Archive

Archive for the ‘CMC’ Category

BO Audit tablespace consumes lots of space

January 22, 2013 2 comments

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