OraFAQ Forum: Performance Tuning » Clustering Factor for LOB Index

Home » RDBMS Server » Performance Tuning » Clustering Factor for LOB Index_Type is NULL (Oracle 11gr2 RHEL)

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

Clustering Factor for LOB Index_Type is NULL [message #649510]

Tue, 29 March 2016 07:18

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Hi,

Can you please help me understand why it shows NULL in CLustering Factor for LOB Index_type

Please let me know for any queries.
Thanks in advance.

Regards,
Hitesh

Report message to a moderator

Re: Clustering Factor for LOB Index_Type is NULL [message #649511 is a reply to message #649510]

Tue, 29 March 2016 07:31

John Watson
Messages: 8454
Registered: January 2010
Location: Global Village

Senior Member

You can't really have a clustering factor for a LOB index. The LOB index is the pointers to the chunks of the LOB. It isn't something on which the CBO can make a choice on how best to apply a predicate.

Report message to a moderator

Re: Clustering Factor for LOB Index_Type is NULL [message #649512 is a reply to message #649511]

Tue, 29 March 2016 07:39

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Many Thanks for reply.
Can I check the total size of all the LOB indexes ?
Can it be possible to provide some script for the same.
Many Thanks in advance.

Report message to a moderator

Re: Clustering Factor for LOB Index_Type is NULL [message #649513 is a reply to message #649512]

Tue, 29 March 2016 07:44

John Watson
Messages: 8454
Registered: January 2010
Location: Global Village

Senior Member

Segment sizes are published in dba_segments. As for writing a script for you, certainly - standard consulting rates will apply.

Report message to a moderator

Previous Topic:	dynamic sql
Next Topic:	Performance tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 06:52:10 CST 2021