Using Code to Write Setting Values for Oracle

Contents

The following code snippets for Oracle databases demonstrate how the SETTINGS_WRITE_STRING procedure sets the value of the ExpiredSessionTimeout setting to twelve hours.

To set the value of the ExpiredSessionTimout setting to twelve hours in an Oracle database:

1. Log into SQL *Plus using privuser as your user name.
2. Run the following statement:

   SQL > exec SETTINGS_WRITE_STRING ('12h','database.cleanup.Usession','ExpiredSessionTimeout');