Home » RDBMS Server » Server Administration » dbms_shared_pool.keep auditing
dbms_shared_pool.keep auditing [message #202392] Thu, 09 November 2006 08:26 Go to next message
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
Re: dbms_shared_pool.keep auditing [message #202394 is a reply to message #202392] Thu, 09 November 2006 08:37 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

From which user you execute "dbms_shared_pool" pkg.
if sys, sys infomation is not store in aud$ table. it is store OS level.

hope this helps.
Mohammad Taj.
Previous Topic: OEM issue
Next Topic: ORA-01684: max # extents (30) reached in table ...
Goto Forum:
  


Current Time: Fri Dec 02 20:48:50 CST 2016

Total time taken to generate the page: 0.09368 seconds