SR 4 DB

set lin 120 set pages 20 col program for a42    COL max_op_cur FOR 999999 HEADING 'Max. Open C.|per Session' COL sum_op_cur FOR 999999 HEADING 'Total. Open C.|per Program' COL avg_op_cur FOR 999999 HEADING 'Avg. Open C.|per Program' --- Opened Cursors Current select program, max_op_cur , sum_op_cur , avg_op_cur , sessions from (select   s .program, max(t.value) max_op_cur ,   sum( t.VALUE) sum_op_cur , round(avg(t.value)) avg_op_cur , count( 1 ) sessions from v$sesstat t, V$STATNAME n , v$session s where t. STATISTIC# = n . STATISTIC#  and   n .name in ( 'opened cursors current' ) and t.sid= s .sid group by s .program order by max(t.value) desc ) where rownum< 10 ; COL PROGRAM FOR A32 COL USERNAME FOR A16 COL MACHINE FOR A24 COL OSUSER FOR A16 ALTER SESSION SET NLS_DATE_FORMAT= 'DD-MON-YYYY HH24:MI:SS' ; SET PAGES 200 SET LIN 120   select s

SQLPROMPT &_user : Who is connected (10g and +). &_CONNECT_IDENTIFIER : Which Database you are connected. Eg : SQL> set sqlprompt   '&_CONNECT_IDENTIFIER@&_user>' PADOVA@SYS > TRIMSPOOL – TRIMOUT SET  TRIMOUT ON or SET  TRIMSPOOL ON removes trailing blanks at the end of each displayed or spooled line. SQL> set lin 80 SQL> set TRIMSPOOL OFF SQL> spool prueba04 . txt SQL> select '12345' cmp from dual ; cmp ----- 12345 SQL>   spool off; bash - 3.2 $  wc - c prueba04 . txt        293 prueba04 . txt < ----- 293 characters SQL> set lin 80 SQL> SET TRIMSPOOL ON SQL> spool prueba02 . txt SQL>   select '12345' cmp from dual ; cmp ----- 12345 SQL>   spool off; bash - 3.2 $ wc - c prueba02 . txt        69 prueba02 . txt    < ----- just 69 characters GLOGIN.SQL $ORACLE_HOME/sqlplus/admin/glogin.sql All