| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 9.2.0.2 performance problem
Hello
We execute the query in the servers, so there is no NET problem (I think).
The data volume is exact (imported).
Execution path is the same, full-scan.
This is a very strange problem and is very important for us to solve it. Thank´s
This is the plan of the windows db:
Execution Plan
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5952 Card=465110 Byt
es=32557700)
1 0 SORT (GROUP BY) (Cost=5952 Card=465110 Bytes=32557700)
2 1 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=643 Card=465110
Bytes=32557700)
0 recursive calls
4 db block gets
6679 consistent gets
12866 physical reads
0 redo size
59454 SQL*Net roundtrips to/from client
0 sorts (memory)
1 sorts (disk)
445919 rows processed
-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de chao_ping
Enviado el: lunes, 20 de enero de 2003 12:19
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Oracle 9.2.0.2 performance problem
Juan Miranda,
It seems quite strange,there is little wait event in the statspack report, and you execution path should be the same on both platform, right? And is the data volumn the same in both platform?And does the time spent on fetch the result from server to your client different?Is the speed of your pc to linux and hp the same?
Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(China Oracle User Group)
>Hello
>
>We have an serious performance problem on a DSS db.
>We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11
>
>Oracle 9.2.0.2 tooks 30 min doing this query where an Intel 2x1,4 Ghz
tooks
>9 min only.
>
>We have in the HP losts of buffers(1,5GB), sga(200MB), pga(500MB), fast i/O
>(EMC Clariom CX600)...
>We try lost of parameters, but time is always the same.
>
>Is there some bug in this release - platform ?????
>How can I get more data about this problem??
>
>Thanks.
>
>SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
> evpanc,evpgru,evpcli,evppai,evppro,evpume,
> to_date(evpano||'-'||evpmes||'-'||'01','YYYY-MM-DD') FECHA,
> sum(evppca) PPTO
>FROM DW.SUPUESTOS
>GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
> evpanc,evpgru,evpcli,evppai,evppro,evpume,
> evpano, evpmes
>
>call count cpu elapsed disk query current
>rows
>------- ------ -------- ---------- ---------- ---------- ---------- -----
-
>----
>Parse 1 0.01 0.00 0 0 0
>0
>Execute 1 0.00 0.00 0 0 0
>0
>Fetch 445920 1748.65 1708.72 1554 1675 23
>445919
>------- ------ -------- ---------- ---------- ---------- ---------- -----
-
>----
>total 445922 1748.66 1708.72 1554 1675 23
>445919
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 90 (recursive depth: 1)
>
>
>Execution Plan
>----------------------------------------------------------
> 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 Card=464215 Byt
> es=32495050)
>
> 1 0 SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050)
> 2 1 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 Card=464215
> Bytes=32495050)
>
>Statistics
>----------------------------------------------------------
> 0 recursive calls
> 31 db block gets
> 1675 consistent gets
> 1577 physical reads
> 0 redo size
> 9012743 bytes sent via SQL*Net to client
> 208363 bytes received via SQL*Net from client
> 29729 SQL*Net roundtrips to/from client
> 0 sorts (memory)
> 1 sorts (disk)
> 445919 rows processed
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: chao_ping_at_vip.163.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: j.miranda_at_sermatica.es Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jan 20 2003 - 06:34:38 CST
 |
 |