12c: Precompilers/SQLJ support for SQL Plan management

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Thu, 29 Aug 2013 12:18:14 +0300
Message-ID: <OFBC9E9069.ECFF41FE-ONC2257BD6.0032B040-C2257BD6.00331B9B_at_seb.lt>

Hi,
Am I rigt: the 12c precompilers/SQLJ support for SQL Plan management is very similar to DB2 bind(?) files ?
Here is an excerpt from 12c new feature guide:

"

1.1.4.13 Precompilers Support for SQL Plan Management

There are new command-line options for the generation of plan baseline SQL statements providing control of the name and format of generated SQL files and log files.
...
1.1.4.14 SQLJ Support for SQL Plan Management

The following are new features in this release for SQLJ support for SQL plan management (SPM):

    Command line and property file options for the generation of plan baseline SQL statements.

    Generation of a SQL file containing the statements for creating SPM plans....
"

In short, .sql file is genereated which creates SPM baselines, effectively freezing plans of your SQL statments.

Brgds, Laimis N

---

Please consider the environment before printing this e-mail

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 29 2013 - 11:18:14 CEST