Ask about SHARED SERVER on 9i
Our comp has been used Oracle Application Server and Oracle DB version 9.2.0.4 64 bit on AIX 5.2
At a time, there are about 70 sessions (application users) connect to db by one use APP_USER. APP_USER is representative user.
I just joined this db server about three days ago, and it's SHARED SERVER. I read some documents about SHARED SERVER, Oracle recommends should use LARGE POOL to allocate the shared server-related UGA, rather that using the shared pool.
To our db, LARGE_POOL_SIZE = 1G. When use bellow scipt to check sessions:
select sid, username, server from v$session where type='USER';