Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227

    Unhappy Unanswered: performance 8.05 vs 8i

    Hi,

    we used Oracle db 8.1.6 in a web app. Now, our client wants to run that app on an 8.0.5 db. So I created exactly the same schema for the 8.0.5 version (same data types, same indexes, same storage params, ...). Surprisingly, performance is not nearly the same. The main query took less than a second to execute in the 8.1.6 database and takes over two and a half minute to execute in the 8.0.5 db.
    Offcourse my question is: what's causing this difference in performance? Are there specific problems in 8.0.5 regarding performance or should I change some of the storage parameters or ... ? Any information would be greatly appreciated.
    Johan

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    With that big a difference, I'd start looking at the query plans. Assuming the tables have been analyzed and your running similar parameters (optimizer_mode, db_block_buffers, shared_pool_size, etc) then the differences in the optimizer wouldn't be that much of a difference, IMHO.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •