| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle much slower than DB2?
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
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.
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-30Received on Sat Jul 21 2001 - 16:26:17 CDT
 |
 |