{"id":490,"date":"2015-02-27T10:00:45","date_gmt":"2015-02-27T02:00:45","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=490"},"modified":"2015-09-10T21:53:02","modified_gmt":"2015-09-10T13:53:02","slug":"oracle-spa","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=490","title":{"rendered":"Oracle SPA\u4ecb\u7ecd"},"content":{"rendered":"

Sql Performance Analyzer (SPA)
\n\u8fd9\u662foracle 11g\u7684\u65b0\u7279\u6027 \u53ef\u5bf9\u4e00\u90e8\u5206sql\u7ed3\u679c\u8fdb\u884c\u6027\u80fd\u5206\u6790 \u9002\u7528\u4e8e\u6570\u636e\u5347\u7ea7 \u8fc1\u79fb\u505a\u524d\u540e\u7684\u6bd4\u8f83
\n\u5206\u6790\u7684\u7ed3\u679c\u4f1a\u6c38\u8fdc\u5b58\u5728\u7684\u6570\u636e\u5e93\u5185\u90e8\u3002\u548c\u6570\u636e\u5e93\u91cd\u6f14\u4e0d\u540c\u7684\u662fspa\u53ea\u80fd\u5206\u6790sql\u8bed\u53e5\u4e14\u53ea\u6709\u67e5\u8be2\u8bed\u53e5
\n\u6b65\u9aa4\u5982\u4e0b\uff1a
\n1.\u5728\u751f\u4ea7\u5e93\u6355\u83b7\u5177\u4f53\u8bed\u53e5
\n2.\u628a\u6355\u83b7\u7684\u8bed\u53e5\u6253\u5305\u4f20\u8f93\u5230\u6d4b\u8bd5\u73af\u5883
\n3.\u521b\u5efaSPA\u4efb\u52a1\u5728\u6d4b\u8bd5\u73af\u5883
\n4.\u751f\u6210\u6539\u53d8\u4e4b\u524d\u7684\u6267\u884c\u4fe1\u606f
\n5.\u505a\u6539\u53d8\uff08\u5347\u7ea7\u6216\u8005\u6253\u8865\u4e01\u6216\u8005\u6539\u53c2\u6570\u6216\u8005\u7b49\u7b49\u3002\u3002\uff09
\n6.\u751f\u6210\u6539\u53d8\u4e4b\u540e\u7684\u6267\u884c\u4fe1\u606f
\n7.\u5bf9\u4e8e\u4e24\u4efd\u4fe1\u606f\uff08\u53ef\u751f\u6210\u62a5\u544a\u6587\u4ef6\uff09<\/p>\n

CREATE USER ucjmh IDENTIFIED BY ucjmh;
\nGRANT DBA TO ucjmh;
\nconn ucjmh\/ucjmh \u2013\u521b\u5efa\u4e00\u4e2a\u7528\u6237
\n\u2013\u5efa\u51e0\u5f20\u8868
\nCREATE TABLE uc_objects AS SELECT * FROM dba_objects;
\nCREATE TABLE uc_tables AS SELECT * FROM dba_tables;
\nCREATE TABLE uc_users AS SELECT * FROM dba_users;
\n\u2013\u505a\u4e00\u4e9b\u67e5\u8be2
\nselect \/*UCJMH*\/ * from uc_objects;
\nselect \/*UCJMH*\/ * from uc_tables;
\nselect \/*UCJMH*\/ * from uc_users;
\n\u2013\u751f\u6210\u4e00\u4e2asqlset
\nbegin
\nsys.dbms_sqltune.create_sqlset(
\nsqlset_name => \u2018uc_sts\u2019,
\nsqlset_owner => \u2018UCJMH\u2019);
\nend;
\n\/<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u2013\u67e5\u770b\u4e00\u4e0b\u662f\u5426\u751f\u6210\u6210\u529f
\nSQL> select name from user_sqlset;<\/p>\n

NAME
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014
\nuc_sts<\/p>\n

\u2013\u628a\u9700\u8981\u7684sql\u653e\u5230\u8fd9\u4e2asqlset\u91cc
\ndeclare
\nstscur dbms_sqltune.sqlset_cursor;
\nbegin
\nopen stscur for
\nselect value(P) from table(
\ndbms_sqltune.select_cursor_cache(
\n\u2018sql_text like \u201dselect \/*UCJMH*\/%\u201d\u2019,
\nnull,null,null,null,null,null,\u2019ALL\u2019)) P;
\ndbms_sqltune.load_sqlset(
\nsqlset_name =>\u2019uc_sts\u2019, \u2013\u8fd9\u91cc\u662f\u533a\u5206\u5927\u5c0f\u5199\u7684 \u5982\u679c\u4f60\u4e0a\u9762\u5199\u7684\u5c0f\u5199 \u4e0d\u8981\u60f3\u5f53\u7136\u8ba4\u4e3aORACLE\u4f1a\u5185\u90e8\u8f6c\u6362\u6210\u5927\u5199
\npopulate_cursor => stscur,
\nsqlset_owner =>\u2019UCJMH\u2019);
\nend;<\/p>\n

PL\/SQL procedure successfully completed<\/p>\n

SQL> select sql_text from user_sqlset_statements where sqlset_name=\u2019uc_sts’;<\/p>\n

SQL_TEXT
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nselect \/*UCJMH*\/ * from uc_objects
\nselect \/*UCJMH*\/ * from uc_users
\nselect \/*UCJMH*\/ * from uc_tables<\/p>\n

\u2013\u6216\u8005
\nSQL> select sql_Text from table(dbms_sqltune.select_sqlset(\u2018uc_sts\u2019));<\/p>\n

SQL_TEXT
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nselect \/*UCJMH*\/ * from uc_objects
\nselect \/*UCJMH*\/ * from uc_users
\nselect \/*UCJMH*\/ * from uc_tables<\/p>\n

\u521b\u5efa\u6682\u5b58\u8868\u4fdd\u5b58STS\uff1a
\nexec DBMS_SQLTUNE.CREATE_STGTAB_SQLSET(\u2018UC_STS_TAB\u2019,\u2019UCJMH\u2019);<\/p>\n

SQL> select count(*) from uc_sts_tab;<\/p>\n

COUNT(*)
\n\u2014\u2014\u2014-
\n0
\n\u2013\u4e0a\u9762\u7684\u6b65\u9aa4\u53ea\u662f\u521b\u5efa\u4e86\u4e00\u4e2a\u7528\u6765\u6682\u5b58set\u7684\u8868 \u4f46\u662f\u5e76\u6ca1\u6709\u771f\u7684\u5df2\u7ecf\u628asql\u653e\u8fdb\u53bb
\n\u2013\u628aSTS\u52a0\u8f7d\u5230\u6682\u5b58\u8868\u91cc\uff1a
\nexec DBMS_SQLTUNE.PACK_STGTAB_SQLSET(\u2018uc_sts\u2019,\u2019UCJMH\u2019,\u2019UC_STS_TAB\u2019,\u2019UCJMH\u2019);<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

SQL> select count(*) from uc_sts_tab;<\/p>\n

COUNT(*)
\n\u2014\u2014\u2014-
\n6<\/p>\n

\u2013\u4e0d\u662f\u5e94\u8be5\u662f3\u6761sql\u5417 \u95ee\u4ec0\u4e48\u662f6\u884c\u8bb0\u5f55\u5462\uff1f\u4ed4\u7ec6\u770b\u770b\u53ef\u4ee5\u53d1\u73b0\u6bcf\u4e2asql_id\u5360\u4e24\u884c \u4e00\u884c\u662fsql \u4e00\u884c\u662f\u7edf\u8ba1\u4fe1\u606f\u548c\u6267\u884c\u8bb0\u5212\u7b49\u4fe1\u606f<\/p>\n

\u628a\u6682\u5b58\u8868\u5bfc\u51fa\u751f\u4ea7\u73af\u5883 \u5bfc\u5165\u6d4b\u8bd5\u73af\u5883\uff08\u6211\u8fd9\u91cc\u6d4b\u8bd5\u73af\u5883\u6ca1\u6709\u4e1c\u897f \u6211\u76f4\u63a5\u628a\u6574\u4e2a\u7528\u6237\u5bfc\u8fc7\u53bb \u5982\u679c\u4f60\u4eec\u5176\u5b83\u8868\u5df2\u7ecf\u5b58\u5728\u4e86\u53ef\u4ee5\u53ea\u5bfc\u4e00\u5f20\u6682\u5b58\u8868\uff09<\/p>\n

create or replace directory dmp as \u2018\/home\/oracle\/dmp’;
\nEXIT
\nexpdp ucjmh\/ucjmh directory=dmp dumpfile=uc.dmp
\nexport ORACLE_SID=emrep
\nsqlplus \/ AS SYSDBA
\ncreate or replace directory dmp as \u2018\/home\/oracle\/dmp’;
\nEXIT
\nimpdp system\/oracle directory=dmp dumpfile=uc.dmp<\/p>\n

\u628aSTS\u4ece\u6682\u5b58\u8868\u91cc\u653e\u5165\u6570\u636e\u5b57\u5178\u91cc\uff1a
\nexec DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET(\u2018uc_sts\u2019,\u2019UCJMH\u2019,TRUE,\u2019UC_STS_TAB\u2019,\u2019UCJMH\u2019); \u2013true\u8868\u793a\u5982\u679c\u6709\u7684\u8bdd\u662f\u5426\u66ff\u6362<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u2013\u521b\u5efa\u4e00\u4e2aspa\u4efb\u52a1
\nSQL> var tname varchar2(20);
\nSQL> exec :tname:= dbms_sqlpa.create_analysis_task(sqlset_name => \u2018uc_sts\u2019, task_name => \u2018MYSPA\u2019);<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u2013\u6267\u884c\u4efb\u52a1\u4ece\u800c\u6784\u5efabefore change data
\nSQL> exec dbms_sqlpa.execute_analysis_task(task_name => :tname, execution_type => \u2018TEST EXECUTE\u2019, execution_name => \u2018before\u2019);<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u2013\u751f\u6210before change\u7684\u62a5\u8868
\nSQL> set long 99999
\nSQL> SELECT dbms_sqlpa.report_analysis_task(task_name => :tname, type=>\u2019text\u2019, section=>\u2019summary\u2019) FROM dual;<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nGENERAL INFORMATION SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nTuning Task Name : MYSPA
\nTuning Task Owner : UCJMH
\nWorkload Type : SQL Tuning Set
\nExecution Count : 1
\nCurrent Execution : before
\nExecution Type : TEST EXECUTE
\nScope : COMPREHENSIVE
\nCompletion Status : COMPLETED
\nStarted at : 11\/01\/2014 19:27:01<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nCompleted at : 11\/01\/2014 19:27:01
\nSQL Tuning Set (STS) Name : uc_sts
\nSQL Tuning Set Owner : UCJMH
\nNumber of Statements in the STS : 3
\nNumber of SQLs Analyzed : 3
\nNumber of SQLs in the Report : 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSUMMARY SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSQL Statements Ordered by Elapsed Time<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nParse Elapsed CPU Buffer Optimizer
\nobject ID SQL ID Time (s) Time (s) Time (s) Gets Cost
\n\u2014\u2014\u2014- \u2014\u2014\u2014\u2014- \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2014
\n3 5d0v1n7gt8j2y .014787 .016058 .015664 1013 284
\n5 g9shuu1cxbqqz .006716 .001369 .001333 76 23
\n4 71tf6tnk513p5 .002394 .000084 .000111 3 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<\/p>\n

\u2013\u505a\u4f60\u8981\u505a\u7684\u53d8\u5316\uff0c\u6bd4\u5982\u4fee\u6539\u53c2\u6570\u3001\u5347\u7ea7\u786c\u4ef6\u3001\u5347\u7ea7\u64cd\u4f5c\u7cfb\u7edf\u7b49\u7b49\u3002
\nSQL> exec dbms_stats.gather_schema_stats(USER);<\/p>\n

PL\/SQL procedure successfully completed.
\n\u6784\u5efaafter change data
\nSQL> EXEC dbms_sqlpa.execute_analysis_task(task_name => :tname, execution_type => \u2018TEST EXECUTE\u2019, execution_name => \u2018after\u2019);<\/p>\n

PL\/SQL procedure successfully completed.<\/p>\n

\u751f\u6210after change\u7684\u62a5\u8868
\nSQL> SELECT dbms_sqlpa.report_analysis_task(task_name => :tname,type=>\u2019text\u2019, section=>\u2019summary\u2019) FROM dual;<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nGENERAL INFORMATION SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nTuning Task Name : MYSPA
\nTuning Task Owner : UCJMH
\nWorkload Type : SQL Tuning Set
\nExecution Count : 2
\nCurrent Execution : after
\nExecution Type : TEST EXECUTE
\nScope : COMPREHENSIVE
\nCompletion Status : COMPLETED
\nStarted at : 11\/01\/2014 19:30:29<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nCompleted at : 11\/01\/2014 19:30:29
\nSQL Tuning Set (STS) Name : uc_sts
\nSQL Tuning Set Owner : UCJMH
\nNumber of Statements in the STS : 3
\nNumber of SQLs Analyzed : 3
\nNumber of SQLs in the Report : 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSUMMARY SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSQL Statements Ordered by Elapsed Time<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nParse Elapsed CPU Buffer Optimizer
\nobject ID SQL ID Time (s) Time (s) Time (s) Gets Cost
\n\u2014\u2014\u2014- \u2014\u2014\u2014\u2014- \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2014
\n7 5d0v1n7gt8j2y .000147 .017201 .016886 1012 284
\n9 g9shuu1cxbqqz .000244 .001269 .001444 75 23
\n8 71tf6tnk513p5 .000423 .000064 0 2 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<\/p>\n

\u2013\u6bd4\u8f83before\u548cafter
\nEXEC dbms_sqlpa.execute_analysis_task(task_name => :tname, execution_type => \u2018COMPARE PERFORMANCE\u2019);<\/p>\n

\u2013\u751f\u6210\u5206\u6790\u62a5\u8868
\nSQL> SELECT dbms_sqlpa.report_analysis_task(task_name => :tname, type=>\u2019text\u2019, section=>\u2019summary\u2019) FROM dual;<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nGENERAL INFORMATION SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nTuning Task Name : MYSPA
\nTuning Task Owner : UCJMH
\nWorkload Type : SQL Tuning Set
\nExecution Count : 2
\nCurrent Execution : after
\nExecution Type : TEST EXECUTE
\nScope : COMPREHENSIVE
\nCompletion Status : COMPLETED
\nStarted at : 11\/01\/2014 19:30:29<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\nCompleted at : 11\/01\/2014 19:30:29
\nSQL Tuning Set (STS) Name : uc_sts
\nSQL Tuning Set Owner : UCJMH
\nNumber of Statements in the STS : 3
\nNumber of SQLs Analyzed : 3
\nNumber of SQLs in the Report : 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSUMMARY SECTION
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nSQL Statements Ordered by Elapsed Time<\/p>\n

DBMS_SQLPA.REPORT_ANALYSIS_TASK(TASK_NAME=>:TNAME,TYPE=>\u2019TEXT\u2019,SECTION=>\u2019SUMMARY\u2019
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2013
\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-
\nParse Elapsed CPU Buffer Optimizer
\nobject ID SQL ID Time (s) Time (s) Time (s) Gets Cost
\n\u2014\u2014\u2014- \u2014\u2014\u2014\u2014- \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2013 \u2014\u2014\u2014
\n7 5d0v1n7gt8j2y .000147 .017201 .016886 1012 284
\n9 g9shuu1cxbqqz .000244 .001269 .001444 75 23
\n8 71tf6tnk513p5 .000423 .000064 0 2 3<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-<\/p>\n

\u5220\u9664\u4efb\u52a1\uff1a
\nselect * from DBA_SQLSET_REFERENCES where SQLSET_NAME=\u2019uc_sts’;
\nexec dbms_sqltune.drop_tuning_task(\u2018MYSPA\u2019);<\/p>\n

\u5220\u9664\u6682\u5b58\u8868\u548cSTS\uff1a
\ndrop table hr.hsj_sts_tab purge;
\nexec dbms_sqltune.drop_sqlset(\u2018uc_sts\u2019);<\/p>\n","protected":false},"excerpt":{"rendered":"

Sql Performance Analyzer (SPA) \u8fd9\u662foracle 11g\u7684\u65b0\u7279\u6027 \u53ef\u5bf9\u4e00\u90e8\u5206sq […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34,8],"class_list":["post-490","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-performance"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=490"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/490\/revisions"}],"predecessor-version":[{"id":1006,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/490\/revisions\/1006"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=490"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}