Query DBA_EXTENTS for Tablespace name,Owner of the segment : DBA_EXTENTS « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. DBA_EXTENTS

Query DBA_EXTENTS for Tablespace name,Owner of the segment

 


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>








Related examples in the same category

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
2.Query DBA_EXTENTS for Name of the segment, Type of segment (ex. TABLE, INDEX)
3.Query to Find Out the File and Block IDs