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?
Could be that your Oracle version is not patched enough, you might be hitting some Oracle bug.
what version you are running and how many patches you have applied .. all these details shall help us help you
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.