1 2 Previous Next 15 Replies Latest reply on Dec 16, 2019 5:11 PM by Mark D Powell Go to original post
      • 15. Re: Query via database link performance issue
        Mark D Powell

        marindo, yes that is the full error stack and the ORA-02063 identifies that the preceding error is from the remote system.  So either the remote query plan is bad requiring the use of an excessive amount of TEMP space, the query is just asking for too much data to be a reasonable request, or the remote system has too little temp space for the demand.  This last is usually not the problem.

        - -

        Meanwhile I see Fernigrini has been responding to your issues though it appears you may still have an issue.  If yes, have you tried to just extract the 15K ID's then issue 15K remote queries on the ID's which can be done using a subquery against the remote target.

        - -

        HTH -- Mark D Powell --

        1 2 Previous Next