Wednesday, May 14, 2014

ADRCI command Ouput is not fully displayed XX rows fetched (*** more available ***)


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:

Anonymous said...

very helpful. Thank you