[Tip] how to see v $ parameter without having privileges

[dr_gori]

This routine is very useful when you do not have privileges to see the Oracle parameters ...

Example:

Select all

utl_file_dir 
user_dump_dest 
max_dump_file_size  
tracefile_identifier  
etc

Just rotate this script :

Select all

set serveroutput on 
declare 
  paramname varchar2(256); 
  integerval binary_integer; 
  stringval varchar2(256); 
  paramtype binary_integer; 
  begin 
   paramtype:=dbms_utility.get_parameter_value('max_dump_file_size',integerval,stringval); 
   if paramtype=1 then 
    dbms_output.put_line(stringval); 
   else 
    dbms_output.put_line(integerval); 
  end if; 
  end; 
/ 

[dr_gori]

Other ways of seeing the Oracle parameters:

In SQL * Plus you can use Show:

Select all

SQL> sho parameter utl% 
 
NAME                                 TYPE        VALUE 
------------------------------------ ----------- ------------------------------ 
create_stored_outlines               string 
utl_file_dir                         string      /db/ges/appl/app_common/comm 
                                                 on/11i/temp 
SQL>