My Oracle Support Banner

FAST command nulls SQLPATH (Doc ID 2730593.1)

Last updated on MARCH 02, 2022

Applies to:

SQL*Plus - Version and later
Information in this document applies to any platform.


Since 12.2 version, there is a SQLPLUS key "-fast", that should simply add several settings:
arraysize 100
lobprefetch 16384
pagesize 50000
rowprefetch 2
statementcache is 20

However, if -fast option is being used, the $SQLPATH variable is nulled out


1. Create a sql file test.sql with the content
select 1 from dual;

2. Save it in a location on the server, i.e. c:\temp

3. set SQLPATH=c:\temp

4. Connect with SQLPLUS
sqlplus sys/welcome1 as sysdba

5. Run the script
SQL> @test.sql


6. Disconnect from SQLPLUS

7. Connect again using fast command
sqlplus -fast "/as sysdba"

8. Run the script
SQL> @test.sql
SP2-0310: unable to open file "test.sql"

SQLPATH has been nulled


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.