What are some ways to make SQL Plus run queries faster, like Toad? (4301331)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

What are some ways to make SQL Plus run queries faster, like Toad?
Description

What are some ways to make SQL Plus run queries faster, similar to Toad's 'Execute Statement' F9.
Resolution

Try running the following SQL Plus Commands before running your query.
set arraysize 500
set verify off
set echo off
set head off
Note: There may be more / other ways to make SQL Plus run queries faster. Please consult with an Oracle DBA on this regard.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title