Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    5

    Lightbulb Unanswered: quesiton about sort area

    Hi all,I don't know why oracle need sort area,why can't oracle do sort during execute SQL statement?

  2. #2
    Join Date
    Apr 2002
    Posts
    56
    The sort area is amount of memory a user gets for sorting purposes (typically 64 KB).
    (this applies to DEDICATED_SERVER connection mode)
    If the sort can not be done in that memory it will use the temporary tablespace for that user to do the sort.

    The sort is needed in case of an order by or distinct or union clause in a query.

  3. #3
    Join Date
    Nov 2002
    Posts
    5
    Thank dewin,but I don't understand why sort can't do in SGA?

  4. #4
    Join Date
    Apr 2002
    Posts
    56
    In SHARED_SERVER mode (MTS,connection sharing ) the sort_area for the user session is actually contained in the SGA.
    This is mostly done with lots of users.
    Search for DEDICATED SERVER and Multithreaded Server (MTS)
    for the details.

  5. #5
    Join Date
    Jan 2004
    Posts
    99
    oracle sorts in memery, IF the work can be done within an area which is smaller than the SORT_AREA_SIZE.

    the sort space is part of the PGA when connected with a dedicated server, shared pool/large pool when connected with MTS.

Posting Permissions

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