Home » Other » General » Buffer Sort
Buffer Sort [message #103467] Fri, 24 October 2003 10:02 Go to next message
Serfiotis Georgios
Messages: 1
Registered: October 2003
Junior Member
Hi,
i'm trying to understand what "buffer sort" operation is in the following explain plan:
0 SELECT STATEMENT
-1 MERGE JOIN CARTESIAN
--2 TABLE ACCESS FULL PLAYS
--3 BUFFER SORT
---4 TABLE ACCESS FULL MOVIE
In Oracle 9i DataBase Performance Guide and Reference, "buffer sort" is not mentioned although all other explain plan's operations are.

What does it mean? Does it take place in main memory or is it an external sort?
Thank you.
Re: Buffer Sort [message #103469 is a reply to message #103467] Sun, 26 October 2003 06:36 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Since its not mentioned in the documentation,we can only guess what it means. Well,it could do in-memory sorts depending on the sort_area_size(or pga_aggregate_target) with its sort runs being stored in the temp tablepsace..

-Thiru
Previous Topic: sqlldr question
Next Topic: Oracle Error
Goto Forum:
  


Current Time: Thu Mar 28 06:58:12 CDT 2024