{"id":1412,"date":"2024-05-08T10:31:45","date_gmt":"2024-05-08T02:31:45","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1412"},"modified":"2024-05-08T10:31:45","modified_gmt":"2024-05-08T02:31:45","slug":"spotlight-on-mysql%e6%80%a7%e8%83%bd%e7%9b%91%e6%8e%a7%e5%b7%a5%e5%85%b7","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1412","title":{"rendered":"spotlight on mysql\u6027\u80fd\u76d1\u63a7\u5de5\u5177"},"content":{"rendered":"

spotlight on mysql\u6027\u80fd\u76d1\u63a7\u5de5\u5177 <\/p>\n

2011-07-26 10:45:41| \u5206\u7c7b\uff1a mysql\u76d1\u63a7 |\u4e3e\u62a5|\u5b57\u53f7 \u8ba2\u9605
\n\u5b98\u65b9\u5730\u5740\uff1a http:\/\/www.quest.com\/downloads\/<\/a><\/p>\n

tomysql http:\/\/www.quest.com\/spotlight-on-mysql\/<\/a><\/p>\n

Quest.Central.For.Databases\u2014\u2014Spotlight\u7684\u4f7f\u7528<\/p>\n

Spotlight\u80fd\u5e2e\u52a9\u4f60\u5feb\u901f\u5730\u8bc6\u522b\u6027\u80fd\u95ee\u9898\u7684\u75c7\u72b6\uff0c\u5e76\u4e14\u5728\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u5e2e\u52a9\u4f60\u89e3\u51b3\u4e0e\u8fd9\u4e9b\u75c7\u72b6\u76f4\u63a5\u76f8\u5173\u7684\u57fa\u672c\u95ee\u9898\u3002\u5bf9\u4e8e\u6bd4\u8f83\u590d\u6742\u7684\u95ee\u9898\uff0c\u7279\u522b\u5728\u540e\u7aef\u5c42\u51fa\u73b0\u74f6\u9888\u65f6\uff0cSpotlight\u80fd\u5e2e\u52a9\u4f60\u8bc6\u522b\u51fa\u95ee\u9898\uff0c\u4ece\u800c\u4f7f\u7528\u66f4\u6df1\u5165\u7684\u5206\u6790\u5de5\u5177\u89e3\u51b3\u95ee\u9898\u3002\u901a\u8fc7Spotlight\u7684\u8b66\u544a\u7a97\u53e3\uff0c\u5f53\u51fa\u73b0\u95ee\u9898\u65f6\u4e00\u773c\u5c31\u53ef\u4ee5\u770b\u5230\u51fa\u73b0\u95ee\u9898\u7684\u5730\u65b9\u3002\u5f53\u5173\u952e\u8d44\u6e90\u4f7f\u7528\u7387\u8fbe\u5230\u4e34\u754c\u7ea7\u522b\u65f6\u901a\u77e5\u7ba1\u7406\u5458\u3002\u5411\u7ba1\u7406\u5458\u53d1\u51fa\u5f69\u8272\u8272\u6807\u8b66\u62a5\u5e76\u4e14\u7a81\u51fa\u663e\u793a\u54ea\u4e2a\u670d\u52a1\u5668\u6216\u8005\u5e94\u7528\u7ec4\u4ef6\u51fa\u73b0\u6027\u80fd\u95ee\u9898\u3002\u5b9a\u4f4d\u51fa\u95ee\u9898\u540e\uff0cSpotlight\u53ef\u63d0\u4f9b\u95ee\u9898\u7684\u4e13\u5bb6\u610f\u89c1\u548c\u89e3\u51b3\u65b9\u6848\u5efa\u8bae\u3002
\n\u3000\u3000\u4e0b\u9762\u4ee5Spotlight On Oracle\u4e3a\u4f8b\u6765\u4ecb\u7ecdSpotlight\u7684\u7528\u6cd5\uff08Spotlight on Windows\u3001Spotlight on SQL Server\u7684\u7528\u6cd5\u7c7b\u4f3c\uff09
\n\u3000\u3000\u4e00\u3001\u9996\u5148\u5efa\u7acbOracle\u7684\u8fde\u63a5
\n\u3000\u3000\u7b2c\u4e00\u6b65\u8981\u65b0\u5efaconnection,\u8fd9\u6837\u80fd\u591f\u4f7f\u7528spotlight\u8fde\u63a5\u5230\u8981\u76d1\u6d4b\u7684\u6570\u636e\u5e93\u3002
\n\u3000\u3000<\/p>\n

\u4e8c\u3001\u7cfb\u7edf\u4e3b\u754c\u9762
\n\u7cfb\u7edf\u4e3b\u754c\u9762\u53cd\u6620\u4e86\u7cfb\u7edf\u7684\u6574\u4f53\u8fd0\u884c\u60c5\u51b5\uff0c\u5982\u679c\u7cfb\u7edf\u54ea\u65b9\u9762\u51fa\u73b0\u95ee\u9898\uff0c\u4f1a\u62a5\u76f8\u5e94\u7684\u8b66\u544a\uff0c\u4e0d\u540c\u7ea7\u522b\u663e\u793a\u4e0d\u540c\u7684\u989c\u8272\uff0c\u6700\u4e25\u91cd\u4e3a\u7ea2\u8272\u8b66\u544a\u3002\u7136\u540e\u636e\u6b64\u8b66\u544a\u53ef\u4e0b\u94bb\u5230\u76f8\u5e94\u7684\u5b50\u7a97\u53e3\uff0c\u67e5\u770b\u76f8\u5e94\u60c5\u51b5\u3002\u4e0b\u9762\u4ecb\u7ecd\u5404\u5b50\u7a97\u53e3\u3002
\n\u3000\u3000
\n1.Session\u9762\u677f:
\n(1)Response<10,\u7cfb\u7edf\u7684\u54cd\u5e94\u65f6\u95f4
\n(2)Total Users:\u603b\u7528\u6237SESSION\u6570
\n(3)Active Users:\u5f53\u524d\u6b63\u5728\u6267\u884c\u7684\u7528\u6237SESSION\u6570
\n\u3000\u30002.Host\u9762\u677f:
\n(1)CPU\u5229\u7528\u7387
\n(2)\u5185\u5b58\u7684\u4f7f\u7528\u60c5\u51b5
\n\u3000\u30003. Server Processes\u9762\u677f\uff1a\u663e\u793a\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4fe1\u606f
\n(1)PGA Target\/Used\u663e\u793aPGA\u76ee\u6807\u603b\u6570\u53ca\u5f53\u524d\u4f7f\u7528\u6570
\n(2)dedicated\u663e\u793a\u4e13\u7528\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4e2a\u6570
\n(3)Shared\u663e\u793a\u5171\u4eab\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4e2a\u6570\u3002
\n(4)Dispatchers\u663e\u793adispathers\u7684\u4e2a\u6570.
\n(5)JobQueue\u663e\u793a\u4f5c\u4e1a\u8fdb\u7a0b\u7684\u4e2a\u6570
\n\u3000\u30004. SGA\u9762\u677f\uff1a\u663e\u793aSGA\u4e2d\u5404\u7ec4\u4ef6\u7684\u5185\u5b58\u4f7f\u7528\u60c5\u51b5
\n(1)CurrentSize\u663e\u793a\u5f53\u524dsga\u4f7f\u7528M\u6570
\n(2)BufferCache,KeepPool,RecyclePool\u663e\u793a\u6570\u636e\u7f13\u51b2\u533a\u7684\u5185\u5b58\u60c5\u51b5
\n(3)SharedPool:\u5171\u4eab\u6c60\u7684\u4f7f\u7528\u60c5\u51b5
\n(4)RedoLog\uff1a\u91cd\u4f5c\u65e5\u5fd7\u7684\u4f7f\u7528\u60c5\u51b5
\n(5)LargePool\uff1a\u5927\u6c60\u7684\u4f7f\u7528\u60c5\u51b5
\n(6)JavaPool\uff1ajava\u6c60\u7684\u4f7f\u7528\u60c5\u51b5
\n\u3000\u30005.Background process\u9762\u677f-\u540e\u53f0\u8fdb\u7a0b\u9762\u677f\uff1a\u663e\u793a\u4e0e\u78c1\u76d8I\/O\u76f8\u5173\u7684\u540e\u53f0\u8fdb\u7a0b\u3002
\n(1)DBWR \u6570\u636e\u5199\u5165\u8fdb\u7a0b
\n(2)LGWR \u65e5\u5fd7\u8fdb\u7a0b
\n(3)ARCH \u89c4\u6863\u8fdb\u7a0b\u5f0f
\n\u3000\u30006. \u78c1\u76d8\u5b58\u50a8\u9762\u677f\uff1a\u663e\u793a\u4e3b\u8981\u6570\u636e\u5e93\u6587\u4ef6\u7684\u60c5\u51b5\uff08\u63a7\u5236\u6587\u4ef6\u9664\u5916\uff09
\n(1\uff09DatabaseFiles:\u663e\u793a\u6570\u636e\u6587\u4ef6\u4f7f\u7528\u60c5\u51b5\u3002
\n(2\uff09\u8054\u673a\u65e5\u5fd7\u6587\u4ef6\u60c5\u51b5\u3002\u5305\u62ec\u7ec4\u6570\u53ca\u5927\u5c0f\u3002
\n(3\uff09\u5f52\u6863\u65e5\u5fd7\u60c5\u51b5\u3002
\n\u3000\u3000\u4e09\u3001TopSessions<\/p>\n

\u901a\u8fc7topSession\u9762\u677f\u53ef\u4ee5\u67e5\u770b\u5f53\u524d\u54ea\u4e2asession\u5f53\u524d\u5360\u7528\u4e86\u5927\u91cf\u7684\u8d44\u6e90\uff0c\u4ee5\u6b64\u5b9a\u4f4d\u6570\u636e\u5e93\u95ee\u9898\u3002\u5355\u51fb\u4e0a\u90e8\u5217\u8868\uff0c\u4f1a\u5728session Information\u4e2d\u663e\u793a\u8be5\u4f1a\u8bdd\u7684\u6240\u6709\u8be6\u3000\u3000\u3000\u3000\u3000\u3000\u7ec6\u4fe1\u606f\u3002 \n\u3000\u3000\n\u4e0b\u9762\u662f\u51e0\u4e2a\u5e94\u6ce8\u610f\u7684\u5730\u65b9\uff1a<\/code><\/pre>\n
\u3000\u3000most recent sql:\u53ef\u4ee5\u7528\u6765\u786e\u5b9a\u5f53\u524d\u5360\u7528\u8d44\u6e90\u6700\u5927\u7684sql\u8bed\u53e5
\n\u3000\u3000Session waits:\u53ef\u4ee5\u627e\u51fa\u4e0e\u8be5session\u76f8\u5173\u7684\u7b49\u5f85\u4e8b\u4ef6\u3002
\n\u3000\u3000
\nSession locks:\u663e\u793a\u76f8\u5173\u7684\u9501\u4fe1\u606f\u3002
\n\u3000\u3000
\n\u56db\u3001top sql:\u6839\u636e\u6761\u4ef6\u6765\u67e5\u770blibraryCache\u4e2d\u76f8\u5e94\u7684sql.
\n\u3000\u3000\u4e3b\u8981\u7684\u9009\u9879\u4e3asorting
\n\u3000\u3000\u53ef\u4ee5\u636e\u6b64\u6765\u627e\u51fa\u5f71\u54cd\u5927\u7684sql
\n\u3000\u3000
\n\u70b9\u51fbFetch SQL\u6309\u94ae\uff0c\u53ef\u4ee5\u67e5\u770b\u5230\u76f8\u5e94\u7684SQL\u8bed\u53e5
\n\u3000\u3000
\n\u4e94\u3001Activity:\u8fd9\u4e2a\u7a97\u53e3\uff0c\u4e3b\u8981\u63d0\u4f9b\u4e86\u7b49\u5f85\u4e8b\u4ef6\uff0c\u9501\u7b49\u5f85\uff0c\u95eb\u9501\u7b49\u5f85\uff0c\u5f53\u524d\u4e8b\u52a1\u7b49\u3002
\n\u3000\u3000
\n\u516d\u3001\u914d\u7f6e\u548c\u5185\u5b58\uff1a\u4e3b\u8981\u663e\u793aSGA\u7684\u4f7f\u7528\u60c5\u51b5\u53ca\u53c2\u6570\u914d\u7f6e\u60c5\u51b5
\n\u3000\u3000
\n\u4e03\u3001\u78c1\u76d8\u5b58\u50a8\u60c5\u51b5:\u663e\u793a\u8868\u7a7a\u95f4\u5229\u7528\u7387\u548c\u5728\u7ebf\u65e5\u5fd7\u7684\u4f7f\u7528\u60c5\u51b5\u3002<\/p>\n
Quest.Central.For.Databases\u4e0b\u8f7d\u5730\u5740\uff1a
\nhttp:\/\/58.251.57.206\/down?cid=1669258673&t=14&fmt=&usrinput=Quest.Central&dt=0&ps=0_0&rt=0kbs&plt=0&spd=9<\/a><\/p>\n
\u6ce8\u610f\uff1a\u8be5\u8f6f\u4ef6\u8bd5\u7528\u671f\u53ea\u67097\u5929\uff0c\u6211\u8fd9\u91cc\u6709\u6ce8\u518c\u673a\uff0c\u9700\u8981\u7684\u8bf7\u7559Email\uff0c\u5230\u65f6\u7edf\u4e00\u53d1\u9001\uff01<\/p>\n
Quest.Central.For.Databases\u7cfb\u5217\u6587\u7ae0\uff1a
\n\u3000 \u3010\u63a8\u8350\u3011[SQL\u4f18\u5316\u5de5\u5177]Quest.Central.For.Databases\u2014\u2014SQL Tuning for SQL Server
\n\u3010\u63a8\u8350\u3011Quest.Central.For.Databases\u2014\u2014Spotlight\u7684\u4f7f\u7528<\/p>\n
ToadDBASuiteforOracle_101R2.exe \u8bd5\u7528\u7248
\nhttp:\/\/worlddownloads.quest.com.edgesuite.net\/Repository\/www.quest.com\/latest_versions\/ToadDBASuiteforOracle_101R2.exe<\/a><\/p>\n
SpotlightonSQLServerEnterpriseXpertEdition_60_1.zip
\nhttp:\/\/www.quest.com\/common\/registration.aspx?requestdefid=7613&sid=d2668ad1-6c0e-4654-8dcc-8cb3add1a487<\/a><\/p>\n
QuestSQLOptimizerforSQLServer_661.exe
\nhttp:\/\/worlddownloads.quest.com.edgesuite.net\/Repository\/www.quest.com\/add_ons\/QuestSQLOptimizerforSQLServer_661.exe<\/a><\/p>\n
spotlight for windows   (\u96c6\u7fa4\u7248\u65e0\u9650\u5236, windows\u7248\u80fd\u7528\u4e24\u5e74)
\nhttp:\/\/usdownloads.quest.com.edgesuite.net\/Repository\/www.quest.com\/latest_versions\/SoW_370304.zip<\/a><\/p>\n
SpotlightonUnix_70.exe
\nhttp:\/\/worlddownloads.quest.com.edgesuite.net\/Repository\/www.quest.com\/latest_versions\/SpotlightonUnix_70.exe<\/a>
\n\u6ce8\u518c\u7801 : 1-47853-30212-46224-95327 www.serials.ws<\/p>\n
Quest Spotlight On Oracle v5.01
\nhttp:\/\/x.139.xdowns.com\/088\/Spotlight.On.Oracle.rar<\/a>
\n\u6ce8\u518c\u7801: xdowns
\n147854926224612498327<\/p>\n
\u5b98\u65b9\u4e0b\u8f7d\u5730\u5740\uff1a<\/p>\n
http:\/\/www.innovatedigital.com\/download<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
spotlight on mysql\u6027\u80fd\u76d1\u63a7\u5de5\u5177 2011-07-26 10:45:41| \u5206\u7c7b\uff1a mysql\u76d1\u63a7 |\u4e3e\u62a5|\u5b57\u53f7 \u8ba2\u9605 \u5b98\u65b9\u5730\u5740\uff1a http:\/\/www.quest.com\/downloads\/ tomysql http:\/\/www.quest.com\/spotlight-on-mysql\/ Quest.Central.For.Databases\u2014\u2014Spotlight\u7684\u4f7f\u7528 Spotlight\u80fd\u5e2e\u52a9\u4f60\u5feb\u901f\u5730\u8bc6\u522b\u6027\u80fd\u95ee\u9898\u7684\u75c7\u72b6\uff0c\u5e76\u4e14\u5728\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u5e2e\u52a9\u4f60\u89e3\u51b3\u4e0e\u8fd9\u4e9b\u75c7\u72b6\u76f4\u63a5\u76f8\u5173\u7684\u57fa\u672c\u95ee\u9898\u3002\u5bf9\u4e8e\u6bd4\u8f83\u590d\u6742\u7684\u95ee\u9898\uff0c\u7279\u522b\u5728\u540e\u7aef\u5c42\u51fa\u73b0\u74f6\u9888\u65f6\uff0cSpotlight\u80fd\u5e2e\u52a9\u4f60\u8bc6\u522b\u51fa\u95ee\u9898\uff0c\u4ece\u800c\u4f7f\u7528\u66f4\u6df1\u5165\u7684\u5206\u6790\u5de5\u5177\u89e3\u51b3\u95ee\u9898\u3002\u901a\u8fc7Spotlight\u7684\u8b66\u544a\u7a97\u53e3\uff0c\u5f53\u51fa\u73b0\u95ee\u9898\u65f6\u4e00\u773c\u5c31\u53ef\u4ee5\u770b\u5230\u51fa\u73b0\u95ee\u9898\u7684\u5730\u65b9\u3002\u5f53\u5173\u952e\u8d44\u6e90\u4f7f\u7528\u7387\u8fbe\u5230\u4e34\u754c\u7ea7\u522b\u65f6\u901a\u77e5\u7ba1\u7406\u5458\u3002\u5411\u7ba1\u7406\u5458\u53d1\u51fa\u5f69\u8272\u8272\u6807\u8b66\u62a5\u5e76\u4e14\u7a81\u51fa\u663e\u793a\u54ea\u4e2a\u670d\u52a1\u5668\u6216\u8005\u5e94\u7528\u7ec4\u4ef6\u51fa\u73b0\u6027\u80fd\u95ee\u9898\u3002\u5b9a\u4f4d\u51fa\u95ee\u9898\u540e\uff0cSpotlight\u53ef\u63d0\u4f9b\u95ee\u9898\u7684\u4e13\u5bb6\u610f\u89c1\u548c\u89e3\u51b3\u65b9\u6848\u5efa\u8bae\u3002 \u3000\u3000\u4e0b\u9762\u4ee5Spotlight On Oracle\u4e3a\u4f8b\u6765\u4ecb\u7ecdSpotlight\u7684\u7528\u6cd5\uff08Spotlight on Windows\u3001Spotlight on SQL Server\u7684\u7528\u6cd5\u7c7b\u4f3c\uff09 \u3000\u3000\u4e00\u3001\u9996\u5148\u5efa\u7acbOracle\u7684\u8fde\u63a5 \u3000\u3000\u7b2c\u4e00\u6b65\u8981\u65b0\u5efaconnection,\u8fd9\u6837\u80fd\u591f\u4f7f\u7528spotlight\u8fde\u63a5\u5230\u8981\u76d1\u6d4b\u7684\u6570\u636e\u5e93\u3002 \u3000\u3000 \u4e8c\u3001\u7cfb\u7edf\u4e3b\u754c\u9762 \u7cfb\u7edf\u4e3b\u754c\u9762\u53cd\u6620\u4e86\u7cfb\u7edf\u7684\u6574\u4f53\u8fd0\u884c\u60c5\u51b5\uff0c\u5982\u679c\u7cfb\u7edf\u54ea\u65b9\u9762\u51fa\u73b0\u95ee\u9898\uff0c\u4f1a\u62a5\u76f8\u5e94\u7684\u8b66\u544a\uff0c\u4e0d\u540c\u7ea7\u522b\u663e\u793a\u4e0d\u540c\u7684\u989c\u8272\uff0c\u6700\u4e25\u91cd\u4e3a\u7ea2\u8272\u8b66\u544a\u3002\u7136\u540e\u636e\u6b64\u8b66\u544a\u53ef\u4e0b\u94bb\u5230\u76f8\u5e94\u7684\u5b50\u7a97\u53e3\uff0c\u67e5\u770b\u76f8\u5e94\u60c5\u51b5\u3002\u4e0b\u9762\u4ecb\u7ecd\u5404\u5b50\u7a97\u53e3\u3002 \u3000\u3000 1.Session\u9762\u677f: (1)Response<10,\u7cfb\u7edf\u7684\u54cd\u5e94\u65f6\u95f4 (2)Total Users:\u603b\u7528\u6237SESSION\u6570 (3)Active Users:\u5f53\u524d\u6b63\u5728\u6267\u884c\u7684\u7528\u6237SESSION\u6570 \u3000\u30002.Host\u9762\u677f: (1)CPU\u5229\u7528\u7387 (2)\u5185\u5b58\u7684\u4f7f\u7528\u60c5\u51b5 \u3000\u30003. Server Processes\u9762\u677f\uff1a\u663e\u793a\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4fe1\u606f (1)PGA Target\/Used\u663e\u793aPGA\u76ee\u6807\u603b\u6570\u53ca\u5f53\u524d\u4f7f\u7528\u6570 (2)dedicated\u663e\u793a\u4e13\u7528\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4e2a\u6570 (3)Shared\u663e\u793a\u5171\u4eab\u670d\u52a1\u5668\u8fdb\u7a0b\u7684\u4e2a\u6570\u3002 (4)Dispatchers\u663e\u793adispathers\u7684\u4e2a\u6570. (5)JobQueue\u663e\u793a\u4f5c\u4e1a\u8fdb\u7a0b\u7684\u4e2a\u6570 \u3000\u30004. SGA\u9762\u677f\uff1a\u663e\u793aSGA\u4e2d\u5404\u7ec4\u4ef6\u7684\u5185\u5b58\u4f7f\u7528\u60c5\u51b5 (1)CurrentSize\u663e\u793a\u5f53\u524dsga\u4f7f\u7528M\u6570 (2)BufferCache,KeepPool,RecyclePool\u663e\u793a\u6570\u636e\u7f13\u51b2\u533a\u7684\u5185\u5b58\u60c5\u51b5 (3)SharedPool:\u5171\u4eab\u6c60\u7684\u4f7f\u7528\u60c5\u51b5 (4)RedoLog\uff1a\u91cd\u4f5c\u65e5\u5fd7\u7684\u4f7f\u7528\u60c5\u51b5 (5)LargePool\uff1a\u5927\u6c60\u7684\u4f7f\u7528\u60c5\u51b5 (6)JavaPool\uff1ajava\u6c60\u7684\u4f7f\u7528\u60c5\u51b5 \u3000\u30005.Background process\u9762\u677f-\u540e\u53f0\u8fdb\u7a0b\u9762\u677f\uff1a\u663e\u793a\u4e0e\u78c1\u76d8I\/O\u76f8\u5173\u7684\u540e\u53f0\u8fdb\u7a0b\u3002 (1)DBWR \u6570\u636e\u5199\u5165\u8fdb\u7a0b (2)LGWR \u65e5\u5fd7\u8fdb\u7a0b (3)ARCH \u89c4\u6863\u8fdb\u7a0b\u5f0f \u3000\u30006. \u78c1\u76d8\u5b58\u50a8\u9762\u677f\uff1a\u663e\u793a\u4e3b\u8981\u6570\u636e\u5e93\u6587\u4ef6\u7684\u60c5\u51b5\uff08\u63a7\u5236\u6587\u4ef6\u9664\u5916\uff09 (1\uff09DatabaseFiles:\u663e\u793a\u6570\u636e\u6587\u4ef6\u4f7f\u7528\u60c5\u51b5\u3002 (2\uff09\u8054\u673a\u65e5\u5fd7\u6587\u4ef6\u60c5\u51b5\u3002\u5305\u62ec\u7ec4\u6570\u53ca\u5927\u5c0f\u3002 (3\uff09\u5f52\u6863\u65e5\u5fd7\u60c5\u51b5\u3002 \u3000\u3000\u4e09\u3001TopSessions \u901a\u8fc7topSession\u9762\u677f\u53ef\u4ee5\u67e5\u770b\u5f53\u524d\u54ea\u4e2asession\u5f53\u524d\u5360\u7528\u4e86\u5927\u91cf\u7684\u8d44\u6e90\uff0c\u4ee5\u6b64\u5b9a\u4f4d\u6570\u636e\u5e93\u95ee\u9898\u3002\u5355\u51fb\u4e0a\u90e8\u5217\u8868\uff0c\u4f1a\u5728session Information\u4e2d\u663e\u793a\u8be5\u4f1a\u8bdd\u7684\u6240\u6709\u8be6\u3000\u3000\u3000\u3000\u3000\u3000\u7ec6\u4fe1\u606f\u3002 \u3000\u3000 \u4e0b\u9762\u662f\u51e0\u4e2a\u5e94\u6ce8\u610f\u7684\u5730\u65b9\uff1a \u3000\u3000most recent sql:\u53ef\u4ee5\u7528\u6765\u786e\u5b9a\u5f53\u524d\u5360\u7528\u8d44\u6e90\u6700\u5927\u7684sql\u8bed\u53e5 \u3000\u3000Session waits:\u53ef\u4ee5\u627e\u51fa\u4e0e\u8be5session\u76f8\u5173\u7684\u7b49\u5f85\u4e8b\u4ef6\u3002 \u3000\u3000 Session locks:\u663e\u793a\u76f8\u5173\u7684\u9501\u4fe1\u606f\u3002 \u3000\u3000 \u56db\u3001top sql:\u6839\u636e\u6761\u4ef6\u6765\u67e5\u770blibraryCache\u4e2d\u76f8\u5e94\u7684sql. \u3000\u3000\u4e3b\u8981\u7684\u9009\u9879\u4e3asorting \u3000\u3000\u53ef\u4ee5\u636e\u6b64\u6765\u627e\u51fa\u5f71\u54cd\u5927\u7684sql \u3000\u3000 \u70b9\u51fbFetch SQL\u6309\u94ae\uff0c\u53ef\u4ee5\u67e5\u770b\u5230\u76f8\u5e94\u7684SQL\u8bed\u53e5 \u3000\u3000 \u4e94\u3001Activity:\u8fd9\u4e2a\u7a97\u53e3\uff0c\u4e3b\u8981\u63d0\u4f9b\u4e86\u7b49\u5f85\u4e8b\u4ef6\uff0c\u9501\u7b49\u5f85\uff0c\u95eb\u9501\u7b49\u5f85\uff0c\u5f53\u524d\u4e8b\u52a1\u7b49\u3002 \u3000\u3000 \u516d\u3001\u914d\u7f6e\u548c\u5185\u5b58\uff1a\u4e3b\u8981\u663e\u793aSGA\u7684\u4f7f\u7528\u60c5\u51b5\u53ca\u53c2\u6570\u914d\u7f6e\u60c5\u51b5 \u3000\u3000 \u4e03\u3001\u78c1\u76d8\u5b58\u50a8\u60c5\u51b5:\u663e\u793a\u8868\u7a7a\u95f4\u5229\u7528\u7387\u548c\u5728\u7ebf\u65e5\u5fd7\u7684\u4f7f\u7528\u60c5\u51b5\u3002 Quest.Central.For.Databases\u4e0b\u8f7d\u5730\u5740\uff1a http:\/\/58.251.57.206\/down?cid=1669258673&t=14&fmt=&usrinput=Quest.Central&dt=0&ps=0_0&rt=0kbs&plt=0&spd=9 \u6ce8\u610f\uff1a\u8be5\u8f6f\u4ef6\u8bd5\u7528\u671f\u53ea\u67097\u5929\uff0c\u6211\u8fd9\u91cc\u6709\u6ce8\u518c\u673a\uff0c\u9700\u8981\u7684\u8bf7\u7559Email\uff0c…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1412","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1412"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions"}],"predecessor-version":[{"id":1413,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1412\/revisions\/1413"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}