Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19c Sql Performance Analyzer and degree of parallelism issue

solo_400Dec 3 2021

I was so happy when I found that in 19c is possible to execute an Analysis Task in parallel by using TEST_EXECUTE_DOP parameter.
Since I have a huge Sql Tuning Set, I tried to test TEST_EXECUTE_DOP=4.
When I want to check performance report I can't see all sql's.
It seems that the number of processed sql's is not the same as total sql's in my Tuning Set but total sql's Tunig Set /TEST_EXECUTE_DOP
This is what I get from the reports:
###############################
General Information
Total Sql Statement Count: 20000
###############################
Report Summary
Overall ( Sql Count) : 5000 -> instead 20000
###############################
Do you have any idea why this ?
Thanks so much.

Comments
Post Details