Re: PL/SQL Tables

From: Fengqing Zhou <zhouf_at_rintintin.Colorado.EDU>
Date: 20 Apr 1998 16:47:46 GMT
Message-ID: <6hfu7i$h8@peabody.colorado.edu>

In article <3534bc5e.3221852_at_192.86.155.100>, Thomas Kyte <tkyte_at_us.oracle.com> wrote:
>A copy of this was sent to "Thomas Kux" <tku_at_thomaskux.b.uunet.de>
>(if that email address didn't require changing)
>On Wed, 15 Apr 1998 06:31:54 +0200, you wrote:
>
>>Does anyone know how the memory for PL/SQL tables is acquired ?
>>Are the kept in memory or is a temp table generated.
>>
>>Regards
>>
>>Thomas
>>
>
>They are in RAM.

Which RAM?
Data buffer in SGA? Or PGA? Or Client side RAM? Or SHARED_POOL? Or depending on whether MTS is on?

Can you explain a little bit more?

Thanks,

>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Herndon VA
>
>http://govt.us.oracle.com/ -- downloadable utilities
>
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
>Anti-Anti Spam Msg: if you want an answer emailed to you,
>you have to make it easy to get email to you. Any bounced
>email will be treated the same way i treat SPAM-- I delete it.
Received on Mon Apr 20 1998 - 11:47:46 CDT