1. As oraSID, execute command BRTOOLS.
> brtools
2. Choose 2 – Space management.
------------------------------------------------------------------------------- BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
3. Choose 7 – Additional space functions.
------------------------------------------------------------------------------- Database space management 1 = Extend tablespace 2 - Create tablespace 3 - Drop tablespace 4 - Alter tablespace 5 - Alter data file 6 - Move data file 7 - Additional space functions 8 - Reset program status Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
4. Choose 1 = Show tablespaces.
------------------------------------------------------------------------------- Additional database space functions 1 = Show tablespaces 2 - Show data files 3 - Show redolog files 4 - Show control files 5 - Show disk volumes Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
5. Select 5 ~ Database tablespace (tablespace) if you want to display only specific tablespace or you can just continue (press c for continue) to display all the tablespaces.
------------------------------------------------------------------------------- BRSPACE main options for showing database information 1 - BRSPACE profile (profile) ........ [initSID.sap] 2 - Database user/password (user) .... [/] 3 # Database instance (instance) ..... [] 4 # Database parameter (parameter) ... [] 5 ~ Database tablespace (tablespace) . [] 6 # Database file (file) ............. [] 7 # Database owner (owner) ........... [] 8 # Database tables (table) .......... [] 9 # Database indexes (index) ......... [] 10 # Table partitions (tabpart) ....... [] 11 # Index partitions (indpart) ....... [] Standard keys: c - cont, b - back, s - stop, r - refr, h - help -------------------------------------------------------------------------------
6. Select “c” again to continue.
-------------------------------------------------------------------------------
Additional BRSPACE options for showing database information
1 - Create log file (log) .......... [no]
2 - Confirmation mode (confirm) .... [yes]
3 # Extended output (output) ....... [no]
4 - Scrolling line count (scroll) .. [20]
5 - Message language (language) .... [E]
6 - BRSPACE command line (command) .
[-p initSID.sap -s 20 -l E -f dbshow -c tsinfo]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
7. Select “c” again.
BR0259I Program execution will be continued... BR0291I BRSPACE will be started with options '-p initSID.sap -s 20 -l E -f dbshow -c tsinfo' BR0280I BRTOOLS time stamp: 2013-07-19 02.21.35 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
8. You will find the list of tablespace as below.
-------------------------------------------------------------------------------
List of database tablespaces
Pos. Tablespace Type Status ExtMan. SegMan. Back. BigFi. Files/AuEx.
Total[KB] Used[%] Free[KB] MaxSize[KB] ExtSize[KB] FreeExt.
1 - PSAPSR3 DATA ONLINE LOCAL AUTO NO NO 332/0
9179136000 95.95 371718528 9179136000 0 167
2 - PSAPSR3702 DATA ONLINE LOCAL AUTO NO NO 3/0
80076800 86.58 10743168 80076800 0 41
3 - PSAPSR3USR DATA ONLINE LOCAL AUTO NO NO 1/0
16384000 72.11 4569920 16384000 0 4
4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO NO 4/0
108544000 0.00 108538880 108544000 0 0
5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO NO 4/0
99328000 0.23 99095552 99328000 0 13156
6 - SYSAUX DATA ONLINE LOCAL AUTO NO NO 3/0
6144000 47.30 3237760 6144000 0 119
7 - SYSTEM DATA ONLINE LOCAL MANUAL NO NO 2/0
4096000 69.83 1235712 4096000 0 2
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
