Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

EXPDP Freezes

Helio GeminianoFeb 26 2024 — edited Feb 27 2024

Hi, Gurus!

Using Oracle 19c, the EXPDP program periodically freezes at the beginning of execution. I found the command below being executed by EXPDP and being blocked by another session. Note that it is a SELECT without FOR UPDATE.

SELECT COUNT(*) FROM sys.v_$open_cursor WHERE sid = SYS_CONTEXT('USERENV', 'SID') AND cursor_type = 'OPEN_PLSQL'

Could someone explain to me how a SELECT without FOR UPDATE can get blocked?

Update: I just discovered that the command below, executed alone, is also blocked.

SELECT COUNT(*) FROM sys.v_$open_cursor;

Comments
Post Details
Added on Feb 26 2024
0 comments
59 views