space issue [message #335948] |
Thu, 24 July 2008 04:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
I just noticed a proactive report lik this:
The tablespace is 85% filled...
But the datafiles show the status lik:
Say datafile1 is.....2000MB maxsize is 1500MB...
....
....
datafilen is.... 2000MB maxsize is 2000MB
My question is how is this possible? The datafile size is completly filled or exceeds the maxsize , but the tablespace status shows that there is a chance of 15% more growth of data in it???
Kindly explain.
Thanks & Regards.
|
|
|
|
Re: space issue [message #335951 is a reply to message #335948] |
Thu, 24 July 2008 04:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
Thanks for the reply. I understood your point.
But, My main concern is that the tablespace shows the space availabilty, but the datafile status shows that there is no space available for future data.
|
|
|
|
|
|
Re: space issue [message #336192 is a reply to message #336001] |
Fri, 25 July 2008 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
There is 1 more thing i wanted to clarify on..(may be stupid...)
SQL> create tablespace test datafile '/u01/test01.dbf' size 100K autoextend on next 10K maxsize 150K;
Tablespace created.
SQL> alter database datafile '/u01/test01.dbf' autoextend on maxsize 5K;
Database altered.
SQL> select bytes M, maxbytes max from dba_data_files where tablespace_name='TEST';
M MAX
---------- ----------
106496 8192
SQL> select 8192/1024 from dual;
8192/1024
----------
8
Maxsize i have kept as 5K...but the status here shows as 8192.
It should have been 5*1024????
I have just entered into the ORACLE field.. so in many concept i'm not clear... please excuse me.. if i had a very basic or silly doubt.
Thanks & Regards
|
|
|
|
|
|
Re: space issue [message #336557 is a reply to message #335948] |
Mon, 28 July 2008 02:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
5k is not a multiple of 8k which is your block size.
So Oracle rounded off to 8k.[nearest multiple]
I guess this is the reason.
|
|
|
|
|
|
Re: space issue [message #336579 is a reply to message #335948] |
Mon, 28 July 2008 04:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Quote: | I posted the rule, Ana posted the question, so we just have to wait.
|
and the OP posted the output:
SQL> select bytes M, maxbytes max from dba_data_files where tablespace_name='TEST';
M MAX
---------- ----------
106496 [b]8192[/b]
Since the value of maxbytes is 8k,as per rule oracle rounded off 5k to the nearest multiple of block size.
2k,4k are not multiples of 8k but 8k is .
|
|
|
|
Re: space issue [message #336793 is a reply to message #336783] |
Tue, 29 July 2008 01:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
16K.
The rule is "it is the minimal number of blocks greater than the size you specified".
You don't split block. Please read Database Concepts, at least the first chapter.
Regards
Michel
[Updated on: Tue, 29 July 2008 01:08] Report message to a moderator
|
|
|
|
|