Re: advanced security confirmation

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.  

Thanks, Jason:

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

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')

On Wed, Jan 28, 2009 at 02:39:42PM -0800, K Gopalakrishnan wrote:
> Ray,
>
> 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 .
>
> -Gopal
>
>
> 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
> >
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l