Troubleshooting
Problem
Oracle Tools : Sqlplus : Session Environment Setting
Symptom
Where to setup basic SQL*Plus Environment Variable setup such as Pagesize, feedback, Heading at SQL session level.
Cause
Resolving The Problem
The setup files for SQL*Plus are the glogin.sql and login.sql files.
These
files contain SQL statements or SQL*Plus commands that you can choose to
execute at the beginning of each SQL*Plus session.
When you invoke
SQL*Plus, glogin.sql is read first, followed by login.sql.
The
Global/Site Profile
==================
The Site Profile file is
$ORACLE_HOME/sqlplus/admin/glogin.sql.
SQL*Plus executes this command file
when any user starts SQL*Plus and SQL*Plus establishes the Oracle connection.
The default Site Profile is placed in $ORACLE_HOME/sqlplus/admin when
SQL*Plus is installed.
The User Profile
=============
The User
Profile file is login.sql.
SQL*Plus executes this command file when any
user starts SQL*Plus and SQL*Plus establishes the Oracle connection.
Historical Number
PRI48115
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21535509