Database Administration (MOSC)

MOSC Banner

select from external table

edited Oct 22, 2013 9:39PM in Database Administration (MOSC) 7 commentsAnswered
A simple select from the external table runs for over 15 mins and finally when the result set comes up it is not huge either, just 13 rows are returned and below is the session wait information
Event Wait Information
---------------------

   SID 214 is waiting on event    : external table write
   P1 Text            : filectx
   P1 Value            : 140031948176272
   P2 Text            : file#
   P2 Value            : 18
   P3 Text            : size
   P3 Value            : 99

Why is the select taking so much time? If I cancel the select inbetween the following error is reported

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01013: user requested cancel of current operation

please suggest

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center