-
hello,
Will init.ora parameters will be stored in a table.
if so in which table ??
thanks
Good Judgement comes from Experience.
Experience comes from Bad Judgement
-
-
-
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
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|