Results for bind peeking


1 to 20 of 1623 results. Prev  Next
Results per page:   20  | 40 | 60


Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

11.1.3 Bind Variable Peekinggood initial join order is a difficult problem. 11.1.3 Bind Variable Peeking In bind variable peeking … (also known as bind peeking ), the optimizer looks at the value in a bind variable when the database … . By peeking at bind values

Database Reference, 11g Release 2 (11.2)

OPTIMIZER_FEATURES_ENABLE

OPTIMIZER_FEATURES_ENABLEPeeking into user-defined bind variables X X X Index joins X X X Table 1-4 Optimizer Features for Oracle … X Complex view merging X X X X X X Peeking into user-defined bind variables X X X X X X Index joins … Optimizer Features for Oracle Database 11g Releases Features 11.1.0.6 Enhanced Bind Peeking

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

7.3.10 Sharing Cursors for Existing Applicationscontained a bind variable and uses bind peeking to estimate cardinality. Statements that differ … statements use literals rather than bind variables, a nondefault setting for CURSOR_SHARING enables … the database to replace literals with system-generated bind variables. Using this technique, the

Database Performance Tuning Guide, 11g Release 2 (11.2)

The Query Optimizer

11.1 Overview of the Query Optimizerstatement. This section contains the following topics: Optimizer Operations Components of the Query Optimizer Bind Variable Peeking

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Size Requirements for Bind ArraysThe bind array must be large enough to contain a single row. If the maximum row length exceeds the … size of the bind array, as specified by the BINDSIZE parameter, then SQL*Loader generates an error … . Otherwise, the bind array contains as many rows as can fit within it, up to the limit set by the … .) Although the entire bind

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Cursor Sharing and Bind VariablesBind Variables Query rewrite is supported when the query contains user bind variables as long as the … actual bind values are not required during query rewrite. If the actual values of the bind … variables are required during query rewrite, then we say that query rewrite is dependent on the bind values

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Performance Implications of Bind ArraysLarge bind arrays minimize the number of calls to the Oracle database and maximize performance. In … general, you gain large improvements in performance with each increase in the bind array size up to … 100 rows. Increasing the bind array size to be greater than 100 rows generally delivers more modest

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Implementing Dynamic SQL Method 4

Bind Descriptorsdata buffer addressed by BNDV(J). Often, bind-variable values are stored in character strings, so … Jth select-list or bind-variable value, reset SELT(J) or BNDT(J) to the datatype you want.

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Implementing Dynamic SQL Method 4

Bind DescriptorsDESCRIPTOR BND the buffer addressed by BNDI(J) determines whether the Jth bind variable is a . If the … elements of BNDI address elements of a data buffer array named BNDIV, and the value of BNDIV(J) is -1, the value of the Jth bind variable is set to NULL.

Data Provider for .NET Developer's Guide, 11g Release 2 (11.2)

Implicit REF CURSOR Binding

Bind Considerationsapplications should not try to explicitly bind the REF CURSOR parameter to OracleCommand. ODP.NET

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Implementing Dynamic SQL Method 4

Bind Descriptorsbind-variable values addressed by BNDV(1) through BNDV(BNDN). If the elements of BNDV address elements … of a data buffer array named BNDVB, Oracle finds the Jth bind-variable value in data buffer BNDVB(J).

Database Performance Tuning Guide, 11g Release 2 (11.2)

Glossary

bind variableA variable in a SQL statement that must be replaced with a valid value, or the address of a value, in order for the statement to successfully execute.

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Implementing Dynamic SQL Method 4

Bind Descriptorsin that buffer. If you want to change the length Oracle uses for the Jth select-list or bind

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Bind Arrays and Conventional Path Loadsread at one time and stored in the bind array. When SQL*Loader sends the Oracle database an INSERT … command, the entire array is inserted at one time. After the rows in the bind array are inserted, a … COMMIT statement is issued. The determination of bind array size pertains to SQL*Loader's

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Calculations to Determine Bind Array SizeThe bind array's size is equivalent to the number of rows it contains times the maximum length of … follows: bind array size = (number of rows) * ( SUM(fixed field lengths) + SUM(maximum varying field … storage that each field occupies in the bind array, but the bind array includes additional overhead for … fields

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Minimizing Memory Requirements for Bind Arrays—especially when multiplied by the number of rows in the bind array. It is best to specify the smallest … \",\" With byte-length semantics, this example uses (10 + 2) * 64 = 768 bytes in the bind array, assuming … -length semantics, the same example uses ((10 * s) + 2) * 64 bytes in the bind array, where \"s\" is the … a delimited

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Calculating Bind Array Size for Multiple INTO TABLE ClausesWhen calculating a bind array size for a control file that has multiple INTO TABLE clauses … file as one, long data structure—that is, the format of a single row in the bind array. If the same … bind array is required each time it is mentioned. It is especially important to minimize the buffer … , EXPRESSION, RECNUM, SYSDATE,

Database Utilities, 11g Release 2 (11.2)

SQL*Loader Control File Reference

Specifying Number of Rows Versus Size of Bind ArrayWhen you specify a bind array size using the command-line parameter BINDSIZE or the OPTIONS clause … in the control file, you impose an upper limit on the bind array. The bind array never exceeds that … . If that size fits within the bind array maximum, then the load continues—SQL*Loader does not try to … expand

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL: Method 4

DESCRIBE the Bind VariablesDESCRIBE BIND VARIABLES puts descriptions of placeholders into a bind descriptor. In our example … , DESCRIBE readies bind_des, as follows: EXEC SQL DESCRIBE BIND VARIABLES FOR sql_stmt INTO bind_des … ; Note that bind_des must not be prefixed with a colon. The DESCRIBE BIND VARIABLES statement must … follow the

Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2)

Object-Relational Data Types in OCI

Bind and Define ExamplesThe examples in this section demonstrate how you can use variables of type OCINumber in OCI bind … placeholder:newsal, specifying an external data type of VARNUM (data type code=6) in the bind





Was this page helpful?

Integrated Cloud Applications & Platform Services