Home » RDBMS Server » Server Administration » After an patch, collect new statistisc? (10.2.0.3 win2003)
After an patch, collect new statistisc? [message #310154] Mon, 31 March 2008 07:35 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Planning to patch our 10g DB. After the patching, will the DB have to collect new statistics? Ie, will the CBO still work in the same way as it did before or will our DBs be very slow in the beginning (if new statistics are needed)?

It is patch 18 for Windows 2003 (64).

Regards
Hristo
Re: After an patch, collect new statistisc? [message #310163 is a reply to message #310154] Mon, 31 March 2008 08:07 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
will the DB have to collect new statistics?

Yes but the default configuration in 10g is that Oracle does it itself.

Quote:
will the CBO still work in the same way as it did before

No.

Quote:
will our DBs be very slow in the beginning

Slower, faster, equal. It depends on your environment.

Regards
Michel
Previous Topic: Can Solaris 5.9 For X86 install Oracle10gR2 version?
Next Topic: pfile and control file query
Goto Forum:
  


Current Time: Thu Dec 08 16:08:03 CST 2016

Total time taken to generate the page: 0.08699 seconds