-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Below are the 2 SQL statements, the first one uses the index AAA_IDX and then second one does a full… READ MORE
Using $ORACLE_HOME/rdbms/admin/awrsqrpt.sql one can generate execution plan from AWR by passing start snap id, end snap id and SQL ID.… READ MORE
One can automate taking of snapshots of STATSPACK by executing DBMS_JOB or by scheduling it through crontab. Schedule automatic STATSPACK… READ MORE
One can truncate data in STATSPACK or delete range of snaps stored. To truncate STATSPACK data Using $ORACLE_HOME/rdbms/admin/sptrunc.sql, one can… READ MORE
When passing method_opt as 'FOR ALL COLUMNS SIZE 1', it means no histogram is collected for columns on the table(s).… READ MORE
|
— The following anonymous PL/SQL code can be used to generate a script which can be run to generate AWR… READ MORE
See the oldest statistics history available SQL> SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY FROM DUAL; GET_STATS_HISTORY_AVAILABILITY ————————————————————————— 25-OCT-11 10.00.55.093000000 PM -07:00 See the stats… READ MORE
Shows in this scenrio there are backup of stats that exists for SCOTT.TEST table SQL> select * FROM DBA_TAB_STATS_HISTORY where… READ MORE
To view output from 10053 using the following link one can download software which allows one to review the output… READ MORE
On AIX – nmon on AIX can be used to monitoring a machine (CPU, Memory, Network traffic, I/O, top processes,… READ MORE
The following article by Cary Milsap talks about “Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok” by… READ MORE
|
To create a baseline of performance of the system, one create a baseline and used for later comparisons. If a… READ MORE
-- drop snapshot, it will not generate an error if the snap id is out of range SQL> EXEC dbms_workload_repository.drop_snapshot_range(low_snap_id=>1,… READ MORE
|
-- Shows SQL statements currently in shared pool with high physical I/O, it sorts by the high I/O first SELECT… READ MORE
declare task_id number; name varchar2(100); descr varchar2(100); obj_id number; -- get the min and max snap id from AWR CURSOR… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 