Home » RDBMS Server » Server Administration » Top 250 database tables (oracle 9.2.0.6 database,sunos)
Top 250 database tables [message #276098] Tue, 23 October 2007 23:42 Go to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
I wanted know if there is way to find list of the top 250 largest tables from a database,with tablename,tablespace name and size .If anyone can help me here,I will be grateful.

Regrads,
Re: Top 250 database tables [message #276103 is a reply to message #276098] Wed, 24 October 2007 00:08 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try something like this:

SELECT * FROM (
  SELECT segment_name, tableSpace_name, bytes / 1024 / 1024 "Meg"
    FROM dba_Segments
   WHERE segment_type = 'TABLE'
   ORDER BY 3 DESC)
WHERE rownum <= 250
/
Re: Top 250 database tables [message #276108 is a reply to message #276098] Wed, 24 October 2007 00:34 Go to previous message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Thanks a lot frank!
Previous Topic: tracing of production databases increases fastly?
Next Topic: error while quering
Goto Forum:
  


Current Time: Thu Dec 08 18:20:09 CST 2016

Total time taken to generate the page: 0.08960 seconds