Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Jai Shree Ram Linux/Unix
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • When to rebuld B-tree index Oracle
  • Order by with ROWNUM Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Goldengate Tutorial Oracle
  • Good Site for Oracle Internals Oracle
  • Guide to Linux System Command Mastery Linux/Unix
  • 10g oem configuration Oracle
  • Find_planinfo.sql Oracle
  • plan10g.sql good Oracle
  • Export With Query Another Example. Oracle
  • Changing default shell Linux/Unix
  • catall.sh Linux/Unix
  • Vivek’s egrep commands to trace problem. (on linux x86-64) 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

  • UNderstand and eliminate Latch contention. Oracle
  • Find Time Consuming SQL Statements in Oracle 10g Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • UTL_FILE test program Oracle
  • Implementing Listener Security 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Space padding in korn shell Linux/Unix
  • Search and Replace vi editor command. Linux/Unix
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • V$ROLLSTAT status is Full Oracle
  • myfile Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme