oracle数据库 10点左右卡,求助：每晚10至11点,数据库CPU占用100%

最新推荐文章于 2024-01-14 21:24:46 发布

崔海龙

最新推荐文章于 2024-01-14 21:24:46 发布

阅读量359

点赞数

文章标签： oracle数据库 10点左右卡

Instance Activity Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------

CPU used by this session 616,402 314.0 21.4

CPU used when call started 616,403 314.0 21.4

CR blocks created 2,713 1.4 0.1

Cached Commit SCN referenced 0 0.0 0.0

DBWR buffers scanned 0 0.0 0.0

DBWR checkpoint buffers written 12,363 6.3 0.4

DBWR checkpoints 0 0.0 0.0

DBWR free buffers found 0 0.0 0.0

DBWR lru scans 0 0.0 0.0

DBWR make free requests 0 0.0 0.0

DBWR revisited being-written buff 0 0.0 0.0

DBWR summed scan depth 0 0.0 0.0

DBWR transaction table writes 270 0.1 0.0

DBWR undo block writes 1,519 0.8 0.1

PX local messages recv'd 0 0.0 0.0

PX local messages sent 0 0.0 0.0

SQL*Net roundtrips to/from client 442,057 225.2 15.4

SQL*Net roundtrips to/from dblink 0 0.0 0.0

background checkpoints completed 0 0.0 0.0

background checkpoints started 0 0.0 0.0

background timeouts 2,606 1.3 0.1

branch node splits 0 0.0 0.0

buffer is not pinned count 98,725,444 50,293.2 3,432.3

buffer is pinned count 7,995,563,564 4,073,134.8 277,971.2

bytes received via SQL*Net from c 25,528,948 13,005.1 887.5

bytes received via SQL*Net from d 0 0.0 0.0

bytes sent via SQL*Net to client 25,731,142 13,108.1 894.6

bytes sent via SQL*Net to dblink 0 0.0 0.0

calls to get snapshot scn: kcmgss 191,319 97.5 6.7

calls to kcmgas 30,029 15.3 1.0

calls to kcmgcs 331 0.2 0.0

change write time 339 0.2 0.0

cleanouts and rollbacks - consist 1 0.0 0.0

cleanouts only - consistent read 65 0.0 0.0

cluster key scan block gets 1,071 0.6 0.0

cluster key scans 145 0.1 0.0

commit cleanout failures: block l 0 0.0 0.0

commit cleanout failures: buffer 0 0.0 0.0

commit cleanout failures: callbac 65 0.0 0.0

commit cleanout failures: cannot 11 0.0 0.0

commit cleanouts 83,412 42.5 2.9

commit cleanouts successfully com 83,336 42.5 2.9

consistent changes 37,198 19.0 1.3

consistent gets 108,715,322 55,382.2 3,779.6

current blocks converted for CR

cursor authentications 1,870 1.0 0.1

data blocks consistent reads - un 37,198 19.0 1.3

db block changes 237,055 120.8 8.2

db block gets 463,984 236.4 16.1

deferred (CURRENT) block cleanout 43,292 22.1 1.5

dirty buffers inspected 0 0.0 0.0

enqueue conversions 0 0.0 0.0

enqueue releases 63,616 32.4 2.2

enqueue requests 63,616 32.4 2.2

enqueue timeouts 0 0.0 0.0

enqueue waits 0 0.0 0.0

Instance Activity Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------

exchange deadlocks 0 0.0 0.0

execute count 132,193 67.3 4.6

free buffer inspected 33 0.0 0.0

free buffer requested 494,552 251.9 17.2

hot buffers moved to head of LRU 3,742 1.9 0.1

immediate (CR) block cleanout app 66 0.0 0.0

immediate (CURRENT) block cleanou 4,779 2.4 0.2

index fast full scans (full) 0 0.0 0.0

leaf node splits 113 0.1 0.0

logons cumulative 2,145 1.1 0.1

messages received 30,415 15.5 1.1

messages sent 30,415 15.5 1.1

no buffer to keep pinned count 0 0.0 0.0

no work - consistent read gets 108,342,594 55,192.4 3,766.6

opened cursors cumulative 85,171 43.4 3.0

parse count (hard) 4,695 2.4 0.2

parse count (total) 86,268 44.0 3.0

parse time cpu 1,143 0.6 0.0

parse time elapsed 4,058 2.1 0.1

physical reads 504,936 257.2 17.6

physical reads direct 14,985 7.6 0.5

physical writes 27,348 13.9 1.0

physical writes direct 14,985 7.6 0.5

physical writes non checkpoint 18,124 9.2 0.6

