{"id":25,"date":"2013-12-27T17:00:14","date_gmt":"2013-12-27T09:00:14","guid":{"rendered":"http:\/\/www.royalwzy.com\/?page_id=25"},"modified":"2016-02-02T15:58:06","modified_gmt":"2016-02-02T07:58:06","slug":"performance","status":"publish","type":"page","link":"http:\/\/www.royalwzy.com\/?page_id=25","title":{"rendered":"Performance"},"content":{"rendered":"

SQL Tuning01-Introduction to SQL Tuning<\/a>
\nSQL Tuning02-Intorduction to the CBO Optimizer<\/a>
\nSQL Tuning03-Optimizer operators<\/a>
\nSQL Tuning04-Interpreting Execution Plans<\/a><\/p>\n

Performance Tuning Tool01-Statspack<\/a>
\nPerformance Tuning Tool02-AWR<\/a>
\nPerformance Tuning Tool03-Sql Tuning Advisor<\/a>
\nPerformance Tuning Tool04-Sql Access Advisor<\/a>
\nPerformance Tuning Tool05-Resource Manager<\/a>
\n
\nPerformance Tuning Tool06-Database Scheduler<\/a>
\nPerformance Tuning Tool07-OUTLINE<\/a>
\nPerformance Tuning Tool08-SQLT Diagnostic Tool<\/a>
\nPerformance Tuning Tool09-SQL Profiles<\/a><\/p>\n

\u8c03\u4f18\u5b9e\u8df501–Oracle\u5e38\u89c1\u7684\u7b49\u5f85\u4e8b\u4ef6\u53ca\u89e3\u51b3\u65b9\u6848<\/a>
\n\u8c03\u4f18\u5b9e\u8df502–ALTER SYSTEM\/SESSION SET EVENTS\u8f6c\u50a8<\/a>
\n\u8c03\u4f18\u5b9e\u8df503–\u4f7f\u7528SQL_TRACE\u548c10046\u4e8b\u4ef6\u8ddf\u8e2aSQL\u7684\u6267\u884c<\/a>
\n\u8c03\u4f18\u5b9e\u8df504–\u5229\u7528FORCE_MATCHING_SIGNATURE\u6355\u83b7\u975e\u7ed1\u5b9a\u53d8\u91cfSQL\u8bed\u53e5<\/a><\/p>\n

Bitmap\u6df1\u5165\u7814\u7a76(\u4e00)<\/a>
\n\u7531\u4e8ebitmap\u9020\u6210\u7684insert\u76f8\u4e92\u963b\u585e<\/a>
\nOracle SPA\u4ecb\u7ecd<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

SQL Tuning01-Introduction to SQL Tuning SQL Tuning02-In […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":21,"menu_order":30,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-25","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"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=25"}],"version-history":[{"count":2,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/25\/revisions"}],"predecessor-version":[{"id":1210,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/25\/revisions\/1210"}],"up":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/pages\/21"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}