problem about full scan temporary table

  • From: qihua wu <wqhhp@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 23 Sep 2006 23:12:39 -0700 (PDT)

Hi, all

I created a global temporary table, and many sessions
will populate huge
volume of data into this table. All of these sessions
will access the table
by means of full scan. Suppose session S1 inserted
10,000 blocks of data,
and S2 inserted 10,000 blocks of data. If S1 scan the
table, will it scan
10,000 blocks or 20,000 blocks? For normal table,
there is high water mark
that determine the upper boundary that oracle will
scan, for temporary
table, is there a similar high water mark for each
session, or for all


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

Other related posts: