DB02 table space overview display wrong sizes

[Former Member]

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

PSAPSR3USR 20 14

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

PSAPTEMP 0 0

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

[Former Member · Accepted solution]

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.

Regards,

Shivam

[Former Member]

Hi...

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

Cheers

KHS

[Former Member]

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