RE: parameter comparison

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 08 Nov 2001 14:36:50 -0800
Message-ID: <F001.003C03FC.20011108140517@fatcity.com>

For those in v$resource_limit try the following query which I find useful:

---start here

• @resource_usage.sql
  --
  
• 25-Aug-2000 Bruce Reardon
  --
  
• Show the resource usage, including calculated percentage values
• 31-Aug-2001 , Bruce Reardon : Add in further order by relating to unlimited resources.

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 , max_utilization , limit_value desc , initial_allocation desc ;

• end query

-----Original Message-----

Sent: Thursday, 8 November 2001 22:25

Some of them you could see through v$resource_limit, v$license and v$mts.

Regards.

• "Tatireddy, Shrinivas (MED, Keane)" <Shrinivas.Tatireddy_at_med.ge.com> wrote: > Hi lists, > > Does anybody have a query that compares the > parameteres that are in > v$parameters vs parameters that are actually being > used by system at a > given time. > > ex: processes parameter in v$parameter is 600 > > if I query select count(*) from v$process; > > count=50 > > at a particular time > > In he same way, for rest of the processes can > anybody post me somequery > (if you have), to check them currently being used. > > Thanx in advance, > Srinivas
  --
  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 Nov 08 2001 - 16:36:50 CST