Table Space showing wrong data in ST04

[Former Member]

Hi All,

We have oracle 10.2.0.4 installed and SAP SRM with latest kernel.

When i login to SAP and check tablespace in st04 / DB02 it is showing PSAPSR3 TAble space auto extend as on, but i have deactivated the auto extend in all the table space.

And for the same thing in DB check it is showing as CRITICAL_TABLESPACE having auto extend on as warning.

Please let me know as it is creating problem in daily monitoring of the system

Thanks & Regards,

Balaji.S

[anindya_bose · Accepted solution]

Can you once again check the value for max_extn for those table space?

This error by brconnect is checked by calculating max_extn.

You can also check Note 849484 - New CRITICAL_TABLESPACE check condition in BRCONNECT

Thanks and Regards

Anindya

[Former Member]

Thanks for the inputs i found there are still some data files in auto extend mode ON.

I am working on the same. Thanks for the info provided.

Regards,

Balaji.S

[fidel_vales]

Hi,

Keeping in mind that the autoextend is an attribute of the datafile and not of the TABLESPACE, it is possible that the tablespace has at least one file with autoextend on

check it with:

select file_name from dba_data_files where tablespace_name = '<yourtbs>' and autoextensible = 'YES'

[Former Member]

Hi,

Can you check the same from BRTOOLS. Can you refresh once by program rsoratod & try. Also check by using tcode DB02OLD

What is your BR*Tool patch level?

Thanks

Sushil