direct path read wait event

 

1hcr1a3uxxud3 direct path read                                                        577 gldmgr                                15357 XX_Custom_Manager_01@amdc-finsysapp-ux01 (TNS V1

which is hung for close to 4 hours

SQL> select sql_text from v$sql where sql_id='1hcr1a3uxxud3';

SQL_TEXT

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT COUNT (1) FROM XXMCK_USCHIC_AP_TXN_DTL WHERE INVOICE_NUM = :B1

Please advise what needs to be done

Best regards,

Vishal