Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10053 trace for sql fired from pl/sql (stored code)

Re: 10053 trace for sql fired from pl/sql (stored code)

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: 2005-12-23 20:17:44
Message-id: c2213f680512231117m3641ea33t@mail.gmail.com


2005/12/22, Phil Jones :
> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 23 2005 - 20:17:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US