Show TOC

Showing Database Parameters with BR*ToolsLocate this document in the navigation structure

Context

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

Procedure

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

      1. Choose Start of the navigation path Instance Management  Next navigation step Additional instance functions Next navigation step Show database parameters 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 parameter (parameter)

        -f dbshow -p|-parameter

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

      3. Choose Continue to start BRSPACE.

    • Command line:

      Enter at least the following command:

      brspace -f dbshow -c dbparam

      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 instance information Next navigation step Show database parameters End of the navigation path.

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

    BRSPACE displays the List of database parameters:

    List Entry

    Meaning

    Pos.

    List sequence number

    Parameter

    Parameter name

    Modif.

    Modification attributes:

    • no: unmodifiable

    • yes: modifiable for the lifetime of an instance

    • spfile: modifiable in spfile

    • both: modifiable in spfile and for the lifetime of an instance

    Spfile

    Whether parameter is specified in spfile:

    • yes: parameter is specified

    • no: parameter is not specified

    • inst: parameter is specified with an instance-specific value

    Inst.

    Database instance the parameter is set for:

    “*” means all instances

    Deft.

    Whether parameter has default value, yes / no

    Value

    Current parameter value

  3. To see more information, select one or more database parameters.
    Example

    These examples apply only 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 database parameter:

    List Entry

    Meaning

    Parameter description (desc)

    Parameter description from V$PARAMETER

    Parameter type (type)

    Type of parameter: boolean, string, integer, file

    Modifiable attribut (modif)

    See Modif. in table above

    Defined in spfile (spfile)

    Whether parameter is specified in spfile:

    • yes: parameter is specified

    • no: parameter is not specified

    • inst: parameter is specified with an instance-specific value

    Database instance (instance)

    See Inst. in table above

    Default value (default)

    Whether parameter has default value, yes / no

    Parameter value (value)

    Current parameter value

    Value in spfile (spfval)

    Parameter value stored in spfile

    Comment on update (comment)

    Your comment on the parameter update

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