User Sessions Query Locks Uncommitted Transactions

Long Running Sessions - SQL Monitor Run SQL Advisor on SQL ID SQL Plan Baselines SQL Profiles Database Health Check Gather Optimizer Statistics Options Compare Initialization Parameters Query Locks Explain Plan SQL Memory Usage Purge SQL from Shared Pool ADDM Actions DB Config Review Automatic Scheduler Tasks

Automatic Scheduler Tasks

RMAN Backup History RMAN Backup Job Progress RMAN Create Newname Script RMAN Online Backup RMAN Offline Backup RMAN Restore SPFILE RMAN Restore RMAN Restore Standby RMAN Restore Point in Time RMAN Kill Backup RMAN Delete Archivelogs RMAN Clone Example I RMAN Clone Example II

General Scripts Reistate Standby after Failover

Redo Log File Switches

Export/Import Options Export Monitoring

Flashback

Statistics Gathering Options

ASM Monitoring Tablespace Management Segment Advisor Recommendations Segment Metadata

NLS Properties

Troubleshoot

DB Links Reverse Engineer Partitioning Directories Directories for External Tables Public synonynms

Cluster Control Server Control ADRCI EMCTL