OraFAQ Forum: Performance Tuning » Testing performance of queries (caching)

Home » RDBMS Server » Performance Tuning » Testing performance of queries (caching)

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

Testing performance of queries (caching) [message #65433]

Mon, 20 September 2004 22:11

andy
Messages: 92
Registered: December 1999

Member

Hi,

I would like to compare the performance of 2 queries (namely how long it takes to query large sets of data). Now, when I run the first query, it takes a considerable amount of time to run, but subsequent runs will be instantaneous. I believe this is due to the db caching the results. Then when I run the second query, it would be fast as well.

How do yo test performance when the db uses caching?

Report message to a moderator

Re: Testing performance of queries (caching) [message #65437 is a reply to message #65433]

Tue, 21 September 2004 11:55

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

From Oracle 10g, one can flush the DB Cache. Example:

SQL> ALTER SYSTEM FLUSH BUFFER_CACHE; 
 
System altered.

Best regards.

Frank

Report message to a moderator

Previous Topic:	Using Loader to load 4GB into a temporary table in RAM
Next Topic:	Speeding up this query?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 02:37:44 CDT 2024