OraFAQ Forum: Server Administration » PCTUSED not permited with index

Home » RDBMS Server » Server Administration » PCTUSED not permited with index (oracle 8i 9i 10g)

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

PCTUSED not permited with index [message #337393]

Wed, 30 July 2008 14:37

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Why does Oracle not permit the use of PCTUSED with indexes?

I will appreciate reply for my question...

Note:-I do have access to metalink and oracle documentation

Report message to a moderator

Re: PCTUSED not permited with index [message #337394 is a reply to message #337393]

Wed, 30 July 2008 14:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because it is meaningless.

Regards
Michel

Report message to a moderator

Re: PCTUSED not permited with index [message #337395 is a reply to message #337394]

Wed, 30 July 2008 14:54

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Thank you very much michel...

Actually some one asked me that in interview ... Very Happy

I said user are not inserting in index Very Happy

... its upto oracle to manage size of leaf block.

I don't know i am right or wrong...

Report message to a moderator

Re: PCTUSED not permited with index [message #337478 is a reply to message #337395]

Thu, 31 July 2008 01:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The good answer to this question in interview is to explain what PCTUSED means and does, then how an index works and so you will show it is meaningless for an index.

Regards
Michel

[Updated on: Thu, 31 July 2008 01:04]

Report message to a moderator

Previous Topic:	how to reduce the database size after dropping the schema
Next Topic:	Different execution plans for same query ???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:29:26 CST 2024