Re: Oracle on NT and memory

place4oracle_at_yahoo.com wrote:
>
> Hello,
>
> We are using Oracle and NT.
> Will all user connection use more memory ?

NT is based on multi-threaded processes -- this means that each executable program is loaded *once* into memory and all "threads" of execution for that image use the same memory-resident binary copy of the code. However, each thread must have its own "private data" area -- in Oracle this usually means the memory allocated for the PGA (Program Memory Area.) The PGA includes session info., stack, cursors & sort area for each Oracle process (the background processes like smon, pmon etc. plus one process for each user session.) So if I were you I would figure each additional session will consume memory equal to init.ora parameter SORT_AREA_SIZE plus space for cursors, stack etc. -- I don't know how much these things occupy. Maybe someone else can offer that info???
--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730