Showing results for 
Search instead for 
Did you mean: 

DB02 table space overview display wrong sizes

Former Member
0 Kudos

Hi all

I get this result when I run the transaccion DB02 and table space overview

Tablespaces: Main data (Last analysis: 13.12.2009 04:00:29)

PSAPSR3 55,000.00 2,458.31

PSAPSR3700 44,980.00 2,128.50

PSAPUNDO 5,060.00 4,921.94

PSAPTEMP 2,000.00 2,000.00

SYSTEM 880 14.38

SYSAUX 340 20.75


Its displaying wrong informaction. The correct its the informatcion below and I get with a detailed analysis.

Tablespaces: Main data (Last analysis: 21.07.2010 13:04:51)

PSAPSR3 75,000.00 4,352.13

PSAPSR3700 44,980.00 1,634.44

PSAPUNDO 5,060.00 4,752.81

SYSTEM 880 10.25

SYSAUX 360 23.5

PSAPSR3USR 20 13.31


I think is for the date of the last analysis, but I dont know how to update my table space overview analysis: i will appreciate it any one cant tell me how to update the analysis.

Best regards.

Edited by: Alvaro Olmos on Jul 21, 2010 8:16 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

To refresh the table space overview do :

DB02 ->Refresh->there you will find two options choose second one

And it will refresh the tablespaces.

Or you can also schedule update stats job daily to update it automatically.



Answers (2)

Answers (2)

Former Member
0 Kudos


This is the common problem,It can be resolve by any one of the point

1) Refreshing the Database by running the program (RSORAT0D)

2) Start DB Check from DB13

3) Restart the Database



Former Member
0 Kudos

That's solved the problem, I will be try to update stats. Thanks again.

Edited by: Alvaro Olmos on Jul 22, 2010 3:22 PM

Edited by: Alvaro Olmos on Jul 22, 2010 3:28 PM