Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

shrink tablespace after table reorg

NRAJJun 25 2014 — edited Jun 27 2014

Hello,

I did the table reorg of one table after moving major data to cloud.  Table size Before - 120G / After 150 MB. Oracle SE 11203.

Now from the tablespace level I see Total Free MB is 182825.953, but I cannot shrink at the tablespace level,

TABLESPACE_NAME Used Size MB           Max Size Mb Total Used MB Total Free MB    Used Percentage

------------------------------ ------------ ----------- ------------- ------------- --------------------------------------------------------

XXX                                        210391.922 262143.875 79317.9219          182825.953           30

When I query datafile for resize it shows only 4G can be gained.

FILE_NAME Smallest Size Poss.  Current Size    Poss. Savings

----------------- -------- ------       -----------     -----------

XXXXX                       20,865                 23,000         2,135

XXXXX                       21,570                 22,528           958

XXXXX                          129                      1,024           895

XXXXX                       32,352                 32,768           416

Could you please let me know the way to shrink and get the 178G ?

Thanks,

Raju

Comments

843811
accum: includes the time for the entries that appear above this one in the list. The last entry will have an accum of 100%
843811
You can also use perfanal utility provided in java.sun.com. It is very useful in interpreting the results of hprof.

~Rajesh.B
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2014
Added on Jun 25 2014
#11g, #general-database-discussions
22 comments
11,646 views