OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » utlrp.sql scripts (oracle,unix)

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

utlrp.sql scripts [message #310058]

Mon, 31 March 2008 02:02

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

Report message to a moderator

Re: utlrp.sql scripts [message #310060 is a reply to message #310058]

Mon, 31 March 2008 02:16

varu123
Messages: 754
Registered: October 2007

Senior Member

Is this your another interview question?

Report message to a moderator

Re: utlrp.sql scripts [message #310062 is a reply to message #310058]

Mon, 31 March 2008 02:24

sheldon1982
Messages: 59
Registered: February 2008
Location: india

Member

yes,
can you help me out.
as i said it only recompile sys objects.

Report message to a moderator

Re: utlrp.sql scripts [message #310066 is a reply to message #310062]

Mon, 31 March 2008 02:47

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

Senior Member
Account Moderator

Description is in the header of the file.

Regards
Michel

Report message to a moderator

Re: utlrp.sql scripts [message #310068 is a reply to message #310058]

Mon, 31 March 2008 03:08

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?

Report message to a moderator

Re: utlrp.sql scripts [message #310071 is a reply to message #310068]

Mon, 31 March 2008 03:12

Michel Cadot
Messages: 68641
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

Report message to a moderator