CODEWITHSUNDEEP
oracle-databaseexternaloracle12cdata-dump
Martin Huang
Martin Huang

Reputation: 1

How do I determine Data Load time for External tables?

I am using Oracle DB 12c Enterprise Edition.

I have set up the file directory for the flat file (.csv) saved on my desktop. The external table is already created and data is being loaded directly to my external table set up in oracle.

It appears that the data import from .CSV --> External Table is a transparent process. How exactly do I determine how long it took to load all the data in .CSV flat file to external table?

My .CSV flat file has 150,000 records. The BADFILE and LOGFILE are produced but it does not provide a specific time on how long it took to load all the files.

Please help..

My goal is to determine if Loading Data via External Table is faster than SQL*LDR or Data Import Utility in SQL Developer.

Upvotes: 0

Views: 1270

Answers (1)

Justin Cave
Justin Cave

Reputation: 231681

The data is loaded from the external table every time you query it. So one option would be to do a 

SELECT COUNT(*)
  FROM your_external_table

and measuring the amount of time that requires. If your intention is to load the data from the external table into the same staging table that you'd load with SQL*Loader, you could also measure the time required to do that INSERT.

Upvotes: 1

Related Questions