2 Replies Latest reply on Dec 15, 2016 12:28 PM by Marwim

    4 parallel nonparallel queries

    Marwim

      I can reproduce this behaviour in 4.1.3 and 4.2EA

       

      When I open a table and go to the "Data" tab I immediately can see 4 active sessions that seem to query this table

      /* + NO_PARALLEL */SELECT ROWID "ROWID", ... FROM MY_TABLE

      4 parallel nonparallel queries?

       

      Those sessions will not go away when I change to another tab like "Grants" they stay until I close the table.

      They don't really cause a lot of IO, I just wonder why they are marked as ACTIVE?

       

      Regards

      Marcus