Procedure documentationShowing Segment Extents with BR*Tools

 

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

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 segment extents 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 file (file)

        -f dbshow -f|-file

        Database owner (owner)

        -f dbshow -o|-owner

        Database table (table)

        -f dbshow -t|-table

        Database index (index)

        -f dbshow -i|-index

        Table partitions (tabpart)

        -f dbshow -tp|-tabpart

        Index partitions (indpart)

        -f dbshow -ip|-indpart

        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 seinfo command that is to be executed using the current settings.

        Note Note

        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.

        End of the note.

        BRSPACE processes all segment extents for the specified objects.

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

    Note 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 segment extents End of the navigation path.

    End of the note.

    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

  2. To see more information, select one or more segment extents.

    Example Example

    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.

    End of the example.

    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

  3. If you specified multiple segment extents, choose Continue to scroll through.

Result

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.