Home » Other » Training & Certification » utlrp.sql scripts (oracle,unix)
utlrp.sql scripts [message #310058] Mon, 31 March 2008 02:02 Go to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Hi Experts,
utlrp.sql is scripts that is used to recompile
invalid objetc.
i want to know it only compile sys objects
or
all the other objects also.

Thanks,
Sheldon
Re: utlrp.sql scripts [message #310060 is a reply to message #310058] Mon, 31 March 2008 02:16 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Is this your another interview question?
Re: utlrp.sql scripts [message #310062 is a reply to message #310058] Mon, 31 March 2008 02:24 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
yes,
can you help me out.
as i said it only recompile sys objects.
Re: utlrp.sql scripts [message #310066 is a reply to message #310062] Mon, 31 March 2008 02:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Description is in the header of the file.

Regards
Michel
Re: utlrp.sql scripts [message #310068 is a reply to message #310058] Mon, 31 March 2008 03:08 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
i can see this line in heading of file

Although invalid PL/SQL modules get automatically recompiled on
use, it is useful to run this script ahead of time

What does it mean?
Re: utlrp.sql scripts [message #310071 is a reply to message #310068] Mon, 31 March 2008 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What does it mean?

That recompiling before a package is used lead to less time in pakage execution as it does not have to be recompile.

By the way this is explained in the header of the file.

Regards
Michel
Re: utlrp.sql scripts [message #310074 is a reply to message #310058] Mon, 31 March 2008 03:21 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
my question this script recompile only sys objects
or
all the objects.
Re: utlrp.sql scripts [message #310084 is a reply to message #310074] Mon, 31 March 2008 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My answer is this is in the header of the file.

Regards
Michel
Re: utlrp.sql scripts [message #310117 is a reply to message #310084] Mon, 31 March 2008 05:55 Go to previous message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
yes
Previous Topic: 10g OCP materials 1Z0-007
Next Topic: Which of the following is not considered part of an Oracle database?
Goto Forum:
  


Current Time: Sat Dec 10 22:42:47 CST 2016

Total time taken to generate the page: 0.14884 seconds