| Error running ADDM report for particular snapshots [message #399315] |
Tue, 21 April 2009 10:32  |
zaff
Messages: 50
Registered: July 2008
|
Member |
|
|
Hi guys,
I'm trying to run a ADDM report for a defined time period:
Instance DB Name Snap Id Snap Started Snap Level
6329 20 Apr 2009 22:00 1
6330 20 Apr 2009 22:10 1
6331 20 Apr 2009 22:20 1
6332 20 Apr 2009 22:30 1
6334 20 Apr 2009 22:50 1
6335 20 Apr 2009 23:00 1
6336 20 Apr 2009 23:10 1
6337 20 Apr 2009 23:20 1
6338 20 Apr 2009 23:30 1
6339 20 Apr 2009 23:40 1
6340 20 Apr 2009 23:50 1
6341 21 Apr 2009 00:00 1
6342 21 Apr 2009 00:10 1
6343 21 Apr 2009 00:20 1
I need a report from snapshotID 6329 to 6343. However, after select the required snapshots I get the following error:
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 6329
Begin Snapshot Id specified: 6329
Enter value for end_snap: 6343
End Snapshot Id specified: 6343
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_6329_6343.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name addmrpt_1_6329_6343.txt
Running the ADDM analysis on the specified pair of snapshots ...
begin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01426: numeric overflow
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 27
Any ideas what is causing this error?
Thanks,
Zaff
|
|
|
|
|
|
| Re: Error running ADDM report for particular snapshots [message #399318 is a reply to message #399315] |
Tue, 21 April 2009 10:47  |
zaff
Messages: 50
Registered: July 2008
|
Member |
|
|
Thanks for the prompt reply BlackSwan.
I still get an error when reducing the number of snapshots:
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 6329
Begin Snapshot Id specified: 6329
Enter value for end_snap: 6331
End Snapshot Id specified: 6331
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_6329_6331.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name addmrpt_1_6329_6331.txt
Running the ADDM analysis on the specified pair of snapshots ...
begin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01426: numeric overflow
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 27
Generating the ADDM report for this analysis ...
ERROR:
ORA-13608: The task or object name NULL is invalid.
ORA-06512: at "SYS.PRVT_ADVISOR", line 2043
ORA-06512: at "SYS.DBMS_ADVISOR", line 560
ORA-06512: at line 1
End of Report
Report written to addmrpt_1_6329_6331.txt
SQL>
Thanks,
Zaff
|
|
|
|
|
|
| Re: Error running ADDM report for particular snapshots [message #399326 is a reply to message #399315] |
Tue, 21 April 2009 11:05 |
zaff
Messages: 50
Registered: July 2008
|
Member |
|
|
here you go:
OS/SERVER: 5.9 Generic_118558-34 sun4u sparc SUNW,Sun-Fire-V490
DATABASE: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit
Just to provide a little background, we're using this db as part of application v&p testing. I'm not sure if a high data load would impact ADDM snapshots.
Thanks,
Zaff
|
|
|
|
|
|
| Re: Error running ADDM report for particular snapshots [message #399328 is a reply to message #399315] |
Tue, 21 April 2009 11:13 |
zaff
Messages: 50
Registered: July 2008
|
Member |
|
|
yes. Usually, report generation is not a problem:
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 6341
Begin Snapshot Id specified: 6341
Enter value for end_snap: 6343
End Snapshot Id specified: 6343
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_1_6341_6343.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name:
Using the report name addmrpt_1_6341_6343.txt
Running the ADDM analysis on the specified pair of snapshots ...
Generating the ADDM report for this analysis ...
DETAILED ADDM REPORT FOR TASK 'TASK_19719' WITH ID 19719
--------------------------------------------------------
Analysis Period: 21-APR-2009 from 00:00:21 to 00:20:25
Database ID/Instance: 4268186125/1
Database/Instance Names: MVF/MVF
Host Name: sun490n001
Database Version: 10.2.0.2.0
Snapshot Range: from 6341 to 6343
Database Time: 278 seconds
Average Database Load: ,2 active sessions
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
THERE WAS NOT ENOUGH DATABASE TIME FOR ADDM ANALYSIS.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ADDITIONAL INFORMATION
----------------------
There was no significant database activity to run the ADDM.
The analysis of I/O performance is based on the default assumption that the
average read time for one database block is 10000 micro-seconds.
An explanation of the terminology used in this report is available when you
run the report with the 'ALL' level of detail.
End of Report
Report written to addmrpt_1_6341_6343.txt
SQL>
Thanks,
Zaff
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
