V$parameter
Oracle Data Pump: Create the DATA_PUMP_DIR Directory
Apr 11, 2026 / · 5 min read · Oracle Data Pump Database Administration Oracle Backup expdp impdp Directory Object SQL all_directories dba_directories v$parameter ·Oracle Data Pump: Create the DATA_PUMP_DIR Directory Before you can run any Oracle Data Pump export (expdp) or import (impdp) job, Oracle needs to know where to write and read dump files and log files on the server. You do this by creating a directory object inside the database that points to a real folder on the …
Read MoreShow non-default parameters in the table v$parameter Show non-default parameters in the table v$parameter SQL Code 1set pages 999 lines 100 2col name format a30 3col value format a50 4select name 5, value 6from v$parameter 7where isdefault = 'FALSE' 8and value is not null 9order by name 10/ Sample Oracle Output 1no …
Read MoreShow latent parameter changes Analyzing Modified Oracle Database Parameters for Insights and Optimization Uncover configuration customizations, potential performance bottlenecks, and security considerations by examining modified initialization parameters in Oracle Database. SQL Code 1select name 2, value 3from …
Read More