| SGA [message #49605] |
Tue, 23 July 2002 13:28  |
Blanca Zamarripa
Messages: 4
Registered: July 2002
|
Junior Member |
|
|
|
how to calculate SGA on my server? Is a Sun server with Oracle9i, database size is 250 MB aproximatly and the total transactions per day are 5500 with 100 users (80 via internet, 20 via LAN)
|
|
|
|
| Re: SGA [message #52467 is a reply to message #49605] |
Wed, 24 July 2002 12:33  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
show sga from svrmgrl ( in 9i just in sqlplus) will help you.
anyhow,
in 9i
sgasize= DB_CACHE_SIZE + DB_KEEP_CACHE_SIZE +
DB_RECYCLE_CACHE_SIZE + DB_nk_CACHE_SIZE
+ SHARED_POOL_SIZE + LARGE_POOL_SIZE +
JAVA_POOL_SIZE + LOG_BUFFERS + 1MB
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
