PMON always report error like below
*** SESSION ID:(1.1) 2001.09.28.20.41.35.850
kssxdl: error deleting SO: c00000000ff612b0, type: 15, owner: c00000000ffa4fa8, flag:
ORA-24756: transaction does not exist
and later (after a few days)
my db's all rollback segments become full
and I have to shutdown abort
can anyone help me?
09-30-2001, 08:14 AM
Could be that your Oracle version is not patched enough, you might be hitting some Oracle bug.
09-30-2001, 04:58 PM
what version you are running and how many patches you have applied .. all these details shall help us help you
10-01-2001, 06:57 AM
Is there an OCI/procedures that manipulate lob data?
If there is, I suggest you separate the lob column into
a separate table with the key of the original table. Then
create a big rollback segment, and use the
SET TRANSACTION USE ROLLBACK SEGMENT BIG_RBS
before the manipulation of data is called.