| tablespace full [message #194252] |
Thu, 21 September 2006 05:26  |
ramkrishna_gosavi
Messages: 15
Registered: June 2006
Location: pune
|
Junior Member |
|
|
hi, i hv monitoring the tablespace in oracle 9i,but which command is use find out use space, free space, how can find out pls send me this command
Regards
ramkrishna
[Updated on: Thu, 21 September 2006 05:27] Report message to a moderator |
|
|
|
| Re: tablespace full [message #194253 is a reply to message #194252] |
Thu, 21 September 2006 05:27  |
ramkrishna_gosavi
Messages: 15
Registered: June 2006
Location: pune
|
Junior Member |
|
|
| ramkrishna_gosavi wrote on Thu, 21 September 2006 05:26 |
hi, i hv monitoring the tablespace in oracle 9i,but which command is use find out use space, free space, how can find out pls send me this command
Regards
ramkrishna
|
|
|
|
|
|
|
| Re: tablespace full [message #194306 is a reply to message #194252] |
Thu, 21 September 2006 07:54 |
Shamsher
Messages: 18
Registered: September 2006
|
Junior Member |
|
|
Try this sql
SELECT tablespace_name, sum ( blocks ) as free_blk , trunc ( sum ( bytes ) / (1024*1024) ) as free_m , max ( bytes ) / (1024) as big_chunk_k, count (*) as num_chunks FROM dba_free_space
GROUP BY tablespace_name ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
