From oracle-l-bounce@freelists.org Fri Sep 9 11:31:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j89GVULP006515 for ; Fri, 9 Sep 2005 11:31:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j89GUwIP006378 for ; Fri, 9 Sep 2005 11:30:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E6E801EB0F4; Fri, 9 Sep 2005 11:29:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00400-02; Fri, 9 Sep 2005 11:29:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A9A21EB449; Fri, 9 Sep 2005 11:29:42 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=psOtmIhDdcL9lb9VBmZ/YibPV2MYu8hlsPn5FTGmdDJmHJDRUNBLybczEDCgU6eVwcC20Iqtcn86mKmBAF2vNam+buuEPN33NuD3iboMEaa1DJGr0WS/eqhtn4K6hyBaovn2O9kCgngGfqxdnTUFCNEIs4Ubq40ymBWYTxOnLkk= Message-ID: <1a3629600509090927359e9d6@mail.gmail.com> Date: Fri, 9 Sep 2005 12:27:49 -0400 From: Chirag DBA To: Oracle-L Freelists , askdba@freelists.org Subject: URGENT - ORA - 65285 and controlfile - db_file_sequential waits error Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4956_25159269.1126283269172" X-archive-position: 25226 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.6 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_MESSAGE,NORMAL_HTTP_TO_IP,UPPERCASE_25_50 autolearn=no version=2.63 ------=_Part_4956_25159269.1126283269172 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Guys, ORA - 65285, Oracle says it is not yet documented. I got the following error in my alert log file.=20 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=20 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 ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- DATABASE 192 1 1 0 0 0 CKPT PROGRESS 4084 4 0 0 0 0 REDO THREAD 104 1 1 0 0 0 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- REDO LOG 72 50 3 0 0 3 DATAFILE 180 121 116 0 0 674 FILENAME 524 372 121 0 0 0 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX ------------------ ----------- ------------- ------------ -----------=20 ---------- 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 ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- LOG HISTORY 36 1134 993 1001 859 11732 OFFLINE RANGE 56 145 0 0 0 0 ARCHIVED LOG 584 2349 2349 1693 1692 13946 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX ------------------ ----------- ------------- ------------ -----------=20 ---------- 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 ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- BACKUP REDOLOG 76 14723 14723 10598 10597 34870 DATAFILE COPY 660 247 0 0 0 0 BACKUP CORRUPTION 44 185 0 0 0 0 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- COPY CORRUPTION 40 204 0 0 0 0 DELETED OBJECT 20 65535 65535 39631 39630 123126 PROXY COPY 852 345 0 0 0 0 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX ------------------ ----------- ------------- ------------ -----------=20 ---------- LAST_RECID ---------- RESERVED4 1 8168 0 0 0 0 22 rows selected. and db_file_sequential reads show high numbers today.=20 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 . ------=_Part_4956_25159269.1126283269172 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 frig= htening messages like BACKUP CORRUPTION,COPY CORRUPTION.
 
SQL> select * from v$controlfile_record_section;

TYPE           &n= bsp;   RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_IN= DEX
------------------ ----------- ------------- ------------ ----------= - ----------
LAST_RECID
----------
DATABASE    = ;            &n= bsp;  192          &= nbsp;  1          &n= bsp; 1           0 &= nbsp;        0
         0

CKPT PROGRESS          = ;   4084         &nb= sp;   4         &nbs= p;  0           0&nb= sp;         0
   =       0

REDO THREAD          &= nbsp;     104       =       1       &= nbsp;    1        &n= bsp;  0          0
&nb= sp;        0


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
REDO LOG   &= nbsp;           &nbs= p;    72        &nbs= p;   50         &nbs= p;  3           0&nb= sp;         0
         3

DATAFILE          &nbs= p;        180    &nb= sp;      121      &n= bsp;   116         &= nbsp; 0          0
 &n= bsp;     674

FILENAME          &nbs= p;        524    &nb= sp;      372      &n= bsp;   121         &= nbsp; 0          0
 &n= bsp;       0


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
TABLESPACE   = ;            &n= bsp;  68           1= 21          109  &nb= sp;        0    &nbs= p;     0
         1

TEMPORARY FILENAME         = 56           121 &n= bsp;          1  &nb= sp;        0    &nbs= p;     0
       &= nbsp; 1

RMAN CONFIGURATION        1108 &= nbsp;          50  &= nbsp;         1   &n= bsp;       0     &nb= sp;    0
        = 1


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
LOG HISTORY  &nbs= p;            &= nbsp; 36          1134 &n= bsp;        993    &= nbsp;   1001        859
     11732

OFFLINE RANGE          = ;     56        = ;   145         &nbs= p;  0           0&nb= sp;         0
   =       0

ARCHIVED LOG          =      584        = ;  2349         2349 &nbs= p;      1693       1= 692
     13946


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
BACKUP SET   = ;            &n= bsp;  40           8= 16          816  &nb= sp;      142      &n= bsp; 141
      3201

BACKUP PIECE          =      736        = ;   699          699=          585    = ;    584
      3201

BACKUP DATAFILE         &nb= sp;  116          3379&nb= sp;        3379    &= nbsp;    307        306     37325


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
BACKUP REDOLOG  &= nbsp;           76 &= nbsp;       14723    &nbs= p;   14723       10598  &= nbsp;   10597
     34870

DATAFILE COPY          = ;    660        &nbs= p;  247          &nb= sp; 0           0 &n= bsp;        0
    = ;     0

BACKUP CORRUPTION         &= nbsp; 44           185&nb= sp;           0 &nbs= p;         0    = ;      0
      &n= bsp;  0


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
COPY CORRUPTION  =            40  =          204    = ;        0     =       0       &= nbsp;  0
         0

DELETED OBJECT         &nbs= p;    20         655= 35        65535    &= nbsp;  39631      39630
   = 123126

PROXY COPY          &n= bsp;      852      &= nbsp;    345        =     0         &= nbsp; 0          0
 &n= bsp;       0


TYPE          &nbs= p;    RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAS= T_INDEX
------------------ ----------- ------------- ------------ ------= ----- ----------
LAST_RECID
----------
RESERVED4   =             &nb= sp;    1        &nbs= p; 8168            0=            0  &= nbsp;       0
         0


22 rows selected.
 
and db_file_sequential reads show high numbers today.
 
buffer busy waits         = ;            &n= bsp;            = ;    5834063        =      19      715996
SQL*Net= more data to client         &= nbsp;           &nbs= p;      9529216      = ;        0     =   49799
rdbms ipc message       =             &nb= sp;            =      18068313       10248= 897  2441471803
async disk IO         &nbs= p;            &= nbsp;           &nbs= p;      23697154     &nbs= p;        0    18305842db file scattered read        &nb= sp;            =            37739602 =              2&= nbsp;    3562500
SQL*Net message from client  &= nbsp;           &nbs= p;            934609= 66            &= nbsp; 0  8260270235
SQL*Net message to client       &nbs= p;            &= nbsp;        93461042   &= nbsp;          0  &n= bsp;    18720
db file sequential read   &n= bsp;            = ;            &n= bsp; 213371307          &= nbsp;  53    13532254.
 
We are on SOLARIS and 9.0.1.3.
------=_Part_4956_25159269.1126283269172-- -- http://www.freelists.org/webpage/oracle-l