Some useful awr queries, change according your needs. Top 10 queries by resource usage across all executions SELECT * FROM (SELECT SQL_ID, SUM(disk_reads_delta) AS “Disk Reads” FROM DBA_HIST_SQLSTAT S WHERE SNAP_ID > 209 AND SNAP_ID <= 210 AND S.MODULE = ‘ClaimCenter’ GROUP BY SQL_ID HAVING SUM(disk_reads_delta) >= 0 ORDER BY 2 DESC) DERIVED_TABLE WHERE ROWNUM ...
Parallel in standalone Databases The parallel options invoke multiple processes to utilize spare system resources to reduce the time required to complete tasks or jobs. The parallel options do not reduce the amount of resources required by the processing; rather, they spread the processing burden across multiple CPUs. In order to get the most benefit ...
(From my old blog, very popular !) A very trivial procedure to do this: # José Valerio – April, 2007 # Before: Stop cluster database # 1. Mount your cluster DB in the node where you # will perform the backup. # 2. Modify backup and format destinations (show channel) # 3. Connect RMAN (nocatalog ...