Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Perf. degradation due to TIMESTAMP WITH TZ

Perf. degradation due to TIMESTAMP WITH TZ

From: Yash <yashgt_at_yahoo.com>
Date: 13 Jan 2004 05:23:19 -0800
Message-ID: <5a373b1d.0401130523.259e0c81@posting.google.com>

We have an application that loads millions of records into a table. Around 10 fields in this record are date fields. We perform the insert using SQL*Loader in direct path mode. The loading takes a few hours. Recently we had to convert the date columns to TIMESTAMP WITH TIMEZONE(3). After doing the appropriate changes in the SQL*Loader control file, when we performed a load, we experienced a performance degradation of 50%.

Is the slowdown inherently due to the type of the column? Can somebody provide any suggestions for reducing the slowdown?

Thanks
Yash Received on Tue Jan 13 2004 - 07:23:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US