doc

    Name:   respool.sql

    Author: Mark Gurry

    This script lists the reserved pool setting for the shared pool.

#

ttitle ' The Reserved Pool Settings for the Shared Pool Area'

select substr(name,1,32) "Parameter", substr(value,1,12) "Setting"
	from v$parameter
 where name like '%reser%'
              OR
       name = ‘shared_pool_size’;