数据库参数设置讨论

zoracledba

环境：AIX5+ORACLE9204
服务器配置：12G RAM + 6个CPU
数据库用途：OLAP(数据仓库)，大小为2T，大量的存储过程，每天夜大量的后台调度并发(50个）。
主要的参数配置：
*** db_cache_size=2G , too small    increse to 4 or 6 GB (depend on if there other process using Memory on that machine)

*** shared_pool_size=2G , too large, even in 10g, 300M is enough, unless you have procedures need pin into shared_pool. set it to 300M is OK.
*** workarea_size_policy=manual,  set it to AUTO
*** sort_area_size=5M, forget it if you use AUTO, let Oracle to handle it.
hash_area_size=10M, forget it if you use AUTO.
cursor_sharing=manual, set to FORCE
undo_management=AUTO   good.

Thanks!
zOracle DBA

antiper

tks,楼上的