Re: FTS waiting on db file sequential reads?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 18 Sep 2014 14:17:47 -0500
Message-ID: <CAP79kiTMAw40ixfyR=3VtESkhHhmEHgzQU_hsyHvY8EaSd1HnA_at_mail.gmail.com>
Yeah, I pulled out the plan using the current plan hash value for the current SQL ID:
Date: Thu, 18 Sep 2014 14:17:47 -0500
Message-ID: <CAP79kiTMAw40ixfyR=3VtESkhHhmEHgzQU_hsyHvY8EaSd1HnA_at_mail.gmail.com>
Yeah, I pulled out the plan using the current plan hash value for the current SQL ID:
select * from table (
dbms_xplan.display_awr('&&SQL_ID',&&plan_hash_value, &&dbid,
'ADVANCED, IOSTATS, ROWS, COST, PARTITION, PARALLEL, PREDICATE, PROJECTION,
ALIAS, REMOTE, NOTE')
);
On Thu, Sep 18, 2014 at 2:12 PM, Jeremy Schneider < jeremy.schneider_at_ardentperf.com> wrote:
> On Thu, Sep 18, 2014 at 3:05 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> Ok, this is a new one to me.
>>
>> Version: 11.2.0.3
>> OS: AIX 6.1 (I think)
>>
>
> maybe obvious, but just checking - you got plan hash 3070881581 from the
> actual running query (v$sql or adding column to snapper output) not an
> explain plan statement, right?
>
> -J
>
> --
> http://about.me/jeremy_schneider
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 18 2014 - 21:17:47 CEST