| dbms_shared_pool.keep auditing [message #202392] |
Thu, 09 November 2006 08:26  |
suvv
Messages: 17
Registered: October 2006
|
Junior Member |
|
|
Database(9.2.0.5) objects are pinned. Pinning process is done by:exec dbms_shared_pool.keep
Please take in consideration that this is PROD instance.
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?
Please help to audit this package and to find relevant info on which process, users are executing exec dbms_shared_pool.keep
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
