FAQ
Hello All,



2 node RAC, 10.2.0.4 EE, on Solaris 10



I am examining data in FGA_LOG$ generated by my fine grained auditing
configuration. I am surprised to see many records with SCN=0. These
records are all inserts (STMT_TYPE=2). And as a cute little aside,
after I saw this the database began kicking me out with ORA-3113.
Lovely.



Has anyone seen this before? How could Oracle just decide to give me
garbage for the SCN? A feature, perhaps?



Thank you for any suggestions, ideas, thoughts or KITA you are willing
to provide.





SYSTEM _at_k31>SELECT stmt_type, TRUNC (ntimestamp#), COUNT (*)

2 FROM SYS.fga_log$

3 WHERE SCN = 0

4 GROUP BY stmt_type, TRUNC (ntimestamp#);



STMT_TYPE TRUNC(NTI COUNT(*)

--------- ----------

2 20-JUN-09 876

2 18-JUN-09 2717

2 21-JUN-09 633

2 22-JUN-09 8819

2 19-JUN-09 2877







Lisa Koivu

Oracle Database Administrator

Starwood Vacation Ownership

Orlando, FL, USA



Always be willing to accept a temporary inconvenience for a permanent
improvement. - H. Jackson Brown, Jr.

Search Discussions

  • Koivu, Lisa at Jun 23, 2009 at 5:29 pm
    FWIW, I found it. It's a bug.



    Subject:

    Bug 5608193 - AUD$ / FGA_LOG$ has NULL or 0 SCN for DDL / DML









    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Koivu, Lisa
    Sent: Monday, June 22, 2009 4:52 PM
    To: oracle-l@freelists.org
    Subject: FGA_LOG$.SCN=0



    Hello All,



    2 node RAC, 10.2.0.4 EE, on Solaris 10



    I am examining data in FGA_LOG$ generated by my fine grained auditing
    configuration. I am surprised to see many records with SCN=0. These
    records are all inserts (STMT_TYPE=2). And as a cute little aside,
    after I saw this the database began kicking me out with ORA-3113.
    Lovely.



    Has anyone seen this before? How could Oracle just decide to give me
    garbage for the SCN? A feature, perhaps?



    Thank you for any suggestions, ideas, thoughts or KITA you are willing
    to provide.





    SYSTEM _at_k31>SELECT stmt_type, TRUNC (ntimestamp#), COUNT (*)

    2 FROM SYS.fga_log$

    3 WHERE SCN = 0

    4 GROUP BY stmt_type, TRUNC (ntimestamp#);



    STMT_TYPE TRUNC(NTI COUNT(*)

    --------- ----------

    2 20-JUN-09 876

    2 18-JUN-09 2717

    2 21-JUN-09 633

    2 22-JUN-09 8819

    2 19-JUN-09 2877







    Lisa Koivu

    Oracle Database Administrator

    Starwood Vacation Ownership

    Orlando, FL, USA



    Always be willing to accept a temporary inconvenience for a permanent
    improvement. - H. Jackson Brown, Jr.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 22, '09 at 8:52p
activeJun 23, '09 at 5:29p
posts2
users1
websiteoracle.com

1 user in discussion

Koivu, Lisa: 2 posts

People

Translate

site design / logo © 2022 Grokbase