Why upgrade to SP4 would cuase Oracle problems

Hello,

Don't know if anybody else has gone or is going through this but here goes.

I don't know if this would be a Oracle or windows issue but i thought i give it a try here at this forum. One of current development servers was upgraded to SP4 for W2K and now Oracle seems to be running at a crawl. Specially when it comes to large queries with outter joins in them. Some just hang and I had to ctl+c to get out.
Is there bug with that SP4 that i should know about? or a tweak that needs to be done to Oracle or its configuration when a machine is upgraded to SP4 (Service Pack 4) ?

Any ideas/suggestions would be great. Or a site that can help me with my problem.

Thanks in Advance.

I think you need to investigate in more depth, pls follow the procedure given below and note the time is taken by the query:

(1) First run the same query without any outer join drop any ORDER BY clause from the query
(2) Add ORDER BY clause and drop outer join from your query
(3) Drop outer join and any ORDER BY clause from your query
(4) Drop all where clauses and run your query

It might be indexing problem if you dont have any index for both base table and joint table(s), Create proper indexe(s) on both base table and joint table(s), Otherwise check the index(s) using by both tables, drop unnecessary index(s) then run the complete query.

Regards,

Can't you take a look at Metalink for known issues on Oracle (which version??) and W2k SP4?

The wierdest thing happened. While i was searching metalink for threads with my similar problem and i found that 9i was smooth and nothing on 8i. And then I tried the queries again and it was fast again. We have no idea who did what or what happened over the days since we last tested the upgrade but everything seems to be running smoothly now.
Thanks for all your suggestions, I will still try the steps just to make sure. =)
But for now all is OK.

Thanks again.