OEM 11G Grid Control
I am trying to generate an ADDM report in OEM.
I chose the option of "Run ADDM to analyze past performance" and then I selected "Period Start Time" and "Period End Time" and clicked on the "OK" button. The report is not getting generated. Are there any modification that need to be done in the OEM? Please let me know what all info you need.
my car won't go
tell me how to make my car go.
How do I ask a question on the forums?
what actual clues exist within EM log file?
I went to "AGENT_HOME/sysman/log" there is no log file "emagent.log", there is only one file called "emagent_perl.trc"
when I did "ls -al" the out shows there are total of 17 files.
drwxr-xr-x 2 oracle oinstall 3 Jan 5 2012 .
drwxr-xr-x 13 oracle oinstall 14 Jan 5 2012 ..
-rw-r----- 1 oracle oinstall 4725 Jan 19 2012 emagent_perl.trc
the addmrpt.sql gets stuck too. I enter the "begin_snap" and the "end_snap", after that it just hangs. the addmrpt works fine for other databases, it is only for the production that I am having trouble with.
the following is the output
Specify the Begin and End Snapshot Ids
Enter value for begin_snap: 45827
Begin Snapshot Id specified: 45827
Enter value for end_snap: 45829
End Snapshot Id specified: 45829
Specify the Report Name
The default report file name is addmrpt_2_45827_45829.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: addm_chpprd2
Using the report name addm_chpprd2
Running the ADDM analysis on the specified pair of snapshots ... ---------> (gets stuck at this point)
when I query the v$session_wait, I see the event "gc cr multi block request", but I can't make out how that wait event is related to the ADDMRPT.SQL hanging. Isn't "gc cr multi block request" an indication of "db file scattered read" on a table?
can you please tell me how to run the trace on addmrpt? I will run the trace and will see what output is generated.