Modify IniTrans on composite interval-hash partitioned table, due to ora-00060
Date: Wed, 25 Mar 2015 20:07:07 +0100
Message-ID: <5513075B.8060105_at_gmail.com>
Hello everyone,
I follow the mailing list for a long time, but I never wrote.
I work on a DWH environment configured as follows: Datastage 8.7 +
Exadata 11G.
In our Datastage project we have a job that update single field of a
table, using PK.
This table is composite partitioned with local index: interval+hash.
Working with a low degree of DataStageparallelism, the job has always worked, but increasing the parallelism job aborted. Increase the parallelism leads to having more sessions and more transactions to the DB. The error is the Oracle ORA-00060.
Considering all that, searching the internet, a suggestion that is given is to increase the value of the parameter INITRANS, which for the table in question is set to the default value.
Two questions.
Do you think that is correct to solve this problem by increasing the
value of INITRANS?
If yes, how to calculate the optimal value?
And, what are the necessary steps so that all partitions and
subpartitions have the new value?
Thank you very much,
greetings
Sandro
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 25 2015 - 20:07:07 CET