oracle glogin.sql 和login.sql
常用sqlplus的對於其輸出格式有時很不舒服,尤其執行計劃,其中login.sql可以放在SQLPATH下,如set SQLPLUS=D:\app\product\10.2.0\db_1\sqlplus\admin然後將login.sql放在該目錄下
或者login.sql放到當前作業系統使用者的使用者目錄下,如windows下C:\Documents and Settings\Administrator、Linux下/home/oracle;
如下是網上參考的一片文件,轉自:http://blog.csdn.net/robbie1314520/article/details/7388245
oracle 10g在%oracle_home%/sqlplus/admin/下面會有一個glogin.sql檔案,每次sqlplus啟動的時候都會查詢並執行這個檔案,可以用這個檔案來儲存一些設定,如 linesize等
讀完glogin.sql這個檔案之後,oracle還會查詢login.sql這個檔案,這是10G以及以上版本新新增的,9i中不存在,這個檔案通常被放置在%oracle_home%/sqlplus/admin/下
sqlplus 每次啟動前,會讀login.sql(若有的話) ,glogin.sql
login.sql只對某特定使用者生效,它的優先順序高於glogin.sql,glogin.sql是全域性設定。
所以,同一個環境變數,比如linesize ,glogin.sql 和login.sql 都有設定,則login.sql 中的設定起作用。
glogin.sql 的檔案位置固定,在$ORACLE_HOME/sqlplus/admin 下面
login.sql的位置不固定,一般將login.sql放在執行sqlplus 的當前目錄(用pwd檢視當前目錄),即:/home/oralce
cat login.sql
- set serveroutput on size 1000000
- set trimspool on
- set long 5000
- set linesize 100
- set pagesize 9999
- set linesize 154
- col GROUP# for 99
- col THREAD# for 99
- col SEQUENCE# for 9999
- col MEMBER for a50
- col MEMBERS for 99
- col name for a35
- col username for a15
- col file_name for a45
- col tablespace_name for a30
- col MACHINE for a30
- col program for a34
- col sid for 9999
- col spid for a8
- --col value for a50
- col COMMENTS for a50
- col object_owner for a20
- col object_name for a30
- col TABLE_OWNER for a20
- col TABLE_NAME for a30
- col COLUMN_NAME for a30
- col owner for a15;
- col table_owner for a15
- col index_type for a10
- col DB_BLOCK_SIZE for a20
- col UNDO_RETENTION for a30
- col sql_text for a74
- col text for a60
- col r_owner for a15
- col index_owner for a15
- col GRANTEE for a15
- col GRANTOR for a15
- col PRIVILEGE for a35
- col PROPERTY_VALUE for a50
- col LAST_RUN_DURATION for a28
- col DEST_NAME for a20
- col DESTINATION for a30
- col PLAN_TABLE_OUTPUT for a130
- col SCHEMA_NAME for a20
- col OCCUPANT_NAME for a30
- col MOVE_PROCEDURE for a35
- col DESCRIPTION for a50
- col p1 for a30
- col p2 for a30
- col p3 for a30
- col p3text for a46
- col p2text for a46
- col OPERATION for a50
- col OPTIONS for a50
- col statement for a88
- col object for a50
- col error for a35
- col ARCHIVE_NAME for a40
- col segment_name for a25
- col segment_type for a25
- col COMPONENT for a25
- col parameter1 for a35
- col parameter2 for a35
- col parameter3 for a35
- col sql_redo for a90
- col sql_undo for a90
- col log_user for a10
- col priv_user for a10
- col schema_user for a11
- col INTERVAL for a20
- col what for a48
- col seg_name for a30
- col SQL_REDO for a90
- col pval2 for a50
- col event for a50
- col dest_name for a30
- col p1 for 99999999999999
- col p2 for 99999999999999
- col p3 for 99999999999999
- col maxbytes for 999999999999999999
- col MODE_REQUESTED for a30
- col MODE_HELD for a30
- col OPERATION for a30
- col options for a30
- --排程相關
- COL JOB_NAME for A15
- COL JOB_CREATOR for A11
- COL PROGRAM_OWNER for A11
- COL PROGRAM_NAME FOR A12
- COL SCHEDULE_NAME FOR A15
- COL SCHEDULE_OWNER FOR A14;
- col SCHEDULE_TYPE for a13
- COL RESOURCE_PLAN FOR A13;
- COL JOB_CLASS FOR A20
- col START_DATE for a20
- col END_DATE FOR a19
- col PROGRAM_ACTION for a45
- col COMMENTS for a15
- col WINDOW_NAME for a20
- col REPEAT_INTERVAL for a22
- col DURATION for a20
- col NEXT_START_DATE for a18
- col DURATION for a8
- col LAST_START_DATE for a18
- col job_action for a10
- col job_type for a10
- column plan_plus_exp format a80
- 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
set serveroutput on size 1000000 set trimspool on set long 5000 set linesize 100 set pagesize 9999 set linesize 154 col GROUP# for 99 col THREAD# for 99 col SEQUENCE# for 9999 col MEMBER for a50 col MEMBERS for 99 col name for a35 col username for a15 col file_name for a45 col tablespace_name for a30 col MACHINE for a30 col program for a34 col sid for 9999 col spid for a8 --col value for a50 col COMMENTS for a50 col object_owner for a20 col object_name for a30 col TABLE_OWNER for a20 col TABLE_NAME for a30 col COLUMN_NAME for a30 col owner for a15; col table_owner for a15 col index_type for a10 col DB_BLOCK_SIZE for a20 col UNDO_RETENTION for a30 col sql_text for a74 col text for a60 col r_owner for a15 col index_owner for a15 col GRANTEE for a15 col GRANTOR for a15 col PRIVILEGE for a35 col PROPERTY_VALUE for a50 col LAST_RUN_DURATION for a28 col DEST_NAME for a20 col DESTINATION for a30 col PLAN_TABLE_OUTPUT for a130 col SCHEMA_NAME for a20 col OCCUPANT_NAME for a30 col MOVE_PROCEDURE for a35 col DESCRIPTION for a50 col p1 for a30 col p2 for a30 col p3 for a30 col p3text for a46 col p2text for a46 col OPERATION for a50 col OPTIONS for a50 col statement for a88 col object for a50 col error for a35 col ARCHIVE_NAME for a40 col segment_name for a25 col segment_type for a25 col COMPONENT for a25 col parameter1 for a35 col parameter2 for a35 col parameter3 for a35 col sql_redo for a90 col sql_undo for a90 col log_user for a10 col priv_user for a10 col schema_user for a11 col INTERVAL for a20 col what for a48 col seg_name for a30 col SQL_REDO for a90 col pval2 for a50 col event for a50 col dest_name for a30 col p1 for 99999999999999 col p2 for 99999999999999 col p3 for 99999999999999 col maxbytes for 999999999999999999 col MODE_REQUESTED for a30 col MODE_HELD for a30 col OPERATION for a30 col options for a30 --排程相關 COL JOB_NAME for A15 COL JOB_CREATOR for A11 COL PROGRAM_OWNER for A11 COL PROGRAM_NAME FOR A12 COL SCHEDULE_NAME FOR A15 COL SCHEDULE_OWNER FOR A14; col SCHEDULE_TYPE for a13 COL RESOURCE_PLAN FOR A13; COL JOB_CLASS FOR A20 col START_DATE for a20 col END_DATE FOR a19 col PROGRAM_ACTION for a45 col COMMENTS for a15 col WINDOW_NAME for a20 col REPEAT_INTERVAL for a22 col DURATION for a20 col NEXT_START_DATE for a18 col DURATION for a8 col LAST_START_DATE for a18 col job_action for a10 col job_type for a10 column plan_plus_exp format a80 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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14710393/viewspace-751632/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle glogin.sql 和login.sql使用OracleSQL
- Oracle login.sqlOracleSQL
- Oracle 10g glogin.sqlOracle 10gSQL
- oracle中SQLPLUS的Login.sqlOracleSQL
- glogin.sqlSQL
- login.sqlSQL
- glogin.sql?指令碼SQL指令碼
- 定製login.sqlSQL
- Oracle通過login.sql實現永久修改sqlplus引數OracleSQL
- oracle login.sql登入時的環境初始化(unix/linux環境)OracleSQLLinux
- sqlplus中glogin.sql的例子SQL
- sqlplus環境配置(login.sql)SQL
- SQL *Plus設定login.sql登入設定SQL
- sqlplus登陸環境設定(glogin.sql)SQL
- login.sql所在的位置 顯示當前連線的oracle SID及使用者命令 轉載SQLOracle
- glogin.sql配置不當引起sqlplus hang的假象分析SQL
- 如何用glogin.sql控制sqlplus工具的環境配置SQL
- 更改glogin.sql檔案,自定義SQLPLUS使用環境SQL
- [20140221]login.sql與系統安全.txtSQL
- 永久設定sql*plus的環境變數(glogin.sql的設定)SQL變數
- 修改glogin.sql引發的生產系統監控的虛假報警SQL
- [20230124]12c訪問login.sql指令碼.txtSQL指令碼
- oracle exp和impOracle
- oracle imp和expOracle
- Oracle ASMM和AMMOracleASM
- [Oracle] exists 和 not existsOracle
- ORACLE SESSION 和 PROCESSOracleSession
- oracle recyclebin和flashbackOracle
- 【SQLPLUS】sqlplus使用小Tips之glogin.sql統一環境配置檔案SQL
- Oracle例項和Oracle資料庫Oracle資料庫
- oracle中關於in和exists,not in 和 not existsOracle
- 話說 Oracle Audit Vault 和Oracle DB VaultOracle
- oracle 9i 和oracle 10g 和oracle 11g有什麼區別Oracle 10g
- Oracle和Mysql遞迴OracleMySql遞迴
- Oracle pctfree 和 pctusedOracle
- Oracle的spfile和pfileOracle
- Oracle取年和月Oracle
- oracle 表分析和索引Oracle索引