Show TOC

Showing Table Partitions with BR*ToolsLocate this document in the navigation structure

Context

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:

      1. Choose Start of the navigation path Segment management Next navigation step Additional segment functions Next navigation step Show table partitions End of the navigation path.

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

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

        Table partitions (tabpart)

        -f dbshow -tp|-tabpart

        Database table (table)

        -f dbshow -t|-table

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

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

      3. Choose Continue

        BRGUI or BRTOOLS prompts you to start BRSPACE.

      4. 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).

    Note

    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 Start of the navigation path Show database segment information Next navigation step Show table partitions End of the navigation path.

  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

    Compr.

    Table partition compression

    LOBs/Cmp.

    LOB partitions types/compression

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

    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

    Partition compression (compress)

    Partition compression: yes or no

    LOBs / LOB compression (lobs_compr)

    LOBs or LOB compression

    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

    Allocated LOB space in KB (lspace)

    Amount of LOB space allocated to the table partition

    Used LOB space in KB / % (lused)

    Used LOB space in table partition/ percentage of total space used

    Pure LOB data in KB / % (ldata)

    Amount of LOB data in the table partition / 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
  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>.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.