NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Chekcing Fragmentation in Table for Oracle DB

1 comment
The below mentioned script can be used to check the table Fragmentation

Column owner   Format A6
Column table_name Format A25
Column "Fragmented-Actual"    Format A15
Column "Fragmented Size"   Format A17
Column "Actual Data Size"   Format A17

SELECT 

owner,table_name,
round((blocks*8),2)||' kb' "Fragmented Size",
round((num_rows*avg_row_len/1024),2)||' kb' "Actual Data Size",
(round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )||' kb' "Fragmented-Actual"
FROM dba_tables
WHERE table_name = '&table_name' ;

1 comment :

  1. Mark Hurd Oracle will dedicate more resources and money to its IaaS business, but first it had to spend a lot of cash making sure its legacy software were cloud compatible and better suited to changing customer purchasing habits……

    ReplyDelete