Space issue in tablespaces.

[Former Member]

Dear All,

There a space utilization of more than 90% in one of the tablespace in development system.

PSAPSR3700 is having 99%.

PSAPSR3 is having 86%.

sugesst me what to do. I have moved one of the datafile of tablespace PSAPSR3700 to other location still is shows 99%.

Please tell how to go forward

Thanks

Bhaskar

[stefan_koehler · Accepted solution]

Hello Bhaskar,

moving is not extending the tablespace. You need to extend your tablespace by adding a new datafile or activating autoextend on the datafiles of tablesapce PSAPSR3700.

http://help.sap.com/saphelp_nw70/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

If you get these values out of db02/db02n .. you maybe will see the new sizes the next day (because of the data gathering of db02/db02n).

Regards

Stefan

[Former Member · Accepted solution]

Dear Stefan,

we have autoextend on for the tablespaces PSAPSR3700 and PSAPSR3.

we are getting waring messeges when i do the database check run the server using brtools( brconnect -u / -c -f check ) command.

following is the warring message:

CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 6) 40960000 KB (> 20423316 KB)

CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 7) 40960000 KB (> 19684152 KB)

CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 5 files on disk 😎 40960000 KB (> 12045128 KB)

CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 3 files on disk 9) 24576000 KB (> 14031632 KB)

CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 6) 25067520 KB (> 20423316 KB)

CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 7) 25169920 KB (> 19684152 KB)

CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 4 files on disk 😎 24268800 KB (> 12045128 KB)

CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 6 files on disk 9) 37744640 KB (> 14031632 KB)

[stefan_koehler · Accepted solution]

Hello Bhaskar,

this error message are coming up, if you have turn AUTOEXTEND on, but your datafiles would not fit into the filesystem, if they reach the maximum size (MAXSIZE).

How much space is missing?

There is a section in the brconnect check logfile ... that looks like this:

BR0982I Database disk volumes

Directory / Raw disk Device Total[KB] Free[KB] Used[%] MaxNeed[KB] MaxMiss[KB]

/oracle/<SID>/sapdata1 2293768 789053440 206260 99.97 20312 0

/oracle/<SID>/sapdata2 2293769 851968000 115432424 86.45 112025348 0

/oracle/<SID>/sapdata3 2293773 736624640 4744016 99.36 4469116 0

You will find the additional space in the column "MaxMiss[KB]" that is needed to extend the datafiles to MAXSIZE.

For more information take a look at the documentation:

http://help.sap.com/saphelp_nw70/helpdata/en/4d/a241ecee0d11d5996600508b5d5211/content.htm

Regards

Stefan

[Former Member · Accepted solution]

Dear Stefan,

Thanks for your reply.

this is the jest of the log of brconnect below, please suggest what step to be taken:

Directory / Raw disk Device Total[KB] Free[KB] Used[%] MaxNeed[KB] MaxMiss[KB

E:\oracle\MRP\102 4 52228060 33568768 35.73 0 0

G:\oracle\MRP 6 52228060 20423188 60.90 0 0

G:\ORACLE\MRP\ORIGLOGA 6 52228060 20423188 60.90 123143794 75197932

G:\ORACLE\MRP\ORIGLOGB 6 52228060 20423188 60.90 123143794 75197932

G:\ORACLE\MRP\SAPDATA1 6 52228060 20423188 60.90 123143794 75197932

H:\ORACLE\MRP\MIRRLOGA 7 52228060 19684152 62.31 102604882 54637768

H:\ORACLE\MRP\MIRRLOGB 7 52228060 19684152 62.31 102604882 54637768

H:\ORACLE\MRP\SAPDATA2 7 52228060 19684152 62.31 102604882 54637768

I:\ORACLE\MRP\SAPDATA3 8 52228060 12045128 76.94 102400080 54432952

J:\ORACLE\MRP\SAPDATA4 9 52228060 14031632 73.13 96256088 48289008

G:\oracle\MRP\saparch 6 52228060 20423188 60.90 0 0

G:\oracle\MRP\sapbackup 6 52228060 20423188 60.90 0 0

G:\oracle\MRP\sapcheck 6 52228060 20423188 60.90 0 0

G:\oracle\MRP\sapreorg 6 52228060 20423188 60.90 0 0

F:\oracle\MRP 5 52228060 30511820 41.58 0 0

Please guide me.

Thanks n regards

Bhaskar

[Former Member · Accepted solution]

Dear Stefan,

Do I need to manually add datafile as specified in MAXMISS; in other logical drive or I need to move some the datafile of SAPDATA<n> to a larger logical drive.

please guide me.

Thanks

Bhaskar

[stefan_koehler · Accepted solution]

Hello Bhaskar,

MAXMISS shows the missing space in the filesystem, that is needed to reach the MAXSIZE of all corresponding datafiles.

So you have to extend your filesystem or move your datafiles from one sapdata to another.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Thanks for your reply....

I will move some of the datafile of those SAPDATA<n> to other larger harddisk (logical drive).

thanks for your support and help.

thanks n regards

Bhaskar

[Former Member · Accepted solution]

You need check the size of autoextend and maxsize, decreased autoextend and then resize the datafile. Maybe you need add more space, HD, to DB.

[Former Member]

Hi,

Have you refreshed your database to show correct result ?

If not got to DB02 and click on Refresh.

Regards,

Suhas