RE: how do I find out the largest index in the database?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 17 Aug 2004 14:47:22 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262119FC41@irvmbxw02>

Step 1: Read this chapter of the manual: Oracle9i Database Concepts Release 2 (9.2) Part Number A96524-01 Chapter 4: The Data Dictionary

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c05d icti.htm

dba_segments has information on object sizes.

select
  b.*
 from
  (select a.owner, a.segment_name, sum (a.bytes) as total_bytes     from dba_segments a
    where a.segment_type in ('INDEX', 'INDX PARTITION', 'INDEX SUBPARTITION' -- , 'LOBINDEX'

                            )

    group by a.owner, a.segment_name
    order by 3 desc
  ) b
 where rownum = 1 ;

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Aug 17 2004 - 16:43:08 CDT