SQL*Plus Tuning Options This feature introduces new SQL*Plus commands SET PREFETCH, SET LOBPREFETCH, and SET STATEMENTCACHE. SQL*Plus can now use Oracle Database techniques such as pre-fetching, array fetching, and statement caching. These new SET commands can be used to tune query performance.
Download the Study24x7 App, so you can connect and collaborate.