How do you set linesize, pagesize, and other environment parameters permanently in Oracle 10g?

Question

how to set linesize, pagesize permanently in oracle 10g?

Answer 1

Is this for SQL*Plus? If so, these instructions will work:

Create a file (or edit it if it's already there) called glogin.sql in the <ORACLE_HOME>\sqlplus\admin directory
(ex. C:\Oracle\Ora10g\sqlplus\admin\glogin.sql)

This file will get executed every time you log into SQL*Plus. You can add settings here, such as "set linesize 1000". Here are the contents of my file:

glogin.sql: set linesize 1000