Create Oracle Table and Index Examples with Parallel Operations
The implementations of parallel operations for table and index creation in Oracle illustrate the application of parallel operations in SQL statements. Learn more.
Read MoreMost Popular Oracle
Manage Oracle Parallel Server Resources and Statement Queueing
In Oracle, you configure the allocation of parallel server resources for a consumer group with the PARALLEL_TARGET_PERCENTAGE directive. Learn more.
Read MoreBasic Concepts of Parallel Operations in Oracle
Although there are some overhead costs and administrative requirements, using parallel operations in Oracle can improve the performance of many queries. Learn more.
Read MoreInternal Workings of the Oracle RAC Systems
With Oracle RAC instances, there are some special processes spawned to coordinate interinstance communication and facilitate resource sharing. Learn more.
Read MoreImplications of PL/SQL Object Location in Oracle
While there is ongoing debate as to where to store Oracle PL/SQL code, generally, the server side is the preferred place. Learn more.
Read MoreImprove Oracle Performance by Reducing Calls to SYSDATE
Calls to the Oracle variable SYSDATE, though convenient, involve some overhead, and should be reduced where possible. Learn more.
Read MoreUse ROWID for Iterative Processing in Oracle
The Oracle ROWID is the fastest access path to a record in a table, even faster than a unique index reference. Learn how this can improve performance.
Read MoreReduce PL/SQL Program Unit Iterations in Oracle
Any Oracle PL/SQL program unit involving looping logic is a strong candidate for performance improvements, and there are several ways to accomplish this. Learn more.
Read MoreIncrease Oracle 11g Performance with Native Compilation
Because natively compiled code in Oracle doesn’t need to be interpreted at runtime, it may execute faster. However, performance gains depend on several factors. Learn more.
Read MoreUse Named Parameters in SQL Function Calls in Oracle 11g
Named notationis the preferred method for passing parameters to subroutines in Oracle. With 11g, you can extend this to SQL statements to yield consistency across the entire code base.
Read MoreReference Sequences Directly in PS/SQL Expressions in Oracle 11g
With Oracle 11g, you can reference sequences directly in PL/SQL expressions, resulting in more streamlined code and improved performance. Learn more.
Read MoreSnapshot Too Old Error In Oracle: Developer Coding Issue
Oracle holds undo information in case you need to roll back a transaction and also to keep a read-consistent version of data. Learn why this can sometimes cause Snapshot Too Old errors.
Read More