Home » RDBMS Server » Performance Tuning » TKprof generation for short duration (10.2.0.1, linux-4.5)
TKprof generation for short duration [message #570148] Mon, 05 November 2012 23:30 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Is it possible to generate AWR report for the duration of 5 min? As we know that snapshots are generated for every 1 hour, which we specified in parameter.

By changing the parameter to 2 min, what could be the impact on database?

Regards,
Ishika
Re: TKprof generation for short duration [message #570151 is a reply to message #570148] Mon, 05 November 2012 23:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
By changing the parameter to 2 min, what could be the impact on database?


Performances impact non negligible.
In fact, you will see in AWR report that AWR takes almost all the resources.

Use ASH for this.

Regards
Michel
Re: TKprof generation for short duration [message #570153 is a reply to message #570151] Tue, 06 November 2012 00:12 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Thanks for your feedback.
We are using ASH report for this type of requirement. I just want to know that, whether we can able to take it or not?
I know that, we can take AWR for 10-15 mins also but not sure about 2 min.

waiting for your reply...
Re: TKprof generation for short duration [message #570156 is a reply to message #570153] Tue, 06 November 2012 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
We are using ASH report for this type of requirement. I just want to know that, whether we can able to take it or not?


I don't understand, if you use it then you are able to "take" (whatever this means) it.

Regards
Michel
Re: TKprof generation for short duration [message #570161 is a reply to message #570156] Tue, 06 November 2012 02:32 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

You are absolutely correct. Generating AWR report of only 2 min is useless. I just want to know, whether it is possible to generate or not?

Ishika
Re: TKprof generation for short duration [message #570163 is a reply to message #570161] Tue, 06 November 2012 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes it is possible, just try it.
Is it useful or wise or...? It is not your question, is it?

Regards
Michel
Re: TKprof generation for short duration [message #570197 is a reply to message #570161] Tue, 06 November 2012 12:25 Go to previous messageGo to next message
LNossov
Messages: 318
Registered: July 2011
Location: Germany
Senior Member
PACKAGE dbms_workload_repository AS

  -- ************************************ --
  --  DBMS_WORKLOAD_REPOSITORY Constants
  -- ************************************ --

  -- Minimum and Maximum values for the
  -- Snapshot Interval Setting (in minutes)
  MIN_INTERVAL    CONSTANT NUMBER := 10;                       /* 10 minutes */


Do you want to reparse the package dbms_workload_repository for that???

What kind of performance issues do you have?
Re: TKprof generation for short duration [message #571356 is a reply to message #570197] Sat, 24 November 2012 05:58 Go to previous message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear LNossov,

Thank you very much. I came to know that AWR min duration can be upto 10 mins.
Previous Topic: Inner join query tuning
Next Topic: How to capture the problem with some sql timeout
Goto Forum:
  


Current Time: Fri Mar 29 06:27:14 CDT 2024