buffer cache and direct reads

Hi ,

i read in manual that parallel reads dont use buffer cache instead use pga memory . So when i issue a select statement in parallel , i expect to see the following things:

1. since the read is parallel , buffer cache is not used , the data is not cached so there will be no entry in gv$bh for the table.
2. gv$sessstat.name 'physical reads direct ' must be non zero .

Are these correct?

Kind Regards, Received on Fri Jul 16 2004 - 10:00:05 CDT