OraFAQ Forum: Performance Tuning » how to clear cache for testing tuned code

Home » RDBMS Server » Performance Tuning » how to clear cache for testing tuned code (oracle 11g r2)

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

how to clear cache for testing tuned code [message #514335]

Mon, 04 July 2011 02:28

gogol_1987
Messages: 12
Registered: March 2011
Location: kolkata

Junior Member

hi gems..

i am testing a proc after tuning it but the problem is, it is taking a very very less time which it shouldnt. I know that it is because of the buffer cache and the shared pool. that why i need to clean the cache to retest it.

I cannot bouce the database as other schemas are part of it. so is there any way to clean the cache for that particular schema i.e bouncing any particular schema(i know that the term is not appropreate)...

pls help

Report message to a moderator

Re: how to clear cache for testing tuned code [message #514339 is a reply to message #514335]

Mon, 04 July 2011 02:31

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

so is there any way to clean the cache for that particular schema

No.
You can onky flush the cache for all.

By the way, flushing the cache is not the good way to tune a system. The only you get is invalid performances indicator.

Regards
Michel

Report message to a moderator

Re: how to clear cache for testing tuned code [message #514343 is a reply to message #514339]

Mon, 04 July 2011 03:05

gogol_1987
Messages: 12
Registered: March 2011
Location: kolkata

Junior Member

actually the proc has taken 782 secs to execute and after the second run it has taken only 62 seconds and i know that it shouldnot take such a small time.

so i need to know the time taken by the proc to hit the database and fetch the resultset to me. how can i achieve this??

Report message to a moderator

Re: how to clear cache for testing tuned code [message #514345 is a reply to message #514343]

Mon, 04 July 2011 03:34

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Depends.

Is it frequently called, or (basically) a one off batch type run?

If frequently called, you shouldn't be flushing. If one off style runs, there is an argument for doing so.

Report message to a moderator

Re: how to clear cache for testing tuned code [message #514354 is a reply to message #514345]

Mon, 04 July 2011 04:25

gogol_1987
Messages: 12
Registered: March 2011
Location: kolkata

Junior Member

no sir...it will not be frequently called...the proc is executed for calculating the backdated datas and thats why it will be called very less...

Report message to a moderator

Previous Topic:	Performance Tuning in Oracle 10g during Migration - Heavy Insert Optimization
Next Topic:	problem with outlines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:03:21 CDT 2024