Re: Inconsistent SQL tuning results
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: breitliw@xxxxxxxxxxxxx
- Date: Mon, 7 Feb 2011 12:45:36 -0600
Without doing any measurements, those results sound very consistent with
data that is not cached on the first run, and is cached on successive runs.
But, as has been noted, you will need to do tracing to verify that.
On Mon, Feb 7, 2011 at 12:35 PM, Wolfgang Breitling
<breitliw@xxxxxxxxxxxxx>wrote:
> 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.
>>
>>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
