DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: query optimization

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    Hello,

    I have a query which executes in 3 secs in 7.3.4 and it takes 15 secs in 8i. I need to make use of dual processors which is with 8i. How should i change the query?? Should i use parallel hint??
    with regards
    Prasanna S

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Was it running in parallel on 7.3.4? If not, there is probabaly
    something else different about the query. Look at the explain plan for it on both databases.

    You can use a parallel hint, but if there is another way to
    solve the problem (like adding an index or rewriting the
    query to make better use of existing indexes) then that is
    a better way to solve the problem.

    -John
    http://www.ezsql.net

  3. #3
    Join Date
    Feb 2001
    Posts
    83
    It is not running in parallel on 7.3.4
    The explain plan seems to be same for both. The objects are same in both the machines.
    So i doubted whether i am not using the hardware resources available.
    with regards
    Prasanna S

  4. #4
    Join Date
    Nov 2000
    Posts
    344
    Are the tables analyzed in both (or neither) databases?

    Check to see if they are or not in your 7.3 database,
    and make sure they are the same in your 8i database.

    Also, if the 8i database is new, you may need to set some
    of your init.ora parameters like shared_pool_size and
    db_block_buffers - especially if they are at default values.

    -John

Posting Permissions

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


Click Here to Expand Forum to Full Width