flush sqlid shared_pool

conn / as sysdba

1)

alter system flush shared_pool;  --- not recommend during the peak hours of the prod..

or,

2)

select sql_text,address, hash_value, executions from v$sqlarea where sql_id = '&sqlid';
exec sys.dbms_shared_pool.purge('&address, &hash_value','c');

-- passing the address and hash_value from the previous query
上一篇:空间复杂度


下一篇:Rust 语言开发 ESP32C3 并在 Wokwi 电子模拟器上运行(esp-hal 非标准库、LCD1602、I2C)-Github