Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oltp insert performance

1046920Nov 4 2013 — edited Nov 4 2013

Hi Experts ,

1. could someone guide me on understanding what are things that impact insert performance in an oltp application with ~25 concurrent sessions doing 20 inserts/session into table X. ? (env- oracle 11g ,3 node RAC , ASSM tablespace , tables X is range partitioned )

2. If any storage parameter is not property set then how to identify which one needs to be fixed?

Note: current insert performance is : 0.02 sec/insert.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2013

Added on Nov 4 2013

#general-database-discussions

4 comments

631 views