Striping and CI Locks

From: Christian Lang <clang_at_mediaprint.at>
Date: 4 Feb 2002 06:26:07 -0800
Message-ID: <6cf185c9.0202040626.7e252796@posting.google.com>

Hi,
at the last weekend I moved our 130G Production DB (7.3.4.5 on Solaris 2.6) from Single Disks to a Stripe set.
--

Today I detect that many sessions have to wait for enqeue
--

SELECT ksqsttyp "Lock",
ksqstget "Gets",
ksqstwat "Waits"
FROM X$KSQST where KSQSTWAT>0;
--

CF 71 2
CI 6572 1109
SQ 5277 59
ST 1067 179
TM 162497 24
TS 1295 8
TX 67239 263

My question:
Could the CI Locks be associated with the StripSet ? Could the init.ora Param. DB_WRITERS=4 be associated with the StripSet ?

any help will be appreciated
Chris Received on Mon Feb 04 2002 - 08:26:07 CST