AUTONOMOUS_TRANSACTION: Pros and Cons

Question

Could an offline transaction be dangerous? If so, in what situations? When are offline transactions necessary?

Answer 1

Yes, offline transactions can be dangerous.

Consider a situation where you have a main transaction. He inserted / updated / deleted rows. If you then, as part of this, configure an autonomous transaction, then either

(1) - . "" . , ( ).

(2) , . , . .

(3). , . - , - , , , , . , - , . , , . ( ) , , , .

(4). / , . , . ( ), . , (5), , .

(5). / , , .

Answer 2

?

.

, ?

. , , , . , , - .

?

, , , . , .