ORACLE：使用ADRCI顯示意外事件

今天在看oracle新特性的時候，使用

ADRCI顯示意外事件

非常有用：

例如：

-bash-3.00$ adrci

ADRCI: Release 11.2.0.1.0 - Production on 星期二 2月 1 10:40:02 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle"

adrci> show incident

ADR Home = /u01/oracle/diag/clients/user_oracle/host_2467386799_76:
*************************************************************************
0 rows fetched

ADR Home = /u01/oracle/diag/tnslsnr/biserver/orcl:
*************************************************************************
0 rows fetched

ADR Home = /u01/oracle/diag/tnslsnr/biserver/listener:
*************************************************************************
0 rows fetched

ADR Home = /u01/oracle/diag/rdbms/orcl/orcl:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME                             
-------------------- ----------------------------------------------------------- ----------------------------------------
37505                ORA 445                                                     2010-04-15 22:48:15.886000 +08:00      
40953                ORA 445                                                     2010-04-28 00:13:46.535000 +08:00      
47153                ORA 7445 [strlen()+24]                                      2010-05-08 16:28:20.026000 +08:00      
50274                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 12:06:20.646000 +08:00      
53475                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 12:09:58.289000 +08:00      
56676                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 12:29:27.433000 +08:00      
59877                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 13:27:31.662000 +08:00      
63078                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 13:52:08.613000 +08:00      
66279                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 14:37:02.891000 +08:00      
66280                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 14:41:01.010000 +08:00      
66281                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 15:19:23.127000 +08:00      
66282                ORA 600 [kcratr_nab_less_than_odr]                          2010-05-23 15:35:17.126000 +08:00      
85803                ORA 7445 [kkoiqb()+9520]                                    2010-06-17 09:55:12.294000 +08:00      
85555                ORA 3137 [12333]                                            2010-06-24 13:44:48.894000 +08:00      
85811                ORA 3137 [12333]                                            2010-06-24 13:46:46.499000 +08:00      
85827                ORA 3137 [12333]                                            2010-06-24 13:48:17.240000 +08:00      
85659                ORA 3137 [12333]                                            2010-06-24 14:04:39.190000 +08:00      
85579                ORA 3137 [12333]                                            2010-06-24 14:07:14.168000 +08:00      
85631                ORA 3137 [12333]                                            2010-06-24 14:46:06.141000 +08:00      
85603                ORA 3137 [12333]                                            2010-06-24 14:48:24.484000 +08:00      
85571                ORA 3137 [12333]                                            2010-06-24 14:51:23.766000 +08:00      
85550                ORA 3137 [12333]                                            2010-06-24 14:55:24.680000 +08:00      
108056               ORA 3137 [12333]                                            2010-07-30 15:27:47.304000 +08:00      
108072               ORA 3137 [12333]                                            2010-07-30 15:30:46.486000 +08:00      
107992               ORA 3137 [12333]                                            2010-07-30 15:31:43.613000 +08:00      
107993               ORA 3137 [12333]                                            2010-07-30 15:32:39.144000 +08:00      
108296               ORA 3137 [12333]                                            2010-07-30 15:34:10.806000 +08:00      
108192               ORA 3137 [12333]                                            2010-07-30 16:29:19.435000 +08:00      
108048               ORA 3137 [12333]                                            2010-07-30 16:30:31.617000 +08:00      
108049               ORA 3137 [12333]                                            2010-07-30 16:35:16.533000 +08:00      
107984               ORA 3137 [12333]                                            2010-07-30 16:38:05.426000 +08:00      
31 rows fetched

顯示了很多過去報出的ORA錯誤資訊。

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