Hi all!

I'm new in database administration, and i'm having some problems regarding
the gathering statistics!

My applications are running in a very good performance. Here we have
9.2.0.5.0 Oracle 9i Database! And there's no statistics! So i think we are
running our queries in a rule CBO mode! (Is that ritgh?!?)

Now we want to migrate to 10g but first we want to test our applications
through a statistics collected environment! For that we have run (over our
dev db) the dbms_stats.gather_schema_stats(OWNER => 'OWNER') statement for
just one owner!

The performance got as down as you can imagine!

Could anyone please advise me about that!

Thanks in advance!

Best regards,

Claudio Duarte
-------------------------------------------------
OCP - Desenvolvedor Oracle
Analista de Sistemas Sr.
[Email address protected]
Tel....: + 55.19.3565.5304
Mob..: + 55.16.9168.2368

Oracle LazyDBA home page