Re: External table performance

  • From: raza siddiqui <raza.siddiqui@xxxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Jan 2018 11:41:22 -0800


Firstly, a 50k datafile is not big by any standards...

Secondly, when External Tables get to be fairly sizeable, one option could be to load the data into a temp table in the Database, use it then truncate once done.

Lastly, could the main select be the issue and not the External table or its data ?

On 1/12/2018 11:28 AM, Powell, Mark wrote:

Sanjay, you did not identify your Oracle version and edition nor post the actual code you have an issue with but consider the following.

I do not have access to a server where I can test right now but I believe that you can select from an external table using parallel query if you are on EE.

Mark Powell
Database Administration
(313) 592-5148

*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
*Sent:* Friday, January 12, 2018 2:23:40 PM
*To:* Oracle-L Freelists
*Subject:* External table performance
Can someone share the Tuning activites that can be done for Selecting data from External table in 12c (12.1)? I am working on project that is getting every 6hourly data as flat file from external source and then has to be selected from ORacle table for some processing. Data is only 50K records but Select is taking time. It is Local Storage where File is located. I don;t think we can have indexes yet and so checking experience from the experts.



Other related posts: