ORACLE: LISTAGG taking too long to output my results
<p>Below is the SQL string I pass to a Oracle server via an Oracle API within Python. I suspect that the listagg function is the reason for the extended amount of processing time. Without the listagg function the results are parsed in under half the time that the below SQL takes. Any suggestions or fixes more than welcome.</p>

<pre><code>SELECT to_char(a.transaction_dt, 'MM/DD/YYYY'), 
        a.sub_acct_nbr, 
        a.trn_ldgr_entr_desc, 
        a.fdoc_nbr, 
        a.fin_object_cd,
        a.fin_sub_obj_cd, 
        a.fin_obj_cd_nm, 
        b.explanation, 
        (select listagg(c.txt, ';') WITHIN GROUP (order by a.fdoc_nbr) from View3 c where a.fdoc_nbr = c.fdoc_nbr) Notes, 
        to_char(a.trn_ldgr_entr_amt, '9,999,999.99'), 
        a.trn_debit_crdt_cd
    FROM  View1 a
    LEFT OUTER JOIN View2 b
    ON  a.fdoc_nbr = b.doc_hdr_id
    WHERE   a.account_nbr = 123456
    AND     a.univ_fiscal_prd_cd = 12
    AND     (a.fin_object_cd BETWEEN '5000' AND '7999'
    OR      a.fin_object_cd BETWEEN '9902' AND '9905')
    ORDER BY a.transaction_dt;
</code></pre>