Sorting million records

Hi,

Oracle version : 11.2.0.4

I have a select query which fetched millions of records and sort it to write it in a file.Basically it is used for report generation purpose.Query is running for very longer time.It is accessing a MV which is created using DBLINK.PFB the plan of query.Kindly assist how to improve performance

SELECT/*+ first_rows(50) */ rep.TRACK_ADAM_ID               AS TRACK_ADAM_ID,rep.TRANSACTION_ID              AS REF_ID,rep.TCON_TYP          AS TCON_TYP,TF.upc_cd                AS ENR_TR_UPC_CD,TF.isrc_cd               AS ENR_TR_ISRC_CD,TF.grid_nr               AS ENR_TR_GRID_NR,TF.record_company_name   AS ENR_TR_RECORD_COMPANY_NAME,TF.content_provider_name AS ENR_TR_CONTENT_PROVIDER_NAME,TF.content_provider_id   AS ENR_TR_CONTENT_PROVIDER_ID,TF.vendor_id             AS ENR_TR_VENDOR_ID,TF.content_name          AS ENR_TR_CONTENT_NAME,'PT'|| TO_CHAR(TRUNC(NVL(TF.TOTAL_TM_MSECS,0)/3600000),'FM990')|| 'H'|| TO_CHAR(TRUNC(MOD(NVL(TF.TOTAL_TM_MSECS,0),3600000)/60000),'FM90')|| 'M'|| TO_CHAR(MOD(NVL(TF.TOTAL_TM_MSECS,0),60000)/1000,'FM90')|| 'S' ENR_TR_TOTAL_TIME,TF.orig_release_year                              AS ENR_TR_ORIG_RELEASE_YEAR,TF.pline_text                                     AS ENR_TR_PLINE_TEXT,TF.ARTIST_NAME                                    AS REF_ARTIST_NAME,TA.artist_name                                 AS ENR_TR_ARTIST_NAME,TA.artist_role_id                              AS ENR_TR_ARTIST_ROLE_ID,TA.artist_role_name                            AS ENR_TR_ARTIST_ROLE_NAME,TA.mi3p_artist_role_name                       AS ENR_TR_ARTIST_MI3P_ROLE_NAME,TA.matching_name                               AS ENR_TR_ARTIST_MATCHING_NAME,booklet.adam_id                                          AS ENR_BOOKLET_ADAM_ID,DECODE(booklet.adam_id,NULL,NULL,TF.content_name) AS ENR_BOOKLET_NAME,booklet.booklet_type_id                                  AS ENR_BOOKLET_TYPE_IDFROMSALE_REP repLEFT JOIN MV_MST TFON TF.adam_id = rep.track_adam_idLEFT JOIN MV_ART TAON TA.content_adam_id = rep.track_adam_idLEFT JOIN MV_BOOK bookletON rep.track_adam_id        = booklet.adam_idWHERE FP         = '201604'AND REPORT_DATA_ID          = 2381AND rep.TCON_TYP IN ('H','J','PJ','PV','PX','S','U','V','X','MA')ORDER BY rep.track_adam_id,TRANSACTION_ID;