Shulou(Shulou.com)06/01 Report--

Sqlplus

SQL > set numw 30

Select FORCE_MATCHING_SIGNATURE, count (1)

From v$sql

Where FORCE_MATCHING_SIGNATURE > 0

And FORCE_MATCHING_SIGNATURE! = EXACT_MATCHING_SIGNATURE

Group by FORCE_MATCHING_SIGNATURE

Having count (1) > & a

Order by 2

Find out the corresponding SQL according to FORCE_MATCHING_SIGNATURE for analysis

PLSQ on the tools---preferences---window type---SQL windows---number_fields to_char tick (avoid displaying scientific counts)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.