Monitoring 8i memory usage- dictionary change breaks script, 2nd request

From: Steve Orr <sorr_at_arzoo.com>
Date: Mon, 15 May 2000 10:29:16 -0700
Message-Id: <10498.105672@fatcity.com>

They changed the data dictionary again in O8i... of course! For 8.0 I have a single query on v$db_object_cache to monitor activity:

SELECT SUBSTR(owner,1,10) Owner,
       SUBSTR(type,1,12)  Type,
       SUBSTR(name,1,20)  Name,
       executions,
       sharable_mem       Mem_used,
       SUBSTR(kept||' ',1,4)   "Pinned?"

  FROM v$db_object_cache
 WHERE type in ('TRIGGER','PROCEDURE','PACKAGE BODY','PACKAGE')  ORDER BY executions desc, sharable_mem desc;

BUT IT DOESN'T WORK IN 8i !!!! The execution counts are no longer maintained in V$DB_OBJECT_CACHE.
Soooo... anyone got a script to monitor executions and memory like the one above that used to work?

TIA!! Received on Mon May 15 2000 - 12:29:16 CDT