sqlplus在啟動時會自動運行兩個腳本:glogin.sql、login.sql這兩個文件

執(zhí)行順序為

1.默認在在$ORACLE_HOME/sqlplus/admin路徑下查找glogin.sql文件執(zhí)行

2.默認在在當前路徑下查找login.sql文件執(zhí)行，若未查找到對應文件則執(zhí)行3

3.判斷是否設置SQLPATH環(huán)境變量，如果設置了該變量則在對應路徑下查找并執(zhí)行，未找到則停止查找

login.sql

--SQLPLUS默認編輯器設置為vi
define?_editor=vi
--默認打開DBMA_OUTPUT,這樣不必要每次在輸入這個命令，同時將默認緩沖池設置得盡可能大
set?serveroutput?on?size?1000000
--假脫機輸出文本時，會去除文本行兩端的空格，而且行寬不定，如果設置為off（默認設置），假脫機輸出的文本行寬度則等于所設置的linesize
set?trimspool?on
--設置選擇LONG和CLOB列時顯示的默認字節(jié)數(shù)
set?long?5000
--設置顯示的文本寬為200個字符
set?linesize?200
--設置SQLPLUS多久打印一次標題，將此參數(shù)設置大些這樣每頁只顯示一次標題
set?pagesize?9999
--設置AUTOTRACE得到解釋計劃輸出的默認寬度，一般80足夠放下整個計劃
column?plan_plus_exp?format?a80
--設置SQLPLUS提示符，顯示格式為用戶@數(shù)據(jù)庫名
column?global_name?new_value?gname
set?termout?off
define?gname=idle
column?global_name?new_value?gname
select?lower(user)?||'@'||?substr(global_name,1,decode(dot,0,length(global_name),dot-1))?global_name
from?(select?global_name,instr(global_name,'.')?dot?from?global_name);
set?sqlprompt?'&gname>'
set?termout?on

使用scott用戶登錄后如下

C:UsersAdministrator>sqlplus?/nolog

SQL*Plus:?Release?11.2.0.1.0?Production?on?星期四?3月?15?14:50:57?2018

Copyright?(c)?1982,?2010,?Oracle.??All?rights?reserved.

idle>conn?scott/123456
已連接。
scott@ORCL>select?*?from?emp;

?????EMPNO?ENAME??????JOB??????????????MGR?HIREDATE??????????????SAL???????COMM
????DEPTNO
----------?----------?---------?----------?--------------?----------?----------
----------
??????7369?SMITH??????CLERK???????????7902?17-12月-80????????????800
????????20
??????7499?ALLEN??????SALESMAN????????7698?20-2月?-81???????????1600????????300
????????30
??????7521?WARD???????SALESMAN????????7698?22-2月?-81???????????1250????????500
????????30
??????7566?JONES??????MANAGER?????????7839?02-4月?-81???????????2975
????????20
??????7654?MARTIN?????SALESMAN????????7698?28-9月?-81???????????1250???????1400
????????30
??????7698?BLAKE??????MANAGER?????????7839?01-5月?-81???????????2850
????????30
??????7782?CLARK??????MANAGER?????????7839?09-6月?-81???????????2450
????????10
??????7788?SCOTT??????ANALYST?????????7566?19-4月?-87???????????3000
????????20
??????7839?KING???????PRESIDENT????????????17-11月-81???????????5000
????????10
??????7844?TURNER?????SALESMAN????????7698?08-9月?-81???????????1500??????????0
????????30
??????7876?ADAMS??????CLERK???????????7788?23-5月?-87???????????1100
????????20
??????7900?JAMES??????CLERK???????????7698?03-12月-81????????????950
????????30
??????7902?FORD???????ANALYST?????????7566?03-12月-81???????????3000
????????20
??????7934?MILLER?????CLERK???????????7782?23-1月?-82???????????1300
????????10

已選擇14行。

idle>conn?/as?sysdba;
已連接。
sys@ORCL>drop?role?plustrace;
drop?role?plustrace
??????????*
第?1?行出現(xiàn)錯誤:
ORA-01919:?角色?'PLUSTRACE'?不存在


sys@ORCL>create?role?plustrace;
角色已創(chuàng)建。

sys@ORCL>grant?plustrace?to?dba?with?admin?option;
授權成功。

sys@ORCL>grant?plustrace?to?scott;
授權成功。

sys@ORCL>grant?select?on?v_$sesstat?to?plustrace;
授權成功。

sys@ORCL>grant?select?on?v_$statname?to?plustrace;
授權成功。

sys@ORCL>grant?select?on?v_$mystat?to?plustrace;
授權成功。

sys@ORCL>grant?plustrace?to?dba?with?admin?option;
授權成功。

sys@ORCL>grant?plustrace?to?scott;
授權成功。

sys@ORCL>exit

C:UsersAdministrator>sqlplus?/nolog

SQL*Plus:?Release?11.2.0.1.0?Production?on?星期四?3月?15?15:19:58?2018

Copyright?(c)?1982,?2010,?Oracle.??All?rights?reserved.

idle>conn?scott/123456;
已連接。
scott@ORCL>set?autot?trace?exp?stat;
scott@ORCL>select?*?from?emp;

已選擇14行。


執(zhí)行計劃
----------------------------------------------------------
Plan?hash?value:?3956160932

--------------------------------------------------------------------------
|?Id??|?Operation?????????|?Name?|?Rows??|?Bytes?|?Cost?(%CPU)|?Time?????|
--------------------------------------------------------------------------
|???0?|?SELECT?STATEMENT??|??????|????14?|??1218?|?????3???(0)|?00:00:01?|
|???1?|??TABLE?ACCESS?FULL|?EMP??|????14?|??1218?|?????3???(0)|?00:00:01?|
--------------------------------------------------------------------------

Note
-----
???-?dynamic?sampling?used?for?this?statement?(level=2)


統(tǒng)計信息
----------------------------------------------------------
??????????0??recursive?calls
??????????0??db?block?gets
??????????8??consistent?gets
??????????0??physical?reads
??????????0??redo?size
???????1631??bytes?sent?via?SQL*Net?to?client
????????520??bytes?received?via?SQL*Net?from?client
??????????2??SQL*Net?roundtrips?to/from?client
??????????0??sorts?(memory)
??????????0??sorts?(disk)
?????????14??rows?processed

scott@ORCL>

可以看到登錄之后 SQLPLUS按照login.sql文件進行相應設置