OraFAQ Forum: Performance Tuning » TKprof generation for short duration

Home » RDBMS Server » Performance Tuning » TKprof generation for short duration (10.2.0.1, linux-4.5)

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

TKprof generation for short duration [message #570148]

Mon, 05 November 2012 23:30

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

Report message to a moderator

Re: TKprof generation for short duration [message #570151 is a reply to message #570148]

Mon, 05 November 2012 23:53

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

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

Report message to a moderator

Re: TKprof generation for short duration [message #570153 is a reply to message #570151]

Tue, 06 November 2012 00:12

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...

Report message to a moderator

Re: TKprof generation for short duration [message #570156 is a reply to message #570153]

Tue, 06 November 2012 01:15

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

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

Report message to a moderator

Re: TKprof generation for short duration [message #570161 is a reply to message #570156]

Tue, 06 November 2012 02:32

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

Report message to a moderator

Re: TKprof generation for short duration [message #570163 is a reply to message #570161]

Tue, 06 November 2012 02:42

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

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

Report message to a moderator

Re: TKprof generation for short duration [message #570197 is a reply to message #570161]

Tue, 06 November 2012 12:25

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?

Report message to a moderator

Re: TKprof generation for short duration [message #571356 is a reply to message #570197]

Sat, 24 November 2012 05:58

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.

Report message to a moderator

Previous Topic:	Inner join query tuning
Next Topic:	How to capture the problem with some sql timeout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 12:10:26 CST 2024