Re: advanced security confirmation

  • From: Jason Heinrich <jheinrichdba@xxxxxxxxx>
  • To: stellr@xxxxxxxxxx
  • Date: Wed, 28 Jan 2009 16:44:09 -0600

To see if your current session is using SSL/TLS, try this:

select sys_context('USERENV','NETWORK_PROTOCOL') from dual;

It should return 'TCPS'.  I guess that doesn't guarantee that it's
encrypted, but it's a good sign.  My second test would be to do a packet
capture to verify that the traffic was illegible, and it looks like you
already did that.

On Wed, Jan 28, 2009 at 3:58 PM, Ray Stell <stellr@xxxxxxxxxx> wrote:

> besides tcpdump, is there a way to confirm a connection is being
> encrypted via ssl?  anything in v$session?  Thanks.
> --
Jason Heinrich

Other related posts: