http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FSystem_Tables_Data_Dictionary%2Fparameter Oracle PL/SQL Tutorial/System Tables Data Dictionary/parameter - История изменений 2026-05-24T05:50:50Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/parameter&diff=3853&oldid=prev в 13:45, 26 мая 2010 2010-05-26T13:45:46Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table> http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/System_Tables_Data_Dictionary/parameter&diff=3854&oldid=prev Admin: 1 версия 2010-05-26T10:08:01Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== Find information about &quot;utl_file_dir&quot; from v$parameter==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; SELECT name, value, isses_modifiable, issys_modifiable<br /> 2 FROM v$parameter<br /> 3 WHERE name = &quot;utl_file_dir&quot;;<br /> NAME<br /> --------------------------------------------------------------------------------<br /> VALUE<br /> --------------------------------------------------------------------------------<br /> ISSES ISSYS_MOD<br /> ----- ---------<br /> utl_file_dir<br /> FALSE FALSE<br /> <br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Join v$process, v$session, v$parameter and v$instance==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; select rtrim(c.value,&quot;/&quot;) || &quot;/&quot; || d.instance_name ||<br /> 2 &quot;_ora_&quot; || ltrim(to_char(a.spid)) || &quot;.trc&quot;<br /> 3 from v$process a, v$session b, v$parameter c, v$instance d<br /> 4 where a.addr = b.paddr<br /> 5 and b.audsid = sys_context( &quot;userenv&quot;, &quot;sessionid&quot;)<br /> 6 and c.name = &quot;user_dump_dest&quot;<br /> 7 and rownum &lt; 50<br /> 8 /<br /> RTRIM(C.VALUE,&quot;/&quot;)||&quot;/&quot;||D.INSTANCE_NAME||&quot;_ORA_&quot;||LTRIM(TO_CHAR(A.SPID))||&quot;.TRC&quot;<br /> -----------------------------------------------------------------------------------------------------------------------------------<br /> C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP/xe_ora_1476.trc<br /> <br /> Statistics<br /> ----------------------------------------------------------<br /> 913 recursive calls<br /> 0 db block gets<br /> 369 consistent gets<br /> 0 physical reads<br /> 0 redo size<br /> 535 bytes sent via SQL*Net to client<br /> 380 bytes received via SQL*Net from client<br /> 2 SQL*Net roundtrips to/from client<br /> 22 sorts (memory)<br /> 0 sorts (disk)<br /> 1 rows processed<br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == show parameter utl_file_dir==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SQL&gt;<br /> SQL&gt; select * from v$parameter where name = &quot;utl_file_dir&quot;<br /> 2 /<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> 817 utl_file_dir<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> 2<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> <br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> <br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> TRUE FALSE FALSE FALSE FALSE FALSE FALSE<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> utl_file accessible directories list<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> <br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> 379739569<br /> NUM NAME<br /> ---------- --------------------------------------------------------------------------------<br /> TYPE<br /> ----------<br /> VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> DISPLAY_VALUE<br /> ----------------------------------------------------------------------------------------------------<br /> ISDEFAULT ISSES ISSYS_MOD ISINS ISMODIFIED ISADJ ISDEP<br /> --------- ----- --------- ----- ---------- ----- -----<br /> DESCRIPTION<br /> ----------------------------------------------------------------------------------------------------<br /> UPDATE_COMMENT<br /> ----------------------------------------------------------------------------------------------------<br /> HASH<br /> ----------<br /> <br /> SQL&gt;<br /> SQL&gt;&lt;/source&gt;</div> Admin