471,049 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Perf. degradation due to TIMESTAMP WITH TZ

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?

Jul 19 '05 #1
0 1435

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jason Heyes | last post: by
15 posts views Thread by Raj | last post: by
3 posts views Thread by Joshua Coady | last post: by
11 posts views Thread by Pohihihi | last post: by
7 posts views Thread by JJ | last post: by
2 posts views Thread by Stefan Kuhr | last post: by
1 post views Thread by Ben | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.