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

Report message to a moderator

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?

Report message to a moderator

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.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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 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?

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

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.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
My answer is this is in the header of the file.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

Previous Topic: 10g OCP materials 1Z0-007
Next Topic: Which of the following is not considered part of an Oracle database?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 03:13:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.