OraFAQ Forum: General » How to find OS User who did the Last compilation of Schema Objects..

Home » Other » General » How to find OS User who did the Last compilation of Schema Objects.. (Oracle10g Database on Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find OS User who did the Last compilation of Schema Objects.. [message #444765]

Wed, 24 February 2010 01:05

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Activate AUDIT or create a database trigger on DDL.

Regards
Michel

Report message to a moderator

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

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 16:19:20 CST 2024