You can use BR*Tools for Oracle to show information about data files.
BRGUI or BRTOOLS:
Choose Space management Additional space functions Show data files .
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) |
|
Database tablespace (tablespace) |
|
Database file (file) |
|
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 dfinfo command that is to be executed using the current settings. |
Choose Continue
BRGUI or BRTOOLS prompts you to start BRSPACE.
Choose Continue to start BRSPACE.
Command line:
Enter at least the following command:
brspace -f dbshow -c dfinfo
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 Show database space information Show data files .
BRSPACE displays the List of database files:
List Entry |
Meaning |
---|---|
Pos. |
List sequence number |
Tablespace |
Tablespace name for the data file |
Status |
Data file status: online, offline, system or recover |
Type |
Data file type: file system, raw device, or ASM file |
File |
Data file name |
Id. |
Data file ID |
Size[KB] |
Data file size |
Device |
Disk device ID |
Back. |
Backup status |
AuExt. |
Whether data file has autoextend set |
MaxSize[KB] |
Maximum size of the data file |
IncrSize[KB] |
Data file increment size |
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 data file:
List Entry |
Meaning |
---|---|
Data file_id (Id) |
Data file ID |
Data file status (status) |
Data file status: online, offline, system or recover |
Tablespace name (tablespace) |
Tablespace name for the data file |
Backup status (backup) |
Backup status |
Data file type (type) |
Data file type: file system, raw device, or ASM file |
Disk device Id (device) |
Disk device ID |
Data file size in KB (size) |
Data file size |
File autoextend mode (autoextend) |
Whether data file has autoextend set |
Maximum file size in KB (maxsize) |
Maximum size of the data file |
File increment size in KB (incrsize) |
Data file increment size |
Allocated disk space in KB (space) |
Disk space allocated to the data file |
Data file creation time (crtime) |
Creation time stamp of the data file |
Data file creation SCN (crscn) |
Creation system change number (SCN) of the data file |
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.