Latest Activity

code

Performance Bench Marks

I'm currently seeing performance issues when we run quiries extracting data from tables with multimilliion records. The data movement is slow and cpu consumption is quite high during the query execution. As a first step, I would like to compare it to t...

performance Bulk Data Load Sql performance

code

Bulk Data Load

I am planning to use Bulk Data load option for cache DB. Could anyone please guide me how to use this particular feature. I tried giving the sqlldr path 'c:/ORACLE/11.2.0.2/bin/sqlldr.exe' in the sqlldr executable location, but while storing the data i...

Bulk Data Load