http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Packages%2Fdbms_space
Oracle PL/SQL/System Packages/dbms space - История изменений
2026-05-24T11:41:37Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/dbms_space&diff=1228&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://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/dbms_space&diff=1229&oldid=prev
Admin: 1 версия
2010-05-26T09:55:16Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Use dbms_space to show space==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> --show space<br />
SQL><br />
SQL><br />
SQL> create or replace procedure show_space(<br />
2 p_segname in varchar2,<br />
3 p_owner in varchar2 default user,<br />
4 p_type in varchar2 default "TABLE")<br />
5 as<br />
6 l_free_blks number;<br />
7<br />
8 l_total_blocks number;<br />
9 l_total_bytes number;<br />
10 l_unused_blocks number;<br />
11 l_unused_bytes number;<br />
12 l_lastusedextfileid number;<br />
13 l_lastusedextblockid number;<br />
14 l_last_used_block number;<br />
15<br />
16 begin<br />
17 dbms_space.free_blocks(<br />
18 segment_owner => p_owner,<br />
19 segment_name => p_segname,<br />
20 segment_type => p_type,<br />
21 freelist_group_id => 0,<br />
22 free_blks => l_free_blks );<br />
23<br />
24 dbms_space.unused_space(<br />
25 segment_owner => p_owner,<br />
26 segment_name => p_segname,<br />
27 segment_type => p_type,<br />
28 total_blocks => l_total_blocks,<br />
29 total_bytes => l_total_bytes,<br />
30 unused_blocks => l_unused_blocks,<br />
31 unused_bytes => l_unused_bytes,<br />
32 last_used_extent_file_id => l_lastusedextfileid,<br />
33 last_used_extent_block_id => l_lastusedextblockid,<br />
34 last_used_block => l_last_used_block );<br />
35<br />
36 dbms_output.put_line( "Free Blocks");<br />
37 dbms_output.put_line( l_free_blks );<br />
38 dbms_output.put_line( "Total Blocks");<br />
39 dbms_output.put_line( l_total_blocks );<br />
40 dbms_output.put_line( "Total Bytes");<br />
41 dbms_output.put_line( l_total_bytes );<br />
42 dbms_output.put_line( "Unused Blocks");<br />
43 dbms_output.put_line( l_unused_blocks );<br />
44 dbms_output.put_line( "Unused Bytes");<br />
45 dbms_output.put_line( l_unused_bytes );<br />
46 dbms_output.put_line( "Last Used Ext FileId");<br />
47 dbms_output.put_line( l_lastusedextfileid );<br />
48 dbms_output.put_line( "Last Used Ext BlockId");<br />
49 dbms_output.put_line( l_lastusedextblockid );<br />
50 dbms_output.put_line( "Last Used Block");<br />
51 dbms_output.put_line( l_last_used_block );<br />
52 end;<br />
53 /<br />
Procedure created.<br />
SQL><br />
SQL> --<br />
</source></div>
Admin