Home » SQL & PL/SQL » SQL & PL/SQL » change inittrans value for a table
change inittrans value for a table [message #20790] Thu, 20 June 2002 07:39 Go to next message
Nagesh
Messages: 18
Registered: April 2002
Junior Member
Hi,

I have a database with morethan 50 tables. I have created one huge table with inittrans 1 option. Now 13 lakhs of rows in that table and that table references to another 5 more tables. How should i change the inittrans value to other. Immediate help would be appreciable.

Thanks in advance.

Nagesh.

Report message to a moderator

Re: change inittrans value for a table [message #20791 is a reply to message #20790] Thu, 20 June 2002 07:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can use
ALTER TABLE XXXX INITRANS 2.
by default it only affects on the new blocks.

to make it affective on all blocks use
ALTER TABLE XXXX MOVE TABLESPACE YYYY.

I have question too!.
does increasing initrans has any real potential gain?
I've never seen any!

Report message to a moderator

Re: change inittrans value for a table [message #20805 is a reply to message #20791] Fri, 21 June 2002 09:05 Go to previous message
Nagesh
Messages: 18
Registered: April 2002
Junior Member
Hi,

I don't have exat answer for that. But my guess is if number of users performing more transactions against one table then more than one intrans would give comfortable availability to users.

Nagesh

Report message to a moderator

Previous Topic: how to create a job which runs automatically for every 4 minutes
Next Topic: How can i retrieve data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 02:57:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.