Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

please analyze my statspack report

576856Mar 17 2009 — edited Mar 17 2009

Hi,

My database is 9.2.0.7 running on hp-ux itanium . we have one schema,which is used for Application.

my apps user from application is trying to do his some process, from application that process is hanging. I traced the sql query, that what that process is running.

I am able to successfull run that query in sql*plus session.

but when I deleted statics on those tables involved in the query, the process from application went fine. i dont know, why it is like that?

I got the statspack report during that time period.

can you please analyze, is there anything wrong with my database

i have optimizer_mode=choose enabled

Edited by: oraDBA2 on Mar 17, 2009 11:48 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 17 2009

#general-database-discussions

10 comments

921 views