Home » Other » General » How to find OS User who did the Last compilation of Schema Objects.. (Oracle10g Database on Unix)
How to find OS User who did the Last compilation of Schema Objects.. [message #444765] Wed, 24 February 2010 01:05 Go to next message
baskaranprasad
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
Hi,

In our dev environment there are thousands of packages and many people without knowingly compiling the specs from PL/SQL tool editor interfaces which inturn affects the status of thousands of dependant packages that results in lots of invalids in our schema.

Is there any way to identify the OS User who did the Last compilation of Schema Objects from metadata dictionaries?
Either it can be the invalid recompilations or altering the db objects etc. Basically want to know the OS user who touched the objects last recently.

Thanks in advance.

Regards,
B.Prasad
Re: How to find OS User who did the Last compilation of Schema Objects.. [message #444767 is a reply to message #444765] Wed, 24 February 2010 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate AUDIT or create a database trigger on DDL.

Regards
Michel
Re: How to find OS User who did the Last compilation of Schema Objects.. [message #444770 is a reply to message #444767] Wed, 24 February 2010 01:31 Go to previous messageGo to next message
baskaranprasad
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
Hi Michel,

Thanks for your reply. Based on your reply I searched in this site and got the solution. Here is the link.

Quote:
http://www.orafaq.com/scripts/plsql/auditdll.txt


Thanks for your valuble time.

Regards,
B.Prasad

[Updated on: Wed, 24 February 2010 01:32]

Report message to a moderator

Re: How to find OS User who did the Last compilation of Schema Objects.. [message #444771 is a reply to message #444770] Wed, 24 February 2010 01:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: Oracle Licensing - Standard / Standard One, per processor not per core?
Next Topic: Building Web 2.0 UIs with JSF, Realtime Updates with JSF and Ajax Push Taught at GIDS 2010
Goto Forum:
  


Current Time: Thu Mar 28 05:10:17 CDT 2024