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: 10672
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: Mon Dec 05 04:47:15 CST 2016

Total time taken to generate the page: 0.09324 seconds