oracle slow query with diferent user

1 vote

2 answers

894 views

oracle oracle-12c performance tuning performance-tuning

                          I have a question with an oracle query that takes almost 20 minutes when it is executed from a schema and yet when it runs as sys users it runs in 1 second maximum ... how is this possible? ... I do not know much about tuning plsql and I find it difficult to find the cause of this tremendous delay, I would like to know if there is any tool to autotuning the queries. The sentence in question is:

    SELECT FC.ID_SER 
         FROM MIGER.FONT_COUNTER FC
         WHERE TO_CHAR(FC.ID_SER) NOT IN (SELECT 
         ID_SER FROM INAC.SERV)
         -- AND (FC.STATE 'R' OR FC.STATE  NULL)
         AND FC.T_ACT='M'

Thank you
                        

Asked by miguel ramires (169 rep)

Feb 7, 2019, 10:40 PM
Last activity: Jun 5, 2020, 01:48 PM

oracle slow query with diferent user

Related Questions