OraFAQ Forum: Server Administration » oracle storage structure parameters

Home » RDBMS Server » Server Administration » oracle storage structure parameters (Oracle 9i / OS Linux)

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

oracle storage structure parameters [message #332448]

Tue, 08 July 2008 09:47

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

Report message to a moderator

Re: oracle storage structure parameters [message #332451 is a reply to message #332448]

Tue, 08 July 2008 09:50

babuknb
Messages: 1736
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

Report message to a moderator

Re: oracle storage structure parameters [message #332454 is a reply to message #332448]

Tue, 08 July 2008 10:08

BlackSwan
Messages: 26766
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)

Report message to a moderator

Re: oracle storage structure parameters [message #332458 is a reply to message #332448]

Tue, 08 July 2008 10:18

Michel Cadot
Messages: 68667
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 22 15:43:45 CDT 2024