| What are BLOCKS? [message #52738] |
Fri, 09 August 2002 07:38  |
Amol
Messages: 12
Registered: June 2001
|
Junior Member |
|
|
Hello,
What is the meaning of 'blocks', which is a field from tables like ALL_ALL_TABLES, USER_TABLES, etc.
Is it the number of cells in the table and if it is so does EMPTY_BLOCKS give the empty cells?
I am serching for a table which can show me number of cells filled in any table from any tablespace.
Thanks,
Amol
|
|
|
|
| Re: What are BLOCKS? [message #52753 is a reply to message #52738] |
Sun, 11 August 2002 17:21  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
1. Whatever you call tables, actually are views.
2. The meaning of "blocks" are number of disk space allocated in units caled blocks. The size is the db_block_size value in your init.ora file.
3. You have to write SQL query for that. Some ideas are given Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
