Database Administration (MOSC)

MOSC Banner

Actual Table size

edited May 22, 2020 12:29PM in Database Administration (MOSC) 3 commentsAnswered

I have used below query to calculate table size.

SELECT  Segment_name, Segment_type, Bytes, (Bytes/ 1024)/ 1024 Mb

  FROM  Dba_segments

WHERE  Segment_type = 'TABLE'

    AND Segment_name in ( 'TABLE');

O/P: Bytes: 1441792

Size in MB: 1.375

So, I have deleted a few records from my table and re-queried. But nothing is changed I got same result.

Usually, after deleting the records the table size should be reduced correct but i did not happen.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center