| Estimate tablespace growth while loading data using sqlldr [message #509904] |
Wed, 01 June 2011 10:06  |
catchmss
Messages: 5
Registered: December 2009
|
Junior Member |
|
|
Hello All,
We load large amount of data into multiple tables using sqlldr.
Amount of data that we need to load varies according to the situation. We want to estimate the tablespace usage growth due to this data load, so we can verify/extend the tablespaces before the data load. Though, setting to autoextend will help in this case, We want to avoid extending the tablespace during sqlldr executing due to performance.
Our initial attempt was to note the tablespace size before and after executing the sqlldr and use the delta. But this delta was not consistent in different environments for the same amount of data. Different environments mean different oracle servers, different existing sizes of tablespaces, One data file Vs multiple data files etc.
So my question is , How do we reliably estimate how much tablespace we need for the given amount of data?
Any other valuable inputs regarding this topic?
|
|
|
|
|
|
| Re: Estimate tablespace growth while loading data using sqlldr [message #509909 is a reply to message #509905] |
Wed, 01 June 2011 10:14  |
catchmss
Messages: 5
Registered: December 2009
|
Junior Member |
|
|
BlackSwan wrote on Wed, 01 June 2011 11:12>So my question is , How do we reliably estimate how much tablespace we need for the given amount of data?
>Any other valuable inputs regarding this topic?
External_file_size * Fudge_Factor = approximate_TS_consumed.
Above "assumes" NO indexes on tables being loaded.
INDEX size/growth needs to be separate calculation.
Thanks for the quick answer.
What is the Fudge_Factor?
Some of the tables have indexes. How do I estimate the INDEX size/growth?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
