Re: Insert performance

At 09:44 PM 9/22/2003, you wrote:
>Does anyone have any idea how to improve performance for multiple inserts
>into a table that uses a sequence generated primary key?

Is the sequence cache set to an appropriately large value?

Justin Cave

>
>I have approximately 6 concurrent inserts per second into this table which
>causes the primary key index to become a hot block. This in turn causes
>"buffer busy waits".
>
>I have increased initrans, but am not sure where to go from here
>
>Any ideas would be appreciated,
>
>Thanks,
>
>Rick Stephenson
>Oracle Database Administrator
>Ovid Technologies, Inc.
>rick_stephenson_at_ovid.com
>
>
>
>This email and any files transmitted with it are confidential and intended
>solely for the use of the individual or entity to which they are
>addressed. This message contains confidential information and is intended
>only for the individual named. If you are not the named addressee you
>should not disseminate, distribute or copy this e-mail. Please notify the
>sender immediately by e-mail if you have received this e-mail by mistake
>and delete this e-mail from your system. If you are not the intended
>recipient you are notified that disclosing, copying, forwarding or
>otherwise distributing or taking any action in reliance on the contents of
>this information is strictly prohibited.
>

Justin Cave
Distributed Database Consulting

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).