Skip to Main Content

Oracle Database Discussions

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!

Range Partition Table - Partition Range Iterator with Bind Variables

Abhinav SharmaApr 14 2025

Hi,

Range Partition Table 3TB Size - Partition Range Iterator operation in execution plan which is not showing PSTART and PSTOP values as it just shows KEY in both places. How to find how many partitions it scans?

Oracle db version - 19.25.0.0.0

This post has been answered by Jonathan Lewis on Apr 15 2025
Jump to Answer
Comments
Post Details
Added on Apr 14 2025
7 comments
210 views