(no subject)

That getenrated redo size for this statement was 828 bytes. If an instance ecovery
is needed, redo log files will be read and your transaction will be applied. If
your transaction was committed, it will not be rolled back. Redo log files are
only read during recovery. There are some ramifications about that and I believe
that Mr. Rama Velpuri has written a few lines about those.

On 2002.07.31 01:58 oraora oraora wrote:
> Guys , my insert statement is below . explain shows 828 for redo
> size . does it mean the no of blocks ? what should be the ideal
> value for the same ? what does the value for redo size = 828
> indicate ?
>
> kindly explain me.
>
> insert into MSG_History
> (Tel,MemNo,FromMemNo,Sex,PDate,Content,S_Name,S_Age,S_Hight,S_Style,S_BloodType,S_LooksLike,Name,Age,Hight,Style,BloodType,LooksLike,REFERER,MSGID,DelFLG,RefCNT,EntPC,Opt1)
>
> values
> (:RTEL,:RMEMNO,:SID,:op_sex,SYSDATE,:MESSAGE,:NAME,:AGE,:HIGHT,:STYLE,:BLOODTYPE,:LOOKSLIKE,:RNAME,:RAGE,:RHIGHT,:RSTYLE,:RBLOODTYPE,:RLOOKSLIKE,'żżż',GetMSGID.NextVal,0,0,:EntPC,:POSTNO)
>
> Elapsed: 00:00:00.69
>
> Execution Plan
> ---------------------------------------------------------
> 0 INSERT STATEMENT Optimizer=CHOOSE (Cost=39185
> Card=6800153 B
> ytes=1523234272)
>
> 1 0 SEQUENCE OF 'GETMSGID'
>
> Statistics
> ---------------------------------------------------------
> 0 recursive calls
> 8 db block gets
> 1 consistent gets
> 1 physical reads
> 828 redo size
> 858 bytes sent via SQL*Net to client
> 1520 bytes received via SQL*Net from client
> 3 SQL*Net roundtrips to/from client
> 2 sorts (memory)
> 0 sorts (disk)
> 1 rows processed
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: oraora oraora
> INET: oraoraora_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).