pinned buffers inspected 1 0.0 0.0

prefetched blocks 424,062 216.0 14.7

prefetched blocks aged out before 6 0.0 0.0

process last non-idle time ################ ############ ############

recursive calls 186,004 94.8 6.5

recursive cpu usage 1,137 0.6 0.0

redo blocks written 91,225 46.5 3.2

redo buffer allocation retries 0 0.0 0.0

redo entries 121,363 61.8 4.2

redo log space requests 0 0.0 0.0

redo log space wait time 0 0.0 0.0

redo ordering marks 0 0.0 0.0

redo size 37,833,848 19,273.5 1,315.3

redo synch time 42,275 21.5 1.5

redo synch writes 28,814 14.7 1.0

redo wastage 7,584,600 3,863.8 263.7

redo write time 2,991 1.5 0.1

redo writer latching time 58 0.0 0.0

redo writes 29,565 15.1 1.0

rollback changes - undo records a 3 0.0 0.0

rollbacks only - consistent read 3,164 1.6 0.1

rows fetched via callback 41,489 21.1 1.4

session connect time ################ ############ ############

session logical reads 109,179,328 55,618.6 3,795.7

session pga memory 3,824,440,260 1,948,263.0 132,959.3

session pga memory max 5,552,887,956 2,828,776.3 193,049.9

session uga memory 11,064,308 5,636.4 384.7

session uga memory max 64,437,136 32,825.9 2,240.2

sorts (disk) 2 0.0 0.0

sorts (memory) 2,238 1.1 0.1

sorts (rows) 45,501,663 23,179.7 1,581.9

summed dirty queue length 0 0.0 0.0

Instance Activity Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------

switch current to new buffer

table fetch by rowid 4,044,994,648 2,060,618.8 140,627.0

table fetch continued row 0 0.0 0.0

table scan blocks gotten 4,213,177 2,146.3 146.5

table scan rows gotten 228,328,194 116,315.9 7,938.0

table scans (direct read) 0 0.0 0.0

table scans (long tables) 407 0.2 0.0

table scans (rowid ranges) 0 0.0 0.0

table scans (short tables) 42,975 21.9 1.5

total file opens 973 0.5 0.0

transaction rollbacks 1 0.0 0.0

transaction tables consistent rea 0 0.0 0.0

user calls 447,773 228.1 15.6

user commits 28,764 14.7 1.0

user rollbacks 0 0.0 0.0

write clones created in backgroun 0 0.0 0.0

write clones created in foregroun 2 0.0 0.0

-------------------------------------------------------------

Tablespace IO Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

->ordered by IOs (Reads + Writes) desc

Tablespace

------------------------------

Av Av Av Av Buffer Av Buf

Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)

-------------- ------- ------ ------- ------------ -------- ---------- ------

BEIJING_DATA

64,620 33 0.4 7.5 10,122 5 23 70.9

TEMP

6,339 3 7.8 2.4 3,754 2 0 0.0

RBS

0 0 0.0 1,793 1 3 3.3

TVGAME_DATA

887 0 0.7 2.5 122 0 0 0.0

PERFSTAT_DATA

416 0 3.9 1.0 323 0 0 0.0

SYSTEM

4 0 7.5 1.0 52 0 0 0.0

USER_ENGINE_DATA

2 0 20.0 1.0 0 0 0 0.0

DATACENTER_DATA

1 0 220.0 1.0 0 0 0 0.0

-------------------------------------------------------------

File IO Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

->ordered by Tablespace, File

Tablespace Filename

------------------------ ----------------------------------------------------

Av Av Av Av Buffer Av Buf

Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)

-------------- ------- ------ ------- ------------ -------- ---------- ------

BEIJING_DATA /u01/app/oracle/oradata/southdb/beijing_data01.dbf

955 0 0.6 7.8 205 0 0

/u01/app/oracle/oradata/southdb/beijing_data02.dbf

954 0 0.6 7.8 200 0 2 0.0

/u01/app/oracle/oradata/southdb/beijing_data03.dbf

948 0 0.9 7.9 152 0 0

/u01/app/oracle/oradata/southdb/beijing_data04.dbf

940 0 0.4 7.9 138 0 0

/u01/app/oracle/oradata/southdb/beijing_data05.dbf

943 0 0.5 7.9 217 0 0

/u01/app/oracle/oradata/southdb/beijing_data06.dbf

956 0 0.9 7.8 114 0 0

/u01/app/oracle/oradata/southdb/beijing_data07.dbf

938 0 0.2 7.9 123 0 0

/u01/app/oracle/oradata/southdb/beijing_data08.dbf

947 0 1.4 7.9 217 0 0

