Accurate size of Index

Posted on 2004-11-19
Last Modified: 2006-11-17
On Oracle 9i or 10g,

After creating an index, either normal or bitmap:
How can you see its accurate size?
I don't mean the amount of extents taken from the free space.
I'm looking for something like the BLOCKS column from USER_TABLES view after performing an ANALYZE operation.

Question by:peledc
    LVL 1

    Accepted Solution

    select sum(bytes/1024) Ks
    from dba_segments
    where owner='<owner>'
    and segment_name = '<index_name>'

    hope it helps

    LVL 1

    Author Comment


    There is also the way of SELECT LEAF_BLOCKS from ind where index_name= '<Index_name>';
    and they both produce the same answers.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now