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

Thread: Order by caused sql qry to slow down

  1. 01-08-2001, 09:29 PM #1
    goodhealth
    goodhealth is offline Junior Member
    Join Date
    Dec 2000
    Posts
    75

    Order by caused sql qry to slow down

    Our current sort_area is 64K. When we run a query with order by clause causing it do a sort (by examining TKPROF output), the system runs much slower than without the order by. The funny thing is that it only sorts 1100 items, not much data at all. Is there an easy to verify that my sort area is too small on the fly, so I can change the parameter, or I have to run BSTAT and ESTAT? Same thing with IO?

    goodhealth
    Reply With Quote Reply With Quote
  2. 01-08-2001, 09:58 PM #2
    goodhealth
    goodhealth is offline Junior Member
    Join Date
    Dec 2000
    Posts
    75
    alter session set sort_area_size = blal...

    seemed to the job for now. Other ideas are welcome.

    goodhealth
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width