Home » RDBMS Server » Backup & Recovery » Update statistics (Oracle 10.2.0.1.0 - Linux)
Update statistics [message #376474] Wed, 17 December 2008 08:21 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!!
I've got a question...
Is it recommended to run an "update statistics" after recovering a database from backup?
When is it recommended an which is the oracle command for doing it?
Thanks!!
Daniela.
Re: Update statistics [message #376483 is a reply to message #376474] Wed, 17 December 2008 09:36 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is it recommended to run an "update statistics" after recovering a database from backup?
Depends. If the physical layout of disks has changed (database files may still go to the same "path"), it is better.
>>When is it recommended an which is the oracle command for doing it?
The same command that was used before restore?
Previous Topic: Cold Copy Restore
Next Topic: rman 'restore validate database' parallelism
Goto Forum:
  


Current Time: Thu Aug 17 05:00:27 CDT 2017

Total time taken to generate the page: 0.09977 seconds