Skip to Content
0
Former Member
Jan 14, 2011 at 01:23 PM

v$log

32 Views

Hi All,

I was trying display the result of the select * from v$log.But there seems to be a formatting with the column width.I tried setting using column <column name > format a10 but it doesnt work.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-


-


-


-


-


--- -


FIRST_CHANGE# FIRST_TIME

-


-


1 1 1129 262144000 2 YES INACTIVE

5506347083 14-JAN-11

2 1 1130 262144000 2 YES INACTIVE

5506397190 14-JAN-11

3 1 1131 262144000 2 NO CURRENT

5506478936 14-JAN-11

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

-


-


-


-


-


--- -


FIRST_CHANGE# FIRST_TIME

-


-


4 1 1128 262144000 2 YES INACTIVE

5506109258 13-JAN-11

Can anyone help me with formatting the display.Thanks.