Oracle 11gR1
V$CONTROLFILE displays the names of the control files.
| Column | Datatype | Description |
|
|
|
|
|
|
| Name of the control file |
|
|
| Indicates whether the file was created in the flash recovery area ( |
|
|
| Control file block size |
|
|
| Control file size (in blocks) |
V$BGPROCESS displays information about the background processes.
| Column | Datatype | Description |
|
|
| Address of the process state object |
|
|
| Process state object serial number |
|
|
| Name of this background process |
|
|
| Description of the background process |
|
|
| Error encountered |
Example:
select * from V$BGPROCESS; --Oracle 10gR2ee
| PADDR | PSERIAL# | NAME | DESCRIPTION | ERROR |
| 00 | 0 | ARB0 | ASM Rebalance 0 | 0 |
| 00 | 0 | ARB1 | ASM Rebalance 1 | 0 |
| 00000007B772D4D0 | 1 | ARC0 | Archival Process 0 | 0 |
| 00000007BE71AC18 | 1 | ARC1 | Archival Process 1 | 0 |
| 00 | 0 | ASMB | ASM Background | 0 |
| 00000007B96EA648 | 1 | CJQ0 | Job Queue Coordinator | 0 |
| 00000007B86F0380 | 1 | CKPT | checkpoint | 0 |
| 00 | 0 | CTWR | Change Tracking Writer | 0 |
| 00000007B772BD18 | 1 | DBW0 | db writer process 0 | 0 |
| 00000007BE719460 | 1 | DBW1 | db writer process 1 | 0 |
| 00 | 0 | DBW2 | db writer process 2 | 0 |
| 00 | 0 | DIAG | diagnosibility process | 0 |
| 00 | 0 | DMON | DG Broker Monitor Process | 0 |
| 00 | 0 | EMN0 | Event Monitor Process 0 | 0 |
| 00 | 0 | FMON | File Mapping Monitor Process | 0 |
| 00 | 0 | GMON | diskgroup monitor | 0 |
| 00 | 0 | INSV | Data Guard Broker INstance SlaVe Process | 0 |
| 00 | 0 | LCK0 | Lock Process 0 | 0 |
| 00000007B96E9E60 | 1 | LGWR | Redo etc. | 0 |
| 00 | 0 | LMD0 | global enqueue service daemon 0 | 0 |
| 00 | 0 | LMON | global enqueue service monitor | 0 |
| 00 | 0 | LMS0 | global cache service process 0 | 0 |
| 00 | 0 | LNS0 | Network Server 0 | 0 |
| 00 | 0 | LNS1 | Network Server 1 | 0 |
| 00 | 0 | LSP0 | Logical Standby | 0 |
| 00 | 0 | LSP1 | Dictionary build process for Logical Standby | 0 |
| 00 | 0 | LSP2 | Set Guard Standby Information for Logical Standby | 0 |
| 00000007B86EFB98 | 1 | MMAN | Memory Manager | 0 |
| 00000007B772CCE8 | 1 | MMNL | Manageability Monitor Process 2 | 0 |
| 00000007B86F0B68 | 1 | MMON | Manageability Monitor Process | 0 |
| 00 | 0 | MRP0 | Managed Standby Recovery | 0 |
| 00 | 0 | NSV0 | Data Guard Broker NetSlave Process 0 | 0 |
| 00000007BE718C78 | 1 | PMON | process cleanup | 0 |
| 00000007B96E9678 | 1 | PSP0 | process spawner 0 | 0 |
| 00000007B86F2B08 | 3 | QMNC | AQ Coordinator | 0 |
| 00 | 0 | RBAL | ASM Rebalance master | 0 |
| 00000007BE719C48 | 1 | RECO | distributed recovery | 0 |
| 00 | 0 | RSM0 | Data Guard Broker Resource Guard Process 0 | 0 |
| 00 | 0 | RSM1 | Data Guard Broker Resource Guard Process 1 | 0 |
| 00 | 0 | RVWR | Recovery Writer | 0 |
| 00000007B772C500 | 1 | SMON | System Monitor Process | 0 |
V$BACKUP_FILES displays information about all RMAN backups (both image copies and backup sets) and archived logs.
This view simulates the LIST BACKUP and LIST COPY RMAN commands. This view requires that the database be set using the DBMS_RCVMAN.SETDATABASE procedure.
| Column | Datatype | Description |
|
|
| Primary key for the backup |
|
|
| Type of the backup: · · · |
|
|
| Type of the file: · · · · · · |
|
|
| Indicates whether the backup has a retention policy different from the value for |
|
|
| If the |
|
|
|
· · If this column is null, then the backup has no KEEP options and will be made obsolete based on the retention policy. |
|
|
| Status of the backup: · · · · |
|
|
| Name of the file |
|
|
| Tag of the piece, copy, or proxy copy |
|
|
| Media ID of the piece or proxy copy |
|
|
| Recid of the record in the control file |
|
|
| Stamp of the record in the control file |
|
|
| Type of media device that stores the backup |
|
|
| Block size for the backup (in bytes) |
|
|
| Time when the backup completed |
|
|
| Indicates whether the backup piece is compressed ( |
|
|
| Indicates whether the backup piece or copy is obsolete ( |
|
|
| Size of the file (in bytes) |
|
|
| Primary key of the backup set (valid only if |
|
|
| Count of the backup set from the control file record (valid only if |
|
|
| Stamp of the backup set from the control file record (valid only if |
|
|
| Type of the backup set (valid only if · · |
|
|
| Incremental type of the backup set (valid only if |
|
|
| Number of backup pieces in the backup set (valid only if |
|
|
| Number of copies of the backup set (valid only if |
|
|
| Completion time of the backup set (valid only if |
|
|
| Status of the backup set (valid only if · · · · |
|
|
| Sum of all backup piece sizes in the backup set (valid only if |
|
|
| Indicates whether the backup pieces of the backup set are compressed ( |
|
|
| Tags of the backup set. If pieces have different tags, then all piece tags are concatenated and separated by commas. Valid only if |
|
|
| Device type of the backup set. If there is more than one device type, then they are separated by commas. Valid only if |
|
|
| Number of pieces inside the backup set (valid only if |
|
|
| Number of copies of the backup set (valid only if |
|
|
| Absolute file number of the datafile (valid only if |
|
|
| Tablespace name of the datafile (valid only if |
|
|
| System change number (SCN) of the most recent |
|
|
| Creation SCN of the control file or datafile (valid only if |
|
|
| System change number (SCN) of the most recent control file or datafile checkpoint (valid only if |
|
|
| Modification time in case of SPFILE, otherwise time when the control file or datafile was checkpointed (valid only if |
|
|
| Redo log thread number of the archived log (valid only if |
|
|
| Redo log sequence number of the archived log (valid only if |
|
|
| System change number (SCN) of the most recent |
|
|
| First SCN of the redo log (valid only if |
|
|
| Time when the Oracle Database switched into the redo log (valid only if |
|
|
| First SCN of the next redo log in the thread (valid only if |
|
|
| First timestamp of the next redo log in the thread (valid only if |
