Re: Inconsistent SQL tuning results

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Mon, 7 Feb 2011 11:35:07 -0700
Message-Id: <1A533B44-E12E-4278-8742-8A82FDBD69B1_at_centrexcc.com>

Still, if they gave you the means to flush the pools at any time you like, giving you some means of starting a trace should not require an act of congress.

On 2011-02-07, at 11:18 AM, Michael Moore wrote:

> I don't really have ALTER SYSTEM. The DBAs created a procedure with
> alter system flush shared_pool;
> alter system flush buffer_cache;
>
> and then gave me execute on that procedure. Believe me, if it was easy, I would have done it. ;-) lol.
>
>
> On Mon, Feb 7, 2011 at 10:15 AM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> If you have the privilege to execute "alter system ... " commands, the privilege to start a trace should be child's play.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 07 2011 - 12:35:07 CST