Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Upgrade from 8.1.6 to 8.1.7 really slow

Re: Upgrade from 8.1.6 to 8.1.7 really slow

From: chao_ping <chao_ping_at_163.com>
Date: 13 May 2002 06:11:26 GMT
Message-ID: <3cdf590e$1@usenetgateway.com> 





what about your system load in both system? If i were you, i will check
the sql execution path in both database, check if they are identical.
Most possible reason i guess is the sql execution path is different in
two systems. Use explain plan about the sql in your batch job or use
tkprof+sql_trace. Hope this helps.




--
an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com


Received on Mon May 13 2002 - 01:11:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US