Home » RDBMS Server » Performance Tuning » Clustering Factor for LOB Index_Type is NULL (Oracle 11gr2 RHEL)
Clustering Factor for LOB Index_Type is NULL [message #649510] Tue, 29 March 2016 07:18 Go to next message
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
Re: Clustering Factor for LOB Index_Type is NULL [message #649511 is a reply to message #649510] Tue, 29 March 2016 07:31 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Clustering Factor for LOB Index_Type is NULL [message #649512 is a reply to message #649511] Tue, 29 March 2016 07:39 Go to previous messageGo to next message
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.
Re: Clustering Factor for LOB Index_Type is NULL [message #649513 is a reply to message #649512] Tue, 29 March 2016 07:44 Go to previous message
John Watson
Messages: 8922
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.
Previous Topic: dynamic sql
Next Topic: Performance tuning
Goto Forum:
  


Current Time: Thu Mar 28 15:33:35 CDT 2024