Using Code to Write Setting Values for Oracle

Previous TopicNext TopicContents

The following code snippets for Oracle Database 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');

Related Topics

Writing Setting Values

Using Code to Write Setting Values for Microsoft SQL Server



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library