We need a tool that tells us how much of a data file we have consumed. If I
insert a 1,000,000 into a database, I should be able to run a command and have
it tell me the percentage used and free in the data file.
Running out of room in the data file will bring cluster processing to a halt
until expanded. This is not HA. DBA/Admins should be able to find out a head of
time that they are running out of room so they can expand by adding another file
and not incur down time.
Currently INFORMATION_SCHEMA.FILES show #free extents
These are extents that can be used by any table.
It is not applicable to show anything other on a per file basis.
I think this example shows why.
Suppose you have a datafile with only 2 extents, each of size 1Gb
One extent is allocated to table T1 and is full.
The other extent is allocated to table T2 and is empty.
If one present this a file 50% full (or empty) it is very missleading
as one can not insert into _any_ other table than T2.
I.e even in 1Gb is "empty" I can't make any inserts...
I think this alternative is out of the question.
---
Since this is not possible, one must extend information show per table.
I.e. find a way of informating that table T1 has 0 free bytes in the extents
that it currently has allocated and the table T2 can make 1Gb of inserts
before it need to allocate a new extent.
The two alternatives that I can think of now is information_schema.tables
or "show table info" (or alike).
I have not however examined either of these,
But I suggest that the person that gets assigned to this WL should do that.
---
Also note that I think that what's currently in INFORMATION_SCHEMA.FILES
is enough to satisfy the second paragraph in the describtion above.
But as discussion has proved not the intent of the entire WL.
Copyright (c) 2000, 2013, Oracle Corporation and/or its affiliates. All rights reserved.
© 2013, Oracle Corporation and/or its affiliates
