Rich,
How about using the next_extent*2 compared with the select max(bytes)
from dba_free_space where tablespace_name ='tablespace name in
question';
That will show you if there is enough free space for two extents or
more.
I display sum(bytes) and max(bytes) to give a complete picture of the
Thanks, but the next extent is the easy one. As I mentioned, I'm already
running a similar query hourly.
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: [EMAIL
If PCT_INCREASE is set to 0, then can't we simply compare
next_extent*2 ( sub-query )?
-Original Message-
Sent: Friday, November 15, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
Thanks, but the next extent is the easy one. As I mentioned, I'm already
running a similar
Nope. If a segment has a NEXT EXTENT of 20M and the two largest contiguous
free spaces in it's TS are 30M and 15M, the second extent (i.e. two extends
to that segment) would fail, but would not show up in the query. That's
what spawned the complexity of my SQL.
Rich
Rich Jesse
Okay. Let me try this!
The largest column will have the biggest extent size that the tablespace can
accommodate next time. You might save this information in a temp. table and have the
other query to check against this.
select substr(a.tablespace_name,1,20) tablespace,