Skip to Content
0
Former Member
Apr 21, 2010 at 06:31 AM

Inquiry: Brspace command for Oracle-based SAP system

48 Views

Hi all,

I have some inquiry with the command brspace for Oracle-based SAP system.

I been using the command [brspace -function tbreorg -action reorg -tablespace "<tablespace name>" -table "<table name>" -mode online] to re-org my database after deletion of workflow log.

However, in my DEV system, I have a number of create-client-delete-client and the harddisk space used is getting quite large.

I wanted to free some space in Oracle tablespace, and i am wondering if:

1. Can I use the command above, remove the -table to re-org the table as a whole?

2. Or the tablespace's free area will auto be available after I delete a client?

In another note,

3. Someone here mention that re-index database would improve the database responses after a client-deletion. Is it better to re-index the database periodically or can I safely ignore this until the database get extremely sluggish (this refer to DEV-based system)?

Thank you