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

Sometimes when we query gv$sql, we can see some details about the operation of different child cursors of the same SQL:

Selet t.instcorrecidretemt.childbirth numberretort.planetary hashworthy valuememot.lastcorrecactivetimestampt.elapsedtimestamption100000Universe decode (t.executionsre0re1ret. Executions), t.elapsedtimestamption1000000.executionsart t.sqlaccountext from gv$sql t where sql_id='xxx'

If the operation information of the same SQL varies greatly from the above query, it is necessary to check whether there is something wrong with the performance of the SQL.

Some binding variables in sql can be queried for gv$sql_bind_capture.

The fixed problem of the execution plan is also based on specific business scenarios, for example, the object data in the sql is basically unchanged, especially like some historical analysis data.

The fixed method of implementing the plan: outline, SQL Profile, and SPM. I will not elaborate here. Now I will do a demonstration for SPM.

To be continued.

Https://blog.csdn.net/yangzhawen/article/details/44017271

Http://blog.itpub.net/26736162/viewspace-2107604/

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.