Analyze and Solaris
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Analyze and Solaris

  1. #1
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197

    Question

    I found this in another post about analyzing stats and its something I have never heard of before. Has anyone else ever experienced this. We are in the middle of optimizing a bunch of queries on Solaris and we are finding that by adding the RULE hint instead of FIRST_ROWS we can reduce the execution time by almost 75%

    Originally posted by gandolf989
    I might add that having stats and optimizer mode set to choose can cause different results on different platforms. I have never had good results generating stats on Solaris Platforms. IMHO Oracle on Solaris needs to run using RBO.

    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    If your improvement is really 75% why don't you just set optimizer mode to rule and eliminate the use of the cbo. Someone told me that the Disk IO on Solaris is slower than on other platforms. I don't have any proof of this, just an observation that stats do not work on Solaris. It seems that you agree with that statement.

  3. #3
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    After the last couple of days I agree totally with the statement. If we keep getting queries from development, changing the optimizer to RULE will definitely have to be looked at.
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by gandolf989
    If your improvement is really 75% why don't you just set optimizer mode to rule and eliminate the use of the cbo. Someone told me that the Disk IO on Solaris is slower than on other platforms.
    I/O performance is more a factor of the hardware involved, not the OS that's driving it.


    I don't have any proof of this, just an observation that stats do not work on Solaris.
    I have not found this to be the case.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    I have noticed the stats issue on a Solaris E450 as well as an Ultra Sparc 1. IMHO I think the issue deals with how solaris handles IO not the hardware.

    Jeff if you are getting good performance running choose or cbo on Solaris then maybe you are computing stats differently. Or maybe you are dealing with cleaner DML than I am dealing with.

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