Insert takes a lot of cpu time and buffer gets
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 04 Feb 2009 19:01:27 +0200
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?
--
Adar Yechiel
Rechovot, Israel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
