dba_audit_session.userhost=1 - What does it mean?

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: oracle list <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 8 Nov 2005 20:12:44 -0500

All,

Oracle 9.2.0.6, Solaris 2.9.

The user did login  from remore host and I could see the correct host
name in V$session however dba_audit_session.userhost shows value of
"1" as below.

select count(*) from dba_audit_session
  COUNT(*)
----------
        44
1 row selected

select distinct userhost from dba_audit_session;
USERHOST
------------------------------------------------
1
--
//www.freelists.org/webpage/oracle-l


Other related posts: