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?
DBMS_JOB.REMOVE
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