Home » RDBMS Server » Performance Tuning » Index storage
Index storage [message #65592] Wed, 03 November 2004 21:29 Go to next message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi,

I have been given a task of specifying storage parameters for Indexes.Can anybody suggest me a checklist that will tell me to specify optimal storage parameters for an Index.

What are the things that I should keep in mind before specifying the storage parameters for an Index.

Pls. this is urgent.

Thanks in Advance.

Milind.
Re: Index storage [message #65598 is a reply to message #65592] Thu, 04 November 2004 02:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
USE LMT ( local managed tablespaces) for indexes (and tables and everything else), use uniform extents. FORGET the storage clauses and other dictionary managed concepts.
Re: Index storage [message #65630 is a reply to message #65598] Wed, 17 November 2004 16:57 Go to previous message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi Mahesh,

Thanks for your help but the problem is we have been recommended that we will be using DMT in our environment and therefore optimal storage parameters are to be specified for the Indexes.

Pls. suggest me to findout the optimal value for INITIAL EXTENT parameter for the Indexes.

thanks in Advance

Milind.
Previous Topic: about EVENT TRACE
Next Topic: 10046 - Unable to trace JDBC thin client
Goto Forum:
  


Current Time: Fri Mar 29 00:18:16 CDT 2024