How to generate awr snapshot manually other than default snapshots in oracle

This document describes how to create or generate AWR snapshot in between default generated snapshots in oracle.

Normally by default AWR snapshot generates every 60 minutes. We need AWR snapshots to create AWR report to analyse when we have performance issues in database.

Below is the procedure to generate snapshot manually at any time interval.

Connect to database as sysdba and find the snapshot history.

[oracle@server1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 9 18:40:51 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> select snap_id,instance_number,end_interval_time from dba_hist_snapshot;

   SNAP_ID    INSTANCE_NUMBER   END_INTERVAL_TIME
     ----------            ---------------                 ------------------------------
10            1                              09-OCT-18 05.43.50.566 PM
11            1                              09-OCT-18 06.30.58.809 PM

SQL>

Generate  AWR snapshot manually using dbms_workload_repository.

SQL> execute dbms_workload_repository.create_snapshot();

PL/SQL procedure successfully completed.

SQL>

SQL> select snap_id,instance_number,end_interval_time from dba_hist_snapshot;

   SNAP_ID           INSTANCE_NUMBER       END_INTERVAL_TIME
    ----------              ---------------                         ------------------------------
12              1                                  09-OCT-18 06.51.22.192 PM
10              1                                  09-OCT-18 05.43.50.566 PM
11              1                                  09-OCT-18 06.30.58.809 PM






Thanks for your patience to view this post.....