RE: DML Locks

Sam/Raghu/List,
if you arfe on 8i, you can query v$resource_limit to see the hwm on each resource - including dml_locks... give about 10% of head room than the max_utilization

HTH
Rahul

PS: in 7.x you have to do a query of the x$ tables... i guess you could find the query
on Steve Adam's site.

> ----------
> From: Sam Petitto[SMTP:sfp_at_netsec.net]
> Sent: Thursday, August 24, 2000 3:43 PM
> To: *lazydba
> Cc: raghuram.yadavalli_at_db.com
> Subject: Re: DML Locks
>
> Hi Raghu,
> I'm not seasoned enough yet to answer your question, but I'm sure someone
> else on the list will. I can recommend a great book by Steve Adams from
> O'Reilly Press called Oracle8i Internal Services for Waits, Latches,
> Locks, and Memory. Although over my head 1/2 the time it seems very good
> on the subject. Also, the link below should get you started in the right
> direction.
> HTH
>
> http://technet.oracle.com/files/search/search.htm?locks
>
>
> raghuram.yadavalli_at_db.com wrote:
>
> Hi,
>
> Thanx again. May be I should have been more explanative.
> You said it. Yes, I would like to know the appropriate number
> of locks to use. How to determine the same?
>
> >
> > There is a parameter called dml_locks in the init.ora file
> > Set this parameter to a higher value
> >
> > select name,value from v$parameter where name='dml_locks'
> > /
> >
> > HTH
> > Suhen Pather
> > Oracle DBA
> > Telkom SA
>
> --
> Sam Petitto 877.799.9380 toll free
> Database Engineer 703.561.0420 local
> NETSEC 703.561.0426 fax
> http://www.netsec.net
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> This electronic message contains information from NETSEC or its
> affiliates, which may be confidential, proprietary or otherwise
> protected from disclosure. The information is intended to be used
> solely by the recipient(s) named above for the purposes intended
> by the originator. If you are not an intended recipient, be aware
> that any review, disclosure, copying, distribution or use of this
> transmission or its contents is prohibited. If you have received
> this transmission in error, please notify us immediately by telephone
> at (703) 561-0420, or by email at sales_at_netsec.net.
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Received on Thu Aug 24 2000 - 04:01:19 CDT