Home » RDBMS Server » Server Administration » Difference between bytes & user_bytes in dba_data_files (10.2.0.3, windows)
Difference between bytes & user_bytes in dba_data_files [message #571567] Tue, 27 November 2012 02:49 Go to next message
ishika_20
Messages: 334
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
Re: Difference between bytes & user_bytes in dba_data_files [message #571571 is a reply to message #571567] Tue, 27 November 2012 03:02 Go to previous message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about reading the documentation?

http://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_3083.htm#i1620500

Regards
Michel
Previous Topic: Exchange Partition issue
Next Topic: Taking Tablespace Offline
Goto Forum:
  


Current Time: Sat Apr 19 05:11:26 CDT 2014

Total time taken to generate the page: 0.11057 seconds