Nologging means do not generate redo log info.

Hints for Parallel Execution
NOPARALLEL
PARALLEL
NOPARALLEL_INDEX
PARALLEL_INDEX
PQ_DISTRIBUTE

APPEND
If a table or an index is specified with nologging, this hint applied
with an insert statement produces a direct path insert which reduces
generation of redo.

http://www.adp-gmbh.ch/ora/sql/hints/index.html


-----Original Message-----
From: Srivastava Mukesh - NASHCCON
[mailto:oracledba-ezmlmshield-x89072195.[Email address protected]
Sent: Monday, July 30, 2007 12:32 PM
To: LazyDBA Discussion
Subject: RE: How to improve the insertion time

Does this means direct load, I don't want to generate redo info for this
can
I used this statement, and what is the difference between append and
parallel hints

Best Regards,
Mukesh

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x72922557.[Email address protected]
Sent: Monday, July 30, 2007 11:48 AM
To: LazyDBA Discussion
Subject: RE: How to improve the insertion time

1. alter table ZZ nologging;

2. insert /*+ append */ into ZZ
Select a.*, b.*
From XX a, YY b
Where a.xx=b.xx;

3. commit;

4. alter table ZZ logging;





Please take a few minutes to provide feedback on the quality of service
you
received from our staff. The Department of Education values your
feedback as
a customer. Commissioner of Education Jeanine Blomberg is committed to
continuously assessing and improving the level and quality of services
provided to you.Simply use the link below. Thank you in advance for
completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Philip Otunla
[mailto:oracledba-ezmlmshield-x15503725.[Email address protected]
Sent: Monday, July 30, 2007 11:29 AM
To: LazyDBA Discussion
Subject: How to improve the insertion time

Hello all,

I have the following script

Insert into ZZ
Select a.*, b.*
From XX a, YY b
Where a.xx=b.xx

Table XX and YY contains about 1.2M records
Running this script takes about 3hours.
Can any body advice me on what to do to improve/reduce the execution
time.
Thank you.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page