-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Tom Kyte’s following routine is a utility that can be used to to collect statistics of a session at the… READ MORE
There are various methods of displaying execution plan. Here is few of them. 1) Using EXPLAIN PLAN and setting STATEMENT_ID… READ MORE
Statspack can be installed by executing the following script, it will prompt for password for user PERFSTAT, the tablespace for… READ MORE
|
Using QSlice one can monitor CPU usage for individual thread on a windows box. Qslice can be downloaded from the… READ MORE
|
The following article explains global statistics versus histogram with DBMS_STATS http://www.akadia.com/services/ora_gather_statistics.html READ MORE
When using DBMS_STATS to gather table statics Oracle backups up the statistics before overwriting it. The following example shows how… READ MORE
|
Explain plan may not relay the correct execution plan optimizer may run, the following link shows an example Explain Plan… READ MORE
|
Find SQL currently executing in a session: https://oraclespin.wordpress.com/2010/05/09/how-to-find-sql-running-for-a-usersid/ Session running waiting on SYS@TESTDB> SELECT event, state, p1, p2, p3, seconds_in_wait… READ MORE
|
— Buffer hit ratioselect (1-(sum(decode(name, ‘physical reads’, value, 0))/(sum(decode(name, ‘db block gets’, value, 0)) +(sum(decode(name, ‘consistent gets’, value, 0))))))*100 “Buffer… READ MORE
Way of changing retention SQL> select dbms_stats.get_stats_history_retention from dual; GET_STATS_HISTORY_RETENTION ————————— 31 — value passed is in days — If… READ MORE
|
Using dbms_stats.get_stats_history_availability one can find date of oldest STATS information. STATS older than this timestamp cannot be restored. SQL> select… READ MORE
|
Space used by AWR SQL> select occupant_desc, space_usage_kbytes from v$sysaux_occupants where occupant_name like ‘%AWR%’; OCCUPANT_DESC SPACE_USAGE_KBYTES —————————————————————- —————— Server Manageability… READ MORE
|
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this… READ MORE
Link to oradebug – debug utility http://www.evdbt.com/Oradebug_Modrakovic.pdf READ MORE
|
DBA_TAB_MODIFICATIONS view contains tables that were modified since last time statistics was gathered on the table. It contains the number… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 