| RE:Checking storage space [message #61347] |
Thu, 15 April 2004 22:40  |
dhnish
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi
How do i check the storage used space for a particular table?
Could i know the command please? I'am using Oracle8i on SUn unix.
Thank you and have a nice day
Yours in service,dhnish
|
|
|
|
| Re: RE:Checking storage space [message #61349 is a reply to message #61347] |
Thu, 15 April 2004 23:03  |
Padmanabhan
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
U can analyze the table like
sql>analyze table
compute statistics;
then , get the block size by,
sql>show parameter db_block_size
select [[blocksize value]]*blocks from dba_tables where table_name = 'tablename';
regards
Padhu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
