Home » RDBMS Server » Performance Tuning » flushing the buffer cache
flushing the buffer cache [message #198908] Thu, 19 October 2006 02:18 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

Can anyone tell how can we flush the database buffer cache without stopping the instance??


Thanks
Reena
Re: flushing the buffer cache [message #198920 is a reply to message #198908] Thu, 19 October 2006 03:01 Go to previous messageGo to next message
readytestgo
Messages: 5
Registered: October 2006
Location: Chennai
Junior Member
What is version of oracle that u r using?


RTGPerf,
http://groups.google.com/group/database-tuning
Re: flushing the buffer cache [message #198927 is a reply to message #198908] Thu, 19 October 2006 03:51 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
version is 9.2
Re: flushing the buffer cache [message #198944 is a reply to message #198908] Thu, 19 October 2006 05:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
As usual, once again,
search before posting Smile
http://www.orafaq.com/forum/m/165818/42800/?srch=flush_cache#msg_165818
Re: flushing the buffer cache [message #198948 is a reply to message #198908] Thu, 19 October 2006 05:13 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Thanks
Reena
Re: flushing the buffer cache [message #203400 is a reply to message #198908] Wed, 15 November 2006 00:49 Go to previous messageGo to next message
xuhai
Messages: 2
Registered: November 2006
Junior Member
In oracle 10g,you can flush buffer pool use alter system flush buffer pool.
In 9i ,you can use alter session set events 'immediate trace name flush_cache';
Re: flushing the buffer cache [message #203439 is a reply to message #203400] Wed, 15 November 2006 02:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why would you ever want to do that?
Re: flushing the buffer cache [message #203458 is a reply to message #198908] Wed, 15 November 2006 03:46 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Oh.. just practicing stuff.. I am preparing for my OCP exams. So, doing some practical sessions and checking different If-Then scenarios. It would help me in better understanding of the subject.

Thanks
Reena
Re: flushing the buffer cache [message #203506 is a reply to message #203458] Wed, 15 November 2006 05:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
OCP 10g. OR 9i ?
Re: flushing the buffer cache [message #203636 is a reply to message #198908] Wed, 15 November 2006 22:21 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
OR 9i
Re: flushing the buffer cache [message #203640 is a reply to message #203636] Wed, 15 November 2006 22:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi reena

i done OCP 9i. so you hv any question regarding OCP 9i you can ask.

and how are you preparing for OCP 9i.


regards
taj.



Re: flushing the buffer cache [message #203713 is a reply to message #198908] Thu, 16 November 2006 02:08 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
That is great!! I am preparing from study notes from BPB publications , oracle documentation, and refering to some good stuff in sites...And ofcourse orafaq forum. What is your personal email id?

Thanks
Reena
Re: flushing the buffer cache [message #203714 is a reply to message #203713] Thu, 16 November 2006 02:11 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi reena

1. mail_id > "star_taj/yahoo.com"



regards
Taj.
http://dbataj.blogspot.com

[Updated on: Thu, 16 November 2006 06:07]

Report message to a moderator

Previous Topic: Interpret STATSPack Report
Next Topic: check last statement executed
Goto Forum:
  


Current Time: Wed Dec 07 22:02:17 CST 2016

Total time taken to generate the page: 0.09101 seconds