Multiple occurence

Hi,

I have large table named duplicate_files (47GB) shown below. I need to
find the multiple occurrence of the file_name with same size in each path.

FILE_NAME
FILESIZE
FULL_PATH ABC.txt 12 I_12_122 ABC.txt 14 I_12_123 ABC.txt 12 I_12_125
ABC.txt 12 I_13_156 ABC.txt 14 I_14_123 ABC.txt 12 I_11_125 ABC.txt 15
I_12_123 ABC.txt 16 I_12_123 ABC.txt 11 I_12_123

The output is shown below.

FILE_NAME FILESIZE
FULL_PATH ABC.txt 12 I_12_122 ABC.txt
12 I_12_125 ABC.txt
12 I_13_156 ABC.txt 12 I_11_125
I used the query below to get the output.But it took me 6 hrs to get the
output. Is there any other better way to increase the speed for faster
results?

select file_name,filesize, full_path from duplicate_files f1 where

(file_name,filesize) in (select file_name,filesize from duplicate_files
group by file_name,filesize having count(file_name) >1);

Any help or advice appreciated. Thanks

Regards,
Nipuna