Parameter Values

[code language=”sql”] select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from sys.x\$ksppi a, sys.x\$ksppcv b, sys.x\$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm in (‘__shared_pool_size’,’__db_cache_size’,’__large_pool_size’,’__java_pool_size’,’__streams_pool_size’,’__pga_aggregate_target’,’__sga_target’,’memory_target’); set linesize 200 col VALUE for a50 set pagesize 100 col Parameter for a50 col "Session Value" for a50 col "Instance Value" for a50 column […]