It is always challenging for Oracle Administrator to define Oracle Memory Parameters. Recently while creating new database with Oracle 11g (11.2.0.3) using DBCA, I noticed the values DBCA assigns to the following memory parameters.
Total Memory: 1024 M (or 1 GB)
Shared Pool - 160 M
Buffer Cache- 482 M
Java Pool - 48 M
Large Pool - 76M
PGA - 256 M
These value can help Oracle DBA to multiply or divide to get accurate numbers. I chose 'custom database' option with 8K block size in DBCA.
Total Memory: 1024 M (or 1 GB)
Shared Pool - 160 M
Buffer Cache- 482 M
Java Pool - 48 M
Large Pool - 76M
PGA - 256 M
These value can help Oracle DBA to multiply or divide to get accurate numbers. I chose 'custom database' option with 8K block size in DBCA.
No comments:
Post a Comment