cancel
Showing results for 
Search instead for 
Did you mean: 

the performance of the tables in the PSAPSTABD is poor

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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 .

nicola_blasi
Active Participant
0 Kudos

Hy

when you start the VA01 , open a new windows and go to st04---details analysys ---oracle session and try to check the select that the trx is doing slowly. then click on explain and copy and paste here. i think is an index problem. I had the same with trx va05.

let me know

bye

Nick

nicola_blasi
Active Participant
0 Kudos

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