Re: Performance!

From: hardmarm <username_at_protect.domain.com>
Date: Thu, 10 Jun 1999 04:19:03 GMT
Message-ID: <X0H73.5573$Xr4.47111@c01read02-admin.service.talkway.com>

Quite a few things to try. You referenced specifically dml statements...are you using ddl commands...how frequent are the commits. A lot depends on the application that you are running. Are you running processes in parallel - how have you defined the initrans. How many rollback segments do you have, and is there any contention for them when running your processes. Block contention can also indicate problems with your initrans setting. You can often times split the db for large processes to multiple disks to improve processing. Also, verify that the platform and db are certified.

Check out O'Reilly's performance tuning book. It will have a number of good resources for you.

Thanks,

Ron
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Wed Jun 09 1999 - 23:19:03 CDT