on 06-10-2008 9:55 AM
Hi:
After I reorganized the tablepsace "PSAPSTABD" with datafile , I
found that the performance for visiting the tables in the PSAPSTABD is
very poor , and the tcode of maintaining the custom master data and
material master data is very slow. The tools for the reorganization is
SAPDBA 6.40 and the type of the reorganization is offline.Why? How can I solve it?
THANKS.
sap envirement: aix 5.3 + oracle 9.2.0.7 + sap r/3 46c sr2
sap kernel : 46d_ext
dbatools: I used dbatools 640 to overwrite the dbatools 620 and "sapdba" to reorg the tablepsace.
Hi:
the size of the database is 650G and the tablespace "PSAPSTABD" is 30G. I regenerated the statistic after the reorg of tablespace. In tcode st03n I found that the average database time , average frontend network time and average GUI time is over 1 s when I used the search help for material or customer data in the tcode va01 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hy,
is not easy understand the problem by your analysys...
try to analyze a single trx that you consider very slow , and through st04(oracle session) let me know in which table the trx remains in hang or in waiting...then you should see the cost estimated for the query that is doing the trx. i mean that could be an index not correctly configured....
Could be also a problem of table statistic..did you regenerate the statistic after the reorg of tablespace?
let me know also database and tablespace dimension ...
Bye bye
Nick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.