PL/SQL Engine
The PL/SQL engine is the system that compiles and runs PL/SQL code blocks. It typically comes bundled with Oracle Database installations or application development tools like Oracle Forms or Report Builder.
When executed, SQL statements included in the PL/SQL code blocks are sent to the SQL Statement Executor for processing. After executing the SQL queries, results then return to the PL/SQL engine, allowing for procedural operations on the retrieved data. This interaction, involving data moves between PL/SQL and SQL Statement Executor, is known as context switching.
Understanding the concept of context switching is important for optimizing the performance of your database applications. Oracle provides several techniques designed to reduce context switching and minimize overhead, such as bulk binding with BULK COLLECT or FORALL. To identify situations where these techniques can be beneficial, it is essential to know what context switching is and when it happens.
Database Server
This is where the database objects reside and with which the PL/SQL engine interacts. The database server includes schema objects, such as tables and views. It also stores PL/SQL procedures, functions, and triggers, so that they execute within the database server, reducing overhead.
0 Comments