SQL
>
select
name
,
type
,
value
from
v$parameter
where
name
like
'%control%'
;
NAME
TYPE
VALUE
------------------------------ ---------- ------------------------------------------------------------
control_files 2
/
u01
/
app
/
oracle
/
oradata
/
orcl
/
control01
.
ctl
,
/
u01
/
app
/
oracle
/
oradata
/
orcl
/
control02
.
ctl
,
/
u01
/
app
/
oracle
/
oradata
/
orcl
/
con
trol03
.
ctl
control_file_record_keep_time 3 7
SQL
>
select
*
from
v$controlfile_record_section
;
TYPE
RECORD_SIZE RECORDS_TOTAL RECORDS_USED
FIRST_INDEX LAST_INDEX LAST_RECID
---------------------------- ----------- ------------- ------------ ----------- ---------- ----------
DATABASE
316 1 1 0 0
0
CKPT PROGRESS 8180 11 0 0 0
0
REDO THREAD 256 8 1 0 0
0
REDO
LOG
72 16 9 0 0
20
DATAFILE 428 100 8 0 0
28
FILENAME
524 2298 21 0 0
0
TABLESPACE 68 100 7 0 0
7
TEMPORARY
FILENAME
56 100 1 0 0
1
RMAN CONFIGURATION 1108 50 0 0
0 0
LOG
HISTORY 56 292 35 1 35
35
OFFLINE
RANGE
200 163 0 0 0
0
TYPE
RECORD_SIZE RECORDS_TOTAL RECORDS_USED
FIRST_INDEX LAST_INDEX LAST_RECID
---------------------------- ----------- ------------- ------------ ----------- ---------- ----------
ARCHIVED
LOG
584 28 20 1 20
20