When the statement is compiled, its access plan is stored in the package cache.
在编译语句时,语句的访问计划被存储在包缓存中。
If the same INSERT statement is executed repeatedly, its access plan will (usually) be found in the package cache and the compilation cost is avoided.
如果重复地执行相同的insert语句,则该语句的访问计划(通常)会进入到包缓存中,这样就免除了编译的开销。
It can also capture queries from SQL cache and produce the explain plan.
它还可以从SQL缓存捕获查询并生成解释计划。
应用推荐