Home » RDBMS Server » Performance Tuning » Buffer Cache (Oracle 9.2.x.x, Unix)
Buffer Cache [message #280423] Tue, 13 November 2007 08:42 Go to next message
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
Re: Buffer Cache [message #280425 is a reply to message #280423] Tue, 13 November 2007 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shutdown

Regards
Michel
Re: Buffer Cache [message #280428 is a reply to message #280423] Tue, 13 November 2007 09:02 Go to previous messageGo to next message
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
Re: Buffer Cache [message #280433 is a reply to message #280428] Tue, 13 November 2007 09:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Buffer Cache [message #280436 is a reply to message #280433] Tue, 13 November 2007 09:50 Go to previous message
balajisundar
Messages: 29
Registered: October 2007
Junior Member
Hi,

Thank you so much.

Regards,
Balaji
Previous Topic: SQL Tunning
Next Topic: Pls. help Tune this query
Goto Forum:
  


Current Time: Sat Dec 03 01:03:54 CST 2016

Total time taken to generate the page: 0.26279 seconds