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
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
v$resource_limit. Look at the max_utilitization and initial_allocation columns..
Thanks
Riyaj Re-yas Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Post, Ethan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/15/01 02:51 PM
Please respond to ORACLE-L
To:Multiple
