table space

[Former Member]

Hi

We have ARFCSSTATE table size as 20 gig

I have removed the entries in ARFCSSTATE table using a report

now ARFCSSTATE table is empty

But its not showing up

I know for this we need to use brtools

Can anyone tell me what options should I select in BRTOOLS

thanks

Jameel

[Former Member · Accepted solution]

Hi Jammel,

If you are on oracle 9i then you can reorganize online no need to shut down SAP.

But reorganizing tables will only show increase in the Free space and total DB size will be same in DB02.

Think of reorganizing tablespace for getting desired changes.

Regards

Umesh

[Former Member · Accepted solution]

Can you let me know what exactly to do

As I have explained above I deleted the entries from the arfcsstate

Now When I check with db02 tables and spaces spacestatistics it of the same size

I need to free up that space

....

...

I am following the above resolution to show free space.....

Is it like I need to reorganize tables then reorganise tablespace

If it is ...how to reorganise tablespace

thanks

Jameel

[Former Member · Accepted solution]

Hello,

I think you need only to reorganize the table.

You can reorganize a table like that:

rspace -f tbreorg -t <table_name>

You can reorganize the tablespace of the tables like that:

brspace -f tbreorg -s <Tablespace_Name> -t "*":

All tables except Tables with LONG Types (for 9i Databases)

See please the SAP Notes: 541538 and 646681 - Reorganizing tables with BRSPACE

Best regards

K.Baran

[former_member204746 · Accepted solution]

Jameel,

DB02 statistics/history is calculated twice a day at 7am and 7pm by job SAP_COLLECTOR._FOR_PERFMONITOR. so, wait until the next day before check table statistics in DB02.

[Former Member · Accepted solution]

hi baran

I tried following the stpes u mentioned

At the final step ...where we provide table owner ..psswd...

all details its not continuing

'...

can i get some more assistance

thanks

Jameel

[Former Member]

thanks mho

thanks umesh and

thanks baran

thanks all

i AM able to do that now

[Former Member]

.

null

[Former Member]

Hi Jameel,

1) If you have deleted all the table entries of ARFCSSTATE then you can use TRUNCATE table command to free up the space.

2) If you have not deleted all the entries then you can Reorganize table online by brtools pls follow link http://help.sap.com/saphelp_nw70/helpdata/en/1b/4e8f0d38a8f4419436d608a36b6581/frameset.htm

If table contains the LONG or RAW fields then refer note no 646681.

This will free up the space and you can see it in %free space in DB02.

also you can see the reduced table size

3) If you want to reduce the Database size then you need to offline reorganize Tablespace by sapdba/brtools.

Hope this is helpful

Regads

Umesh

[Former Member]

Please be aware that when you are performing online reorganization of either the table or tablespace, sufficient space is available as a temporary container for the objects before they are moved to the new location. Its always a good practise to perform it during low activity on the system.

Offline reorganization (export / import) does not need free space to be available at the DB level, but will need space at OS level to dump the table and also a downtime to complete the tasks.

[Former Member]

Hi Jameel

brtools -> 3 - Segment management -> 1 = Reorganize tables ->

5 ~ Table owner (owner) ............ [SAPSID] <- could also be SAPR3/SAPSR3

6 ~ Table names (table) ............ [ARFCSSTATE]

Make sure:

- you have a valid database backup

- you tested the procedure on a non-productive system

- you have read SAP Note 646681

Best regards