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 -> Performance Issue (8i to 9i migration)

Performance Issue (8i to 9i migration)

From: kong <kongkong99_at_yahoo.com>
Date: 6 May 2004 01:23:42 -0700
Message-ID: <cc50806d.0405060023.195eb3be@posting.google.com> 





Hi All,



Seems that 8i to 9i migration give me a big shock.
While we were using 8i, it took 2minutes to execute a package/view.
But 9i takes more than 3 hours..


It doesn't make sense.



So, I'm wondering is there any thing i've missed out?
For example some queries can not run in proper way as it is in 8i?
Or, there are major changes in queries that i need to do?



Can someone please help me or provide me as much information ..
I appreciate your help so much.



Thanks.




Warmest Regards,


Felicia
Received on Thu May 06 2004 - 03:23:42 CDT












Original text of this message













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