get database parameter

You do not need to have DBA priviledge to view all the database parameters

A simple script will do

set serveroutput on size 1000000

declare
x number;
y long;
d number;
begin
if ( dbms_utility.get_parameter_value( '&1', x, y ) = 1 )
then
dbms_output.put_line( y );
else
dbms_output.put_line( x );
end if;
end;
/

Unfortunately, the following parameters are not supported

shared_pool_size
sga_max_size
shared_pool_reserved_size
large_pool_size
java_pool_size
db_keep_cache_size
db_recycle_cache_size
db_2k_cache_size
db_4k_cache_size
db_8k_cache_size
db_16k_cache_size
db_32k_cache_size
db_cache_size
pga_aggregate_target