Re: Growing table

From: Terry Sutton <terrysutton_at_usa.net>
Date: Fri, 12 Nov 2004 10:12:51 -0800
Message-ID: <002f01c4c8e3$8984ce10$6bf5a8c0@TerrySutton>

Good question, Michael, Christian, and Dick (great minds think alike?). The statement which I've found which inserts the rows is:

INSERT     INTO owner.SESSION_DATA (Session_Key, Data_Type,
Line_Number,       Generation,       Other_Data)     VALUES (:1,
:2,       :3,       :4,       :5     )

Just to be sure, I looked in v$sqlarea, and the only statement which uses APPEND is one which inserts into a SYS temp table and is not related to these tables at all.

--Terry

Original Message ----- From: "Michael McMullen" <ganstadba_at_hotmail.com> To: <terrysutton_at_usa.net>; <oracle-l_at_freelists.org> Sent: Friday, November 12, 2004 9:20 AM Subject: Re: Growing table

Is the insert done with an /*+ append */ hint or in direct mode?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 12 2004 - 12:12:07 CST