We have recently migrated an Oracle 9i (18.104.22.168) database from Sunfire 4800 to Oracle 10g (10.2.0.1) on a new Sunfire e2900 server (two-node RAC), each with eight CPUs and 16GB RAM, which is double the previous configuration. We have analyzed the schema using execute dbms_utility.analyze_schema('ETMS','COMPUTE'); It took 13 hours to complete. But my 9i database just took 4.5 hours. Kindly suggest what went wrong.
In Oracle 10g, use the DBMS_STATS utility instead of the DBMS_UTILITY supplied package. This will help your cause greatly. And then look into letting Oracle automatically determine the sample size to compute statistics with (DBMS_STATS.AUTO_SAMPLE_SIZE). This document describes
the DBMS_STATS package
in more detail.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.