Monday, September 26, 2016

OBJECTS IN SYSTEM TABLESPACE NOTES



  • Objects in SYSTEM TS

    OBJECTS IN SYSTEM TABLESPACE NOTES:
  • Owner - Owner of the object
  • Object Name - Name of object
  • Object Type - Type of object
  • Tablespace - Tablespace name
  • Size - Size (bytes) of object
  • Any user (other than SYS, SYSTEM) should have their objects moved out of the SYSTEM tablespace

    select OWNER,
 SEGMENT_NAME,
 SEGMENT_TYPE,
 TABLESPACE_NAME,
 BYTES
from  dba_segments
where TABLESPACE_NAME = 'SYSTEM'
and OWNER not in ('SYS','SYSTEM')
order  by OWNER, SEGMENT_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...