‘4. Performance’

Tablespace usage history

Tablespace usage history of 7 days. select thedate, gbsize, prev_gbsize, gbsize-prev_gbsize diff from ( select thedate, gbsize, lag(gbsize,1) over (order by r) prev_gbsize from ( select rownum r, thedate, gbsize from ( select trunc(thedate) thedate, max(gbsize) gbsize from ( select to_date(to_char(snapshot.begin_interval_time,’YYYY-MON-DD HH24:MI:SS’),’YYYY-MON-DD HH24:MI:SS’) thedate, round((usage.tablespace_usedsize*block_size.value)/1024/1024/1024,2) gbsize from dba_hist_tbspc_space_usage usage, v$tablespace tablespace, dba_hist_snapshot snapshot, v$parameter block_size […]

October 22, 2015 · Sanjay · No Comments
Posted in: 1. DB Admin, 4. Performance

Perf: ASH scripts and their usage

Perf: ASH scripts and their usage $ORACLE_HOME/rdbms/admin   ashrpt.sql — Active Session History (ASH) report ashrpti.sql — Active Session History (ASH) report. RAC and Standby Database support added in 2008. ashrptistd.sql — Active Session History (ASH) report helper script for obtaining user input when run on a Standby.

May 28, 2014 · Sanjay · No Comments
Posted in: 1. DB Admin, 3. All Scripts, 4. Performance

Perf: ADDM scripts and their usage

Perf: ADDM scripts and their usage $ORACLE_HOME/rdbms/admin addmrpt.sql — Automatic Database Diagnostic Monitor (ADDM) report addmrpti.sql — Automatic Database Diagnostic Monitor (ADDM) report addmtmig.sql — Post upgrade script to load new ADDM task metadata tables for task migration.

May 28, 2014 · Sanjay · No Comments
Posted in: 1. DB Admin, 3. All Scripts, 4. Performance

Perf: AWR scripts and their usage

 AWR scripts their usage You need execute privileges on package dbms_workload_repository if not logging as user having dba role. $ORACLE_HOME/rdbms/admin or ?/rdbms/admin awrrpt.sql — basic AWR report awrsqrpt.sql — Standard SQL statement Report awrddrpt.sql — Period different on current instance awrrpti.sql — Workload Repository Report Instance (RAC) awrgrpt.sql — AWR Global Report (RAC) awrgdrpt.sql — […]

May 28, 2014 · Sanjay · No Comments
Posted in: 1. DB Admin, 3. All Scripts, 4. Performance