RE: sufficient next extent space
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'JBECKSTROM@xxxxxxxxx'" <JBECKSTROM@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx, Tony.Adolph@xxxxxx
- Date: Mon, 7 Feb 2005 09:33:59 -0500
All,
This is exactly why we like Locally Managed Disks and Uniform extent sizes.
All of this "management" effort goes away. Just not needed any more.
Tom
-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Monday, February 07, 2005 9:20 AM
To: oracle-l@xxxxxxxxxxxxx; oracle-db-l@xxxxxxxxxxxxxxxxxxxx;
ORACLE-L@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx; Tony.Adolph@xxxxxx;
oracle-rdbms@xxxxxxxxxxxxxxx
Subject: Re: sufficient next extent space
That's the problem the new datafile is showing as multiple free extents
so max won't work.
>>> <Tony.Adolph@xxxxxx> 2/7/05 9:20:05 AM >>>
Hi Jeffrey,
My point is that IF they are ajacent they will be counted by max(bytes)
as one lump (extent). I.e. max(bytes) gives the largest continuous lump
of freespace. I think you have an error in your calculations /
assumptions. continuous lump of freespace = free extents if they are
adjacent
I don't know why your new datafile isn't showing up as 99% free, i.e.
max(bytes) = 99% of total size of new datafile, but that's a different
problem....
Tony
"Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
02/07/2005 02:36 PM To
<Tony.Adolph@xxxxxx> cc
Subject
Re: sufficient next extent space
That is what I currently do. That won't combine if adjacent. Only
want to combine the free extents if they are adjacent to each other.
>>> <Tony.Adolph@xxxxxx> 2/7/05 8:36:31 AM >>>
Hi Jeff,
Run this query. I have grouped by file_id instead of TS:
select
file_id,
sum(bytes) free,
max(bytes) max_extent
from
dba_free_space
group by file_id
I think you will see that do not have 3 (or how ever many) large
contiguous extents... max(bytes) gets the largest for you.... If it
doesn't come up in the column, then the big extents you extpected is
already split somehow.
Tony
"Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
02/07/2005 02:19 PM
To
<Tony.Adolph@xxxxxx> cc
Subject
Re: sufficient next extent space
(select
tablespace_name,
sum(bytes) free,
max(bytes) max_extent
from
dba_free_space
group
by tablespace_name) fs
But this is grouping solely by tablespace_name getting max(bytes). In
my example:
427 9 507,904 ***FREE***
427 63,497 507,904 ***FREE***
427 126,985 507,904 ***FREE***
427 190,473 421,824 ***FREE***
I would want all 3 free space entries combined since they are adjacent.
This is a brand new datafile and notice all Oracle setup the free
extents.
>>> <Tony.Adolph@xxxxxx> 2/7/05 8:17:17 AM >>>
The adjacent extents are already summed... look at column max_extent
in dba_free_space
Tony
"Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/07/2005 02:07 PM
Please respond to
JBECKSTROM@xxxxxxxxx
To
<Tony.Adolph@xxxxxx> cc
<oracle-l@xxxxxxxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>,
<oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>,
<oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx> Subject
Re: sufficient next extent space
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
