Originally posted by tamilselvan
Partition does NOT work very well with high volume OLTP.

Tamil
Tamil -
Can you explain why Partitioning is bad with OLTP?

I haven't yet had the opportunity to use partitioning - none of our db siizes could justify the cost. However, we have a new app coming in and they request it. The table that will need it has ~80 Million rows and will be about 4 Gig in size. It's mainly an OLTP system - but not HUGE volume. The entire DB is refreshed from the mainframe once a week, takes daily inserts and updates, and has a batch update process every night. The batch refresh is done using SQL*Loader.

Does the benefit of the load offset the problems with OLTP - in your opinion?

Thanks for your input...
Jodie