Solution Manager

[Former Member]

Hi

We are using solution manager with oracle and I did find partitioned tables in database, so question is

does solution manager need oracle partition option to work.

Br Marko

[Former Member]

To tel you the truth, I don't think there are so many data for Solution Manager that need patition in SAP database table.

[alexander_maetzing]

Hi Marko,

good question! Do you have the names of the tables? I could compare them with our system.

Best regards, Alexander

[Former Member]

Hi

Tables and partitioons are called like this: and we are using solution manager diagnostig.

Br Marko

/BI0/F0SMD_PE2H /BI0/F0SMD_PE2H0000000266

/BI0/F0SMD_PE2H /BI0/F0SMD_PE2H0000000278

/BI0/F0SMD_EA2H /BI0/F0SMD_EA2H0000000103

/BI0/F0SMD_PE2H /BI0/F0SMD_PE2H0000000267

/BI0/F0SMD_EA2H /BI0/F0SMD_EA2H0000000092

[alexander_maetzing]

Hi Marko,

seems to be BI-tables where E2E (performance) data is stored. If they (means: SAP) decided to use partitioned tables for this purpose I would recommend to keep them as partitioned. So they expect huge amounts of data for these tables in the worst case. Note #1178655 explains a little bit more about the InfoCubes the tables are for. May be it helps.

Best regards, Alexander