Oracle: Initialization Parameters (10g)

Initialization parameters for Oracle 10g can be obtained from v$parameter;

sample script to get values:
set pagesize 1000

set linesize 150
column name format a40
column value format a40
column description format a40


select name, value, description from v$parameter order by name;



useful links:
http://www.dba-oracle.com/t_oracle10g_initialization_parms.htm

No comments: