記一次ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
環境：
ORACLE 10.2.0.4 64BIT
REDHAT 5.4 64BIT
WAR:
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:44:20 2011
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
ALTER SYSTEM SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:44:30 2011
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:45:28 2011
今天在資料庫巡檢的時候發現alter檔案裡輸出了許多類似於以下的資訊：
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:44:20 2011
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
ALTER SYSTEM SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:44:30 2011
ALTER SESSION SET hash_join_enabled specifies an obsolete parameter
Thu Jun 30 15:45:28 2011
根據字面的意思是有的回話執行了：
alter session set hash_join_enabled=true/false;之類的語句，又因為
hash_join_enabled引數是oracle10已經廢棄的引數，所以資料庫就在alter檔案裡輸出了相關的資訊！
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10130206/viewspace-1051807/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- alter session setSession
- ALTER SESSION SET EVENTSSession
- alter session|system set eventsSession
- alter session set events /Oracle跟蹤SessionOracle
- alter session set events 'immediate trace name controlf level 8'Session
- alter session set events語句dump 控制檔案頭資訊示例Session
- [20120103] alter session set statistics_level = all;Session
- alter session set events語句dump REDO日誌檔案頭資訊示例Session
- AUTHID DEFINER\authid current_user與alter session set current_schemaSession
- alter system kill sessionSession
- alter database和alter system和alter session的區別DatabaseSession
- 轉儲控制檔案時遇到的知識點：所有alter session set eventSession
- alter system set event和set events的區別
- oracle10g_alter session set events 'immediate trace name controlf level 8'dumpOracleSession
- 使用DBMS_UTILITY.get_parameter_value檢視session的parameterSession
- ALTER SESSION ADVISE ClauseSession
- ALTER SYSTEM DISCONNECT SESSION ClauseSession
- 使用alter session set current_schema=scott用explain plan for檢視scott使用者的sqlSessionAISQL
- alter system set events 相關知識
- alter system set events 知識 [final]
- alter system set events相關知識：
- alter system set events相關知識
- ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance staOracle
- ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance startedOracle
- alter system kill session 不成功Session
- Session store not set on request.Session
- Laravel - Session store not set on requestLaravelSession
- Alter system kill session and ORA-00031: session marked for killSession
- 【Oracle】alter system set events 相關知識Oracle
- ALTER SYSTEM KILL SESSION這麼沒力？(轉)Session
- v$lock之alter table drop column與alter table set unused column區別系列五
- alter system set events相關知識(轉帖2)
- alter system set events相關知識(轉帖1)
- alter system disconnect/kill session 'sid,serial#';Session
- ora-00054 , alter system kill session 'id,serial#'Session
- "alter system kill session" can crash the instance if IO slaves usedSession
- Strut2------獲取介面返回的session,application,parameterSessionAPP
- 利用DBMS_SESSION.SET_CONTEXT傳值SessionContext