Home > Auditing, CMC, SAP BI > BO Audit tablespace consumes lots of space

BO Audit tablespace consumes lots of space

environment: SAP BI 4.0 SP5 P1, repositroy database: Oracle Database 11gR2

Hi,

Today I’ve noticed my BO auditing tablespace becomes rather big, when checking the tablespace details, I’ve learned all space is consumed by the event tables of the BO auditing:

Segment Name Type

Size (KB)

Extents

BO_AUDIT4.ADS_EVENT_DETAIL TABLE

2,891,776

228

BO_AUDIT4.ADS_EVENT_DETAIL_1 INDEX

1,576,960

208

BO_AUDIT4.ADS_EVENT TABLE

1,015,808

195

BO_AUDIT4.ADS_EVENT_8 INDEX

734,208

161

BO_AUDIT4.ADS_EVENT_DETAIL_2 INDEX

581,632

142

BO_AUDIT4.ADS_EVENT_DETAIL_3 INDEX

581,632

142

BO_AUDIT4.ADS_EVENT_2 INDEX

311,296

109

BO_AUDIT4.ADS_EVENT_1 INDEX

270,336

104

BO_AUDIT4.ADS_EVENT_3 INDEX

122,880

86

BO_AUDIT4.ADS_EVENT_4 INDEX

114,688

85

You can configure the contents of these tables by modifying the Auditing section of the CMC:

ScreenHunter_41 Jan. 22 11.17

In my case I’ll change the “Delete Events Older than (days) to 31. I believe this change will prevent the tablespace from growing further.

kr,

hans

Advertisements
  1. Kurien
    March 5, 2014 at 1:06 pm

    Hello recently my AUDIT tablespace is growing massive and i want to know if i can recreate this tablespace in Oracle? I am not concerned about my history, as this system is not live yet.

    • heremha
      March 6, 2014 at 9:20 am

      Hi,

      I think it’s better to change the auditing-settings in the CMC (CMC –> Audting). Here you can define how many days the auditing logs must be kept.

      Hope this helps,
      kr
      Hans

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: