OraFAQ Forum: Server Administration » Difference between bytes & user_bytes in dba_data

Home » RDBMS Server » Server Administration » Difference between bytes & user_bytes in dba_data_files (10.2.0.3, windows)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Difference between bytes & user_bytes in dba_data_files [message #571567]

Tue, 27 November 2012 02:49

ishika_20
Messages: 203
Registered: December 2006
Location: delhi

Senior Member

Dear All,

I am confused about the two columns of dba_data_files (Bytes & user_bytes).

select bytes/1024/1024, maxbytes/1024/1024, user_bytes/1024/1024 from dba_data_files;

1	5	32767.984375	4.9375
2	490	32767.984375	489.9375
3	90	32767.984375	89.9375
4	530	32767.984375	529.9375
5	2048	32767.984375	2047.9375
6	2048	32767.984375	2047.9375
7	2048	0	2047.9375

Kindly help me out to understand about these columns.

Regards,
Ishika

Report message to a moderator