os thread startup等待事件HANG處理

n-lauren發表於2015-03-08

環境:
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

問題&解決:
SQL> select  count(*) from MV_EDR_BASE_V;

在查詢物化檢視時,發生了os thread startup等待事件,並一直HANG住.
 
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     TRUE
sga_max_size                         big integer 40G
sga_target                           big integer 0


將pre_page_sgaFALSE
alter system set pre_page_sga=FALSE scope=spfile;
restart instant;

再次執行SQL,等待消失...

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22990797/viewspace-1452075/,如需轉載,請註明出處,否則將追究法律責任。

相關文章