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.
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
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 04 2016 - 15:30:23 CET