Using Code to Write Setting Values with Oracle or Oracle Autonomous Database

The following code snippets demonstrate how the SETTINGS_WRITE_STRING procedure sets the value of the ExpiredSessionTimeout setting to 12 hours.

To set the value of the ExpiredSessionTimeout setting to 12 hours:

Log in to SQL*Plus with your privuser credentials.
Run the following statement:
SQL > exec SETTINGS_WRITE_STRING ('12h','database.cleanup.Usession','ExpiredSessionTimeout');