| Tuning Question [message #90500] |
Thu, 11 December 2003 11:47  |
Matthew McGuire
Messages: 1
Registered: December 2003
|
Junior Member |
|
|
|
I have a table that has 1 million rows inserted per day. After the insert there are about 8 updated statements to the same row inserted. What overall parameters should I think about? I can get about 100 transactions per second (1 insert and 8 updates = 1 transaction). 1 row 2K. I believe I should be able to handle more. Oracle 9i, redhat 8, dual xeon 2.4, 2G Ram, fiber connected netapp. Does 100 - 120 transactions per second sound right?
|
|
|
|
| Re: Tuning Question [message #90506 is a reply to message #90500] |
Sat, 20 December 2003 22:48  |
Aparba
Messages: 4
Registered: June 2003
|
Junior Member |
|
|
Ram : 1gb ram
o/s windows 2000 server.
Subject : Data mart.
What would be the suggested values for required block size, sort area size, hash area size, db_file_multiblock_read_count sizes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
