Error: 17803, Severity: 20, State: 7 Insufficient memory available
Windows 2003
SQL Server 2000 SP4 8.0.2055
在log中發現一些錯誤如下， 機器記憶體為 40G , 分配給SQL Server的為30G, 設定了AWE大記憶體 。 不知道
是否設定AWE的問題 ？ 查詢了一下， 是 Bug #: 364188 (SHILOH_BUGS) ，
詳見 FIX： 額外的最佳化記憶體消耗量可能出現的具有多個 OUTER 聯接的查詢
但是後面說明： 此問題最早在 Microsoft SQL Server 2000 Service Pack 4 中得到了解決。 我們的SQL Server2000已經是
SP4 8.0.2055 了 ， 怎麼還會出這樣的問題呢 ？
2009-07-30 14:51:21.96 spid102 Dynamic Memory Manager: Stolen=133353 OS Reserved=1160 ...
2009-07-30 14:51:21.96 spid102 Procedure Cache: TotalProcs=59524 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.96 spid102 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.96 spid102 Buffer Distribution: Stolen=46640 Free=21890 Procedures=86713...
2009-07-30 14:51:21.95 spid131 Insufficient memory available..
2009-07-30 14:51:21.95 spid131 Error: 17803, Severity: 20, State: 8
2009-07-30 14:51:21.95 spid131 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.95 spid131 Global Memory Objects: Resource=2650 Locks=229 ...
2009-07-30 14:51:21.95 spid131 Dynamic Memory Manager: Stolen=133360 OS Reserved=1160 ...
2009-07-30 14:51:21.95 spid131 Procedure Cache: TotalProcs=59520 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.95 spid131 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.95 spid131 Buffer Distribution: Stolen=46648 Free=21882 Procedures=86713...
2009-07-30 14:51:21.87 spid133 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.87 spid133 Global Memory Objects: Resource=2656 Locks=229 ...
2009-07-30 14:51:21.87 spid133 Dynamic Memory Manager: Stolen=137409 OS Reserved=1160 ...
2009-07-30 14:51:21.87 spid133 Procedure Cache: TotalProcs=61063 TotalPages=90746 InUsePages=42484
2009-07-30 14:51:21.87 spid133 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.87 spid133 Buffer Distribution: Stolen=46675 Free=17822 Procedures=90746...
2009-07-30 14:51:21.76 spid100 Insufficient memory available..
2009-07-30 14:51:21.76 spid100 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.76 spid100 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.76 spid100 Global Memory Objects: Resource=2660 Locks=229 ...
2009-07-30 14:51:21.76 spid100 Dynamic Memory Manager: Stolen=144657 OS Reserved=1160 ...
2009-07-30 14:51:21.76 spid100 Procedure Cache: TotalProcs=62931 TotalPages=97986 InUsePages=45735
2009-07-30 14:51:21.76 spid100 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.76 spid100 Buffer Distribution: Stolen=46688 Free=10569 Procedures=97986...
2009-07-30 14:51:21.73 spid111 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.73 spid111 Global Memory Objects: Resource=2661 Locks=229 ...
2009-07-30 14:51:21.73 spid111 Dynamic Memory Manager: Stolen=146582 OS Reserved=1160 ...
2009-07-30 14:51:21.73 spid111 Procedure Cache: TotalProcs=62220 TotalPages=99845 InUsePages=46448
2009-07-30 14:51:21.73 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.73 spid111 Buffer Distribution: Stolen=46748 Free=8653 Procedures=99845...
2009-07-30 14:51:21.63 spid124 Insufficient memory available..
2009-07-30 14:51:21.63 spid124 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.63 spid124 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid124 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid124 Dynamic Memory Manager: Stolen=152744 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid124 Procedure Cache: TotalProcs=63806 TotalPages=105919 InUsePages=49532
2009-07-30 14:51:21.63 spid124 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid124 Buffer Distribution: Stolen=46944 Free=2380 Procedures=105919...
2009-07-30 14:51:21.63 spid67 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid134 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid67 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid134 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid67 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid134 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid67 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid134 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid67 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid134 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid67 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 spid134 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 server Insufficient memory available..
2009-07-30 14:51:21.63 server Error: 17803, Severity: 20, State: 14
2009-07-30 14:51:21.63 server Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 server Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 server Dynamic Memory Manager: Stolen=152911 OS Reserved=1160 ...
2009-07-30 14:51:21.63 server Procedure Cache: TotalProcs=63805 TotalPages=106074 InUsePages=49628
2009-07-30 14:51:21.63 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 server Buffer Distribution: Stolen=46947 Free=2222 Procedures=106074...
2009-07-30 14:51:21.60 spid127 BPool::Map: no remappable address found.
2009-07-30 14:51:21.60 spid115 BPool::Map: no remappable address found.
2009-07-30 14:51:21.59 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.56 spid111 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.56 spid111 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.56 spid111 Dynamic Memory Manager: Stolen=155138 OS Reserved=1160 ...
2009-07-30 14:51:21.56 spid111 Procedure Cache: TotalProcs=63819 TotalPages=108288 InUsePages=50762
2009-07-30 14:51:21.56 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776916...
2009-07-30 14:51:21.56 spid111 Buffer Distribution: Stolen=46955 Free=0 Procedures=108288...
2009-07-30 14:51:21.51 spid71 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid102 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid119 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid136 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid134 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid133 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 spid100 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server 3 pages have a bstat of 000209
2009-07-30 14:51:21.43 server 103 pages have a bstat of 00000b
2009-07-30 14:51:21.43 server 268 pages have a bstat of 000009
2009-07-30 14:51:21.43 server 63819 pages have a bstat of 001001
2009-07-30 14:51:21.43 server 91415 pages have a bstat of 000000
2009-07-30 14:51:21.41 server There are 155608 pages in the AWE window
2009-07-30 14:51:21.41 server AWE mapping status:
2009-07-30 14:51:21.41 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid131 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid67 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid69 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid124 BPool::Map: no remappable address found.
2009-07-30 14:50:06.27 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 14:45:04.05 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:45:03.18 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:44:10.64 spid99 Insufficient memory available..
2009-07-30 11:44:10.64 spid99 Error: 17803, Severity: 20, State: 8
2009-07-30 11:44:10.64 spid99 Query Memory Manager: Grants=2 Waiting=0 Maximum=30163 Available=29943
2009-07-30 11:44:10.64 spid99 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid99 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid99 Procedure Cache: TotalProcs=63112 TotalPages=101774 InUsePages=46494
2009-07-30 11:44:10.64 spid99 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid99 Buffer Distribution: Stolen=52285 Free=1194 Procedures=101774...
2009-07-30 11:44:10.64 spid89 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.64 spid89 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid89 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid89 Procedure Cache: TotalProcs=63239 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.64 spid89 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid89 Buffer Distribution: Stolen=52282 Free=1194 Procedures=101777...
2009-07-30 11:44:10.53 spid78 Insufficient memory available..
2009-07-30 11:44:10.53 spid78 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid78 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid78 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid78 Dynamic Memory Manager: Stolen=151088 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid78 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid78 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid78 Buffer Distribution: Stolen=49427 Free=4049 Procedures=101777...
2009-07-30 11:44:10.53 spid119 Insufficient memory available..
2009-07-30 11:44:10.53 spid119 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid119 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid119 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid119 Dynamic Memory Manager: Stolen=151051 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid119 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid119 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid119 Buffer Distribution: Stolen=49405 Free=4071 Procedures=101777...
2009-07-30 11:44:10.51 spid113 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.51 spid113 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.51 spid113 Dynamic Memory Manager: Stolen=150592 OS Reserved=1160 ...
2009-07-30 11:44:10.51 spid113 Procedure Cache: TotalProcs=64144 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.51 spid113 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.51 spid113 Buffer Distribution: Stolen=48932 Free=4544 Procedures=101777...
2009-07-30 11:44:10.50 spid79 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.50 spid79 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.50 spid79 Dynamic Memory Manager: Stolen=150182 OS Reserved=1160 ...
2009-07-30 11:44:10.50 spid79 Procedure Cache: TotalProcs=64326 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.50 spid79 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.50 spid79 Buffer Distribution: Stolen=48517 Free=4959 Procedures=101777...
2009-07-30 11:44:10.45 spid69 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid69 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid69 Dynamic Memory Manager: Stolen=148599 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid69 Procedure Cache: TotalProcs=64912 TotalPages=101764 InUsePages=46494
2009-07-30 11:44:10.45 spid69 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid69 Buffer Distribution: Stolen=47052 Free=6437 Procedures=101764...
2009-07-30 11:44:10.45 spid109 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid109 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid109 Dynamic Memory Manager: Stolen=148597 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid109 Procedure Cache: TotalProcs=64129 TotalPages=101761 InUsePages=46494
2009-07-30 11:44:10.45 spid109 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid109 Buffer Distribution: Stolen=47053 Free=6439 Procedures=101761...
2009-07-30 11:44:10.43 spid115 Insufficient memory available..
2009-07-30 11:44:10.43 spid115 Error: 17803, Severity: 20, State: 12
2009-07-30 11:44:10.43 spid115 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid126 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid115 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid126 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid115 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid126 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid115 Procedure Cache: TotalProcs=64666 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid126 Procedure Cache: TotalProcs=64612 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid115 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid126 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid115 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.43 spid126 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.39 spid112 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.39 spid112 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.39 spid112 Dynamic Memory Manager: Stolen=150401 OS Reserved=1160 ...
2009-07-30 11:44:10.39 spid112 Procedure Cache: TotalProcs=65207 TotalPages=103561 InUsePages=47324
2009-07-30 11:44:10.39 spid112 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.39 spid112 Buffer Distribution: Stolen=47065 Free=4627 Procedures=103561...
2009-07-30 11:44:10.31 server Insufficient memory available..
2009-07-30 11:44:10.31 server Error: 17803, Severity: 20, State: 14
2009-07-30 11:44:10.31 spid95 Insufficient memory available..
2009-07-30 11:44:10.31 spid95 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.31 spid95 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.31 spid95 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.31 spid95 Dynamic Memory Manager: Stolen=153217 OS Reserved=1160 ...
2009-07-30 11:44:10.31 spid95 Procedure Cache: TotalProcs=65654 TotalPages=106363 InUsePages=48694
2009-07-30 11:44:10.31 spid95 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.31 spid95 Buffer Distribution: Stolen=47082 Free=1808 Procedures=106363...
2009-07-30 11:44:10.29 server Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.29 server Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.29 server Dynamic Memory Manager: Stolen=153317 OS Reserved=1160 ...
2009-07-30 11:44:10.29 server Procedure Cache: TotalProcs=65654 TotalPages=106461 InUsePages=48752
2009-07-30 11:44:10.29 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.29 server Buffer Distribution: Stolen=47083 Free=1709 Procedures=106461...
2009-07-30 11:44:10.21 spid119 BPool::Map: no remappable address found.
2009-07-30 11:44:10.20 spid99 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid109 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid69 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 3 pages have a bstat of 000209
2009-07-30 11:44:10.17 spid126 116 pages have a bstat of 00000b
2009-07-30 11:44:10.17 spid126 270 pages have a bstat of 000009
2009-07-30 11:44:10.17 spid126 65671 pages have a bstat of 001001
2009-07-30 11:44:10.17 spid126 89548 pages have a bstat of 000000
2009-07-30 11:44:10.17 spid126 There are 155608 pages in the AWE window
2009-07-30 11:44:10.17 spid126 AWE mapping status:
2009-07-30 11:44:10.17 spid79 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid95 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 server BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid115 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid78 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid89 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid112 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid113 BPool::Map: no remappable address found.
2009-07-30 11:40:04.69 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:35:03.02 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
SQL Server 2000 SP4 8.0.2055
在log中發現一些錯誤如下， 機器記憶體為 40G , 分配給SQL Server的為30G, 設定了AWE大記憶體 。 不知道
是否設定AWE的問題 ？ 查詢了一下， 是 Bug #: 364188 (SHILOH_BUGS) ，
詳見 FIX： 額外的最佳化記憶體消耗量可能出現的具有多個 OUTER 聯接的查詢
但是後面說明： 此問題最早在 Microsoft SQL Server 2000 Service Pack 4 中得到了解決。 我們的SQL Server2000已經是
SP4 8.0.2055 了 ， 怎麼還會出這樣的問題呢 ？
2009-07-30 14:51:21.96 spid102 Dynamic Memory Manager: Stolen=133353 OS Reserved=1160 ...
2009-07-30 14:51:21.96 spid102 Procedure Cache: TotalProcs=59524 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.96 spid102 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.96 spid102 Buffer Distribution: Stolen=46640 Free=21890 Procedures=86713...
2009-07-30 14:51:21.95 spid131 Insufficient memory available..
2009-07-30 14:51:21.95 spid131 Error: 17803, Severity: 20, State: 8
2009-07-30 14:51:21.95 spid131 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.95 spid131 Global Memory Objects: Resource=2650 Locks=229 ...
2009-07-30 14:51:21.95 spid131 Dynamic Memory Manager: Stolen=133360 OS Reserved=1160 ...
2009-07-30 14:51:21.95 spid131 Procedure Cache: TotalProcs=59520 TotalPages=86713 InUsePages=40912
2009-07-30 14:51:21.95 spid131 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.95 spid131 Buffer Distribution: Stolen=46648 Free=21882 Procedures=86713...
2009-07-30 14:51:21.87 spid133 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.87 spid133 Global Memory Objects: Resource=2656 Locks=229 ...
2009-07-30 14:51:21.87 spid133 Dynamic Memory Manager: Stolen=137409 OS Reserved=1160 ...
2009-07-30 14:51:21.87 spid133 Procedure Cache: TotalProcs=61063 TotalPages=90746 InUsePages=42484
2009-07-30 14:51:21.87 spid133 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.87 spid133 Buffer Distribution: Stolen=46675 Free=17822 Procedures=90746...
2009-07-30 14:51:21.76 spid100 Insufficient memory available..
2009-07-30 14:51:21.76 spid100 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.76 spid100 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.76 spid100 Global Memory Objects: Resource=2660 Locks=229 ...
2009-07-30 14:51:21.76 spid100 Dynamic Memory Manager: Stolen=144657 OS Reserved=1160 ...
2009-07-30 14:51:21.76 spid100 Procedure Cache: TotalProcs=62931 TotalPages=97986 InUsePages=45735
2009-07-30 14:51:21.76 spid100 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.76 spid100 Buffer Distribution: Stolen=46688 Free=10569 Procedures=97986...
2009-07-30 14:51:21.73 spid111 Query Memory Manager: Grants=0 Waiting=0 Maximum=29647 Available=29647
2009-07-30 14:51:21.73 spid111 Global Memory Objects: Resource=2661 Locks=229 ...
2009-07-30 14:51:21.73 spid111 Dynamic Memory Manager: Stolen=146582 OS Reserved=1160 ...
2009-07-30 14:51:21.73 spid111 Procedure Cache: TotalProcs=62220 TotalPages=99845 InUsePages=46448
2009-07-30 14:51:21.73 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.73 spid111 Buffer Distribution: Stolen=46748 Free=8653 Procedures=99845...
2009-07-30 14:51:21.63 spid124 Insufficient memory available..
2009-07-30 14:51:21.63 spid124 Error: 17803, Severity: 20, State: 12
2009-07-30 14:51:21.63 spid124 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid124 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid124 Dynamic Memory Manager: Stolen=152744 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid124 Procedure Cache: TotalProcs=63806 TotalPages=105919 InUsePages=49532
2009-07-30 14:51:21.63 spid124 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid124 Buffer Distribution: Stolen=46944 Free=2380 Procedures=105919...
2009-07-30 14:51:21.63 spid67 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid134 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 spid67 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid134 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 spid67 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid134 Dynamic Memory Manager: Stolen=152829 OS Reserved=1160 ...
2009-07-30 14:51:21.63 spid67 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid134 Procedure Cache: TotalProcs=63805 TotalPages=105988 InUsePages=49582
2009-07-30 14:51:21.63 spid67 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid134 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 spid67 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 spid134 Buffer Distribution: Stolen=46946 Free=2309 Procedures=105988...
2009-07-30 14:51:21.63 server Insufficient memory available..
2009-07-30 14:51:21.63 server Error: 17803, Severity: 20, State: 14
2009-07-30 14:51:21.63 server Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.63 server Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.63 server Dynamic Memory Manager: Stolen=152911 OS Reserved=1160 ...
2009-07-30 14:51:21.63 server Procedure Cache: TotalProcs=63805 TotalPages=106074 InUsePages=49628
2009-07-30 14:51:21.63 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776911...
2009-07-30 14:51:21.63 server Buffer Distribution: Stolen=46947 Free=2222 Procedures=106074...
2009-07-30 14:51:21.60 spid127 BPool::Map: no remappable address found.
2009-07-30 14:51:21.60 spid115 BPool::Map: no remappable address found.
2009-07-30 14:51:21.59 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.56 spid111 Query Memory Manager: Grants=1 Waiting=0 Maximum=74643 Available=74481
2009-07-30 14:51:21.56 spid111 Global Memory Objects: Resource=2663 Locks=229 ...
2009-07-30 14:51:21.56 spid111 Dynamic Memory Manager: Stolen=155138 OS Reserved=1160 ...
2009-07-30 14:51:21.56 spid111 Procedure Cache: TotalProcs=63819 TotalPages=108288 InUsePages=50762
2009-07-30 14:51:21.56 spid111 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776916...
2009-07-30 14:51:21.56 spid111 Buffer Distribution: Stolen=46955 Free=0 Procedures=108288...
2009-07-30 14:51:21.51 spid71 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid102 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid119 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid136 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid134 BPool::Map: no remappable address found.
2009-07-30 14:51:21.45 spid133 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 spid100 BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server BPool::Map: no remappable address found.
2009-07-30 14:51:21.43 server 3 pages have a bstat of 000209
2009-07-30 14:51:21.43 server 103 pages have a bstat of 00000b
2009-07-30 14:51:21.43 server 268 pages have a bstat of 000009
2009-07-30 14:51:21.43 server 63819 pages have a bstat of 001001
2009-07-30 14:51:21.43 server 91415 pages have a bstat of 000000
2009-07-30 14:51:21.41 server There are 155608 pages in the AWE window
2009-07-30 14:51:21.41 server AWE mapping status:
2009-07-30 14:51:21.41 spid111 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid131 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid67 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid69 BPool::Map: no remappable address found.
2009-07-30 14:51:21.41 spid124 BPool::Map: no remappable address found.
2009-07-30 14:50:06.27 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 14:45:04.05 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:45:03.18 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:44:10.64 spid99 Insufficient memory available..
2009-07-30 11:44:10.64 spid99 Error: 17803, Severity: 20, State: 8
2009-07-30 11:44:10.64 spid99 Query Memory Manager: Grants=2 Waiting=0 Maximum=30163 Available=29943
2009-07-30 11:44:10.64 spid99 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid99 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid99 Procedure Cache: TotalProcs=63112 TotalPages=101774 InUsePages=46494
2009-07-30 11:44:10.64 spid99 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid99 Buffer Distribution: Stolen=52285 Free=1194 Procedures=101774...
2009-07-30 11:44:10.64 spid89 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.64 spid89 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.64 spid89 Dynamic Memory Manager: Stolen=153973 OS Reserved=1176 ...
2009-07-30 11:44:10.64 spid89 Procedure Cache: TotalProcs=63239 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.64 spid89 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.64 spid89 Buffer Distribution: Stolen=52282 Free=1194 Procedures=101777...
2009-07-30 11:44:10.53 spid78 Insufficient memory available..
2009-07-30 11:44:10.53 spid78 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid78 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid78 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid78 Dynamic Memory Manager: Stolen=151088 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid78 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid78 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid78 Buffer Distribution: Stolen=49427 Free=4049 Procedures=101777...
2009-07-30 11:44:10.53 spid119 Insufficient memory available..
2009-07-30 11:44:10.53 spid119 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.53 spid119 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.53 spid119 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.53 spid119 Dynamic Memory Manager: Stolen=151051 OS Reserved=1160 ...
2009-07-30 11:44:10.53 spid119 Procedure Cache: TotalProcs=63401 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.53 spid119 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.53 spid119 Buffer Distribution: Stolen=49405 Free=4071 Procedures=101777...
2009-07-30 11:44:10.51 spid113 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.51 spid113 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.51 spid113 Dynamic Memory Manager: Stolen=150592 OS Reserved=1160 ...
2009-07-30 11:44:10.51 spid113 Procedure Cache: TotalProcs=64144 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.51 spid113 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.51 spid113 Buffer Distribution: Stolen=48932 Free=4544 Procedures=101777...
2009-07-30 11:44:10.50 spid79 Query Memory Manager: Grants=1 Waiting=0 Maximum=30163 Available=30001
2009-07-30 11:44:10.50 spid79 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.50 spid79 Dynamic Memory Manager: Stolen=150182 OS Reserved=1160 ...
2009-07-30 11:44:10.50 spid79 Procedure Cache: TotalProcs=64326 TotalPages=101777 InUsePages=46494
2009-07-30 11:44:10.50 spid79 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.50 spid79 Buffer Distribution: Stolen=48517 Free=4959 Procedures=101777...
2009-07-30 11:44:10.45 spid69 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid69 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid69 Dynamic Memory Manager: Stolen=148599 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid69 Procedure Cache: TotalProcs=64912 TotalPages=101764 InUsePages=46494
2009-07-30 11:44:10.45 spid69 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid69 Buffer Distribution: Stolen=47052 Free=6437 Procedures=101764...
2009-07-30 11:44:10.45 spid109 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.45 spid109 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.45 spid109 Dynamic Memory Manager: Stolen=148597 OS Reserved=1160 ...
2009-07-30 11:44:10.45 spid109 Procedure Cache: TotalProcs=64129 TotalPages=101761 InUsePages=46494
2009-07-30 11:44:10.45 spid109 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.45 spid109 Buffer Distribution: Stolen=47053 Free=6439 Procedures=101761...
2009-07-30 11:44:10.43 spid115 Insufficient memory available..
2009-07-30 11:44:10.43 spid115 Error: 17803, Severity: 20, State: 12
2009-07-30 11:44:10.43 spid115 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid126 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.43 spid115 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid126 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.43 spid115 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid126 Dynamic Memory Manager: Stolen=148605 OS Reserved=1160 ...
2009-07-30 11:44:10.43 spid115 Procedure Cache: TotalProcs=64666 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid126 Procedure Cache: TotalProcs=64612 TotalPages=101770 InUsePages=46494
2009-07-30 11:44:10.43 spid115 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid126 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.43 spid115 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.43 spid126 Buffer Distribution: Stolen=47053 Free=6430 Procedures=101770...
2009-07-30 11:44:10.39 spid112 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.39 spid112 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.39 spid112 Dynamic Memory Manager: Stolen=150401 OS Reserved=1160 ...
2009-07-30 11:44:10.39 spid112 Procedure Cache: TotalProcs=65207 TotalPages=103561 InUsePages=47324
2009-07-30 11:44:10.39 spid112 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.39 spid112 Buffer Distribution: Stolen=47065 Free=4627 Procedures=103561...
2009-07-30 11:44:10.31 server Insufficient memory available..
2009-07-30 11:44:10.31 server Error: 17803, Severity: 20, State: 14
2009-07-30 11:44:10.31 spid95 Insufficient memory available..
2009-07-30 11:44:10.31 spid95 Error: 17803, Severity: 20, State: 7
2009-07-30 11:44:10.31 spid95 Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.31 spid95 Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.31 spid95 Dynamic Memory Manager: Stolen=153217 OS Reserved=1160 ...
2009-07-30 11:44:10.31 spid95 Procedure Cache: TotalProcs=65654 TotalPages=106363 InUsePages=48694
2009-07-30 11:44:10.31 spid95 Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.31 spid95 Buffer Distribution: Stolen=47082 Free=1808 Procedures=106363...
2009-07-30 11:44:10.29 server Query Memory Manager: Grants=2 Waiting=0 Maximum=75534 Available=75210
2009-07-30 11:44:10.29 server Global Memory Objects: Resource=2547 Locks=193 ...
2009-07-30 11:44:10.29 server Dynamic Memory Manager: Stolen=153317 OS Reserved=1160 ...
2009-07-30 11:44:10.29 server Procedure Cache: TotalProcs=65654 TotalPages=106461 InUsePages=48752
2009-07-30 11:44:10.29 server Buffer Counts: Commited=3932160 Target=3932160 Hashed=3776896...
2009-07-30 11:44:10.29 server Buffer Distribution: Stolen=47083 Free=1709 Procedures=106461...
2009-07-30 11:44:10.21 spid119 BPool::Map: no remappable address found.
2009-07-30 11:44:10.20 spid99 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid109 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid69 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 BPool::Map: no remappable address found.
2009-07-30 11:44:10.17 spid126 3 pages have a bstat of 000209
2009-07-30 11:44:10.17 spid126 116 pages have a bstat of 00000b
2009-07-30 11:44:10.17 spid126 270 pages have a bstat of 000009
2009-07-30 11:44:10.17 spid126 65671 pages have a bstat of 001001
2009-07-30 11:44:10.17 spid126 89548 pages have a bstat of 000000
2009-07-30 11:44:10.17 spid126 There are 155608 pages in the AWE window
2009-07-30 11:44:10.17 spid126 AWE mapping status:
2009-07-30 11:44:10.17 spid79 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid95 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 server BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid115 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid78 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid89 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid112 BPool::Map: no remappable address found.
2009-07-30 11:44:10.15 spid113 BPool::Map: no remappable address found.
2009-07-30 11:40:04.69 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
2009-07-30 11:35:03.02 backup Log backed up: Database: eFoxSFCMAX2, creation date(time): 2009/07/04(17:35:01)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-662561/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Error: 17803, Severity: 20, State: 12Error
- Error: 9002, Severity: 17, State: 6Error
- Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk spaceErrorDatabase
- Basically Available（基本可用），Soft stateAI
- SAPOSCOL not running (Shared memory not available)AI
- ORA-00020: No more process state objects available故障一例ObjectAI
- [20191211]Free SGA Memory Available.txtAI
- [ASP.NET State service] errorASP.NETError
- An out of memory error has occurred.Error
- tomcat--because there was insufficient free space available after evicting expired cache entriesTomcatAI
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- ORA-29278: SMTP transient error: 421 Service not availableErrorAI
- linux CentOS出現Error: xz compression not availableLinuxCentOSErrorAI
- note the ORA-27102: out of memory errorError
- alter table engine=memory ERROR 1114Error
- 【ERROR】su user報'This account is currently not available'錯誤 for linuxErrorAILinux
- Git bash Error: Could not fork child process: There are no available terminals (-1)GitErrorAI
- YaST2 error: (gnomesu): CRITICAL **: There are no services for 'libgnomesu' available.ASTErrorAI
- R12 help--diagnostics--examine gives function not available errorFunctionAIError
- Docker無法執行java虛擬機器報錯There is insufficient memory for the Java RuntimeDockerJava虛擬機
- SP2-0642: SQL*Plus internal error state 2165SQLError
- oninit -vy 出錯： Fatal error in shared memory creation 以及 shared memory already existsError
- k8s kubectl top pod報錯error Metrics API not availableK8SErrorAPIAI
- 【ERROR】ORA-27102: out of memory 解決方法Error
- Oracle 12c In-Memory Option - 7Oracle
- [Error Code: 904, SQL State: 42000] ORA-00904 : 識別符號無效ErrorSQL符號
- android 開發遇到的問題 ：Installation error: INSTALL_FAILED_INSUFFICIENT_STORAGEAndroidErrorAI
- ORA-27102:out of memory Linux-x86_64 Error: 12: Cannot allocate memory的處理LinuxError
- RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not availableErrorUXDatabaseOracleAI
- 談談BUG嚴重級別(severity)管理
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- ?WARNING: ASM communication error: op 0 state 0x0 (15055)ASMError
- Error Domain=kAFAssistantErrorDomain Code=7ErrorAI
- Composer 記憶體不足解決方案 PHP Fatal error: Out of memory記憶體PHPError
- ORA-27102: out of memory Linux Error: 28: No space left on deviceLinuxErrordev
- 帝國CMSr的Fatal error:Allowed memory size of的解決辦法Error
- ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available fErrorAI
- ORA-20000: Insufficient privileges to analyze an object in SchemaObject