Winzipper/Winzipper_ISO.iso/programming/oracle7 7.2/DB/UTIL72/KBCUS.ORA

Text File | 1995-05-18 | 75.5 KB | 2,526 lines

#
# $Header: kbcus.ora 7020200.1 95/02/15 20:49:51 cli Generic<base> $
#
#  Copyright (c) 1991 by Oracle Corporation
#    NAME
#      kbcus.ora - SQL*DBA Character-mode version of the initialization file
#    DESCRIPTION
#      Init file for screen-mode SQL*DBA
#    NOTES
#      A 'MODIFIER=' has to be one that is accepted by toolkit (see the tk
#      reference manual for a list of possible values).  A 'KEYCAP=' can be
#      ALMOST any value defined by the toolkit manual (the reason is obvious).
#      Finally, a key and keycap cannot be used simultaneously for the same
#      hot key.
#    MODIFIED   (MM/DD/YY)
#     dsternbe   01/13/95 -  211272 - Fix Process Monitor
#     dsternbe   01/13/95 -  160599 - Fix ALTER USER QUOTA
#     sjoe       08/02/94 -  NLSRTL loadable data changes
#     sjoe       05/10/94 -  187200 - monitor process terminal incorrect
#     sjoe       12/14/93 -  180478 - monitor process truncates termid
#     sjoe       11/24/93 -  174259 - monitor sqlarea uses lots of tmp
#     sjoe       11/02/93 -  #166860 - monitor statistics don't show parallel
#     sjoe       11/02/93 -  merge changes from branch 1.11.312.4
#     rnakhwa    04/28/93 -  Bug # 153745
#     rnakhwa    04/28/93 -  merge changes from branch 1.11.312.3
#     rnakhwa    04/07/93 -  Merge changes from 7.0.14
#     rnakhwa    04/16/93 -  Bug # 158162
#     rnakhwa    04/06/93 -  Bug # 156421
#     rnakhwa    03/29/93 -  Bug # 149425
#     rnakhwa    12/15/92 -  Bug # 143257
#     rnakhwa    12/08/92 -  Change monitor rollback to use undo$
#     rnakhwa    12/04/92 -  Remove SYSTEM GRANT auditing option from grant/rev
#     agupta     12/02/92 -  v$rollstat change
#     rnakhwa    12/01/92 -  Internal error code # 10625
#     rnakhwa    11/30/92 -  Mismatched parenthesis in kill session list
#     rnakhwa    11/30/92 -  Nlssize specialmenuid=
#     bmahbod    11/29/92 -  fix bug 140421: add ParServ and SQL to
#                            system and session monitor statistics
#     agupta     11/28/92 -  NLSize mnemonics, accelerators
#     rnakhwa    11/25/92 -  nlssize help= markers in sqldba
#     rnakhwa    11/25/92 -  Creation

REM **********************************************************************
REM     MENUBAR Session Menu
REM **********************************************************************
{ DEFINE ITEM CONNECT_I [TITLE=11000 MNEMONIC=11001 MODIFIER=UIKY_MODIF_ALT
   KEY=o]
  RETURNS [{CONNECT_G()}]
};

{ DEFINE ITEM DISCONNECT_I [TITLE=11002 MNEMONIC=11003 ALERT=10000 HELP=14000]
  RETURNS [disconnect]
};

{ DEFINE ITEM HOST_I [TITLE=11004 MNEMONIC=11005]
  RETURNS [{SYSTEM_G()}]
};

{ DEFINE ITEM HOSTOUT_I [TITLE=11006 MNEMONIC=11007 HELP=14001]
  RETURNS [host]
};

{ DEFINE ITEM SERVERON_I [TITLE=11008 MNEMONIC=11009]
  RETURNS [{SERVERON_G()}]
};

{ DEFINE ITEM SERVEROFF_I [TITLE=11010 MNEMONIC=11011]
  RETURNS [set serveroutput off]
};

