create table test_table_1
as
select 
  cast(dbms_random.string('A',50) as varchar2(50)) col01
, cast(dbms_random.string('A',50) as varchar2(50)) col02
, cast(dbms_random.string('A',50) as varchar2(50)) col03
, cast(dbms_random.string('A',50) as varchar2(50)) col04
, cast(dbms_random.string('A',50) as varchar2(50)) col05
, cast(dbms_random.string('A',50) as varchar2(50)) col06
, cast(dbms_random.string('A',50) as varchar2(50)) col07
, cast(dbms_random.string('A',50) as varchar2(50)) col08
, cast(dbms_random.string('A',50) as varchar2(50)) col09
, cast(dbms_random.string('A',50) as varchar2(50)) col10
from dual
connect by level < 1000000

create table test_table_2
as select * from test_table_1

원하시는 row 수만큼(temp 파일 사용할 정도로 큰 테이블) 임시 테이블 생성하셔서 sort나 hash join 등등 테스트해보세요.