Showing Tablespaces with BR*Tools 

Use

You can use BR*Tools  for Oracle to show information about tablespaces.

Procedure

...

       1.      Start the procedure using BRGUI or BRTOOLS, or from the command line:

¡        BRGUI or BRTOOLS:

                                                  i.       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.

                                                ii.       Set the required options:

Menu Entry	Equivalent BRSPACE Command Option
BRSPACE profile (profile)	-p|-profile
Database user/password (user)	-u|-user
Database tablespace (tablespace)	-f dbshow -t|-tablespace

                                               iii.       Choose Continue.

BRGUI or BRTOOLS displays a further menu, Additional BRSPACE options for showing database information, where you specify the additional options with which you call BRSPACE.

Menu Entry	Equivalent BRSPACE Command Option
Create log file (log)	-f dbshow -l|-log
Confirmation mode (confirm)	-c|-confirm
Scrolling line count (scroll)	-s|-scroll
Message language (language)	-l|-language
BRSPACE command line (command)	This shows you the BRSPACE –f dbshow –c tsinfo command that is to be executed using the current settings.

                                               iv.       Choose Continue

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                                 v.       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.

       2.      If you have already entered the tablespace name, continue with step 4.

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
Backup	Tablespace backup status
Files/AuExt.	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
ExtSize[KB]	Maximum size the tablespace can be extended
FreeExt.	Number of free extents in tablespace
Largest[KB]	Size of largest free extents in tablespace

       3.      To see more information, select one or more tablespaces.

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
Number of files in tablespace (files)	Number of data files in tablespace
Number of autoextensible files (autoext)	Number of data files with autoextend set
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 extension size in KB (extsize)	Maximal size the tablespace can be extended
Number of free extents (freext)	Number of free extents in tablespace
Largest free extents (largest)	Size of largest extents in tablespace in KB

       4.      If you specified multiple tablespaces, choose Continue to scroll through.

Results

If you set the option Create log file (parameter –l|-log), check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays 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 Logs and Profiles with BR*Tools.