{ DEFINE MENU T_SESSION [TITLE=11012 MNEMONIC=11013]
  ITEM CONNECT_I
  ITEM DISCONNECT_I
  SEPARATOR
  ITEM HOST_I
  ITEM HOSTOUT_I
  SEPARATOR
  ITEM SERVERON_I
  ITEM SERVEROFF_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Instance Menu
REM **********************************************************************
{ DEFINE ITEM STARTUP_I [TITLE=11050 MNEMONIC=11051 MODIFIER=UIKY_MODIF_ALT
   KEY=p]
  RETURNS [{STARTUP_G()}]
};

{ DEFINE ITEM NORMAL_I [TITLE=11052 MNEMONIC=11053 HELP=14002 ALERT=10001]
  RETURNS [normal]
};

{ DEFINE ITEM IMMEDIATE_I [TITLE=11054 MNEMONIC=11055 HELP=14003 ALERT=10002]
  RETURNS [immediate]
};

{ DEFINE ITEM ABORT_I [TITLE=11056 MNEMONIC=11057 HELP=14004 ALERT=10003]
  RETURNS [abort]
};

{ DEFINE MENU SHUTDOWN_M [TITLE=11058 MNEMONIC=11059]
  ITEM NORMAL_I
  ITEM IMMEDIATE_I
  ITEM ABORT_I
  RETURNS [shutdown {:0}]
};

{ DEFINE ITEM EXCLUSIVE_I [TITLE=11060 MNEMONIC=11061 ALERT=10004]
  RETURNS [exclusive]
};

{ DEFINE ITEM PARALLEL_I [TITLE=11062 MNEMONIC=11063 ALERT=10005]
  RETURNS [parallel]
};

{ DEFINE MENU MOUNT_M [TITLE=11064 MNEMONIC=11065]
  ITEM EXCLUSIVE_I
  ITEM PARALLEL_I
  RETURNS [alter database mount {:0}]
};

{ DEFINE ITEM OPENDB_I [TITLE=11066 MNEMONIC=11067 ALERT=10006]
  RETURNS [alter database open]
};

{ DEFINE ITEM LOCAL_I [TITLE=11068 MNEMONIC=11069 HELP=14005 ALERT=10007]
  RETURNS [local]
};

{ DEFINE ITEM GLOBAL_I [TITLE=11070 MNEMONIC=11071 HELP=14006 ALERT=10008]
  RETURNS [global]
};

{ DEFINE MENU CHECKPOINT_M [TITLE=11072 MNEMONIC=11073]
  ITEM LOCAL_I
  ITEM GLOBAL_I
  RETURNS [alter system checkpoint {:0}]
};

{ DEFINE ITEM LOGSWITCH_I [TITLE=11074 MNEMONIC=11075 HELP=14007 ALERT=10009]
  RETURNS [alter system switch logfile]
};

{ DEFINE ITEM CONFIGDISP_I [TITLE=11076 MNEMONIC=11077]
  RETURNS [{CONFIGDISP_G()}]
};

{ DEFINE ITEM CONFIGSERV_I [TITLE=11078 MNEMONIC=11079]
  RETURNS [{CONFIGSERV_G()}]
};

{ DEFINE ITEM PREVCON_I [TITLE=11080 MNEMONIC=11081 HELP=14008 ALERT=10010]
  RETURNS [alter system enable restricted session]
};

{ DEFINE ITEM ALLOWCON_I [TITLE=11082 MNEMONIC=11083 HELP=14009 ALERT=10011]
  RETURNS [alter system disable restricted session]
};

{ DEFINE ITEM KILLSESS_I [TITLE=11084 MNEMONIC=11085
   MODIFIER=UIKY_MODIF_ALT KEY=s]
  RETURNS [{KILLSESS_G()}]
};

{ DEFINE ITEM RECOVER_TXN_I [TITLE=11086 MNEMONIC=11087]
  RETURNS [{2PC_TRANS_G()}]
};

{ DEFINE MENU T_INSTANCE [TITLE=11088 MNEMONIC=11089]
  ITEM STARTUP_I
  ITEM SHUTDOWN_M
  SEPARATOR
  ITEM MOUNT_M
  ITEM OPENDB_I
  SEPARATOR
  ITEM CHECKPOINT_M
  ITEM LOGSWITCH_I
  SEPARATOR
  ITEM CONFIGDISP_I
  ITEM CONFIGSERV_I
  SEPARATOR
  ITEM PREVCON_I
  ITEM ALLOWCON_I
  ITEM KILLSESS_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Tablespace Menu
REM **********************************************************************
{ DEFINE ITEM CREATETS_I [TITLE=11100 MNEMONIC=11101]
  RETURNS [{CREATETS_G()}]
};

{ DEFINE ITEM DROPTS_I [TITLE=11102 MNEMONIC=11103]
  RETURNS [{DROPTS_G()}]
};

{ DEFINE ITEM ONLINETS_I [TITLE=11104 MNEMONIC=11105 MODIFIER=UIKY_MODIF_ALT
   KEY=n]
  RETURNS [{ONLINETS_G()}]
};

{ DEFINE ITEM OFFLINETS_I [TITLE=11106 MNEMONIC=11107
   MODIFIER=UIKY_MODIF_ALT KEY=f]
  RETURNS [{OFFLINETS_G()}]
};

{ DEFINE ITEM ADD_DATAFILE_I [TITLE=11108 MNEMONIC=11109]
  RETURNS [{ADDFILETS_G()}]
};

{ DEFINE ITEM RENAME_DATAFILE_I [TITLE=11110 MNEMONIC=11111]
  RETURNS [{RENAMEDFTS_G()}]
};

{ DEFINE ITEM ALTER_DEF_STORE_I [TITLE=11112 MNEMONIC=11113]
  RETURNS [{STORAGETS_G()}]
};

{ DEFINE MENU T_TABLESPACE [TITLE=11114 MNEMONIC=11115]
  ITEM CREATETS_I
  ITEM DROPTS_I
  SEPARATOR
  ITEM ONLINETS_I
  ITEM OFFLINETS_I
  SEPARATOR
  ITEM ADD_DATAFILE_I
  ITEM RENAME_DATAFILE_I
  SEPARATOR
  ITEM ALTER_DEF_STORE_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Rollback Segments Menu
REM **********************************************************************
{ DEFINE ITEM CREATERBS_I [TITLE=11150 MNEMONIC=11151]
  RETURNS [{CREATERBS_G()}]
};

{ DEFINE ITEM DROPRBS_I [TITLE=11152 MNEMONIC=11153]
  RETURNS [{DROPRB_G()}]
};

{ DEFINE ITEM SETONRBS_I [TITLE=11154 MNEMONIC=11155]
  RETURNS [{ONLINERB_G()}]
};

{ DEFINE ITEM SETOFFRBS_I [TITLE=11156 MNEMONIC=11157]
  RETURNS [{OFFLINERB_G()}]
};

{ DEFINE ITEM STORAGERBS_I [TITLE=11158 MNEMONIC=11159]
  RETURNS [{STORAGERB_G()}]
};

{ DEFINE MENU T_RBSEGS [TITLE=11160 MNEMONIC=11161]
  ITEM CREATERBS_I
  ITEM DROPRBS_I
  SEPARATOR
  ITEM SETONRBS_I
  ITEM SETOFFRBS_I
  SEPARATOR
  ITEM STORAGERBS_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Log Menu
REM **********************************************************************
{ DEFINE ITEM ADDGRP_I [TITLE=11200 MNEMONIC=11201]
  RETURNS [{LOGADDG_G()}]
};

{ DEFINE ITEM DROPGP_I [TITLE=11202 MNEMONIC=11203]
  RETURNS [{LOGDROPG_G()}]
};

{ DEFINE ITEM ADDMEM_I [TITLE=11204 MNEMONIC=11205]
  RETURNS [{LOGADDM_G()}]
};

{ DEFINE ITEM MOVEMEM_I [TITLE=11206 MNEMONIC=11207]
  RETURNS [{LOGMOVEM_G()}]
};

{ DEFINE ITEM DROPMEM_I [TITLE=11208 MNEMONIC=11209]
  RETURNS [{LOGDROPM_G()}]
};

{ DEFINE ITEM ENABLETHR_I [TITLE=11210 MNEMONIC=11211]
  RETURNS [{LOGENABLET_G()}]
};

{ DEFINE ITEM DISABLETHR_I [TITLE=11212 MNEMONIC=11213]
  RETURNS [{LOGDISABLET_G()}]
};

{ DEFINE ITEM STARTA_ARCHIVE_I [TITLE=11214 MNEMONIC=11215]
  RETURNS [{LOGARCHA_G()}]
};

{ DEFINE ITEM STOPA_ARCHIVE_I [TITLE=11216 MNEMONIC=11217 ALERT=10012
    HELP=14010]
  RETURNS [alter system archive log stop]
};

{ DEFINE ITEM BEGIN_MAN_ARCH_I [TITLE=11218 MNEMONIC=11219]
  RETURNS [{LOGARCHM_G()}]
};

{ DEFINE ITEM LIST_MAN_ARCH_I [TITLE=11220 MNEMONIC=11221 HELP=14011]
  RETURNS [archive log list]
};

{ DEFINE MENU T_LOGS [TITLE=11222 MNEMONIC=11223]
  ITEM ADDGRP_I
  ITEM DROPGP_I
  SEPARATOR
  ITEM ADDMEM_I
  ITEM MOVEMEM_I
  ITEM DROPMEM_I
  SEPARATOR
  ITEM ENABLETHR_I
  ITEM DISABLETHR_I
  SEPARATOR
  ITEM STARTA_ARCHIVE_I
  ITEM STOPA_ARCHIVE_I
  ITEM BEGIN_MAN_ARCH_I
  ITEM LIST_MAN_ARCH_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Backup Menu
REM **********************************************************************
{ DEFINE ITEM START_BACKUP_I [TITLE=11250
   MNEMONIC=11251 MODIFIER=UIKY_MODIF_ALT KEY=t]
  RETURNS [{BACKUP_TS_S_G()}]
};

{ DEFINE ITEM STOP_BACKUP_I [TITLE=11252 MNEMONIC=11253
   MODIFIER=UIKY_MODIF_ALT KEY=e]
  RETURNS [{BACKUP_TS_E_G()}]
};

{ DEFINE ITEM RECOVER_DB_I [TITLE=11254 MNEMONIC=11255]
  RETURNS [{RECOVER_DB_G()}]
};

{ DEFINE ITEM RECOVER_TS_I [TITLE=11256 MNEMONIC=11257]
  RETURNS [{RECOVER_TS_G()}]
};

{ DEFINE ITEM RECOVER_FILE_I [TITLE=11258 MNEMONIC=11259]
  RETURNS [{RECOVER_FILE_G()}]
};

{ DEFINE MENU T_BACKUP [TITLE=11260 MNEMONIC=11261]
  ITEM START_BACKUP_I
  ITEM STOP_BACKUP_I
  SEPARATOR
  ITEM RECOVER_DB_I
  ITEM RECOVER_TS_I
  ITEM RECOVER_FILE_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Security Menu
REM **********************************************************************
{ DEFINE ITEM CREATE_USER_I [TITLE=11300 MNEMONIC=11301
   MODIFIER=UIKY_MODIF_ALT KEY=u]
  RETURNS [{USERCREAT_G()}]
};

{ DEFINE ITEM ALTER_USER_I [TITLE=11302 MNEMONIC=11303]
  RETURNS [{USERALTER_G()}]
};

{ DEFINE ITEM DROP_USER_I [TITLE=11304 MNEMONIC=11305
   MODIFIER=UIKY_MODIF_ALT KEY=d]
  RETURNS [{USERDROP_G()}]
};

{ DEFINE ITEM CREATE_ROLE_I [TITLE=11306 MNEMONIC=11307]
  RETURNS [{ROLECREAT_G()}]
};

{ DEFINE ITEM ALTER_ROLE_I [TITLE=11308 MNEMONIC=11309]
  RETURNS [{ROLEALTER_G()}]
};

{ DEFINE ITEM DROP_ROLE_I [TITLE=11310 MNEMONIC=11311]
  RETURNS [{ROLEDROP_G()}]
};

{ DEFINE ITEM CREATE_PROFILE_I [TITLE=11312 MNEMONIC=11313]
  RETURNS [{PROFCREAT_G()}]
};

{ DEFINE ITEM ALTER_PROFILE_I [TITLE=11314 MNEMONIC=11315]
  RETURNS [{PROFALTER_G()}]
};

{ DEFINE ITEM DROP_PROFILE_I [TITLE=11316 MNEMONIC=11317]
  RETURNS [{PROFDROP_G()}]
};

{ DEFINE ITEM ALTER_RESCOST_I [TITLE=11318 MNEMONIC=11319]
  RETURNS [{RESCOST_G()}]
};

{ DEFINE ITEM GRANT_I [TITLE=11320 MNEMONIC=11321 MODIFIER=UIKY_MODIF_ALT
   KEY=g]
  RETURNS [{GRANT_G()}]
};

{ DEFINE ITEM REVOKE_I [TITLE=11322 MNEMONIC=11323 MODIFIER=UIKY_MODIF_ALT
   KEY=r]
  RETURNS [{REVOKE_G()}]
};

{ DEFINE MENU T_SECURITY [TITLE=11324 MNEMONIC=11325]
  ITEM CREATE_USER_I
  ITEM ALTER_USER_I
  ITEM DROP_USER_I
  SEPARATOR
  ITEM CREATE_ROLE_I
  ITEM ALTER_ROLE_I
  ITEM DROP_ROLE_I
  SEPARATOR
  ITEM CREATE_PROFILE_I
  ITEM ALTER_PROFILE_I
  ITEM DROP_PROFILE_I
  ITEM ALTER_RESCOST_I
  SEPARATOR
  ITEM GRANT_I
  ITEM REVOKE_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR Monitor Menu
REM **********************************************************************

{ DEFINE ITEM SHARED_I [TITLE=11350 MNEMONIC=11351]
  RETURNS [shared]
};

{ DEFINE ITEM DISPATCHER_I [TITLE=11352 MNEMONIC=11353]
  RETURNS [dispatcher]
};

{ DEFINE ITEM CIRCUIT_I [TITLE=11354 MNEMONIC=11355]
  RETURNS [circuit]
};

{ DEFINE ITEM QUEUE_I [TITLE=11356 MNEMONIC=11357]
  RETURNS [queue]
};

{ DEFINE MENU MULTI_M [TITLE=11358 MNEMONIC=11359]
  ITEM SHARED_I
  ITEM DISPATCHER_I
  ITEM CIRCUIT_I
  ITEM QUEUE_I
  RETURNS [{:0}]
};

{ DEFINE ITEM PROCESS_I [TITLE=11360 MNEMONIC=11361]
  RETURNS [process]
};

{ DEFINE ITEM SESSION_I [TITLE=11362 MNEMONIC=11363]
  RETURNS [session]
};

{ DEFINE ITEM TABLE_I [TITLE=11364 MNEMONIC=11365]
  RETURNS [table]
};

{ DEFINE ITEM SQLAREA_I [TITLE=11366 MNEMONIC=11367]
  RETURNS [sqlarea]
};

{ DEFINE ITEM LCACHE_I [TITLE=11368 MNEMONIC=11369]
  RETURNS [lcache]
};

{ DEFINE ITEM LATCH_I [TITLE=11370 MNEMONIC=11371]
  RETURNS [latch]
};

{ DEFINE ITEM LOCK_I [TITLE=11372 MNEMONIC=11373]
  RETURNS [lock]
};

{ DEFINE ITEM IO_I [TITLE=11374 MNEMONIC=11375]
  RETURNS [systemio]
};

{ DEFINE ITEM FILEIO_I [TITLE=11376 MNEMONIC=11377]
  RETURNS [fileio]
};

{ DEFINE ITEM ROLLBACK_I [TITLE=11378 MNEMONIC=11379]
  RETURNS [rollback]
};

{ DEFINE ITEM STAT_SESSION_I [TITLE=11380 MNEMONIC=11381]
  RETURNS [sessionstatistic]
};

{ DEFINE ITEM STAT_SYSTEM_I [TITLE=11382 MNEMONIC=11383]
  RETURNS [systemstatistic]
};

{ DEFINE MENU STAT_M [TITLE=11384 MNEMONIC=11385]
   ITEM STAT_SESSION_I
   ITEM STAT_SYSTEM_I
  RETURNS [{:0}]
};

{ DEFINE MENU T_MONITOR [TITLE=11386 MNEMONIC=11387]
   ITEM MULTI_M
   ITEM PROCESS_I
   ITEM SESSION_I
   ITEM TABLE_I
   ITEM SQLAREA_I
   ITEM LCACHE_I
   ITEM LATCH_I
   ITEM LOCK_I
   ITEM FILEIO_I
   ITEM IO_I
   ITEM ROLLBACK_I
   ITEM STAT_M
  RETURNS [monitor {:0}]
};

REM **********************************************************************
REM     MENUBAR - Storage
REM **********************************************************************

{ DEFINE MENU T_STORAGE [TITLE=11400 MNEMONIC=11401]
   ITEM T_TABLESPACE
   SEPARATOR
   ITEM T_RBSEGS
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR - File
REM **********************************************************************
{ DEFINE ITEM BATCH_I [TITLE=11450 MNEMONIC=11451]
  RETURNS [{BATCH_G()}]
};

{ DEFINE ITEM SPLON_I [TITLE=11452 MNEMONIC=11453]
  RETURNS [{SPLON_G()}]
};

{ DEFINE ITEM SPLOFF_I [TITLE=11454 MNEMONIC=11455 HELP=14012 ALERT=10013]
  RETURNS [spool off]
};

{ DEFINE ITEM QUIT_I [TITLE=11456 MNEMONIC=11457 ALERT=10014
   MODIFIER=UIKY_MODIF_ALT KEY=q HELP=14013]
  RETURNS [exit]
};

{ DEFINE MENU T_FILE [TITLE=11458 MNEMONIC=11459]
   ITEM BATCH_I
   SEPARATOR
   ITEM SPLON_I
   ITEM SPLOFF_I
   SEPARATOR
   ITEM QUIT_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR - Edit
REM **********************************************************************
{ DEFINE ITEM CUT_I [TITLE=11500 MNEMONIC=11501 SPECIALMENUID=215 HELP=14014
   MODIFIER=UIKY_MODIF_ALT KEY=x]
  RETURNS [ ]
};

{ DEFINE ITEM COPY_I [TITLE=11502 MNEMONIC=11503 SPECIALMENUID=216 HELP=14015
   MODIFIER=UIKY_MODIF_ALT KEY=c]
  RETURNS [ ]
};

{ DEFINE ITEM PASTE_I [TITLE=11504 MNEMONIC=11505 SPECIALMENUID=221
   HELP=14016 MODIFIER=UIKY_MODIF_ALT KEY=v]
  RETURNS [ ]
};

{ DEFINE ITEM CLEAR_I [TITLE=11506 MNEMONIC=11507 SPECIALMENUID=220
   HELP=14017 MODIFIER=UIKY_MODIF_ALT KEY=b]
  RETURNS [ ]
};

REM ** Previous Command Menu Item now returns title value instead of string **
REM ** so string isn't inadvertently translated.
{ DEFINE ITEM PREV_I [TITLE=11508 MNEMONIC=11509 HELP=14018
   MODIFIER=UIKY_MODIF_ALT KEY=i]
  RETURNS [11508]
};

REM ** Next Command Menu Item now returns tile value instead of string **
REM ** so string isn't inadvertently translated.
{ DEFINE ITEM NEXT_I [TITLE=11510 MNEMONIC=11511 HELP=14019
   MODIFIER=UIKY_MODIF_ALT KEY=j]
  RETURNS [11510]
};

{ DEFINE MENU T_EDIT [TITLE=11512 MNEMONIC=11513]
    ITEM CUT_I
    ITEM COPY_I
    ITEM PASTE_I
    ITEM CLEAR_I
    SEPARATOR
    ITEM PREV_I
    ITEM NEXT_I
    RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR - Help
REM **********************************************************************
{ DEFINE ITEM ABOUT_I [TITLE=11550 MNEMONIC=11551 SPECIALMENUID=219]
  RETURNS [ ]
};

{ DEFINE ITEM HELP_I [TITLE=11552 MNEMONIC=11553 SPECIALMENUID=217
   MODIFIER=UIKY_MODIF_ALT KEY=h]
  RETURNS [ ]
};

REM ** Show Keys Menu Item now returns title value instead of string **
REM ** so string isn't inadvertently translated.
{ DEFINE ITEM SHOWKEYS_I [TITLE=11554 MNEMONIC=11555 MODIFIER=UIKY_MODIF_ALT
   KEY=k]
  RETURNS [11554]
};

{ DEFINE MENU T_HELP [TITLE=11556 MNEMONIC=11557]
    ITEM ABOUT_I
    ITEM HELP_I
    ITEM SHOWKEYS_I
    RETURNS [{:0}]
};

REM **********************************************************************
REM     MENUBAR - top level menu
REM **********************************************************************
{ DEFINE MENU TOPMENU [TITLE=11600]
   ITEM T_FILE
   ITEM T_EDIT
   ITEM T_SESSION
   ITEM T_INSTANCE
   ITEM T_STORAGE
   ITEM T_LOGS
   ITEM T_BACKUP
   ITEM T_SECURITY
   ITEM T_MONITOR
   ITEM T_HELP
  RETURNS [{:0}]
};

REM **********************************************************************
REM    File Dialog Definitions - Items under menu File
REM **********************************************************************
{ DEFINE GROUP BATCH_G [TITLE=12001 HEIGHT=4 WIDTH=60 X=10 Y=8 HELP=14020]
  RETURNS [@{
   CHECKBOX(X=1 Y=1 TITLE=12002 HELP=14021 ONVALUE=@)}{
   FIELD(X=24 Y=3 TITLE=12003 WIDTH=35 OPTIONAL=0 HELP=14022)}]
};

{ DEFINE GROUP SPLON_G [TITLE=12050 HEIGHT=2 WIDTH=54 X=13 Y=8 HELP=14023]
  RETURNS [spool {FIELD(X=12 Y=1 TITLE=12051 WIDTH=41 OPTIONAL=0 HELP=14024)}]
};

REM **********************************************************************
REM    Session Dialog Definitions - Items under menu Session
REM **********************************************************************
{ DEFINE GROUP CONNECT_G [TITLE=12100 HEIGHT=3 WIDTH=43 X=18 Y=7 HELP=14025]
  RETURNS [connect {
   FIELD(X=11 Y=1 TITLE=12101 WIDTH=30 MAXLEN=30 OPTIONAL=0 HELP=14026)}{
   FIELD(X=11 Y=2 TITLE=12102 WIDTH=30 MAXLEN=30 SECURE=1 PREFIX=/
     HELP=14027)}]
};

{ DEFINE GROUP SERVERON_G [TITLE=12150 HEIGHT=2 WIDTH=30 X=25 Y=8 HELP=14028]
  RETURNS [set serveroutput on {
   FIELD(X=7 Y=1 TITLE=12151 WIDTH=9 PREFIX=[size ] HELP=14029)}]
};

{ DEFINE GROUP SYSTEM_G [TITLE=12200 HEIGHT=2 WIDTH=44 X=18 Y=8 HELP=14030]
  RETURNS [host {
   FIELD(X=10 Y=1 WIDTH=32 TITLE=12201 OPTIONAL=0 HELP=14031)}]
};

REM **********************************************************************
REM    Instance Dialog Definitions - Items under menu Instance
REM **********************************************************************
{ DEFINE GROUP STARTUP_G [TITLE=12250 HEIGHT=16 WIDTH=47 X=16 Y=2 HELP=14032]
  RETURNS [startup {
   STARTUP_OPEN_R(X=1 Y=1)}{
   FIELD(X=17 Y=11 TITLE=12251 WIDTH=26 PREFIX=[ pfile=] HELP=14033)}{
   CHECKBOX(X=1 Y=13 TITLE=12252 ONVALUE=[ force] HELP=14034)}{
   CHECKBOX(X=1 Y=14 TITLE=12253 ONVALUE=[ restrict] HELP=14035)}{
   CHECKBOX(X=1 Y=15 TITLE=12254 ONVALUE=[ recover] HELP=14036)}]
};

{ DEFINE ITEM STARTUP_OPEN_I [TITLE=12255 DEFAULT=1 HELP=14037]
  RETURNS [{
   STARTUP_EXCLUSIVE1_R(X=6 Y=1)}{
   CHECKBOX(X=30 Y=2 DEFAULT=0 ONVALUE=[ retry] TITLE=12256 HELP=14038)} open {
   FIELD(X=21 Y=3 TITLE=12257 WIDTH=21 HELP=14039)}]
};

{ DEFINE ITEM STARTUP_MOUNT_I [TITLE=12258 Y=4 HELP=14040]
  RETURNS [{
   STARTUP_EXCLUSIVE2_R(X=6 Y=1)}{
   CHECKBOX(X=30 Y=2 DEFAULT=0 ONVALUE=[ retry] TITLE=12256
        HELP=14041)} mount {
   FIELD(X=21 Y=3 TITLE=12257 WIDTH=21 HELP=14042)}]
};

{ DEFINE ITEM STARTUP_NOMOUNT_I [TITLE=12259 Y=8 HELP=14043]
  RETURNS [nomount]
};

{ DEFINE RADIO STARTUP_OPEN_R [HEIGHT=9]
   ITEM STARTUP_OPEN_I
   ITEM STARTUP_MOUNT_I
   ITEM STARTUP_NOMOUNT_I
  RETURNS [{:0}]
};

{ DEFINE ITEM STARTUP_EXCLUSIVE1_I [TITLE=12260 DEFAULT=1 HELP=14044]
  RETURNS [exclusive]
};

{ DEFINE ITEM STARTUP_PARALLEL1_I [TITLE=12261 Y=1 HELP=14045]
  RETURNS [parallel]
};

{ DEFINE RADIO STARTUP_EXCLUSIVE1_R [HEIGHT=2]
   ITEM STARTUP_EXCLUSIVE1_I
   ITEM STARTUP_PARALLEL1_I
  RETURNS [{:0}]
};

{ DEFINE ITEM STARTUP_EXCLUSIVE2_I [TITLE=12260 DEFAULT=1 HELP=14046]
  RETURNS [exclusive]
};

{ DEFINE ITEM STARTUP_PARALLEL2_I [TITLE=12261 Y=1 HELP=14047]
  RETURNS [parallel]
};

{ DEFINE RADIO STARTUP_EXCLUSIVE2_R [HEIGHT=2]
   ITEM STARTUP_EXCLUSIVE2_I
   ITEM STARTUP_PARALLEL2_I
  RETURNS [{:0}]
};

{ DEFINE GROUP CONFIGDISP_G [TITLE=12300 HEIGHT=4 WIDTH=40 X=20 Y=5
   MULTICHOICE=1 PREFIX=[alter system set ] SEPARATOR=[ ] HELP=14048]
  RETURNS [mts_dispatchers=\'{
   FIELD(TITLE=12301 X=24 Y=1 WIDTH=10 OPTIONAL=0 HELP=14049)},{
   FIELD(TITLE=12302  X=24 Y=3 WIDTH=5 OPTIONAL=0 HELP=14050)}\']
};

{ DEFINE GROUP CONFIGSERV_G [TITLE=12350 HEIGHT=2 WIDTH=43 X=19 Y=9 HELP=14051]
  RETURNS [alter system set mts_servers={
   FIELD(TITLE=12351 WIDTH=5 X=36 Y=1 OPTIONAL=0 HELP=14052)}]
};

{ DEFINE GROUP KILLSESS_G [TITLE=12400 WIDTH=54 HEIGHT=8 X=13 Y=4 HELP=14053]
  RETURNS [alter system kill session \'{
   KILLSESS_L(X=1 Y=2 ERRORNO=345 HELP=14054)}\']
};

{ DEFINE ITEM KILLSESSL_I [ ]
   QUERY [select
          to_char(sid, '099999') || '   ' || to_char(serial#, '09999')
          || '  ' || username, sid, serial# from v$session
          where username is not null and status != 'KILLED']
  RETURNS [{:1},{:2}]
};

{ DEFINE LIST KILLSESS_L [TITLE=12401 WIDTH=52 HEIGHT=6 X=10 Y=5 OPTIONAL=0]
   ITEM KILLSESSL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP 2PC_TRANS_G [TITLE=12450 WIDTH=58 HEIGHT=10 X=11 Y=5 HELP=14055]
  RETURNS [{
   2PC_TRANS_R(X=1 Y=1)} force \'{
   2PC_TRANS_L(X=1 Y=5 ERRORNO=346)}\']
};

{ DEFINE ITEM 2PC_COMMIT_I [TITLE=12451 DEFAULT=1 HELP=14056]
  RETURNS [commit]
};

{ DEFINE ITEM 2PC_ROLLBACK_I [TITLE=12452 Y=1 HELP=14057]
  RETURNS [rollback]
};

{ DEFINE RADIO 2PC_TRANS_R [HEIGHT=2]
   ITEM 2PC_COMMIT_I
   ITEM 2PC_ROLLBACK_I
  RETURNS [{:0}]
};

{ DEFINE ITEM 2PC_TRANSL_I [ ]
   QUERY [select substr(decode(ltrim(lpad(nvl(global_oracle_id,
                                          local_tran_id), 51)),
      nvl(global_oracle_id, local_tran_id),
        nvl(global_oracle_id, local_tran_id),
      '...' || substr(lpad(nvl(global_oracle_id, local_tran_id), 2000),
      -48)), 1, 51) "column",
      nvl(global_oracle_id, local_tran_id) from sys.pending_trans$
      where state = 'prepared']
  RETURNS [{:1}]
};

{ DEFINE LIST 2PC_TRANS_L [TITLE=12453 WIDTH=56 HEIGHT=5 X=13 Y=7 OPTIONAL=0
    HELP=14058] ITEM 2PC_TRANSL_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM    Tablespace Dialog Definitions - Items under menu Tablespace
REM **********************************************************************
{ DEFINE GROUP CREATETS_G [TITLE=12500 WIDTH=46 HEIGHT=9 X=17 Y=4 HELP=14059]
  RETURNS [create tablespace {
   FIELD(TITLE=12501 X=7 Y=1 WIDTH=30 MAXLEN=30 OPTIONAL=0
     HELP=14060)} datafile {
   FIELD(TITLE=12502 X=13 Y=3 WIDTH=30 HELP=14061
         OPTIONAL=0 INVOKE=[{FILESPEC_G(MULTICHOICE=1 Y=4)}])}{
   FIELD(TITLE=12503 X=10 Y=5 WIDTH=30 PREFIX=[ default storage (]
    SUFFIX=[)] HELP=14062 INVOKE=[{STORAGE_G(TITLE=12504)}])}{
   CREATETS_R(TITLE=12505 X=1 Y=7)}]
};

{ DEFINE ITEM CREATETS_ONLINE_I [TITLE=12506 DEFAULT=1 HELP=14063]
  RETURNS [ online]
};

{ DEFINE ITEM CREATETS_OFFLINE_I [TITLE=12507 Y=1 HELP=14064]
  RETURNS [ offline]
};

{ DEFINE RADIO CREATETS_R [TITLE=12505 HEIGHT=2]
   ITEM CREATETS_ONLINE_I
   ITEM CREATETS_OFFLINE_I
  RETURNS [{:0}]
};

{ DEFINE GROUP FILESPEC_G [TITLE=12550 WIDTH=50 HEIGHT=4 X=15 Y=10 HELP=14065]
  RETURNS [\'{
   FIELD(TITLE=12551 X=11 Y=1 WIDTH=29 OPTIONAL=0 HELP=14066)}\'{
   CHECKBOX(TITLE=12552 X=1 Y=2 HELP=14067 ONVALUE=[ size {
    FILESIZE_G(X=10 Y=0)}])}{
   CHECKBOX(TITLE=12553 X=1 Y=3 ONVALUE=[ reuse] HELP=14068)}]
};

{ DEFINE GROUP FILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14069]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14070)}{
   FILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM K_I [TITLE=12555 DEFAULT=1 X=0 HELP=14071]
  RETURNS [K]
};

{ DEFINE ITEM M_I [TITLE=12556 X=6 HELP=14072]
  RETURNS [M]
};

{ DEFINE RADIO FILESIZE_R [HEIGHT=1]
    ITEM K_I
    ITEM M_I
  RETURNS [{:0}]
};

{ DEFINE ITEM GK_I [TITLE=12555 DEFAULT=1 X=0 HELP=14073]
  RETURNS [K]
};

{ DEFINE ITEM GM_I [TITLE=12556 X=6 HELP=14074]
  RETURNS [M]
};

{ DEFINE RADIO GFILESIZE_R [HEIGHT=1]
    ITEM GK_I
    ITEM GM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP AFILESPEC_G [TITLE=12550 WIDTH=50 HEIGHT=4 X=15 Y=10 HELP=14075]
  RETURNS [\'{
   FIELD(TITLE=12551 X=11 Y=1 WIDTH=29 OPTIONAL=0 HELP=14076)}\'{
   CHECKBOX(TITLE=12552 X=1 Y=2 HELP=14077 ONVALUE=[ size {
    AFILESIZE_G(X=10 Y=0)}])}{
   CHECKBOX(TITLE=12553 X=1 Y=3 ONVALUE=[ reuse] HELP=14078)}]
};

{ DEFINE GROUP AFILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14079]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14080)}{
   AFILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM AK_I [TITLE=12555 DEFAULT=1 X=0 HELP=14081]
  RETURNS [K]
};

{ DEFINE ITEM AM_I [TITLE=12556 X=6 HELP=14082]
  RETURNS [M]
};

{ DEFINE RADIO AFILESIZE_R [HEIGHT=1]
    ITEM AK_I
    ITEM AM_I
  RETURNS [{:0}]
};

{ DEFINE ITEM Q1K_I [TITLE=12555 DEFAULT=1 X=0 HELP=14083]
  RETURNS [K]
};

{ DEFINE ITEM Q1M_I [TITLE=12556 X=6 HELP=14084]
  RETURNS [M]
};

{ DEFINE RADIO Q1FILESIZE_R [HEIGHT=1]
    ITEM Q1K_I
    ITEM Q1M_I
  RETURNS [{:0}]
};

{ DEFINE ITEM Q2K_I [TITLE=12555 DEFAULT=1 X=0 HELP=14085]
  RETURNS [K]
};

{ DEFINE ITEM Q2M_I [TITLE=12556 X=6 HELP=14086]
  RETURNS [M]
};

{ DEFINE RADIO Q2FILESIZE_R [HEIGHT=1]
    ITEM Q2K_I
    ITEM Q2M_I
  RETURNS [{:0}]
};

{ DEFINE GROUP RFILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14087]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14088)}{
   RFILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM RK_I [TITLE=12555 DEFAULT=1 X=0 HELP=14089]
  RETURNS [K]
};

{ DEFINE ITEM RM_I [TITLE=12556 X=6 HELP=14090]
  RETURNS [M]
};

{ DEFINE RADIO RFILESIZE_R [HEIGHT=1]
    ITEM RK_I
    ITEM RM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP R2FILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14091]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14092)}{
   R2FILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM R2K_I [TITLE=12555 DEFAULT=1 X=0 HELP=14093]
  RETURNS [K]
};

