RE: Why does my insert creates so many logs?

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Thu, 19 Sep 2002 10:18:23 -0800
Message-ID: <F001.004D4114.20020919101823@fatcity.com>

What version? What is the definition of table A? Have you enabled parallel DML? What about the append hint? According to the docs it is supposed to be automatic with the parallel hint but...

Tim

-----Original Message-----
Sent: Wednesday, September 18, 2002 3:39 PM To: Multiple recipients of list ORACLE-L

Hi.

A developer of mine is running a large insert as select:

insert /* parallel hint */ into table A nologging
(select * from table b where ...);

There are no indices on table A and a PK disabled. Still that insert generates a large amount of logs. What could be the reason for that? Any ideas? Table A is not partitioned and has NOLOGGING attribute on the dba_tables set to Yes.

thanks

Gene

Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.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 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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: Johnston, Tim
INET: TJohnston_at_quallaby.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------