Database Memory & 4030/4031 (MOSC)

MOSC Banner

400 session with dedicated server.

edited Oct 10, 2018 10:01AM in Database Memory & 4030/4031 (MOSC) 26 commentsAnswered
Hi Oracle Masters,

Our working environment is as follows:
One database server is Oracle 9i (9.2.0.8) and Windows 2003 EE 32 bit, 24GB of physical RAM, using / PAE and / 3GB so windows only reading 16GB.
One Enterprise Server (JD Edwards EnterpriseOne 8.11) and Windows 2003 EE 32 bit (4GB RAM)
Three JAS Server and Windows 2003 EE 32 bit (@ 4GB RAM)


SQL> show sga

Total System Global Area 9473324244 bytes
Fixed Size                   459988 bytes
Variable Size             880803840 bytes
Database Buffers         8589934592 bytes
Redo Buffers                2125824 bytes
SQL> show parameter pga

NAME_COL_PLUS_SHOW_PARAM                                         TYPE
---------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
--------------------------------------------------------------------------------
----------------------------------------------------
pga_aggregate_target                                             big integer
2684354560

Name                                            Total Units                                                                        

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