Hi Steve,
It looks like I used an incorrect script (see below) to determine hidden
parameters. I always used it for v7 in the past, but didn't go in detail how
it worked itself
--
-- Shows hidden (undocumented) init.ora parameters
--
col ksppinm format a40
select ksppinm, ksppity
from x$ksppi
where substr(ksppinm, 1, 1) = '_'
order by ksppinm
/
Your script ('all_parameters') returns expected default 1 and there are no
latches which have non-zero WAITERS_WOKEN except 'shared pool' and 'library
cache'
BTW could you tell me what does KSPPITY mean ?
Thanks,
Ed
>
>
> Hi Ed,
>
> Are you sure that's a default. I've seen it default to 1 on
> the same platform
> and version.
> Which latches have non-zero WAITERS_WOKEN statistics in V$LATCH?
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
>
> -----Original Message-----
> From: Shevtsov, Eduard [mailto:EShevtsov_at_flagship.ru]
> Sent: Friday, 17 November 2000 21:40
> To: Multiple recipients of list ORACLE-L
> Subject: latch_wait_posting
>
>
> Hi ALL!
>
> I have default _latch_wait_posting = 3, I'm on 8.1.6, Solaris
>
> Does anybody know the sense of setting the parameter to three ?
Received on Fri Nov 17 2000 - 06:50:13 CST
