WebAug 2, 2016 · A simpler approach can be the one explained here: this article describe how to use the shrink command against Oracle database tables to reclaim wated space. If you want a detailed procedure give me the result of the following query: select distinct segment_type from dba_segments where tablespace_name='YOURTABLESPACENAME'; Share Improve … WebClick on the "Server" tab. Click the "Tablespaces" link. Select the "RECLAIM_TS" tablespace by clicking the radio button. Select the "Show Tablespace Contents" action and click the "Go" button. On the resulting page, expand the "Extent Map" section. The image below shows the extent map for the "RECLAIM_TS" tablespace.
Handy Oracle free space script
WebThis script displays tablespace free space and fragmentation for each tablespace. It prints the total size, the amount of space available, and a summary of free space fragmentation … WebCurrently i am using the below mentioned script to see the freespace in tablespace. But the Freespace shown in this report is mistakenly shown smaller than the actual freespace in the datafiles. For example i ran the below mentioned script and found that the tablespace CUSTDATA has only 4634 MB free. diving horse steel pier atlantic city
ORACLE-BASE - DBA Scripts: ts_full.sql
WebFeb 7, 2011 · SELECT /* + RULE */ df.tablespace_name "Tablespace", df.bytes / (1024*1024*1024) "Size (GB)", SUM (fs.bytes) / (1024*1024*1024) "Free (GB)", NVL (ROUND (SUM (fs.bytes) * 100 / df.bytes),1) "%Free", ROUND ( (df.bytes - SUM (fs.bytes)) * 100 / df.bytes) "%Used" FROM dba_free_space fs, (SELECT tablespace_name, SUM (bytes) … WebMay 9, 2007 · query to check tablespace size and freespace 547581 May 9 2007 — edited May 9 2007 hi experts i am using oracle 9i . want ot check freespace and size of … WebJan 18, 2012 · 1 try moving the table to another tablespace and back. – Benoit Jan 18, 2012 at 21:24 @benoit : I dont have an another tablespace to move the contents of a table.I need to free the space using the alter command. I tried to understand the alter index coalesce command but couldnt figure out it. – Raghavendar Jan 18, 2012 at 21:39 4 craft kits for teen girl