Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do i find out which query is hanging the stored procedure?

msNov 4 2019 — edited Nov 5 2019

Hi All,

    I have a stored procedure which is running forever. The particular stored procedure reads a file and performs validation and inserts into some transaction table.

    There are many stored procedures that are called within the main procedure. There might be locks or blocks or some query is taking long time to execute

    How do i find out which query in which procedure is taking long time to execute? But sometimes the same procedures completes successfully within few seconds inserting

    all the records (10000 recs).

Thanks

Gautam S

Comments

Christopher Jones-Oracle
Answer

That log snippet had no useful information (which is sadly common for node-gyp logs).

Check standard gotchas such as having a new-enough compiler, the correct proxies, the correct values for OCI_*_DIR, using sudo -E.

Install instructions are at: https://github.com/oracle/node-oracledb/blob/master/INSTALL.md

Marked as Answer by User514049-Oracle · Sep 27 2020
User514049-Oracle

It might very well be the reason since it worked fine on Linux 7 which has the gcc with the correct level of support.  Will Visual Studio Community Edition cut it on Windows or do I need Visual Studio Profession?

I believe CE will work.  Also see https://github.com/oracle/node-oracledb/issues/483#issuecomment-242620104

1 - 3

Post Details

Added on Nov 4 2019
#performance
9 comments
3,021 views