| tuning related [message #54614] |
Fri, 22 November 2002 22:28  |
gaurang patel
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
|
if my server database is 40 gb and memory of server is 1.25gb then what is my sga pl telling me
|
|
|
|
|
|
| Re: tuning related [message #54635 is a reply to message #54614] |
Mon, 25 November 2002 02:47  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
It more depends on the type of your database (OLTP, DDS, Hybrid, Data Mart), and the number of concurent user connections, then the size of the database.
You have to substract from 1.25 Gb - the OS memory usage, any other running applications, leave some space for kernel I/O operations, some extra Mb, and the rest of it can go to Oracle. Whatever you size SGA, make sure it does not swap the SGA to disk, or you will get phone calls every five minutes.
A script to help you size your SGA could be found Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
