oracle10g生成awr报告,oracle 10g 生成awr报告过程

最新推荐文章于 2021-04-09 23:15:27 发布
最新推荐文章于 2021-04-09 23:15:27 发布
阅读量317 收藏
点赞数
文章标签： oracle10g生成awr报告

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

[oracle@204_maridb ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 1 16:08:08 2019

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> var snap_id number

SQL> exec :snap_id:=dbms_workload_repository.create_snapshot

PL/SQL procedure successfully completed.

SQL> print snap_id

SNAP_ID

52434

SQL> @?/rdbms/admin/awrrpt.sql

Current Instance

DB Id DB Name Inst Num Instance

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

3047903966 SKODACOM 1 TSH1

Specify the Report Type

Would you like an HTML report, or a plain text report?

Enter 'html' for an HTML report, or 'text' for plain text

Defaults to 'html'

Enter value for report_type:

Type Specified: html

Instances in this Workload Repository schema

DB Id Inst Num DB Name Instance Host

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

3047903966 1 SKODACOM skodacom skodacom

3047903966 1 SKODACOM skodacom localhost.lo

caldomain

* 3047903966 1 SKODACOM TSH1 204_maridb

Using 3047903966 for database Id

Using 1 for instance number

Specify the number of days of snapshots to choose from

Entering the number of days (n) will result in the most recent

(n) days of snapshots being listed. Pressing without

specifying a number lists all completed snapshots.

Enter value for num_days: 1

Listing the last day's Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

TSH1 SKODACOM 52416 01 Jul 2019 00:00 1

52417 01 Jul 2019 01:00 1

52418 01 Jul 2019 02:00 1

52419 01 Jul 2019 03:00 1

52420 01 Jul 2019 04:01 1

52421 01 Jul 2019 05:00 1

52422 01 Jul 2019 06:00 1

52423 01 Jul 2019 07:00 1

52424 01 Jul 2019 08:00 1

52425 01 Jul 2019 09:01 1

52426 01 Jul 2019 10:00 1

52427 01 Jul 2019 11:00 1

52428 01 Jul 2019 12:00 1

52429 01 Jul 2019 13:00 1

52430 01 Jul 2019 14:00 1

52431 01 Jul 2019 15:00 1

52432 01 Jul 2019 15:20 1

52433 01 Jul 2019 16:00 1

52434 01 Jul 2019 16:08 1

Specify the Begin and End Snapshot Ids

Enter value for begin_snap: 52416

Begin Snapshot Id specified: 52416

Enter value for end_snap: 52434

End Snapshot Id specified: 52434

Specify the Report Name

The default report file name is awrrpt_1_52416_52434.html. To use this name,

press to continue, otherwise enter an alternative.

Enter value for report_name:

Using the report name awrrpt_1_52416_52434.html

AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
SKODACOM3047903966TSH1110.2.0.1.0NO204_maridb
Snap IdSnap TimeSessionsCursors/Session
Begin Snap:5241601-Jul-19 00:00:4317 2.5
End Snap:5243401-Jul-19 16:08:3117 2.3
Elapsed:  967.81 (mins)  
DB Time:  0.12 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 848M 848MStd Block Size: 8K
Shared Pool Size: 272M 272MLog Buffer: 14,408K

Load Profile

Per SecondPer Transaction
Redo size: 275.43 110,302.15
Logical reads: 6.96 2,788.01
Block changes: 1.17 467.69
Physical reads: 0.03 10.90
Physical writes: 0.11 45.72
User calls: 0.02 9.13
Parses: 0.15 61.34
Hard parses: 0.00 1.58
Sorts: 0.34 134.33
Logons: 0.00 0.41
Executes: 0.71 286.07
Transactions: 0.00 
% Blocks changed per Read: 16.78Recursive Call %: 99.55
Rollback per transaction %: 0.00Rows per Sort: 11.79

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.63In-memory Sort %: 100.00
Library Hit %: 98.79Soft Parse %: 97.43
Execute to Parse %: 78.56Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 95.45% Non-Parse CPU: 49.03

Shared Pool Statistics

BeginEnd
Memory Usage %: 54.72 58.88
% SQL with executions>1: 69.86 86.77
% Memory for SQL w/exec>1: 73.78 89.49

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
control file parallel write 19,358 50 3 689.2System I/O
log file parallel write 10,837 9 1 127.0System I/O
CPU time  6  85.0 
os thread startup 35 1 42 20.1Concurrency
db file sequential read 1,287 1 1 17.2User I/O

Main Report

Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

  • Total time in database user-calls (DB Time): 7.3s
  • Statistics including the word "background" measure background process

    time, and so do not contribute to the DB time statistic

  • Ordered by % or DB time desc, Statistic name
Statistic NameTime (s)% of DB Time
DB CPU6.1885.02
sql execute elapsed time4.9167.54
parse time elapsed3.4547.49
hard parse elapsed time3.3045.36
PL/SQL execution elapsed time1.0614.53
connection management call elapsed time0.141.87
PL/SQL compilation elapsed time0.121.69
failed parse elapsed time0.081.09
hard parse (sharing criteria) elapsed time0.020.30
sequence load elapsed time0.000.03
hard parse (bind mismatch) elapsed time0.000.03
repeated bind elapsed time0.000.02
DB time7.27 
background elapsed time138.22 
background cpu time129.06 

Back to Wait Events Statistics

Back to Top

Wait Class

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc
Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
System I/O72,7060.00601501.42
Concurrency470.001320.32
User I/O1,4990.001110.34
Other2410.00121.66
Configuration20.000260.01
Commit380.00010.26
Application120.00010.08
Network1,2960.00008.94

Back to Wait Events Statistics

Back to Top

Wait Events

  • s - second
  • cs - centisecond - 100th of a second
  • ms - millisecond - 1000th of a second
  • us - microsecond - 1000000th of a second
  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write19,3580.00503133.50
log file parallel write10,8370.009174.74
os thread startup350.001420.24
db file sequential read1,2870.00118.88
latch free200.001260.14
control file sequential read42,4160.0000292.52
db file scattered read500.00040.34
Log archive I/O470.00030.32
log file sequential read460.00010.32
log file switch completion20.000260.01
log file sync380.00010.26
latch: library cache lock50.00060.03
LGWR wait for redo copy2100.00001.45
rdbms ipc reply110.00010.08
SQLNet break/reset to client120.00010.08
SQLNet more data to client1720.00001.19
latch: shared pool10.00020.01
SQLNet message to client1,1120.00007.67
log file single write20.00010.01
latch: library cache50.00000.03
buffer busy waits10.00000.01
direct path write1360.00000.94
SQLNet more data from client120.00000.08
direct path read260.00000.18
Streams AQ: qmn slave idle wait2,0730.0056,5452727714.30
Streams AQ: qmn coordinator idle wait4,15050.0556,5451362528.62
Streams AQ: waiting for time management or cleanup tasks13100.0023,67318210250.09
SQL*Net message from client1,1120.0019,705177217.67
class slave wait3597.1416647430.24
jobq slave wait20100.005929300.14

Back to Wait Events Statistics

Back to Top

Background Wait Events

  • ordered by wait time desc, waits desc (idle events last)
EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file parallel write19,3580.00503133.50
log file parallel write10,8370.009174.74
os thread startup350.001420.24
control file sequential read29,7860.0000205.42
Log archive I/O470.00030.32
log file sequential read460.00010.32
events in waitclass Other2210.00001.52
log file single write20.00010.01
latch: library cache40.00000.03
buffer busy waits10.00000.01
direct path read80.00000.06
direct path write80.00000.06
rdbms ipc message187,70999.62610,97132551,294.54
pmon timer19,412100.0056,6802920133.88
Streams AQ: qmn slave idle wait2,0730.0056,5452727714.30
Streams AQ: qmn coordinator idle wait4,15050.0556,5451362528.62
smon timer19697.9654,9612804131.35
Streams AQ: waiting for time management or cleanup tasks13100.0023,67318210250.09

Back to Wait Events Statistics

Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME150,595
IDLE_TIME23,037,966
NICE_TIME14
SYS_TIME62,816
USER_TIME87,765
LOAD0
RSRC_MGR_CPU_WAIT_TIME0
PHYSICAL_MEMORY_BYTES161,772
NUM_CPUS4
NUM_CPU_SOCKETS4

Back to Wait Events Statistics

Back to Top

Service Statistics

  • ordered by DB Time
Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS7.306.201,517199,781
SYS$BACKGROUND0.000.0065206,296
skodacom.skodacom0.000.0000

Back to Wait Events Statistics

Back to Top

Service Wait Class Stats

  • Wait Class info for services in the Service Statistics section.
  • Total Waits and Time Waited displayed for the following wait

    classes: User I/O, Concurrency, Administrative, Network

  • Time Waited (Wt Time) in centisecond (100th of a second)
Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
SYS$USERS1162124730012191
SYS$BACKGROUND33722401470000

Back to Wait Events Statistics

Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL

    statements called by the code.

  • % Total DB Time is the Elapsed Time of the SQL statement divided

    into the Total Database Time multiplied by 100

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
99180.48119.75bunssq950snhfinsert into wrh$_sga_target_ad...
2212.3231.86572fbaj0fdw2b

sqlplus@204maridb (TNS V1-V3)

select output from table(dbms...
221,9350.0026.70aykvshm7zsabdselect size_for_estimate, ...
2211,6130.0021.46803b7z0t84sq7select job, nvl2(last_date, ...
1020.5013.8195w06sfdyppfj

navicat.exe

SELECT FROM (SELECT "NAVICAT...
1140.2312.830pt2789bczdp0

navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...
1120.3810.5315xnmd14bcfby

navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...
1110.7610.515n73rjfpt3q4b

sqlplus@204_maridb (TNS V1-V3)

BEGIN :snap_id:=dbmsworkload...
11180.049.53d92h3rjp0y217begin prvt_hdm.auto_execute( :...
1111,6130.009.02g2wr3u7s1gtf3select count() from sys.job$ ...
001070.005.77g337099aatnujupdate smon_scntime set orig...
00180.024.7784qubbrsr0kfninsert into wrh$_latch (snap...
001,8550.004.27772s25v1y0x8kselect shared_pool_size_for_es...
0040.074.0786synsm5txwj6

navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...
00170.012.13agpd044zj368minsert into wrh$_system_event ...
00160.012.1232wqka2zwvu65insert into wrh$_parameter (...
00970.001.88a1xgxtssv5rrpselect sum(used_blocks), ts.t...
0020.071.8784vvbj8g8sups

navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...
0010.131.841srfjbzhb29z8

sqlplus@204_maridb (TNS V1-V3)

 select from sys.wrh$_active...
001,0480.001.79g00cj285jmgswupdate sys.mon_mods$ set inser...
0040.031.73d5bwbakqj3f79

navicat.exe

SELECT OWNER, TABLE_NAME FROM...
00850.001.626cxqh7mktnbjminsert into smon_scn_time (thr...
001220.001.507cq8d0jqxzum1delete from smon_scn_time wher...
00170.011.43cvn54b7yz0s8uselect /+ index(idl_ub1$ i_id...
00180.011.357vgmvmy8vvb9sinsert into wrh$_tempstatxs ...
00150.011.34cfz686a6qp0kgselect o.obj#, u.name, o.nam...
0040.021.31chunmygjj8x7g

navicat.exe

SELECT OWNER, TABLE_NAME, CO...
001,6800.001.308p447s6p0rv6bselect java_pool_size_for_esti...
0020.051.250m9ka0jk9kk4z

navicat.exe

SELECT OWNER, TABLE_NAME FROM...
0010.081.108dw6saa5zu2sk

sqlplus@204_maridb (TNS V1-V3)

select

service_name, ui...

003280.001.07bsa0wjtftg3uwselect file# from file$ where ...
00160.001.05586b2udq6dbnginsert into wrh$_sysstat (sn...
00160.001.04g6wf9na8zs5hbinsert into wrh$_sysmetric_sum...

Back to SQL Statistics

Back to Top

SQL ordered by CPU Time

  • Resources reported for PL/SQL code includes the resources used by all SQL

    statements called by the code.

  • % Total DB Time is the Elapsed Time of the SQL statement divided

    into the Total Database Time multiplied by 100

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
99180.48119.75bunssq950snhfinsert into wrh$_sga_target_ad...
2212.1931.86572fbaj0fdw2b

sqlplus@204maridb (TNS V1-V3)

select output from table(dbms...
221,9350.0026.70aykvshm7zsabdselect size_for_estimate, ...
2211,6130.0021.46803b7z0t84sq7select job, nvl2(last_date, ...
1140.2312.830pt2789bczdp0

navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...
1120.3810.5315xnmd14bcfby

navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...
1110.7310.515n73rjfpt3q4b

sqlplus@204_maridb (TNS V1-V3)

BEGIN :snap_id:=dbmsworkload...
11180.049.53d92h3rjp0y217begin prvt_hdm.auto_execute( :...
1111,6130.009.02g2wr3u7s1gtf3select count() from sys.job$ ...
001070.005.77g337099aatnujupdate smon_scntime set orig...
00180.024.7784qubbrsr0kfninsert into wrh$_latch (snap...
001,8550.004.27772s25v1y0x8kselect shared_pool_size_for_es...
0120.1313.8195w06sfdyppfj

navicat.exe

SELECT FROM (SELECT "NAVICAT...
0040.064.0786synsm5txwj6

navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...
00170.012.13agpd044zj368minsert into wrh$_system_event ...
00970.001.88a1xgxtssv5rrpselect sum(used_blocks), ts.t...
0020.071.8784vvbj8g8sups

navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...
001,0480.001.79g00cj285jmgswupdate sys.mon_mods$ set inser...
0040.031.73d5bwbakqj3f79

navicat.exe

SELECT OWNER, TABLE_NAME FROM...
00850.001.626cxqh7mktnbjminsert into smon_scn_time (thr...
001220.001.507cq8d0jqxzum1delete from smon_scn_time wher...
0010.101.841srfjbzhb29z8

sqlplus@204_maridb (TNS V1-V3)

 select * from sys.wrh$_active...
00160.012.1232wqka2zwvu65insert into wrh$_parameter (...
00180.011.357vgmvmy8vvb9sinsert into wrh$_tempstatxs ...
00150.011.34cfz686a6qp0kgselect o.obj#, u.name, o.nam...
0040.021.31chunmygjj8x7g

navicat.exe

SELECT OWNER, TABLE_NAME, CO...
001,6800.001.308p447s6p0rv6bselect java_pool_size_for_esti...
0020.051.250m9ka0jk9kk4z

navicat.exe

SELECT OWNER, TABLE_NAME FROM...
0010.081.108dw6saa5zu2sk

sqlplus@204_maridb (TNS V1-V3)

select

service_name, ui...

003280.001.07bsa0wjtftg3uwselect file# from file$ where ...
00160.001.05586b2udq6dbnginsert into wrh$_sysstat (sn...
00160.001.04g6wf9na8zs5hbinsert into wrh$_sysmetric_sum...
00170.001.43cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_id...

Back to SQL Statistics

Back to Top

SQL ordered by Gets

  • Resources reported for PL/SQL code includes the resources used by all SQL

    statements called by the code.

  • Total Buffer Gets: 404,261
  • Captured SQL account for 94.8% of Total
Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
113,5821113,582.0028.102.192.32572fbaj0fdw2b

sqlplus@204maridb (TNS V1-V3)

select output from table(dbms...
38,995122319.639.650.110.117cq8d0jqxzum1delete from smon_scn_time wher...
37,90449,476.009.380.100.10chunmygjj8x7g

navicat.exe

SELECT OWNER, TABLE_NAME, CO...
34,630107323.648.570.420.42g337099aatnujupdate smon_scntime set orig...
23,79445,948.505.890.930.930pt2789bczdp0

navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...
23,22611,6132.005.751.561.56803b7z0t84sq7select job, nvl2(last_date, ...
17,97118998.394.450.690.69d92h3rjp0y217begin prvt_hdm.auto_execute( :...
11,61311,6131.002.870.660.66g2wr3u7s1gtf3select count() from sys.job$ ...
9,52515635.002.360.100.10cfz686a6qp0kgselect o.obj#, u.name, o.nam...
6,01923,009.501.490.261.0095w06sfdyppfj

navicat.exe

SELECT FROM (SELECT "NAVICAT...
5,78218321.221.430.030.0331a13pnjps7j3SELECT source, (case w...
4,94441,236.001.220.130.13d5bwbakqj3f79

navicat.exe

SELECT OWNER, TABLE_NAME FROM...
4,59422,297.001.140.040.04b7jn4mf49n569select o.name, u.name from ob...

Back to SQL Statistics

Back to Top

SQL ordered by Reads

  • Total Disk Reads: 1,581
  • Captured SQL account for 109.7% of Total
Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
8802440.0055.660.261.0095w06sfdyppfj

navicat.exe

SELECT FROM (SELECT "NAVICAT...
305476.2519.290.220.3086synsm5txwj6

navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...
2331233.0014.742.192.32572fbaj0fdw2b

sqlplus@204maridb (TNS V1-V3)

select output from table(dbms...
157179.249.930.070.10cvn54b7yz0s8uselect /+ index(idl_ub1$ i_id...
73173.004.620.100.131srfjbzhb29z8

sqlplus@204_maridb (TNS V1-V3)

 select * from sys.wrh$_active...
14121.170.890.020.03a1y2ba3awndas

sqlplus@204_maridb (TNS V1-V3)

SELECT VALUE FROM DBA_HIST_PAR...
12112.000.760.730.765n73rjfpt3q4b

sqlplus@204_maridb (TNS V1-V3)

BEGIN :snap_id:=dbmsworkload...
1226.000.760.010.03awppxms81us4n

sqlplus@204_maridb (TNS V1-V3)

SELECT SUM(TIME_WAITED_MICRO) ...
11180.610.700.690.69d92h3rjp0y217begin prvt_hdm.auto_execute( :...
55830.010.320.040.045h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAM...

Back to SQL Statistics

Back to Top

SQL ordered by Executions

  • Total Executions: 41,480
  • Captured SQL account for 90.8% of Total
Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
11,61300.000.000.00803b7z0t84sq7select job, nvl2(last_date, ...
11,61311,6131.000.000.00g2wr3u7s1gtf3select count(*) from sys.job$ ...
1,93540,63521.000.000.00aykvshm7zsabdselect size_for_estimate, ...
1,85525,97014.000.000.00772s25v1y0x8kselect shared_pool_size_for_es...
1,6803,3602.000.000.008p447s6p0rv6bselect java_pool_size_for_esti...
1,04800.000.000.00350f5yrnnmshslock table sys.mon_mods$ in ex...
1,0481,0280.980.000.00g00cj285jmgswupdate sys.mon_mods$ set inser...
7047041.000.000.0049s332uhbnsma declare

vsn va...

5835831.000.000.005h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAM...
5224030.770.000.003c1kubcdjnppqupdate sys.col_usage$ set eq...
5045041.000.000.00f9u3p2bz694ddselect count(*) from sys.job$ ...
4664661.000.000.00grwydz59pu6mcselect text from view$ where r...

Back to SQL Statistics

Back to Top

SQL ordered by Parse Calls

  • Total Parse Calls: 8,895
  • Captured SQL account for 77.5% of Total
Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,0481,04811.78350f5yrnnmshslock table sys.mon_mods$ in ex...
1,0481,04811.78g00cj285jmgswupdate sys.mon_mods$ set inser...
7047047.9149s332uhbnsma declare

vsn va...

4664665.24grwydz59pu6mcselect text from view$ where r...
3283283.69bsa0wjtftg3uwselect file# from file$ where ...
1911912.15chsyr0gssbuqfselect f.file#, f.block#, f....
1715221.923c1kubcdjnppqupdate sys.col_usage$ set eq...
1711191.9253btfq0dt9bs9insert into sys.col_usage$ val...
1711711.92b2gnxm5z6r51nlock table sys.col_usage$ in e...
1681681.897mvdhsu3d43agselect a.obj# OBJOID, a.class...
1071071.20g337099aatnujupdate smon_scntime set orig...
97971.09a1xgxtssv5rrpselect sum(used_blocks), ts.t...
94941.060h6b2sajwb74nselect privilege#, level from ...
89891.008swypbbr0m372select order#, columns, types ...
89891.00cqgv56fmuj63xselect owner#, name, namespace...

Back to SQL Statistics

Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics

Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics

Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0m9ka0jk9kk4zSELECT OWNER, TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SKODACOM_READ' ORDER BY OWNER
0pt2789bczdp0

SELECT T.TABLE_NAME, T.OWNER, T.TABLESPACE_NAME, T.CLUSTER_NAME, T.IOT_NAME, T.PCT_FREE, T.PCT_USED, T.INI_TRANS, T.MAX_TRANS, T.INITIAL_EXTENT, T.NEXT_EXTENT, T.MIN_EXTENTS, T.MAX_EXTENTS, T.PCT_INCREASE, T.FREELISTS, T.FREELIST_GROUPS, T.LOGGING, T.BACKED_UP, T.NUM_ROWS, T.BLOCKS, T.EMPTY_BLOCKS, T.AVG_SPACE, T.CHAIN_CNT, T.AVG_ROW_LEN, T.AVG_SPACE_FREELIST_BLOCKS, T.NUM_FREELIST_BLOCKS, T.DEGREE, T.INSTANCES, T.CACHE, T.TABLE_LOCK, T.SAMPLE_SIZE, T.LAST_ANALYZED, T.PARTITIONED, T.IOT_TYPE, T.TEMPORARY, T.SECONDARY, T.NESTED, T.BUFFER_POOL, T.MONITORING, T.CLUSTER_OWNER, TC.COMMENTS, T.OBJECT_ID_TYPE, T.TABLE_TYPE_OWNER, T.TABLE_TYPE, T.GLOBAL_STATS, T.USER_STATS, T.DURATION, T.SKIP_CORRUPT, T.ROW_MOVEMENT, ET.TABLE_NAME EXT_TABLE_NAME, T.DEPENDENCIES, T.COMPRESSION, T.DROPPED, T.STATUS DROP_STATUS, (SELECT STATUS FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = 'TABLE') STATUS, (SELECT GENERATED FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = 'TABLE') GENERATED FROM SYS.ALL_ALL_TABLES T, SYS.ALL_EXTERNAL_TABLES ET, SYS.ALL_TAB_COMMENTS TC WHERE T.IOT_NAME IS NULL AND T.NESTED = 'NO' AND T.SECONDARY = 'N' AND NOT EXISTS (SELECT 1 FROM SYS.ALL_MVIEWS MV WHERE MV.OWNER = T.OWNER AND MV.MVIEW_NAME = T.TABLE_NAME) AND TC.OWNER(+) = T.OWNER AND TC.TABLE_NAME(+) = T.TABLE_NAME AND ET.TABLE_NAME(+) = T.TABLE_NAME AND ET.OWNER(+) = T.OW

NER AND T.OWNER = 'SKODACOM' ORDER BY T.TABLE_NAME ASC

15xnmd14bcfby

SELECT T.TABLE_NAME, T.OWNER, T.TABLESPACE_NAME, T.CLUSTER_NAME, T.IOT_NAME, T.PCT_FREE, T.PCT_USED, T.INI_TRANS, T.MAX_TRANS, T.INITIAL_EXTENT, T.NEXT_EXTENT, T.MIN_EXTENTS, T.MAX_EXTENTS, T.PCT_INCREASE, T.FREELISTS, T.FREELIST_GROUPS, T.LOGGING, T.BACKED_UP, T.NUM_ROWS, T.BLOCKS, T.EMPTY_BLOCKS, T.AVG_SPACE, T.CHAIN_CNT, T.AVG_ROW_LEN, T.AVG_SPACE_FREELIST_BLOCKS, T.NUM_FREELIST_BLOCKS, T.DEGREE, T.INSTANCES, T.CACHE, T.TABLE_LOCK, T.SAMPLE_SIZE, T.LAST_ANALYZED, T.PARTITIONED, T.IOT_TYPE, T.TEMPORARY, T.SECONDARY, T.NESTED, T.BUFFER_POOL, T.MONITORING, T.CLUSTER_OWNER, TC.COMMENTS, T.OBJECT_ID_TYPE, T.TABLE_TYPE_OWNER, T.TABLE_TYPE, T.GLOBAL_STATS, T.USER_STATS, T.DURATION, T.SKIP_CORRUPT, T.ROW_MOVEMENT, ET.TABLE_NAME EXT_TABLE_NAME, T.DEPENDENCIES, T.COMPRESSION, T.DROPPED, T.STATUS DROP_STATUS, (SELECT STATUS FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = 'TABLE') STATUS, (SELECT GENERATED FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER AND O.OBJECT_NAME = T.TABLE_NAME AND OBJECT_TYPE = 'TABLE') GENERATED FROM SYS.ALL_ALL_TABLES T, SYS.ALL_EXTERNAL_TABLES ET, SYS.ALL_TAB_COMMENTS TC WHERE T.IOT_NAME IS NULL AND T.NESTED = 'NO' AND T.SECONDARY = 'N' AND NOT EXISTS (SELECT 1 FROM SYS.ALL_MVIEWS MV WHERE MV.OWNER = T.OWNER AND MV.MVIEW_NAME = T.TABLE_NAME) AND TC.OWNER(+) = T.OWNER AND TC.TABLE_NAME(+) = T.TABLE_NAME AND ET.TABLE_NAME(+) = T.TABLE_NAME AND ET.OWNER(+) = T.OW

NER AND T.OWNER = 'SKODACOM_READ' ORDER BY T.TABLE_NAME ASC

1srfjbzhb29z8 select from sys.wrh$_active_session_history
31a13pnjps7j3

SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROWRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation

, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC

32wqka2zwvu65insert into wrh$_parameter (snap_id, dbid, instance_number, parameter_hash, value, isdefault, ismodified) select :snap_id, :dbid, :instancenumber, i.ksppihash hash, sv.ksppstvl, sv.ksppstdf, decode(bitand(sv.ksppstvf, 7), 1, 'MODIFIED', 'FALSE') from x$ksppi i, x$ksppsv sv where i.indx = sv.indx and (((i.ksppinm not like '#%' escape '#') or (sv.ksppstdf = 'FALSE') or (bitand(sv.ksppstvf, 5) > 0)) or (i.ksppinm like '##%' escape '#')) order by hash
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
49s332uhbnsma declare

vsn varchar2(20);

begin

vsn := dbms_rcvman.getPackageVersion;

:pkg_vsn:pkg_vsn_i := vsn;

if vsn is not null then

:pkg_vsnub4 :=

to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) ||

substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00'));

end if;

end;

53btfq0dt9bs9insert into sys.col_usage$ values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
572fbaj0fdw2bselect output from table(dbms_workload_repository.awr_report_html( :dbid,

:inst_num,

:bid, :eid,

:rpt_options ))

586b2udq6dbnginsert into wrh$_sysstat (snap_id, dbid, instance_number, stat_id, value) select :snap_id, :dbid, :instance_number, stat_id, value from v$sysstat order by stat_id
5h7w8ykwtb2xtINSERT INTO SYS.WRI$_ADV_PARAMETERS (TASK_ID, NAME, DATATYPE, VALUE, FLAGS, DESCRIPTION) VALUES (:B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
5n73rjfpt3q4bBEGIN :snap_id:=dbms_workload_repository.create_snapshot; END;
6cxqh7mktnbjminsert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7)
772s25v1y0x8kselect shared_pool_size_for_estimate s, shared_pool_size_factor 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
7mvdhsu3d43agselect a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a where bitand(a.job_status, 515) = 1 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.class_oid is not null and a.class_oid in (select b.obj# from scheduler$_class b where bitand(b.flags, :4) <> 0 and b.affinity = :5) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
7vgmvmy8vvb9sinsert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
803b7z0t84sq7select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date < :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
84vvbj8g8supsSELECT V.VIEW_NAME, V.TEXT_LENGTH, V.TEXT, V.TYPE_TEXT_LENGTH, V.TYPE_TEXT, V.OID_TEXT_LENGTH, V.OID_TEXT, V.VIEW_TYPE_OWNER, V.VIEW_TYPE, V.SUPERVIEW_NAME, (SELECT STATUS FROM SYS.ALL_OBJECTS WHERE OWNER = V.OWNER AND OBJECT_NAME = V.VIEW_NAME AND OBJECT_TYPE = 'VIEW' AND SUBOBJECT_NAME IS NULL) STATUS, (SELECT COMMENTS FROM SYS.ALL_TAB_COMMENTS WHERE OWNER = V.OWNER AND TABLE_NAME = V.VIEW_NAME) COMMENTS, C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE FROM SYS.ALL_VIEWS V, SYS.ALL_CONSTRAINTS C WHERE C.OWNER(+) = V.OWNER AND C.TABLE_NAME(+) = V.VIEW_NAME AND V.OWNER = 'SKODACOM' AND V.VIEW_NAME = 'VIEW_THREAD_USER' ORDER BY V.OWNER, V.VIEW_NAME ASC
86synsm5txwj6SELECT V.VIEW_NAME, V.TEXT_LENGTH, V.TEXT, V.TYPE_TEXT_LENGTH, V.TYPE_TEXT, V.OID_TEXT_LENGTH, V.OID_TEXT, V.VIEW_TYPE_OWNER, V.VIEW_TYPE, V.SUPERVIEW_NAME, (SELECT STATUS FROM SYS.ALL_OBJECTS WHERE OWNER = V.OWNER AND OBJECT_NAME = V.VIEW_NAME AND OBJECT_TYPE = 'VIEW' AND SUBOBJECT_NAME IS NULL) STATUS, (SELECT COMMENTS FROM SYS.ALL_TAB_COMMENTS WHERE OWNER = V.OWNER AND TABLE_NAME = V.VIEW_NAME) COMMENTS, C.CONSTRAINT_NAME, C.CONSTRAINT_TYPE FROM SYS.ALL_VIEWS V, SYS.ALL_CONSTRAINTS C WHERE C.OWNER(+) = V.OWNER AND C.TABLE_NAME(+) = V.VIEW_NAME AND V.OWNER = 'SKODACOM' ORDER BY V.OWNER, V.VIEW_NAME ASC
8dw6saa5zu2sk

select

service_name, uio_waits, uio_time, con_waits, con_time,

adm_waits, adm_time, net_waits, net_time

from

(select

stat1.service_name service_name, db_time, uio_waits, uio_time,

con_waits, con_time, adm_waits, adm_time, net_waits, net_time

from

(select s1.service_name,

sum(decode(s1.stat_name, 'DB time', s1.diff, 0)) db_time

from

(select e.service_name service_name,

e.stat_name stat_name,

e.value - b.value diff

from dba_hist_service_stat b,

dba_hist_service_stat e

where b.snap_id = :bid

and e.snap_id = :eid

and b.instance_number = :inst_num

and e.instance_number = :inst_num

and b.dbid = :dbid

and e.dbid = :dbid

and b.stat_id = e.stat_id

and b.service_name_hash = e.service_name_hash) s1

group by s1.service_name) stat1,

(select s2.service_name,

sum(decode(s2.wait_class, 'User I/O',

s2.total_waits, 0)) uio_waits,

sum(decode(s2.wait_class, 'User I/O',

s2.time_waited, 0)) uio_time,

sum(decode(s2.wait_class, 'Concurrency',

s2.total_waits, 0)) con_waits,

sum(dec

ode(s2.wait_class, 'Concurrency',

s2.time_waited, 0)) con_time,

sum(decode(s2.wait_class, 'Administrative',

s2.total_waits, 0)) adm_waits,

sum(decode(s2.wait_class, 'Administrative',

s2.time_waited, 0)) adm_time,

sum(decode(s2.wait_class, 'Network',

s2.total_waits, 0)) net_waits,

sum(decode(s2.wait_class, 'Network',

s2.time_waited, 0)) net_time

from

(select e.service_name service_name,

e.wait_class wait_class,

e.total_waits - b.total_waits total_waits,

e.time_waited - b.time_waited time_waited

from dba_hist_service_wait_class b,

dba_hist_service_wait_class e

where b.snap_id = :bid

and e.snap_id = :eid

and b.instance_number = :inst_num

and e.instance_number = :inst_num

and b.dbid = :dbid

and e.dbid = :dbid

and b.wait_class_id = e.wait_class_id

and b.service_name_hash = e.service_name_hash) s2

group by s2.service_name) stat2

where

stat1.service_name = stat2.service_name

order by

db_time desc, service_name)

wh

ere rownum <= :top_n_svc

8p447s6p0rv6bselect java_pool_size_for_estimate s, java_pool_size_factor 100 f, estd_lc_load_time l, 0 from v$java_pool_advice
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
95w06sfdyppfjSELECT FROM (SELECT "NAVICAT_TABLE"., ROWNUM "NAVICAT_ROWNUM" FROM (SELECT FROM "SKODACOM"."VIEW_THREAD_USER") "NAVICAT_TABLE" WHERE ROWNUM <= 1000) WHERE "NAVICAT_ROWNUM" > 0
a1xgxtssv5rrpselect sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a1y2ba3awndasSELECT VALUE FROM DBA_HIST_PARAMETER WHERE SNAP_ID = :B4 AND DBID = :B3 AND INSTANCE_NUMBER = :B2 AND PARAMETER_NAME = :B1
agpd044zj368minsert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id
awppxms81us4nSELECT SUM(TIME_WAITED_MICRO) FROM DBA_HIST_SYSTEM_EVENT WHERE SNAP_ID = :B3 AND DBID = :B2 AND INSTANCE_NUMBER = :B1 AND WAIT_CLASS != 'Idle'
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b7jn4mf49n569select o.name, u.name from obj$ o, type$ t, user$ u where o.oid$ = t.tvoid and u.user#=o.owner# and bitand(t.properties, 8388608) = 8388608 and (sysdate-o.ctime) > 0.0007
bsa0wjtftg3uwselect file# from file$ where ts#=:1
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS fro v$sga_target_advice
cfz686a6qp0kgselect o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
chsyr0gssbuqfselect f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# and t.dflextpct!=0 and t.bitmapped=0
chunmygjj8x7gSELECT OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM ALL_TAB_COLUMNS WHERE OWNER = 'SKODACOM' ORDER BY OWNER, TABLE_NAME
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8uselect /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d5bwbakqj3f79SELECT OWNER, TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'SKODACOM' ORDER BY OWNER
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
f9u3p2bz694ddselect count() from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3))
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g2wr3u7s1gtf3select count() from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
g337099aatnujupdate smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
g6wf9na8zs5hbinsert into wrh$_sysmetric_summary (snap_id, dbid, instance_number, begin_time, end_time, intsize, group_id, metric_id, num_interval, maxval, minval, average, standard_deviation) select :snap_id, :dbid, :instance_number, begtime, endtime, intsize_csec, groupid, metricid, numintv, max, min, avg, std FROM x$kewmsmdv WHERE groupid = 2
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics

Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session6,1630.1142.50
CPU used when call started1,8640.0312.86
CR blocks created570.000.39
Cached Commit SCN referenced430.000.30
Commit SCN cached30.000.02
DB time6,7490.1246.54
DBWR checkpoint buffers written6,5440.1145.13
DBWR checkpoints10.000.01
DBWR transaction table writes4290.012.96
DBWR undo block writes1,2360.028.52
PX local messages recv'd00.000.00
PX local messages sent00.000.00
SMON posted for undo segment shrink30.000.02
SQLNet roundtrips to/from client1,0590.027.30
active txn count during cleanout4070.012.81
application wait time10.000.01
background checkpoints completed10.000.01
background checkpoints started10.000.01
background timeouts186,9873.221,289.57
buffer is not pinned count174,3473.001,202.39
buffer is pinned count133,1802.29918.48
bytes received via SQLNet from client76,3731.32526.71
bytes sent via SQL*Net to client1,402,04024.149,669.24
calls to get snapshot scn: kcmgss75,6411.30521.66
calls to kcmgas2,7740.0519.13
calls to kcmgcs6700.014.62
change write time430.000.30
cleanout - number of ktugct calls4510.013.11
cleanouts and rollbacks - consistent read gets00.000.00
cleanouts only - consistent read gets130.000.09
cluster key scan block gets112,5071.94775.91
cluster key scans15,7210.27108.42
commit batch/immediate performed10.000.01
commit batch/immediate requested10.000.01
commit cleanout failures: block lost00.000.00
commit cleanout failures: callback failure510.000.35
commit cleanouts5,5710.1038.42
commit cleanouts successfully completed5,5200.1038.07
commit immediate performed10.000.01
commit immediate requested10.000.01
commit txn count during cleanout2140.001.48
concurrency wait time1500.001.03
consistent changes28,8010.50198.63
consistent gets279,1004.811,924.83
consistent gets - examination63,7331.10439.54
consistent gets direct420.000.29
consistent gets from cache279,0584.811,924.54
cursor authentications540.000.37
data blocks consistent reads - undo records applied580.000.40
db block changes67,8151.17467.69
db block gets125,1612.16863.18
db block gets direct780.000.54
db block gets from cache125,0832.15862.64
deferred (CURRENT) block cleanout applications3,5490.0624.48
dirty buffers inspected00.000.00
enqueue conversions31,0160.53213.90
enqueue releases415,8417.162,867.87
enqueue requests415,8417.162,867.87
enqueue waits00.000.00
execute count41,4800.71286.07
free buffer inspected1,4330.029.88
free buffer requested9,5870.1766.12
heap block compress2360.001.63
hot buffers moved to head of LRU70.000.05
immediate (CR) block cleanout applications130.000.09
immediate (CURRENT) block cleanout applications8940.026.17
index fast full scans (full)00.000.00
index fetch by key48,5660.84334.94
index scans kdiixs149,2460.85339.63
leaf node 90-10 splits1220.000.84
leaf node splits1750.001.21
lob reads4,4550.0830.72
lob writes7,7460.1353.42
lob writes unaligned7,7460.1353.42
logons cumulative590.000.41
messages received6,0690.1041.86
messages sent6,0690.1041.86
no buffer to keep pinned count00.000.00
no work - consistent read gets155,3342.681,071.27
opened cursors cumulative9,4700.1665.31
parse count (failures)60.000.04
parse count (hard)2290.001.58
parse count (total)8,8950.1561.34
parse time cpu3150.012.17
parse time elapsed3300.012.28
physical read IO requests1,2180.028.40
physical read bytes12,951,552223.0489,321.05
physical read total IO requests43,8240.75302.23
physical read total bytes752,499,71212,958.855,189,653.19
physical read total multi block requests920.000.63
physical reads1,5810.0310.90
physical reads cache1,5310.0310.56
physical reads cache prefetch3630.012.50
physical reads direct500.000.34
physical reads direct (lob)180.000.12
physical reads prefetch warmup00.000.00
physical write IO requests4,8800.0833.66
physical write bytes54,312,960935.33374,572.14
physical write total IO requests93,1971.60642.74
physical write total bytes1,387,083,77623,887.079,566,095.01
physical write total multi block requests1,9810.0313.66
physical writes6,6300.1145.72
physical writes direct860.000.59
physical writes direct (lob)780.000.54
physical writes direct temporary tablespace00.000.00
physical writes from cache6,5440.1145.13
physical writes non checkpoint1,0920.027.53
pinned buffers inspected00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use1,3210.029.11
recursive calls293,4165.052,023.56
recursive cpu usage1,7000.0311.72
redo blocks written40,4320.70278.84
redo buffer allocation retries20.000.01
redo entries37,0930.64255.81
redo log space requests20.000.01
redo log space wait time50.000.03
redo ordering marks5540.013.82
redo size15,993,812275.43110,302.15
redo synch time80.000.06
redo synch writes12,6250.2287.07
redo wastage4,007,00069.0027,634.48
redo write time5620.013.88
redo writer latching time20.000.01
redo writes10,8380.1974.74
rollback changes - undo records applied20.000.01
rollbacks only - consistent read gets570.000.39
rows fetched via callback20,0940.35138.58
session cursor cache hits5,8360.1040.25
session logical reads404,2616.962,788.01
session pga memory486,7928.383,357.19
session pga memory max1,797,51230.9612,396.63
session uga memory4,296,593,60073,991.9529,631,680.00
session uga memory max94,606,5121,629.23652,458.70
shared hash latch upgrades - no wait49,1100.85338.69
sorts (memory)19,4780.34134.33
sorts (rows)229,7373.961,584.39
sql area purged00.000.00
summed dirty queue length00.000.00
switch current to new buffer300.000.21
table fetch by rowid65,6141.13452.51
table fetch continued row1750.001.21
table scan blocks gotten22,6500.39156.21
table scan rows gotten572,0749.853,945.34
table scans (long tables)20.000.01
table scans (short tables)1,3800.029.52
total number of times SMON posted40.000.03
transaction rollbacks10.000.01
undo change vector size4,400,55275.7830,348.63
user I/O wait time1460.001.01
user calls1,3240.029.13
user commits1450.001.00
user rollbacks00.000.00
workarea executions - optimal7,5170.1351.84
write clones created in background00.000.00
write clones created in foreground00.000.00

Back to Instance Activity Statistics

Back to Top

Instance Activity Stats - Absolute Values

  • Statistics with absolute values (should not be diffed)
StatisticBegin ValueEnd Value
session cursor cache count7,9038,770
opened cursors current4239
logons current1717

Back to Instance Activity Statistics

Back to Top

Instance Activity Stats - Thread Activity

  • Statistics identified by '(derived)' come from sources other than SYSSTAT
StatisticTotalper Hour
log switches (derived)10.06

Back to Instance Activity Statistics

Back to Top

IO Stats

Back to Top

Tablespace IO Stats

  • ordered by IOs (Reads + Writes) desc
TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX13002.691.533,008000.00
SYSTEM23701.392.11881000.00
UNDOTBS1100.001.00986010.00
SKODACOM84900.981.043000.00
EBUY_USER100.001.001000.00
PEICHE100.001.001000.00

Back to IO Stats

Back to Top

File IO Stats

  • ordered by Tablespace, File
TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
EBUY_USER/u01/oradata/skodacom/ebuy_user01.dbf100.001.001000.00
PEICHE/u01/oradata/skodacom/peiche_data_file1.dbf100.001.001000.00
SKODACOM/u01/oradata/skodacom/skodacom_user01.dbf69500.881.051000.00
SKODACOM/u01/oradata/skodacom/skodacom_user02.dbf12001.581.001000.00
SKODACOM/u01/oradata/skodacom/skodacom_user03.dbf3400.881.001000.00
SYSAUX/u01/oradata/skodacom/sysaux.dbf13002.691.533,008000.00
SYSTEM/u01/oradata/skodacom/system.dbf23701.392.11881000.00
UNDOTBS1/u01/oradata/skodacom/undotbs1.dbf100.001.00986010.00

Back to IO Stats

Back to Top

Buffer Pool Statistics

  • Standard block size Pools D: default, K: keep, R: recycle
  • Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D105,152100404,7091,5326,544001

Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

  • B: Begin snapshot, E: End snapshot
Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B07163173878184320878 
E0716943163061843206306 

Back to Advisory Statistics

Back to Top

Buffer Pool Advisory

  • Only rows with estimated physical reads >0 are displayed
  • ordered by Block Size, Buffers For Estimate
PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D800.099,9201.122,723,336
D1600.1919,8401.102,663,197
D2400.2829,7601.082,629,478
D3200.3839,6801.062,582,075
D4000.4749,6001.032,505,137
D4800.5759,5201.012,456,910
D5600.6669,4401.012,444,051
D6400.7579,3601.002,426,428
D7200.8589,2801.002,426,061
D8000.9499,2001.002,425,878
D8481.00105,1521.002,425,878
D8801.04109,1201.002,425,878
D9601.13119,0401.002,425,878
D1,0401.23128,9601.002,425,878
D1,1201.32138,8801.002,425,878
D1,2001.42148,8001.002,425,878
D1,2801.51158,7201.002,425,878
D1,3601.60168,6401.002,425,878
D1,4401.70178,5601.002,425,878
D1,5201.79188,4801.002,425,878
D1,6001.89198,4001.002,416,287

Back to Advisory Statistics

Back to Top

PGA Aggr Summary

  • PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.002370

Back to Advisory Statistics

Back to Top

PGA Aggr Target Stats

  • B: Begin snap E: End snap (rows dentified with B or E contain data

    which is absolute i.e. not diffed over the interval)

  • Auto PGA Target - actual workarea memory target
  • W/A PGA Used - amount of memory used for all Workareas (manual + auto)
  • %PGA W/A Mem - percentage of PGA memory allocated to workareas
  • %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
  • %Man W/A Mem - percentage of workarea memory under manual control
PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B234167104.320.000.000.000.0047,841
E234167104.020.000.000.000.0047,841

Back to Advisory Statistics

Back to Top

PGA Aggr Target Histogram

  • Optimal Executions are purely in-memory operations
Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K7,2207,22000
64K128K545400
128K256K6600
512K1024K20620600
1M2M404000

Back to Advisory Statistics

Back to Top

PGA Memory Advisory

  • When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value

    where Estd PGA Overalloc Count is 0

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
290.132,595.47493.6184.0017
580.252,595.47290.4990.0010
1170.502,595.4761.7698.001
1750.752,595.470.00100.000
2341.002,595.470.00100.000
2801.202,595.470.00100.000
3271.402,595.470.00100.000
3741.602,595.470.00100.000
4201.802,595.470.00100.000
4672.002,595.470.00100.000
7013.002,595.470.00100.000
9344.002,595.470.00100.000
1,4026.002,595.470.00100.000
1,8698.002,595.470.00100.000

Back to Advisory Statistics

Back to Top

Shared Pool Advisory

  • SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
  • Note there is often a 1:Many correlation between a single logical object

    in the Library Cache, and the physical number of memory objects associated

    with it. Therefore comparing the number of Lib Cache objects (e.g. in

    v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1440.53352,6517850.99691.17462,980
1760.65665,4817880.99661.12468,081
2080.76977,6737951.00591.00473,154
2400.8812810,0387951.00591.00473,713
2721.0015912,3857951.00591.00473,815
3041.1219014,6657951.00591.00473,823
3361.2422116,9217961.00580.98473,851
3681.3523317,7777961.00580.98473,851
4001.4723317,7777961.00580.98473,851
4321.5923317,7777961.00580.98473,851
4641.7123317,7777961.00580.98473,851
4961.8223317,7777961.00580.98473,851
5281.9423317,7777961.00580.98473,851
5602.0623317,7777961.00580.98473,851

Back to Advisory Statistics

Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2920.251,5022,723,291
5840.501,1972,505,204
8760.751,0782,426,363
1,1681.001,0762,425,878
1,4601.251,0762,425,878
1,7521.501,0702,416,174
2,0441.751,0622,416,174
2,3362.001,0622,416,174

Back to Advisory Statistics

Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics

Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

  • ordered by wait time desc, waits desc
ClassWaitsTotal Wait Time (s)Avg Time (ms)
undo header100

Back to Wait Statistics

Back to Top

Enqueue Activity

No data exists for this section of the report.

Back to Wait Statistics

Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

  • Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
  • STO - Snapshot Too Old count, OOS - Out of Space count
  • Undo segment block stats:
  • uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
  • eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
10.752,0081743180/1800/00/0/0/0/0/0

Back to Undo Statistics

Back to Top

Undo Segment Stats

  • Most recent 35 Undostat rows, ordered by Time desc
End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
01-Jul 16:0691104031800/00/0/0/0/0/0
01-Jul 15:5601001800/00/0/0/0/0/0
01-Jul 15:461517411800/00/0/0/0/0/0
01-Jul 15:3602001800/00/0/0/0/0/0
01-Jul 15:2641172031800/00/0/0/0/0/0
01-Jul 15:1602001800/00/0/0/0/0/0
01-Jul 15:0667141021800/00/0/0/0/0/0
01-Jul 14:5611011800/00/0/0/0/0/0
01-Jul 14:46027001800/00/0/0/0/0/0
01-Jul 14:3611011800/00/0/0/0/0/0
01-Jul 14:2614011800/00/0/0/0/0/0
01-Jul 14:1601001800/00/0/0/0/0/0
01-Jul 14:063291021800/00/0/0/0/0/0
01-Jul 13:5612011800/00/0/0/0/0/0
01-Jul 13:4613011800/00/0/0/0/0/0
01-Jul 13:3602001800/00/0/0/0/0/0
01-Jul 13:2603001800/00/0/0/0/0/0
01-Jul 13:1601001800/00/0/0/0/0/0
01-Jul 13:064091031800/00/0/0/0/0/0
01-Jul 12:5612011800/00/0/0/0/0/0
01-Jul 12:46612011800/00/0/0/0/0/0
01-Jul 12:3621011800/00/0/0/0/0/0
01-Jul 12:2603001800/00/0/0/0/0/0
01-Jul 12:1602001800/00/0/0/0/0/0
01-Jul 12:063790031800/00/0/0/0/0/0
01-Jul 11:5601001800/00/0/0/0/0/0
01-Jul 11:4604001800/00/0/0/0/0/0
01-Jul 11:3601001800/00/0/0/0/0/0
01-Jul 11:2613011800/00/0/0/0/0/0
01-Jul 11:1601001800/00/0/0/0/0/0
01-Jul 11:063085031800/00/0/0/0/0/0
01-Jul 10:5613011800/00/0/0/0/0/0
01-Jul 10:4602001800/00/0/0/0/0/0
01-Jul 10:3613011800/00/0/0/0/0/0

Back to Undo Statistics

Back to Top

Latch Statistics

Back to Top

Latch Activity

  • "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for

    willing-to-wait latch get requests

  • "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
  • "Pct Misses" for both should be very close to 0.0
Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AWR Alerted Metric Element list205,5630.00 00 
Consistent RBA10,8400.00 00 
FAL request queue1,1630.00 00 
FAL subheap alocation1,1630.00 00 
FIB s.o chain latch60.00 00 
FOB s.o list latch4870.00 00 
JS mem alloc latch40.00 00 
JS queue access latch40.00 00 
JS queue state obj latch348,4640.00 00 
JS slv state obj latch80.00 00 
KGX0  045,4340.00
KMG MMAN ready and startup request latch19,3560.00 00 
KTF sga latch990.00 019,3490.00
KWQMN job cache list latch130.00 00 
MQL Tracking Latch0  01,1470.00
Memory Management Latch0  019,3560.00
OS process3840.00 00 
OS process allocation19,6120.00 00 
OS process: request allocation1160.00 00 
PL/SQL warning settings1,1260.00 00 
SQL memory manager latch180.00 019,3380.00
SQL memory manager workarea list latch1,298,2480.00 00 
Shared B-Tree2,0730.00 00 
active checkpoint queue latch24,1560.00 00 
active service list104,8810.000.00019,4120.00
archive control1,1010.00 00 
archive process latch20,5010.00 00 
begin backup scn array780.00 00 
cache buffer handles1,0040.00 00 
cache buffers chains906,7140.000.00011,0040.00
cache buffers lru chain26,7570.00 014,5700.00
cache table scan latch500.00 0500.00
cas latch440.00 00 
channel handle pool latch1180.00 00 
channel operations parent latch271,7750.00 00 
checkpoint queue latch777,6000.00 06,0780.00
client/application info1550.00 00 
compile environment latch6400.00 00 
dml lock allocation7,0150.00 00 
dummy allocation1180.00 00 
enqueue hash chains862,7890.00 00 
enqueues822,1440.000.0000 
event group latch580.00 00 
file cache latch1,6300.00 00 
global KZLD latch for mem in SGA200.00 00 
hash table column usage latch4510.00 091,3020.00
hash table modification latch8450.00 00 
job workq parent latch0  020.00
job_queue_processes parameter latch9690.00 00 
kks stats9760.00 00 
ksuosstats global area3,9080.00 00 
ktm global data2020.00 00 
kwqbsn:qsga2,0730.00 00 
lgwr LWN SCN20,4170.00 00 
library cache186,9840.020.1304040.00
library cache load lock6540.00 00 
library cache lock51,2950.030.2900 
library cache lock allocation8540.00 00 
library cache pin133,5690.000.0000 
library cache pin allocation3040.00 00 
list of block allocation2860.00 00 
loader state object freelist2720.00 00 
message pool operations parent latch20.00 00 
messages387,0490.020.0000 
mostly latch-free SCN23,2090.00 00 
multiblock read objects1200.00 00 
ncodef allocation latch9250.00 00 
object queue header heap260.00 010.00
object queue header operation87,4170.00 00 
object stats modification350.00 00 
parallel query alloc buffer7,7360.00 00 
parameter table allocation management601.670.0000 
post/wait queue1480.00 0400.00
process allocation1162.591.000580.00
process group creation1160.00 00 
qmn task queue latch8,2920.00 00 
redo allocation51,7910.020.00037,1180.01
redo copy0  037,1180.57
redo on-disk SCN71,2880.00 00 
redo writing97,3000.000.0000 
resmgr group change latch290.00 00 
resmgr:actses active list670.00 00 
resmgr:actses change group240.00 00 
resmgr:free threads list492.040.0000 
resmgr:schema config180.00 00 
rm cas latch1880.00 00 
row cache objects253,5650.000.0000 
sequence cache2020.00 00 
session allocation59,8980.000.0000 
session idle bit3,2290.00 00 
session state list latch2050.00 00 
session switching9250.00 00 
session timer19,4120.00 00 
shared pool56,8120.010.2500 
simulator hash latch22,7530.00 00 
simulator lru latch21,9710.00 04620.00
slave class350.00 00 
slave class create13912.231.0000 
sort extent pool1,6140.00 00 
state object free list360.00 00 
statistics aggregation2,0160.00 00 
temp lob duration state obj allocation20.00 00 
threshold alerts latch3,0690.00 00 
transaction allocation2020.00 00 
transaction branch allocation9250.00 00 
undo global data23,1030.00 00 
user lock823.660.0000 

Back to Latch Statistics

Back to Top

Latch Sleep Breakdown

  • ordered by misses desc
Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
library cache186,98440535000
library cache lock51,29517513000
slave class create13917170000
shared pool56,812413000
process allocation116330000

Back to Latch Statistics

Back to Top

Latch Miss Sources

  • only latches with sleeps are shown
  • ordered by name, sleeps desc
Latch NameWhereNoWait Misses SleepsWaiter Sleeps
library cachekglhdgc: child:021
library cachekglpin: child: heap processing020
library cachekglpndl: child: before processing012
library cache lockkgllkdl: child: cleanup055
process allocationksucrp030
shared poolkghalo011
slave class createksvcreate0170

Back to Latch Statistics

Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics

Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics

Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

  • Total Logical Reads: 404,261
  • Captured Segments account for 70.5% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYSSYSTEMSMON_SCN_TIME TABLE75,93618.78
SYSSYSTEMI_JOB_NEXT INDEX35,1368.69
SYSSYSTEMCOLTYPE$ TABLE16,5284.09
SYSSYSTEMTAB$ TABLE13,9043.44
SYSSYSTEMOBJ$ TABLE11,9682.96

Back to Segment Statistics

Back to Top

Segments by Physical Reads

  • Total Physical Reads: 1,581
  • Captured Segments account for 93.0% of Total
OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SKODACOMSKODACOMTB_USER TABLE40025.30
SYSSYSTEMVIEW$ TABLE30619.35
SKODACOMSKODACOMTB_USER_PK INDEX25015.81
SKODACOMSKODACOMTB_THREAD TABLE18111.45
SYSSYSTEMIDL_UB1$ TABLE1529.61

Back to Segment Statistics

Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics

Back to Top

Dictionary Cache Stats

  • "Pct Misses" should be very low (< 2% in most cases)
  • "Final Usage" is the number of cache entries being used
CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1,0250.000 361
dc_global_oids2091.440 087
dc_histogram_data16,1920.720 011,807
dc_histogram_defs18,0051.810 03,890
dc_object_ids8,5560.550 01,189
dc_objects3,3013.360 11,304
dc_profiles220.000 01
dc_rollback_segments15,5720.000 029
dc_segments1,9600.510 37819
dc_sequences50.000 58
dc_tablespaces16,7100.000 09
dc_usernames1250.800 012
dc_users13,6450.010 037
outstanding_alerts9700.000 08

Back to Top

Library Cache Activity

  • "Pct Misses" should be very low
NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY1232.441,3100.4620
CLUSTER350.00640.0000
INDEX4522.221158.7000
SQL AREA17697.1648,6070.771050
TABLE/PROCEDURE1,0438.925,5505.14610

Back to Top

Memory Statistics

Back to Top

Process Memory Summary

  • B: Begin snap E: End snap
  • All rows below contain absolute values (i.e. not diffed over the interval)
  • Max Alloc is Maximum PGA Allocation size at snapshot time
  • Hist Max Alloc is the Historical Max Allocation for still-connected processes
  • ordered by Begin/End snapshot, Alloc (MB) desc
CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther99.86 5.879.4123231717
 Freeable4.060.000.680.411 66
 SQL0.310.160.030.040197
 PL/SQL0.090.030.010.01001717
EOther99.55 5.869.4223231717
 Freeable4.130.000.690.361 66
 SQL0.250.130.030.030197
 PL/SQL0.110.050.010.01001717

Back to Memory Statistics

Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers889,192,448 
Fixed Size2,020,384 
Redo Buffers14,753,792 
Variable Size318,770,144 

Back to Memory Statistics

Back to Top

SGA breakdown difference

  • ordered by Pool, Name
  • N/A value for Begin MB or End MB indicates the size of that Pool/Name was

    insignificant, or zero in that snapshot

PoolNameBegin MBEnd MB% Diff
javafree memory16.0016.000.00
largePX msg pool0.990.990.00
largefree memory15.0115.010.00
sharedASH buffers8.008.000.00
sharedCCursor4.004.020.58
sharedFileOpenBlock3.543.540.00
sharedKCB Table Scan Buffer4.004.000.00
sharedKGLS heap2.872.963.11
sharedKQR M PO2.802.986.39
sharedKQR M SO5.555.600.95
sharedKSFD SGA I/O b4.004.000.00
sharedKTI-UNDO3.223.220.00
sharedPCursor3.433.42-0.29
sharedPL/SQL MPCODE 3.06 
shareddb_block_hash_buckets4.204.200.00
sharedevent statistics per sess3.883.880.00
sharedfree memory123.16111.86-9.17
sharedkglsim hash table bkts4.004.000.00
sharedlibrary cache10.2810.582.99
sharedprivate strands6.056.050.00
sharedrow cache7.137.130.00
sharedsql area17.9527.1651.32
 buffer_cache848.00848.000.00
 fixed_sga1.931.930.00
 log_buffer14.0714.070.00

Back to Memory Statistics

Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_allow_resetlogs_corruptionTRUE  
audit_file_dest/u01/oracle/admin/skodacom/adump  
audit_sys_operationsTRUE  
audit_trailDB, EXTENDED  
background_dump_dest/u01/oracle/admin/skodacom/bdump  
control_files/u01/oradata/skodacom/control1.ctl, /u01/oradata/skodacom/control2.ctl, /u01/oradata/skodacom/control3., /u01/app/oracle/product/10.2.0/db_1/dbs/ctl  
core_dump_dest/u01/oracle/admin/skodacom/cdump  
db_block_size8192  
db_create_file_dest/u01/oradata  
db_create_online_log_dest_1/u01/oradata  
db_domainskodacom  
db_nameskodacom  
db_recovery_file_dest/u01/arch/flashbakdb  
db_recovery_file_dest_size21474836480  
db_unique_nameskodacom  
job_queue_processes10  
log_archive_dest_1LOCATION=/u01/arch/skodacom  
log_archiveformatlog%t%s%r.arc  
open_cursors1500  
processes400  
sga_target1224736768  
undo_managementAUTO  
undo_retention10800  
undo_tablespaceUNDOTBS1  
user_dump_dest/u01/oracle/admin/skodacom/udump  

Back to Top

End of Report

Report written to awrrpt_1_52416_52434.html

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

[oracle@204_maridb ~]$ ll

总用量 19080

-rw-r--r-- 1 oracle oinstall 252239 7月 1 16:09 awrrpt_1_52416_52434.html

-rw-r--r-- 1 oracle oinstall 249247 7月 1 15:22 awrrpt_1_52431_52432.html

-rw-r--r-- 1 oracle oinstall 16444 4月 16 11:45 dbca.rsp

-rw-r--r-- 1 oracle oinstall 920 4月 16 11:24 enterprise01.rsp

-rw-r--r-- 1 oracle oinstall 457 4月 22 16:04 export.log

-rw-r----- 1 oracle oinstall 18321408 4月 19 10:54 full.dmp

-rw-r----- 1 oracle oinstall 1167 4月 19 11:39 impdp.log

-rw-r----- 1 oracle oinstall 291067 4月 19 11:36 import.log

-rw-r--r-- 1 oracle oinstall 5742 4月 16 11:49 netca.rsp

-rw-rw-r-- 1 oracle oinstall 65 4月 16 11:13 oraInst.loc

-rw-r--r-- 1 root root 121910 5月 14 14:19 rlwrap-0.43-2.el7.x86_64.rpm

-rw-r--r-- 1 oracle oinstall 65638 5月 14 11:48 rman_11.log

drwxr-xr-x 2 oracle oinstall 4096 5月 23 10:55 scripts

-rw-r----- 1 oracle oinstall 172032 4月 19 11:36 testexpdp.dmp

尖小椒
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle的awr生成报告步骤
微风
02-22 3756
* 定义：awr报告是oracle 10g下提供的一种性能收集和分析工具，它能提供一个时间段内整个系统资源使用情况的报告，通过这个报告，我们就可以了解一个系统的整个运行情况，这就像一个人全面的体检报告。
ORACLE AWR报告生成.docx
02-15
在Oracle 11g中，生成AWR报告主要通过运行`awrrpt`脚本来完成。 首先，你需要访问Oracle的`rdbms/admin`目录，找到`awrrpt`脚本。这个脚本通常位于Oracle的安装路径下，例如`$ORACLE_HOME/rdbms/admin`。在SQL*Plus...
oracle 10 awr,ORACLE10G AWR使用和分析
weixin_30072693的博客
04-09 161
输入 num_days 的值: 1输入 begin_snap 的值: 1181输入 end_snap 的值: 1182输入 report_name 的值: Report written to awrrpt_1_1181_1182.htmlSQL> exit下载awrrpt_1_1181_1182.html并打开查看。需要注意的是使用 AWR 需要有 Diagnostic Pack Licen...
Oracle10g调优：Oracle10g AWR使用方法及分析
weixin_33819479的博客
10-20 99
Oracle10g调优：Oracle10g AWR使用方法及分析---来源：TTT BLOG [ http://www.taoyoyo.net/ttt/ ]地址：http://www.taoyoyo.net/ttt/post/301.html --- 　　为公司做的一个测试DB现在响应非常慢，急需优化，终于找到AWR的优化方法，在这里总结记录一下!(大部分是在网上的资料。) 　　关于AWR概述...
oracle10g生成awr报告,oracle 10g awr报告生成步骤及awr报告分析
weixin_39580715的博客
04-03 128
3. io：如果需要的数据在内存中没有，则需要到磁盘中去取，就会用到物理io了，还有表之间的连接数据太多，以及排序等操作内存放不下的时候，也需要用到临时表空间，也就用到物理io了这里有一点说明的是，虽然oracle占用了8G的内存，但pga一般只占8G的20%，对于专用服务器模式，每次执行sql语句，表数据的运算等操作，都在pga中进行的，也就是说只能用1.6G左右的内存，如果多个用户都执行多表关...
Oracle10g AWR
05-16 118
Oracle10g AWR[@more@]--------------------------1. about Oracle10g AWR AWR 自动工作负载信息库，是 Oracle10g 新特性之一。 AWR 作为 Or...
oracle 10G特性之awr
cuilin2183的博客
04-21 203
oracle推出已经2年多了，但只在04年用过几个月，之后接触的数据库大部分是8i和9i，所以，很多10g的新特性没有接触到。现在有时间可以学习10g了。打算用一系列的文章来记录学习10g新特性的心得。一、概述 awr(A...
oracle 生成awr 报告
06-21
使用非常详尽的步骤，一步一步的指引我们在oracle 中如何生成一份awr报告
oracle awr报告生成
09-27
window下直接调用生成弹出html格式的awr报告，不用去linux下了，但是妖之道数据库密码的啊，不然没法调用，修改里bat里的连接串即可 样例： sqlplus sys/oracle@zhengshiku_2 as sysdba @addmrpt.sql
oracle抓取指定时间段AWR报告实例说明 .docx
06-09
记一次生产环境排查服务器性能优化的问题，需要获取oracle的AWR报告，进行分析服务器sql的执行时间
oracle 10g AWR
03-12
10g/11g AWR 快照频率、基准线、段的统计、lob段信息 物理文件I/O
AWR报告生成详解.doc
03-25
在Windows平台上生成AWR报告，首先需要登录到部署了Oracle 10g数据库的服务器，通过cmd.exe启动命令行。进入`C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN`目录，以SYSDBA权限登录sqlplus。在sqlplus中执行`@awrrpt`...
Oracle10g AWR (Automatic Workload Repository)
cuixie2370的博客
06-03 111
Oracle Database 10g 提供了一个显著改进的工具：自动工作负载信息库 (AWR)。Oracle 建议用户用这个取代 Statspack。AWR 实质上是一个 Oracle 的内置工具，它采集...
oracle10g生成awr报告,生成oracle 10G的AWR报告
weixin_42511714的博客
04-03 121
使用用户登录，打开终端出现$提示符。$使用Sqlplus连接Oracle实例(SID_NAME用实际实例名称替换)$ORACLE_SID=SID_NAME$export ORACLE_SID$sqlplus / as sysdbaSQL>运行$ORACLE_HOME/rdbms/admin/awrrpt.sql脚本，产生AWR报告。SQL>@?/rdbms/admin/awrrpt.s...
Oracle 10g AWR安装使用
02-09 174
一.用awr生成报告SQL> SQLPLUS / AS SYSDBA SQL> var snap_id number; SQL> exec:snap_id:=dbms_workload_repository...
Oracle10g下生成AWR性能报告步骤
aovenus的专栏-测试新时代（微信公众号：测试新时代）
08-28 3933
Oracle10g下生成AWR性能报告步骤   1.  切换到oracle目录 $ORACLE_HOME/rdbms/admin 2.  使用sqlplus /as sysdba @awrrpt.sql生成性能报告 指定生成报告的类型，默认html格式，建议html格式。默认直接回车 输入需要最近几天的快照信息，这里输入1天的： 列出了最近1天的快照信息，每1
oracle 10g 生成awr报告过程
07-01 438
SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining options[oracle@204_maridb ~]$ sqlplus / as sysdba ...
ORACLE-AWR报告结果分析.doc
11-18
ORACLE-AWR报告结果分析.doc详细介绍了ORACLE-AWR报告的生成过程以及报告结果分析。ORACLE-AWR报告是通过对比两次快照收集到的统计信息来生成报表数据，报表包括多个部分，能够提供系统资源使用情况的报告，帮助了解...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值