Ethan,
And for a simple script I find handy to look at v$resource_limit:
-- resource_usage.sql
--
-- 25-Aug-2000 Bruce Reardon
--
-- Show the resource usage, including calculated percentage values
--
set pagesize 1000
set linesize 150
column current_utilization heading Current|Utilisation
What would I see if these are set too low and where would I find it?
- Ethan
- http://www.geocities.com/epost1 http://www.geocities.com/epost1
--
This e-mail is intended for the use of the addressee(s) only and may
Hi, !
Oracle 8i Internal Services (Steve Adams) has a nice discussion abt
this topic.Sorry, RIght now I don't have the book with me.
--- Post, Ethan [EMAIL PROTECTED] wrote:
What would I see if these are set too low and where would I find it?
- Ethan
- http://www.geocities.com/epost1
You can set dml_locks in your init.ora. I believe the only drawback to
increasing this is loss of a small bit of memory. I think each dml_lock slot
takes about 100 bytes (it's written up in Steve Adams' book). If I remember
correctly, enqueue_resources can also be set in the init.ora, but if you
Thanks, I have access to it, will look it up. - E
-Original Message-
From: K Gopalakrishnan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ENQUEUE RESOURCES and DML LOCKS
Hi, !
Oracle 8i Internal Services
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ENQUEUE RESOURCES and DML LOCKS
What would I see if these are set too low and where would I find it?
- Ethan
- http://www.geocities.com/epost1 http://www.geocities.com/epost1