B
B
batalish2021-03-04 06:54:38
Oracle
batalish, 2021-03-04 06:54:38

How to compile a package that is blocked by other sessions?

Good afternoon everyone! There is a package that is pulled by another system and when you try to roll changes, pl/sql throws a timeout.
During rollover, the number of schema sessions that this package uses grows. Tell me, how can I update the package without blocking?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2021-03-04
@idShura

There is only one option, kill sessions that interfere and compile the package.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question