SQL statements in this section are ordered based on the difference in the number of total buffer cache reads or buffer gets made when processing the SQL statement between the two snapshot sets, and are listed in descending order.
SQL statements in this section are ordered based on the difference in the number of total parses made when processing the SQL statement between the two snapshot sets, and are listed in descending order. Parsing is one stage in the processing of a SQL an application issues a SQL statement, the application makes a parse call to Oracle Database. Making parse calls can greatly affect the performance of a database and should be minimized as much as possible.
By making stored procedures the unit of transaction and executing them at the partition containing the necessary data, it is possible to eliminate round trip messaging between SQL statements.
The WHILE conditional affects the execution of only a single SQL statement, unless statements are grouped into a compound statement between the keywords BEGIN and END.
WHILE は、単一の SQL 文とキーワード BEGIN と END で囲まれた複合文を制御します。
Everything in between is treated as an SQL statement and parsed for variable substitution.
This section explains in detail how you can pass data between your C program and the embedded SQL statements using a simple mechanism called host variables.
The current audit entry number. The audit entryid sequence is shared between fine-grained audit records and regular audit records. You cannot use this attribute in distributed SQL statements
You will need some cross-referencing between GUI and menu items, JSPs, html pages and java codes and the related SQL statements when it comes to change something one or two statements and files.
Interactive Reporting inserts the SQL statement directly into the content, nested between the header and footer "Imported SQL Statement." If the statement is larger than the entire Contents pane use the scroll keys to view it.
The data in the snapshot interval is analyzed by ADDM. ADDM compares the difference between snapshots to determine which SQL statements to capture, based on the effect on the system load. The ADDM analysis the number of SQL statements that need to be captured over time.
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.
Înregistrează-te pentru a accesa mai multe exemple