Query to find out specific Segment growth from Datafile

  --total bytes

SELECT OWNER,
  SEGMENT_NAME,
  SEGMENT_TYPE,
  TABLESPACE_NAME,
  SUM(BYTES)/1024/1024/1024 GB
FROM DBA_EXTENTS A
WHERE FILE_ID IN
  (SELECT FILE_ID
  FROM Dba_data_files
  WHERE TRIM(FILE_NAME) IN
    (SELECT TRIM(NAME)
    FROM V$DATAFILE
    WHERE TRUNC(SYSDATE)-10<TRUNC(CREATION_TIME)
    )
  )
  --AND A.TABLESPACE_NAME='VVS'
  GROUP BY OWNER,
  SEGMENT_NAME,
  SEGMENT_TYPE,
  TABLESPACE_NAME
ORDER BY SUM(BYTES)/1024/1024/1024 DESC;

       
--total block


SELECT OWNER,
  SEGMENT_NAME,
  SEGMENT_TYPE,
  TABLESPACE_NAME,
  SUM(BLOCKS)  BLOCKS
FROM DBA_EXTENTS A
WHERE FILE_ID IN
  (SELECT FILE_ID
  FROM Dba_data_files
  WHERE TRIM(FILE_NAME) IN
    (SELECT TRIM(NAME)
    FROM V$DATAFILE
    WHERE TRUNC(SYSDATE)-10<TRUNC(CREATION_TIME)
    )
  )
  AND A.TABLESPACE_NAME='VVS'
  GROUP BY OWNER,
  SEGMENT_NAME,
  SEGMENT_TYPE,
  TABLESPACE_NAME
ORDER BY SUM(BLOCKS)  DESC
;