Showing Table Partitions with BR*Tools 

Use

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

Procedure

...

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

¡        BRGUI or BRTOOLS:

                                                  i.       Choose Segment management → Additional segment functions  → Show table partitions.

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 -s|-tablespace
Database owner (owner)	-f dbshow -o|-owner
Database table (table)	-f dbshow -t|-table

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 table partitions in the specified tablespace or all table partitions belonging to the specified owner(s) or table(s).

                                               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
Extended output (output)	-o|-output
Scrolling line count (scroll)	-s|-scroll
Message language (language)	-l|-language
BRSPACE command line (command)	This shows you the BRSPACE –f dbshow -c tpinfo 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 tpinfo

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 table partitions.

       2.      If you have already entered a single table name, continue with step 4.

BRSPACE displays the List of database table partitions:

List Entry	Meaning
Pos.	List sequence number
Owner	Partition owner
Table	Table name
Partition	Partition name
Tablespace	Tablespace name
Analyzed	Date last analyzed by update statistics
Rows	Number of rows
Space[KB]	Total space allocated to the table partition
Used[KB:%]	Used space in table partition: percentage of total space used (“high-water mark”)
Data [KB:%]	Amount of data in table partition: percentage of total space for data

       3.         To see more information, select one or more table partitions.

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 partition:

List Entry	Meaning
Hash partition (hash)	Hash partitions: 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 (“high-water mark”)
Pure data in KB / % (data)	Amount of data in the table / percentage of total 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

       4.      If you specified multiple table partitions, 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.