Re: Oracle much slower than DB2?

These are way too small.

Add new redo logs with at least 100 MB size each and drop the existing ones. Then please retry.

Martin

Burkhard Schultheis wrote:
>
> Thomas Kyte wrote:
> >
> > how big are your logs?
> >
> > select group#, thread#, sequence#, bytes, members from v$log;
> >
>
> SQL> select group#, thread#, sequence#, bytes, members from v$log;
>
> GROUP# THREAD# SEQUENCE# BYTES MEMBERS
> ---------- ---------- ---------- ---------- ----------
> 1 1 19586 1048576 1
> 2 1 19582 1048576 1
> 3 1 19583 1048576 1
> 4 1 19584 1048576 1
> 5 1 19585 1048576 1
>
> 5 rows selected.
>
> > can you try it with sql_trace, timed_statistics, and tkprof and post the
> > results?
>
> TKPROF: Release 8.0.5.0.0 - Production on Wed Jul 4 9:59:42 2001
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Trace file: ora_11292.trc
> Sort options: default
>
> ********************************************************************************
> count = number of times OCI procedure was executed
> cpu = cpu time in seconds executing
> elapsed = elapsed time in seconds executing
> disk = number of physical reads of buffers from disk
> query = number of buffers gotten for consistent read
> current = number of buffers gotten in current mode (usually for update)
> rows = number of rows processed by the fetch or execute call
> ********************************************************************************
>
> alter session set sql_trace=true
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 0 0.00 0.00 0 0
> 0 0
> Execute 1 0.02 0.02 0 0
> 0 0
> Fetch 0 0.00 0.00 0 0
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 1 0.02 0.02 0 0
> 0 0
>
> Misses in library cache during parse: 0
> Optimizer goal: CHOOSE
> Parsing user id: 17
> ********************************************************************************
>
> UPDATE lzgneu.mdst SET graph0 = 0, graph1 = 0, graph2 = 0, graph3 = 0,
> graph4
> = 0, graph5 = 0, graph6 = 0, graph7 = 0, graph8 = 0, graph9 = 0,
> graph10 =
> 0
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 1 0.00 0.00 0 0
> 0 0
> Execute 1 2.82 17.73 0 356
> 12448 11199
> Fetch 0 0.00 0.00 0 0
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 2 2.82 17.73 0 356
> 12448 11199
>
> Misses in library cache during parse: 0
> Optimizer goal: CHOOSE
> Parsing user id: 17
>
> ********************************************************************************
>
> OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 1 0.00 0.00 0 0
> 0 0
> Execute 2 2.84 17.75 0 356
> 12448 11199
> Fetch 0 0.00 0.00 0 0
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 3 2.84 17.75 0 356
> 12448 11199
>
> Misses in library cache during parse: 0
>
> OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
>
> call count cpu elapsed disk query
> current rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> Parse 0 0.00 0.00 0 0
> 0 0
> Execute 0 0.00 0.00 0 0
> 0 0
> Fetch 0 0.00 0.00 0 0
> 0 0
> ------- ------ -------- ---------- ---------- ---------- ----------
> ----------
> total 0 0.00 0.00 0 0
> 0 0
>
> Misses in library cache during parse: 0
>
> 2 user SQL statements in session.
> 0 internal SQL statements in session.
> 2 SQL statements in session.
> ********************************************************************************
> Trace file: ora_11292.trc
> Trace file compatibility: 7.03.02
> Sort options: default
>
> 1 session in tracefile.
> 2 user SQL statements in trace file.
> 0 internal SQL statements in trace file.
> 2 SQL statements in trace file.
> 2 unique SQL statements in trace file.
> 35 lines in trace file.
>
> Regards,
> --
> Burkhard Schultheis
> Tele Data Electronic
> Wagnerstr. 10
> D-76448 Durmersheim
>
> Email: schultheis_at_tde-online.de
> Phone: +49-7245-9287-21
> Fax: +49-7245-9287-30
Received on Sat Jul 21 2001 - 16:26:44 CDT