ALTER SYSTEM DISCONNECT SESSION Clause
Use the DISCONNECT SESSION clause to disconnect the current session by destroying
the dedicated server process (or virtual circuit if the connection was made by way of a
Shared Sever). To use this clause, your instance must have the database open. You
must identify the session with both of the following values from the V$SESSION view:
■ For integer1, specify the value of the SID column.
■ For integer2, specify the value of the SERIAL# column.
If system parameters are appropriately configured, then application failover will take
effect.
■ The POST_TRANSACTION setting allows ongoing transactions to complete before
the session is disconnected. If the session has no ongoing transactions, then this
clause has the same effect described for as KILL SESSION.
■ The IMMEDIATE setting disconnects the session and recovers the entire session
state immediately, without waiting for ongoing transactions to complete.
– If you also specify POST_TRANSACTION and the session has ongoing
transactions, then the IMMEDIATE keyword is ignored.
– If you do not specify POST_TRANSACTION, or you specify POST_
TRANSACTION but the session has no ongoing transactions, then this clause
has the same effect as described for KILL SESSION IMMEDIATE.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-1001974/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20180918]disconnect session和kill session的區別.txtSession
- alter tablespace ts_name autoextend_clause
- ALTER SYSTEM FLUSH BUFFER_POOL
- 2.7.6.2.1 ALTER SYSTEM SET語句中的SCOPE子句
- alter system set event和set events的區別
- [20231023]備庫與alter system flush buffer_cache.txt
- alter system set ... scope=... 中的scope的含義是什麼？
- ORACLE之手動註冊監聽listener。alter system set local_listener="XXX"Oracle
- Oracle Model ClauseOracle
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated cExpressAI
- DML_The OUTPUT Clause
- Oracle SQL Model ClauseOracleSQL
- [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains 的問題 MySQLExpressAIMySql
- kinect2.0 Self-Learning (1) - recycling disconnect (solved)
- SQL__ALTERSQL
- MySQL ALTER命令MySql
- mysql加快alter操作MySql
- 4.3.2.2.1 The SEED FILE_NAME_CONVERT Clause
- Oracle不同版本檢視資料庫session/system級別設定了哪些eventsOracle資料庫Session
- alter database disable thread 2Databasethread
- mysql的ALTER TABLE命令MySql
- alter table set unused column
- Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggreExpressAI
- list is not in GROUP BY clause and contains nonaggre的問題AI
- mysql主給備賦予許可權時報錯，MySQL [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clauseMySqlExpress
- alter table move與shrink space
- alter table nologging /*+APPEND PARALLEL(n)*/APPParallel
- alter table drop unused columns checkpoint
- 如何獲取 alter 裡面的字串？字串
- 開心檔之MySQL ALTER命令MySql
- You can‘t specify target table ‘Person‘ for update in FROM clause
- System
- session和v$session說明Session
- laravel session 與 php session配置LaravelSessionPHP
- ALTER TABLE修改列的不同方法
- MySQL-ALTER TABLE命令學習[20180503]MySql
- mysql alter modify 和 change的區別MySql
- MySQL 資料庫 ALTER命令講解MySql資料庫
- MySQL alter 新增列對dml影響MySql