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

1.cursor: pin S

(1)。 Cause of occurrence

The wait event is caused by a large number of concurrency of the same SQL

(2)。 Measures:

Decentralized mutex contention

Select / * 1cm / * from dual

Select / * 2girls / * from dual

2.cursor: pin S wait on X

(1)。 Cause of occurrence:

1. Higher hard resolution

two。 High version problem

3.Bug

(2)。 Measure

-confirm the reason for hard resolution (bind variable or share pool size)

-execute DDL statements on the objects involved in the SQL

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.