Friday, July 13, 2007

10g Init parameter(sepecific)

--Common Settings for 10g Database
commit_write='batch' #(or not to set it )
recyclebin=on
disk_asynch_io=false #(For platform doesn’t support asynchronised I/O, like HP-UX)
-- Use hidden parameters as workaround for 10g bugs, which are fixed in future version.
_gby_hash_aggregation_enabled=FALSE # bug 4604970
_kghdsidx_count=1 #bug 5508574
_table_lookup_prefetch_size=0 #bug 5509707, 4148420