AWR Report for Standard Edition?
AWR for Standard Edition I was assigned to collect some performance data in an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under… Read More »AWR Report for Standard Edition?
Statspack
How to Resolve ORA-23421: job number is not a job in the job queue
ORA-23421 When I tried to remove a given job from the queue, the statement failed with ORA-23421, and ORA-06512 are also in the error stack.… Read More »How to Resolve ORA-23421: job number is not a job in the job queue
How to Resolve ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
STATSPACK ORA-00001 Login as PERFSTAT and took a snapshot like the following statement. But it failed with ORA-00001. SQL> exec statspack.snap(i_snap_level=>5); BEGIN statspack.snap(i_snap_level=>5); END; *… Read More »How to Resolve ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated
How to Fix Broken Statspack Snapshot Jobs
Broken STATSPACK After we create and initiate STATSPACK in Oracle database, we sometimes might see a broken STATSPACK snapshot job stopped working for several days.… Read More »How to Fix Broken Statspack Snapshot Jobs
How to Find Top IO on Data Files
In my case, I was planning to move some hot data files to a new mount point with SSD disks underneath, so I have to… Read More »How to Find Top IO on Data Files
When RMAN met Resource Manager
Users notified DBA that they found AP responded longer than normal starting from 22:00 everyday, especially when a period of running RMAN on the host,… Read More »When RMAN met Resource Manager