в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T10:01:23Z

1 версия

Новая страница

==Query DBA_EXTENTS for Extent number in the segment, Starting block number for the extent, Size of the extent in bytes, Size of the extent, in Oracle blocks==



<source lang="sql">

SQL> select
6 Extent_ID, /*Extent number in the segment*/
7 Block_ID, /*Starting block number for the extent*/
8 Bytes, /*Size of the extent, in bytes*/
9 Blocks /*Size of the extent, in Oracle blocks*/
10 from DBA_EXTENTS
11 where Segment_Name = "segment_name"
12 order by Extent_ID;
SQL>
SQL>

</source>

==Query DBA_EXTENTS for Name of the segment, Type of segment (ex. TABLE, INDEX)==



<source lang="sql">

SQL> select
4 Segment_Name, /*Name of the segment*/
5 Segment_Type /*Type of segment (ex. TABLE, INDEX)*/
10 from DBA_EXTENTS
11 where Segment_Name = "segment_name"
12 order by Extent_ID;
SQL>
SQL>

</source>

==Query DBA_EXTENTS for Tablespace name,Owner of the segment==



<source lang="sql">

SQL> select
2 Tablespace_Name, /*Tablespace name*/
3 Owner /*Owner of the segment*/
10 from DBA_EXTENTS
11 where Segment_Name = "segment_name"
12 order by Extent_ID;
SQL>
SQL>

</source>

==Query to Find Out the File and Block IDs==



<source lang="sql">

SQL>
SQL> SELECT SEGMENT_NAME,
2 FILE_ID,
3 BLOCK_ID
4 FROM DBA_EXTENTS
5 WHERE OWNER = "OE"
6 AND SEGMENT_NAME LIKE "ORDERS%"
7 /
no rows selected
SQL>
SQL> --

</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/System Tables Views/DBA EXTENTS - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия