OraFAQ Forum: Security » PL SQL Compilation Session

Home » RDBMS Server » Security » PL SQL Compilation Session (Oracle 10g)

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

PL SQL Compilation Session [message #479664]

Mon, 18 October 2010 11:21

shivamkkumar1gmailcom
Messages: 2
Registered: October 2010

Junior Member

Is there any way to identify who has compiled a specific PL/SQL stored program?

Report message to a moderator

Re: PL SQL Compilation Session [message #479665 is a reply to message #479664]

Mon, 18 October 2010 11:27

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use Log Miner.
But if you usually need this kind of information you should activate audit.

Regards
Michel

Report message to a moderator

Re: PL SQL Compilation Session [message #479667 is a reply to message #479665]

Mon, 18 October 2010 11:39

shivamkkumar1gmailcom
Messages: 2
Registered: October 2010

Junior Member

Thanks Michel. But if the audit is not enabled, is there any alternative to know? Few objects have been compiled last week in one of our production environment. How to track the sessions in which those have been compiled? gv$session has no data now for those objects.

Report message to a moderator

Re: PL SQL Compilation Session [message #479668 is a reply to message #479667]

Mon, 18 October 2010 11:42

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

Michel's given you the ways.
Audit exists for a reason, if you don't switch it on you really can't expect to get the information it is designed to record.

Report message to a moderator

Previous Topic:	Logminer and password change
Next Topic:	Create table others schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 25 06:58:19 CDT 2023