| Statement Performance - SGA Cache [message #155700] |
Wed, 18 January 2006 01:19  |
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
|
Member |
|
|
Hi,
i would like to test how fast is a statement. I'm guessing, that the statement remain in the "Database Buffer Cache" after the execution , because if i'm testing it a second time, it's pretty fast.
How could i disable this functionality for testing purposes? Or is it possible to delete the content of the "Database Buffer Cache"?
-----
Oracle: 9.2.0.1
OS: Win XP Pro
|
|
|
|
| Re: Statement Performance - SGA Cache [message #155727 is a reply to message #155700] |
Wed, 18 January 2006 03:36  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
I think for your purpose DB_RECYCLE_CACHE_SIZE parameter can be used.
And you cant clear buffer cache in 9i. Had it been 10g then it would have been possible with the command.
Alter system flush buffer_cache;
|
|
|
|
| Re: Statement Performance - SGA Cache [message #155730 is a reply to message #155700] |
Wed, 18 January 2006 03:53 |
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
|
Member |
|
|
Hi,
if i' using:
it shows me:
db_cache_advice string ON
db_cache_size big integer 25165824
db_recycle_cache_size big integer 0
What does that mean? Isn't the db_cache_size the correct parameter? But i don't want to restart the DB just to do a quick testing...
Any other idea?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
