My Oracle Support Banner

How to Display Comma Separated Init.ora Value Longer than 512 Bytes (Doc ID 153076.1)

Last updated on FEBRUARY 23, 2024

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 9.0.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.



Several init.ora parameters can have a comma separated list of different values,
such as rollback_segments, control_files, and utl_file_dir.  A select value 
from v$parameter truncates this string to 512 bytes.  This can provide
incomplete information; especially, the parameter utl_file_dir is vulnerable.  

For example:

SQL> select value from v$parameter where name like 'utl%';

/tmp, /var/opt/oracle/utldir1, /var/opt/oracle/utldir2, /var/opt/oracle/utldir3,
 /var/opt/oracle/utldir4, /var/opt/oracle/utldir5, /var/opt/oracle/utldir6, /var
/opt/oracle/utldir7, /var/opt/oracle/utldir8, /var/opt/oracle/utldir9, /var/opt/
oracle/utldir0, /var/opt/oracle/utldira, /var/opt/oracle/utldirb, /var/opt/oracl
e/utldirc, /var/opt/oracle/utldird, /var/opt/oracle/utldire, /var/opt/oracle/utl
dirf, /var/opt/oracle/utldirg, /var/opt/oracle/utldirh, /var/opt/oracle/utldiri,
 /var/opt/oracle/utldirj, /var/o


 No changes


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.