Home » Developer & Programmer » Designer » Tuning Question
Tuning Question [message #90500] Thu, 11 December 2003 11:47 Go to next message
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 Go to previous message
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
Previous Topic: Oracle space Question
Next Topic: Sizing Shared pool - A Question
Goto Forum:

Current Time: Fri Jun 18 01:12:43 CDT 2021