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!

Predicate information in SQL Monitor(Text) report

Rajeshwaran JeyabalApr 22 2020 — edited Apr 22 2020

The output produced by SQL Monitor report is really helpful.

current we use this dbms_sqltune.report_sql_monitor(type=>'text') - to get the Textual version of sqlmonitor report, very light weight when compared to "active" format. - How the predicate information section is missing in the Textual version, but the same is available in the "active" format

It would be very helpful, if the textual version supports the predicate information, that would help us to isolate what part of the predicates were access and filters, while we navigate through the execution plan details.

Comments
Post Details
Added on Apr 22 2020
0 comments
274 views