"alter system kill session" can crash the instance if IO slaves used
9207下,如果BACKUP_TAPE_IO_SLAVES設定為TRUE,想使用LARGE POOL優化備份的話, 用ALTER SYSTEM KILL SESSION 殺RMAN程式不安全。
The content was last updated on: 08-AUG-2005
Click here for details of each of the sections below.
Bug 3996802 "alter system kill session" can crash the instance if IO slaves used
This note gives a brief overview of bug 3996802.The content was last updated on: 08-AUG-2005
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions < 10.2 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
Symptoms: | Related To: |
|
Description
It is possible for "alter system kill session" to cause corruption
in IO slave state objects. If this occurs then the following symptoms
can occur:
- Dump in [ksfvidel]
- Dump in other ksfv* routines
- PMON crashign the instance with ORA-600[1115] cleaning up a state object
from the IO slave. (State Object of type "KSFV Adapator State").
Workaround:
Do not use "alter system kill session" when IO slaves are used.
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice. |
References
Bug:3996802 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8242091/viewspace-691946/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql批次kill sessionMySqlSession
- 無腦批量kill sessionSession
- ALTER SYSTEM FLUSH BUFFER_POOL
- [20180918]disconnect session和kill session的區別.txtSession
- 2.7.6.2.1 ALTER SYSTEM SET語句中的SCOPE子句
- alter system set event和set events的區別
- System.IO.Pipelines: .NET高效能IO
- [20231023]備庫與alter system flush buffer_cache.txt
- OB運維 | 連線 kill 中的 session_id運維Session
- alter system set ... scope=... 中的scope的含義是什麼?
- ld: -pie can only be used when targeting iOS 4.2 or later clang: error: linker command failed with eiOSErrorAI
- ORACLE之手動註冊監聽listener。alter system set local_listener="XXX"Oracle
- 使用System.IO.File.Create()時注意的問題
- 【TUNE_ORACLE】等待事件之IO等待“read by other session”Oracle事件Session
- .net 6 C#中System.IO.Path類的用法C#
- Caused by: org.apache.parquet.io.ParquetDecodingException: Can‘t read value in column [result, labelApacheException
- vertx instance
- GPU InstanceGPU
- SQL__ALTERSQL
- MySQL ALTER命令MySql
- Oracle Least Recently Used ChainsOracleASTAI
- [Bash] Kill command
- mysql加快alter操作MySql
- [java IO流]之 鍵盤顯示器輸入輸出流(System)Java
- Standard Functions Used in SAP Retail with ArticlesFunctionAI
- 【linux】kill命令模板Linux
- 3.2.1 Mounting a Database to an InstanceDatabase
- 3.1.5.6 Forcing an Instance to Start
- Oracle不同版本檢視資料庫session/system級別設定了哪些eventsOracle資料庫Session
- alter database disable thread 2Databasethread
- mysql的ALTER TABLE命令MySql
- alter table set unused column
- Bug 27223075 - Wait for 'PX Deq: Join Ack' when no active QC but PPA* slaves shoAI
- 教育授權certificate used to sign the license
- crash日誌分析
- Crash日誌解析
- 解析 crash log(一)
- Android Native Crash 收集Android
- sqlserver kill long time lockSQLServer