Home » RDBMS Server » Server Administration » Re: Flushing the Data Buffer Cache WITHOUT BOUNCING
Re: Flushing the Data Buffer Cache WITHOUT BOUNCING [message #53322] Thu, 12 September 2002 08:04
andrew again
Messages: 2577
Registered: March 2000
Senior Member
I can't see the advantage of forcing a read from disk when your system will never really operate that way. I'd much rather tune the statements by running each variation (several times to ensure consistent results). Anyway - try offlining and then onlining the TS between statements.
alter tablespace x offline;
alter tablespace x online;

Report message to a moderator

Previous Topic: ORA-01092: Oracle instance terminated. Disconnection forced. error
Next Topic: difference sysdate-hiredate = yy-mm-dd.hh:mm:ss
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 12:46:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.