SELECT on ASSM tablespace
From: lsllcm <lsllcm_at_gmail.com>
Date: Mon, 7 Sep 2009 18:38:26 -0700 (PDT)
Message-ID: <3e167bbe-0d3a-4c1f-a537-c58cb1c3975b_at_v37g2000prg.googlegroups.com>
Hi All,
Date: Mon, 7 Sep 2009 18:38:26 -0700 (PDT)
Message-ID: <3e167bbe-0d3a-4c1f-a537-c58cb1c3975b_at_v37g2000prg.googlegroups.com>
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
Received on Mon Sep 07 2009 - 20:38:26 CDT