Oracle PL/SQL Tutorial/System Tables Data Dictionary/parameter

Материал из SQL эксперт
Перейти к: навигация, поиск

Find information about "utl_file_dir" from v$parameter

SQL>
SQL>
SQL> SELECT name, value, isses_modifiable, issys_modifiable
  2  FROM   v$parameter
  3  WHERE  name = "utl_file_dir";
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
ISSES ISSYS_MOD
----- ---------
utl_file_dir
FALSE FALSE

SQL>


Join v$process, v$session, v$parameter and v$instance

SQL>
SQL> select rtrim(c.value,"/") || "/" || d.instance_name ||
  2                      "_ora_" || ltrim(to_char(a.spid)) || ".trc"
  3    from v$process a, v$session b, v$parameter c, v$instance d
  4   where a.addr = b.paddr
  5     and b.audsid = sys_context( "userenv", "sessionid")
  6     and c.name = "user_dump_dest"
  7     and rownum < 50
  8  /
RTRIM(C.VALUE,"/")||"/"||D.INSTANCE_NAME||"_ORA_"||LTRIM(TO_CHAR(A.SPID))||".TRC"
-----------------------------------------------------------------------------------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP/xe_ora_1476.trc

Statistics
----------------------------------------------------------
        913  recursive calls
          0  db block gets
        369  consistent gets
          0  physical reads
          0  redo size
        535  bytes sent via SQL*Net to client
        380  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
         22  sorts (memory)
          0  sorts (disk)
          1  rows processed
SQL>
SQL>


show parameter utl_file_dir

SQL>
SQL> select * from v$parameter where name = "utl_file_dir"
  2  /
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
       817 utl_file_dir
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
         2
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------

       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------

       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
TRUE      FALSE FALSE     FALSE FALSE      FALSE FALSE
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
utl_file accessible directories list
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------

       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------
 379739569
       NUM NAME
---------- --------------------------------------------------------------------------------
      TYPE
----------
VALUE
----------------------------------------------------------------------------------------------------
DISPLAY_VALUE
----------------------------------------------------------------------------------------------------
ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP
--------- ----- --------- ----- ---------- ----- -----
DESCRIPTION
----------------------------------------------------------------------------------------------------
UPDATE_COMMENT
----------------------------------------------------------------------------------------------------
      HASH
----------

SQL>
SQL>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/parameter&oldid=3854»