{ DEFINE ITEM R2M_I [TITLE=12556 X=6 HELP=14094]
  RETURNS [M]
};

{ DEFINE RADIO R2FILESIZE_R [HEIGHT=1]
    ITEM R2K_I
    ITEM R2M_I
  RETURNS [{:0}]
};

{ DEFINE GROUP SFILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14095]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14096)}{
   SFILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM SK_I [TITLE=12555 DEFAULT=1 X=0 HELP=14097]
  RETURNS [K]
};

{ DEFINE ITEM SM_I [TITLE=12556 X=6 HELP=14098]
  RETURNS [M]
};

{ DEFINE RADIO SFILESIZE_R [HEIGHT=1]
    ITEM SK_I
    ITEM SM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ZFILESIZE_G [TITLE=12554 WIDTH=20 HEIGHT=1 HELP=14099]
  RETURNS [{
   FIELD(X=0 Y=0 WIDTH=5 OPTIONAL=0 HELP=14100)}{
   ZFILESIZE_R(X=7 Y=0)}]
};

{ DEFINE ITEM ZK_I [TITLE=12555 DEFAULT=1 X=0 HELP=14101]
  RETURNS [K]
};

{ DEFINE ITEM ZM_I [TITLE=12556 X=6 HELP=14102]
  RETURNS [M]
};

{ DEFINE RADIO ZFILESIZE_R [HEIGHT=1]
    ITEM ZK_I
    ITEM ZM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP STORAGE_G [TITLE=12600 WIDTH=48 HEIGHT=6 X=16 Y=6 HELP=14103]
  RETURNS [{
   CHECKBOX(TITLE=12601 X=1 Y=1 HELP=14104 ONVALUE=[initial {
    SFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12602 X=1 Y=2 HELP=14105 ONVALUE=[next {
    SFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12603 X=1 Y=3 HELP=14106 ONVALUE=[minextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14107)} ])}{
   CHECKBOX(TITLE=12604 X=1 Y=4 HELP=14108 ONVALUE=[maxextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14109)} ])}{
   CHECKBOX(TITLE=12605 X=1 Y=5 HELP=14110
        ONVALUE=[ pctincrease {FIELD(X=26 WIDTH=3 OPTIONAL=0
                     HELP=14111)}])}]
};

{ DEFINE GROUP ZSTORAGE_G [TITLE=12600 WIDTH=48 HEIGHT=6 X=16 Y=6 HELP=14112]
  RETURNS [{
   CHECKBOX(TITLE=12601 X=1 Y=1 HELP=14113 ONVALUE=[initial {
    ZFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12602 X=1 Y=2 HELP=14114 ONVALUE=[next {
    ZFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12603 X=1 Y=3 HELP=14115 ONVALUE=[minextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14116)} ])}{
   CHECKBOX(TITLE=12604 X=1 Y=4 HELP=14117 ONVALUE=[maxextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14118)} ])}{
   CHECKBOX(TITLE=12605 X=1 Y=5 HELP=14119
    ONVALUE=[ pctincrease {FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14120)}])}]
};

{ DEFINE GROUP DROPTS_G [TITLE=12650 HEIGHT=10 WIDTH=46 X=17 Y=5 HELP=14121]
  RETURNS [drop tablespace {
   ONLINETSWOS_L(X=1 Y=2 HEIGHT=6 WIDTH=44 TITLE=12651 HELP=14122)}{
   CHECKBOX(X=1 Y=8 TITLE=12652 HELP=14123 ONVALUE=[ including contents{
     CHECKBOX(X=2 Y=1 TITLE=12653
          HELP=14124 ONVALUE=[ cascade constraints])}])}]
};

