Database Administration (MOSC)

MOSC Banner

Ask about SHARED SERVER on 9i

edited Jun 4, 2012 5:41AM in Database Administration (MOSC) 3 commentsAnswered
Hi all,

   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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center