Re: Single user, multiple log ins

"Christopher Latta" <nobody_at_nowhere.not> wrote in message news:eo0P6.3292$Ld4.144913_at_ozemail.com.au...
> I have an application, and for ease of client use I have set up one Oracle
> user password that everybody uses to log in to the database (this happens
> automatically via initialization scripts) and their actual log in is
> verified against my own tables of user names and passwords.
>
> I have been reading some DBA books recently and they were discussing the
> private area of the SGA that gets allocated to each user. I took this to
> mean "each user session", but had a horrible thought this morning that
 they
> may have actually meant each user log in name, which would mean I'm
 cramming
> all my users into one little section of memory. Surely not.
>
> Is there any performance implications of such an approach?
>
> TIA
> Christopher Latta
>
>

The PGA is in the SGA only when using MTS. Also it is indeed allocated by session basis and not per user.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 24 2001 - 01:50:10 CDT