oracle\u8fd9\u4e2a\u9519\u8bef\u7684\u610f\u601d\u662f\u00a0 \u6570\u636e\u5e93\u7684\u8fde\u63a5\u6570\u8fbe\u5230\u6700\u5927\u503c\u9650\u5236\u3002<\/p>\n

\u4e00\u3001\u5173\u4e8e<\/strong>v$process <\/strong>\u548c<\/strong>v$session<\/strong>\u7684\u57fa\u672c\u77e5\u8bc6<\/strong>
\nOracle\u6570\u636e\u5e93\u4e2dSession\u548cConnection\u7684\u533a\u522b\u3002
\n\u5728Oracle\u7684\u5b98\u65b9\u6587\u6863\u4e0a\uff0c\u5bf9Session\u548cConnection\u662f\u8fd9\u6837\u89e3\u91ca\u7684\uff1a
\n\u00a0 Connection:<\/strong> Communicate pathway between a client process and an Oracle database instance.<\/p>\n

\u8fde\u63a5<\/strong>\uff1a\u4e00\u4e2a\u5ba2\u6237\u7aef\u8fdb\u7a0b\u548cOracle\u6570\u636e\u5e93\u5b9e\u4f8b\u4e4b\u95f4\u7684\u901a\u4fe1\u94fe\u8def\u3002<\/p>\n

Session: <\/strong>A logical entity in the database instance memory that represnts the state of a current user login to a database. A single connection can have 0, 1 or more sessions established on it.
\n\u4f1a\u8bdd\uff1a<\/strong>\u7528\u4e8e\u5c55\u793a\u5f53\u524d\u767b\u5f55\u5230\u6570\u636e\u5e93\u7528\u6237\u7684\u72b6\u6001\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u5185\u5b58\u4e2d\u7684\u4e00\u4e2a\u903b\u8f91\u5b9e\u4f53\u3002\u4e00\u4e2a\u5355\u72ec\u7684\u8fde\u63a5\u53ef\u4ee5\u67090\uff0c1\uff0c\u6216\u8005\u66f4\u591a\u7684\u4f1a\u8bdd\u3002<\/p>\n

Connection\u5e76\u4e0d\u662f\u76f4\u63a5\u5efa\u7acb\u5728\u7528\u6237\u8fdb\u7a0b\u548c\u6570\u636e\u5e93\u5b9e\u4f8b\u4e4b\u95f4\u7684\u3002\u800c\u662f\u5728\u7528\u6237\u8fdb\u7a0b\u548cServer Process\uff08\u670d\u52a1\u5668\u8fdb\u7a0b\uff09\u4e4b\u95f4\u7684\uff0c\u56e0\u6b64\u6709\u4e00\u4e2aConnection\u5c31\u4e00\u5b9a\u4f1a\u6709\u4e00\u4e2a\u7528\u6237\u8fdb\u7a0b\u548c\u4e00\u4e2a\u670d\u52a1\u5668\u8fdb\u7a0b\u3002\u4f46\u4e0d\u4e00\u5b9a\u4f1a\u5b58\u5728Session\u3002\u6bd4\u5982\uff0c\u5982\u679c\u9700\u8981\u5c06\u4e1c\u897f\u4eceA\u8fd0\u5230B\uff0cConnection\u53ef\u4ee5\u770b\u6210\u662f\u4e00\u5ea7\u201c\u6865\u201d\uff0c\u800c\u5361\u8f66\u628a\u4e1c\u897f\u4eceA\u8fd0\u5230B\u540e\u5e76\u8fd4\u56deA\uff0c\u8fd9\u5c31\u662fSession\u3002\u6240\u4ee5\uff0c\u53ea\u8981\u4e0d\u65ad\u5f00\u8fde\u63a5\uff0c\u968f\u65f6\u90fd\u53ef\u4ee5\u5728\u8fd9\u4e2a\u8fde\u63a5\u4e0a\u521b\u5efa\u51fa\u4f1a\u8bdd\u3002<\/p>\n

\u4e8c\u3001\u67e5\u770b<\/strong>v$process <\/strong>\u548c<\/strong>v$session<\/strong>\u7684\u57fa\u672c\u4fe1\u606f<\/strong>
\n\u67e5\u8be2\u8d44\u6e90\u9650\u5236\u7684\u89c6\u56fe\u7684\u8bed\u6cd5\uff1a<\/p>\n

select * from v$resource_limit;<\/p>\n

select * from v$process;<\/p>\n

select * from v$session;<\/p>\n

select * from v$session t where t.STATUS=’ACTIVE”;<\/p>\n

process\u548csession\u53c2\u6570\u6700\u5927\u503c\u4f30\u7b97\u65b9\u6cd5
\nselect round(sum(pga_used_mem)\/1024\/1024,0) total_used_M, round(sum(pga_used_mem)\/count(1)\/1024\/1024,0) avg_used_M,
\nround(sum(pga_alloc_mem)\/1024\/1024,0) total_alloc_M, round(sum(pga_alloc_mem)\/count(1)\/1024\/1024,0) avg_alloc_M from v$process;<\/p>\n

