Updates

    Oracle: Query to find the 10 Largest Objects in DB

    SELECT * FROM
    (
    select
        SEGMENT_NAME,
        SEGMENT_TYPE,
        BYTES/1024/1024/1024 GB,
        TABLESPACE_NAME
    from
        dba_segments
    order by 3 desc 
    ) WHERE
    ROWNUM <= 10

    0 comments:

    Post a Comment

    Copyright © ORACLE ONLINE DBA
    Developed By Pavan Yennampelli