doc

    Name:   mtsmem.sql

    Author: Mark Gurry


The following script lists how much session memory is being used by 
Multi-threaded server in the shared pool.

#

SELECT SUM(VALUE)
  FROM V$SESSTAT
 WHERE NAME = 'session uga memory'

Doc

The result indicates the memory currently allocated to all sessions. 
You can use this figure to increase the shared pool size if you are 
planning to use the multi-threaded server. You can also obtain the 
maximum amount of memory that the server sessions have utilised using 
the following script.

#

SELECT SUM(VALUE)
  FROM V$SESSTAT
 WHERE NAME = 'session uga memory max'

Doc

It is usually best to use the latter calculation and add on a 30% 
contingency.

#