Re: Viewing the hidden _{Parameters}

I strongly recommended not changes these unless you talk to Oracle first, easiest way to get de-supported. By the way in 8i you dont need to change this parameter. I have done some testing and you get one latch per db_block. Unlike 7.x where you got a ratio of 4/1.. ie 4 db_blocks to one latch. The SQL to view the documented parameters is :

select ksppinm from x$ksppi

where substr(ksppinm,1,1) = '_';

"Rob K" <robkato_at_earthlink.net> wrote in message news:HU9W6.5411$aV1.495316_at_newsread1.prod.itd.earthlink.net...

> How can I find what the values are for the '_' parameters (hidden) i.e.
> _db_block_hash_buckets
>
> Thanks Rob
>
>
Received on Thu Jun 14 2001 - 20:54:56 CDT