Showing Database Parameters with BR*Tools

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

Procedure

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

BRGUI or BRTOOLS:

Choose Instance Management Show database parameters .

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

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.

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 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 Show database instance information Show database parameters .

End of the note.

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

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

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

End of the example.

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

If you specified multiple parameters, 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 Logs and Profiles with BR*Tools.