performance issue

[maswien]

I recently created a 9i database, after the vendor imported the data into the database, they complained that the oracle hung (time out )when running a large resultset query. In general, what should I start to look at in this case?

Thanks.

 

[SantaMufasa]

Maswein,

Hanging is not a performance issue...it is an error condition. What proof can you/they offer that Oracle is actually hanging versus simply taking a long time to execute? Is Oracle throwing some sort of error during a long-running query?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[Beilstwh]

Did you gather statistics after you did the large vendor import? If you didn't, your explain plans will be all messed up.

Bill
Oracle DBA/Developer
New York State, USA

 

[Wholsea]

I'd say check your indexes and make sure they are set up so as to promote speedy queries...

Then I'd run some statistics...

Analyze table tablename compute statistics

this should speed things up a bit...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[maswien]

Thanks for replies, I asked the queries they ran, they told me the query returns 40,000 rows and used as to replicate these data to another database, does this look like a network issue? When I checked the .trc file in /udump directory I couldn't find a time out query. Anything I can do on the database side in this case?