Home » RDBMS Server » Server Administration » compiling invalid objects
compiling invalid objects [message #320986] Sat, 17 May 2008 06:06 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I checked my production database and it has about 100 invalid objects, should i run the utlrp script, please advice.

Report message to a moderator

Re: compiling invalid objects [message #320992 is a reply to message #320986] Sat, 17 May 2008 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It won't hurt to run utlrp, but it might not help anything.

Is everything working OK in your Production Application?

Do you suffer from compulsive tuning disorder?

Report message to a moderator

Re: compiling invalid objects [message #320996 is a reply to message #320986] Sat, 17 May 2008 09:07 Go to previous message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
Maybe utlrp solves your problem. However you may want to find out why these objects turned invalid.

Report message to a moderator

Previous Topic: after run CREATE DATABASE statement, where can I find the log file?
Next Topic: How do I effectively monitor and notify OS diskspace utilized by Oracle tablespaces?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 10 09:38:10 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.