You can use BR*Tools for Oracle to show information about database disk volumes.
BRSPACE searches in the SAPDATA_HOME directory (on UNIX) or on all local drives (on Windows) for all available sapdata<N> directories, regardless of whether they already contain database files. It displays these in the List of database disk volumes, as described below. The column Dbfs/Lnks indicates how many database files or softlinks already exist in these directories.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS:
Choose
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) |
|
Database user/password (user) |
|
Create log file (log) |
|
Confirmation mode (confirm) |
|
Scrolling line count (scroll) |
|
Message language (language) |
|
BRSPACE command line (command) |
This shows you the BRSPACE -f dbshow -c dvinfo command that is to be executed using the current settings. |
Choose Continue.
BRGUI or BRTOOLS prompts you to start BRSPACE.
Command line:
Enter at least the following command:
brspace -f dbshow -c dvinfo
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).
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
.BRSPACE displays the List of database disk volumes:
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Device |
Disk device ID for the disk volume |
Total [KB] |
Total space on volume |
Used [%) |
Used space on volume |
Free[KB] |
Free space on volume |
Usable [KB] |
Usable space |
Dbfs/Lnks |
Number of database files or softlinks on volume |
Directory/RawDisk |
Name of directory or raw disk where volume is located |
To see more information, select one or more disk volumes.
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 disk volume:
List Entry |
Meaning |
---|---|
Disk device Id (device) |
Disk device ID for the disk volume |
Total space in KB (total) |
Total space on volume |
Used space in % (used) |
Used space on volume |
Free space in KB (free) |
Free space on volume |
Usable space in KB (usable) |
Usable space on volume (1023/1024 of free space) |
All free space in KB (afree) |
All free space on volume including space reserved for superuser |
Database file/link count (count) |
Number of database files or links on volume |
Max. still needed space in KB (needed) |
Additional space needed by autoextensible files to achieve maximum file size |
Max. missing space in KB (missing) |
Missing space if all autoextensible files had maximum file size |
If you specified multiple disk volumes, choose Continue to scroll through.
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 logs <encoded timestamp>.dbw displays the details.
For more information about how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.