Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Setup and Size

Status
Not open for further replies.
robhalabicki

robhalabicki

MIS
Aug 20, 2001
3
CA
I am new to Warehousing in that we have been mostly OLTP and speed is of benefit. Is there anyone who can help give recommendations to the setup of a database that will contain 3,000,000 rows of Data Approx 550 bytes. Should I use table partitioning, how should I use it. What about disk setup. Does 5-10 disk in mirror and stripe setup on a Unix machine sound reasonable? Any guesses on SGA setup, how much buffer cahce and shared pool do you think it needs?
 
Status
Not open for further replies.

Similar threads

RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
470
johnherman
johnherman
Ulianna
  • Locked
  • Question
Loading files from different sources into one database table
Replies
1
Views
171
johnherman
johnherman
Sohailaziz
  • Locked
  • Question
Difference and Usefulness of SSIS and SSAS 1
Replies
3
Views
163
johnherman
johnherman
dbrs4me
  • Locked
  • Question
Book Search - Oracle OWB and OBIEE
Replies
0
Views
104
dbrs4me
dbrs4me
blom0344
  • Locked
  • Question
Web service versus directly sourcing database
Replies
2
Views
100
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top