We had no negative impact from those blocks left with initrans=1. And it
truely did stop our locks.
I hope it works for you as well.
Kevin
-Original Message-
Sent: Friday, October 26, 2001 11:32 AM
To: 'Kevin Lange '; 'Multiple recipients of list ORACLE-L '
So the existing data blo
So the existing data blocks that were assigned to INITRANS=1 would not have
any negative impact, right?
Now I remember that was you had the problem and I read your note and kept
for reference. Now I am facing the same problem.
Thank you.
Bing
-Original Message-
To: Multiple recipien
Yes you can. But it will only be that way for new records added. We had
the same problem on 8.0.5 .
But that should be ok. Our problem was that , on new records, we had reads
coming thru that appeared to do full table scans while the initial inserts
were coming thru. This, apparently, caus
Look up the alter table command and see. If its there then you should
be able to, providing no one is actively using the table.
-Original Message-
Sent: Thursday, October 25, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have 8.1.7.1 running on HP-UX. One of my table is
Hi,
I have 8.1.7.1 running on HP-UX. One of my table is heavily being updated
and I see blocking locks. I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away. Question I have is
can I modify it in the fly without dropping and recreating the table.