File Header
David Jones wrote:
>
> Dear Guru:
>
> When I query the physical file size
>
> oracle:>ls -l users01.dbf
> -rw-r- 1 oracle dba 104865792 Apr 10 13:56 users01.dbf
>
> compare with the size I get from the v$datafile
> SQL> select name, sum(bytes) from v$datafile where
Title: RE: differences between physical datafile and v$datafile
Because your db_block_size is 4K?
|| -Original Message-
|| From: David Jones [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, May 01, 2001 5:01 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: differences between
Every Oracle tablespace uses one Oracle block of overhead for
tablespace/datafile administrative information.
-Original Message-
Sent: Tuesday, May 01, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Dear Guru:
When I query the physical file size
oracle:>ls -l users01.dbf
-rw-r-
Dear Guru:
When I query the physical file size
oracle:>ls -l users01.dbf
-rw-r- 1 oracle dba 104865792 Apr 10 13:56 users01.dbf
compare with the size I get from the v$datafile
SQL> select name, sum(bytes) from v$datafile where name like '%users%' group
by name;
NAME