audit dbms_shared_pool.keep Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: audit dbms_shared_pool.keep

  1. #1
    Join Date
    Oct 2006

    audit dbms_shared_pool.keep

    Database( objects are pinned. Pinning process is done by:
    exec dbms_shared_pool.keep

    Need to find what user, process is pinning them.
    For this we considered auditing package dbms_shared_pool package.
    So I planned:
    - to bounce DB to not have any pinned objects
    - to run:
    SQL> AUDIT execute ON dbms_shared_pool BY ACCESS WHENEVER SUCCESSFUL;

    Please help to audit this package and to find relevant info on which process, users are executing exec dbms_shared_pool.keep Can you also confirm whether we have to set the init.ora parameter? AUDIT_TRAIL

    Please take in consideration that this is PROD instance.

  2. #2
    Join Date
    Oct 2006
    We have done the following in TEST:
    1. set AUDIT_TRAIL=DB
    2. shutdown and restart database
    3. AUDIT execute ON dbms_shared_pool BY ACCESS WHENEVER SUCCESSFUL;
    4. then for testing, I issue
    execute dbms_shared_pool.keep('APPS.FND_PROFILE');
    5. I checked v$db_object_cache and I can see FND_PROFILE is now pinned.

    But when I tried to select on DBA_AUDIT_TRAIL & AUD$, I didn't get any row.

    So where can I find the audit inforamtion?

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    have you considered searching dba_source to look for calls to that procedure?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width