Home » RDBMS Server » Performance Tuning » ADDM report (Oracle 10.2.0.4.0,SunOS)
ADDM report [message #550641] Wed, 11 April 2012 03:54 Go to next message
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,
Re: ADDM report [message #550643 is a reply to message #550641] Wed, 11 April 2012 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: ADDM report [message #550644 is a reply to message #550643] Wed, 11 April 2012 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ADDM report [message #550648 is a reply to message #550644] Wed, 11 April 2012 05:10 Go to previous messageGo to next message
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.
Re: ADDM report [message #550650 is a reply to message #550648] Wed, 11 April 2012 05:17 Go to previous messageGo to next message
cookiemonster
Messages: 11285
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
Re: ADDM report [message #550651 is a reply to message #550650] Wed, 11 April 2012 05:29 Go to previous messageGo to next message
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.
Re: ADDM report [message #550656 is a reply to message #550648] Wed, 11 April 2012 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
There was some activity at that time on database.


This is not what Oracle notes.
So who tells the truth? Guess which one I will trust.

Regards
Michel
Re: ADDM report [message #550658 is a reply to message #550650] Wed, 11 April 2012 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
While the tadpole comparsion was frankly unecessary


Sure, but what do you expect from a froggy? Smile

Regards
Michel
Re: ADDM report [message #550666 is a reply to message #550658] Wed, 11 April 2012 07:01 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Smile

sorry , i just now saw that statistics parameter is set to TYPICAL.

But why i am seeing such output in ADDM report.

Can you please explain ?
Re: ADDM report [message #550670 is a reply to message #550666] Wed, 11 April 2012 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because there was no activity on the database.

Regards
Michel
Re: ADDM report [message #551104 is a reply to message #550670] Sun, 15 April 2012 12:01 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Michel for your answer
Previous Topic: loop questions
Next Topic: DB performance keys
Goto Forum:
  


Current Time: Thu Dec 18 21:41:57 CST 2014

Total time taken to generate the page: 6.22173 seconds