Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to find the current sizes of the tables in a Database?

 
Priya dharshini
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
How to find the current sizes of the tables in a Database. Please any one help me out.
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
checkout Dan Morgans Library page from Puget sound Oracle Users Group on tables:
http://www.psoug.org/reference/tables.html

check out the two queries at the bottom of the page. Excellent resource
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do you mean the number of rows, or something that is measured in KB/MB/GB? If the former, "select count(*) from table" will tell you that.
[ September 27, 2007: Message edited by: Ulf Dittmer ]
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want to know the number of rows in a table:

SELECT num_rows
FROM all_tables
WHERE table_name = 'YOUR_TABLE_NAME'
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic