-- 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
COLUMN id_plus_exp          FORMAT 990 HEADING i
COLUMN parent_id_plus_exp   FORMAT 990 HEADING p
COLUMN plan_plus_exp        FORMAT a60
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp   FORMAT a29
COLUMN other_plus_exp       FORMAT a44

-- MKruse additions
alter session set nls_date_format = 'DD-MON-YY HH24:MI';
set LINESIZE 155
set PAGESIZE 75
set time on
set feedback off
column INST           format 99
column SID            format 9999
column USERNAME       format a16
column OSUSER         format a12
column MACHINE        format a16
column MODULE         format a30
column SQLTEXT        format a50
column SERIAL         format a6
column SERVICE_NAME   format a14
column EVENT          format a40
column MB             format 999,999.9
column MAXMB          format 999,999.9
column NEXTMB         format 99,999.9
column FREEMB         format 999,999.9
column USEDMB         format 999,999.9
column PCTUSED        format 990.0
column FILE_ID        format 999
column FILE_NAME      format a65
column BLOCK_ID       format 9999999
column SEGMENT_NAME   format a30
column SEGMENT_TYPE   format a18
column PARTITION_NAME format a16
column OWNER          format a12
column GRANTEE        format a16
column GRANTOR        format a10
column OBJECT_NAME    format a35
column TABLE_OWNER    format a10
column REDOKB         format 9,999.9
column HOST           format a15
column DB_LINK        format a15
column SUBPARTITION_NAME format a16
column SEGMENT        format a8 
column START_TIME     format a18 
column STATUS         format a8 
column USAGE          format a32
column PIN            format a10
column REQ            format a10
column COMPONENT      format a25

-- OEM
column host_name        format a9
column display_name     format a35
column type_display_name format a28
column database_type    format a17
column version          format a10
column operating_system format a20
column platform         format a30
column group_name       format a15

-- GG Heartbeat
column src_db        format a9
column source_commit format a26
column target_commit format a26
column update_timestamp format a26
column captime       format a26
column pmptime       format a26
column deltime       format a26
