New Database Initialization Parameters

Oracle Database 10g has introduced a large number of new initialization parameters, many of which have been covered in previous chapters. This section covers some of the interesting ones that have not yet been mentioned:

  • DDL_WAIT_FOR_LOCKS specifies whether DDL statements such as ALTER TABLE ... ADD COLUMN wait and complete instead of timing out if the statement is not able to acquire all required locks. The default value is FALSE and hence DDL statements time out if the statement cannot obtain all required locks.

  • LDAP_DIRECTORY_ACCESS specifies whether Oracle refers to the Oracle internet Directory (OiD) for user-authentication information. If directory access is turned on, then this parameter also specifies ...

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.