Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

vendredi 22 novembre 2013

Comment vérifier et activer Parallel DML (nouveauté 11.2.0.4 et 12c)

Comment vérifier et activer Parallel DML (nouveauté 11.2.0.4 et 12c)

By Franck Pachot

Interesting article. Read it


mercredi 26 juin 2013

Oracle Database 12c Review :: Finally, a true cloud database

JUNE 26, 2013

Oracle Database 12c review: Finally, a true cloud database

Pluggable databases bring a new level of efficiency and ease to database consolidation, while a wealth of other new features address performance, availability, and more

Interesting article. Read it

mardi 26 mars 2013

Oracle White Paper :SQL Profiles: Technical Overview



What is a SQL profile? 
            A SQL profile is a set of auxiliary information specific to a SQL statement. Conceptually, a SQL
profile is to a SQL statement what statistics are to a table or index. The database can use the
auxiliary information to improve execution plans.
A SQL profile contains corrections for poor optimizer estimates discovered by the SQL Tuning
advisor. This information can improve optimizer cardinality and selectivity estimates, which in
turn leads the optimizer to select better plans.
The SQL profile does not contain information about individual execution plans. Rather, the
optimizer has the following sources of information when choosing plans:
• The environment, which contains the database configuration, bind variable values, optimizer
statistics, data set, etc.
• The supplemental statistics in the SQL profile
 Therefore, SQL profiles just guide the optimizer to a better plan.
Sql-profiles-technical-overview-128535