_spin_count

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 10 Aug 2011 20:37:43 +0000
Message-ID: <EDA437CAA8612C418E013CDA4B4A75513E55EBB5_at_CWYIGMBCRP01.Corp.Acxiom.net>

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_at_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.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 10 2011 - 15:37:43 CDT