Oracle SPM（SQL Performance Management）是一種用于監控和管理SQL性能的工具，可幫助識別和解決性能問題。以下是利用Oracle SPM進行SQL性能監控的步驟：
ALTER SYSTEM SET CONTROL_MANAGEMENT_PACK_ACCESS = ‘DIAGNOSTIC+TUNING’ SCOPE = BOTH;
BEGIN DBMS_SPM.CREATE_SQL_PLAN_BASELINE(sql_handle => ‘SQL_HANDLE’, plan_name => ‘PLAN_NAME’, fixed => ‘YES’); END;
BEGIN DBMS_SPM.LOAD_PLAN_FROM_CURSOR_CACHE(sql_id => ‘SQL_ID’); END;
BEGIN DBMS_SPM.SPM_EVOLVE_SQL_PLAN_BASELINE(sql_handle => ‘SQL_HANDLE’, time_limit => 60, verify => ‘YES’); END;
通過以上步驟，您可以利用Oracle SPM進行SQL性能監控，幫助識別和解決SQL性能問題，提高數據庫性能和可靠性。
