user$.AUDIT$
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Dec 2009 15:31:02 -0600
Hi Lister,
Do you know what user$.AUDIT$ is for? I know it's for audit but our
audit_trail is set to NONE.
(Also, what is _NEXT_USER?)
Thanks,
Roger
P.S.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
SQL> select name, AUDIT$ from user$
2 where name = '_NEXT_USER'
3 or name = 'W10574'
4 or name = 'ROGER';
NAME AUDIT$
------------------------------ --------------------------------------
ROGER
W10574
_NEXT_USER ------
SQL> select name, AUDIT$ from user$
2 where name = '_NEXT_USER'
3 or name = 'W10574'
4 or name = 'ROGER'
5 or name = 'W9627';
NAME AUDIT$
------------------------------ --------------------------------------
W9627 ------
ROGER
W10574
_NEXT_USER ------
SQL>
Other related posts:
