Home » RDBMS Server » Performance Tuning » Testing performance of queries (caching)
Testing performance of queries (caching) [message #65433] Mon, 20 September 2004 22:11 Go to next message
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?
Re: Testing performance of queries (caching) [message #65437 is a reply to message #65433] Tue, 21 September 2004 11:55 Go to previous message
Frank Naude
Messages: 4578
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
Previous Topic: Using Loader to load 4GB into a temporary table in RAM
Next Topic: Speeding up this query?
Goto Forum:
  


Current Time: Fri Mar 01 12:15:02 CST 2024