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 12.2.0.1 and laterOracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.
Symptoms
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'
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |