You can use BR*Tools for Oracle to show information about segment extents.
BRGUI or BRTOOLS:
Choose Segment management Additional segment functions Show segment extents .
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) |
|
Database file (file) |
|
Database owner (owner) |
|
Database table (table) |
|
Database index (index) |
|
Table partitions (tabpart) |
|
Index partitions (indpart) |
|
Create log file (log) |
|
Confirmation mode (confirm) |
|
Extended output (output) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshow -c seinfo command that is to be executed using the current settings. |
If required, in Database table or Database Index you can enter the names of multiple tables or indexes by using wildcards. For more information, see “Selecting Objects” in Segment Management with BR*Tools.
In Database tablespace, Database file, and Database owner, you can specify multiple objects but you cannot use wildcards.
BRSPACE processes all segment extents for the specified objects.
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 seinfo
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 segment information Show segment extents .
BRSPACE displays the List of segment extents:
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Owner |
Segment owner |
Type |
Segment type: table, index, tabpart, indpart, lobseg, lobind, cluster, rollback, temp, cache |
Segment |
Segment name |
Partition |
Partition name if applicable |
Tablespace |
Tablespace name |
Extent Id |
Extent ID |
File Id |
File ID |
Block Id |
Block ID |
Size[KB] |
Extent size |
These examples only 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 extent of segment:
List Entry |
Meaning |
---|---|
Segment type (type) |
Segment type: table, index, tabpart, indpart, lobseg, lobind, cluster, rollback, temp, cache |
Tablespace name (tablespace) |
Tablespace name |
Data file (file) |
Data file name |
Extent Id. (extent_id) |
Extent ID |
File Id. (file_id) |
File ID |
Relative file number (file_no) |
Relative file number |
Block Id. (block_id) |
Block ID |
Extent size in KB (size) |
Extent size |
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.