Who's using JAVA?

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Fri, 28 May 2004 15:45:50 -0500
Message-ID: <A366E86AF2FBD611AB920002B31E58B0096DC8AF@conmsx07.corp.acxiom.net>

Hi Guys! How do I tell if anyone's using JAVA?  

We inherited a bunch (30+) of 8.1.6.2 DBs almost all of which have JAVA installed. Upgrading to 9.2 has been a pain with JAVA.  

Today one of the DBAs ran rmjvm on a DB that had been upgraded and he lost all the user source.
He got it back, but while he was doing that the client said they hadn't been using the code for almost 2 years.    

Just wondering how I tell who, is anyone is using it, and how much. I ran an old script to check pool use and got: (db.name is used to tell difference between 50 or so DBs called 'PROD','ORCLT','TEST' etc.)
--SP.sql Written by Lawrence Wolfson 09/10/99 -- Courtesy of Rich Niemiec column SELECT magazine July 99 V6#4  

SET FEEDBACK OFF
COL value FOR 999,999,999,999 HEA "Shared Pool Size" COL bytes FOR 999,999,999,999 HEA "Free Bytes" COL time FOR A20
SELECT db.name DB

,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS') TIME
,TO_NUMBER(V$PARAMETER.value) value
, V$SGASTAT.bytes
,(V$SGASTAT.bytes/V$PARAMETER.value) * 100 "Percent Free"
 FROM db

,V$PARAMETER
,V$SGASTAT

WHERE V$SGASTAT.name = 'free memory'
 AND V$PARAMETER.name = 'shared_pool_size' ;
SELECT db.name DB

       ,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS') TIME
       ,TO_NUMBER(V$PARAMETER.value) value
       , V$SGASTAT.pool
       , V$SGASTAT.bytes
       ,(V$SGASTAT.bytes/V$PARAMETER.value) * 100 "Percent Free"
   FROM db
       ,V$PARAMETER
       ,V$SGASTAT
 WHERE  V$SGASTAT.name   = 'free memory'

  AND (V$PARAMETER.name = 'shared_pool_size'   AND V$SGASTAT.pool = 'shared pool'

       )
   OR (V$PARAMETER.name = 'large_pool_size'   AND V$SGASTAT.pool = 'large pool'

       )
 ;
DB TIME (GMT) Shared Pool Size POOL Free Bytes Percent Free

---- -------------------- ---------------- ----------- ----------------
------------
xxxx 28-MAY-2004 20:37:52      245,366,784 shared pool       89,521,044
36.4845814
xxxx 28-MAY-2004 20:37:52      262,144,000 large pool       262,144,000
100
xxxx 28-MAY-2004 20:37:52      230,686,720 java pool        230,473,728
99.9076705
xxxx 28-MAY-2004 20:37:52      230,686,720 java pool            212,992

.092329545  

  This is one of few databases we're running RMAN on, but client says they're using JAVA all the time.  

Thanks
Larry      

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 28 2004 - 16:22:49 CDT