OraFAQ Forum: Server Administration » Index usage

Home » RDBMS Server » Server Administration » Index usage - script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index usage - script [message #113062]

Wed, 30 March 2005 16:53

prekida
Messages: 5
Registered: March 2005

Junior Member

Does anyone have script for determining the index usage

Thanks

Report message to a moderator

Re: Index usage - script [message #113328 is a reply to message #113062]

Fri, 01 April 2005 08:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please explain.
are looking into
1. check the whether the index is used or not?
or
2. space usage of index?
or
3. How data is spread ?

Report message to a moderator

Re: Index usage - script [message #113352 is a reply to message #113328]

Fri, 01 April 2005 09:57

prekida
Messages: 5
Registered: March 2005

Junior Member

I am looking for space usage for index, what is originally allocated, what's being used and what's free space for all indexes in a database

Thanks

Report message to a moderator

Re: Index usage - script [message #113376 is a reply to message #113352]

Fri, 01 April 2005 12:38

andrew again
Messages: 2577
Registered: March 2000

Senior Member

this file will report usage, free space for each index and table. The indexes occur before the table in the report to be able to easly show grand totals. Doesn't handle LOB segements, hence the mini breakdown at the end.

Attachment: tab_indx_space_usage_by_TS.sql
(Size: 5.82KB, Downloaded 1060 times)

Report message to a moderator

Re: Index usage - script [message #113380 is a reply to message #113376]

Fri, 01 April 2005 13:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

cool script Andrew!
Predika:
See whether it helps you.

Report message to a moderator

Re: Index usage - script [message #113386 is a reply to message #113380]

Fri, 01 April 2005 14:10

prekida
Messages: 5
Registered: March 2005

Junior Member

Thanks Andrew! It is very helpful

Thank you very much

Report message to a moderator

Previous Topic:	how to increase size of a tablespace
Next Topic:	Unable to start 2 Oracle services

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 00:49:27 CDT 2025