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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Monitor queries: equivalent of mysql's "show processlist"

704200May 29 2009 — edited May 29 2009

Hi all,

I'm not very familiar with Oracle, I'm looking for a convenient way to reproduce the "show processlist" offered by mysql. As a command line would be ideal.

A little bit about the background: I'm trying to ensure my program (using JDBC) cancels queries properly. We offer support for mysql, oracle & postgres. For mysql, a one-liner:'mysql -hmy_host -pmy_port ... -e "show processlist"' returns the list of process on the server, if I could reproduce this behavior with Oracle that would be very helpful.

Thanks a lot for any help!

Anthony

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2009

Added on May 29 2009

#general-database-discussions

13 comments

5,358 views