Session queries - column order

[Aviga]

Hi,

I defined a top-level session query called "Application Info" to see some v$session in a specified order.

select username, module, action, client_info, sid, serial#, status, sql_address, sql_hash_value, paddr
from v$session
where username is not null;

The columns are ordered completely differently!

Should they be taken into account?

Thanks in advance.

Best regards

Avigael

 

[Marco Kalter]

Some key columns are indeed moved forward. This is a known issue that is fixed for the next release.

 

[Aviga]

Thanks Marco.