FAQ
Hi Guys,
ORA - 65285, Oracle says it is not yet documented.
I got the following error in my alert log file.
kccrsz: denied expansion of controlfile section 19 by 1337 record(s)
the number of records is already at maximum value (65535)
control_file_record_keep_time integer 21 <-- Do I need to reduce this?
When I saw the view v$controlfile_record_section, I saw couple of
frightening messages like BACKUP CORRUPTION,COPY CORRUPTION.
SQL> select * from v$controlfile_record_section;

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

DATABASE 192 1 1 0 0

CKPT PROGRESS 4084 4 0 0 0

REDO THREAD 104 1 1 0 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

REDO LOG 72 50 3 0 0

3

DATAFILE 180 121 116 0 0

674

FILENAME 524 372 121 0 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

TABLESPACE 68 121 109 0 0

1

TEMPORARY FILENAME 56 121 1 0 0

1

RMAN CONFIGURATION 1108 50 1 0 0

1

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

LOG HISTORY 36 1134 993 1001 859

11732

OFFLINE RANGE 56 145 0 0 0

ARCHIVED LOG 584 2349 2349 1693 1692

13946

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

BACKUP SET 40 816 816 142 141

3201

BACKUP PIECE 736 699 699 585 584

3201

BACKUP DATAFILE 116 3379 3379 307 306

37325

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

BACKUP REDOLOG 76 14723 14723 10598 10597

34870

DATAFILE COPY 660 247 0 0 0

BACKUP CORRUPTION 44 185 0 0 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

COPY CORRUPTION 40 204 0 0 0

DELETED OBJECT 20 65535 65535 39631 39630

123126

PROXY COPY 852 345 0 0 0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX

------------------ ----------- ------------- ------------ -----------

LAST_RECID

RESERVED4 1 8168 0 0 0

22 rows selected.
and db_file_sequential reads show high numbers today.
buffer busy waits 5834063 19 715996
SQL*Net more data to client 9529216 0 49799
rdbms ipc message 18068313 10248897 2441471803
async disk IO 23697154 0 18305842
db file scattered read 37739602 2 3562500
SQL*Net message from client 93460966 0 8260270235
SQL*Net message to client 93461042 0 18720
db file sequential read 213371307 53 13532254.
We are on SOLARIS and 9.0.1.3 <http://9.0.1.3>.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 9, '05 at 11:31a
activeSep 9, '05 at 11:31a
posts1
users1
websiteoracle.com

1 user in discussion

Chirag DBA: 1 post

People

Translate

site design / logo © 2022 Grokbase