recurring ORA-1555 for 3hrs
Hi,
How do we troubleshoot further for ORA-1555 To fix database restart was done.
Mon Jul 18 06:10:40 2016
ORA-01555 caused by SQL statement below (SQL ID: f8x1kpvandsz0, Query Duration=29 sec, SCN: 0x06b7.261b5556):
SELECT IM.Incident_ID_URL, CRA_SM_RW.fnRelatedRecords_url(IM."NUMBER", :"SYS_B_00", :"SYS_B_01", :"SYS_B_02") AS First_20_Service_Desk_Ref, IM.Category, IM.Subcategory AS Area, IM.Incident_Type AS Sub_Area, IM.Opened, IM.Closed, IM.Status, IM.Major_Flag_YN AS "MAJOR INCIDENT?", C.Contact_Info, IM.Asgn_Group, IM.FrontLine_Owner_Group, IM.Assignee, IM.FrontLine_Owner, IM.TITLE_FORMATTED AS Title, IM.Affected_CI, IM.Affected_Service, IM.Environment AS Affected_CI_Environment, :"SYS_B_03" || IM.Priority || :"SYS_B_04" AS Priority, IM.RTC AS Response_Target, ACT.Age_Min, :"SYS_B_05" || ACT.Age_DD_HH_MM || :"SYS_B_06" AS Age, CRA_SM_RW.FNIMRELATEDGROUPS(IM."NUMBER",:"SYS_B_07",:"SYS_B_08",:"SYS_B_09",:"SYS_B_10") AS First_20_touched_groups, IM.Description_Cut AS Description, IM.Location AS CI_Location, IM.User_Impact FROM CRA_SM_RW.VWINCIDENTM IM, CRA_SM_RW.VWCONTACTSM C, cra_sm_rw.VWIMACTIVITYRECORDS ACT WHERE IM.contact_id = C.contact_id(+) AND IM."NUMBER" = ACT."NUMBER"