Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    30

    Unanswered: audit database problem

    Initially, We have sybsecurity database of size = 200 mb, then we altered the sybsecurity database by 500 mb. We also extended aud_seg_01 segment. But we noticed that after 300mb the audit data segment got full. Can someone give me idea why the problem happened ? How can i utilise the full audit database size ?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    This is quite common if you choose to audit every event. Normally I pick and choose to decide what is important to business and filter out other unnecessary events.

    You might also want to truncate the audit tables if they are too old there is no business requirement to maintain.

  3. #3
    Join Date
    Nov 2003
    Posts
    30
    thanks for your answer.

    We have audit truncation job in place. But my question is that why the audit database segment was full even though it is showing 60% dataspace occupied.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •