XE Poor Performance on Oracle 9.2.0.5

s_woolley

Member
Dear List



We have been experiencing very poor performance since upgrading XE from
Oracle 8.1.7.4 to 9.2.0.5.



We believe Oracle statistics is causing the main problem relating to the
poor performance.



Can anyone recommend any statistics commands that work best with XE and 9i ?



We are on XE SP22_C1

Oracle 9.2.0.5 (64bit)

Sun Solaris V8



Thank you



Shane Woolley

CNC Administrator
 
Shane,

logged in to Oracle (SQL-PLUS or SQL Worksheet) as a DBA issue the following command for each Schema as appropriate, replacing PRODDTA with each schema name:

execute dbms_utility.analyze_schema('PRODDTA','COMPUTE');

Regards,
 
Back
Top