Re: How to view a specific index

handl_at_mts.net (Laura) wrote in message news:<e0ddcf8.0407191348.37e80f38_at_posting.google.com>...
> What is the sql command to view information on a specific index?
>
> If the index is
> ADMIN.LR_ACCOUNT_IDX
>
> How do you see all the information on how it was set up?
> Like storage, the extents, space.
>
> Reason is, that I got an error
> ORA-1632: max # extents 128 reached in index ADMIN.LR_ACCOUNT_IDX
>
> Now I wanted to look at it, with out going into DBA studio. Vendor
> fixed by setting to unlimmited, is this a good thing?

Yes, it is a good thing (unless you are on V7 and have very small blocks). Why not use the tools you have? Metalink has a bunch of scripts if you feel the need to learn, and the docs have much interesting info http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch252.htm#1292867 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/stats.htm#25115 .

Sometimes you can do interesting things with OEM, too, like look and see what sql a tool is using, if that tool doesn't have the option to show the sql.

jg

--
@home.com is bogus.
How to make money with open source software: 
http://www.signonsandiego.com/uniontrib/20040720/news_1b20lindows.html