RE: insert nologging parallel/noparallel and archiving

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Wed, 14 Aug 2002 09:18:49 -0800
Message-ID: <F001.004B4DEC.20020814091849@fatcity.com>

In the second case you are also selecting from sequence which might have generated the logs. Use logminer and get the details of what was logged.

Naveen

-----Original Message-----
Sent: Wednesday, August 14, 2002 10:14 PM To: Multiple recipients of list ORACLE-L

Rick,

These are the transactions:

This one does not create any logs (nothing was written into arch directory);

insert /*+ parallel (egurev1.offr,16) */ into egurev1.offr
nologging
(select

 a.PRDCT_ID   ,
 a.OFFR_RSPNS_TYP_CDE ,
 a.PRTY_TYP_NBR ,
 a.PREFR_IND     ,
 a.OFFR_CNT       ,
 a.PROC_MTH_VAL    ,
 a.TRSFR_RSPNS_CDE  ,
 a.EXPCT_GRID_SCR_VAL,
 b.OFFR_CALL_KEY

from ccsrep.offr a, egurev1.offr_call b
where
a.acct_nbr = b.acct_nbr
and a.dt_nbr = b.dt_nbr
and a.usr_id = b.usr_id
);

This one created a few logs in the arch directory:

insert /*+ parallel (egurev1.offr_Call,16) */ into egurev1.offr_Call nologging (sele
ct /*+ parallel (b,16) */ ACCT_NBR , USR_ID , DT_NBR , OPERS_CNTR_CDE, DEPT_ID
, CRD_TYP_NBR , OPT_CDE , IVR_CDE , IVR_FL_IND , IVR_PASS_IND , CALL_CNT ,
PROC_MTH_VAL, INBD_OUTBD_CDE , offr_call_key.nextval from ccsrep.offr_call b, dual)
/

When executing no indices were existing on the target tables.

Gene

• Rick_Cale_at_teamhealth.com wrote:
  >
  > As long as you are doing INSERT INTO ... using CTAS
  > it can make use of
  > NOLOGGING according to Oracle. I do not know
  > why the single table does not use it. Perhaps
  > posting relevant portion of
  > insert stmt may provide some help
  

  ---

Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: gurelei_at_yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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).

Received on Wed Aug 14 2002 - 12:18:49 CDT