RE: sufficient next extent space
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <howard.latham@xxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Mon, 07 Feb 2005 08:06:04 -0500
But you would only want to sum them if they are adjacent. Suggestions
on how?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
>>> "Howard Latham" <howard.latham@xxxxxxxxxx> 2/7/05 7:48:35 AM >>>
Here's a fishing rod.
Sum and group by spring to mind.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: 07 February 2005 12:50
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
Subject: sufficient next extent space
I have an SQL script that looks for sufficient space for the next
extent. I am having a problem though when Oracle is breaking the
datafile into multiple free extents, i.e.
26 107,758 153,816 ***FREE***
426 126,985 507,904 ***FREE***
426 190,473 421,824 ***FREE***
427 9 507,904 ***FREE***
427 63,497 507,904 ***FREE***
427 126,985 507,904 ***FREE***
427 190,473 421,824 ***FREE***
File 427 is a brand new 1900M datafile in the tablespace. Right now I
am seeing the largest free as 507,904 bytes and not 1900 M. Any
suggestions on how to combine the extents in the sql script.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
