on 12-17-2008 1:33 PM
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
To tel you the truth, I don't think there are so many data for Solution Manager that need patition in SAP database table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marko,
good question! Do you have the names of the tables? I could compare them with our system.
Best regards, Alexander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.