RE: ENQUEUE RESOURCES and DML LOCKS

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 30 Aug 2001 15:59:05 -0700
Message-ID: <F001.0037E5B7.20010830161456@fatcity.com>

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" format 9999 column max_utilization heading "Max|Utilisation" format 9999 column initial_allocation heading "Initial|Allocation" format A10 column limit_value heading "Limit|Value" format A10 column cur_pcnt FORMAT 999.99
column max_pcnt FORMAT 999.99

select

    resource_name ,
    current_utilization ,
    max_utilization ,
    initial_allocation ,
    limit_value ,

    TO_NUMBER ( decode( limit_value , '         0' , '100' ,
                          ' UNLIMITED' , '0' ,
                              TO_CHAR(current_utilization / limit_value *
100) ) ) cur_pcnt ,
    TO_NUMBER ( decode( limit_value , '         0' , '100' ,
                          ' UNLIMITED' , '0' ,
                              TO_CHAR(max_utilization / limit_value * 100) )

) max_pcnt
from

v$resource_limit
order by

max_pcnt ;

-----Original Message-----
Sent: Thursday, 16 August 2001 6:48

Thanks, I have access to it, will look it up. - E

>-----Original Message-----
>From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com]
>Sent: Wednesday, August 15, 2001 1:29 PM
>
>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" <epost_at_kcc.com> wrote:
>> 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>
>
>Best Regards,
>K Gopalakrishnan,
>Bangalore, INDIA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Aug 30 2001 - 17:59:05 CDT