2005/12/22, Phil Jones <phillipjones@xxxxxxxxx>: > alter system flush buffer_cache; > > in 10g, it can be useful in other circumstances. And on 9i it is something like: alter session set events 'immediate trace name flush_cache'; -- Best regards, Alex Gorbachev -- //www.freelists.org/webpage/oracle-l