OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ADDM report (Oracle 10.2.0.4.0,SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ADDM report [message #550641]

Wed, 11 April 2012 03:54

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

As there was a database performance, we started to analyse the issue by running ADDM using below.

@?/rdbms/admin/addmrpt.sql

.

The result of running ADD is below.

          DETAILED ADDM REPORT FOR TASK 'TASK_64718' WITH ID 64718
          --------------------------------------------------------

              Analysis Period: 10-APR-2012 from 06:00:15 to 07:00:22
         Database ID/Instance: 324353546/1
      Database/Instance Names: JACK/jack1
                    Host Name: fdsfggwe001
             Database Version: 10.2.0.4.0
               Snapshot Range: from 26820 to 26822
                Database Time: 6 seconds
        Average Database Load: 0 active sessions

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

THERE WAS NOT ENOUGH DATABASE TIME FOR ADDM ANALYSIS.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          ADDITIONAL INFORMATION
          ----------------------

There was no significant database activity to run the ADDM.

The database's maintenance windows were active during 100% of the analysis
period.

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.

Note:
-------
Current parameters set in database are below

statistics_level ---- string

timed_statistics --- boolean

1.Do i need to set the initialization parameter to some other value?

2.should i run the below command before executing the ADD report ?

exec dbms_workload_repository.create_snapshot();

Kindly advice .

Regards,

Report message to a moderator

Re: ADDM report [message #550643 is a reply to message #550641]

Wed, 11 April 2012 04:25

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

THERE WAS NOT ENOUGH DATABASE TIME FOR ADDM ANALYSIS.
There was no significant database activity to run the ADDM.

You need to do nothing but some activity on your database.

Regards
Michel

Report message to a moderator

Re: ADDM report [message #550644 is a reply to message #550643]

Wed, 11 April 2012 04:28

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And above all you need to understand what you do:
Quote:

Current parameters set in database are below

statistics_level ---- string

timed_statistics --- boolean

This is completely meaningless and seems to have been posted by someone with an IQ slighty above a tadpole.

Regards
Michel

Report message to a moderator

Re: ADDM report [message #550648 is a reply to message #550644]

Wed, 11 April 2012 05:10

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

This is completely meaningless and seems to have been posted by someone with an IQ slighty above a tadpole.

This is Wrong.

Please give the appropriate answer for my questions.

Quote:

You need to do nothing but some activity on your database.

There was some activity at that time on database.

Report message to a moderator

Re: ADDM report [message #550650 is a reply to message #550648]

Wed, 11 April 2012 05:17

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Jack14 wrote on Wed, 11 April 2012 11:10

Quote:
This is completely meaningless and seems to have been posted by someone with an IQ slighty above a tadpole.

This is Wrong.

Please give the appropriate answer for my questions.

While the tadpole comparsion was frankly unecessary, Michel does have a point that you weren't paying attention to what you posted.
You put the datatype of the parameters. We already know the datatype of the parameters. We need to know what they are actually set to in your DB.

Jack14 wrote on Wed, 11 April 2012 11:10

Quote:
You need to do nothing but some activity on your database.

There was some activity at that time on database.

Define some

Report message to a moderator

Re: ADDM report [message #550651 is a reply to message #550650]

Wed, 11 April 2012 05:29

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

SQL>
SQL> show parameter statistics

NAME                                 TYPE
------------------------------------ --------
VALUE
------------------------------
statistics_level                     string
TYPICAL
timed_os_statistics                  integer
0
timed_statistics                     boolean
TRUE

This is what is set in my database.

Report message to a moderator