使用IN子句中的子查询，Oracle性能降低

I have query like this:

我有这样的查询:

SELECT
  xmlelement("objects",
    xmlagg(
        xmlelement("object",
          xmlelement("accountId", ACCOUNTS.accountId),
          xmlelement("address", ACCOUNTS.ADDRESS)
      )
    )
    INTO obj_info_xml
    FROM 
      ACCOUNTS
    WHERE account_code IN (SELECT EXTRACTVALUE(VALUE(accountCodes), '/accountCode/text()') as accountCode
                 FROM TABLE(XMLSEQUENCE(EXTRACT(X, '//accountCodes/accountCode'))) accountCodes); 
SELECT
  x