FIPS 140-2 Settings and verification

How to check what client version is connecting you DB

set linesize 180

set pagesize 600

col sid format 99999

col client_info format a45

col network_service_banner format a85

col CLIENT_VERSION format a10

col CLIENT_DRIVER format a10

break on sid skip 1 on client_info on client_version on CLIENT_DRIVER

select sid,

 (select username||'/'||machine||'/'||osuser  from v$session s where s.sid = i.sid) client_info,

CLIENT_VERSION,

CLIENT_DRIVER,

NETWORK_SERVICE_BANNER

from v$session_connect_info i;

break on sid skip 0