hello,
Will init.ora parameters will be stored in a table.
if so in which table ??
thanks
Printable View
hello,
Will init.ora parameters will be stored in a table.
if so in which table ??
thanks
In v$parameter.
v$parameter
it will store in some x$table but
for system specific it will store in v$system
_parameter view and session specific in v$parameter;
With RDBMS version of SQL*Plus, you can also type "show parameter" at the SQL> prompt to see all parameters, and you can do "show parameter parameter_name" to see all parameters that have "parameter_name" in them. For example,
SQL> show parameter dump
NAME TYPE VALUE
------------------------------------ ------- --------------
background_core_dump string partial
background_dump_dest string ?/rdbms/log
core_dump_dest string ?/dbs
max_dump_file_size string 10240
shadow_core_dump string PARTIAL
user_dump_dest string ?/rdbms/log
maybe you should look at v$parameter