Expdp invoked by a privileged user executes a query for V$OPEN_CURSOR causing slow down
(Doc ID 2548089.1)
Last updated on SEPTEMBER 24, 2021
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Datapump export invoked by a user who has a privilege role such as DBA, EXP_FULL_DATABASE, IMP_FULL_DATABASE, DATAPUMP_EXP_FULL_DATABASE and DATAPUMP_IMP_FULL_DATABASE executes queries for v$open_cursor. This causes performance degradation. SQL trace of master control (dm) and worker (dw) processes show the following sql. SELECT COUNT(*) FROM v$open_cursor WHERE sid = SYS_CONTEXT('USERENV', 'SID') AND cursor_type = 'OPEN_PLSQL'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document