DBA_DATA_FILES inconsistency?
- From: Rich <richa03@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Feb 2013 08:23:54 -0800
Hi List,
This is Oracle EE 10.2.0.5 on Solaris 5.10.
From SQL:
select FILE_NAME, FILE_ID, TABLESPACE_NAME, BLOCKS, STATUS, AUTOEXTENSIBLE,
MAXBLOCKS, INCREMENT_BY, USER_BLOCKS, ONLINE_STATUS
from dba_data_files where tablespace_name like 'HUB%';
I see the following:
FILE_NAME FILE_ID TABLESPACE_NAME BLOCKS
STATUS AUT MAXBLOCKS INCREMENT_BY USER_BLOCKS ONLINE_
----------------------------------- ---------- --------------- ------------
--------- --- ------------ ------------ ------------ -------
/u01/insta/data/hubaaaa_03.dbf 17 HUBAAAA 3,840,000
AVAILABLE YES 3,840,000 128 3,839,984 ONLINE
/u01/insta/data/hubaaaa_02.dbf 16 HUBAAAA 3,840,000
AVAILABLE YES 3,840,000 128 3,839,984 ONLINE
/u01/insta/data/hubaaaa_01.dbf 10 HUBAAAA 3,840,000
AVAILABLE YES 2,560,000 1280 3,839,984 ONLINE
/u01/insta/data/hubaaaaindx_01.dbf 2 HUBAAAAINDX 1,190,400
AVAILABLE YES 2,560,000 1280 1,190,392 ONLINE
Am I missing something?
Shouldn't MAXBLOCKS be larger than BLOCKS (and USERBLOCKS) for FILE_NAME
/u01/insta/data/hubaaaa_01.dbf (FILE_ID 10)?
Anyone seen anything like this?
Thanks,
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
