SQL & PL/SQL

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!

See SQL Queries currently under execution

616266Feb 29 2008 — edited Feb 29 2008

Hello,

Can anyone please tell me if there is a way to see SQL Queries currently executing on Oracle Server. Sometimes oracle client program i am using hangs if query execution takes long time because of large size of the table. So when I close the client program, does query execution triggered from that client stop on server or does it continue? If it does continue, is there a way to find which query is under execution and stop it?

Thank you,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 28 2008

Added on Feb 29 2008

4 comments

2,193 views