Printable View
can i consider giving these values for DB size of >30GB and
5000 trans per day by >30 users (30 x 5000 trans) RAM size of 2-4GB
db_block_size=7000
shared_pool_size=209714200
java_pool_size= 10485600
log_buffer= 1637400
sort_area_size= 2047000
sort_area_retained_size= 1023000
Try out these, I got them as a tip from someone
O7_DICTIONARY_ACCESSIBILITY=TRUE
bitmap_merge_area_size=1048576
db_block_size=4096
db_cache_size=1543503872
db_writer_processes=2
java_pool_size=117440512
large_pool_size=67108864
sga_max_size=2735708800
shared_pool_reserved_size=42781900
shared_pool_size=855638016 sort_area_retained_size=512000
sort_area_size=1024000