http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSQL_Plus%2Fshow
Oracle PL/SQL/SQL Plus/show - История изменений
2026-05-14T13:21:25Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/show&diff=1655&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<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://sqle.ru/index.php?title=Oracle_PL/SQL/SQL_Plus/show&diff=1656&oldid=prev
Admin: 1 версия
2010-05-26T09:58:32Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==show parameters block==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> show parameters block<br />
NAME TYPE VALUE<br />
------------------------------------ ----------- ------------------------------<br />
db_block_buffers integer 0<br />
db_block_checking string FALSE<br />
db_block_checksum string TRUE<br />
db_block_size integer 8192<br />
db_file_multiblock_read_count integer 128<br />
SQL><br />
</source><br />
<br />
<br />
<br />
<br />
==show parameter timed_statistics==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> set echo on<br />
SQL> set serveroutput on<br />
SQL><br />
SQL> show parameter timed_statistics;<br />
NAME TYPE<br />
------------------------------------ --------------------------------<br />
VALUE<br />
------------------------------<br />
timed_statistics boolean<br />
TRUE<br />
SQL><br />
SQL> alter session set sql_trace=true;<br />
Session altered.<br />
SQL><br />
SQL><br />
SQL> select owner, count(*)<br />
2 from all_objects<br />
3 group by owner;<br />
OWNER COUNT(*)<br />
------------------------------ ----------<br />
MDSYS 458<br />
TSMSYS 2<br />
FLOWS_020100 1085<br />
PUBLIC 2766<br />
OUTLN 7<br />
sqle 99<br />
CTXSYS 338<br />
HR 34<br />
FLOWS_FILES 11<br />
SYSTEM 422<br />
DBSNMP 46<br />
OWNER COUNT(*)<br />
------------------------------ ----------<br />
XDB 334<br />
SYS 6611<br />
13 rows selected.<br />
SQL> /<br />
OWNER COUNT(*)<br />
------------------------------ ----------<br />
MDSYS 458<br />
TSMSYS 2<br />
FLOWS_020100 1085<br />
PUBLIC 2766<br />
OUTLN 7<br />
sqle 99<br />
CTXSYS 338<br />
HR 34<br />
FLOWS_FILES 11<br />
SYSTEM 422<br />
DBSNMP 46<br />
OWNER COUNT(*)<br />
------------------------------ ----------<br />
XDB 334<br />
SYS 6611<br />
13 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
</source><br />
<br />
<br />
<br />
<br />
==SHOW USER==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> SHOW USER<br />
USER is "sqle"<br />
SQL><br />
</source></div>
Admin