Home » SQL & PL/SQL » SQL & PL/SQL » Pl/Sql procedure update statistics (Oracle 10 g)
Pl/Sql procedure update statistics [message #310677] Wed, 02 April 2008 01:05 Go to next message
brutus.i
Messages: 5
Registered: October 2007
Location: India
Junior Member
Hi,
Iam using Oracle 10g , Enterprise edition.
I created a pl/sql procedure and its compiled and working fine.
Couple of days before , another developer had changed some few lines in the code for some requirement.
Now i need to know, which user changed the procedure code and what are the exact lines of codes which are changed.

Thank you.
Re: Pl/Sql procedure update statistics [message #310682 is a reply to message #310677] Wed, 02 April 2008 01:17 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
In DBA_OBJECTS you can find when the last change on an object was done: LAST_DDL_TIME.

The "Who changed it" and "What did he/she change" questions are a bit harder.
I don't know for sure, but maybe you can get that from Data Mining the logfiles ?

I guess you don't have a source versioning tool in place, which would be the perfect place to get the information you want.
Re: Pl/Sql procedure update statistics [message #310685 is a reply to message #310677] Wed, 02 April 2008 01:28 Go to previous messageGo to next message
brutus.i
Messages: 5
Registered: October 2007
Location: India
Junior Member
Thanks MarcS for the reply.
Re: Pl/Sql procedure update statistics [message #310693 is a reply to message #310677] Wed, 02 April 2008 01:48 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who and what can be found using LogMiner.

Regards
Michel
Previous Topic: SOLUTION NEEDED FOR QUERY RELATED TO EM
Next Topic: Want sql output in xls format
Goto Forum:
  


Current Time: Wed Dec 07 03:10:13 CST 2016

Total time taken to generate the page: 0.05925 seconds