Subject:            Wide SQL*DBA Screens
Last Revision Date: 11 September 1994
Author:Saleem Haque                                                      



      By default the SQL*DBA monitor screens are 80 characters wide
and 24 lines high, the typical screen size for a vt220 or a vt320
terminal. This screen size is not very useful for monitoring
activity on databases with more than 30 users who are using more
than 20 resources, because although, by default the PROCESS, TABLE,
STATISTICS and some other screens do scroll down the LOCK screen
does not, and all locks held by a process with ORACLE PID greater
than 30, and on a resource that was the 21st or later to be accessed
would not be visible. The lock screen will scroll down if it is
invoked as "lo all", and you can also see the processes with PID
greater than 30 by invoking the screen as "lo all 31 60", but you
cannot see all the locks and all processes holding those locks at the
same time. The only way to view this wide output is to spool it to a
file and print the file in landscape mode or with a smaller font if a
printer that supports such a feature is available.

      SQL*DBA uses the CRT utility to display all information. The
CRT utility allows one to define terminal display characteristics,
such as reverse video and the size of the display, for ORACLE
full-screen products like SQL*DBA. If one has the appropriate
hardware a CRT definition can be created to display information on a
screen up to 180 characters wide and 66 lines high. This is possible
on almost all windowing terminals that include different types of
workstations and all the wide screen X-window terminals.

      Follow the steps below to create a CRT defintion.

      1. Change directories to the CRT directory. This is a
         subdirectory of the ORACLE root or home directory.

      2. Generate the CRT form using the command

         IAG23 CRT

         If the CRT.FRM already exists skip this step and go the
         next one.

      3. Run the CRT form

         IAP23 CRT SYSTEM/MANAGER

      4. Query up the terminal definition that you want to change.
         (The default definition used by SQL*DBA is what the CRT
         utility was configured with at installation time. VT100
         is a commonly used definition). Create/Insert a new record
         as duplicate of the definition you want to customize. Change
         the CRT NAME to WIDE100 (the name must be 8 characters or
         less) in the new record. Then change the COLUMNS and LINES
         fields to the screen dimensions that you want, for example
         180 and 66 respectively. Update the MODE LINE and MESSAGE
         LINE fields appropriately - in this case to 66 and 65.
         Commit your changes and exit the form.

      5. Log into SQLPLUS as SYSTEM/MANAGER and duplicate the
         corresponding record in the CRTBOX table.
         For the example above:

         INSERT INTO CRTBOX SELECT * FROM CRTBOX WHERE CRTNAME = 'VT100';

         Find out the ROWID of the new record inserted and update the
         CRTNAME using the ROWID as follows:

         UPDATE CRTBOX SET CRTNAME = 'WIDE100' WHERE ROWID = 'rowid';
         COMMIT;

      6. Run the CRT utility to create a new CRT file.

         CRT WIDE100 SYSTEM/MANAGER

         This will create a file called WIDE100.CRT

      7. Now if a windowing terminal is available with fonts so a
         180x66 window can be created, run SQL*DBA as follows to get
         equally sized MONITOR screens

         SQLDBA TERMINAL=WIDE100