/u01/app/oracle/oradata/southdb/beijing_data09.dbf

954 0 0.9 7.8 202 0 0

/u01/app/oracle/oradata/southdb/beijing_data10.dbf

949 0 0.6 7.8 401 0 1 130.0

/u01/app/oracle/oradata/southdb/beijing_data11.dbf

939 0 0.2 7.9 208 0 0

/u01/app/oracle/oradata/southdb/beijing_data12.dbf

968 0 0.5 7.9 183 0 0

/u01/app/oracle/oradata/southdb/beijing_data13.dbf

970 0 0.9 7.9 168 0 0

/u01/app/oracle/oradata/southdb/beijing_data14.dbf

965 0 0.5 7.9 96 0 0

/u01/app/oracle/oradata/southdb/beijing_data15.dbf

974 0 0.2 7.9 189 0 0

/u01/app/oracle/oradata/southdb/beijing_data16.dbf

970 0 0.5 7.9 167 0 0

/u01/app/oracle/oradata/southdb/beijing_data17.dbf

964 0 0.3 7.9 134 0 0

/u01/app/oracle/oradata/southdb/beijing_data18.dbf

969 0 0.3 7.9 147 0 0

/u01/app/oracle/oradata/southdb/beijing_data19.dbf

976 0 0.4 7.9 129 0 0

/u01/app/oracle/oradata/southdb/beijing_data20.dbf

4,219 2 0.1 8.0 97 0 0

/u01/app/oracle/oradata/southdb/beijing_data21.dbf

4,227 2 0.2 8.0 98 0 0

/u01/app/oracle/oradata/southdb/beijing_data22.dbf

4,237 2 0.3 7.9 148 0 0

/u01/app/oracle/oradata/southdb/beijing_data23.dbf

4,250 2 0.4 7.9 242 0 0

/u01/app/oracle/oradata/southdb/beijing_data24.dbf

4,214 2 0.3 7.9 240 0 0

/u01/app/oracle/oradata/southdb/beijing_data25.dbf

4,216 2 0.3 7.9 520 0 0

/u01/app/oracle/oradata/southdb/beijing_data26.dbf

4,261 2 0.4 7.9 487 0 0

File IO Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

->ordered by Tablespace, File

Tablespace Filename

------------------------ ----------------------------------------------------

Av Av Av Av Buffer Av Buf

Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)

-------------- ------- ------ ------- ------------ -------- ---------- ------

BEIJING_DATA /u01/app/oracle/oradata/southdb/beijing_data27.dbf

4,254 2 0.4 7.9 630 0 0

/u01/app/oracle/oradata/southdb/beijing_data28.dbf

4,931 3 0.4 3.1 978 0 19 78.9

/u01/app/oracle/oradata/southdb/beijing_data29.dbf

478 0 0.7 7.8 780 0 0

/u01/app/oracle/oradata/southdb/beijing_data30.dbf

477 0 0.5 7.8 260 0 0

/u01/app/oracle/oradata/southdb/beijing_data31.dbf

478 0 0.8 7.8 492 0 0

/u01/app/oracle/oradata/southdb/beijing_data32.dbf

467 0 0.6 8.0 171 0 0

/u01/app/oracle/oradata/southdb/beijing_data33.dbf

468 0 0.1 7.9 359 0 0

/u01/app/oracle/oradata/southdb/beijing_data34.dbf

464 0 0.1 8.0 185 0 0

/u01/app/oracle/oradata/southdb/beijing_data35.dbf

496 0 0.1 8.0 62 0 0

/u01/app/oracle/oradata/southdb/beijing_data36.dbf

500 0 0.2 7.9 90 0 0

/u01/app/oracle/oradata/southdb/beijing_data37.dbf

929 0 0.1 8.0 41 0 0

/u01/app/oracle/oradata/southdb/beijing_data38.dbf

942 0 0.4 7.9 50 0 0

/u01/app/oracle/oradata/southdb/beijing_data39.dbf

953 0 0.3 7.8 240 0 1 0.0

/u01/app/oracle/oradata/southdb/beijing_data40.dbf

980 0 0.7 7.6 562 0 0

DATACENTER_DATA /u01/app/oracle/oradata/southdb/datacenter_data01.db

1 0 220.0 1.0 0 0 0

PERFSTAT_DATA /u01/app/oracle/oradata/southdb/perfstat_data01.dbf

226 0 4.6 1.0 181 0 0

/u01/app/oracle/oradata/southdb/perfstat_data02.dbf

190 0 3.1 1.0 142 0 0

RBS /u01/app/oracle/oradata/southdb/rbs01.dbf

0 0 340 0 0

