By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,278 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,278 IT Pros & Developers. It's quick & easy.

question on lock list

P: n/a
Hi,
we i get a snapshot for lock on db i'm getting
LOCK_LIST_IN_USE =5560
and
my LOCKLIST parameter = 50,

is it ok for OLTP database or do i have to do any tuning here.

thanks
sridhar

Sep 11 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
LOCK_LIST_IN_Use is in bytes and LOCKLIST parameter is in 4k pages...
Your config means that you have a locklist 50*4094=204800 bytes...
Check for Lock waits,Lock escalations .....

/Roger

Sep 11 '06 #2

P: n/a
locklist=50?
too low!!

situ wrote:
Hi,
we i get a snapshot for lock on db i'm getting
LOCK_LIST_IN_USE =5560
and
my LOCKLIST parameter = 50,

is it ok for OLTP database or do i have to do any tuning here.

thanks
sridhar
Sep 11 '06 #3

P: n/a

ka******@hotmail.com wrote:
LOCK_LIST_IN_Use is in bytes and LOCKLIST parameter is in 4k pages...
Your config means that you have a locklist 50*4094=204800 bytes...
Check for Lock waits,Lock escalations .....

/Roger
thanks,

both lock waits and lock escalation are showing zero.

is there any parameter to know percentage of lock list used, and also
the above values are ok or does it need any tuning?

Sep 11 '06 #4

P: n/a
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
thanks,

both lock waits and lock escalation are showing zero.

is there any parameter to know percentage of lock list used, and also
the above values are ok or does it need any tuning?
I would set locklist to 4096 for OLTP.
Sep 11 '06 #5

P: n/a

Mark A wrote:
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
thanks,

both lock waits and lock escalation are showing zero.

is there any parameter to know percentage of lock list used, and also
the above values are ok or does it need any tuning?

I would set locklist to 4096 for OLTP.
ok then,

what would be an ideal value for

LOCKLIST and MAXLOCKS

Sep 11 '06 #6

P: n/a
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
>
Mark A wrote:
>"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
thanks,

both lock waits and lock escalation are showing zero.

is there any parameter to know percentage of lock list used, and also
the above values are ok or does it need any tuning?

I would set locklist to 4096 for OLTP.

ok then,

what would be an ideal value for

LOCKLIST and MAXLOCKS
As I stated, 4096 should be fine for most OLTP systems. You could lower that
if it had fairly low transaction rates.

MAXLOCKS is the percent of the LOCKLIST that can be held by one application
before lock escalation occurs. The larger the LOCKLIST, the more locks one
application can hold before escalation occurs. If you use 4096 for LOCKLIST,
the default for MAXLOCKS is fine (I believe it is about 20%).
Sep 11 '06 #7

P: n/a

Mark A wrote:
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

Mark A wrote:
"situ" <SR********@REDIFFMAIL.COMwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
thanks,

both lock waits and lock escalation are showing zero.

is there any parameter to know percentage of lock list used, and also
the above values are ok or does it need any tuning?


I would set locklist to 4096 for OLTP.
ok then,

what would be an ideal value for

LOCKLIST and MAXLOCKS

As I stated, 4096 should be fine for most OLTP systems. You could lower that
if it had fairly low transaction rates.

MAXLOCKS is the percent of the LOCKLIST that can be held by one application
before lock escalation occurs. The larger the LOCKLIST, the more locks one
application can hold before escalation occurs. If you use 4096 for LOCKLIST,
the default for MAXLOCKS is fine (I believe it is about 20%).

thank u very much to every body

Sep 11 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.