Re: DBA_FREE_SPACE has multiple rows for a given file_id
Date: Sun, 4 Dec 2016 14:56:42 +0000
Message-ID: <MMXP123MB091138A309BBCD9795B77FC9A5800_at_MMXP123MB0911.GBRP123.PROD.OUTLOOK.COM>
Sorry, wrong one.
Give me a couple of minutes to find the right one - I wrote it up a couple of years ago. It's on my blog somewhere.
Regards
Jonathan Lewis
From: Jonathan Lewis
Sent: 04 December 2016 14:55:18
To: oracle-l_at_freelists.org
Subject: Re: DBA_FREE_SPACE has multiple rows for a given file_id
Answered here (probably):
http://jonathanlewis.wordpress.com/2013/02/25/free-space-2/
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jithin Sarath <jithinsarath_at_gmail.com> Sent: 04 December 2016 14:30:23
To: oracle-l_at_freelists.org
Subject: DBA_FREE_SPACE has multiple rows for a given file_id
I am an Oracle EBS DBA, who lurks here to learn. While looking at what one of our alerts do, I observed something that I felt strange.
Our in house DBA added a 2 GB datafile and it showed up as below.
[Inline images 1]
It appears that the 2 GB was split into 496 MB x4 + 64 MB.
I'm curious to see why is there an upper limit of 496 here ? My SYSTEM tablespace has the below specs
[Inline images 2]
[Inline images 3]
Anyone with some free time who can help me understand is most welcome.
Thanks !! J
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 04 2016 - 15:56:42 CET