Collect History

[Former Member]

Hi All,

How to collect DB time history and wait event history date wise. Kindly help.

Thn

MS

[fidel_vales]

hi,

AWR does that automatically. But you need the diagnostic pack license.

If you do not have it then you can use statspack but there is not much information on the Oracle 11g docuementation as that focus on AWR, but you can check SAP Note 717484.

But you really should improve your questions.

[Former Member]

Hi Fidel,

How we generate the below report.

[Former Member]

This is db time history.

[fidel_vales]

Hi,

First, I strongly recommend that you read the oracle documentation, in this case the Oracle Database Performance Tuning Guide because generating a graph that you do not understand is useless.

That graph is generated with an SAP tool called RSORASTT. It can be found in an SAP Note (That I assume you can find alone) and it is not documented or supported by SAP (it is provided as is, it might work or not)