Q
Problem solve Get help with specific problems with your technologies, process and projects.

Design advice for 2 TB database

Kindly advise me on the design of a database sizing around 2 TB per month on transaction table.

Kindly advise me on the design of a database sizing around 2 TB per month on transaction table. (Physical memory 2 GB on IBM P5, Linux ES4.) No images and transaction table is of 200-character record length.

Writing 2 TB a month will require a good enough file system to handle the I/O needs for your online redo logs, your undo tablespace, your archived redo logs and your tablespace(s) holding the table and indexes. You might need to ensure you have enough disk spindles to be able to handle this type of I/O volume.

The other thing I would recommend is to look at partitioning. You may have to partition this table to get the desired performance out of it. Partitioning is an extra cost option, but it may be just what you need.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close