How to check the SYSTEM and SYSAUX Tablespace for Freespace (SAP 4.7)

[Former Member]

Dear all ,

SAP 4.7 ,Win2003 , Oracle 9i

I have checked the DB Upgrade guide from Ora 9.2.0.6 to 10.2

I have execute the below command for checking the current SYSTEM tablespace and i got error.

Checking the SYSTEM and SYSAUX Tablespace for

Table space error:

D:\Ora_RDBMS\NT\I386>brspace -f dbshow -c tsinfo -s SYSTEM

'brspace' is not recognized as an internal or external command,

operable program or batch file.

the Upgrade guide also mentioned the below step to setup AUTOEXTEND ,

If the free space is less than 750 MB, use your preferred database administration tool to increase the size by using one of the following options:■

Setting the AUTOEXTEND option for the existing datafile to ON.

Kindly suggest how to check free space for SYSTEM Tablespace (SAP 4.7 version)

Regards

[anindya_bose · Accepted solution]

Satheesh

The command you are using is working fine for me.

> brspace -f dbshow -c tsinfo -s SYSTEM

1. Login to your database server ( where your oracle is running) with user id , <SID>ADM

2. Open command prompt and run the same command.

Otherwise , you can see the same information from SAP level via Tcode DB02.

Regards

Anindya

[Former Member · Accepted solution]

Hi Anindya,

I have checked from SAP level for checking the free space of SYSTEM Table space .

AUTOEXTEND is off .

Kindly suggest how to make Aotoextend is on .

Regards

[anindya_bose · Accepted solution]

You can use BRTOOLS for that.

1. Login with sidadm

2. Open command prompt, Type BRTOOLS

3. Option 2 Space Management---->Option 5 Alter Datafile.

For detail click the Link: [Autoextend|http://help.sap.com/saphelp_erp2004/helpdata/en/f1/5e863f06593a17e10000000a114084/content.htm]

Also check the links below..

Remember, AUTOEXTEND is a function of Datafile not in tablespace.

Regards

Anindya

Edited by: Anindya Bose on May 26, 2010 2:10 PM

[former_member227600 · Accepted solution]

HI,

D:\Ora_RDBMS\NT\I386>brspace -f dbshow -c tsinfo -s SYSTEM
'brspace' is not recognized as an internal or external command,
operable program or batch file.

I think brspace is not exits in your system. Please provide the version of brspace.

1:- Login as sidadm & execute the below command.

brspace -V

brtools -V

[Former Member]

The easiest way to do this is from transaction db02 - and perform a refresh. In the tablespace overview you see exactly the size, free space and if autoextend is on.

Kind regards,

Mark