0

We have one system status table A in DB and Application process select and update on that table for 4 times in one seconds so huge audit logs are generating.

So I have tried 

NOAUDIT ALL on schema.A;

  • but still audit logs are generated why?

  • and how do I find out previously fired Audit statement?

J. Chomel
  • 8,193
  • 15
  • 41
  • 69
pramod
  • 123
  • 1
  • 3
  • 9

1 Answers1

0

  • You must restart the sessions for them to stop logging in the trail.

  • Check that you have no trigger on that table who would do the auditing above Oracle's mechanism

J. Chomel
  • 8,193
  • 15
  • 41
  • 69