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

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:
  


Current Time: Sat Dec 03 05:36:49 CST 2016

Total time taken to generate the page: 0.25298 seconds