Home » RDBMS Server » Server Administration » oracle storage structure parameters (Oracle 9i / OS Linux)
oracle storage structure parameters [message #332448] Tue, 08 July 2008 09:47 Go to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Hi experts ,
Give me the reason that why we use INITRANS parameter 3 in case of index segment and 2 of data segment.
what is the role of INITRANS?

Thanks
Vivek Kumar
Re: oracle storage structure parameters [message #332451 is a reply to message #332448] Tue, 08 July 2008 09:50 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

>>Give me the reason that why we use INITRANS parameter 3 in case of index segment and 2 of data segment

I can't able to understand your question.

Babu
Re: oracle storage structure parameters [message #332454 is a reply to message #332448] Tue, 08 July 2008 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Vivek.k.thakur wrote on Tue, 08 July 2008 07:47
Hi experts ,
Give me the reason that why we use INITRANS parameter 3 in case of index segment and 2 of data segment.
what is the role of INITRANS?

Thanks
Vivek Kumar


Reasearch "Interested Transaction List" (ITL)
Re: oracle storage structure parameters [message #332458 is a reply to message #332448] Tue, 08 July 2008 10:18 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know why you are using these values. The default is 1 for table and 2 for index.

Regards
Michel
Previous Topic: Migration Oracle 10G pre activities
Next Topic: Updating oracle9i Db with the Updation of Oracle10g DB
Goto Forum:
  


Current Time: Fri Dec 09 03:42:19 CST 2016

Total time taken to generate the page: 0.12190 seconds