Database Software

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!

Database - Application crashing

775371Mar 28 2012 — edited Apr 1 2012

Dear All,

I am new to Oracle DBA work, so the below mentined issues are simple for you all.

We are facing one issue here. We have database with version 10.2.0.3 in Linux server and an Application running on Win 2003 is connecting to Database. Connection is happening through Terminal server.

While users working on the application,some time the application window is crashing and the user has to connect to application again and he has to enter all the data if he didn't submit. But the same time other users can access the applciation and do their transaction.Could anyone please help , how to track the queries happening in database and If I get the queries then i can run the same from SQL promt directly.

1- > Please help me to find the queries running by users.
2- > Any other mothods I can track this issue

Thanks,
Asim

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2012

Added on Mar 28 2012

#data-guard, #performance-availability

7 comments

1,293 views