Oracle
Oracle 10g: Possible optimization in massive data dump
Submitted by il_masacratore on 16 February, 2010 - 14:59In batch runs to make a massive data dump into the same table using an INSERT or UPDATE for register within a block, the process can be optimized with the use of parameters (if client supports it) or if we use ODBC with bind variables.
Recall the steps taken by Oracle to process a query:
1) Sintactic Validation
2) Semantic Validation
3) Optimization
4) Generation of the QEP (Query Execution Plan)
5) Implementation of the QEP (Query Execution Plan)
2) Semantic Validation
3) Optimization
4) Generation of the QEP (Query Execution Plan)
5) Implementation of the QEP (Query Execution Plan)
Sentences can pick up the parameters by value (where salary > 1000) or once the sentence is compiled using Bind Variables (where salary>: b1). The advantage of the second option is that Oracle compile the sentence only one-time and reuses the compiled code for each of the values for the parameters.
But we must be aware because in the latter case because Oracle can't calculate the degree of selectivity of a query and, instead, apply a degree of selectivity by default (associated with each type of operation), which can give in wrong decisions.
- il_masacratore's blog
- 1 comment
- Read more
- 1821 reads
-
Data Integration at Oracle OpenWorld 2009
Submitted by Dataprix on 23 September, 2009 - 09:20fecha:
11 October, 2009 - 11:45 - 15 October, 2009 - 11:30
Ubicación:
San Francisco, CA - MosconeCenter, West Exhibition Hall
Data integration is central to deriving business value from the diverse sources and silos of data produced by the modern enterprise. Oracle Data Integration Suite, built around Oracle Data Integrator Enterprise Edition, provides a comprehensive data integration platform that addresses the data integration requirements of Oracle database, middleware, and application customers, from high-volume, high-performance batches, to event-driven, trickle-feed integration processes, and SOA-enabled data services.
Find out more about Oracle Data Integration products at Oracle OpenWorld 2009. Attend conference sessions and panels for overviews, advanced best practices, and case studies by Oracle Data Integration product experts, and get some hands-on time with Oracle Data Integration products in hands-on labs. Or visit the Oracle Data Integration stations at the Oracle DEMOgrounds, where developers, product managers, and architects can lead you through product demonstrations and answer your questions about Oracle's current and future data integration offerings.
