Re: System statistics in Oracle 10.2

> Does anyone know if in Oracle 10.2 we are "obliged" to have the system
> statistics? Why didn't the same problem happen on my Oracle 10.1
> environment (with NO system stats)?

You are not "obliged" to have them. You can always use DBMS_STATS to delete them, with the DELETE_SYSTEM_STATS procedure. And Oracle will run without them being present. The question is....will Oracle run effectively?

Additionally, you are talking about two different versions of Oracle, 10.1 and 10.2. These are not patchset changes. Oracle released 10.1 knowing that all of their plans for the 10g database were not fully implemented. But it gets it to market earlier than if they waited for all functionality to be implemented. Later on, they release the ".2" version with more functionality. Oracle used this same approach with previous versions as well.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown