| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INITRANS storage parameter
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 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 recipients of list ORACLE-L
Sent: 10/26/01 2:30 AM
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, caused a problem with the tables
because locks started to build up. When we changed our initrans to 2 on
all
those tables, our locking problem went away.
-----Original Message-----
To: Multiple recipients of list ORACLE-L
Sent: 10/25/01 6:10 PM
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.
Thanks
Bing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wong, Bing
INET: bing.wong_at_IngramMicro.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 26 2001 - 11:58:01 CDT
 |
 |