/* ************************************************ */
/*                                                  */
/* Script: Display open cursor information          */
/*                                                  */
/* name:    @c:\oracle\sql\v$open_c.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select 	user_name,
 	substr(sql_text, 1, 20)
  from v$open_cursor
order by 1 asc, 2 asc;

commit;

