Procedure documentationShowing Tablespaces with BR*Tools

 

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

Procedure

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

    • BRGUI or BRTOOLS:

      1. Choose Start of the navigation path Space management Next navigation step Additional space functions Next navigation step Show tablespaces 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 -t|-tablespace

        Create log file (log)

        -f dbshow -l|-log

        Confirmation mode (confirm)

        -c|-confirm

        Scrolling line count (scroll)

        -s|-scroll

        Message language (language)

        -l|-language

        BRSPACE command line (command)

        This shows you the BRSPACE -f dbshow -c cfinfo command that is to be executed using the current settings.

      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 tsinfo

      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 space information Next navigation step Show tablespaces End of the navigation path.

    End of the note.

  2. If you have already entered the tablespace name, continue with step 4.

    BRSPACE displays the List of database tablespaces:

    List Entry

    Meaning

    Pos.

    List sequence number

    Tablespace

    Tablespace name

    Type

    Tablespace type: data, temp or undo

    Status

    Tablespace status: online or offline

    ExtMan.

    Tablespace extent management: local or dictionary

    SegMan.

    Segment space management: auto or manual

    Back.

    Tablespace backup status

    BigFi.

    BigFile tablespace

    Files/AuEx.

    Number of data files / number of data files with autoextend set

    Total[KB]

    Total tablespace size

    Used[%]

    Used space in tablespace

    Free[KB]

    Free space in tablespace

    MaxSize[KB]

    Maximum size the tablespace can be extended to

    FreeExt.

    Number of free extents in tablespace

    Largest[KB]

    Size of largest free extents in tablespace

  3. To see more information, select one or more tablespaces.

    Example Example

    These examples 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 tablespace:

    List Entry

    Meaning

    Tablespace type (type)

    Tablespace type: data, temp or undo

    Tablespace status (status)

    Tablespace status: online or offline

    Extent management (extent)

    Tablespace extent management - local or dictionary

    Segment space management

    (space)

    Segment space management - auto or manual

    Backup status (backup)

    Tablespace backup status

    Bigfile tablespace (bigfile)

    Bigfile tablespace

    Number of files in tablespace (files)

    Number of data files in tablespace

    Number of autoextensible files

    (autoext)

    Number of data files with autoextend set

    Tablespace compression

    (compression)

    Indicates whether tablespace compression is active

    Tablespace encryption

    (encryption)

    Indicates whether tablespace encryption is active

    Total tablespace size in KB

    (total)

    Total tablespace size

    Used space in tablespace in % (used)

    Used space in tablespace

    Free space in tablespace in KB

    (free)

    Free size in tablespace

    Maximum tablespace size in KB (maxsize)

    Maximum size of the tablespace

    Maximum extension size in KB

    (extsize)

    Maximum size the tablespace can be extended to

    Used space as to max. size in % (used)

    Used space as a percentage of maximum size

    Free space as to max. size in % (used)

    Free space as a percentage of maximum

    Allocated disk space in KB (space)

    Disk space allocated to the tablespace

    Number of free extents (freext)

    Number of free extents in tablespace

    Largest free extents (largest)

    Size of largest extents in tablespace in KB

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