{ DEFINE ITEM BONLINETSL_I [ ]
   QUERY [select distinct ts$.name, ts$.name from ts$, v$backup, file$
          where v$backup.file# = file$.file# and v$backup.status = 'NOT ACTIVE'
          and file$.ts# = ts$.ts# order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST BONLINETS_L [TITLE=12700 HEIGHT=6 WIDTH=40 X=20
    Y=5 OPTIONAL=0] ITEM BONLINETSL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM EONLINETSL_I [ ]
   QUERY [select distinct ts$.name, ts$.name from ts$, v$backup, file$
          where v$backup.file# = file$.file# and v$backup.status = 'ACTIVE'
          and file$.ts# = ts$.ts# order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST EONLINETS_L [TITLE=12700 HEIGHT=6 WIDTH=40 X=20
    Y=5 OPTIONAL=0] ITEM EONLINETSL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM ONLINETSL_I [ ]
   QUERY [select name, name from sys.ts$ where online$ = 1 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ONLINETS_L [TITLE=12700 HEIGHT=6 WIDTH=40 X=20
    Y=5 OPTIONAL=0] ITEM ONLINETSL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM ONLINETSWOSL_I [ ]
   QUERY [select name, name from sys.ts$ where online$ != 3 and
          name != 'SYSTEM' order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ONLINETSWOS_L [TITLE=12700 HEIGHT=10 WIDTH=44 X=15
    Y=7 OPTIONAL=0]
   ITEM ONLINETSWOSL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM OFFLINETSL_I [ ]
   QUERY [select name, name from sys.ts$ where online$ = 2 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST OFFLINETS_L [TITLE=12701 HEIGHT=10 WIDTH=45
    X=15 Y=7 OPTIONAL=0]
    ITEM OFFLINETSL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM ALLTSL_I [ ]
   QUERY [select name, name from sys.ts$ where online$ != 3 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ALLTS_L [TITLE=12702 HEIGHT=10 WIDTH=45
    X=15 Y=7 OPTIONAL=0]
    ITEM ALLTSL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ONLINETS_G [TITLE=12703 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14125]
  RETURNS [alter tablespace {
   OFFLINETS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6
           HELP=14126 ERRORNO=347)} online]
};

{ DEFINE GROUP OFFLINETS_G [TITLE=12704 HEIGHT=11 WIDTH=58 X=11 Y=5 HELP=14127]
  RETURNS [alter tablespace {
   ONLINETSWOS_L(X=1 Y=2 HEIGHT=6 WIDTH=56 TITLE=12651 ERRORNO=348
             HELP=14128)} offline {
   OFFLINETSG_R(X=1 Y=8)}]
};

{ DEFINE ITEM OFFTSNORMAL_I [HELP=14129 TITLE=12705 DEFAULT=1]
  RETURNS [normal]
};

{ DEFINE ITEM OFFTSTEMPORARY_I [HELP=14130 TITLE=12706 Y=1]
  RETURNS [temporary]
};

{ DEFINE ITEM OFFTSIMMEDIATE_I [HELP=14131 TITLE=12707 Y=2]
  RETURNS [immediate]
};

{ DEFINE RADIO OFFLINETSG_R [TITLE=12708 HEIGHT=3]
   ITEM OFFTSNORMAL_I
   ITEM OFFTSTEMPORARY_I
   ITEM OFFTSIMMEDIATE_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ADDFILETS_G [TITLE=12709 WIDTH=46 HEIGHT=11 X=17 Y=5 HELP=14132]
  RETURNS [alter tablespace {
   ALLTS_L(TITLE=12651 HEIGHT=7 WIDTH=43 X=1 Y=2 HELP=14133)
   } add datafile {
   FIELD(TITLE=12502 X=13 Y=10 WIDTH=30 OPTIONAL=0 HELP=14134
         INVOKE=[{AFILESPEC_G(MULTICHOICE=1 Y=6)}])}]
};

{ DEFINE GLOBAL TABLESPACE_NAME [%%]
};

{ DEFINE GROUP RENAMEDFTS_G [TITLE=12710 WIDTH=70 HEIGHT=12 X=5 Y=5 HELP=14135]
  RETURNS [alter tablespace {
   ALLTS_L(TITLE=12651 HEIGHT=7 WIDTH=68 X=1 Y=2 SAVE=[TABLESPACE_NAME]
           HELP=14136)} rename datafile {
   FIELD(TITLE=12711 X=16 Y=10 WIDTH=52 OPTIONAL=0
     HELP=14137 INVOKE=[{OLDDATAFILES_G()}])} to {
   FIELD(TITLE=12712 X=16 Y=11 WIDTH=52 OPTIONAL=0 HELP=14138)}]
};

{ DEFINE GROUP OLDDATAFILES_G [TITLE=12713 HEIGHT=9 WIDTH=74 X=3 Y=6
   HELP=14139]
  RETURNS [{OLDDATAFILES_L(HELP=14140)}]
};

{ DEFINE ITEM OLDDATAFILES_I [ ]
   QUERY [select substr(decode(ltrim(lpad(df.name, 70)), df.name, df.name,
      '...' || substr(lpad(df.name, 2000), -67)), 1, 70) "OLDDATAFILES_I",
      '''' || df.name || '''' from
          v$datafile df, file$, ts$ where df.file# = file$.file# and
          file$.ts# = ts$.ts# and ts$.name like '{TABLESPACE_NAME}']
  RETURNS [{:1}]
};

{ DEFINE LIST OLDDATAFILES_L [HEIGHT=9 WIDTH=74 OPTIONAL=0 MULTICHOICE=1]
   ITEM OLDDATAFILES_I
  RETURNS [{:0}]
};

{ DEFINE GROUP STORAGETS_G [TITLE=12714 WIDTH=50 HEIGHT=15 X=15 Y=3 HELP=14141]
  RETURNS [alter tablespace {
   ALLTS_L(TITLE=12651 HEIGHT=7 WIDTH=48 X=1 Y=2 HELP=14142)
  } default storage ({
   ZSTORAGE_G(TITLE=12000 X=0 Y=9)})]
};

REM **********************************************************************
REM    Rollback Segment Dialog Defns - Items under menu RBSegs
REM **********************************************************************
{ DEFINE GROUP CREATERBS_G [TITLE=12750 WIDTH=54 HEIGHT=9 X=13 Y=4 HELP=14143]
  RETURNS [create{
   CREATERBS_R(X=1 Y=1)}rollback segment {
   FIELD(TITLE=12501 X=7 Y=4 WIDTH=30 OPTIONAL=0 HELP=14144)}{
   FIELD(TITLE=12751 X=16 Y=6 WIDTH=30 PREFIX=[ tablespace ]
     HELP=14145 INVOKE=[{RBSONLTS_G()}])}{
    FIELD(TITLE=12752 X=21 Y=8 WIDTH=30 PREFIX=[ storage (]
      SUFFIX=[)] HELP=14146 INVOKE=[{RBSTORE_G()}])}]
};

{ DEFINE GROUP RBSONLTS_G [TITLE=12753 WIDTH=46 HEIGHT=8 X=17 Y=5 HELP=14147]
  RETURNS [{ONLINETS_L(TITLE=12651 X=1 Y=2 WIDTH=42 HEIGHT=6 HELP=14148)}]
};

{ DEFINE ITEM RBS_PUBLIC_I [TITLE=12754 DEFAULT=1 HELP=14149]
  RETURNS [ public ]
};

{ DEFINE ITEM RBS_PRIVATE_I [TITLE=12755 Y=1 HELP=14150]
  RETURNS [ ]
};

{ DEFINE RADIO CREATERBS_R [HEIGHT=2]
   ITEM RBS_PUBLIC_I
   ITEM RBS_PRIVATE_I
  RETURNS [{:0}]
};

{ DEFINE GROUP RBSTORE_G [TITLE=12756 WIDTH=46 HEIGHT=6 X=17 Y=6 HELP=14151]
  RETURNS [{
   CHECKBOX(TITLE=12601 X=1 Y=1
    HELP=14152 ONVALUE=[initial {
    RFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12602 X=1 Y=2
    HELP=14153 ONVALUE=[next {
    RFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12757 X=1 Y=3
    HELP=14154 ONVALUE=[optimal {
    RFILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12603 X=1 Y=4
    HELP=14155 ONVALUE=[minextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14156)} ])}{
   CHECKBOX(TITLE=12604 X=1 Y=5
    HELP=14157 ONVALUE=[maxextents {
    FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14158)}])}]
};

{ DEFINE GROUP RBSTORE2_G [TITLE=12756 WIDTH=46 HEIGHT=5 X=17 Y=7 HELP=14159]
  RETURNS [{
   CHECKBOX(TITLE=12602 X=1 Y=1 HELP=14160 ONVALUE=[next {
    R2FILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12757 X=1 Y=2 HELP=14161
    ONVALUE=[optimal {R2FILESIZE_G(X=26 OPTIONAL=0)} ])}{
   CHECKBOX(TITLE=12603 X=1 Y=3 HELP=14162
    ONVALUE=[minextents {FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14163)} ])}{
   CHECKBOX(TITLE=12604 X=1 Y=4 HELP=14164
        ONVALUE=[maxextents {FIELD(X=26 WIDTH=3 OPTIONAL=0 HELP=14165)}])}]
};

{ DEFINE ITEM ONLINERBL_I [ ]
   QUERY [select name, name from sys.undo$ where status$ = 3
          and name != 'SYSTEM' order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ONLINERB_L [TITLE=12758 HEIGHT=10 WIDTH=45
    X=15 Y=7 OPTIONAL=0]
   ITEM ONLINERBL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM OFFLINERBL_I [ ]
   QUERY [select name, name from sys.undo$ where status$ = 2 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST OFFLINERB_L [TITLE=12759 HEIGHT=10 WIDTH=45
    X=15 Y=7 OPTIONAL=0]
    ITEM OFFLINERBL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM ALLRBL_I [ ]
   QUERY [select name, name from sys.undo$ where status$ != 1 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ALLRB_L [TITLE=12760 HEIGHT=10 WIDTH=45
    X=15 Y=7 OPTIONAL=0]
    ITEM ALLRBL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP DROPRB_G [TITLE=12761 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14166]
  RETURNS [drop rollback segment {
   OFFLINERB_L(X=1 Y=2 HEIGHT=6 WIDTH=40 TITLE=12762 HELP=14167 ERRORNO=349)}]
};

{ DEFINE GROUP ONLINERB_G [TITLE=12763 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14168]
  RETURNS [alter rollback segment {
   OFFLINERB_L(TITLE=12762 X=1 Y=2 WIDTH=40 HEIGHT=6
           HELP=14169 ERRORNO=350)} online]
};

{ DEFINE GROUP OFFLINERB_G [TITLE=12764 HEIGHT=8 WIDTH=42 X=19 Y=5 HELP=14170]
  RETURNS [alter rollback segment {
   ONLINERB_L(X=1 Y=2 HEIGHT=6 WIDTH=40 TITLE=12762
          HELP=14171 ERRORNO=351)} offline]
};

{ DEFINE GROUP STORAGERB_G [TITLE=12765 WIDTH=46 HEIGHT=13 X=17 Y=4 HELP=14172]
  RETURNS [alter rollback segment {
   ALLRB_L(TITLE=12762 HEIGHT=6 WIDTH=44 X=1 Y=2 HELP=14173)
  } storage ({
   RBSTORE2_G(TITLE=12000 X=0 Y=8)})]
};

REM **********************************************************************
REM    Logging Dialog Definitions - Items under menu Logs
REM **********************************************************************
{ DEFINE GROUP LOGADDG_G [TITLE=12800 HEIGHT=8 WIDTH=62 X=9 Y=4 HELP=14174]
  RETURNS [alter database add logfile {
   FIELD(TITLE=12801 X=16 Y=1 WIDTH=3 PREFIX=[thread ]
    HELP=14175 INVOKE=[{THREAD_G()}] SUFFIX=[ ])}{
   FIELD(TITLE=12802 X=16 Y=3 WIDTH=3 PREFIX=[group ]
    HELP=14176 INVOKE=[{GROUPNO_G(Y=5)}] SUFFIX=[ ])}{
   FIELD(TITLE=12803 X=26 Y=5 WIDTH=34 OPTIONAL=0
    HELP=14177 PREFIX=[(] SUFFIX=[)]
    INVOKE=[{LOGMEMSPECWOREUSE_G()}])}{
   CHECKBOX(TITLE=12804 X=1 Y=7 HELP=14178
    ONVALUE=[ size {
    FIELD(X=17 WIDTH=4 OPTIONAL=0
     HELP=14179)}{GFILESIZE_R(X=23)}{
     CHECKBOX(X=37 TITLE=12805 ONVALUE=[ reuse]
              HELP=14180)}])}]
};

{ DEFINE GROUP LOGMEMSPECWOREUSE_G [TITLE=12806 WIDTH=42 HEIGHT=3 X=19 Y=5
   MULTICHOICE=1 HELP=14181]
  RETURNS [\'{FIELD(X=7 Y=1 TITLE=12501 WIDTH=33 OPTIONAL=0 HELP=14182)}\']
};

{ DEFINE GROUP LOGMEMSPEC_G [TITLE=12806 WIDTH=42 HEIGHT=4 X=19 Y=5
   MULTICHOICE=1 HELP=14183]
  RETURNS [\'{
   FIELD(X=7 Y=1 TITLE=12501 WIDTH=33 OPTIONAL=0 HELP=14184)}\'{
   CHECKBOX(X=2 Y=2 TITLE=12805 HELP=14185 ONVALUE=[ reuse])}]
};

{ DEFINE GROUP LOGDROPG_G [TITLE=12807 WIDTH=42 HEIGHT=8 X=19 Y=4 HELP=14186]
  RETURNS [alter database drop logfile group {
   LOGGRP_L(TITLE=12808 X=1 Y=2 WIDTH=40 HEIGHT=6 OPTIONAL=0 HELP=14187)}]
};

{ DEFINE ITEM LOGGRPL_I [ ]
   QUERY [select group#, group# from v$log order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST LOGGRP_L [TITLE=12809 HEIGHT=10 WIDTH=45 X=15 Y=7]
   ITEM LOGGRPL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP LOGADDM_G [TITLE=12810 HEIGHT=4 WIDTH=50 X=15 Y=6 HELP=14188]
  RETURNS [alter database add logfile member {
   FIELD(TITLE=12811 X=17 Y=1 WIDTH=31 OPTIONAL=0
    HELP=14189 INVOKE=[{LOGMEMSPEC_G()}])}{
   FIELD(TITLE=12812 X=17 Y=3 WIDTH=3 PREFIX=[ to group ]
    OPTIONAL=0 HELP=14190 INVOKE=[{LOGLSTG_G()}])}]
};

{ DEFINE GROUP LOGLSTG_G [TITLE=12813 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14191]
  RETURNS [{LOGGRP_L(TITLE=12808 X=1 Y=2 WIDTH=40 HEIGHT=6
   OPTIONAL=0 HELP=14192)}]
};

{ DEFINE GROUP LOGMOVEM_G [TITLE=12814 WIDTH=50 HEIGHT=4 X=15 Y=6 HELP=14193]
  RETURNS [alter database rename file {
   FIELD(X=16 Y=1 TITLE=12711 WIDTH=32 OPTIONAL=0
         HELP=14194 INVOKE=[{LOGMEM_G()}])} to {
   FIELD(X=16 Y=3 OPTIONAL=0 TITLE=12712 WIDTH=32
         HELP=14195)}]
};

{ DEFINE GROUP LOGDROPM_G [TITLE=12815 WIDTH=72 HEIGHT=10 X=4 Y=3 HELP=14196]
  RETURNS [alter database drop logfile member {
   GROUPMEM_L(TITLE=12816 MULTICHOICE=1 HELP=14197)}]
};

{ DEFINE ITEM LOGMEML_I [ ]
   QUERY [select substr(decode(ltrim(lpad(member, 66)), member, member,
      '...' || substr(lpad(member, 2000), -63)), 1, 66) "LOGMEML_I",
      '''' || member || '''' from v$logfile order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST LOGMEM_L [TITLE=12817 HEIGHT=8 WIDTH=70 X=1 Y=2
   OPTIONAL=0]
   ITEM LOGMEML_I
  RETURNS [{:0}]
};

{ DEFINE GROUP LOGMEM_G [TITLE=12818 WIDTH=72 HEIGHT=10 X=4 Y=3 HELP=14198]
  RETURNS [{LOGMEM_L(TITLE=12819 MULTICHOICE=1 HELP=14199)}]
};

{ DEFINE GROUP LOGENABLET_G [TITLE=12820 WIDTH=38 HEIGHT=11 X=21 Y=5
   HELP=14200]
  RETURNS [alter database enable {
   LOGENABLET_R(X=1 Y=1)}thread {
   LOGETHREAD_L(X=1 Y=5 TITLE=12821 WIDTH=36 HEIGHT=6 HELP=14201)}]
};

{ DEFINE ITEM LOGPRIVATE_I [TITLE=12822 DEFAULT=1 HELP=14202]
  RETURNS [ ]
};

{ DEFINE ITEM LOGPUBLIC_I [TITLE=12823 Y=1 HELP=14203]
  RETURNS [public ]
};

{ DEFINE RADIO LOGENABLET_R [HEIGHT=2]
   ITEM LOGPRIVATE_I
   ITEM LOGPUBLIC_I
  RETURNS [{:0}]
};

{ DEFINE ITEM LOGETHREADL_I [ ]
   QUERY [select thread#, thread# from v$thread
      where enabled = 'DISABLED' and groups >= 2 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST LOGETHREAD_L [TITLE=12824 HEIGHT=10 WIDTH=45 X=15 Y=7
   OPTIONAL=0] ITEM LOGETHREADL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM LOGDTHREADL_I [ ]
   QUERY [select thread#, thread# from v$thread where enabled != 'DISABLED'
           order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST LOGDTHREAD_L [TITLE=12821 HEIGHT=10 WIDTH=45 X=15 Y=7
   OPTIONAL=0] ITEM LOGDTHREADL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP LOGDISABLET_G [TITLE=12825 WIDTH=37 HEIGHT=8 X=21 Y=4
   HELP=14204]
  RETURNS [alter database disable thread {
   LOGDTHREAD_L(TITLE=12821 X=1 Y=2 WIDTH=35 HEIGHT=6 HELP=14205)}]
};

{ DEFINE GROUP LOGARCHA_G [TITLE=12826 HEIGHT=2 WIDTH=58 X=11 Y=7 HELP=14206]
  RETURNS [alter system archive log start{
   FIELD(X=26 Y=1 WIDTH=30 TITLE=12827 PREFIX=[ to \']
     HELP=14207 SUFFIX=[\'])}]
};

{ DEFINE ITEM THREADL_I [ ]
   QUERY [select thread#, thread# from v$thread order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST THREAD_L [TITLE=12821 HEIGHT=6 WIDTH=20 X=1 Y=2]
   ITEM THREADL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP THREAD_G [TITLE=12828 WIDTH=22 HEIGHT=8 X=29 Y=6 HELP=14208]
  RETURNS [{THREAD_L(HELP=14209)}]
};

{ DEFINE GROUP ATHREAD_G [TITLE=12828 WIDTH=22 HEIGHT=8 X=29 Y=6 HELP=14210]
  RETURNS [{THREAD_L(HELP=14211)}]
};

{ DEFINE GROUP LOGARCHM_G [TITLE=12829 HEIGHT=12 WIDTH=60 X=10 Y=4 HELP=14212]
  RETURNS [alter system archive log {
    FIELD(X=25 Y=1 WIDTH=5 TITLE=12830 PREFIX=[thread ]
          HELP=14213 INVOKE=[{ATHREAD_G()}] SUFFIX=[ ])}{
   LOGARCHM_R(X=1 Y=3)} {
    FIELD(X=26 Y=11 WIDTH=25 TITLE=12827 PREFIX=[to \']
      HELP=14214 SUFFIX=[\'])}]
};

{ DEFINE ITEM ARCHMALL_I [TITLE=12831 DEFAULT=1 HELP=14215]
  RETURNS [all]
};

{ DEFINE ITEM ARCHMNXT_I [TITLE=12832 Y=1 HELP=14216]
  RETURNS [next]
};

{ DEFINE ITEM GROUPNOL_I [ ]
   QUERY [select group#, group# from v$log order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST GROUPNO_L [TITLE=12833 HEIGHT=6 WIDTH=33 X=1 Y=2
   OPTIONAL=0] ITEM GROUPNOL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP GROUPNO_G [TITLE=12834 WIDTH=35 HEIGHT=8 X=22 Y=6 HELP=14217]
  RETURNS [{GROUPNO_L(HELP=14218)}]
};

{ DEFINE GROUP AGROUPNO_G [TITLE=12834 WIDTH=35 HEIGHT=8 X=22 Y=6 HELP=14219]
  RETURNS [{GROUPNO_L(HELP=14220)}]
};

{ DEFINE ITEM ARCHMGRP_I [TITLE=12835 Y=2 HELP=14221]
  RETURNS [group {
   FIELD(X=27 Y=0 WIDTH=5 OPTIONAL=0 HELP=14222 INVOKE=[{AGROUPNO_G()}])}]
};

{ DEFINE ITEM GROUPMEML_I [ ]
   QUERY [select substr(to_char(group#, '0999') || '  ' ||
      decode(ltrim(lpad(member, 58)), member, member,
      '...' || substr(lpad(member, 2000), -55)), 1, 65) "GROUPMEML_I",
      '''' || member || '''' from v$logfile order by group#, member]
  RETURNS [{:1}]
};

{ DEFINE LIST GROUPMEM_L [TITLE=12816 HEIGHT=8 WIDTH=70 X=1 Y=2
   OPTIONAL=0] ITEM GROUPMEML_I
  RETURNS [{:0}]
};

{ DEFINE GROUP GROUPMEM_G [TITLE=12836 WIDTH=72 HEIGHT=10 X=4 Y=3 HELP=14223]
  RETURNS [{GROUPMEM_L(HELP=14224)}]
};

{ DEFINE ITEM ARCHMLOG_I [TITLE=12837 Y=3 HELP=14225]
  RETURNS [logfile {
   FIELD(X=37 Y=0 WIDTH=20 OPTIONAL=0 HELP=14226 INVOKE=[{GROUPMEM_G()}])}]
};

{ DEFINE ITEM ARCHMSEQ_I [TITLE=12838 Y=4 HELP=14227]
  RETURNS [sequence {
   FIELD(X=34 Y=0 WIDTH=5 OPTIONAL=0 HELP=14228)}]
};

{ DEFINE ITEM ARCHMCHG_I [TITLE=12839 Y=5 HELP=14229]
  RETURNS [change {
   FIELD(X=32 Y=0 WIDTH=15 OPTIONAL=0 HELP=14230)}]
};

{ DEFINE ITEM ARCHMCUR_I [TITLE=12840 Y=6 HELP=14231]
  RETURNS [current]
};

{ DEFINE RADIO LOGARCHM_R [HEIGHT=7]
   ITEM ARCHMALL_I
   ITEM ARCHMNXT_I
   ITEM ARCHMGRP_I
   ITEM ARCHMLOG_I
   ITEM ARCHMSEQ_I
   ITEM ARCHMCHG_I
   ITEM ARCHMCUR_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM    Security Dialog Definitions - Items under menu Security
REM **********************************************************************
{ DEFINE GROUP USERCREAT_G [TITLE=12850 WIDTH=52 HEIGHT=10 X=14 Y=4 HELP=14232]
  RETURNS [create user {
   FIELD(X=7 Y=1 TITLE=12501 WIDTH=32 OPTIONAL=0 HELP=14233)} {
   USERAUTH_R(X=1 Y=3)}{
   FIELD(TITLE=12851 X=23 Y=6 WIDTH=27 HELP=14234 PREFIX=[ default tablespace ]
     INVOKE=[{ALLTS1_G(Y=5 TITLE=12852)}])}{
   FIELD(TITLE=12853 X=23 Y=7 WIDTH=27
    PREFIX=[ temporary tablespace ] HELP=14235
    INVOKE=[{ALLTS2_G(Y=5 TITLE=12854)}])}{
   FIELD(TITLE=12855 X=23 Y=8 WIDTH=27 PREFIX=[ ] HELP=14236 INVOKE=[{
    USERQUOTA1_G(SEPARATOR=[ ] WIDTH=56 X=12 Y=5 MULTICHOICE=1)}])}{
   FIELD(TITLE=12856 X=23 Y=9 WIDTH=27 PREFIX=[ profile ]
    HELP=14237 INVOKE=[{ALLPROF1_G(Y=5)}])}]
};

{ DEFINE ITEM USERPASS_I [TITLE=12857 DEFAULT=1 HELP=14238]
  RETURNS [identified by {
   FIELD(X=33 Y=0 WIDTH=17 OPTIONAL=0 HELP=14239)}]
};

{ DEFINE ITEM USEROSAUTH_I [TITLE=12858 Y=1 HELP=14240]
  RETURNS [identified externally]
};

{ DEFINE ITEM RUSERPASS_I [TITLE=12857 DEFAULT=1 HELP=14241]
  RETURNS [identified by {
   FIELD(X=33 Y=0 WIDTH=17 OPTIONAL=0 HELP=14242)}]
};

{ DEFINE ITEM RUSEROSAUTH_I [TITLE=12858 Y=1 HELP=14243]
  RETURNS [identified externally]
};

{ DEFINE RADIO USERAUTH_R [HEIGHT=2]
   ITEM RUSERPASS_I
   ITEM RUSEROSAUTH_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ALLTS1_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14244]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6 HELP=14245)}]
};

{ DEFINE GROUP ALLTS2_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14246]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40
    HEIGHT=6 HELP=14247)}]
};

{ DEFINE GROUP ALLTS3_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14248]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6 HELP=14249)}]
};

{ DEFINE GROUP ALLTS4_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14250]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6 HELP=14251)}]
};

{ DEFINE GROUP ALLTS5_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14252]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6 HELP=14253)}]
};

{ DEFINE GROUP ALLTS6_G [TITLE=12753 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14254]
  RETURNS [{ALLTS_L(TITLE=12651 X=1 Y=2 WIDTH=40 HEIGHT=6 HELP=14255)}]
};

{ DEFINE GROUP USERQUOTA1_G [WIDTH=56 HEIGHT=5 TITLE=12859 HELP=14256]
  RETURNS [quota {
   QUOTALIMIT1_R(X=1 Y=1)} on {
   FIELD(X=18 Y=3 WIDTH=18 TITLE=12860 OPTIONAL=0 HELP=14257
     INVOKE=[{ALLTS3_G()}])}]
};

{ DEFINE GROUP USERQUOTA2_G [WIDTH=56 HEIGHT=5 TITLE=12859 HELP=14258]
  RETURNS [quota {
   QUOTALIMIT2_R(X=1 Y=1)} on {
   FIELD(X=18 Y=3 WIDTH=18 TITLE=12860 OPTIONAL=0 HELP=14259
     INVOKE=[{ALLTS6_G()}])}]
};

{ DEFINE ITEM QUOTALIM1_I [TITLE=12861 X=20 HELP=14260]
  RETURNS [{
   FIELD(X=10 Y=0 WIDTH=5 OPTIONAL=0 HELP=14261)}{
   Q1FILESIZE_R(X=17 Y=0)}]
};

{ DEFINE ITEM QUOTAUNLIM1_I [TITLE=12862 DEFAULT=1 HELP=14262]
  RETURNS [unlimited]
};

{ DEFINE RADIO QUOTALIMIT1_R [HEIGHT=1]
   ITEM QUOTAUNLIM1_I
   ITEM QUOTALIM1_I
  RETURNS [{:0}]
};

{ DEFINE ITEM QUOTALIM2_I [TITLE=12861 X=20 HELP=14263]
  RETURNS [{
   FIELD(X=10 Y=0 WIDTH=5 OPTIONAL=0 HELP=14264)}{
   Q2FILESIZE_R(X=17 Y=0)}]
};

{ DEFINE ITEM QUOTAUNLIM2_I [TITLE=12862 DEFAULT=1 HELP=14265]
  RETURNS [unlimited]
};

{ DEFINE RADIO QUOTALIMIT2_R [HEIGHT=1]
   ITEM QUOTAUNLIM2_I
   ITEM QUOTALIM2_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ALLPROF1_G [TITLE=12863 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14266]
  RETURNS [{ALLPROF_L(TITLE=12864 X=1 Y=2 WIDTH=40 HELP=14267
    HEIGHT=6)}]
};

{ DEFINE GROUP ALLPROF2_G [TITLE=12863 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14268]
  RETURNS [{ALLPROF_L(TITLE=12864 X=1 Y=2 WIDTH=40 HELP=14269 HEIGHT=6)}]
};

{ DEFINE ITEM ALLUSERSL_I [ ]
   QUERY [select name, name from sys.user$ where type = 1 order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ALLUSERS_L [TITLE=12865 HEIGHT=10 WIDTH=45 X=15 Y=7]
   ITEM ALLUSERSL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ALLROLES_G [TITLE=12866 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14270]
  RETURNS [{ALLROLES_L(TITLE=12867 X=1 Y=2 WIDTH=40 HELP=14271
    HEIGHT=6 MULTICHOICE=1)}]
};

{ DEFINE ITEM ALLROLESL_I [ ]
   QUERY [select name, name from sys.user$ where type = 0
            and name not in ('PUBLIC', '_NEXT_USER') order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ALLROLES_L [TITLE=12868 HEIGHT=10 WIDTH=45 X=15 Y=7
   OPTIONAL=0]
   ITEM ALLROLESL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM ALLPROFL_I [ ]
   QUERY [select name, name from sys.profname$ order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST ALLPROF_L [TITLE=12869 HEIGHT=10 WIDTH=45 X=15 Y=7
   OPTIONAL=0]
   ITEM ALLPROFL_I
  RETURNS [{:0}]
};

{ DEFINE ITEM DROPPROFL_I [ ]
   QUERY [select name, name from sys.profname$ where name != 'DEFAULT'
   order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST DROPPROF_L [TITLE=12869 HEIGHT=10 WIDTH=45 X=15 Y=7
   OPTIONAL=0]
   ITEM DROPPROFL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP USERALTER_G [TITLE=12870 WIDTH=74 HEIGHT=12 X=3 Y=4 HELP=14272]
  RETURNS [alter user {
   ALLUSERS_L(TITLE=12871 X=1 Y=1 WIDTH=32 HEIGHT=5 OPTIONAL=0 ERRORNO=356
              HELP=14273)}{
   USERAUTH2_R(X=35 Y=2)}{
   FIELD(X=28 Y=7 TITLE=12872 WIDTH=44
    PREFIX=[ default tablespace ] HELP=14274
    INVOKE=[{ALLTS4_G()}])}{
   FIELD(X=28 Y=8 TITLE=12873 WIDTH=44 HELP=14275
    PREFIX=[ temporary tablespace ] INVOKE=[{ALLTS5_G()}])}{
   FIELD(X=28 Y=9 TITLE=12855 WIDTH=44 PREFIX=[ ]HELP=14276 INVOKE=[{
    USERQUOTA2_G(SEPARATOR=[ ] WIDTH=56 X=12 Y=5 MULTICHOICE=1)}])}{
   FIELD(X=28 Y=10 TITLE=12856 WIDTH=44 PREFIX=[ profile ]
    HELP=14277 INVOKE=[{ALLPROF2_G()}])}{
   FIELD(X=28 Y=11 TITLE=12874 WIDTH=44 PREFIX=[ default role ]
    HELP=14278 INVOKE=[{ALLROLES_G()}])}]
};

{ DEFINE ITEM USERNOCHANGE_I [TITLE=12875 DEFAULT=1 HELP=14279]
  RETURNS [ ]
};

{ DEFINE ITEM USERPASS2_I [TITLE=12876 Y=1 HELP=14280]
  RETURNS [ identified by {
   FIELD(X=24 Y=0 WIDTH=14 OPTIONAL=0 HELP=14281)}]
};

{ DEFINE ITEM USEROSAUTH2_I [TITLE=12877 Y=2 HELP=14282]
  RETURNS [ identified externally]
};

{ DEFINE RADIO USERAUTH2_R [HEIGHT=3]
   ITEM USERNOCHANGE_I
   ITEM USERPASS2_I
   ITEM USEROSAUTH2_I
  RETURNS [{:0}]
};

{ DEFINE GROUP USERDROP_G [TITLE=12878 WIDTH=42 HEIGHT=9 X=19 Y=4 HELP=14283]
  RETURNS [drop user {
   ALLUSERS_L(TITLE=12871 X=1 Y=2 WIDTH=40 HEIGHT=6 OPTIONAL=0 HELP=14284
    ERRORNO=356)}{
   CHECKBOX(TITLE=12879 X=1 Y=8 HELP=14285 ONVALUE=[ cascade])}]
};

{ DEFINE GROUP ROLECREAT_G [TITLE=12880 WIDTH=52 HEIGHT=6 X=14 Y=5 HELP=14286]
  RETURNS [create role {
   FIELD(X=7 Y=1 WIDTH=30 TITLE=12501 OPTIONAL=0 HELP=14287)} {
   ROLEAUTH_R(X=1 Y=3)}]
};

{ DEFINE ITEM ROLENOAUTH_I [TITLE=12881 Y=2 HELP=14288]
  RETURNS [not identified]
};

{ DEFINE RADIO ROLEAUTH_R [HEIGHT=3]
   ITEM USERPASS_I
   ITEM USEROSAUTH_I
   ITEM ROLENOAUTH_I
  RETURNS [{:0}]
};

{ DEFINE ITEM USERPASS3_I [TITLE=12876 DEFAULT=1 HELP=14289]
  RETURNS [identified by {
   FIELD(X=24 Y=0 WIDTH=17 OPTIONAL=0 HELP=14290)}]
};

{ DEFINE ITEM USEROSAUTH3_I [TITLE=12877 Y=1 HELP=14291]
  RETURNS [identified externally]
};

{ DEFINE ITEM ROLENOAUTH3_I [TITLE=12882 Y=2 HELP=14292]
  RETURNS [not identified]
};

{ DEFINE RADIO ROLEAUTH3_R [HEIGHT=3]
   ITEM USERPASS3_I
   ITEM USEROSAUTH3_I
   ITEM ROLENOAUTH3_I
  RETURNS [{:0}]
};

{ DEFINE GROUP ROLEALTER_G [TITLE=12883 WIDTH=52 HEIGHT=11 X=14 Y=4 HELP=14293]
  RETURNS [alter role {
   ALLROLES_L(TITLE=12884 X=1 Y=2 WIDTH=50 HEIGHT=5 ERRORNO=357 HELP=14294)} {
   ROLEAUTH3_R(X=1 Y=8)}]
};

{ DEFINE GROUP ROLEDROP_G [TITLE=12885 WIDTH=42 HEIGHT=8 X=19 Y=4 HELP=14295]
  RETURNS [drop role {
   ALLROLES_L(TITLE=12884 X=1 Y=2 WIDTH=40 HEIGHT=6 ERRORNO=357 HELP=14296)}]
};

{ DEFINE GROUP PROFCREAT_G [TITLE=12886 WIDTH=72 HEIGHT=12 X=4 Y=4 HELP=14297]
  RETURNS [create profile {
   FIELD(X=7 Y=1 TITLE=12501 WIDTH=30 OPTIONAL=0 HELP=14298)} {
   PROFILE_G(X=1 Y=3)}]
};

{ DEFINE GROUP PROFALTER_G [TITLE=12887 WIDTH=72 HEIGHT=16 X=4 Y=3 HELP=14299]
  RETURNS [alter profile {
   ALLPROF_L(X=1 Y=1 HEIGHT=6 WIDTH=68 TITLE=12856 HELP=14300)} {
   APROFILE_G(X=1 Y=7)}]
};

{ DEFINE GROUP PROFILE_G [WIDTH=70 HEIGHT=9 HELP=14301]
  RETURNS [limit{
   CHECKBOX(TITLE=12888 X=0 Y=0 HELP=14302
    ONVALUE=[ sessions_per_user {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12889 X=0 Y=1 HELP=14303
    ONVALUE=[ cpu_per_session {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12890 X=0 Y=2 HELP=14304
    ONVALUE=[ cpu_per_call {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12891 X=0 Y=3 HELP=14305
    ONVALUE=[ connect_time {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12892 X=0 Y=4 HELP=14306
    ONVALUE=[ idle_time {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12893 X=0 Y=5 HELP=14307
    ONVALUE=[ logical_reads_per_session {
     PROFLIM_R()}])}{
   CHECKBOX(TITLE=12894 X=0 Y=6 HELP=14308
    ONVALUE=[ logical_reads_per_call {
     PROFLIM_R()}])}{
   CHECKBOX(TITLE=12895 X=0 Y=7
    HELP=14309 ONVALUE=[ private_sga {PROFLIM_R()}])}{
   CHECKBOX(TITLE=12896 X=0 Y=8 HELP=14310
        ONVALUE=[ composite_limit {PROFLIM_R()}])}]
};

{ DEFINE ITEM PROFLIMVAL_I [TITLE=12897 HELP=14311]
  RETURNS [{FIELD(X=11 Y=0 WIDTH=5 HELP=14312)}]
};

{ DEFINE ITEM PROFUNLIM_I [TITLE=12862 X=18 HELP=14313]
  RETURNS [unlimited]
};

{ DEFINE ITEM PROFDEFLIM_I [TITLE=12898 X=33 DEFAULT=1 HELP=14314]
  RETURNS [default]
};

{ DEFINE RADIO PROFLIM_R [X=26 HEIGHT=1]
   ITEM PROFLIMVAL_I
   ITEM PROFUNLIM_I
   ITEM PROFDEFLIM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP APROFILE_G [WIDTH=70 HEIGHT=9 HELP=14315]
  RETURNS [limit{
   CHECKBOX(TITLE=12888 X=0 Y=0 HELP=14316
    ONVALUE=[ sessions_per_user {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12889 X=0 Y=1 HELP=14317
    ONVALUE=[ cpu_per_session {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12890 X=0 Y=2 HELP=14318
    ONVALUE=[ cpu_per_call {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12891 X=0 Y=3 HELP=14319
    ONVALUE=[ connect_time {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12892 X=0 Y=4 HELP=14320
    ONVALUE=[ idle_time {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12893 X=0 Y=5 HELP=14321
    ONVALUE=[ logical_reads_per_session {
     APROFLIM_R()}])}{
   CHECKBOX(TITLE=12894 X=0 Y=6 HELP=14322
    ONVALUE=[ logical_reads_per_call {
     APROFLIM_R()}])}{
   CHECKBOX(TITLE=12895 X=0 Y=7
    HELP=14323 ONVALUE=[ private_sga {APROFLIM_R()}])}{
   CHECKBOX(TITLE=12896 X=0 Y=8 HELP=14324
    ONVALUE=[ composite_limit {APROFLIM_R()}])}]
};

{ DEFINE ITEM APROFLIMVAL_I [TITLE=12897 HELP=14325]
  RETURNS [{FIELD(X=11 Y=0 WIDTH=5 HELP=14326)}]
};

{ DEFINE ITEM APROFUNLIM_I [TITLE=12862 X=18 HELP=14327]
  RETURNS [unlimited]
};

{ DEFINE ITEM APROFDEFLIM_I [TITLE=12898 X=33 DEFAULT=1 HELP=14328]
  RETURNS [default]
};

{ DEFINE RADIO APROFLIM_R [X=26 HEIGHT=1]
   ITEM APROFLIMVAL_I
   ITEM APROFUNLIM_I
   ITEM APROFDEFLIM_I
  RETURNS [{:0}]
};

{ DEFINE GROUP PROFDROP_G [TITLE=12899 WIDTH=50 HEIGHT=9 X=15 Y=4 HELP=14329]
  RETURNS [drop profile {
   DROPPROF_L(TITLE=12864 X=1 Y=2 WIDTH=48 HEIGHT=6 HELP=14330)}{
   CHECKBOX(TITLE=12900 X=1 Y=8 HELP=14331 ONVALUE=[ cascade])}]
};

{ DEFINE GROUP RESCOST_G [TITLE=12901 WIDTH=31 HEIGHT=5 X=24 Y=6 HELP=14332]
  RETURNS [alter resource cost{
   FIELD(X=24 Y=1 TITLE=12889 PREFIX=[ cpu_per_session ]
         WIDTH=5 HELP=14333)}{
   FIELD(X=24 Y=2 TITLE=12891 PREFIX=[ connect_time ] WIDTH=5
         HELP=14334)}{
   FIELD(X=24 Y=3 TITLE=12893
         PREFIX=[ logical_reads_per_session ] WIDTH=5 HELP=14335)}{
   FIELD(X=24 Y=4 TITLE=12895 PREFIX=[ private_sga ]
    WIDTH=5 HELP=14336)}]
};

{ DEFINE ITEM PRIVROLESL_I [ ]
   QUERY [select substr(name, 1, 36), name from system_privilege_map
      where name != 'SYSTEM GRANT' union
          select substr(name, 1, 36), name from sys.user$ where type = 0
            and name not in ('PUBLIC', '_NEXT_USER') order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST PRIVROLES_L [TITLE=12902 HEIGHT=10 WIDTH=38
    X=1 Y=2 OPTIONAL=0]
   ITEM PRIVROLESL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP GPRIVROLES_G [TITLE=12903 WIDTH=40 HEIGHT=12 X=20 Y=4
   HELP=14337]
  RETURNS [{PRIVROLES_L(MULTICHOICE=1 HELP=14338)}]
};

{ DEFINE GROUP RPRIVROLES_G [TITLE=12903 WIDTH=40 HEIGHT=12 X=20 Y=4
   HELP=14339]
  RETURNS [{PRIVROLES_L(MULTICHOICE=1 HELP=14340)}]
};

{ DEFINE ITEM USERROLESL_I [ ]
   QUERY [select substr(name, 1, 36), name from sys.user$
          where name not in ('PUBLIC', '_NEXT_USER') order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST USERROLES_L [TITLE=12904 HEIGHT=10 WIDTH=36
    X=2 Y=2 OPTIONAL=0]
   ITEM USERROLESL_I
  RETURNS [{:0}]
};

{ DEFINE GROUP GUSERROLES_G [TITLE=12905 WIDTH=38 HEIGHT=12 X=21 Y=4
   HELP=14341]
  RETURNS [{USERROLES_L(MULTICHOICE=1 ERRORNO=358 HELP=14342)}]
};

{ DEFINE GROUP RUSERROLES_G [TITLE=12905 WIDTH=38 HEIGHT=12 X=21 Y=4
   HELP=14343]
  RETURNS [{USERROLES_L(MULTICHOICE=1 ERRORNO=358 HELP=14344)}]
};

{ DEFINE GROUP GRANT_G [TITLE=12906 WIDTH=63 HEIGHT=6 X=9 Y=5 HELP=14345]
  RETURNS [grant {
   FIELD(X=8 Y=1 TITLE=12907 WIDTH=50 OPTIONAL=0 HELP=14346
    INVOKE=[{GPRIVROLES_G()}])} to {
   FIELD(X=8 Y=3 TITLE=12908 WIDTH=50 OPTIONAL=0
         HELP=14347 INVOKE=[{GUSERROLES_G()}])}{
   CHECKBOX(TITLE=12909 HELP=14348 X=1 Y=5
            ONVALUE=[ with admin option])}]
};

{ DEFINE GROUP REVOKE_G [TITLE=12910 WIDTH=51 HEIGHT=4 X=15 Y=7 HELP=14349]
  RETURNS [revoke {
   FIELD(X=8 Y=1 TITLE=12911 WIDTH=40 OPTIONAL=0 HELP=14350
     INVOKE=[{RPRIVROLES_G()}])} from {
   FIELD(X=8 Y=3 TITLE=12912 WIDTH=40 OPTIONAL=0 HELP=14351
     INVOKE=[{RUSERROLES_G()}])}]
};


REM **********************************************************************
REM    Backup Dialog Definitions - Items under menu Backup
REM **********************************************************************
{ DEFINE GROUP BACKUP_TS_S_G [TITLE=12950 WIDTH=42 HEIGHT=8 X=19 Y=4
   HELP=14352]
  RETURNS [alter tablespace {
   BONLINETS_L(TITLE=12952 X=1 Y=2 WIDTH=40 HEIGHT=6
    ERRORNO=352 HELP=14353)} begin backup]
};

{ DEFINE GROUP BACKUP_TS_E_G [TITLE=12951 WIDTH=42 HEIGHT=8 X=19 Y=4
   HELP=14354]
  RETURNS [alter tablespace {
   EONLINETS_L(TITLE=12952 X=1 Y=2 WIDTH=40 HEIGHT=6
    ERRORNO=353 HELP=14355)} end backup]
};

{ DEFINE GROUP RECOVER_DB_G [TITLE=12953 WIDTH=41 HEIGHT=8 X=19 Y=6 HELP=14356]
  RETURNS [recover database {
   RECOVER_DB_R(X=1 Y=1)}{
   CHECKBOX(TITLE=12954 X=1 Y=7
    HELP=14357 ONVALUE=[ using backup controlfile])}]
};

{ DEFINE ITEM RECOVER_DB_COMP_I [TITLE=12955 DEFAULT=1 HELP=14358]
  RETURNS [ ]
};

{ DEFINE ITEM RECOVER_DB_INCM_I [TITLE=12956 Y=1 HELP=14359]
  RETURNS [{RECOVER_DB_INCM_R(X=3 Y=1)}]
};

{ DEFINE RADIO RECOVER_DB_R [HEIGHT=5]
   ITEM RECOVER_DB_COMP_I
   ITEM RECOVER_DB_INCM_I
  RETURNS [{:0}]
};

{ DEFINE ITEM RECOVER_DB_INCM_USR_I [TITLE=12957 DEFAULT=1 HELP=14360]
  RETURNS [until cancel]
};

{ DEFINE ITEM RECOVER_DB_INCM_SCN_I [TITLE=12958 Y=1 HELP=14361]
  RETURNS [until change {FIELD(X=18 Y=0 WIDTH=18 HELP=14362)}]
};

{ DEFINE ITEM RECOVER_DB_INCM_TIME_I [TITLE=12959 Y=2 HELP=14363]
  RETURNS [until time \'{FIELD(X=18 Y=0 WIDTH=18 HELP=14364)}\']
};

{ DEFINE RADIO RECOVER_DB_INCM_R [HEIGHT=3]
   ITEM RECOVER_DB_INCM_USR_I
   ITEM RECOVER_DB_INCM_SCN_I
   ITEM RECOVER_DB_INCM_TIME_I
  RETURNS [{:0}]
};

{ DEFINE GROUP RECOVER_TS_G [TITLE=12960 WIDTH=42 HEIGHT=8 X=19 Y=6 HELP=14365]
  RETURNS [recover tablespace {
   OFFLINETS_L(TITLE=12961 X=1 Y=2 WIDTH=40 HEIGHT=6
    MULTICHOICE=1 ERRORNO=354 HELP=14366)}]
};

{ DEFINE GROUP RECOVER_FILE_G [TITLE=12962 WIDTH=74 HEIGHT=8 X=3 Y=4
   HELP=14367]
  RETURNS [recover datafile {
   OFFLINEFILE_L(TITLE=12502 X=1 Y=2 WIDTH=72 HEIGHT=6 MULTICHOICE=1
    ERRORNO=355 HELP=14368)}]
};

{ DEFINE ITEM OFFLINEFILE_I [ ]
   QUERY [select substr(decode(ltrim(lpad(name, 68)), name, name,
      '...' || substr(lpad(name, 2000), -65)), 1, 68) "OFFLINEFILE_I",
      '''' || name || '''' from v$datafile order by 1]
  RETURNS [{:1}]
};

{ DEFINE LIST OFFLINEFILE_L [TITLE=12963 HEIGHT=10 WIDTH=72 X=4 Y=7
    OPTIONAL=0]
   ITEM OFFLINEFILE_I
  RETURNS [{:0}]
};

REM **********************************************************************
REM     Monitor Definitions - Items under menu Monitor
REM **********************************************************************

{DEFINE MONITOR SHARED
  [TITLE=13000 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14369]
 QUERY [SELECT NAME, STATUS, REQUESTS,
     '(' || TO_CHAR(ROUND(IDLE/8640000)) || ') ' ||
     TO_CHAR(MOD(ROUND(IDLE/360000), 24)) || ':' ||
     TO_CHAR(MOD(ROUND(IDLE/6000), 60)) || ':' ||
     TO_CHAR(MOD(ROUND(IDLE/100), 60)),
     '(' || TO_CHAR(ROUND(BUSY/8640000)) || ') ' ||
     TO_CHAR(MOD(ROUND(BUSY/360000), 24)) || ':' ||
     TO_CHAR(MOD(ROUND(BUSY/6000), 60)) || ':' ||
     TO_CHAR(MOD(ROUND(BUSY/100), 60)),
     ROUND(BUSY/(IDLE+BUSY), 3),
     DECODE(RAWTOHEX(CIRCUIT), '00000000', null, RAWTOHEX(CIRCUIT))
    FROM V$SHARED_SERVER
    WHERE NAME LIKE UPPER(\'{FIELD(TITLE=13001
         WIDTH=7 X=13 Y=1 DEFAULT=[%%] OPTIONAL=0 HELP=14370)}\')
        AND STATUS LIKE UPPER(\'{FIELD(TITLE=13002 HELP=14371
     WIDTH=14 X=40 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
        ORDER BY NAME]
 INTO [ :1(WIDTH=5 TITLE=13003)
    :2(WIDTH=12 TITLE=13004)
    :3(WIDTH=8 TITLE=13005)
    :4(WIDTH=13 TITLE=13006)
    :5(WIDTH=15 TITLE=13007)
    :6(WIDTH=5 TITLE=13008)
    :7(WIDTH=8 TITLE=13009)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR DISPATCHER
  [TITLE=13050 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14372]
 QUERY [SELECT NAME, STATUS, ACCEPT, MESSAGES, BYTES, OWNED,
     '(' || TO_CHAR(ROUND(IDLE/8640000)) || ') ' ||
     TO_CHAR(MOD(ROUND(IDLE/360000), 24)) || ':' ||
     TO_CHAR(MOD(ROUND(IDLE/6000), 60)) || ':' ||
     TO_CHAR(MOD(ROUND(IDLE/100), 60)),
     '(' || TO_CHAR(ROUND(BUSY/8640000)) || ') ' ||
     TO_CHAR(MOD(ROUND(BUSY/360000), 24)) || ':' ||
     TO_CHAR(MOD(ROUND(BUSY/6000), 60)) || ':' ||
     TO_CHAR(MOD(ROUND(BUSY/100), 60)),
     ROUND(BUSY/(IDLE+BUSY), 3)
    FROM V$DISPATCHER
    WHERE NAME LIKE UPPER(\'{FIELD(TITLE=13001 HELP=14373
         WIDTH=7 X=13 Y=1 DEFAULT=[%%] OPTIONAL=0)}\') AND
     STATUS LIKE UPPER(\'{FIELD(TITLE=13002 HELP=14374
     WIDTH=14 X=40 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
        ORDER BY NAME]
 INTO [ :1(WIDTH=5 TITLE=13051)
    :2(WIDTH=10 TITLE=13052)
    :3(WIDTH=4 TITLE=13053)
    :4(WIDTH=5 TITLE=13054)
    :5(WIDTH=7 TITLE=13055)
    :6(WIDTH=7 TITLE=13056)
    :7(WIDTH=13 TITLE=13057)
    :8(WIDTH=13 TITLE=13058)
    :9(WIDTH=4 TITLE=13059)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR CIRCUIT
  [TITLE=13100 X=5 Y=3 WIDTH=70 HEIGHT=18 HELP=14375]
 QUERY [SELECT DECODE(RAWTOHEX(C.CIRCUIT),'00000000',null,RAWTOHEX(C.CIRCUIT)),
     D.NAME, S1.NAME, S.SID, S.SERIAL#,
         C.STATUS, C.QUEUE, C.MESSAGES, C.BYTES
    FROM V$CIRCUIT C, V$DISPATCHER D, V$SHARED_SERVER S1, V$SESSION S
    WHERE C.DISPATCHER = D.PADDR(+) AND C.SERVER = S1.PADDR(+) AND
     C.SADDR = S.SADDR(+)
        ORDER BY C.CIRCUIT]
 INTO [ :1(WIDTH=8 TITLE=13101)
    :2(WIDTH=5 TITLE=13102)
    :3(WIDTH=5 TITLE=13103)
    :4(WIDTH=5 TITLE=13104)
    :5(WIDTH=5 TITLE=13105)
    :6(WIDTH=8 TITLE=13106)
    :7(WIDTH=10 TITLE=13107)
    :8(WIDTH=6 TITLE=13108)
    :9(WIDTH=8 TITLE=13109)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR QUEUE
  [TITLE=13150 X=14 Y=3 WIDTH=52 HEIGHT=18 HELP=14376]
 QUERY [SELECT DECODE(RAWTOHEX(PADDR), '00000000', null,RAWTOHEX(PADDR)),
     TYPE, QUEUED, TOTALQ, DECODE(TOTALQ, 0, 0, ROUND(WAIT/TOTALQ/100, 5))
    FROM V$QUEUE
        ORDER BY PADDR]
 INTO [ :1(WIDTH=9 TITLE=13151)
    :2(WIDTH=10 TITLE=13152)
    :3(WIDTH=8 TITLE=13153)
    :4(WIDTH=8 TITLE=13154)
    :5(WIDTH=9 TITLE=13155)
      ]
 AGGREGATE [ ]
};


{DEFINE MONITOR PROCESS
  [TITLE=13200 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14377]
 QUERY  [SELECT P.PID, P.SPID, P.USERNAME, P.LATCHWAIT,
     DECODE(S.TERMINAL, NULL, P.TERMINAL, S.TERMINAL),
         DECODE(S.PROGRAM, NULL, P.PROGRAM, S.PROGRAM)
         FROM V$PROCESS P, V$SESSION S
         WHERE P.ADDR = S.PADDR AND {FIELD(TITLE=13201 HELP=14378
      WIDTH=6 X=21 Y=1 DEFAULT=[0] OPTIONAL=0)}<=PID AND
      PID<={FIELD(TITLE=13202 WIDTH=6 X=21 Y=2 HELP=14379
      DEFAULT=[999999] OPTIONAL=0)}
         ORDER BY PID]
 INTO   [ :1(WIDTH=7  TITLE=13203)
          :2(WIDTH=8 TITLE=13204)
      :3(WIDTH=16 TITLE=13205)
      :4(WIDTH=8 TITLE=13206)
          :5(WIDTH=10  TITLE=13207)
      :6(WIDTH=64  TITLE=13208)
    ]
 AGGREGATE [ ]
};

{DEFINE MONITOR SESSION [TITLE=13250 X=1 Y=3 WIDTH=78
  HEIGHT=18 HELP=14380]
 QUERY [SELECT S.SID, S.SERIAL#, P.PID, S.STATUS, S.USERNAME, LOCKWAIT,
     DECODE(S.COMMAND, 0, 'NONE', 1, 'CREATE TABLE', 2, 'INSERT', 3,
     'SELECT', 4, 'CREATE CLUSTER', 5, 'ALTER CLUSTER', 6, 'UPDATE', 7,
     'DELETE', 8, 'DROP CLUSTER', 9, 'CREATE INDEX', 10, 'DROP INDEX', 11,
     'ALTER INDEX', 12, 'DROP TABLE', 13, 'UNDEFINED', 14, 'UNDEFINED', 15,
      'ALTER TABLE', 16, 'UNDEFINED', 17, 'GRANT', 18, 'REVOKE', 19,
     'CREATE SYNONYM', 20, 'DROP SYNONYM', 21, 'CREATE VIEW', 22,
     'DROP VIEW', 23, 'UNDEFINED', 24, 'UNDEFINED', 25, 'UNDEFINED', 26,
     'LOCK TABLE', 27, 'NO OPERATION', 28, 'RENAME', 29, 'COMMENT', 30,
     'AUDIT', 31, 'NO AUDIT', 32, 'CREATE EXTERNAL DATABASE', 33,
         'DROP EXTERNAL DATABASE', 34, 'CREATE DATABASE', 35, 'ALTER DATABASE',
         36, 'CREATE ROLLBACK SEGMENT', 37, 'ALTER ROLLBACK SEGMENT', 38,
         'DROP ROLLBACK SEGMENT', 39, 'CREATE TABLESPACE', 40,
         'ALTER TABLESPACE', 41, 'DROP TABLESPACE', 42, 'ALTER SESSION', 43,
         'ALTER USER', 44, 'COMMIT', 45, 'ROLLBACK', 46, 'SAVEPOINT',
         'UNKNOWN')
        FROM V$SESSION S, V$PROCESS P
        WHERE S.PADDR = P.ADDR AND S.USERNAME LIKE UPPER(\'{FIELD(TITLE=13251
         WIDTH=8 X=18 HELP=14381 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
    ORDER BY S.SID, S.SERIAL#]
 INTO [:1(WIDTH=7 TITLE=13252)
       :2(WIDTH=6 TITLE=13253)
       :3(WIDTH=7 TITLE=13254)
       :4(WIDTH=8 TITLE=13255)
       :5(WIDTH=16 TITLE=13256)
       :6(WIDTH=8 TITLE=13257)
       :7(WIDTH=30 TITLE=13258)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR TABLE [TITLE=13300 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14382]
 QUERY [SELECT SID,OWNER,OBJECT
        FROM V$ACCESS
        WHERE SID>={FIELD(TITLE=13301 WIDTH=6 X=21 Y=1 DEFAULT=0 OPTIONAL=0
         HELP=14383)} AND SID <={FIELD(TITLE=13302 WIDTH=6 X=21 Y=2
         DEFAULT=999999 HELP=14384 OPTIONAL=0)} AND OWNER LIKE
         UPPER(\'{FIELD(TITLE=13303 HELP=14385
         WIDTH=20 X=55 Y=1 DEFAULT=[%%] OPTIONAL=0)}\') AND OBJECT LIKE UPPER(
         \'{FIELD(TITLE=13304 WIDTH=20 X=55 Y=2 DEFAULT=[%%]
         HELP=14386 OPTIONAL=0)}\')
        ORDER BY SID,OWNER]
 INTO [ :1(WIDTH=7 TITLE=13305)
    :2(WIDTH=30 TITLE=13306)
    :3(WIDTH=30 TITLE=13307)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR SQLAREA
  [TITLE=13350 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14387]
 QUERY [SELECT SQL_TEXT, VERSION_COUNT,SHARABLE_MEM, PERSISTENT_MEM,
     RUNTIME_MEM
        FROM V$SQLAREA
    WHERE UPPER(SQL_TEXT) LIKE UPPER(\'{FIELD(TITLE=13351 HELP=14388
         WIDTH=20 X=18 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
        ORDER BY SQL_TEXT]
 INTO [ :1(WIDTH=40 TITLE=13352)
    :2(WIDTH=6 TITLE=13353)
    :3(WIDTH=8 TITLE=13354)
    :4(WIDTH=11 TITLE=13355)
    :5(WIDTH=8 TITLE=13356)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR LCACHE
  [TITLE=13400 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14389]
 QUERY [SELECT NAMESPACE, GETS, GETHITS, ROUND(GETHITRATIO, 2), PINS, PINHITS,
         ROUND(PINHITRATIO, 2), RELOADS, INVALIDATIONS
        FROM V$LIBRARYCACHE
    WHERE NAMESPACE LIKE UPPER(\'{FIELD(TITLE=13401 HELP=14390
         WIDTH=20 X=19 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
        ORDER BY NAMESPACE]
 INTO [ :1(WIDTH=15 TITLE=13402)
    :2(WIDTH=8 TITLE=13403)
    :3(WIDTH=6 TITLE=13404)
    :4(WIDTH=5 TITLE=13405)
    :5(WIDTH=8 TITLE=13406)
    :6(WIDTH=6 TITLE=13407)
    :7(WIDTH=5 TITLE=13408)
    :8(WIDTH=7 TITLE=13409)
    :9(WIDTH=9 TITLE=13410)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR LATCH [TITLE=13450 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14391]
 QUERY [SELECT LN.NAME, NVL(TO_CHAR(LH.PID), ' '), L.GETS, L.MISSES, L.SLEEPS,
         L.IMMEDIATE_GETS, L.IMMEDIATE_MISSES
        FROM V$LATCH L, V$LATCHNAME LN, V$LATCHHOLDER LH
        WHERE L.LATCH#=LN.LATCH# AND L.ADDR = LH.LADDR(+)
    ORDER BY L.LEVEL#,L.LATCH#]
 INTO [ :1(WIDTH=20 TITLE=13451)
    :2(WIDTH=6 TITLE=13452)
    DELTA(:3)(WIDTH=8 TITLE=13453)
    DELTA(:4)(WIDTH=8 TITLE=13454)
    DELTA(:5)(WIDTH=8 TITLE=13455)
    DELTA(:6)(WIDTH=11 TITLE=13456)
    DELTA(:7)(WIDTH=8 TITLE=13457)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR FILEIO [TITLE=13500 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14392]
 QUERY [SELECT DECODE(LTRIM(LPAD(NAME, 25)), NAME, NAME,
    '...' || SUBSTR(LPAD(NAME, 2000), -22)), PHYRDS, PHYWRTS, PHYBLKRD,
    PHYBLKWRT, READTIM, WRITETIM FROM V$DBFILE DF, V$FILESTAT FS
        WHERE DF.FILE#=FS.FILE# AND NAME LIKE
         \'{FIELD(TITLE=13501 WIDTH=25 X=19 Y=1 DEFAULT=[%%] HELP=14393
         OPTIONAL=0)}\'
        ORDER BY DF.FILE#]
 INTO [ :1(WIDTH=25 TITLE=13502)
    RATE(DELTA(:2))(WIDTH=8 TITLE=13503)
    RATE(DELTA(:3))(WIDTH=8 TITLE=13504)
    DIV(DELTA(:4) DELTA(:2))(WIDTH=8 TITLE=13505)
    DIV(DELTA(:5) DELTA(:3))(WIDTH=8 TITLE=13506)
    DIV(DELTA(:6) DELTA(:2))(WIDTH=8 TITLE=13507)
    DIV(DELTA(:7) DELTA(:3))(WIDTH=8 TITLE=13508)
    :2(WIDTH=8 TITLE=13509)
    :3(WIDTH=8 TITLE=13510)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR SYSTEMIO [TITLE=13550 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14394]
 QUERY [SELECT P.PID, S.SID, I.BLOCK_GETS + I.CONSISTENT_GETS,
    I.PHYSICAL_READS, I.BLOCK_CHANGES + I.CONSISTENT_CHANGES
    FROM V$PROCESS P, V$SESSION S, V$SESS_IO I
    WHERE P.ADDR=S.PADDR AND I.SID=S.SID
        ORDER BY P.PID,S.SID]
 INTO [ :1(WIDTH=7 TITLE=13551)
    :2(WIDTH=7 TITLE=13552)
    PCTOFTOTAL(DELTA(:3))(WIDTH=9 TITLE=13553)
    PCTOFTOTAL(DELTA(:4))(WIDTH=9 TITLE=13554)
    PCTOFTOTAL(DELTA(:5))(WIDTH=9 TITLE=13555)
    PCTOFTOTAL(NORMALIZED(:3))(WIDTH=9 TITLE=13556)
    PCTOFTOTAL(NORMALIZED(:4))(WIDTH=9 TITLE=13557)
    PCTOFTOTAL(NORMALIZED(:5))(WIDTH=9 TITLE=13558)
      ]
 AGGREGATE [ SUM(DELTA(:3))(WIDTH=10 X=15 TITLE=13559)
         SUM(DELTA(:4))(WIDTH=10 X=25)
         SUM(DELTA(:5))(WIDTH=10 X=35)
         SUM(NORMALIZED(:3))(WIDTH=10 X=45)
         SUM(NORMALIZED(:4))(WIDTH=10 X=55)
         SUM(NORMALIZED(:5))(WIDTH=10 X=65)
       ]
};

{DEFINE MONITOR ROLLBACK [TITLE=13600 X=1 Y=3 WIDTH=78 HEIGHT=18 HELP=14395]
 QUERY [SELECT RN.USN, RN.NAME, RS.EXTENTS, RS.RSSIZE, RS.WRITES, RS.XACTS,
     RS.GETS, RS.WAITS, TO_CHAR(RS.OPTSIZE), RS.HWMSIZE, RS.SHRINKS,
     RS.WRAPS, RS.EXTENDS, RS.AVESHRINK, RS.AVEACTIVE, RS.STATUS
        FROM V$ROLLNAME RN, V$ROLLSTAT RS
        WHERE RN.USN=RS.USN AND RN.NAME LIKE UPPER(\'{FIELD(
         TITLE=13601 WIDTH=20 X=26 Y=1 DEFAULT=[%%]
         HELP=14396 OPTIONAL=0)}\')
        ORDER BY RN.USN]
 INTO  [ :1(WIDTH=4 TITLE=13602)
     :2(WIDTH=10 TITLE=13603)
     :16(WIDTH=15 TITLE=13617)
         :4(WIDTH=10 TITLE=13604)
     :3(WIDTH=7 TITLE=13605)
     :6(WIDTH=8 TITLE=13606)
     RATE(DELTA(:5))(WIDTH=10 TITLE=13607)
     RATE(DELTA(:7))(WIDTH=9  TITLE=13608)
     RATE(DELTA(:8))(WIDTH=9  TITLE=13609)
     :9(WIDTH=10 TITLE=13610)
     :10(WIDTH=10 TITLE=13611)
     :15(WIDTH=10 TITLE=13612)
     :14(WIDTH=10 TITLE=13613)
     :12(WIDTH=10 TITLE=13614)
     :13(WIDTH=10 TITLE=13615)
     :11(WIDTH=10 TITLE=13616)
       ]
 AGGREGATE [ ]
};

{DEFINE MONITOR SESSIONSTATISTIC [TITLE=13650 X=1 Y=3 WIDTH=78 HEIGHT=18
  HELP=14397]
 QUERY [SELECT DISTINCT S.NAME, ST.VALUE
        FROM V$STATNAME S, V$SESSTAT ST, V$SESSION SS
    WHERE S.STATISTIC# = ST.STATISTIC# AND ST.SID = SS.SID AND
    {FIELD(TITLE=13651 WIDTH=6 X=44 Y=1 DEFAULT=[0] OPTIONAL=0 HELP=14398)}
    = SS.SID AND
       (BITAND(S.CLASS,{CHECKBOX(TITLE=13653 X=2 Y=3 ONVALUE=1 OFFVALUE=0
                                 HELP=14400)})=1
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13654 X=13 Y=3 ONVALUE=2 OFFVALUE=0
                                HELP=14401)})=2
        OR
    BITAND(S.CLASS,{CHECKBOX(TITLE=13655 X=25 Y=3 ONVALUE=4 OFFVALUE=0
                             HELP=14402)})=4
        OR
      BITAND(S.CLASS,{CHECKBOX(TITLE=13656 X=40 Y=3 ONVALUE=8 OFFVALUE=0
                               HELP=14403)})=8
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13657 X=53 Y=3 ONVALUE=32 OFFVALUE=0
                                HELP=14404)})=32
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13658 X=69 Y=3 ONVALUE=64 OFFVALUE=0
                                HELP=14404)})=64)
        ORDER BY S.NAME, ST.VALUE]
 INTO [ :1(WIDTH=36 TITLE=13660)
    DELTA(:2)(WIDTH=7 TITLE=13661)
    TAVG(DELTA(:2))(WIDTH=7 TITLE=13662)
    TMIN(DELTA(:2))(WIDTH=7 TITLE=13663)
    TMAX(DELTA(:2))(WIDTH=7 TITLE=13664)
    :2(WIDTH=7 TITLE=13665)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR SYSTEMSTATISTIC [TITLE=13700 X=1 Y=3 WIDTH=78 HEIGHT=18
  HELP=14405]
 QUERY [SELECT S.NAME, S.VALUE FROM V$SYSSTAT S WHERE
        BITAND(S.CLASS,{CHECKBOX(TITLE=13701 X=2 Y=1 ONVALUE=1 OFFVALUE=0
                 HELP=14406)})=1
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13702 X=13 Y=1 ONVALUE=2 OFFVALUE=0
                HELP=14407)})=2
        OR
    BITAND(S.CLASS,{CHECKBOX(TITLE=13703 X=25 Y=1 ONVALUE=4 OFFVALUE=0
                 HELP=14408)})=4
        OR
      BITAND(S.CLASS,{CHECKBOX(TITLE=13704 X=40 Y=1 ONVALUE=8 OFFVALUE=0
                   HELP=14409)})=8
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13705 X=53 Y=1 ONVALUE=32 OFFVALUE=0
                HELP=14410)})=32
        OR
       BITAND(S.CLASS,{CHECKBOX(TITLE=13706 X=69 Y=1 ONVALUE=64 OFFVALUE=0
                HELP=14410)})=64
        ORDER BY S.NAME, S.VALUE]
 INTO [ :1(WIDTH=36 TITLE=13708)
    DELTA(:2)(WIDTH=7 TITLE=13709)
    TAVG(DELTA(:2))(WIDTH=7 TITLE=13710)
    TMIN(DELTA(:2))(WIDTH=7 TITLE=13711)
    TMAX(DELTA(:2))(WIDTH=7 TITLE=13712)
    :2(WIDTH=7 TITLE=13713)
      ]
 AGGREGATE [ ]
};

{DEFINE MONITOR LOCK [TITLE=13750 X=3 Y=3 WIDTH=72 HEIGHT=18 HELP=14411]
 QUERY [SELECT S.USERNAME, S.SID, S.SERIAL#, '  '||L.TYPE, L.ID1, L.ID2,
        ' '||DECODE(L.LMODE, 0, 'NONE', 1, 'NULL', 2, '  RS', 3, '  RX',
         4, '   S', 5, ' SRX', 6, '   X', '   ?'),
        '  '||DECODE(L.REQUEST, 0, 'NONE', 1, 'NULL', 2, '  RS', 3, '  RX',
           4, '   S', 5, ' SRX', 6, '   X', '   ?')
        FROM V$LOCK L, V$SESSION S
        WHERE L.SID=S.SID AND S.USERNAME LIKE UPPER(\'{FIELD(TITLE=13751
         WIDTH=8 X=18 HELP=14412 Y=1 DEFAULT=[%%] OPTIONAL=0)}\')
    ORDER BY S.SID,L.TYPE]
 INTO [ :1(WIDTH=16 TITLE=13752)
    :2(WIDTH=7  TITLE=13753)
    :3(WIDTH=6 TITLE=13754)
    :4(WIDTH=6  TITLE=13755)
    :5(WIDTH=8  TITLE=13756)
    :6(WIDTH=8  TITLE=13757)
    :7(WIDTH=5  TITLE=13758)
    :8(WIDTH=9  TITLE=13759)
      ]
 AGGREGATE [ ]
};

REM **********************************************************************
REM     Invoke Topmenu to build menubar
REM **********************************************************************
{ TOPMENU() };