Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How many times a table has extended
On Tue, 16 Nov 1999 14:18:07 GMT, qcoldiro_at_my-deja.com wrote:
>How can I tell in SQL*Plus how many times a table has extended?
With
SELECT extents FROM user_segments where segment_name = '~table_name~';
you get the number of extents of the table including INITIAL-extent.
Hope this helps
Reinhard