Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 – 64bit Production
With the Partitioning and Data Mining options
SQL> show parameters db_files
NAME TYPE VALUE
db_files integer 200
2.-)
sql>select * from v$controlfile_record_section;
ARCHIVED LOG 328 3456 3,170 1767 1,480 21244
BACKUP CORRUPTION 44 371 0 0 0 0
BACKUP DATAFILE 116 282 56 1 56 56
BACKUP PIECE 480 204 33 1 33 33
BACKUP REDOLOG 76 215 0 0 0 0
BACKUP SET 40 409 5 1 5 5
BACKUP SPFILE 36 454 4 1 4 4
CKPT PROGRESS 8180 11 0 0 0 0
COPY CORRUPTION 40 409 0 0 0 0
DATABASE 316 1 1 0 0 0
DATABASE INCARNATION 56 292 1 1 1 1
DATAFILE 428 100 58 0 0 324
DATAFILE COPY 404 202 187 1 187 187
DATAFILE HISTORY 312 52 0 0 0 0
DELETED OBJECT 20 8180 3,041 7369 2,229 3047
FILENAME 268 2298 63 0 0 0
FLASHBACK LOG 84 2048 0 0 0 0
GUARANTEED RESTORE POINT 212 2048 0 0 0 0
INSTANCE SPACE RESERVATION 28 1055 1 0 0 0
LOG HISTORY 56 1168 1,168 767 766 11862
MTTR 100 8 1 0 0 0
OFFLINE RANGE 200 163 0 0 0 0
PROXY COPY 596 247 0 0 0 0
RECOVERY DESTINATION 180 1 0 0 0 0
REDO LOG 72 16 4 0 0 126
REDO THREAD 256 8 1 0 0 0
REMOVABLE RECOVERY FILES 32 1000 0 0 0 0
RESTORE POINT 212 2083 0 0 0 0
RMAN CONFIGURATION 1108 50 3 0 0 13
RMAN STATUS 116 141 47 1 47 47
STANDBY DATABASE MATRIX 400 10 10 0 0 0
TABLESPACE 68 100 13 0 0 19
TEMPORARY FILENAME 56 100 5 0 0 10
THREAD INSTANCE NAME MAPPING 80 8 8 0 0 0
3.-)como saco el terdr punto (limite de open files en AIX)