Re: performance of Inserting bytes

On 19 Jul 2002 21:48:17 -0700, kevinepsworth_at_bigfoot.com (Kevin Epsworth) wrote:

>Hi Aseem,
>
>Did you find solution to your problem.
>
>Actually, I am also having the same problem.
>
>Thanks,
>
>-Kevin
>
>aseem_at_modena.stpn.soft.net (Aseem Bansal) wrote in message news:<dba22635.0207110540.7982d7cd_at_posting.google.com>...
>> Hi
>> I donot have much idea about the slow performance regarding the
>> insert statement execution.
>> I am using Oracle JDBC driver (Classes12.zip) for accessing
>> oracle 8.1.6. In the database, I am maintaining a message table which
>> has 6 fields (4 numbers, 1 char and 1 "LONG RAW " ). If i try to
>> insert 5000 messages into this table using a single prepared
>> statement, performance is around 60-80 inserts per sec (always <
>> 100). How can I increase this?
>>
>>
>> Regards
>> Aseem Bansal

Archives for this group exists in vain. No one searches them. There can be quite a lot of areas on the database side resulting in this problem, and due to the nature of the original post (and running on a desupported version), one has more or less to be clairvoyant to address the issue.
The problem can be caused by improperly sized online redolog files, resulting in 'checkpoint not complete' messages in the alert, the problem can be caused by an improperly sized log_buffer in init.ora resulting in buffer space requests, the problem can be caused by improperly sized rollback segments with too small extents.
the problem can be caused by improperly sized extents in a dictionary management tablespace resulting in frequent space management transactions.
Just to mention a few options.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 20 2002 - 03:24:45 CDT