I get grumpy when I see negative serial#''s in v$session_connect_info ...

I get grumpy when I see negative serial#'s in v $session_connect_info ... this is almost enough to make a groundhog run for cover. Looking for sessions not using AES256 encryption ... running 11.1.0.7.5 ( patchset update about to go to 11.1.0.7.6 ).

This query shows rows from v$session_connect_info that have serial#'s less than zero.

select * from ( select sid, serial#, authentication_type, network_service_banner from v$session_connect_info where instr(network_service_banner,'AES256') > 0 ) where serial# < 1

SID,SERIAL#,AUTHENTICATION_TYPE,NETWORK_SERVICE_BANNER 5088,-21485,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product 5301,-29006,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product 5382,-26393,DATABASE,Oracle Advanced Security: AES256 encryption service adapter for Linux: Version 11.1.0.7.0 - Product

When I check these sessions against v$session the serial# looks ok
( not negative ).

select saddr, sid, serial#, username, osuser, type from v$session where
sid in ( select sid from
( select sid, serial#, authentication_type, network_service_banner
from v$session_connect_info where
instr(network_service_banner,'AES256') > 0 ) where serial# < 1 )

SADDR,SID,SERIAL#,USERNAME,OSUSER,TYPE
00000002D7C49DD0,5382,39143,I1236,whse,USER
00000002D792E920,5088,44051,I0952,sales,USER
00000002D7B6EC08,5301,36530,I5304,sales,USER

• I guess I have to volley this over to Oracle Support I did not find anything relevant yet in my searches.