Re: Inconsistent SQL tuning results
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Michael Moore <michaeljmoore@xxxxxxxxx>
- Date: Mon, 7 Feb 2011 11:35:07 -0700
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@xxxxxxxxxxxxx>
> wrote:
> If you have the privilege to execute "alter system ... " commands, the
> privilege to start a trace should be child's play.
>
Other related posts:
