Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • V$transaction notes for finding XID composition. Oracle
  • Check Oracle installed products using one command Oracle
  • Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • Difference between SYNC and AFFIRM Oracle
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Index Range Scan Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • rm_backup_arch_file.ksh Linux/Unix
  • create a folder in multiple places Linux/Unix
  • get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
  • SQL_PROFILE – I explaination Oracle
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • how to find OS block size Oracle
  • .profile Linux/Unix

AWR settings- MMON is not taking snapshot.

Posted on 07-Nov-2005 By Admin No Comments on AWR settings- MMON is not taking snapshot.

POTENTIAL SOLUTION(S) for AWR Snapshot Error

============================================

(*) To take the snapshots we need to populate WRM$_SNAPSHOT table successfully and for that instance metadata should be present in WRM$_DATABASE_INSTANCE.

(*) To regenerate the AWR objects run catnoawr.sql and catawr.sql scripts from $ORACLE_HOME/rdbms/admin

(*) Then RESTART the database

So, if we have regenerated the AWR objects by running catnoawr.sql and catawr.sql, then we need to bounce the database. On restart of the database instance the WRM$_DATABASE_INSTANCE & Other internal objects will be populated with the required data. Then we can take manual snapshots and also MMON process will start collecting the snapshots.

Remember: If we are inserting manually into WRP$_DATABASE_INSTANCE, we are getting some errors while executing $ORACLE_HOME/rdbms/admin/awrrpt.

When we rename instance oracle still keeps the old hostname and old database information in WRM$_DATABASE_INSTANCE, so MMON might not be able to generate snapshot at specific interval. So its always needed to drop and re-generate AWR Objects when we are renaming database and instance name.

*) Then try generating the snapshots manually for testing purpose.

SQL> BEGIN

2 DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(‘TYPICAL’);

3 END;

4 /

POTENTIAL SOLUTION JUSTIFICATION(S)

==================================

Note 308003.1 AWR Snapshots Not Generating

Oracle, SQL scripts

Post navigation

Previous Post: Changing the Global Database Name
Next Post: Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1

Related Posts

  • cur_sql.sql Oracle
  • Physical Standby switchover with session active Oracle
  • DB Console Mainenance. Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • My Minimum Tuning Programs Oracle
  • column level grant syntax Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • restarting network in linux Linux/Unix
  • Good notes on Oracle Events Oracle
  • Removing first line Linux/Unix
  • Jai Shree Ram Oracle
  • To Find Orphan OS processes. Linux/Unix
  • telnet listening Linux/Unix
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme