You can use BR*Tools for Oracle to show information about tablespaces.
BRGUI or BRTOOLS:
Choose Space management Additional space functions Show tablespaces .
BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.
Set the required options:
Menu Entry |
Equivalent BRSPACE Command Option |
---|---|
BRSPACE profile (profile) |
|
Database user/password (user) |
|
Database tablespace (tablespace) |
|
Create log file (log) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshow -c cfinfo command that is to be executed using the current settings. |
Choose Continue
BRGUI or BRTOOLS prompts you to start BRSPACE.
Choose Continue to start BRSPACE.
Command line:
Enter at least the following command:
brspace -f dbshow -c tsinfo
You can enter more parameters if required. For more information, see BRSPACE -f dbshow.
BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log if you set the option Create log file (parameter -l|-log).
If you started BRSPACE from the command line without the information class name ( -c|-class) - that is, with brspace -f dbshow - BRSPACE displays the Show database information main menu.
Choose Show database space information Show tablespaces .
BRSPACE displays the List of database tablespaces:
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Tablespace |
Tablespace name |
Type |
Tablespace type: data, temp or undo |
Status |
Tablespace status: online or offline |
ExtMan. |
Tablespace extent management: local or dictionary |
SegMan. |
Segment space management: auto or manual |
Back. |
Tablespace backup status |
BigFi. |
BigFile tablespace |
Files/AuEx. |
Number of data files / number of data files with autoextend set |
Total[KB] |
Total tablespace size |
Used[%] |
Used space in tablespace |
Free[KB] |
Free space in tablespace |
MaxSize[KB] |
Maximum size the tablespace can be extended to |
FreeExt. |
Number of free extents in tablespace |
Largest[KB] |
Size of largest free extents in tablespace |
These examples apply to input in character mode.
To select the first three entries in the list, enter 1-3.
To select the first and third entries, enter 1,3.
To select the first three entries and the fifth, enter 1-3,5.
To select all entries, enter 0.
BRSPACE displays Information about tablespace:
List Entry |
Meaning |
---|---|
Tablespace type (type) |
Tablespace type: data, temp or undo |
Tablespace status (status) |
Tablespace status: online or offline |
Extent management (extent) |
Tablespace extent management - local or dictionary |
Segment space management (space) |
Segment space management - auto or manual |
Backup status (backup) |
Tablespace backup status |
Bigfile tablespace (bigfile) |
Bigfile tablespace |
Number of files in tablespace (files) |
Number of data files in tablespace |
Number of autoextensible files (autoext) |
Number of data files with autoextend set |
Tablespace compression (compression) |
Indicates whether tablespace compression is active |
Tablespace encryption (encryption) |
Indicates whether tablespace encryption is active |
Total tablespace size in KB (total) |
Total tablespace size |
Used space in tablespace in % (used) |
Used space in tablespace |
Free space in tablespace in KB (free) |
Free size in tablespace |
Maximum tablespace size in KB (maxsize) |
Maximum size of the tablespace |
Maximum extension size in KB (extsize) |
Maximum size the tablespace can be extended to |
Used space as to max. size in % (used) |
Used space as a percentage of maximum size |
Free space as to max. size in % (used) |
Free space as a percentage of maximum |
Allocated disk space in KB (space) |
Disk space allocated to the tablespace |
Number of free extents (freext) |
Number of free extents in tablespace |
Largest free extents (largest) |
Size of largest extents in tablespace in KB |
If you set the option Create log file (parameter -l|-log), check the results in the BRSPACE logs.
The summary log space<DBSID>.log displays the return code.
The detail log s<encoded timestamp>.dbw displays the details.
For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.