ADRCI command Ouput is not fully displayed XX rows fetched (*** more available ***)
Mostly i use ADRCI prompt whenever any one of our databases gives ORA-600 or ORA-7445 for which we knock ORACLE SUPPORT and they need ips pack zip file.
So when i gave show incident command, Only First 50 rows were shown and other rows are not shown. Below is the command to view full list of incidents
**************************************** Step By Step Procedure ******************************************************
#########################################
# 1) Show Incident
#########################################
show incident
ADR Home = /u01/app/oracle/diag/rdbms/oralin/oralin:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
259193 ORA 600 [15764] 2014-03-23 12:11:05.350000 +00:00
...
...
257131 ORA 4030 2014-03-30 10:08:20.329000 +00:00
258929 ORA 4030 2014-03-30 10:08:20.331000 +00:00
256675 ORA 4030 2014-03-30 10:08:20.331000 +00:00
First 50 rows fetched (*** more available ***)
adrci>
=====================================================================================================================
Looks like there are more number of incidents Available and 1st 50 rows are only shown
=====================================================================================================================
#########################################
# 2) List All Incidents
#########################################
show incident -all
adrci> show incident -all
ADR Home = /u01/app/oracle/diag/rdbms/oralin/oralin:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
259193 ORA 600 [15764] 2014-03-23 12:11:05.350000 +00:00
261017 ORA 600 [15764] 2014-03-24 02:02:33.078000 +00:00
....
257206 ORA 7445 [__intel_ssse3_rep_memcpy] 2014-04-10 19:47:51.146000 +00:00
256953 ORA 7445 [rworofprFastUnpackRowsets] 2014-04-10 19:48:00.127000 +00:00
257952 ORA 600 [qesmmCUpdCurSz2] 2014-05-13 20:24:57.304000 +00:00
288270 ORA 7445 [qesmmCGetStats] 2014-05-13 20:24:59.921000 +00:00
256617 ORA 600 [qesmmCUpdCurSz2] 2014-05-13 20:35:49.036000 +00:00
256618 ORA 7445 [qesmmCGetStats] 2014-05-13 20:35:51.013000 +00:00
256619 ORA 600 [17114] 2014-05-13 20:41:52.638000 +00:00
296 rows fetched
A Simple but helpful Command. In step 1 we got only 50 rows and Step 2 gives results for 296 rows.
=====================================================================================================================
Comments Are Always welcome
=====================================================================================================================
1 comment:
very helpful. Thank you
Post a Comment