| Buffer Sort [message #103467] |
Fri, 24 October 2003 10:02  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
