Re: SELECT on ASSM tablespace
From: ddf <oratune_at_msn.com>
Date: Tue, 8 Sep 2009 07:40:57 -0700 (PDT)
Message-ID: <4d1ae136-fc3a-4212-aa96-0e8ca5ecac63_at_o9g2000yqj.googlegroups.com>
On Sep 7, 8:38 pm, lsllcm <lsl..._at_gmail.com> wrote:
> Hi All,
>
> I do one test on consistent read about SELECT on ASSM tablespace
>
> --SELECT FROM TABLE in ASSM tablespace
> from 10046 trace file, there is no read operation to read PAGETABLE
> SEGMENT HEADER/Second LEVEL BITMAP BLOCK/FIRST LEVEL BITMAP BLOCK
>
> Is that right?
>
> Thanks
> Jacky
Date: Tue, 8 Sep 2009 07:40:57 -0700 (PDT)
Message-ID: <4d1ae136-fc3a-4212-aa96-0e8ca5ecac63_at_o9g2000yqj.googlegroups.com>
On Sep 7, 8:38 pm, lsllcm <lsl..._at_gmail.com> wrote:
> Hi All,
>
> I do one test on consistent read about SELECT on ASSM tablespace
>
> --SELECT FROM TABLE in ASSM tablespace
> from 10046 trace file, there is no read operation to read PAGETABLE
> SEGMENT HEADER/Second LEVEL BITMAP BLOCK/FIRST LEVEL BITMAP BLOCK
>
> Is that right?
>
> Thanks
> Jacky
Yes, which does not mean those events don't occur. Event 10046 does not, to my knowledge, report them.
David Fitzjarrell Received on Tue Sep 08 2009 - 09:40:57 CDT