Home » RDBMS Server » Server Administration » Error running ADDM report for particular snapshots (Oracle 10g)
Error running ADDM report for particular snapshots [message #399315] Tue, 21 April 2009 10:32 Go to next message
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 #399317 is a reply to message #399315] Tue, 21 April 2009 10:41 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+ORA-01426:+numeric+overflow

Some number is too big.
Reduce the range by half & run 2 reports
Re: Error running ADDM report for particular snapshots [message #399318 is a reply to message #399315] Tue, 21 April 2009 10:47 Go to previous messageGo to next message
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 #399322 is a reply to message #399315] Tue, 21 April 2009 10:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
This almost smells to me like a bug.
This has always worked for me & GOOGLE give no clue as to others having this happen.


Post Operating System (OS) name & version for DB server system.
Post Oracle version to 4 decimal place of database s/w.


Re: Error running ADDM report for particular snapshots [message #399326 is a reply to message #399315] Tue, 21 April 2009 11:05 Go to previous messageGo to next message
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 #399327 is a reply to message #399315] Tue, 21 April 2009 11:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Can you successfully generate a report for any single period?
Re: Error running ADDM report for particular snapshots [message #399328 is a reply to message #399315] Tue, 21 April 2009 11:13 Go to previous message
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
Previous Topic: standby issue
Next Topic: How to enable the table level supplemental logging
Goto Forum:
  


Current Time: Thu Dec 08 14:07:48 CST 2016

Total time taken to generate the page: 0.17496 seconds