Re: Is this script correct ?

From: <tday6_at_csc.com>
Date: Thu, 01 Nov 2001 08:20:04 -0800
Message-ID: <F001.003BA777.20011101083023@fatcity.com>

Try

set serveroutput on size 1000000
declare
--

V_SP NUMBER(32) := NULL;
V_FB NUMBER(32) := NULL;
V_PF NUMBER(32,2) := NULL;

--

BEGIN
select to_number(value) into V_SP from v$parameter where name = 'shared_pool_size';
select sum(bytes) into V_FB from v$sgastat where name = 'free memory';

V_PF := (V_FB/V_SP)*100;
dbms_output.put_line(V_SP||' Shared Pool Size ');
dbms_output.put_line(V_FB||' Free Bytes ');
dbms_output.put_line(V_PF||'% Free ');

END;

                    Raymond Lee                                                        
    
                    Meng Hong            To:     Multiple recipients of list ORACLE-L  
    
                    <RAYMOND             <ORACLE-L_at_fatcity.com>                        
    
                    @infopro.com.        cc:                                           
    
                    my>                  Subject:     Re: Is this script correct ?     
    
                    Sent by: root                                                      
    
                                                                                       
    
                                                                                       
    
                    11/01/2001                                                         
    
                    03:10 AM                                                           
    
                    Please                                                             
    
                    respond to                                                         
    
                    ORACLE-L

Hei , is this script correct to determint my share spool size ??? But why it give me 3 row instead of 1 ??? My DB is 8.1.7 running in win2kpro
128 RAM.. col value for 999,999,999,999 heading Shared Pool Size col bytes for 999,999,999,999 heading Free Bytes select to_number(v$parameter.value) value, v$sgastat.bytes,

     (v$sgastat.bytes/v$parameter.value)*100 PercentFree
from      v$sgastat, v$parameter
where     v$sgastat.name = 'free memory'

and v$parameter .name = 'shared_pool_size' /

7000000   392104    5.60148571428571
7000000   614400    8.77714285714286
7000000   32768     0.468114285714286

Raymond Lee
Infopro Sdn Bhd

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Raymond Lee Meng Hong
INET: RAYMOND_at_infopro.com.my

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: tday6_at_csc.com

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