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:[EMAIL PROTECTED]]
>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" <[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 <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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).