annatext.serwis
Temat: [Oracle 9] Priorytety dostepo do bazy
...db_name=bpsc
background_dump_dest=/oracle/admin/bpsc/bdump
core_dump_dest=/oracle/admin/bpsc/cdump
timed_statistics=TRUE
user_dump_dest=/oracle/admin/bpsc/udump
control_files=("/oracle/oradata/bpsc/control01.ctl",
"/oracle/oradata/bpsc/control02.ctl", "/oralog/bpsc/archiv/control03.ctl")
instance_name=bpsc
job_queue_processes=10 aq_tm_processes=1
compatible=9.2.0.0.0
hash_join_enabled=TRUE
query_rewrite_enabled=FALSE
star_transformation_enabled=FALSE
remote_dependencies_mode=SIGNATURE
shared_pool_size = 524288000
#shared_pool_size = 704643072
java_pool_size = 33554432
large_pool_size = 67108864
processes=100
fast_start_mttr_target=300
sga_max_size=1572864000
#sga_max_size = 1363148800...
Źródło: forum.hotscripts.pl/showthread.php?t=15937
