DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 47

Thread: Oracle 9i is slower then Oracle 8i over the same network

  1. #1
    Join Date
    Dec 2004
    Posts
    13

    Oracle 9i is slower then Oracle 8i over the same network

    Two weeks ago we moved our database from 8i to 9i. The two databases are sitting on different machines but same location. Now 3 out of 9 sites are getting slow performance in the 9i database. When they connect to the 8i database there is no problem. They are using the same network connection and the same tnsnames file to connect to the two databases. It is just that 9i's perfomance is half of 8i for the 3 sites.

    I think it is an Oracle networking setup issue that the 8i does not care about. The tnsnames and sqlnet files for all the sites are the same.

    I would really appriciate if someone can help me on this one.

    Thanks,
    Syed

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you measured ping and tnsping times? Do the listener setups differ at all?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2004
    Posts
    13
    Yes the listener setup is the same and tnsping for the two databases is the same as well.

    By the way it may not be a networking issue.
    Last edited by Syed Mohammad; 12-21-2004 at 07:46 PM.

  4. #4
    Join Date
    May 2001
    Posts
    736
    Before moving to 9i did u tested ur application on 9i.If u have statistics available on 8i compare them by obtaining the statistics on 9i.Check ur STATSPACK report 9i may be it will lead u to someware.

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Have you copied the parameters across from 8i to open your 9i database? i.e. Are you using *_AREA_SIZE instead of PGA_AGGREGATE_TARGET?

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Do you see SQL is performing slow?

    Or network issue?

    Tamil

  7. #7
    Join Date
    Dec 2004
    Posts
    13
    It seems like this is not a network issue.

    Yes the sql performance is slow. The query that use to return data in 4 seconds is now taking 9 seconds.

    Any help would be appriciated.

  8. #8
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Implement statspack and take reports and see for top SQLs. It's likely that the queries may be going for different execution plan now. Check the init parameters. Especially *sort_area_size, optimizer* and cursor_sharing parameters.
    -nagarjuna

  9. #9
    Join Date
    Dec 2004
    Posts
    13
    I ran a tkprof on both databases for the same query. Both cpu and elapsed are better in the new database, but the data is taking 4 more seconds to populate in the new database.

    This tells me that there is a network problem. What do you think.

    One question I have about net8-9. Is this only to make a connection or does it also have an affect on the speed of the transmission of the data.

    Also in the sqlnet file does it matter if you are using the
    NAMES.DEFAULT_DOMAIN parameter or not.

    Your help would be very much appriciated.

    Thanks.

  10. #10
    Join Date
    May 2001
    Posts
    736
    Did u run STATSPACK on 9i?.What is the result?Compare them with 8i

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