Oracle Database Commands and Practical Examples

AWR - Delete AWR Snapshots ID  Query to display the existing AWR snapshots  period SQL> col BEGIN_INTERVAL_TIME format a28 SQL> col EN...

  Script execution's For non and RAC Database AWR report  Example Below for 2 node RAC . SQL> @d NAME      INSTANCE_NAME    DB_UNIQUE...

  Enabling and Disabling AWR Snapshots Capture enabled when STATISTICS_LEVEL = TYPICAL or ALL disabled when STATISTICS_LEVEL = BASIC  Initia...

Space consumed by AWR snapshots  SQL> @d NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    ...