Re: Is this script correct ?

From: Raymond Lee Meng Hong <RAYMOND_at_infopro.com.my>
Date: Thu, 01 Nov 2001 00:29:35 -0800
Message-ID: <F001.003BA161.20011101001019@fatcity.com>

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). Received on Thu Nov 01 2001 - 02:29:35 CST