| Export - URGENT REQ!!!!!!! [message #57076] |
Mon, 19 May 2003 11:37  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
This is the query i use,
select nvl(b.tablespace_name,nvl(a.tablespace_name,'UNKNOWN')) name
, kbytes_alloc kbytes
, kbytes_alloc-nvl(kbytes_free,0) used
, nvl(kbytes_free,0) free
, ((kbytes_alloc-nvl(kbytes_free,0))/kbytes_alloc)*100 pct_used
, nvl(largest,0) largest
from (select sum(bytes)/1024 Kbytes_free
, max(bytes)/1024 largest
, tablespace_name
from dba_free_space
group by tablespace_name) a
, (select sum(bytes)/1024 Kbytes_alloc
, tablespace_name
from dba_data_files
group by tablespace_name) b
where a.tablespace_name (+) = b.tablespace_name
order by used
RESULT SET
Table space Name :REMODEL02
KBYTES :49152000
USED :6615232
FREE :42536768
PCT_USED :13.4587239583333
Largest :3174384
Requirement:
I have a table "Employee" stored within
this tablespace(REMODEL02), I want the space(size) occupied by Employee table.
URGENT !!!!!
Raj
|
|
|
|
| Re: Export - URGENT REQ!!!!!!! [message #57085 is a reply to message #57076] |
Mon, 19 May 2003 23:32  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
One way is
Analyze table
> compute statistics
select blocks from user_tables where table_name ='<<desired table>>'
calculate:
blocks * block_size
Also
Records per block = (block size - 110 bytes for overhead) * (PCTUSED/100)/
Average Record Size
Total blocks = (records in table) / (records per block)
Total table size = blocks * block size
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
