July 21, 2009 at 4:42 am
Symptom
Objects are deletable even after the ‘Objects are Modifiable’ property of SWCV is unchecked.
Other terms
‘Objects are Modifiable’ in SWCV. Delete allowed for non-modifiable SWCV.
Reason and Prerequisites
Behavior change regarding the ‘Objects are Modifiable’ property of the SWCV. When the above property is unchecked for a SWCV, we were able to delete objects under it. [...]
July 2, 2009 at 12:22 pm
Symptom
high enqueue waits after a reorganization/ change of extent size
Other terms
v$lock
ST-lock
enqueue
lock
insert, update , delete
DML
space management
coalesce free space
alter tablespace coalesce
reorganization
next extent size
Reason and Prerequisites
Performance is at a standstill, all workprocesses are occupied, oracle sessions show enqueue waits
there can be different reasons why an enqeue can cause severe performance impacts on the system. In order to [...]
June 8, 2009 at 4:48 am
Symptom
The deletion of documents using the BAPI ‘BAPI_RECORD_DELETEELEMENTS’ takes a long time when there are too many objects linked to the record and deletion of objects is done using service provider-specific identifiers.
Other terms
Performance, record, case, document, delete, BAPI BAPI_RECORD_DELETEELEMENTS, time, API, element_delete_by_poid
Reason and Prerequisites
Program Error
Solution
Kindly apply the note to get the correction.
Note that, [...]