2 CPU and 4 GB memory on the server
SGA
Shared Pool 384 m
Buffer high-speed cache 1008 m
Large pool 64 m
Java pool 32 m
Total SGA capacity 1489.209 m
The maximum size of SGA is 1521.471 MB.
PGA
Total PGA target: 800 mb
Parameters
Control_files = ('/Oracle/APP/product/9.2.0/oradata/ora9/control01.ctl', '/Oracle/APP/product/9.2.0/oradata/ora9/control02.ctl ', '/Oracle/APP/product/9.2.0/oradata/ora9/control03.ctl ')
Core_dump_dest =/Oracle/APP/product/9.2.0/admin/ora9/cdump
DB _ block_size = 8192
DB _ cache_size = 1056964608
Db_domain =''
Db_file_multiblock_read_count = 16
Db_name = ora9
Dispatchers = '(Protocol = TCP) (Service = ora9xdb )'
Fast _start_mttr_target = 300
Hash_join_enabled = true
Instance_name = ora9
Java _ pool_size = 33554432
Job_queue_processes = 10
Large_pool_size = 67108864
Log_archive_dest_1 = 'location =/Oracle/APP/product/9.2.0/dbs/arch'
Open_cursors = 300
Pga_aggregate_target = 838860800
Processes = 300
Query_rewrite_enabled = false
Remote_login_passwordfile = exclusive
Shared_pool_size = 402653184
Sort_area_size = 524288
Star_transformation_enabled = false
Timed_statistics = true
Undo_management = auto
Undo_retention = 10800
Undo_tablespace = undotbs1
User_dump_dest =/Oracle/APP/product/9.2.0/admin/ora9/udump