Monday, September 26, 2016

FREE, LARGEST, & INITIAL NOTES


  • Freespace/Largest Ext

    FREE, LARGEST, & INITIAL NOTES:
  • Tablespace - Name of the tablespace
  • Total Free Space - Total amount (bytes) of freespace in the tablespace
  • Largest Free Extent - Largest free extent (bytes) in the tablespace

    select  TABLESPACE_NAME,
 sum(BYTES) Total_free_space,
    max(BYTES) largest_free_extent
from  dba_free_space
group  by TABLESPACE_NAME
    • By -
    Labels:

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)

    How To Fix Hive – Partition Table Query Failed When Stored As Parquet

    This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...