OraFAQ Forum: Performance Tuning » flushing the buffer cache

Home » RDBMS Server » Performance Tuning » flushing the buffer cache

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

flushing the buffer cache [message #198908]

Thu, 19 October 2006 02:18

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

Report message to a moderator

Re: flushing the buffer cache [message #198920 is a reply to message #198908]

Thu, 19 October 2006 03:01

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

Report message to a moderator

Re: flushing the buffer cache [message #198927 is a reply to message #198908]

Thu, 19 October 2006 03:51

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

version is 9.2

Report message to a moderator

Re: flushing the buffer cache [message #198944 is a reply to message #198908]

Thu, 19 October 2006 05:01

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: flushing the buffer cache [message #198948 is a reply to message #198908]

Thu, 19 October 2006 05:13

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Thanks
Reena

Report message to a moderator

Re: flushing the buffer cache [message #203400 is a reply to message #198908]

Wed, 15 November 2006 00:49

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';

Report message to a moderator

Re: flushing the buffer cache [message #203439 is a reply to message #203400]

Wed, 15 November 2006 02:45

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Why would you ever want to do that?

Report message to a moderator

Re: flushing the buffer cache [message #203458 is a reply to message #198908]

Wed, 15 November 2006 03:46

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

Report message to a moderator

Re: flushing the buffer cache [message #203506 is a reply to message #203458]

Wed, 15 November 2006 05:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
OCP 10g. OR 9i ?

Report message to a moderator

Re: flushing the buffer cache [message #203636 is a reply to message #198908]

Wed, 15 November 2006 22:21

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

OR 9i

Report message to a moderator

Re: flushing the buffer cache [message #203640 is a reply to message #203636]

Wed, 15 November 2006 22:35

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.

Report message to a moderator

Re: flushing the buffer cache [message #203713 is a reply to message #198908]

Thu, 16 November 2006 02:08

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

Report message to a moderator

Re: flushing the buffer cache [message #203714 is a reply to message #203713]

Thu, 16 November 2006 02:11

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 18:42:28 CDT 2024