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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sufficient next extent space

RE: sufficient next extent space

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 07 Feb 2005 08:06:04 -0500
Message-Id: <s207217b.091@gcrta.org>


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_at_rsmb.co.uk> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: 07 February 2005 12:50
To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com
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

--
http://www.freelists.org/webpage/oracle-l 



--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 07 2005 - 08:09:02 CST

Original text of this message

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