an Unable to
use system rollback segment for a non system error.
When does Oracle report an ORA-1554: Out of transaction slots for a
rollback segment?
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
of transaction slots for a
rollback segment?
Thanks
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ORA-1554: Out of transaction slots
Hello Folks,
I carried out a test, whereby I had just one rollback segment online with
a
block size of 2K, and then running updates against the database thru
Sorry if I did not phrase my question correctly. I do know that for a
database with block size 2K, the number of max transaction slots is 21.
When I was running my tests, I was expecting to see an Out of transaction
slots on the 22nd session. Instead Oracle tried to use the system rollback
of list ORACLE-L
[EMAIL PROTECTED]
n cc:
kaygopal@yahSubject: RE: ORA-1554: Out of transaction
slots
correctly. I do know that for a
database with block size 2K, the number of max transaction slots is 21.
When I was running my tests, I was expecting to see an Out of transaction
slots on the 22nd session. Instead Oracle tried to use the system rollback
segment, and gave me an Unable to use system
: error freeing extent (3) of rollback segment (2). Yes,
optsize is set.
ORA-1554: Out of transaction slots in transaction tables.
I am trying to investigate why? Metalink could not give me a definite
answer, and soft closed the tar.
Thanks
Raj
is set.
ORA-1554: Out of transaction slots in transaction tables.
I am trying to investigate why? Metalink could not give me a definite
answer, and soft closed the tar.
Thanks
Raj
Anjo Kolk
anjo@oraperfTo: Multiple recipients of list
ORACLE
rollback tablespace errors were a
result of the Out of transaction slots message. Transactions were
assigned as they came in to different transaction slots in the rollback
segments. Suppose, we had 21 transaction slots in each of the 20 rollback
segments. This were utilized one by one by different
the shutdown at
00:15 AM, the alert log reported an error saying ORA-01595: error freeing
extent (8) of rollback segment (2)) ORA-01554: out of transaction slots in
transaction tables. Now, we have 20 rollback segments, 10 on each node, on
a block size of 2k. So that would mean about approximately a total
not be creating a trace file
when a rollback segment goes unavailable? Also, why was the out of
transaction slots error reported in the alert log just before the
shutdown,
when in fact, the application reported it much earlier? Have not been to
get a definite answer yet on my TAR. Any pointers
Thanks Tim for your response to this. I agree with you. For now, I have
come up with this theory :
I feel that the Unable to use system rollback tablespace errors were a
result of the Out of transaction slots message. Transactions were
assigned as they came in to different transaction slots
were a
result of the Out of transaction slots message. Transactions were
assigned as they came in to different transaction slots in the rollback
segments. Suppose, we had 21 transaction slots in each of the 20 rollback
segments. This were utilized one by one by different transactions, and
never
13 matches
Mail list logo