OraFAQ Forum: SQL & PL/SQL » No.of extents allocated

Home » SQL & PL/SQL » SQL & PL/SQL » No.of extents allocated

Mon, 24 November 2003 23:16

Sudhakar
Messages: 34
Registered: May 2002

Member

Hi,

Is is possible to know the number of extents allocated for an object?

Mon, 24 November 2003 23:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Select extents
  From user_segments
 Where segment_name = 'YOUR_TABLE'
   And segment_type = 'TABLE';

MHE

Previous Topic:	FETCH BIRTHDAY LIES WITH IN A WEEK
Next Topic:	Performance improvement when UNION

Goto Forum:

]

Current Time: Thu Apr 25 17:19:12 CDT 2024