Re: advanced security confirmation
Date: Wed, 28 Jan 2009 19:07:55 -0500
yeah, that's in the same catagory as tcpdump. I was hoping for some v$dodad.
Jason's query is in the ballpark, but what about a session that is not your current connection? I'll be wanting to track who has not cut over before I pull the plug on clear text.
SQL> select sys_context('USERENV','NETWORK_PROTOCOL') from dual;
On Wed, Jan 28, 2009 at 02:39:42PM -0800, K Gopalakrishnan wrote:
> You may want to trace the sqlnet packets and see whether they are
> encrypted or not. Without ASO, you may see the SQLtext and data (in
> fixed with hex as well as ascii) format.
> Set the sqlnet.ora parameter trace_level_client=support/16 to see the
> encrypted(!) data transfer .
> On Wed, Jan 28, 2009 at 1:58 PM, Ray Stell <stellr_at_cns.vt.edu> wrote:
> > besides tcpdump, is there a way to confirm a connection is being
> > encrypted via ssl? anything in v$session? Thanks.
> > --
> > http://www.freelists.org/webpage/oracle-l