Let us have your views ...
SQL>Var Name (lower case):dump Name Currently SesMo SysMod Modified Adjus ---------------------------------------- -------------------- ----- --------- ---------- ----- background_core_dump full FALSE FALSE FALSE FALSE background_dump_dest /wc/wc_u06/bdump FALSE FALSE FALSE FALSE core_dump_dest /wc/wc_u06/cdump FALSE FALSE FALSE FALSE max_dump_file_size 1024000 TRUE FALSE FALSE FALSE shadow_core_dump full FALSE FALSE FALSE FALSE user_dump_dest /wc/wc_u06/udump FALSE IMMEDIATE FALSE FALSE 6 rows selected. Name Type Is Defaul Description ---------------------- ----- --------- --------------------------------------------------------- background_core_dump 2 TRUE Core Size for Background Processes background_dump_dest 2 FALSE Detached process dump directory core_dump_dest 2 FALSE Core dump directory max_dump_file_size 2 FALSE Maximum size (blocks) of dump file shadow_core_dump 2 TRUE Core Size for Shadow Processes user_dump_dest 2 FALSE User process dump directory |
column Currently format A20
column Name format a40
column Type format 9999
set head on
SET PAGES 900
accept varname prompt 'Var Name (lower case):'
select name "Name",
rtrim( value ) "Currently",
isses_modifiable "SesMod",
issys_modifiable "SysMod",
ismodified "Modified",
isadjusted "Adjusted"
from v$parameter
where name like '%&&varname%'
order by name
/
column Name format a22
select substr( name, 1, 20 ) "Name",
Type "Type",
isdefault "Is Default",
description "Description"
from v$parameter
where name like '%&&varname%'
order by name
/
set head off
|