/u01/app/oracle/oradata/southdb/rbs02.dbf

0 0 225 0 1 10.0

/u01/app/oracle/oradata/southdb/rbs03.dbf

0 0 293 0 1 0.0

/u01/app/oracle/oradata/southdb/rbs04.dbf

0 0 107 0 0

/u01/app/oracle/oradata/southdb/rbs05.dbf

0 0 260 0 0

/u01/app/oracle/oradata/southdb/rbs06.dbf

0 0 134 0 0

/u01/app/oracle/oradata/southdb/rbs07.dbf

0 0 94 0 0

File IO Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

->ordered by Tablespace, File

Tablespace Filename

------------------------ ----------------------------------------------------

Av Av Av Av Buffer Av Buf

Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)

-------------- ------- ------ ------- ------------ -------- ---------- ------

RBS /u01/app/oracle/oradata/southdb/rbs08.dbf

0 0 65 0 0

/u01/app/oracle/oradata/southdb/rbs09.dbf

0 0 78 0 0

/u01/app/oracle/oradata/southdb/rbs10.dbf

0 0 122 0 0

/u01/app/oracle/oradata/southdb/rbs11.dbf

0 0 75 0 1 0.0

SYSTEM /u01/app/oracle/oradata/southdb/system01.dbf

4 0 7.5 1.0 52 0 0

TEMP /u01/app/oracle/oradata/southdb/temp01.dbf

6,339 3 7.8 2.4 3,754 2 0

TVGAME_DATA /u01/app/oracle/oradata/southdb/tvgame_data01.dbf

0 0 16 0 0

/u01/app/oracle/oradata/southdb/tvgame_data02.dbf

9 0 2.2 2.9 3 0 0

/u01/app/oracle/oradata/southdb/tvgame_data03.dbf

5 0 4.0 1.2 11 0 0

/u01/app/oracle/oradata/southdb/tvgame_data04.dbf

10 0 6.0 1.6 14 0 0

/u01/app/oracle/oradata/southdb/tvgame_data05.dbf

2 0 5.0 4.5 3 0 0

/u01/app/oracle/oradata/southdb/tvgame_data06.dbf

1 0 10.0 2.0 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data08.dbf

11 0 3.6 7.3 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data09.dbf

6 0 6.7 8.0 15 0 0

/u01/app/oracle/oradata/southdb/tvgame_data10.dbf

18 0 3.9 8.0 14 0 0

/u01/app/oracle/oradata/southdb/tvgame_data11.dbf

17 0 2.4 8.0 22 0 0

/u01/app/oracle/oradata/southdb/tvgame_data12.dbf

21 0 3.3 8.0 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data13.dbf

16 0 2.5 8.0 3 0 0

/u01/app/oracle/oradata/southdb/tvgame_data14.dbf

16 0 3.8 8.0 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data15.dbf

736 0 0.1 1.6 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data16.dbf

16 0 3.8 8.0 11 0 0

/u01/app/oracle/oradata/southdb/tvgame_data17.dbf

1 0 20.0 5.0 0 0 0

/u01/app/oracle/oradata/southdb/tvgame_data18.dbf

0 0 2 0 0

/u01/app/oracle/oradata/southdb/tvgame_data19.dbf

1 0 0.0 1.0 7 0 0

/u01/app/oracle/oradata/southdb/tvgame_data20.dbf

File IO Stats for DB: SOUTHDB Instance: southdb Snaps: 101 -102

->ordered by Tablespace, File

Tablespace Filename

------------------------ ----------------------------------------------------

Av Av Av Av Buffer Av Buf

Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)

-------------- ------- ------ ------- ------------ -------- ---------- ------

1 0 0.0 1.0 1 0 0

USER_ENGINE_DATA /u01/app/oracle/oradata/southdb/user_engine_data01.d

2 0 20.0 1.0 0 0 0

-------------------------------------------------------------

Buffer Pool Statistics for DB: SOUTHDB Instance: southdb Snaps: 101 -102

-> Pools D: default pool, K: keep pool, R: recycle pool

Free Write Buffer

Buffer Consistent Physical Physical Buffer Complete Busy

P Gets Gets Reads Writes Waits Waits Waits

- ----------- ------------- ----------- ---------- ------- -------- ----------

D 494,579 108,370,283 489,978 12,363 0 0 26

-------------------------------------------------------------

崔海龙

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle数据库 10点左右卡,求助：每晚10至11点,数据库CPU占用100%

Instance Activity Stats for DB: SOUTHDBInstance: southdbSnaps: 101 -102Statistic Total per Second per Trans--------------------------------- ---------------...
复制链接

扫一扫