Re: External table performance
From: Andy Sayer <andysayer_at_gmail.com>
Date: Sat, 13 Jan 2018 08:29:11 +0000
Message-ID: <CACj1VR7HEsL48DP1LK7YLNjTGkr-nevCF_rZ=Oi_k-Fhfmt_Ug_at_mail.gmail.com>
Date: Sat, 13 Jan 2018 08:29:11 +0000
Message-ID: <CACj1VR7HEsL48DP1LK7YLNjTGkr-nevCF_rZ=Oi_k-Fhfmt_Ug_at_mail.gmail.com>
What’s the entire process here? What are you doing with the 3-5k rows? It would take some time to send them all to a client to display.
Have you traced the SQL and seen what the waits are?
Before we start blaming bugs, it’s imporant to know what is really going on.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 13 2018 - 09:29:11 CET