8.10 Login performance and Oracle statistics...

Anyone come across an issue whereby if you have Oracle stats generated for
the task view table (F9000), login time for a fat client rises from 2 seconds
(without stats) and 12 seconds (with stats)? Parsing the query directly to
sqlplus gives the same differences. Config of the DB server is Oracle
9.2.0.7 on Win2k3 running EO810. Have tried the various permutations of the
optimizer_mode parameter, but the same results apply.

Just wondering is this a bug particular to 9.2.x., or my stupidity! And also
if anyone else has spotted the same effect in other areas?

Regards,

Kieran Fitzgerald

Hi,

Am not an Oracle expert , but I have seen a similar scenario at another client on Oracle 9.2, where if they have statistics turned on for the job master table, then WSJ takes forever to pull up the job records....so they have turned it off for that table....

Hi,
Here are some suggestions:-
1) Try analysing the table in Oracle.
2) Set autotrace on
3) Parse the query and find the cost and time taken
4) Based on the cost and time you could try increasing the db cache size, indexes, parallel processing.

I just know the basics of Tuning, so cant really comment on it. Hope this helps.