Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bytes is greater than maxbytes in dba_data_files

557800Aug 16 2007 — edited Aug 16 2007

Hi,

In what situation can the size of bytes be greater than the size of maxbytes in the dba_data_files?

select bytes,user_bytes,maxbytes from dba_data_files where bytes > maxbytes

BYTES USER_BYTES MAXBYTES

10485760000 10485694464 6392119296
6291456000 6288310272 5242880000
6291456000 6291390464 5242880000
6291456000 6291390464 5242880000
10485760000 10485628928 7340032000
33554432000 33552334848 0
15728640000 15725494272 12582912000
35357982720 35347496960 32212254720
11534336000 11523850240 5242880000
11534336000 11532238848 10485760000

Regards,
CT

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2007

Added on Aug 16 2007

#general-database-discussions

7 comments

7,349 views