\u4e09\u3001\u91ca\u653e\u8d44\u6e90<\/strong>
\n\u5728sqlnet.ora\u6587\u4ef6\u4e2d\u8bbe\u7f6eexpire_time \u53c2\u6570\u3002
\n\u53ef\u4ee5\u4f7f\u7528EXPIRE_TIME\u53c2\u6570\u95f4\u6b47\u68c0\u67e5\u5f02\u5e38session\u5e76\u91ca\u653eprocess\u3002
\n\u5b98\u65b9\u8bf4\u660e\uff1aSQLNET.EXPIRE_TIME
\nPurpose
\nUse parameter SQLNET.EXPIRE_TIME to specify a the time interval, in minutes, to send a probe to verify that client\/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit. This parameter is primarily intended for the database server, which typically handles multiple connections at any one time.
\nLimitations on using this terminated connection detection feature are:
\nIt is not allowed on bequeathed connections.
\nThough very small, a probe packet generates additional traffic that may downgrade network performance.
\nDepending on which operating system is in use, the server may need to perform additional processing to distinguish the connection probing event from other events that occur. This can also result in degraded network performance.<\/p>\n

Recommended Value
\n10
\nExample
\nSQLNET.EXPIRE_TIME=10<\/p>\n

\u8fd9\u91cc\u8bbe\u7f6e\u662f10\u5206\u949f\uff0c\u6bcf10\u5206\u949fOracle\u4f1a\u786e\u8ba4\u6240\u6709session\u5ba2\u6237\u7aef\u8fde\u63a5\u662f\u5426\u6b63\u5e38\uff0c\u5bf9\u4e8e\u4e0d\u6b63\u5e38\u7684session\uff0coracle\u4f1a\u6e05\u7406process\u3002<\/p>\n

\u540c\u65f6\uff0c\u6269\u5927\u6700\u5927\u8fde\u63a5\u6570\uff0c\u540c\u65f6<\/strong>Session<\/strong>\u81ea\u52a8\u8ddf\u7740\u6269\u5927\u3002<\/strong><\/p>\n

–\u4fee\u6539\u6700\u5927\u8fde\u63a5\u6570:<\/p>\n

alter system set processes = 500 scope = spfile;<\/p>\n

\u91cd\u542f\u6570\u636e\u5e93\uff1a<\/p>\n

cmd :sqlplus sys\/passw@databasename as sysdba<\/p>\n

\u7136\u540e\u8f93\u5165\u4ee5\u4e0b\u547d\u4ee4<\/p>\n

shutdown immediate;\u2014\u2014\u5173\u95ed\u6570\u636e\u5e93\uff0c\u5927\u6982\u9700\u8981\u4e00\u4e2a\u5c0f\u65f6<\/p>\n

startup;–\u91cd\u542f\u6570\u636e\u5e93\uff0c\u5927\u6982\u51e0\u5206\u949f\u3002<\/p>\n

\u91cd\u542f\u4e4b\u540e\uff1a<\/p>\n

select count(*) from v$process \u00a0 \u00a0\u2014\u2014\u4ece298\u53d8\u6210132<\/p>\n

select count(*) from v$session \u00a0 \u00a0\u2014\u2014\u4ece104\u53d8\u621038<\/p>\n

\u4f46\u662f\uff0c\u5728ArcGIS Portal \u91cc\u9762\u6253\u5f00\u4e00\u4e2a\u9875\u9762\uff0c\u8c03\u7528\u4e86SDE\u56fe\u5c42\uff0c<\/p>\n

\u4e0a\u9762\u7684\u8fde\u63a5\u6570\u5b57\u90fd\u589e\u52a0\uff0c\u90a3\u4e48\u5c31\u7b97\u8bbe\u7f6e\u4e3a\u6700\u5927500\uff0c\u4e5f\u652f\u6491\u4e0d\u6765\u591a\u5c11\u7528\u6237\u4f7f\u7528\u7684\uff01\uff01\uff01\uff01\uff1f\uff1f\uff1f\uff1f<\/p>\n

–\u67e5\u770b\u5f53\u524d\u6709\u54ea\u4e9b\u7528\u6237\u6b63\u5728\u4f7f\u7528\u6570\u636e<\/p>\n

SELECT osuser, a.username,cpu_time\/executions\/1000000||’s’,b.sql_text,machine<\/p>\n

from v$session a, v$sqlarea b<\/p>\n

where a.sql_address =b.address order by cpu_time;<\/p>\n

\u2014\u2014\u5728ArcGIS Portal \u91cc\u9762\u6253\u5f00\u4e00\u4e2a\u9875\u9762\uff0c\u8c03\u7528\u4e86SDE\u56fe\u5c42\uff0c\u901a\u8fc7\u4ee5\u4e0a\u8bed\u53e5\uff0c\u53ef\u4ee5\u770b\u5230SDE\u7528\u6237\u7684\u8fde\u63a5\u4fe1\u606f\u3002<\/p>\n

\u5c31\u7b97\u5173\u95ed\u4e86\u6d4f\u89c8\u5668\uff0c\u4e00\u6bb5\u65f6\u95f4\u4f9d\u7136\u53ef\u4ee5\u770b\u5230\u8fd9\u4e9b\u4fe1\u606f\uff0c\u534a\u4e2a\u5c0f\u65f6\u540e\uff0cSDE\u7684\u8fde\u63a5\u624d\u6d88\u5931\u3002<\/p>\n

\u2014\u2014\u67e5\u8be2\u6570\u636e\u5e93\u6709\u6ca1\u6709\u6b7b\u9501\uff0cno row selected \u8bf4\u660e\u6ca1\u6709\u6b7b\u9501\u3002<\/p>\n

select * from v$locked_object<\/p>\n<\/div>\n<\/div>\n<\/article>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"