Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: When to expect the next extent of table?

Re: When to expect the next extent of table?

From: <pjackson_at_hilliard.com>
Date: 1998/09/25
Message-ID: <6ugffo$7u4$1@nnrp1.dejanews.com>#1/1

Also, make sure there is enough space for the next extent. Use a query like this:

select tablespace_name,

       owner,
       segment_name,
       segment_type,
       next_extent

from dba_segments a
where not exists

   (select 'x'
    from dba_free_space b
    where a.tablespace_name = b.tablespace_name       and b.bytes >= a.next_extent)
order by tablespace_name,segment_name

--
Paul

In article <6uevf0$t7a$1_at_newton2.pacific.net.sg>,
  "Ng TC" <tcng_at_yas.com.sg> wrote:

>
> Hi,
>
> How do I check if a table (or other objects) will be creating the next
> extent (which dynamice views, dba_ views??)?
>
> How do I check how much of the current extent is being used?
>
> Thanks in advance.
>
> Regards,
> Tse Chong
>
> (Please reply trhough email: tcng_at_yas.com.sg )
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 25 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US