как узнать размер таблицы в oracle

Как узнать размер таблицы в oracle

��
unformatted_blocks
Total number of blocks that are unformatted

unformatted bytes
Total number of bytes that are unformatted

fs1_blocks
Number of blocks that has at least 0 to 25% free space

fs1_bytes
Number of bytes that has at least 0 to 25% free space

fs2_blocks
Number of blocks that has at least 25 to 50% free space

fs2_bytes
Number of bytes that has at least 25 to 50% free space

fs3_blocks
Number of blocks that has at least 50 to 75% free space

fs3_bytes
Number of bytes that has at least 50 to 75% free space

fs4_blocks
Number of blocks that has at least 75 to 100% free space

fs4_bytes
Number of bytes that has at least 75 to 100% free space

ful1_blocks
Total number of blocks that are full in the segment

full_bytes
Total number of bytes that are full in the segment 20 �� 09, 18:00��[7205723] �� | ��

Re: �� ? [new]

orawish
Member

��: ��-2 (City)
��: 15504

Brass,

20 �� 09, 20:03��[7206234] �� | ��

Re: �� ? [new]

Serguei
Member

��: Papua New Guinea
��: 713

Fedortsov A.

�� ?

20 �� 09, 20:12��[7206261] �� | ��

Re: �� ? [new]

Brass
Member

��: ��
��: 541

orawish

Brass,

��
��
��

20 �� 09, 22:23��[7206514] �� | ��

Re: �� ? [new]

Brass
Member

��: ��
��: 541

Brass

orawish
Brass,
20 �� 09, 22:34��[7206545] �� \| ��

Re: �� ? [new]
�� . Member ��: �� ��: 783	�� v$segstat �� .
20 �� 09, 22:53��[7206586] �� \| ��

Re: �� ? [new]

orawish
Member

��: ��-2 (City)
��: 15504

Brass,

�� , �� .
��, �� �� �� (�� ), ��, ��,
��

21 �� 09, 16:26��[7210971] �� | ��

�� 1 ��.

Re: �� ? [new]

Evgeny_1987
Member

��:
��: 26

Fedortsov A., � �� , �� blob-�� :

http://konurbaev-e.blogspot.ru/2013/06/oracle-database-how-to-calculate-actual.html

18 �� 13, 23:15��[14451106] �� | ��

Re: �� ? [new]

ORA__SQL
Member

��: Moscow
��: 1774

Evgeny_1987
Fedortsov A., � �� , �� blob-�� : http://konurbaev-e.blogspot.ru/2013/06/oracle-database-how-to-calculate-actual.html

��

19 �� 13, 00:04��[14451239] �� | ��

Re: �� ? [new]

Sayan Malakshinov
Member

��,
1. ��
2. �� upper, ��
3. �� ALL_ c DBA_, �� owner’a
4. �� lob index’� � ��
5. dba_segments �� «��» ��, �� , ��

19 �� 13, 02:23��[14451435] �� | ��

Re: �� ? [new]

Sayan Malakshinov
Member

��: ��
��: 5931

-2-
�� , �� .

��, ��

19 �� 13, 09:20��[14451790] �� | ��

Re: �� ? [new]

Evgeny_1987
Member

��
2. �� upper, �� 3. �� ALL_ c DBA_, �� owner’a

select
sum(s.bytes) into val
from
dba_lobs t
inner join
dba_segments s on t.segment_name = s.segment_name
where
t.table_name = upper(pNazvanie)
and
t.owner = upper(pOwner);

�� , �� .
�� 2 ��, �� .

19 �� 13, 20:05��[14456154] �� | ��

Re: �� ? [new]

Sayan Malakshinov
Member

COLUMN TABLE_NAME FORMAT A32
COLUMN OBJECT_NAME FORMAT A32
COLUMN OWNER FORMAT A10

Источник