Inserts

From: <mkline1_at_comcast.net>
Date: Tue, 20 Jan 2004 11:34:37 -0800
Message-ID: <F001.005DDAB9.20040120113437@fatcity.com>

This may be more on that parallel being set too high, but looking for ways to improve insert speed. I've seen the "APPEND" hint mentioned, but not sure if that speeds things up or simply says "Insert at the end".

Also, a co-worker found a PL/SQL on a "degree=4" table that has a cursor, then one insert and then another insert to the same table before the cursor loops. What might this do to a parallel table? Maybe it's limited to only one server per cursor, but this could cause some fun otherwise.

Thoughts, suggestions, white papers, places to look?

--

Maks
Midlothian, VA 23112
804-744-1545
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: mkline1_at_comcast.net

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). Received on Tue Jan 20 2004 - 13:34:37 CST