Trying to find out what a specific running statement is (Oracle)












0















I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:



How do you show sql executing on an oracle database



It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.



I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)



I have also executed the script referenced in this post:



How to see the actual Oracle SQL statement that is being executed



And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.










share|improve this question







New contributor




Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:



    How do you show sql executing on an oracle database



    It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.



    I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)



    I have also executed the script referenced in this post:



    How to see the actual Oracle SQL statement that is being executed



    And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.










    share|improve this question







    New contributor




    Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:



      How do you show sql executing on an oracle database



      It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.



      I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)



      I have also executed the script referenced in this post:



      How to see the actual Oracle SQL statement that is being executed



      And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.










      share|improve this question







      New contributor




      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I'm trying to look into what's running on my Oracle instance at the moemnt. I have a large INSERT statement going that's dumping data into a table, and I can see this is running when I execute the SQL script referenced in this post:



      How do you show sql executing on an oracle database



      It's showing my INSERT statement fine, but it's also showing a second statement that looks like a trigger or a stored proc that's not reference in the insert statement "mp_manual_pay" which is an abbreviation of the table I'm inserting data into.



      I can't find this label referenced in a trigger or a stored proc, so I'm wondering what else this might be? I've search sys.all_objects and cannot see any reference to this label / name. Any ideas on where else to search to see what exactly this is? (I expect it's the cause of a rather slow insert, and I would like to temporarily disable this during the bulk insert)



      I have also executed the script referenced in this post:



      How to see the actual Oracle SQL statement that is being executed



      And this certainly seems to indicate that something else is going on, but I can't for the life of me figure out where it's coming from.







      oracle






      share|improve this question







      New contributor




      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 12 mins ago









      RocksaltRocksalt

      11




      11




      New contributor




      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Rocksalt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "182"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Rocksalt is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230632%2ftrying-to-find-out-what-a-specific-running-statement-is-oracle%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Rocksalt is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Rocksalt is a new contributor. Be nice, and check out our Code of Conduct.













          Rocksalt is a new contributor. Be nice, and check out our Code of Conduct.












          Rocksalt is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Database Administrators Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230632%2ftrying-to-find-out-what-a-specific-running-statement-is-oracle%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Liste der Baudenkmale in Friedland (Mecklenburg)

          Single-Malt-Whisky

          Czorneboh