{"id":1691,"date":"2019-10-16T13:40:38","date_gmt":"2019-10-16T05:40:38","guid":{"rendered":"http:\/\/www.llku.com\/?p=1691"},"modified":"2019-10-16T13:57:43","modified_gmt":"2019-10-16T05:57:43","slug":"oracle%e6%95%b0%e6%8d%ae%e5%ba%93%e6%8a%a5%e9%94%99%ef%bc%9aora-01555-%e5%bf%ab%e7%85%a7%e8%bf%87%e6%97%a7-%e5%9b%9e%e9%80%80%e6%ae%b5%e5%8f%b7-10-%e5%90%8d%e7%a7%b0%e4%b8%ba-_syssmu10_3550978943","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1691","title":{"rendered":"oracle\u6570\u636e\u5e93\u62a5\u9519\uff1aORA-01555: \u5feb\u7167\u8fc7\u65e7: \u56de\u9000\u6bb5\u53f7 10 (\u540d\u79f0\u4e3a “_SYSSMU10_3550978943$”) \u8fc7\u5c0f"},"content":{"rendered":"
\n

\u524d\u7f00\uff1a<\/p>\n

\u6bd4\u8f83\u5947\u602a\u7684\u662f\uff0c\u8bf7\u6c42\u7206\u8fd9\u4e2a\u9519\u8bef\u540e\uff0c\u6211\u5728\u7a0b\u5e8f\u91cc\u9762\u52a0\u4e86\u4e2awhen others\u7684\u5f02\u5e38\uff0c\u7136\u540e\u5c31\u6b63\u5e38\u4e86\u3002<\/p>\n

\n
\n
\n
\n

oracle undo\u8868\u7a7a\u95f4<\/p>\n

undo\u8868\u7a7a\u95f4\u7528\u4e8e\u5b58\u653eundo\u6570\u636e\uff0c\u5f53\u6267\u884cDML\u64cd\u4f5c\uff08insert\u3001update\u3001delete\uff09\u65f6\uff0coracle\u4f1a\u5c06\u8fd9\u4e9b\u64cd\u4f5c\u7684\u65e7\u6570\u636e\u5199\u5165\u5230undo\u6bb5\u3002<\/p>\n

undo\u6570\u636e\u7684\u4f5c\u7528<\/p>\n

1.\u56de\u9000\u4e8b\u52a1<\/p>\n

\u5f53\u6267\u884cDML\u64cd\u4f5c\u4fee\u6539\u6570\u636e\u540e\uff0c\u65e7\u6570\u636e\u88ab\u5b58\u653e\u5728undo\u6bb5\u4e2d\u3002\u53ea\u8981\u6570\u636e\u4e3a\u63d0\u4ea4\u3001\u56de\u6eda\u6bb5\u672a\u5199\u6ee1\u6216\u8005\u56de\u6eda\u6bb5\u4e3a\u8d85\u65f6\u7684\u60c5\u51b5\u4e0b\uff0c\u65e7\u6570\u636e\u90fd\u80fd\u88ab\u56de\u6eda\u56de\u6765\u3002<\/p>\n

2.\u8bfb\u4e00\u81f4\u6027<\/p>\n

\u901a\u8fc7DML\u64cd\u4f5c\u540e\u7684\u6570\u636e\u6ca1\u6709\u63d0\u4ea4\u4e4b\u524d\uff0c\u5176\u4ed6\u7528\u6237\u8bfb\u53d6\u7684\u6570\u636e\u90fd\u662f\u56de\u6eda\u6bb5\u91cc\u9762\u7684\u65e7\u6570\u636e\u3002<\/p>\n

\u4f7f\u7528undo\u53c2\u6570<\/p>\n

1.undo_management<\/p>\n

\u8be5\u521d\u59cb\u5316\u53c2\u6570\u7528\u4e8e\u6307\u5b9aundo\u6570\u636e\u7684\u7ba1\u7406\u65b9\u5f0f\u3002\u5982\u679c\u8981\u4f7f\u7528\u81ea\u52a8\u7ba1\u7406\u6a21\u5f0f\uff0c\u5fc5\u987b\u8bbe\u7f6e\u4e3aauto\uff0c\u5982\u679c\u4f7f\u7528\u624b\u5de5\u7ba1\u7406\u6a21\u5f0f\u5fc5\u987b\u8bbe\u7f6e\u8be5\u53c2\u6570\u4e3amanual\uff0c\u4f7f\u7528\u81ea\u52a8\u7ba1\u7406\u6a21\u5f0f\u65f6\uff0coracle\u4f1a\u4f7f\u7528undo\u8868\u7a7a\u95f4\u7ba1\u7406\uff0c\u4f7f\u7528\u624b\u5de5\u7ba1\u7406\u6a21\u5f0f\u65f6\uff0coracle\u4f1a\u4f7f\u7528\u56de\u6eda\u6bb5\u7ba1\u7406undo\u6570\u636e\u3002\u9700\u8981\u6ce8\u610f,\u4f7f\u7528\u81ea\u52a8\u7ba1\u7406\u6a21\u5f0f\u65f6,\u5982\u679c\u6ca1\u6709\u914d\u7f6e\u521d\u59cb\u5316\u53c2\u6570UNDO_TABLESPACE,oracle\u4f1a\u81ea\u52a8\u9009\u62e9\u7b2c\u4e00\u4e2a\u53ef\u7528\u7684UNDO\u8868\u7a7a\u95f4\u5b58\u653eUNDO\u6570\u636e,\u5982\u679c\u6ca1\u6709\u53ef\u7528\u7684UNDO\u8868\u7a7a\u95f4,oracle\u4f1a\u4f7f\u7528SYSTEM\u56de\u6eda\u6bb5\u5b58\u653eUNDO\u8bb0\u5f55,\u5e76\u5728ALTER\u6587\u4ef6\u4e2d\u8bb0\u8f7d\u8b66\u544a\u3002<\/p>\n

2,UNDO_TABLESPACE<\/p>\n

\u8be5\u521d\u59cb\u5316\u53c2\u6570\u7528\u4e8e\u6307\u5b9a\u4f8b\u7a0b\u6240\u8981\u4f7f\u7528\u7684UNDO\u8868\u7a7a\u95f4,\u4f7f\u7528\u81ea\u52a8UNDO\u7ba1\u7406\u6a21\u5f0f\u65f6,\u901a\u8fc7\u914d\u7f6e\u8be5\u53c2\u6570\u53ef\u4ee5\u6307\u5b9a\u4f8b\u7a0b\u6240\u8981\u4f7f\u7528\u7684UNDO\u8868\u7a7a\u95f4.<\/p>\n

\u5728RAC(Real Application Cluster)\u7ed3\u6784\u4e2d,\u56e0\u4e3a\u4e00\u4e2aUNDO\u8868\u7a7a\u95f4\u4e0d\u80fd\u7531\u591a\u4e2a\u4f8b\u7a0b\u540c\u65f6\u4f7f\u7528,\u6240\u6709\u5fc5\u987b\u4e3a\u6bcf\u4e2a\u4f8b\u7a0b\u914d\u7f6e\u4e00\u4e2a\u72ec\u7acb\u7684UNDO\u8868\u7a7a\u95f4.<\/p>\n

3,UNDO_RETENTION<\/p>\n

\u8be5\u521d\u59cb\u5316\u53c2\u6570\u7528\u4e8e\u63a7\u5236UNDO\u6570\u636e\u7684\u6700\u5927\u4fdd\u7559\u65f6\u95f4,\u5176\u9ed8\u8ba4\u503c\u4e3a900\u79d2,\u4ece9i\u5f00\u59cb,\u901a\u8fc7\u914d\u7f6e\u8be5\u521d\u59cb\u5316\u53c2\u6570,\u53ef\u4ee5\u6307\u5b9aundo\u6570\u636e\u7684\u4fdd\u7559\u65f6\u95f4,\u4ece\u800c\u786e\u5b9a\u5012\u53d9\u67e5\u8be2\u7279\u5f81(Flashback Query)\u53ef\u4ee5\u67e5\u770b\u5230\u7684\u6700\u65e9\u65f6\u95f4\u70b9.<\/p>\n

\u624b\u5de5\u7ba1\u7406\u56de\u6eda\u6bb5\u7684\u89c4\u5212\uff1a<\/p>\n

SQL> show parameter\u00a0 undo;<\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/p>\n

———————————— ———– ——————————<\/p>\n

undo_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 AUTO<\/p>\n

undo_retention\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0 900<\/p>\n

undo_tablespace\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 UNDOTBS1<\/p>\n

SQL> show parameter\u00a0 transactions;<\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/p>\n

———————————— ———– ——————————<\/p>\n

transactions\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 187\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ———-\u7cfb\u7edf\u51c6\u5907\u652f\u6301\u7684\u4e8b\u52a1\u8fde\u63a5\u6570\u91cf\u3002<\/p>\n

transactions_per_rollback_segment\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ————–\u6bcf\u4e2a\u56de\u6eda\u6bb5\u652f\u6301\u7684\u4e8b\u52a1\u8fde\u63a5\u6570\u91cf\u3002\u56de\u6eda\u6bb5\u6570=187\/5<\/p>\n

SQL> show\u00a0 parameter rollback;<\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/p>\n

———————————— ———– ———-<\/p>\n

fast_start_parallel_rollback\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 LOW<\/p>\n

rollback_segments\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string ———————-\u8bbe\u7f6e\u56de\u6eda\u6bb5\u7684\u6570\u91cf<\/p>\n

transactions_per_rollback_segment\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 5<\/p>\n

<\/div>\n

\u9519\u8bef\u539f\u56e0\uff1a<\/p>\n

SQL\u8bed\u53e5\u6267\u884c\u65f6\u95f4\u592a\u957f\uff0c\u6216\u8005UNDO\u8868\u7a7a\u95f4\u8fc7\u5c0f\uff0c\u6216\u8005\u4e8b\u52a1\u91cf\u8fc7\u5927\uff0c\u6216\u8005\u8fc7\u4e8e\u9891\u7e41\u7684\u63d0\u4ea4\uff0c\u5bfc\u81f4\u6267\u884cSQL\u8fc7\u7a0b\u4e2d\u8fdb\u884c\u4e00\u81f4\u6027\u8bfb\u65f6\uff0cSQL\u6267\u884c\u540e\u4fee\u6539\u7684 \u524d\u955c\u50cf\uff08\u5373UNDO\u6570\u636e\uff09\u5728UNDO\u8868\u7a7a\u95f4\u4e2d\u5df2\u7ecf\u88ab\u8986\u76d6\uff0c\u4e0d\u80fd\u6784\u9020\u4e00\u81f4\u6027\u8bfb\u5757\uff08CR blocks\uff09\u3002 \u00a0\u8fd9\u79cd\u60c5\u51b5\u6700\u591a\u3002<\/p>\n

\u89e3\u51b3\u529e\u6cd5\uff1a<\/p>\n

\u7b2c1\u79cd\u60c5\u51b5\u89e3\u51b3\u7684\u529e\u6cd5\uff1a<\/p>\n

\uff081\uff09\u589e\u52a0UNDO\u8868\u7a7a\u95f4\u5927\u5c0f<\/p>\n

\uff082\uff09\u589e\u52a0undo_retention \u65f6\u95f4\uff0c\u9ed8\u8ba4\u53ea\u670915\u5206\u949f<\/p>\n

alter \u00a0system set undo_retention=14400 \uff1b<\/p>\n

undo_retention\u8fd9\u4e2a\u503c\u53ef\u4ee5\u6839\u636e\u60c5\u51b5\u8c03\u5927\u4e00\u4e9b\u3002<\/p>\n

\uff083\uff09\u4f18\u5316\u51fa\u9519\u7684SQL\uff0c\u51cf\u5c11\u67e5\u8be2\u7684\u65f6\u95f4\uff0c\u9996\u9009\u65b9\u6cd5<\/p>\n

\uff084\uff09\u907f\u514d\u9891\u7e41\u7684\u63d0\u4ea4<\/p>\n

\u8fd8\u6709\u4e00\u79cd\u60c5\u51b5\uff0c\u53ef\u80fd\u662foracle BUG\uff0c\u5b98\u7f51\u8bf4\u6cd5ORA-01555BUG\u6bd4\u8f83\u591a\uff0c<\/p>\n

\u5176\u4ed6\u53c2\u8003\uff1a<\/p>\n

https:\/\/www.cnblogs.com\/Richardzhu\/archive\/2013\/03\/25\/2981610.html<\/a><\/p>\n

\u67e5\u770b\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5
\nSELECT a.tablespace_name,
\nROUND (a.total_size) “total_size(MB)”,
\nROUND (a.total_size) – ROUND (b.free_size, 3) “used_size(MB)”,
\nROUND (b.free_size, 3) “free_size(MB)”,
\nROUND (b.free_size \/ total_size * 100, 2) || ‘%’ free_rate
\nFROM ( SELECT tablespace_name, SUM (bytes) \/ 1024 \/ 1024 total_size
\nFROM dba_data_files
\nGROUP BY tablespace_name) a,
\n( SELECT tablespace_name, SUM (bytes) \/ 1024 \/ 1024 free_size
\nFROM dba_free_space
\nGROUP BY tablespace_name) b
\nWHERE a.tablespace_name = b.tablespace_name(+);<\/p>\n

TABLESPACE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 total_size(MB) used_size(MB) free_size(MB) FREE_RATE
\n—————————— ————– ————- ————- —————————————–
\nSYSAUX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 900\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 835.687\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 64.313 7.15%
\nUNDOTBS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24576\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 53.875\u00a0\u00a0\u00a0\u00a0 24522.125 99.78%
\nUSERS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.312\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.688 73.75%
\nSYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4170\u00a0\u00a0\u00a0\u00a0\u00a0 4160.687\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9.313 .22%
\nUSER_DATA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 150\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 105.062\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 44.938 29.96%<\/p>\n

\u8ba1\u7b97\u6240\u9700undo\u8868\u7a7a\u95f4\u7684\u5927\u5c0f:<\/p>\n

1.\u8ba1\u7b97\u4e1a\u52a1\u9ad8\u5cf0\u671f\u6bcf\u79d2\u4ea7\u751fundo\u6570\u636e\u5757\u7684\u4e2a\u6570
\nSQL> select max(undoblks \/ ((end_time – begin_time)*24*3600)) from v$undostat;<\/p>\n

MAX(UNDOBLKS\/((END_TIME-BEGIN_
\n——————————
\n11.305<\/p>\n

2.\u5f97\u5230undo\u6570\u636e\u5757\u5728undo\u8868\u7a7a\u95f4\u4e2d\u53ef\u4ee5\u4fdd\u7559\u7684\u6700\u957f\u65f6\u95f4
\nSQL> show parameter undo_retention;<\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE
\n———————————— ———– ——————————
\nundo_retention\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 86400<\/p>\n

3.\u5f97\u5230\u6570\u636e\u5757\u5927\u5c0f
\nSQL> show parameter db_blo<\/p>\n

NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE
\n———————————— ———– ——————————
\ndb_block_buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 0
\ndb_block_checking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 FALSE
\ndb_block_checksum\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 TYPICAL
\ndb_block_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 integer\u00a0\u00a0\u00a0\u00a0 8192<\/p>\n

4.\u5c06\u4ee5\u4e0a\u4e09\u8005\u7684\u6570\u636e\u76f8\u4e58\u5c31\u662f\u6240\u9700undo\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\u6570
\nSQL> select (11.305*86400*8192)\/1024\/1024\/1024 undoTablespace_GB from dual;<\/p>\n

UNDOTABLESPACE_GB
\n—————–
\n7.4520263671875<\/p>\n

\u53d1\u73b0undo\u8868\u7a7a\u95f4\u4e0d\u591f\u7684\u65f6\u5019\uff0c\u8d76\u7d27\u589e\u52a0undo\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\uff0c\u6267\u884c\u8bed\u53e5\u5982\u4e0b\uff1a
\nalter tablespace undotbs1 add datafile ‘\/u01\/database\/instance_name\/undotbs02.dbf’ size 100M autoextend on next 128M maxsize 24G;
\nalter tablespace undotbs1 add datafile ‘\/u01\/database\/instance_name\/undotbs03.dbf’ size 100M autoextend on next 128M maxsize 24G;
\nalter tablespace undotbs1 add datafile ‘\/u01\/database\/instance_name\/undotbs04.dbf’ size 100M autoextend on next 128M maxsize 24G;<\/p>\n

–\u67e5\u770b\u4f1a\u8bdd\u6570
\nselect count(*) from v$session;<\/p>\n

–\u67e5\u770b\u8fdb\u7a0b\u6570
\nselect count(*) from v$process;<\/p>\n

–\u67e5\u770b\u6570\u636e\u5e93\u7684\u5e76\u53d1\u8fde\u63a5\u6570
\nselect * from v$session where status=’ACTIVE’;<\/p>\n

–\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u5efa\u7acb\u7684\u4f1a\u8bdd
\nSELECT SID,SERIAL#,USERNAME,PROGRAM,MACHINE,STATUS FROM V$SESSION;<\/p>\n

–\u67e5\u770b\u6570\u636e\u5e93\u5141\u8bb8\u7684\u6700\u5927\u8fde\u63a5\u6570
\nSELECT value FROM V$PARAMETER WHERE NAME=’processes’<\/p>\n

–\u67e5\u770b\u6570\u636e\u5e93\u5141\u8bb8\u7684\u6700\u5927\u4f1a\u8bdd\u6570
\nSELECT value FROM V$PARAMETER WHERE NAME=’sessions’
\n–\u67e5\u770b\u540e\u53f0\u6b63\u5728\u8fd0\u884c\u7740\u7684sql\u8bed\u53e5
\nselect a.program,b.spid,c.sql_text from v$session a,v$process b,v$sqlarea c where a.paddr=b.addr and a.sql_hashvalue=c.hash_value and a.username is not null;<\/p>\n

\u67e5\u8be2\u6240\u6709\u6570\u636e\u5e93\u7684\u8fde\u63a5\u6570
\nselect schemaname,count(*)from v$session group by schemaname;<\/p>\n

\u67e5\u8be2\u7ec8\u7aef\u7528\u6237\u4f7f\u7528\u6570\u636e\u5e93\u7684\u8fde\u63a5\u60c5\u51b5\u3002
\nselect osuser,schemaname,count(*) fromv $session group by schemaname,osuser;<\/p>\n

\u67e5\u770b\u5f53\u524d\u4e0d\u4e3a\u7a7a\u7684\u8fde\u63a5
\nselect * from v$session where username is not null<\/p>\n

\u67e5\u770b\u4e0d\u540c\u7528\u6237\u7684\u8fde\u63a5\u6570
\nselect username,count(username) from v$session where username is not null group by username<\/p>\n

\u8f6c\u81ea\uff1ahttps:\/\/blog.csdn.net\/qiuzhi__ke\/article\/details\/78937078<\/p>\n<\/div>\n<\/div>\n<\/article>\n<\/div>\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u524d\u7f00\uff1a \u6bd4\u8f83\u5947\u602a\u7684\u662f\uff0c\u8bf7\u6c42\u7206\u8fd9\u4e2a\u9519\u8bef\u540e\uff0c\u6211\u5728\u7a0b\u5e8f\u91cc\u9762\u52a0\u4e86\u4e2awhen others\u7684\u5f02\u5e38\uff0c\u7136\u540e\u5c31\u6b63\u5e38\u4e86\u3002 ora … \u7ee7\u7eed\u9605\u8bfboracle\u6570\u636e\u5e93\u62a5\u9519\uff1aORA-01555: \u5feb\u7167\u8fc7\u65e7: \u56de\u9000\u6bb5\u53f7 10 (\u540d\u79f0\u4e3a “_SYSSMU10_3550978943$”) \u8fc7\u5c0f<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[68],"tags":[133],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1691"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1691"}],"version-history":[{"count":2,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1691\/revisions"}],"predecessor-version":[{"id":1693,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1691\/revisions\/1693"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1691"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1691"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1691"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}