Skip to Main Content

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!

Equivalent of Informix's onstat command

mohitanchliaApr 24 2008 — edited Apr 24 2008
Is there a equivalent of onstat command line in Informix ? onstat helps give lots of information like:

- Session id and the sql that session is currently executing.
- Gives the space left in tablespace
- Threads in waiting, sleeping state
- Information about Informix Virtual processors
- Locks, waits, latches
- Buffered read and write cache
- Thread id's, session ids etc.

It's a complete suite of functionality rolled in one onstat command line command. Is there something similar that would give me all this information ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2008
Added on Apr 24 2008
5 comments
1,816 views