Who's using JAVA?

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.

Other related posts: