pga question

From: utkanbir <hopehope_123_at_yahoo.com>
Date: 8 Jul 2004 22:25:36 -0700
Message-ID: <f6c90ebe.0407082125.1d6e216d@posting.google.com>

Hi Gurus ,

I have a question about pga.

Think that i have a big sort operation or a create table as select statement (so pga is necessary for write buffers), for the sort operation , where are the blocks which are read from disk are stored? In buffer cache (so other users can use these blocks since they are cached.) or in pga (so only the workarea which is allocated for the process can see them)

Kind Regards,
tolga Received on Fri Jul 09 2004 - 00:25:36 CDT