Re: RE: Oracle 8.1.7.4 is running slow after plataform migration

From: chao_ping <chao_ping_at_vip.163.com>
Date: Thu, 24 Apr 2003 17:16:45 -0800
Message-ID: <F001.0058910D.20030424171645@fatcity.com>

Angel Perez,您好！

     hi, but from the tkprof report, the oracle on solaris is faster, sun:

Execute 594624     18.19      16.82    0          0          0     0
Fetch   594624     74.80      71.91    0     594624    2378496     0
total   1189249     92.99      88.73   0     594624    2378496     0
linux:
Execute 594624     40.11      37.16     0          0          0     0
Fetch   594624    119.68     117.39     2     594624    2378496     0
------- ------  -------- ---------- ----- ---------- ----------  ----
total   1189249    159.83     154.58    2     594624    2378496     0
	Sun took 88.73 second and linux took 154.58 seconds(why elapsed time smaller than cpu time?)
	And another question is that why not try index on the table when tuning this sql? and your sql is a simple query, why so much data read in current mode(2378496)? It seems strange.
	

• 2003-04-24 16:05:00 您在来信中写道：=======

>I did it, but no diferences, the cust on explain plan is better in
>Solaris, but run slow.
>
>> You may need to run statistics;
>>
>> -----Original Message-----
>> From: Thater, William [mailto:William.Thater_at_carrier.utc.com]
>> Sent: Thursday, April 24, 2003 2:22 PM
>> To: LazyDBA.com Discussion
>> Subject: RE: Oracle 8.1.7.4 is running slow after plataform migration
>>
>>
>>
>>>-----Original Message-----
>>>From: Angel Perez [mailto:angel.perez_at_informata.com.br]
>>>Sent: Thursday, April 24, 2003 2:12 PM
>>>To: LazyDBA.com Discussion
>>>Subject: Oracle 8.1.7.4 is running slow after plataform migration
>>>
>>>
>>>I have two server machines:
>>>- Linux Intel Pentium III 700Mhz(4 cpu) 4.0Gb RAM RedHat 7.1 using
>>> ServerRaid 5 on 4 HD 10,000RPM
>>>- Sun Solaris Enterprise 2.8 UltraSparc 450 Mhz (4 cpu) 4.0Gb
>>>RAM using
>>>Veritas File system 3.3.3 and Volume Manager 3.1 RAID on 10 HD
>>>10,000RPM
>>>Concatened using 3 volumes (1 data,1 indexes, 1
>>>oracle/temp/rollback) with
>>>mirror.
>>
>> has the /etc/system file on the sun box been updated per the Oracle
>> install instructions? has the shared memore segment value been set to a
>> high value?
>>
>>
>> --
>> Bill "Shrek" Thater ORACLE DBA
>> William.Thater_at_carrier.utc.com
>> ------------------------------------------------------------------------
>> "Only two things are infinite, the universe and human
>> stupidity, and I'm not sure about the former."
>> -- Albert Einstein
>> ------------------------------------------------------------------------
>>>
>>
>> --------
>> Oracle documentation is here:
>> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send
>> a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send
>> a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive:
>> http://www.LAZYDBA.com/odbareadmail.pl
>> Tell yer mates about http://www.farAwayJobs.com
>> By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>>
>>
>> --------
>> Oracle documentation is here:
>> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send
>> a blank email to oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send
>> a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive:
>> http://www.LAZYDBA.com/odbareadmail.pl
>> Tell yer mates about http://www.farAwayJobs.com
>> By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>
>
>
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
>To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html

• = = = = = = = = = = = = = = = = = = =

　　　　　　　　致

礼！                                    

　　　　　　　　chao_ping
　　　　　　　　chao_ping_at_vip.163.com
　　　　　　　　　　2003-04-25

-- 
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).

Received on Thu Apr 24 2003 - 20:16:45 CDT