Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

1 TB table performance

user10698496Jan 19 2015 — edited Jan 19 2015

Hi,

Oracle version - 11.2.0.4

I have a datawarehousing environment which uses informatica tool. DB size is around 5TB out of which one table is 1 TB size.This is a hash partitioned table with 256 partitions.During batch window many DML operations are happening on this table and all are taking huge time.Gathering statistics on this table alone takes more than an hour.

Kindly let me know some general tuning tips on such huge tables.Is it a wise idea to have tables in TB size?Also is it a wise idea to have 256 partitions? Do we have to move historic data to another table?

It is a stand alone db on AIX 7

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2015

Added on Jan 19 2015

#general-database-discussions

2 comments

556 views