Re: pga question

• Post for FREE via your newsreader at post.usenet.com ****

> 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)

Buffer for sort operations are stored in the PGA, i.e. no caching or sharing with other user is performed by Oracle.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=