FAST command nulls SQLPATH (Doc ID 2730593.1)

Last updated on MARCH 07, 2023

Applies to:

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

Symptoms

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

Reproducing:

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

1
----------
1

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