Error Reported During Statement Execution Due to Too Few Files Opened by User and Too Many Files Flushed to Drives When Executing SQL Statements

Symptom

The number of files that can be opened by users is too small. When executing SQL statements, too many files are flushed to drives. As a result, an error is reported during statement execution.

Key Process and Cause Analysis

Multiple files need to be created when they are flushed to drives. If the number of files to be created exceeds the limit set in the system, file creation fails. Therefore, you need to modify the system limit.

Conclusion and Solution

1. Run the following statement to modify the limit:

   ulimit -SHn 1000000000

2. After the limit is modified, restart the database.