OraFAQ Forum: Server Administration » Why is one index unused?

Home » RDBMS Server » Server Administration » Why is one index unused?

Mon, 12 February 2007 06:34

aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid

Junior Member

Hi,
How could I find out the reason for one index to be unused?

Best regards and thank you very much.

Mon, 12 February 2007 07:11

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

Senior Member
Account Moderator

You mean, 'unused' with a query, where it is expected to be made use of
or
'Unusable' status of an index after a direct load/related?

Mon, 12 February 2007 07:25

aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid

Junior Member

Hi,
It had 'Unusable' status, maybe after a direct load/related, but i don't know.
How could I check it?

Mon, 12 February 2007 09:49

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

Senior Member
Account Moderator

Mon, 12 February 2007 09:57

aherranp@yahoo.es
Messages: 3
Registered: February 2007
Location: madrid

Junior Member

Thank you very much. We just solve the problem increasing temporary TS. Best regards,

Previous Topic:	tablespace UNDOTBS1 almost full, Any help
Next Topic:	Opatch failed due to inventory problem.

Goto Forum:

]

Current Time: Mon Dec 02 15:32:47 CST 2024