Originally posted by Orca777
9i DB_BLOCK_LRU_LATCHES ... how can is see/select it?
Code:
select count(*) from v$latch_children
where name = 'cache buffers lru chain';
From metalink...
In Oracle9i, the parameter DB_BLOCK_LRU_LATCHES is obsolete (listed in the desupported/depreciated init.ora parameter section of the Oracle 9i New Features guide). This is now a hidden parameter that defaults based on the value of cpu_count or db_writer_processes if explictly set, as well as several other factors(which includes the max # of caches ). A setting of db_writer_processes = 4 seems to adjust the hidden parameter to 32. Since this is now a hidden parameter, I would keep in mind that the formula (and therefore the value)is subject to change with subsequent versions.
HTH.