/* ************************************************ */
/*                                                  */
/* Script: Display the total amount of memory       */
/*         needed for the current sessions          */
/*                                                  */
/* name:    @c:\oracle\sql\v$sessta.sql             */
/* date:    29-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select 	sum(se.value)||' Bytes' "Total memory for all sessions"
   from v$sesstat se,
	v$statname n
  where n.statistic# = se.statistic# and
	n.name = 'session pga memory';

commit;

