You can use BR*Tools for Oracle to show information about tables.
BRGUI or BRTOOLS:
Choose Segment management Additional segment functions Show tables .
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 owner (owner) |
|
Database table (table) |
|
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 cfinfo command that is to be executed using the current settings. |
If required, in Database table you can enter the names of multiple tables by using wildcards. For more information, see Selecting Objects in Segment Management with BR*Tools.
In Database tablespace and Database owner, you can specify multiple objects but you cannot use wildcards. BRSPACE processes all the tables in the specified tablespace(s) or all tables belonging to the specified owner(s).
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 tbinfo
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 tables .
BRSPACE displays the List of database tables:
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Owner |
Table owner |
Table |
Table name |
Prt. |
Partitioned: yes or no |
Prts |
Number of partitions for partitioned table |
Mon. |
Monitoring attribute |
Par. |
Degree of parallelism |
Inds |
Number of indexes |
Tablespace |
Tablespace name |
Cmpr. |
Table compression |
LOBs/Cmp |
LOB types / LOB compression |
Analyzed |
Date last analyzed by update statistics |
Rows |
Number of rows |
Space[KB] |
Total space allocated to the table |
Used[KB:%] |
Used space in table: percentage of total space used |
Data [KB:%] |
Amount of data in the table: percentage of total space for data |
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 table:
List Entry |
Meaning |
---|---|
Partitioned table (partitioned) |
Partitioned: yes or no |
Number of partitions (partitions) |
Number of partitions for partitioned table |
Monitoring attribute (monitoring) |
Monitoring attribute |
Parallel degree (degree) |
Degree of parallelism |
Index-organized table (iot) |
Index-organized tables: yes or no |
Number of indexes (indexes) |
Number of indexes |
Table compression (compress) |
Table compression: yes or no |
LOBs / LOB compression (lobs_compr) |
LOBs or LOB compression: yes or no |
Tablespace name (tablespace) |
Tablespace name |
Last analyzed (analyzed) |
Date last analyzed by update statistics |
Sample size (sample) |
Sample size of update statistics |
Number of rows (rows) |
Number of rows |
Allocated space in KB (space) |
Total space allocated to the table |
Used space in KB / % (used) |
Used space in table / percentage of total space used |
Pure data in KB / % (data) |
Amount of data in the table / percentage of total space for data |
Allocated LOB space in KB (lspace) |
Amount of LOB space allocated to the table |
Used LOB space in KB / % (lspace) |
Used LOB space in table / percentage of total space used |
Pure LOB data in KB / % (data) |
Amount of LOB data in the table / percentage of total LOB space for data |
Number of chained rows (chained) |
Number of chained rows |
Next extent size in KB (next) |
Next extent size |
Maximum number of extents (maxexts) |
Maximum number of extents possible |
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.