Set Logsize
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Service Cloud 7.1
- Documentation
Purpose
The Set Logsize statement sets the maximum size to which the driver’s embedded database log file can grow before a Checkpoint statement is performed.
Syntax
SET LOGSIZE size
where:
- size
- specifies the maximum size in MB of the .log file. The default is 200 MB. A value of 0 means no limit is imposed on the size of the log file.
Notes
- When the log file exceeds the specified size, the Checkpoint statement closes and then reopens the database files, resetting the .log file.