glogin.sql

define_editor=notepad
set serveroutput on size 1000000
set trimspool on
SET PAGESIZE 55
set lines 175
set termout off
define gname=idle
column global_name new_value gname
— Used for the SHOW ERRORS command
COLUMN LINE/COL FORMAT A8
COLUMN ERROR FORMAT A65 WORD_WRAPPED

— Used for the SHOW SGA command
COLUMN name_col_plus_show_sga FORMAT a24

— Defaults for SHOW PARAMETERS
COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME
COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE

— Defaults for SET AUTOTRACE EXPLAIN report
col instance_number format 999 heading ‘Inst’
col startup_time format a15 heading ‘Startup’
col begin_interval_time format a15 heading ‘Begin snap’
col end_interval_time format a15 heading ‘End Snap’
col flush_elapsed format a20 heading ‘flush elapsed’
col error_count format 9999 heading ‘Err#’
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
COLUMN plan_plus_exp FORMAT a80
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp FORMAT a29
COLUMN other_plus_exp FORMAT a44
column argument25 heading ARG25 format a5
column argument24 heading ARG24 format a5
column argument23 heading ARG23 format a5
column argument22 heading ARG22 format a5
column argument21 heading ARG21 format a5
column argument20 heading ARG20 format a5
column argument19 heading ARG19 format a5
column argument18 heading ARG18 format a5
column argument17 heading ARG17 format a5
column argument16 heading ARG16 format a5
column argument15 heading ARG15 format a5
column argument14 heading ARG14 format a5
column argument13 heading ARG13 format a5
column argument12 heading ARG12 format a5
column argument11 heading ARG11 format a5
column argument10 heading ARG10 format a5
column argument9 heading ARG9 format a4
column argument8 heading ARG8 format a4
column argument7 heading ARG7 format a4
column argument6 heading ARG6 format a4
column argument5 heading ARG5 format a4
column argument4 heading ARG4 format a4
column argument3 heading ARG3 format a4
column argument2 heading ARG2 format a4
column argument1 heading ARG1 format a4
column oracle_session_id heading SESSION_ID format 9999999999
column oracle_process_id heading PROC_ID format a7
column os_process_id heading OS_PROC_ID format a10
column print_job_id format a15
column completion_code heading CMPL_CDE format a8
column printer format a15
column description format a45
column req_information format a35
column completion_text format a35
column outfile_name format a55
column logfile_name format a55
column argument_text format a20
column notify_on_pp_error format a20
column nls_codeset format a15
column security_group_id heading SEC_GRP_ID format 9999999999
column nls_territory format a13
column priority heading PRIORTY format 9999999
column priority_request_id heading PRTY_REQ_ID format 9999999999
column nls_language format a11
column responsibility_application_id heading RESP_APP_ID format 9999999999
column program_application_id heading PRGM_APP_ID format 9999999999
column concurrent_program_id heading CONC_PRGM_ID format 99999999999
column print_style format a15
column request_class_application_id heading RQST_CL_APP_ID format 9999999999999
column responsibility_id heading RESP_ID format 9999999
column number_of_arguments heading #_ARGS format 99999
column number_of_copies heading #_COPIES format 9999999
column resubmit_interval heading RESUB_INTVL format 9999999999
column resubmit_interval_unit_code heading RESUB_INTVL_UN_CDE format a17
column resubmit_interval_type_code heading RESUB_INTVL_TP_CDE format a17
column outfile_node_name heading OUTF_NODE_NAME format a13
column logfile_node_name heading LOGF_NODE_NAME format a13
column outcome_product format a14
column controlling_manager heading CNTRL_MGR format 99999999
column logical_ios heading LOG_IOs format 9999999
column physical_ios heading PHYS_IOs format 99999999
column client_pid format a11
column client_dbid format a11
column group# format a11
column remote_template format a5
column dependency format a5
column dest_name format a20
column destination format a45
column error format a20
column alternate format a15
column db_link format a30
column host format a12
column host_name format a25
column target_name format a25
column target_type format a25
column file_name format a55
column os_storage_entity format a55
column os_username format a15
column userhost format a20
column terminal format a15
column obj_name format a30
column new_name format a15
column comment_text format a12
column sql_text format a65
column sql_bind format a25
column directory_path format a65
column timezone_region format a25
column maxbytes format 999999999999
column max_file_size format 999999999999
column file_size format 999999999999
column object_name format a30
column what format a65
column interval format a30
column interval format a40
column nls_env format a65
column what format a70
column log_user format a15
column priv_user format a15
column schema_user format a15
column failures format 99999
column alternate format a15
column argument10 heading ARG10 format a5
column argument11 heading ARG11 format a5
column argument12 heading ARG12 format a5
column argument13 heading ARG13 format a5
column argument14 heading ARG14 format a5
column argument15 heading ARG15 format a5
column argument16 heading ARG16 format a5
column argument17 heading ARG17 format a5
column argument18 heading ARG18 format a5
column argument19 heading ARG19 format a5
column argument1 heading ARG1 format a4
column argument20 heading ARG20 format a5
column argument21 heading ARG21 format a5
column argument22 heading ARG22 format a5
column argument23 heading ARG23 format a5
column argument24 heading ARG24 format a5
column argument25 heading ARG25 format a5
column argument2 heading ARG2 format a4
column argument3 heading ARG3 format a4
column argument4 heading ARG4 format a4
column argument5 heading ARG5 format a4
column argument6 heading ARG6 format a4
column argument7 heading ARG7 format a4
column argument8 heading ARG8 format a4
column argument9 heading ARG9 format a4
column argument_text format a20
column characterset format a20
column client_dbid format a11
column client_pid format a11
column comment_text format a12
column completion_code heading CMPL_CDE format a8
column completion_text format a35
column concurrent_program_id heading CONC_PRGM_ID format 99999999999
column controlling_manager heading CNTRL_MGR format 99999999
column db_link format a30
column default_temp_tablespace format a10
column dependency format a5
column description format a45
column destination format a45
column dest_name format a20
column directory_path format a65
column end_time format a36
column error format a20
COLUMN ERROR FORMAT A65 WORD_WRAPPED
column file_name format a55
column global_name format a30
column group# format a11
column host format a12
column host_name format a25
COLUMN id_plus_exp FORMAT 990 HEADING i
COLUMN LINE/COL FORMAT A8
column logfile_name format a55
column logfile_node_name heading LOGF_NODE_NAME format a13
column logical_ios heading LOG_IOs format 9999999
column message format a55
COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME
COLUMN name_col_plus_show_sga FORMAT a24
column national_characterset format a20
column new_name format a15
column nls_codeset format a15
column nls_language format a11
column nls_territory format a13
column notify_on_pp_error format a20
column number_of_arguments heading #_ARGS format 99999
column number_of_copies heading #_COPIES format 9999999
column object_name format a35
COLUMN object_node_plus_exp FORMAT a8
column obj_name format a30
column operation format a35
column oracle_process_id heading PROC_ID format a7
column oracle_session_id heading SESSION_ID format 9999999999
column os_process_id heading OS_PROC_ID format a10
column os_storage_entity format a55
column os_username format a15
COLUMN other_plus_exp FORMAT a44
COLUMN other_tag_plus_exp FORMAT a29
column outcome_product format a14
column outfile_name format a55
column outfile_node_name heading OUTF_NODE_NAME format a13
column output format a55 wrap
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
column physical_ios heading PHYS_IOs format 99999999
COLUMN plan_plus_exp FORMAT a60
column printer format a15
column print_job_id format a15
column print_style format a15
column priority heading PRIORTY format 9999999
column priority_request_id heading PRTY_REQ_ID format 9999999999
column program_application_id heading PRGM_APP_ID format 9999999999
column remote_template format a5
column req_information format a35
column request_class_application_id heading RQST_CL_APP_ID format 9999999999999
column responsibility_application_id heading RESP_APP_ID format 9999999999
column responsibility_id heading RESP_ID format 9999999
column resubmit_interval heading RESUB_INTVL format 9999999999
column resubmit_interval_type_code heading RESUB_INTVL_TP_CDE format a17
column resubmit_interval_unit_code heading RESUB_INTVL_UN_CDE format a17
COLUMN ROWLABEL FORMAT A15
column security_group_id heading SEC_GRP_ID format 9999999999
column sql_bind format a25
column sql_text format a65
column start_time format a36
column statistics_name format a40
column statistics_view_name format a35
column target format a30
column target_name format a25
column target_type format a25
column terminal format a15
column timezone_region format a25
column userhost format a20
COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE
column compatibility format a15
column database_compatibility heading DB_COMPAT format a15

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s