DBA_FREE_SPACE has multiple rows for a given file_id

From: Jithin Sarath <jithinsarath_at_gmail.com>
Date: Sun, 4 Dec 2016 20:00:23 +0530
Message-ID: <CACoevcpbinOyxXfj9fWhrxqHcudHcWqpiVjusr27YwHpThJcOg_at_mail.gmail.com>

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.

[image: 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

[image: Inline images 2]
[image: Inline images 3]

Anyone with some free time who can help me understand is most welcome.

Thanks !! J


Received on Sun Dec 04 2016 - 15:30:23 CET

Original text of this message