Slow Query with ROWNUM
From: Amit Saroha <eramitsaroha_at_gmail.com>
Date: Wed, 18 Oct 2023 11:43:32 -0400
Message-ID: <CAG67e6R8y-7Est5iewhmZEU4f4EPhMfft8uCR4-L4nMAOh=erQ_at_mail.gmail.com>
Hi All,
Date: Wed, 18 Oct 2023 11:43:32 -0400
Message-ID: <CAG67e6R8y-7Est5iewhmZEU4f4EPhMfft8uCR4-L4nMAOh=erQ_at_mail.gmail.com>
Hi All,
I want to shorten the response time to my little query, which typically takes 10 minutes, to only one minute.
I kindly ask you to have a look and provide your insightful input in order to decrease the questioning time.
Let me know if you need more information apart from the SQL monitoring report.
Best Regards,
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 18 2023 - 17:43:32 CEST
- text/html attachment: sqlm_5jg8frgfkg4fr.html