Index: Date Index | Thread Index

[Date Prev] | [Date Next] | [Thread Prev] | [Thread Next]

[OAUGNetDBA]-Re: CPUJAN 2008

It happened to us.
Bakthav, Vidhya wrote:

Hi All,

After the installation of CPUJAN 2008 Database patch 6646853 the readme
instructs us to run view_recompile_jan2008cpu.sql to compile all the
views. The recompile_precheck_jan2008cpu.sql reported that 21,300 views
found and 46,389 objects to compiled. The number of invalid objects in
the db after running utlrp is only 70. When i ran the
view_recompile_jan2008cpu.sql it invalidated 46,389 objects and compiled
them back. This took more than 6 hours to complete.

Does this happen to everyone?

thanks,
vidhya

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>





#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>
  • Prev by Date: [OAUGNetDBA]-CPUJAN 2008
  • Next by Date: [OAUGNetDBA]-Re: CPUJAN 2008
  • Previous by thread: [OAUGNetDBA]-CPUJAN 2008
  • Next by thread: [OAUGNetDBA]-Re: CPUJAN 2008

    • Index: Date Index | Thread Index

    Thank you for using the OAUG Listserver Archive.