Home » RDBMS Server » Backup & Recovery » tablespace full
tablespace full [message #194252] Thu, 21 September 2006 05:26 Go to next message
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 Go to previous messageGo to next message
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 #194255 is a reply to message #194253] Thu, 21 September 2006 05:35 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Check for

DBA_FREE_SPACE view..
Re: tablespace full [message #194306 is a reply to message #194252] Thu, 21 September 2006 07:54 Go to previous message
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 ;

Previous Topic: Please help ora-01203 wrong incarnation of this file in standby db
Next Topic: Shared Server Configuration
Goto Forum:
  


Current Time: Mon Dec 05 08:57:01 CST 2016

Total time taken to generate the page: 0.28165 seconds