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

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 15 May 2000 20:37:56 -0700 (PDT)
Message-Id: <10498.105710@fatcity.com>

Steve,

Actually you shouldn't be using the EXECUTIONS in V$DB_OBJECT_CACHE as it's not accurate (repeated executions in the same call don't increment the value). Instead you should look at EXECUTIONS in V$SQLAREA. This is documented in the
V$DB_OBJECT_CACHE description in the Server Reference manual from 7.3 - 8.0.

HTH,

• Anita
  • Steve Orr <sorr_at_arzoo.com> wrote:
    > 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!!
    > Steve Orr
    >
    >
    >
    > --
    > Author: Steve Orr
    > INET: sorr_at_arzoo.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
    > 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).
    

    ---

Do You Yahoo!?
Send online invitations with Yahoo! Invites. Received on Mon May 15 2000 - 22:37:56 CDT