In my previous post, Registering the Oracle Database with the listener, I mentioned the role of the initialization parm LOCAL_LISTENER…
In this short post i want to talk about same notable changes beginning with 12.1.0.2. Enterprise Edition is now a…
prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY LOW PARALLEL 8; SQL> ALTER TABLE MOVE PARTITION COMPRESS FOR QUERY HIGH…
The basic idea behind the Exadata Hybrid Columnar Compression (hereby referred as EHCC) is to reprise the benefits of column…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
http://www.oracle-developer.net/display.php?id=206
Summary I recently investigated an IO performance “spike” on a large 11.2.0.3 transactional system and I thought I would cover some…