| AWR reports snapshots is not generating [message #646430] |
Wed, 30 December 2015 06:14  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
Due to space issues, at night, database got hanged. Morning, we checked and made available spaces for archivelog. Database is up and running well but awr snapshots are not generating. Manually, i ave created it at the same interval of time.
Please let me know, whether this creation will help to generate snapshots at regular frequent interval of time?
Or, should I need to modify any other parameter?
Below are the parameter -
SQL> sho parameter statistics
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_use_pending_statistics boolean FALSE
statistics_level string TYPICAL
timed_os_statistics integer 0
timed_statistics boolean TRUE
Please guide ...
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
|
|
| Re: AWR reports snapshots is not generating [message #647460 is a reply to message #646435] |
Thu, 28 January 2016 16:38  |
 |
scapy
Messages: 12
Registered: November 2015
Location: Portugal
|
Junior Member |
|
|
Hi Ashish,
Is a bug in that version, you have to apply a psu to last version,i dont remember the mos note.
Other option is try to kill the mmon process, and after that, it restart.
Hope this help you.
Cumps
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
