Re: Insert takes a lot of cpu time and buffer gets

From: David Ballester <ballester.david_at_gmail.com>
Date: Wed, 04 Feb 2009 19:37:56 +0100
Message-Id: <1233772676.30190.19.camel_at_nebuchaddnezzar>



El mié, 04-02-2009 a las 19:01 +0200, Yechiel Adar escribió:
> I run statspack on 9.2.0.5, windows 2000.
> The server is 2 dual core cpus with 4 GB memory.
>
> I see that 27,550 inserts costs 31 buffer gets per insert and a total of
> 48 seconds cpu.
> They are using bind variables.
> The table has no descriptors and no triggers.
> The tablespace is locally managed and the table size is 500 MB with 147
> extents.
>
> There are 20 fields, from which 14 are fields that contains date values
> but the fields are varchar2(10).
>
> What can cause the high buffer gets and the high cpu?
>

Have no idea but seems that is doing a extra job per insert? may be reading block, deciding that is not usable, reading another one...

what's about pct free / pct used?

what's about the database encoding?  

Only brainstorming :)

D.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 04 2009 - 12:37:56 CST

Original text of this message