Infor Enterprise Server Technical Reference Guide for Oracle Database Driver

Back

Forward

  • Copy URL
  • PDF
  • Print this page

Topic URL copied to clipboard

About this guide
Intended audience
Related documents
LN Database Driver Overview
LN architecture
Display tier
Application tier
Database tier
Data flow through the LN architecture
LN hardware configurations
LN Database Organization
LN data dictionary
Table naming convention
Column naming convention
Index naming convention
Data type mapping
Additional constraints
Database Driver Internal Processing
Data integrity
Referential integrity
Distributed databases
Data buffering
Database driver SQL processing
Oracle Call Interface (OCI)
SQL processing
Setting driver behavior
Driver resources
Environment variables
Server environment variables
Client environment variables
Storage parameter file
Database Security
Database security
Groups
Object security
Authentication
DBA module
Database Driver Profiling and Statistics
Profiling
Profiling example
To gather statistics
Troubleshooting
Logging database driver trace information
Logging errors
Database Driver Configuration and Tuning
Cursor management
Array interface
Query tuning
Query hint generation
SQL Query Hints
Hints based on the ORDER BY clause
Hints based on the WHERE clause
Example of index selection
Example of weight calculation
Concatenated expressions
Specifying query tuning
Locking behavior
Implicit and explicit locking
Delayed locking
Statement and lock timeouts
Database Driver Resources and Environment Variable
Summary of Oracle driver resources and environment variables
Detailed description of driver resources and environment variables
Generic driver resources
Oracle driver specific resources
Oracle maintenance program specific resource
Resources passed to the Oracle RDBMS
Storage Parameter File Format and Driver Configuration Options
File format: $BSE/lib/ora/ora_driver_param
File format: $BSE/lib/ora/ora_storage_param
Parameter file field descriptions
To Connect to Oracle
Connection parameters
Globalization support
NLS parameters
Collation and Sorting
Conversion from CHAR to VARCHAR2 strings
Difference between the CHAR and VARCHAR2 data type
Conversion from CHAR to VARCHAR
  • Links
  • Feedback
  • Support
  • © Copyright 2025. Infor. All rights reserved.
  • Open link in new tab
  • Open link in new window
  • Copy link to clipboard