|
-
Hi
We are implementing Oracle Parallel Server. It is a OLTP application. We are carrying out stress testing , the time taken for inserting records with 150 Concurrent(inserts) user is expected to take less than 2 seconds for each user session.
But it is taking 20+ seconds for some users.
We tried altering the tables by setting the freelists to 20,
initrans to 4,pctused to 40.Could anyone tell me what other parameter that can be set at the table level. The table contains 4 columns and one being Long datatype and others being varchar datatypes..
When we go live we expect the concurrent users to be around 350+..
thanx in Advance
Sriram
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|