query taking a long time
- From: "ahmed.fikri@xxxxxxxxxxx" <ahmed.fikri@xxxxxxxxxxx>
- To: "list, oracle" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Nov 2020 18:50:32 +0100 (CET)
Hi all,
following sql takes a long time to be executed. I have seen that the query
was the whole time on CPU.
I checked one execute plan and I found a lot of NLs and the E-Rows is much
less than the A-Rows.
I gathered the data dictionary and fixed objects statistics but it doesn't
help. We are using 12.1.0.2
any Idea?
Best regards
Ahmed
- Follow-Ups:
- RE: query taking a long time
- From: Mark W. Farnham
- Re: query taking a long time
- From: Mladen Gogala
- RE: query taking a long time
Other related posts:
- » query taking a long time - ahmed.fikri@xxxxxxxxxxx
- » RE: query taking a long time- Mark W. Farnham
- » Re: query taking a long time- Mladen Gogala
- » Re: query taking a long time- Mladen Gogala
