Database Administration (MOSC)

MOSC Banner

datafile maxsize when using Oracle Managed Files (OMF)

edited Jul 7, 2013 7:27PM in Database Administration (MOSC) 6 commentsAnswered ✓
Hi, 

I am a newbie in Oracle11g and trying to learn for OCA.
It is stated in the doc that maxsize is unlimited when using OMF.

"By default, an Oracle managed datafile for a permanent tablespace is 100 MB and is autoextensible with an unlimited maximum size"


I installed Oracle 11.2.0.3 on windows server 2008 64-bit and tried to use OMF, but the maxsize is set to 32Gb.


SQL> select file_name, maxbytes from dba_data_FILES WHERE tablespace_name LIKE '%OMF%';

FILE_NAME  : <somepath>\O1_MF_TEST_OMF_8XFDZLNS_.DBF 
MAXBYTES : 34359721984 (=32 Gb)


Can somebody help me to understand what's going on?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center