FAQ
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>

Search Discussions

  • Goulet, Richard at Dec 23, 2009 at 1:21 pm
    Just because audit_train = none does not mean that the structures are
    not in place.


    Dick Goulet
    Senior Oracle DBA/NA Team Lead
    PAREXEL International



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Roger Xu
    Sent: Tuesday, December 22, 2009 4:31 PM
    To: oracle-l@freelists.org
    Subject: user$.AUDIT$

    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>
  • Roger Xu at Dec 23, 2009 at 2:42 pm
    my question is - what is the meaning of 5 dashes in the audit$ field?
    Thanks.
    On Wed, Dec 23, 2009 at 7:21 AM, Goulet, Richard wrote:

    Just because audit_train = none does not mean that the structures are not
    in place.


    *Dick Goulet***
    Senior Oracle DBA/NA Team Lead
    PAREXEL International


    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Roger Xu
    *Sent:* Tuesday, December 22, 2009 4:31 PM
    *To:* oracle-l@freelists.org
    *Subject:* user$.AUDIT$

    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>
    >
  • Mark W. Farnham at Dec 23, 2009 at 2:35 pm
    select x.user#,x.name

    from (select user#,name from sys.user$ order by user# desc) x

    where rownum < 5;



    should illustrate what _NEXT_USER is.



    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Roger Xu
    Sent: Tuesday, December 22, 2009 4:31 PM
    To: oracle-l@freelists.org
    Subject: user$.AUDIT$



    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>
  • Yong Huang at Dec 23, 2009 at 5:08 pm

    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?)
    Was the database upgraded from 9i to 10g? The script c0902000.sql has

    update user$ set audit$ = substr(audit$, 1, 32) || '------';

    among other update SQLs to set the same column of other base tables
    to have 6 dashes (at the end).

    According to Bug 6635956, DBMS_METADATA.GET_DDL can fail if this column
    "contains NULL characters". I think this is related, although a NULL
    character is really chr(0), instead of NULL (see the SQL in catmeta.sql).

    The _NEXT_USER is a special dummy user used when you create a new user,
    probably temporarily holding the next user#.

    I've done a little research on a similar object, _NEXT_OBJECT. It plays
    a role in assigning a new ID when you create a new object of any type.
    If you see contention on _NEXT_OBJECT, you may be creating new objects
    too frequently. (Ref: http://yong321.freeshell.org/computer/UncommonSenseAboutCommonObjects.doc)

    Yong Huang

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 22, '09 at 9:31p
activeDec 23, '09 at 5:08p
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase