Q
Problem solve Get help with specific problems with your technologies, process and projects.

Determining size of table in Oracle database

What is the query to determine the table size of a database in Oracle?

What is the query to determine the table size of a database in Oracle?

Any object in Oracle that requires space is called a SEGMENT. Tables and indexes are both considered segments. A view, stored procedure and sequences are examples of objects that are not considered segments since only their definition is stored in the Data Dictionary.

If you want to see the size of any segment, you can query the DBA_SEGMENTS view. So to find the size of a table, use the following query:

SELECT bytes FROM dba_segments
WHERE owner='SCOTT' AND segment_name='EMP';
Keep in mind that this is the allocated space of the table.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close