Oracle - AWR - 教你如何看 - 图文(16)

Back to Streams Statistics Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics Back to Top

Resource Limit Stats

? ?

only rows with Current or Maximum Utilization > 80% of Limit are shown ordered by resource name

Limit 450063 450063 Resource Name Current Utilization Maximum Utilization Initial Allocation gcs_resources gcs_shadows 349,392 400,300 446,903 450063 447,369 450063

Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different) audit_file_dest background_dump_dest cluster_database cluster_database_instances compatible control_files core_dump_dest db_block_size db_domain db_name dispatchers instance_number job_queue_processes open_cursors pga_aggregate_target processes remote_listener remote_login_passwordfile sga_max_size sga_target sort_area_size spfile thread undo_management undo_retention undo_tablespace user_dump_dest /oracle/app/oracle/admin/ICCI/adump /oracle/app/oracle/admin/ICCI/bdump TRUE 2 10.2.0.3.0 /oracle/app/oracle/admin/ICCI/cdump 8192 ICCI (PROTOCOL=TCP) (SERVICE=ICCIXDB) 1 10 800 1073741824 500 LISTENERS_ICCI EXCLUSIVE 4294967296 4294967296 196608 /dev/rora_SPFILE 1 AUTO 900 UNDOTBS1 /oracle/app/oracle/admin/ICCI/udump /dev/rora_CTL01, /dev/rora_CTL02, /dev/rora_CTL03 db_file_multiblock_read_count 16

Back to Top

More RAC Statistics ? ? ? ?

Global Enqueue Statistics Global CR Served Stats Global CURRENT Served Stats Global Cache Transfer Stats Back to Top

Global Enqueue Statistics

Statistic acks for commit broadcast(actual) acks for commit broadcast(logical) broadcast msgs on commit(actual) Total 18,537 21,016 5,193 per Second per Trans 3.92 4.45 1.10 3.31 3.75 0.93 broadcast msgs on commit(logical) broadcast msgs on commit(wasted) dynamically allocated gcs resources dynamically allocated gcs shadows false posts waiting for scn acks flow control messages received flow control messages sent gcs assume cvt gcs assume no cvt gcs ast xid gcs blocked converts gcs blocked cr converts gcs compatible basts gcs compatible cr basts (global) gcs compatible cr basts (local) gcs cr basts to PIs gcs cr serve without current lock gcs dbwr flush pi msgs gcs dbwr write request msgs gcs error msgs gcs forward cr to pinged instance gcs immediate (compatible) converts gcs immediate (null) converts gcs immediate cr (compatible) converts gcs immediate cr (null) converts gcs indirect ast gcs lms flush pi msgs gcs lms write request msgs gcs msgs process time(ms) gcs msgs received gcs out-of-order msgs gcs pings refused gcs pkey conflicts retry gcs queued converts gcs recovery claim msgs gcs refuse xid gcs regular cr gcs retry convert request gcs side channel msgs actual gcs side channel msgs logical gcs stale cr gcs undo cr gcs write notification msgs gcs writes refused ges msgs process time(ms) ges msgs received global posts dropped global posts queue time global posts queued global posts requested 5,491 450 0 0 0 0 2 0 9,675 1 7,099 8,442 45 273 12,593 0 0 223 223 0 0 2,998 170,925 0 722,748 306,817 0 189 16,164 1,792,132 0 0 0 2 0 0 0 0 437 21,086 3,300 5 23 3 1,289 138,891 0 0 0 0 1.16 0.10 0.00 0.00 0.00 0.00 0.00 0.00 2.05 0.00 1.50 1.79 0.01 0.06 2.66 0.00 0.00 0.05 0.05 0.00 0.00 0.63 36.16 0.00 152.88 64.90 0.00 0.04 3.42 379.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.09 4.46 0.70 0.00 0.00 0.00 0.27 29.38 0.00 0.00 0.00 0.00 0.98 0.08 0.00 0.00 0.00 0.00 0.00 0.00 1.73 0.00 1.27 1.51 0.01 0.05 2.25 0.00 0.00 0.04 0.04 0.00 0.00 0.54 30.53 0.00 129.11 54.81 0.00 0.03 2.89 320.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.08 3.77 0.59 0.00 0.00 0.00 0.23 24.81 0.00 0.00 0.00 0.00 global posts sent implicit batch messages received implicit batch messages sent lmd msg send time(ms) lms(s) msg send time(ms) messages flow controlled messages queue sent actual messages queue sent logical messages received actual messages received logical messages sent directly messages sent indirectly messages sent not implicit batched messages sent pbatched msgs causing lmd to send msgs msgs causing lms(s) to send msgs msgs received queue time (ms) msgs received queued msgs sent queue time (ms) msgs sent queue time on ksxp (ms) msgs sent queued msgs sent queued on ksxp process batch messages received process batch messages sent 0 81,181 19,561 0 0 15,306 108,411 222,518 474,202 1,931,144 25,742 137,725 88,859 1,050,224 61,682 85,978 911,013 1,931,121 5,651 66,767 215,124 243,729 120,003 181,019 0.00 17.17 4.14 0.00 0.00 3.24 22.93 47.07 100.31 408.50 5.45 29.13 18.80 222.16 13.05 18.19 192.71 408.50 1.20 14.12 45.51 51.56 25.38 38.29 0.00 14.50 3.49 0.00 0.00 2.73 19.37 39.75 84.71 344.97 4.60 24.60 15.87 187.61 11.02 15.36 162.74 344.97 1.01 11.93 38.43 43.54 21.44 32.34

Back to Top

Global CR Served Stats

Statistic CR Block Requests CURRENT Block Requests Data Block Requests Undo Block Requests TX Block Requests Current Results Private results Zero Results Disk Read Results Fail Results Fairness Down Converts Fairness Clears Free GC Elements Flushes Flushes Queued Flush Queue Full Flush Max Time (us) Light Works Errors Total 10,422 251 10,422 2 20 10,664 4 5 0 0 1,474 0 0 370 0 0 0 2 0

Back to Top

Global CURRENT Served Stats

? ? ?

Pins = CURRENT Block Pi …… 此处隐藏：4349字，全部文档内容请下载后查看。喜欢就下载吧 ……