OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Buffer Cache (Oracle 9.2.x.x, Unix)

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

Buffer Cache [message #280423]

Tue, 13 November 2007 08:42

balajisundar
Messages: 29
Registered: October 2007

Junior Member

Hi,

Can any body please let me know the command to clear the buffer cache in oracle 9.2x version? im testing my code for performance issue,It would be of great help if some body can give me the command or a link which takes me clear understanding.

Thanks,
Balaji

Report message to a moderator

Re: Buffer Cache [message #280425 is a reply to message #280423]

Tue, 13 November 2007 08:43

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

shutdown

Regards
Michel

Report message to a moderator

Re: Buffer Cache [message #280428 is a reply to message #280423]

Tue, 13 November 2007 09:02

balajisundar
Messages: 29
Registered: October 2007

Junior Member

Hi

I would have definitely done that if I'm in a position to do that. I don't have privilege for that.

Regards,
Balaji

Report message to a moderator

Re: Buffer Cache [message #280433 is a reply to message #280428]

Tue, 13 November 2007 09:46

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no other way in 9i.

By the way, if you have not the privilege to shut down the database, I doubt you would have the one to flush the buffer cache.

Regards
Michel

Report message to a moderator

Re: Buffer Cache [message #280436 is a reply to message #280433]

Tue, 13 November 2007 09:50

balajisundar
Messages: 29
Registered: October 2007

Junior Member

Hi,

Thank you so much.

Regards,
Balaji

Report message to a moderator

Previous Topic:	SQL Tunning
Next Topic:	Pls. help Tune this query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 13:41:32 CDT 2024