SQL*Plus (MOSC)

MOSC Banner

How to format SQLPLUS output?

edited Oct 14, 2009 9:35PM in SQL*Plus (MOSC) 7 commentsAnswered
 Hi!

How do I format the below output to be more readers friendly?

select sid, username, event, blocking_session,
   seconds_in_wait, wait_time
from gv$session where state in ('WAITING')
and wait_class != 'Idle';

    SID USERNAME                       EVENT
                        BLOCKING_SESSION
------- ------------------------------ -----------------------
----------------------- ----------------
SECONDS_IN_WAIT WAIT_TIME
--------------- ---------
    183 SERVER                         PX Deq: Signal ACK
              0         0

As you can see its really hard to read.

Thanks for your time!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center