cancel
Showing results for 
Search instead for 
Did you mean: 

v$log

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

audunlea_hansen
Active Participant
0 Kudos

Try

set pages 50 lines 120

col <col name> form a30

.....

select * from v$log

You may like to set the following before query on v$log:

alter session set nls_date_format='dd.mm.yy hh24:mi:ss';

Regards

Audun

Answers (0)