_spin_count
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Aug 2011 20:37:43 +0000
Hi guys,
AIX 6.1 11.2.0.2
We've been having CPU issues and losing the ASM connection.
I saw we have _spin_count set and was looking at
http://andreynikolaev.wordpress.com/2011/01/18/spin-tales-part-3-non-standard-latch-classes-in-oracle-9-2-11g/#more-1190
suggesting
* When you set _SPIN_COUNT parameter in initialization file, do not
forget to fix the value of _LATCH_CLASS_0="20000" also. Otherwise spin for
exclusive latches may be greatly affected by next instance restart.
*
We don't have that set and tried running his scripts getting:
desc x$ksllt
ERROR:
ORA-04043: object x$ksllt does not exis
anyone know what happened to that? Same thing in 11.1.0.7.0
TIA
Larry
10.2.0.4
15:22:51 SYS@BMCPDS>desc x$ksllt
Name Null?
Type
------------------------------------------------------------------------
-------- -------------------------------------------------
ADDR
RAW(8)
INDX
NUMBER
INST_ID
NUMBER
KSLLTNUM
NUMBER
KSLLTNGT
NUMBER
KSLLTNFA
NUMBER
KSLLTWGT
NUMBER
KSLLTWFF
NUMBER
KSLLTWKC
NUMBER
KSLLTWSL
NUMBER
KSLLTWTH
NUMBER
KSLLTMSX
NUMBER
KSLLTMXS
NUMBER
KSLLTMSW
NUMBER
KSLLTWSX
NUMBER
KSLLTWXS
NUMBER
KSLLTWSW
NUMBER
KSLLTHST0
NUMBER
KSLLTHST1
NUMBER
KSLLTHST2
NUMBER
KSLLTHST3
NUMBER
KSLLTHST4
NUMBER
KSLLTHST5
NUMBER
KSLLTHST6
NUMBER
KSLLTHST7
NUMBER
KSLLTHST8
NUMBER
KSLLTHST9
NUMBER
KSLLTHST10
NUMBER
KSLLTHST11
NUMBER
KSLLTCNM
NUMBER
KSLLTWHR
NUMBER
KSLLTWHY
NUMBER
KSLLTWTT
NUMBER
KSLLTHDT
NUMBER
KSLLTDNT
NUMBER
KSLLTWTW
NUMBER
YIELDS_KSLLT
NUMBER
MISSES_WL_KSLLT
NUMBER
YIELDS_WL_KSLLT
NUMBER
SLEEPS_WL_KSLLT
NUMBER
CLASS_KSLLT
NUMBER
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank You.
****************************************************************************
Other related posts:
