Oracle 10g process of generating awr report 02/23 Update SLTechnology News&Howtos

Oracle 10g process of generating awr report

2025-02-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

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

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 TSH1Specify 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_maridbUsing 3047903966 for database IdUsing 1 for instance numberSpecify 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: 52416Begin Snapshot Id specified: 52416Enter value for end_snap: 52434End Snapshot Id specified: 52434Specify 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 Reportbody.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}

Pre.awr {font:8pt Courier;color:black; background:White;} h2.awr {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid # cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}

H3.awr {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}

H4.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;} li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif;color: black; background:White;}

Th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px} th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}

Td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}

Td.awrc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;} a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}

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: 14408K

Load Profile

Per SecondPer Transaction

Redo size: 275.43 110302.15

Logical reads: 6.96 2788.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 19358 50 3 689.2System I/O

Log file parallel write 10837 9 1 127.0System I/O

CPU time 6 85.0

Os thread startup 35 1 42 20.1Concurrency

Db file sequential read 1287 1 1 17.2User I/O

Main Report

Report Summary

Wait Events Statistics

SQL Statistics

Instance Activity Statistics

IO Stats

Buffer Pool Statistics

Advisory Statistics

Wait Statistics

Undo Statistics

Latch Statistics

Segment Statistics

Dictionary Cache Statistics

Library Cache Statistics

Memory Statistics

Streams Statistics

Resource Limit Statistics

Init.ora Parameters

Wait Events Statistics

Time Model Statistics

Wait Class

Wait Events

Background Wait Events

Operating System Statistics

Service Statistics

Service Wait Class Stats

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 CPU 6.18 85.02

Sql execute elapsed time 4.91 67.54

Parse time elapsed 3.45 47.49

Hard parse elapsed time 3.30 45.36

PL/SQL execution elapsed time 1.06 14.53

Connection management call elapsed time 0.14 1.87

PL/SQL compilation elapsed time 0.12 1.69

Failed parse elapsed time 0.08 1.09

Hard parse (sharing criteria) elapsed time 0.02 0.30

Sequence load elapsed time 0.00 0.03

Hard parse (bind mismatch) elapsed time 0.00 0.03

Repeated bind elapsed time 0.00 0.02

DB time 7.27

Background elapsed time 138.22

Background cpu time 129.06

Back to Wait Events Statistics

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/O 72706 0.00 60 1 501.42

Concurrency 47 0.00 1 32 0.32

User I/O 1499 0.00 1 1 10.34

Other 241 0.00 1 2 1.66

Configuration 2 0.00 0 26 0.01

Commit 38 0.00 0 1 0.26

Application 12 0.00 0 1 0.08

Network 1296 0.00 00 8.94

Back to Wait Events Statistics

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 write 19358 0.00 50 3 133.50

Log file parallel write 10837 0.00 9 1 74.74

Os thread startup 35 0.00 1 42 0.24

Db file sequential read 1287 0.00 1 1 8.88

Latch free 20 0.00 1 26 0.14

Control file sequential read 42416 0.00 00 292.52

Db file scattered read 50 0.00 0 4 0.34

Log archive I/O 47 0.00 0 3 0.32

Log file sequential read 46 0.00 0 1 0.32

Log file switch completion 2 0.00 0 26 0.01

Log file sync 38 0.00 0 1 0.26

Latch: library cache lock 5 0.00 0 6 0.03

LGWR wait for redo copy 210 0.00 00 1.45

Rdbms ipc reply 11 0.00 0 1 0.08

SQLNet break/reset to client 12 0.00 0 1 0.08

SQLNet more data to client 172 0.00 00 1.19

Latch: shared pool 1 0.00 0 2 0.01

SQLNet message to client 1112 0.00 00 7.67

Log file single write 2 0.00 01 0.01

Latch: library cache 5 0.00 00 0.03

Buffer busy waits 1 0.00 00 0.01

Direct path write 136 0.00 00 0.94

SQLNet more data from client 12 0.00 00 0.08

Direct path read 26 0.00 00 0.18

Streams AQ: qmn slave idle wait 2073 0.00 56545 27277 14.30

Streams AQ: qmn coordinator idle wait 4150 50.05 56545 13625 28.62

Streams AQ: waiting for time management or cleanup tasks 13 100.00 23673 1821025 0.09

SQL*Net message from client 1112 0.00 19705 17721 7.67

Class slave wait 35 97.14 166 4743 0.24

Jobq slave wait 20 100.00 59 2930 0.14

Back to Wait Events Statistics

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 write 19358 0.00 50 3 133.50

Log file parallel write 10837 0.00 9 1 74.74

Os thread startup 35 0.00 1 42 0.24

Control file sequential read 29786 0.00 00 205.42

Log archive I/O 47 0.00 0 3 0.32

Log file sequential read 46 0.00 0 1 0.32

Events in waitclass Other 221 0.00 00 1.52

Log file single write 2 0.00 01 0.01

Latch: library cache 4 0.00 00 0.03

Buffer busy waits 1 0.00 00 0.01

Direct path read 8 0.00 00 0.06

Direct path write 8 0.00 00 0.06

Rdbms ipc message 187709 99.62 610971 3255 1294.54

Pmon timer 19412 100.00 56680 2920 133.88

Streams AQ: qmn slave idle wait 2073 0.00 56545 27277 14.30

Streams AQ: qmn coordinator idle wait 4150 50.05 56545 13625 28.62

Smon timer 196 97.96 54961 280413 1.35

Streams AQ: waiting for time management or cleanup tasks 13 100.00 23673 1821025 0.09

Back to Wait Events Statistics

Operating System Statistics

StatisticTotal

BUSY_TIME 150595

IDLE_TIME 23037966

NICE_TIME 14

SYS_TIME 62816

USER_TIME 87765

LOAD 0

RSRC_MGR_CPU_WAIT_TIME 0

PHYSICAL_MEMORY_BYTES 161772

NUM_CPUS 4

NUM_CPU_SOCKETS 4

Back to Wait Events Statistics

Service Statistics

Ordered by DB Time

Service NameDB Time (s) DB CPU (s) Physical ReadsLogical Reads

SYS$USERS 7.30 6.20 1517 199781

SYS$BACKGROUND 0.00 0.00 65 206296

Skodacom.skodacom 0.00 0.00 00

Back to Wait Events Statistics

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$USERS

1162 124 7 3 0 0 1219 1

SYS$BACKGROUND

337 22 40 147 0 0 0

Back to Wait Events Statistics

SQL Statistics

SQL ordered by Elapsed Time

SQL ordered by CPU Time

SQL ordered by Gets

SQL ordered by Reads

SQL ordered by Executions

SQL ordered by Parse Calls

SQL ordered by Sharable Memory

SQL ordered by Version Count

Complete List of SQL Text

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

9 9 18 0.48 119.75 bunssq950snhf

Insert into wrh$_sga_target_ad...

2 2 1 2.32 31.86 572fbaj0fdw2b

Sqlplus@204maridb (TNS V1-V3)

Select output from table (dbms...

2 2 1935 0.00 26.70 aykvshm7zsabd

Select size_for_estimate,...

2 2 11613 0.00 21.46 803b7z0t84sq7

Select job, nvl2 (last_date,...

1 0 2 0.50 13.81 95w06sfdyppfj

Navicat.exe

SELECT FROM (SELECT "NAVICAT...

1 1 4 0.23 12.83 0pt2789bczdp0

Navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...

1 1 2 0.38 10.53 15xnmd14bcfby

Navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...

1 1 1 0.76 10.51 5n73rjfpt3q4b

Sqlplus@204_maridb (TNS V1-V3)

BEGIN: snap_id:=dbmsworkload...

1 1 18 0.04 9.53 d92h4rjp0y217

Begin prvt_hdm.auto_execute (:.

11 11613 0.00 9.02 g2wr3u7s1gtf3

Select count () from sys.job$...

00 107 0.00 5.77 g337099aatnuj

Update smon_scntime set orig...

0 0 18 0.02 4.77 84qubbrsr0kfn

Insert into wrh$_latch (snap...

00 1855 0.00 4.27 772s25v1y0x8k

Select shared_pool_size_for_es...

0 0 4 0.07 4.07 86synsm5txwj6

Navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...

0 0 17 0.01 2.13 agpd044zj368m

Insert into wrh$_system_event...

0 0 16 0.01 2.12 32wqka2zwvu65

Insert into wrh$_parameter (...

00 97 0.00 1.88 a1xgxtssv5rrp

Select sum (used_blocks), ts.t...

0 0 2 0.07 1.87 84vvbj8g8sups

Navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...

0 0 1 0.13 1.84 1srfjbzhb29z8

Sqlplus@204_maridb (TNS V1-V3)

Select from sys.wrh$_active...

00 1048 0.00 1.79 g00cj285jmgsw

Update sys.mon_mods$ set inser...

0 0 4 0.03 1.73 d5bwbakqj3f79

Navicat.exe

SELECT OWNER, TABLE_NAME FROM...

00 85 0.00 1.62 6cxqh7mktnbjm

Insert into smon_scn_time (thr...

00 122 0.00 1.50 7cq8d0jqxzum1

Delete from smon_scn_time wher...

0 0 17 0.01 1.43 cvn54b7yz0s8u

Select / + index (idl_ub1 $iVieid.

0 0 18 0.01 1.35 7vgmvmy8vvb9s

Insert into wrh$_tempstatxs...

0 0 15 0.01 1.34 cfz686a6qp0kg

Select o.obj#, u.name, o.nam...

0 0 4 0.02 1.31 chunmygjj8x7g

Navicat.exe

SELECT OWNER, TABLE_NAME, CO...

00 1680 0.00 1.30 8p447s6p0rv6b

Select java_pool_size_for_esti...

0 0 2 0.05 1.25 0m9ka0jk9kk4z

Navicat.exe

SELECT OWNER, TABLE_NAME FROM...

0 0 1 0.08 1.10 8dw6saa5zu2sk

Sqlplus@204_maridb (TNS V1-V3)

Select

Service_name, ui...

00 328 0.00 1.07 bsa0wjtftg3uw

Select file# from file$ where...

00 16 0.00 1.05 586b2udq6dbng

Insert into wrh$_sysstat (sn...

00 16 0.00 1.04 g6wf9na8zs5hb

Insert into wrh$_sysmetric_sum...

Back to SQL Statistics

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

9 9 18 0.48 119.75 bunssq950snhf

Insert into wrh$_sga_target_ad...

2 2 1 2.19 31.86 572fbaj0fdw2b

Sqlplus@204maridb (TNS V1-V3)

Select output from table (dbms...

2 2 1935 0.00 26.70 aykvshm7zsabd

Select size_for_estimate,...

2 2 11613 0.00 21.46 803b7z0t84sq7

Select job, nvl2 (last_date,...

1 1 4 0.23 12.83 0pt2789bczdp0

Navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...

1 1 2 0.38 10.53 15xnmd14bcfby

Navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...

1 1 1 0.73 10.51 5n73rjfpt3q4b

Sqlplus@204_maridb (TNS V1-V3)

BEGIN: snap_id:=dbmsworkload...

1 1 18 0.04 9.53 d92h4rjp0y217

Begin prvt_hdm.auto_execute (:.

11 11613 0.00 9.02 g2wr3u7s1gtf3

Select count () from sys.job$...

00 107 0.00 5.77 g337099aatnuj

Update smon_scntime set orig...

0 0 18 0.02 4.77 84qubbrsr0kfn

Insert into wrh$_latch (snap...

00 1855 0.00 4.27 772s25v1y0x8k

Select shared_pool_size_for_es...

0 1 2 0.13 13.81 95w06sfdyppfj

Navicat.exe

SELECT FROM (SELECT "NAVICAT...

0 0 4 0.06 4.07 86synsm5txwj6

Navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...

0 0 17 0.01 2.13 agpd044zj368m

Insert into wrh$_system_event...

00 97 0.00 1.88 a1xgxtssv5rrp

Select sum (used_blocks), ts.t...

0 0 2 0.07 1.87 84vvbj8g8sups

Navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...

00 1048 0.00 1.79 g00cj285jmgsw

Update sys.mon_mods$ set inser...

0 0 4 0.03 1.73 d5bwbakqj3f79

Navicat.exe

SELECT OWNER, TABLE_NAME FROM...

00 85 0.00 1.62 6cxqh7mktnbjm

Insert into smon_scn_time (thr...

00 122 0.00 1.50 7cq8d0jqxzum1

Delete from smon_scn_time wher...

0 0 1 0.10 1.84 1srfjbzhb29z8

Sqlplus@204_maridb (TNS V1-V3)

Select * from sys.wrh$_active...

0 0 16 0.01 2.12 32wqka2zwvu65

Insert into wrh$_parameter (...

0 0 18 0.01 1.35 7vgmvmy8vvb9s

Insert into wrh$_tempstatxs...

0 0 15 0.01 1.34 cfz686a6qp0kg

Select o.obj#, u.name, o.nam...

0 0 4 0.02 1.31 chunmygjj8x7g

Navicat.exe

SELECT OWNER, TABLE_NAME, CO...

00 1680 0.00 1.30 8p447s6p0rv6b

Select java_pool_size_for_esti...

0 0 2 0.05 1.25 0m9ka0jk9kk4z

Navicat.exe

SELECT OWNER, TABLE_NAME FROM...

0 0 1 0.08 1.10 8dw6saa5zu2sk

Sqlplus@204_maridb (TNS V1-V3)

Select

Service_name, ui...

00 328 0.00 1.07 bsa0wjtftg3uw

Select file# from file$ where...

00 16 0.00 1.05 586b2udq6dbng

Insert into wrh$_sysstat (sn...

00 16 0.00 1.04 g6wf9na8zs5hb

Insert into wrh$_sysmetric_sum...

00 17 0.00 1.43 cvn54b7yz0s8u

Select / * + index (idl_ub1 $iVieid.

Back to SQL Statistics

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: 404261

Captured SQL account for 94.8% of Total

Buffer Gets Executions Gets per Exec% TotalCPU Time (s) Elapsed Time (s) SQL IdSQL ModuleSQL Text

113582 1 113582.00 28.10 2.19 2.32 572fbaj0fdw2b

Sqlplus@204maridb (TNS V1-V3)

Select output from table (dbms...

38995 122 319.63 9.65 0.11 0.11 7cq8d0jqxzum1

Delete from smon_scn_time wher...

37904 4 9476.00 9.38 0.10 0.10 chunmygjj8x7g

Navicat.exe

SELECT OWNER, TABLE_NAME, CO...

34630 107 323.64 8.57 0.42 0.42 g337099aatnuj

Update smon_scntime set orig...

23794 4 5948.50 5.89 0.93 0.93 0pt2789bczdp0

Navicat.exe

SELECT T.TABLE_NAME, T.OWNER,...

23226 11613 2.00 5.75 1.56 1.56 803b7z0t84sq7

Select job, nvl2 (last_date,...

17971 18 998.39 4.45 0.69 0.69 d92h4rjp0y217

Begin prvt_hdm.auto_execute (:.

11613 11613 1.00 2.87 0.66 0.66 g2wr3u7s1gtf3

Select count () from sys.job$...

9525 15 635.00 2.36 0.10 0.10 cfz686a6qp0kg

Select o.obj#, u.name, o.nam...

6019 2 3009.50 1.49 0.26 1.00 95w06sfdyppfj

Navicat.exe

SELECT FROM (SELECT "NAVICAT...

5782 18 321.22 1.43 0.03 0.03 31a13pnjps7j3

SELECT source, (case w.

4944 4 1236.00 1.22 0.13 0.13 d5bwbakqj3f79

Navicat.exe

SELECT OWNER, TABLE_NAME FROM...

4594 2 2297.00 1.14 0.04 0.04 b7jn4mf49n569

Select o.name, u.name from ob...

Back to SQL Statistics

SQL ordered by Reads

Total Disk Reads: 1581

Captured SQL account for 109.7% of Total

Physical ReadsExecutionsReads per Exec% TotalCPU Time (s) Elapsed Time (s) SQL IdSQL ModuleSQL Text

880 2 440.00 55.66 0.26 1.00 95w06sfdyppfj

Navicat.exe

SELECT FROM (SELECT "NAVICAT...

305 4 76.25 19.29 0.22 0.30 86synsm5txwj6

Navicat.exe

SELECT V.VIEW_NAME, V.TEXT_LE...

233 1 233.00 14.74 2.19 2.32 572fbaj0fdw2b

Sqlplus@204maridb (TNS V1-V3)

Select output from table (dbms...

157 17 9.24 9.93 0.07 0.10 cvn54b7yz0s8u

Select / + index (idl_ub1 $iVieid.

73 1 73.00 4.62 0.10 0.13 1srfjbzhb29z8

Sqlplus@204_maridb (TNS V1-V3)

Select * from sys.wrh$_active...

14 12 1.17 0.89 0.02 0.03 a1y2ba3awndas

Sqlplus@204_maridb (TNS V1-V3)

SELECT VALUE FROM DBA_HIST_PAR...

12 1 12.00 0.76 0.73 0.76 5n73rjfpt3q4b

Sqlplus@204_maridb (TNS V1-V3)

BEGIN: snap_id:=dbmsworkload...

12 2 6.00 0.76 0.01 0.03 awppxms81us4n

Sqlplus@204_maridb (TNS V1-V3)

SELECT SUM (TIME_WAITED_MICRO)...

11 18 0.61 0.70 0.69 0.69 d92h4rjp0y217

Begin prvt_hdm.auto_execute (:.

5 583 0.01 0.32 0.04 0.04 5h7w8ykwtb2xt

INSERT INTO SYS.WRI$_ADV_PARAM...

Back to SQL Statistics

SQL ordered by Executions

Total Executions: 41480

Captured SQL account for 90.8% of Total

Executions Rows ProcessedRows per ExecCPU per Exec (s) Elap per Exec (s) SQL IdSQL ModuleSQL Text

11613 0 0.00 0.00 0.00 803b7z0t84sq7

Select job, nvl2 (last_date,...

11613 11613 1.00 0.00 0.00 g2wr3u7s1gtf3

Select count (*) from sys.job$...

1935 40635 21.00 0.00 0.00 aykvshm7zsabd

Select size_for_estimate,...

1855 25970 14.00 0.00 0.00 772s25v1y0x8k

Select shared_pool_size_for_es...

1680 3360 2.00 0.00 0.00 8p447s6p0rv6b

Select java_pool_size_for_esti...

1048 0 0.00 0.00 0.00 350f5yrnnmshs

Lock table sys.mon_mods$ in ex...

1048 1028 0.98 0.00 0.00 g00cj285jmgsw

Update sys.mon_mods$ set inser...

704 704 1.00 0.00 0.00 49s332uhbnsma

Declare

Vsn va...

583 583 1.00 0.00 0.00 5h7w8ykwtb2xt

INSERT INTO SYS.WRI$_ADV_PARAM...

522 403 0.77 0.00 0.00 3c1kubcdjnppq

Update sys.col_usage$ set eq...

504 504 1.00 0.00 0.00 f9u3p2bz694dd

Select count (*) from sys.job$...

466 466 1.00 0.00 0.00 grwydz59pu6mc

Select text from view$ where r...

Back to SQL Statistics

SQL ordered by Parse Calls

Total Parse Calls: 8895

Captured SQL account for 77.5% of Total

Parse CallsExecutions Total Parses SQL IdSQL ModuleSQL Text

1048 1048 11.78 350f5yrnnmshs

Lock table sys.mon_mods$ in ex...

1048 1048 11.78 g00cj285jmgsw

Update sys.mon_mods$ set inser...

704 704 7.91 49s332uhbnsma

Declare

Vsn va...

466 466 5.24 grwydz59pu6mc

Select text from view$ where r...

328 328 3.69 bsa0wjtftg3uw

Select file# from file$ where...

191 191 2.15 chsyr0gssbuqf

Select f.file#, f.block#, f....

171 522 1.92 3c1kubcdjnppq

Update sys.col_usage$ set eq...

171 119 1.92 53btfq0dt9bs9

Insert into sys.col_usage$ val...

171 171 1.92 b2gnxm5z6r51n

Lock table sys.col_usage$ in e...

168 168 1.89 7mvdhsu3d43ag

Select a.obj# OBJOID, a.class...

107 107 1.20 g337099aatnuj

Update smon_scntime set orig...

97 97 1.09 a1xgxtssv5rrp

Select sum (used_blocks), ts.t...

94 94 1.06 0h7b2sajwb74n

Select privilege#, level from...

89 89 1.00 8swypbbr0m372

Select order#, columns, types...

89 89 1.00 cqgv56fmuj63x

Select owner#, name, namespace...

Back to SQL Statistics

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics

Complete List of SQL Text

SQL IdSQL Text

0h7b2sajwb74nselect 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

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(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)) 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.