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?
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
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