| After an patch, collect new statistisc? [message #310154] |
Mon, 31 March 2008 07:35  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
