如何给其他会话设置session级别的参数

就我所知，存在1种方法，这里抛砖引玉一下：

1. 通过 AFTER LOGON ON Trigger登录后触发器实现部分用户或程序登录即触发session级别的参数被设置，如:

CREATE OR REPLACE TRIGGER AUTO_SESSION_PARAMETER

AFTER LOGON ON MACLEAN.SCHEMA

BEGIN

execute immediate 'alter session set optimizer_mode=RULE'

END

/

Trigger created.

当有用户以MACLEAN账号登录时，会触发该Trigger在session级别设置optimizer_mode=RULE使用RBO优化器。

本文主要介绍下spring boot中对session timeout参数值的设置过程。

spring-boot-autoconfigure-1.5.8.RELEASE-sources.jar!/org/springframework/boot/autoconfigure/web/ServerProperties.java

spring-boot-1.5.8.RELEASE-sources.jar!/org/springframework/boot/context/embedded/tomcat/TomcatEmbeddedServletContainerFactory.java

可以从源码看到，如果设置小于60秒的话，则会默认取1分钟

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/core/StandardContext.java

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/session/StandardSession.java

这个是在这个方法中更新

tomcat-embed-core-8.5.23-sources.jar!/org/apache/coyote/http11/Http11Processor.java

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/connector/CoyoteAdapter.java

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/connector/Request.java

里头的方法会调用recycleSessionInfo

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/core/ApplicationDispatcher.java

tomcat-embed-core-8.5.23-sources.jar!/org/apache/catalina/core/ApplicationHttpRequest.java

---