Oracle field size, take 2 
Author Message
 Oracle field size, take 2
Hey there,

I would like (correction, my boss wants) to get the size of an Oracle
table.

Since, I'm pretty new to SQL, could anyone help?

Thanx!

Nr



Tue, 23 Oct 2001 03:00:00 GMT
 Oracle field size, take 2

Hi,

To obtain the size of a table, you can run the analyze command against
the table, which will tell you the average row size, the number of rows,
where the High Water Mark is (which states the highest block ever used),
the number of empty blocks.

All of this can be found on the DBA_TABLES / USER_TABLES.

Hope this helps,
Andrew

Quote:

> Hey there,

> I would like (correction, my boss wants) to get the size of an Oracle
> table.

> Since, I'm pretty new to SQL, could anyone help?

> Thanx!

> Nr



Wed, 24 Oct 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DB size increased after reducing fields size

2. Oracle size of numeric fields?

3. Oracle size of numeric fields

4. Field sizes in Oracle- 255 max?

5. changing the field size of primary key field....

6. HOW TO change field size and delete field

7. controlling field sizes via numeric field input?

8. How to get the number of BYTES a field takes up

9. WHY: count() over an indexed field takes a long time

10. Database field not taking variable value w/o generating error

11. SQL Server database file size versus Oracle File size

12. NT Cluster size and Oracle data block size


 
Powered by phpBB® Forum Software