awrrpt_1_21676_21699

WORKLOAD REPOSITORY report for

DB Name DB IdFLCP 2210110125

Host Name PlatformCLKLXFLCDBP01 Linux x86 64-bit

Snap IdBegin Snap: 21676

End Snap: 21699

Elapsed:

DB Time:

Report Summary

Cache Sizes

BeginBuffer Cache: 544M

Shared Pool Size: 800M

Load Profile

Per SecondDB Time(s): 0.6

DB CPU(s): 0.5

Redo size: 20,840.60

Logical reads: 18,053.00

Block changes: 142.9

Physical reads: 214.8

Physical writes: 3.5

User calls: 99.5

Parses: 17

Hard parses: 0.1

W/A MB processed: 12.6

Logons: 0

Executes: 106.7

Rollbacks: 0

Transactions: 2.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100

Buffer Hit %: 99.73

Library Hit %: 99.91

Execute to Parse %: 84.1

Parse CPU to Parse Elapsd %: 84.66

Shared Pool Statistics

BeginMemory Usage %: 88.83

% SQL with executions>1: 96.97

% Memory for SQL w/exec>1: 93.05

Top 5 Timed Foreground Events

Event WaitsDB CPU

db file sequential read 653,664

db file scattered read 316,529

resmgr:cpu quantum 22,153

direct path read 104,325

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average Begin Load Average End1.98 0.41

Instance CPU

%Total CPU %Busy CPU

24.3 95.6

Memory Statistics

BeginHost Mem (MB): 7,855.70

SGA use (MB): 1,536.00

PGA use (MB): 470.7

% Host Mem used for SGA+PGA: 25.54

Main Report

Report SummaryWait Events StatisticsSQL StatisticsInstance Activity StatisticsIO StatsBuffer Pool StatisticsAdvisory StatisticsWait StatisticsUndo StatisticsLatch StatisticsSegment StatisticsDictionary Cache StatisticsLibrary Cache StatisticsMemory StatisticsStreams StatisticsResource Limit StatisticsShared Server Statistics

Wait Events Statistics

Time Model Statistics

Total time in database user-calls (DB Time): 48862.9s

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 Name Time (s)sql execute elapsed time 46,112.35

DB CPU 38,847.96

parse time elapsed 504.27

hard parse elapsed time 458.91

PL/SQL execution elapsed time 457.07

failed parse elapsed time 209.77

RMAN cpu time (backup/restore) 32.84

sequence load elapsed time 30.6

hard parse (sharing criteria) elapsed time 30.26

connection management call elapsed time 10.01

hard parse (bind mismatch) elapsed time 8.57

repeated bind elapsed time 4.94

inbound PL/SQL rpc elapsed time 3.99

PL/SQL compilation elapsed time 3.11

Java execution elapsed time 0.11

DB time 48,862.95

background elapsed time 8,930.06

background cpu time 476.67

init.ora Parameters

Back to Top

Time Model StatisticsOperating System StatisticsOperating System Statistics - DetailForeground Wait ClassForeground Wait EventsBackground Wait EventsWait Event HistogramWait Event Histogram Detail (64 msec to 2 sec)Wait Event Histogram Detail (4 sec to 2 min)Wait Event Histogram Detail (4 min to 1 hr)Service StatisticsService Wait Class Stats

Back to Top

Back to Wait Events StatisticsBack to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different

ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic ValueBUSY_TIME 4,112,439

IDLE_TIME 12,086,292

IOWAIT_TIME 394,936

NICE_TIME 2,178

SYS_TIME 109,704

USER_TIME 3,962,473

LOAD 2

RSRC_MGR_CPU_WAIT_TIME 113,699

VM_IN_BYTES 230,410,700,800

VM_OUT_BYTES 17,114,957,824

PHYSICAL_MEMORY_BYTES 8,237,330,432

NUM_CPUS 2

GLOBAL_RECEIVE_SIZE_MAX 4,194,304

GLOBAL_SEND_SIZE_MAX 1,048,576

TCP_RECEIVE_SIZE_DEFAULT 87,380

TCP_RECEIVE_SIZE_MAX 4,194,304

TCP_RECEIVE_SIZE_MIN 4,096

TCP_SEND_SIZE_DEFAULT 16,384

TCP_SEND_SIZE_MAX 4,194,304

TCP_SEND_SIZE_MIN 4,096

Operating System Statistics - Detail

Snap Time Load5/31/2013 0:00 1.98

5/31/2013 1:00 1.02

5/31/2013 2:00 0.53

5/31/2013 3:00 0.36

5/31/2013 4:00 0.22

5/31/2013 5:00 0.53

5/31/2013 6:00 0.22

5/31/2013 7:00 0.08

5/31/2013 8:00 0.01

5/31/2013 9:00 0.28

5/31/2013 10:00 0.04

5/31/2013 11:00 0.46

5/31/2013 12:00 0.04

5/31/2013 13:00 0.36

5/31/2013 14:00 0.64

5/31/2013 15:00 1.06

5/31/2013 16:00 0.8

5/31/2013 17:00 1.22


5/31/2013 18:00 1.87

5/31/2013 19:00 0.35

5/31/2013 20:00 0.4

5/31/2013 21:00 0.91

5/31/2013 22:00 0.45

5/31/2013 23:00 0.41

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second

ordered by wait time desc, waits desc

%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Captured Time accounts for 91.9% of Total DB time 48,862.95 (s)

Total FG Wait Time: 6,047.07 (s) DB CPU time: 38,847.96 (s)

Wait Class WaitsDB CPU

User I/O 1,119,450

Scheduler 22,153

Commit 169,674

Network 7,770,474

System I/O 89,884

Concurrency 4,615

Application 332

Other 600,468

Configuration 97

Administrative 2

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second

Only events with Total Wait Time (s) >= .001 are shown

ordered by wait time desc, waits desc (idle events last)


Event Waitsdb file sequential read 653,664

db file scattered read 316,529


direct path read 104,325

log file sync 169,674

read by other session 38,646

control file sequential read 89,577

SQL*Net message to client 7,544,768

TCP Socket (KGAS) 1,649

enq: TX - row lock contention 12



library cache lock 29

latch: cache buffers chains 2,648

SQL*Net more data from client 14,214

ADR block file read 833

ASM file metadata operation 255

SQL*Net more data to client 209,843

direct path write 1,248

library cache: mutex X 1,315

db file parallel read 131

asynch descriptor resize 598,044

recovery area: computing obsolete files 2

latch: row cache objects 27

enq: TX - index contention 116

latch: shared pool 20

enq: KO - fast object checkpoint 239

CSS initialization 96

Disk file operations I/O 3,323

buffer busy waits 360

latch free 72

undo segment extension 7

recovery area: computing backed up files 2

control file single write 80

direct path write temp 66

log file switch (private strand flush incomplete) 13

log file sequential read 59

enq: TM - contention 1

buffer exterminate 27

RMAN backup & recovery I/O 47

CSS operation: action 96

row cache lock 55

reliable message 190

enq: SQ - contention 74

CSS operation: query 576

control file parallel write 110

recovery area: computing dropped files 2

switch logfile command 2

utl_file I/O 1,512

ADR block file write 115

SQL*Net break/reset to client 80

cursor: pin S 20

library cache load lock 1

enq: CF - contention 5

log file switch completion 3

cursor: pin S wait on X 1

latch: In memory undo latch 22

latch: enqueue hash chains 6

direct path read temp 4

Log archive I/O 3

kfk: async disk IO 8

ADR file lock 138

latch: undo global data 1

SQL*Net message from client 7,544,767

jobq slave wait 32,224

wait for unread message on broadcast channel 3,300

PL/SQL lock timer 1

KSV master wait 579

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Only events with Total Wait Time (s) >= .001 are shown


Event WaitsBackup: MML create a backup piece 4

RMAN backup & recovery I/O 127,286

log file parallel write 247,017

control file sequential read 310,488

ASM file metadata operation 143,902

control file parallel write 97,348

db file parallel write 158,610

db file sequential read 16,398


Backup: MML write backup piece 9,690

LNS wait on SENDREQ 245,903

os thread startup 1,002

Parameter File I/O 22,084

log file sequential read 2,550

Backup: MML commit backup piece 4

db file scattered read 867

Backup: MML query backup piece 4

ADR block file read 416


Disk file operations I/O 25,290

Data file init write 755

SQL*Net more data from client 138

enq: PV - syncstart 1


direct path read 149


LGWR wait for redo copy 836


rdbms ipc reply 159

log file sync 48




direct path write 107

log file single write 192

latch free 58

Log archive I/O 46


read by other session 2

latch: redo allocation 51


enq: TC - contention 1

asynch descriptor resize 3,777

enq: JS - queue lock 9


enq: CR - block range reuse ckpt 41

latch: messages 4



latch: cache buffers chains 3

Backup: MML shutdown 1

db file single write 14


SQL*Net message to client 3,437

enq: RO - fast object reuse 37

latch: cache buffers lru chain 8

SQL*Net more data to client 138

latch: call allocation 2

ADR file lock 160

rdbms ipc message 802,817

EMON slave idle wait 82,712

class slave wait 36,799

DIAG idle wait 164,377

Space Manager: slave idle wait 25,349

Streams AQ: emn coordinator idle wait 8,273

wait for unread message on broadcast channel 83,100

ASM background timer 63,298

shared server idle wait 2,758

smon timer 449

pmon timer 27,694

dispatcher timer 1,379

Streams AQ: qmn coordinator idle wait 5,924

Streams AQ: qmn slave idle wait 3,030

LNS ASYNC end of log 294,270

1

KSV master wait 50,968

JOX Jit Process Sleep 14

SQL*Net message from client 4,422

SGA: MMAN sleep for component shrink 756

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000

% of Waits: value of .0 indicates value was <.05%; value of null is truly 0

% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms

Ordered by Event (idle events last)

Event Total WaitsADR block file read 1249

Streams AQ: waiting for time management or cleanup tasks



ADR file lock 298

ARCH wait for archivelog lock 52

ASM file metadata operation 144.1K


Backup: MML create a backup piece 4


Backup: MML shutdown 1

Backup: MML write backup piece 9690




Data file init write 755

Disk file operations I/O 28.6K

LGWR wait for redo copy 836

LNS wait on SENDREQ 245.9K

Log archive I/O 48

Parameter File I/O 22.1K

RMAN backup & recovery I/O 127.3K

SQL*Net break/reset to client 68

SQL*Net message to client 7548.1K

SQL*Net more data from client 14.4K

SQL*Net more data to client 210K

TCP Socket (KGAS) 1649

asynch descriptor resize 601.8K

buffer busy waits 369

buffer deadlock 2

buffer exterminate 27

control file parallel write 97.4K

control file sequential read 399.5K


cursor: mutex S 1

cursor: pin S 20

cursor: pin S wait on X 1


db file parallel write 158.6K

db file scattered read 317.3K

db file sequential read 670.1K

db file single write 14

direct path read 104.5K

direct path read temp 4




enq: CR - block range reuse ckpt 41

enq: JS - queue lock 9



enq: RF - synch: DG Broker metadata 6

enq: RO - fast object reuse 37

enq: SQ - contention 74






latch free 130

latch: In memory undo latch 22


latch: cache buffers lru chain 10

latch: call allocation 3

latch: checkpoint queue latch 1


latch: messages 4

latch: object queue header operation 4

latch: redo allocation 51



latch: undo global data 1



library cache: mutex X 1315

log file parallel write 247K


log file single write 192



log file sync 169.7K

os thread startup 1002

rdbms ipc reply 159

read by other session 38.6K





resmgr:cpu quantum 23.3K

row cache lock 55



utl_file I/O 1512

ASM background timer 63.3K

DIAG idle wait 164.4K

EMON slave idle wait 82.7K

JOX Jit Process Sleep 14

KSV master wait 51.5K

LNS ASYNC end of log 294.3K

PL/SQL lock timer 1

SGA: MMAN sleep for component shrink 756

SQL*Net message from client 7548.9K

Space Manager: slave idle wait 25.3K

Streams AQ: emn coordinator idle wait 8273

Streams AQ: qmn coordinator idle wait 5924

Streams AQ: qmn slave idle wait 3030

1

VKRM Idle 1

class slave wait 36.8K

dispatcher timer 1379

Streams AQ: waiting for time management or cleanup tasks

jobq slave wait 32.2K

pmon timer 27.7K

rdbms ipc message 802.8K

shared server idle wait 2758

smon timer 448

wait for unread message on broadcast channel 86.4K

Wait Event Histogram Detail (64 msec to 2 sec)


Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)

% of Total Waits: total waits for all wait classes, including Idle

% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0

Ordered by Event (only non-idle events are displayed)

Event Waits 64ms to 2sADR block file read 21


ASM file metadata operation 1078

Backup: MML create a backup piece 3


Backup: MML write backup piece 18


Disk file operations I/O 4

LNS wait on SENDREQ 89

Parameter File I/O 62

RMAN backup & recovery I/O 461

SQL*Net message to client 327

SQL*Net more data from client 42

SQL*Net more data to client 1

TCP Socket (KGAS) 73

asynch descriptor resize 7

buffer busy waits 3

control file parallel write 1013

control file sequential read 1483



db file parallel write 363

db file scattered read 2193

db file sequential read 4404

direct path read 2391











latch free 4






library cache: mutex X 15

log file parallel write 2065



log file sync 2138

os thread startup 138

rdbms ipc reply 2

read by other session 431




reliable message 2

resmgr:cpu quantum 11.8K



Wait Event Histogram Detail (4 sec to 2 min)


Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)

% of Total Waits: total waits for all wait classes, including Idle

% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0

Ordered by Event (only non-idle events are displayed)

Event Waits 4s to 2mASM file metadata operation 11


TCP Socket (KGAS) 2


Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.




Service Statistics

ordered by DB Time

Service Name DB Time (s)SYS$USERS 48,846

FLCP.WORLD 19

FLCPXDB 0

SYS$BACKGROUND 0

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 seconds

Service Name User I/O Total WtsSYS$USERS 1119105

FLCP.WORLD 981

SYS$BACKGROUND 65084

SQL Statistics

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

%Total - Elapsed Time as a percentage of Total DB time



SQL ordered by Elapsed TimeSQL ordered by CPU TimeSQL ordered by User I/O Wait TimeSQL ordered by GetsSQL ordered by ReadsSQL ordered by Physical Reads (UnOptimized)SQL ordered by ExecutionsSQL ordered by Parse CallsSQL ordered by Sharable MemorySQL ordered by Version CountComplete List of SQL Text

Back to Top

%CPU - CPU Time as a percentage of Elapsed Time

%IO - User I/O Time as a percentage of Elapsed Time

Captured SQL account for 103.5% of Total DB Time (s): 48,863

Captured PL/SQL account for 11.1% of Total DB Time (s): 48,863

Elapsed Time (s) Executions11,133.45 360,353

10,498.93 150,648

5,166.13 4,786

4,649.69 3,867

4,381.32 8,640

3,774.83 150,627

3,196.26 150,613

3,166.02 150,588

2,294.44 3,999

2,158.54 5,887

1,149.18 4,803

608.02 577

SQL ordered by CPU Time


%Total - CPU Time as a percentage of Total DB CPU



Captured SQL account for 106.6% of Total CPU Time (s): 38,848

Captured PL/SQL account for 9.4% of Total CPU Time (s): 38,848

CPU Time (s) Executions9,894.99 360,353

9,651.05 150,648

3,695.79 4,786

3,464.84 150,627

3,376.07 3,867

2,914.88 150,613

2,914.02 150,588

2,282.97 8,640

1,665.49 3,999

1,564.11 5,887

1,056.15 4,803

444.65 577

Back to SQL StatisticsBack to Top


SQL ordered by User I/O Wait Time


%Total - User I/O Time as a percentage of Total User I/O Wait time



Captured SQL account for 117.4% of Total User I/O Wait Time (s): 4,357

Captured PL/SQL account for 30.3% of Total User I/O Wait Time (s): 4,357

User I/O Time (s) Executions1,950.28 8,640

1,164.49 4,786

1,000.73 3,867

506.28 3,999

428.16 5,887

231.99 1

197.43 191

131.01 577

104.97 293

100.56 1

79.38 10

72.37 66

45.07 4,418

SQL ordered by Gets


%Total - Buffer Gets as a percentage of Total Buffer Gets



Total Buffer Gets: 1,494,038,414

Captured SQL account for 106.8% of Total

Buffer Gets Executions265,354,724 150,627

265,337,396 150,648

265,310,284 150,588

265,304,334 150,613

128,457,935 8,640

96,263,927 4,786

88,151,680 3,867

75,471,796 360,353

51,516,911 5,887

43,842,821 3,999

27,941,327 4,803


26,134,544 115,404

23,929,233 4,993

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads



Total Disk Reads: 17,774,468


Physical Reads Executions13,256,302 8,640

2,183,617 191

1,636,817 4,786

1,103,762 3,867

564,409 3,999

444,716 5,887

311,441 293

249,611 577

114,003 1

66,837 44

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs

%Opt - Optimized Reads as percentage of SQL Read Requests

%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs

Total Physical Read Requests: 1,106,218


Total UnOptimized Read Requests: 1,106,218


Total Optimized Read Requests: 1


UnOptimized Read Reqs Physical Read Reqs165,574 165,574

116,673 116,673

38,148 38,148

18,046 18,046

15,343 15,343

12,296 12,296

10,515 10,515



6,762 6,762

5,285 5,285

3,748 3,748

SQL ordered by Executions



Total Executions: 8,826,696


Executions Rows Processed642,667 642,666

619,420 619,419

360,353 23,292

328,580 328,580

311,665 256,359

175,662 175,662

150,648 530

150,627 2,005

150,613 1,462

150,588 13

147,260 84,431

116,753 58,394

115,404 4,555,338

111,313 111,313

SQL ordered by Parse Calls

Total Parse Calls: 1,403,008


Parse Calls Executions116,608 116,753

107,129 111,313

24,143 328,580

23,266 76,168

22,435 22,435

15,158 15,158

12,402 12,402

12,401 12,401



12,213 12,899

11,686 12,006

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b) Executions3,307,251 108

2,855,984 133

2,312,110 1

2,295,104 170

2,175,273 2,625

1,660,969 40

1,604,504 2,047

1,384,217 1,070

1,370,452 46

1,350,483 108

1,248,234 46

1,187,098 482

1,131,746 60

1,077,206 1

1,077,194 23

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count Executions123 108

123 108

123 108

123 108

123 108

123 108

123 108

89 133

89 133

89 133

21 1,147



Complete List of SQL Text

SQL Id SQL Text01d5n1nm17r2h

0bkjwu3swz0wy

17jn6anhgwns5

1q3jj96ycbjtb delete from FLIGHT_ULD where FLU_ID = :1

1znntxfy46782

239n3h55fcak1

23xqu9u9s36zd

2bjggjqk03ar8


select nvl2(stale_stats, decode(stale_stats, 'NO', 3, 1), 2) from dba_ind_statistics where owner=:1 and index_name=:2

SELECT value, type FROM v$parameter WHERE name = :1

INSERT INTO FLIGHT_ULD (FLU_ULD_OWN, FLU_HUID, FLU_GWT, FLU_TWT, FLU_NWT, FLU_VOL_PCT, FLU_AP_FR, FLU_AP_TO, FLU_GRP, FLU_REMARK, FLU_LP_REMARK, FLU_ULDT_ID, FLU_FL_ID, FLU_NAME, FLU_ULD_SERIAL_NR, FLU_SHADOW, FLU_LAST_CHANGE_BY, FLU_UHC_ID, FLU_STATUS, FLU_FRT_TD_ID, FLU_CTR_TD_ID, FLU_ACTUAL, FLU_TYPE, FLU_BT_TD_ID, FLU_TRF_TD_ID, FLU_FFL_TD_ID, FLU_TRF_FLNR, FLU_BAGS, FLU_VOL, FLU_TRAVEL, FLU_PRIORITY, FLU_NUM_OF_PIECES, FLU_SBC_TD_ID, FLU_POU, FLU_OFF_LOAD_LOCK, FLU_ON_LOAD_LOCK, FLU_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, NULL, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

select fl_id, acr_act_id, fl_trim_state, fl_std, sysdate - 1 as the_past, acr_id, acr_reg_nr, acr_pax, fl_ap_to, CASE WHEN (fl_a_fblst IS NULL AND fl_a_frmp IS NULL AND fl_a_ftxi IS NULL AND fl_a_ftrp IS NULL) THEN 0 ELSE 1 END final_fuel, acr_opr_id, fl_flt_td_id, acr_actst_id from flight, ac_reg where acr_id = fl_acr_id and fl_flnr = :1 and fl_ap_fr = :2 and fl_ap_to = :3 and (select lg_first_leg_date_local from leg_group where fl_lg_id = lg_id) = :4

UPDATE FLIGHT_ULD B SET FLU_TF_FLU_ID = NULL WHERE FLU_TF_FLU_ID IS NOT NULL AND NOT EXISTS (SELECT NULL FROM FLIGHT_ULD A WHERE A.FLU_ID = B.FLU_TF_FLU_ID)

SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = :B1 AND NOT COLUMN_NAME IN (SELECT AUT_SHADOW FROM AUDIT_TABLES WHERE AUT_TABLE_NAME = :B1 )

SELECT dest_id FROM v$archive_dest WHERE lower(destination) = lower('FLCP_IBCLXFLCDB01') AND (dest_name not in ( select alternate from v$archive_dest))

3958xb2mvh047

3j2p1zh0uazqj

3jyk3kjz0bwwa UPDATE CTX_USER SET CTXU_USER = :B1

select /*+ no_parallel_index(t, "IND_FK_FLU_AP_TO") dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index(t, "IND_FK_FLU_AP_TO") */ count(*) as nrw, count(distinct sys_op_lbid(91610, 'L', t.rowid)) as nlb, null as ndk, sys_op_countchg(substrb(t.rowid, 1, 15), 1) as clf from "SABLE_CX"."FLIGHT_ULD" t where "FLU_AP_TO" is not null

INSERT INTO FLIGHT (FL_S_FBLST, FL_S_FRMP, FL_S_FTXI, FL_S_FTRP, FL_A_FBLST, FL_A_FRMP, FL_A_FTXI, FL_A_FTRP, FL_MZFW, FL_MTW, FL_MTOW, FL_MLW, FL_TRIM_STATE, FL_ACTFTS_ID, FL_AP_FR, FL_AP_TO, FL_STD, FL_OD, FL_FLNR, FL_ACR_ID, FL_FUEL_DEN, FL_FUEL_DEN_UNT_ID, FL_LEN_DUNT_ID, FL_WT_DUNT_ID, FL_FUEL_DUNT_ID, FL_SHADOW, FL_SUP_INFO, FL_JSB_ACCEPTED, FL_BAR, FL_BAR_ORIGIN, FL_LDM, FL_ACTFM_ID, FL_NOSHOW, FL_PAX_TOT, FL_PAX_CLS, FL_PAX_GEN, FL_PAX_CLS_GEN, FL_RECALC, FL_AUTOLOAD, FL_TRIM_PHASE, FL_A_PAX_FINAL, FL_A_TRF_FINAL, FL_A_BAG_FINAL, FL_EZFW_EDNO, FL_EZFW_AT_EDNO, FL_EZFW_TIME, FL_AZFW_EDNO, FL_AZFW_AT_EDNO, FL_AZFW_TIME, FL_STD_MZFW, FL_STD_MTW, FL_STD_MTOW, FL_STD_MLW, FL_BAG_CLS, FL_IND_A_BAG, FL_FLT_TD_ID, FL_STD_LOCAL, FL_STA, FL_LG_ID, FL_LG_SEQ_NR, FL_LOADSHEET_FINAL, FL_LDMUCM_FINAL, FL_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63)

424h0nf7bhqzd

477jzbnj2kkjc

4m7m0t6fjcs5x

4x866jn4mj1uy

53a8kaygxu00w

5f0qauvgms6nd

5nfc6vt4wa3td

SELECT sqlset_row(sql_id, force_matching_signature, sql_text, object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, priority, command_type, first_load_time, stat_period, active_stat_period, other, plan_hash_value, sql_plan, bind_list) FROM ( SELECT /*+ first_rows(1) */ sql_id, force_matching_signature, sql_text, cast(NULL as SQL_OBJECTS) object_list, bind_data, parsing_schema_name, module, action, elapsed_time, cpu_time, buffer_gets, disk_reads, direct_writes, rows_processed, fetches, executions, end_of_fetch_count, optimizer_cost, optimizer_env, NULL priority, command_type, NULL first_load_time, null stat_period, null active_stat_period, xmlelement( "other_attrs", xmlelement("parsing_user_id", parsing_user_id)).getClobVal() other, plan_hash_value, cast(NULL as SQL_PLAN_TABLE_TYPE) sql_plan, cast (NULL as SQL_BINDS) bind_list FROM ((SELECT t1.sql_id, t1.force_matching_signature, sql_text, module, action, selap as ELAPSED_TIME, scpu as CPU_TIME, sbgets as BUFFER_GETS, swrites as DIRECT_WRITES, sdreads as DISK_READS, srow as ROWS_PROCESSED , sfetches as fetches, sexec as EXECUTIONS, seofc as end_of_fetch_count, optimizer_cost, optimizer_env, command_type, parsing_schema_name, parsing_user_id, T1.snap_id, T1.plan_hash_value, T1.dbid, loaded_versions, bind_data FROM (SELECT sql_id, force_matching_signature, action, module, snap_id, dbid, loaded_versions, instance_number, sql_text, SELECT COUNT (*) FROM CTX_USER WHERE CTXU_USER IS NOT NULL

update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'

INSERT INTO flight_uld_dgr (fludgr_id, fludgr_flu_id, fludgr_dgr_id, fludgr_shadow, fludgr_weight, fludgr_remark, fludgr_ti) SELECT -fludgr_id, ABS(fludgr_flu_id), fludgr_dgr_id, NULL, fludgr_weight, fludgr_remark, fludgr_ti FROM flight_uld_dgr WHERE ABS(fludgr_flu_id) = ABS(:1) AND fludgr_shadow = 'INS'

SELECT COUNT(vwflls_flu_id) FROM view_flight_load_seq, flight_uld WHERE vwflls_fl_id = :1 AND vwflls_dist = 2 AND flu_id = vwflls_flu_id AND flu_tf_flu_id IS NULL

SELECT LS_VERSION, USR_CODE, LS_TIMESTAMP, LSA_RCV_MSG, LSA_RCV_TIMESTAMP, LSA_RCV_COLOR FROM LOADSHEET LEFT OUTER JOIN USERS ON LS_USR_ID = USR_ID LEFT OUTER JOIN LOADSHEETACARS ON LS_ID = LSA_LS_ID WHERE LS_FL_ID = :1 ORDER BY LS_VERSION

5xxxrg5ckv1k3

5zruc4v6y32f9

69x26sjrctxv8

6mcpb06rctk0x call dbms_space.auto_space_advisor_job_proc ( )

MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN STALENESS > LOG(0.01, NVL(LOC_STALE_PCT, :B1 )/100) THEN 128 ELSE 0 END + AFLAGS AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#( +) = S.TS# AND DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

select segment_name, segment_type, extents, max_extents from sys.dba_segments where max_extents-extents<100

6wm3n4d7bnddg

72ukkfmh7y7dz

7417dx8xc2n5u

8szmwam7fysa3

8ums58rsq08u1 DELETE FROM ctx_user

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(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.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(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND UPDATE FLIGHT SET FL_S_FBLST = :1, FL_S_FRMP = :2, FL_S_FTXI = :3, FL_S_FTRP = :4, FL_A_FBLST = :5, FL_A_FRMP = :6, FL_A_FTXI = :7, FL_A_FTRP = :8, FL_MZFW = :9, FL_MTW = :10, FL_MTOW = :11, FL_MLW = :12, FL_TRIM_STATE = :13, FL_ACTFTS_ID = :14, FL_AP_FR = :15, FL_AP_TO = :16, FL_STD = :17, FL_OD = :18, FL_FLNR = :19, FL_ACR_ID = :20, FL_FUEL_DEN = :21, FL_FUEL_DEN_UNT_ID = :22, FL_LEN_DUNT_ID = :23, FL_WT_DUNT_ID = :24, FL_FUEL_DUNT_ID = :25, FL_SHADOW = :26, FL_SUP_INFO = :27, FL_JSB_ACCEPTED = :28, FL_BAR = :29, FL_BAR_ORIGIN = :30, FL_LDM = :31, FL_ACTFM_ID = :32, FL_NOSHOW = :33, FL_PAX_TOT = :34, FL_PAX_CLS = :35, FL_PAX_GEN = :36, FL_PAX_CLS_GEN = :37, FL_RECALC = :38, FL_AUTOLOAD = :39, FL_TRIM_PHASE = :40, FL_A_PAX_FINAL = :41, FL_A_TRF_FINAL = :42, FL_A_BAG_FINAL = :43, FL_EZFW_EDNO = :44, FL_EZFW_AT_EDNO = :45, FL_EZFW_TIME = :46, FL_AZFW_EDNO = :47, FL_AZFW_AT_EDNO = :48, FL_AZFW_TIME = :49, FL_STD_MZFW = :50, FL_STD_MTW = :51, FL_STD_MTOW = :52, FL_STD_MLW = :53, FL_BAG_CLS = :54, FL_IND_A_BAG = :55, FL_FLT_TD_ID = :56, FL_STD_LOCAL = :57, FL_STA = :58, FL_LG_ID = :59, FL_LG_SEQ_NR = :60, FL_LOADSHEET_FINAL = :61, FL_LDMUCM_FINAL = :62 WHERE FL_ID = :63

SELECT fludgr_id FROM flight_uld_dgr WHERE fludgr_shadow = 'UPD' AND ABS(fludgr_flu_id) = ABS(:1) AND fludgr_id < 0

insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))

8xgd2r1h0kr34

9wygvu6cx2npy

a7a6ygz8y7762 DELETE FROM FLIGHT_ULD WHERE FLU_ID = :B1

a927uzs9sa0zd

a94ftn6jmcrpm SELECT SEQ_AUDIT_LOG.NEXTVAL FROM DUAL

insert into wri$_adv_sqlt_plans (statement_id, timestamp, operation, options, object_node, object_owner, object_name, object_instance, object_type, search_columns, id, parent_id, position, other, optimizer, cost, cardinality, bytes, other_tag, partition_start, partition_stop, partition_id, distribution, cpu_cost, io_cost, temp_space, access_predicates, filter_predicates, projection, time, qblock_name, object_alias, plan_id, depth, remarks, other_xml) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

DELETE FROM WRI$_ADV_MESSAGE_GROUPS A WHERE A.TASK_ID = :B2 AND (:B1 IS NULL OR :B1 = A.EXEC_NAME)

select 'INTER_MEDIA' as name, decode((select username from dba_users where username='ORDSYS'), 'ORDSYS', 'TRUE', 'FALSE') as selected from dual union select 'SPATIAL' as name, decode((select username from dba_users where username='MDSYS'), 'MDSYS', 'TRUE', 'FALSE') as selected from dual union select 'OLAP' as name, decode((select username from dba_users where username='OLAPSYS'), 'OLAPSYS', 'TRUE', 'FALSE') as selected from dual union select 'ORACLE_TEXT' as name, decode((select username from dba_users where username='CTXSYS'), 'CTXSYS', 'TRUE', 'FALSE') as selected from dual union select 'ULTRA_SEARCH' as name, decode((select username from dba_users where username='WKSYS'), 'WKSYS', 'TRUE', 'FALSE') as selected from dual union select 'LABEL_SECURITY' as name, decode((select username from dba_users where username='LBACSYS'), 'LBACSYS', 'TRUE', 'FALSE') as selected from dual union select 'SAMPLE_SCHEMA' as name, decode((select count(*) from dba_users where username IN('HR', 'PM', 'QS', 'SH', 'OE')), 0, 'FALSE', 'TRUE') as selected from dual union select 'JSERVER' as name, decode((select count(*) from sys.obj$ where type#=29), 0, 'FALSE', 'TRUE') as selected from dual union select 'ORACLE_DATA_MINING' as name, decode((select status from dba_registry where comp_id='ODM'), 'VALID', 'TRUE', 'FALSE') as selected from dual union select 'XDB' as name, decode((select username from dba_users where username='XDB'), 'XDB', 'TRUE', 'FALSE') as selec ted from dual union select 'EM_REPOSITORY' as name, decode((select username from dba_users where username='SYSMAN'), 'SYSMAN', 'TRUE', 'FALSE') as

ab3swhv5g138y

ah7s7nxmj2n5w

ajud2fbak4n5q BEGIN pack_reload.deassign_position(:1, :2, :3); END;

arvad97suq7p1 BEGIN pack_audit.set_context_user(:1); END;

b6usrg82hwsa3 call dbms_stats.gather_database_stats_job_proc ( )

bghk5x23n0682

bmquxnvdftw7t

select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), 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, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 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.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY' )) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time),

SELECT COUNT(vwflls_flu_id) FROM view_flight_load_seq, flight_uld, flight_config WHERE vwflls_fl_id = :1 AND vwflls_dist = 1 AND flu_id = vwflls_flu_id AND vwflls_actdlp_id = flc_actdlp_id AND flc_flu_id = flu_id

INSERT INTO FLIGHT_ULD (FLU_ULD_OWN, FLU_HUID, FLU_GWT, FLU_TWT, FLU_NWT, FLU_VOL_PCT, FLU_AP_FR, FLU_AP_TO, FLU_GRP, FLU_REMARK, FLU_LP_REMARK, FLU_ULDT_ID, FLU_FL_ID, FLU_NAME, FLU_ULD_SERIAL_NR, FLU_SHADOW, FLU_LAST_CHANGE_BY, FLU_UHC_ID, FLU_STATUS, FLU_FRT_TD_ID, FLU_CTR_TD_ID, FLU_ACTUAL, FLU_TYPE, FLU_BT_TD_ID, FLU_TRF_TD_ID, FLU_FFL_TD_ID, FLU_TRF_FLNR, FLU_BAGS, FLU_VOL, FLU_TRAVEL, FLU_PRIORITY, FLU_NUM_OF_PIECES, FLU_SBC_TD_ID, FLU_POU, FLU_OFF_LOAD_LOCK, FLU_ON_LOAD_LOCK, FLU_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, 'U', :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36)

SELECT value FROM v$parameter WHERE name = 'spfile'

bqqwtnz5f54q4

bwf4gb43gftx2

c2p32r5mzv8hb BEGIN prvt_advisor.delete_expired_tasks; END;

d0ckx4p2hrg91

db3q2xdrx0fsd

db4s8nqngnr03

dsnk22bby5s7b

dxb7nztnykx9q

dxw3x3na1vsxn SELECT CTXU_USER FROM CTX_USER

f12tdjj14dvpw

f30k0j8r8wbx2

f68tgm3hzwnnz

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

fugp3z26mj1ad

select fl_id, acr_act_id, fl_trim_state, fl_std, sysdate - 1 as the_past, acr_id, acr_reg_nr, acr_pax, fl_ap_to, CASE WHEN (fl_a_fblst IS NULL AND fl_a_frmp IS NULL AND fl_a_ftxi IS NULL AND fl_a_ftrp IS NULL) THEN 0 ELSE 1 END final_fuel, acr_opr_id, fl_flt_td_id, acr_actst_id from flight, ac_reg where acr_id = fl_acr_id and fl_flnr = :1 and fl_ap_fr = :2 and fl_ap_to = :3 and trunc(fl_std_local) = :4

UPDATE flight_load_seq SET flls_pct_mac = -1 WHERE flls_fl_id = :1

DELETE FROM flight_uld_dgr WHERE fludgr_id < 0 AND ABS(fludgr_flu_id) = ABS(:1)

UPDATE FLIGHT_ULD SET FLU_ULD_OWN = :1, FLU_HUID = :2, FLU_GWT = :3, FLU_TWT = :4, FLU_NWT = :5, FLU_VOL_PCT = :6, FLU_AP_FR = :7, FLU_AP_TO = :8, FLU_GRP = :9, FLU_REMARK = :10, FLU_LP_REMARK = :11, FLU_ULDT_ID = :12, FLU_FL_ID = :13, FLU_NAME = :14, FLU_ULD_SERIAL_NR = :15, FLU_SHADOW = :16, FLU_LAST_CHANGE_BY = 'U', FLU_UHC_ID = :17, FLU_STATUS = :18, FLU_FRT_TD_ID = :19, FLU_CTR_TD_ID = :20, FLU_ACTUAL = :21, FLU_TYPE = :22, FLU_BT_TD_ID = :23, FLU_TRF_TD_ID = :24, FLU_FFL_TD_ID = :25, FLU_TRF_FLNR = :26, FLU_BAGS = :27, FLU_VOL = :28, FLU_TRAVEL = :29, FLU_PRIORITY = :30, FLU_NUM_OF_PIECES = :31, FLU_SBC_TD_ID = :32, FLU_POU = :33, FLU_OFF_LOAD_LOCK = :34, FLU_ON_LOAD_LOCK = :35 WHERE FLU_ID = :36

SELECT fludgr_weight, fludgr_ti, fludgr_remark, dgr_id, dgr_code, dgr_name, dgr_hazard_f, dgr_rigid, dgr_reposition_warning FROM flight_uld_dgr JOIN dgr_def ON fludgr_dgr_id = dgr_id WHERE fludgr_flu_id = :1 AND fludgr_id > 0

DELETE FROM CTX_SESSION WHERE CTXS_SID = SYS.DBMS_SESSION.UNIQUE_SESSION_ID()

select FLL_DATE, FLL_USR_CODE from FLIGHT_LOCK where FLL_FL_ID = :1

SELECT FLUS_ID, FLUS_FLU_ID, FLUS_ULD_NUMBER, FLUS_ULD_OWNER, ULDT_TYPE, FLUS_ULD_TWT FROM FLIGHT_ULD_STACKED JOIN ULD_TYPE_DEF ON FLUS_ULDT_ID = ULDT_ID JOIN FLIGHT_ULD ON FLUS_FLU_ID = FLU_ID WHERE FLU_FL_ID = :1

BEGIN pack_reload.assign_uld(:1, :2, :3, :4, :5, :6); END;

SELECT vwflls_flu_id, vwflls_actdlp_id, vwflls_actddo_id, vwflls_fp_align, vwflls_fp_orientation, vwflls_fp_weight_distr FROM view_flight_load_seq WHERE vwflls_fl_id = :1 AND (vwflls_actdlp_id = :2 OR vwflls_actddo_id = :3) AND vwflls_dist = :4

SELECT fludgr_id FROM flight_uld_dgr WHERE fludgr_shadow = 'DEL' AND ABS(fludgr_flu_id) = ABS(:1) AND fludgr_id < 0

fuyrx4r46bgxw

g9pv2yphydjtm delete from FLIGHT_ULD where FLU_FL_ID = :1

gm67aj46qd3sd

gr8ks2caytam9 delete from FLIGHT_ULD where FLU_ID in (:1, :2)

Instance Activity Statistics

Instance Activity Stats

Ordered by statistic name

Statistic TotalBatched IO (bound) vector count 992

Batched IO (full) vector count 38

Batched IO block miss count 9,986

Batched IO buffer defrag count 30

Batched IO double miss count 171

Batched IO same unit count 2,658

Batched IO single block count 894

select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STREAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREAT E_TIME||'X' ) aps,

UPDATE flight_uld SET flu_on_load_lock = null WHERE flu_fl_id = :1


Instance Activity StatsInstance Activity Stats - Absolute ValuesInstance Activity Stats - Thread Activity

Back to Top

Batched IO slow jump count 62

Batched IO vector block count 6,459

Batched IO vector read count 203

Block Cleanout Optim referenced 11,403

CCursor + sql area evicted 568

CPU used by this session 3,876,663

CPU used when call started 3,823,124

CR blocks created 206,143

Cached Commit SCN referenced 17,005

Commit SCN cached 17,007

DB time 6,327,511

DBWR checkpoint buffers written 276,669

DBWR checkpoints 339

DBWR revisited being-written buffer 4

DBWR tablespace checkpoint buffers written 2,384

DBWR thread checkpoint buffers written 0

DBWR transaction table writes 5,753

DBWR undo block writes 90,685

Effective IO time 604,472,779

HSC Heap Segment Block Changes 2,089,737

Heap Segment Array Inserts 3,510

Heap Segment Array Updates 946

IMU CR rollbacks 10,843

IMU Flushes 30,794

IMU Redo allocation size 203,095,260

IMU commits 163,641

IMU contention 5,010

IMU ktichg flush 3,027

IMU pool not allocated 546

IMU recursive-transaction flush 1,122

IMU undo allocation size 520,712,824

IMU- failed to get a private strand 546

LOB table id lookup cache misses 1

Misses for writing mapping 1

Number of read IOs issued 112,893

RowCR - row contention 1,076

RowCR attempts 2,182,095

RowCR hits 2,191,744

SMON posted for undo segment shrink 70

SQL*Net roundtrips to/from client 7,544,974

TBS Extension: bytes extended 838,860,800

TBS Extension: files extended 8

TBS Extension: tasks created 1

TBS Extension: tasks executed 1

active txn count during cleanout 306,063

application wait time 2,361

background checkpoints completed 49

background checkpoints started 48

background timeouts 526,635

branch node splits 43

buffer is not pinned count 53,707,302

buffer is pinned count 532,442,934

bytes received via SQL*Net from client 536,049,866

bytes sent via SQL*Net to client 2,061,916,341

calls to get snapshot scn: kcmgss 8,089,795

calls to kcmgas 779,080

calls to kcmgcs 4,676,945

cell physical IO interconnect bytes 242,752,213,504

change write time 4,916

cleanout - number of ktugct calls 225,025

cleanouts and rollbacks - consistent read gets 154,518

cleanouts only - consistent read gets 5,492

cluster key scan block gets 25,135,265

cluster key scans 6,144,980

commit batch performed 0

commit batch requested 0

commit batch/immediate performed 347

commit batch/immediate requested 347

commit cleanout failures: block lost 18,670

commit cleanout failures: buffer being written 2

commit cleanout failures: callback failure 3,076

commit cleanout failures: cannot pin 902

commit cleanouts 1,085,418

commit cleanouts successfully completed 1,062,768

commit immediate performed 347

commit immediate requested 347

commit txn count during cleanout 97,254

concurrency wait time 7,163

consistent changes 3,093,808

consistent gets 1,478,347,899

consistent gets - examination 14,621,091

consistent gets direct 13,845,848

consistent gets from cache 1,464,502,050

consistent gets from cache (fastpath) 1,442,557,281

cursor authentications 1,204

data blocks consistent reads - undo records applied 2,851,553

db block changes 11,824,864

db block gets 15,690,501

db block gets direct 4,404

db block gets from cache 15,686,097

db block gets from cache (fastpath) 3,725,724

deferred (CURRENT) block cleanout applications 334,031

dirty buffers inspected 5,862

enqueue conversions 36,581

enqueue deadlocks 1

enqueue releases 3,245,050

enqueue requests 3,245,049

enqueue timeouts 7

enqueue waits 636

exchange deadlocks 2

execute count 8,826,696

failed probes on index block reclamation 6

file io wait time 3,742,454,141

free buffer inspected 4,755,612

free buffer requested 4,335,118

heap block compress 21,845

hot buffers moved to head of LRU 245,878

immediate (CR) block cleanout applications 160,010

immediate (CURRENT) block cleanout applications 180,039

index crx upgrade (positioned) 198

index crx upgrade (prefetch) 10

index fast full scans (full) 54,546

index fetch by key 7,163,854

index scans kdiixs1 16,320,769

java call heap collected bytes 75,552

java call heap collected count 391

java call heap gc count 1

java call heap live object count 0

java call heap live object count max 0

java call heap live size 0

java call heap live size max 0

java call heap object count 391

java call heap object count max 391

java call heap total size 1,310,720

java call heap total size max 1,310,720

java call heap used size 75,552

java call heap used size max 75,552

java session heap live size 335,872

java session heap live size max 335,872

java session heap used size 335,872

java session heap used size max 335,872

leaf node 90-10 splits 5,229

leaf node splits 12,440

lob reads 9,489

lob writes 7,060

lob writes unaligned 6,481

logons cumulative 2,264

max cf enq hold time 1,050

messages received 430,685

messages sent 430,685

min active SCN optimization applied on CR 347

no buffer to keep pinned count 30

no work - consistent read gets 1,455,843,175

non-idle wait count 11,532,169

non-idle wait time 1,396,637

opened cursors cumulative 6,400,200

parse count (describe) 50

parse count (failures) 576

parse count (hard) 4,407

parse count (total) 1,403,008

parse time cpu 39,936

parse time elapsed 47,171

physical read IO requests 1,106,218

physical read bytes 145,608,441,856

physical read total IO requests 1,675,816

physical read total bytes 230,618,614,272

physical read total multi block requests 311,061

physical reads 17,774,468

physical reads cache 3,928,242

physical reads cache prefetch 2,941,084

physical reads direct 13,846,226

physical reads direct (lob) 2,298

physical reads direct temporary tablespace 124

physical reads prefetch warmup 0

physical write IO requests 166,107

physical write bytes 2,387,345,408

physical write total IO requests 859,864

physical write total bytes 12,133,599,232

physical write total multi block requests 13,683

physical writes 291,424

physical writes direct 4,816

physical writes direct (lob) 2,274

physical writes direct temporary tablespace 2,021

physical writes from cache 286,608

physical writes non checkpoint 113,860

pinned buffers inspected 2,447

prefetch clients - default 20

prefetch warmup blocks aged out before use 0

prefetched blocks aged out before use 3,538

process last non-idle time 82,361

recursive calls 8,911,442

recursive cpu usage 505,718

redo KB read 3,583,022

redo KB read (memory) 1,769,741

redo KB read (memory) for transport 1,769,741

redo KB read for transport 1,771,586

redo blocks checksummed by FG (exclusive) 762,159

redo blocks written 3,650,566

redo buffer allocation retries 25

redo entries 5,472,874

redo log space requests 29

redo log space wait time 42

redo ordering marks 79,735

redo size 1,724,737,048

redo size for direct writes 20,643,216

redo subscn max counts 131,365

redo synch long waits 18,720

redo synch time 42,819

redo synch time (usec) 428,074,908

redo synch writes 172,264

redo wastage 83,027,312

redo write time 46,304

redo writes 247,015

rollback changes - undo records applied 11,415

rollbacks only - consistent read gets 4,154

rows fetched via callback 2,902,601

scheduler wait time 115,608

session connect time 0

session cursor cache hits 2,742,185

session logical reads 1,494,038,414

shared hash latch upgrades - no wait 3,112,324

shared hash latch upgrades - wait 76

sorts (memory) 855,955

sorts (rows) 3,937,664,004

sql area evicted 3,479

sql area purged 672

summed dirty queue length 29,027

switch current to new buffer 94,229

table fetch by rowid 276,887,931

table fetch continued row 1,253,882

table scan blocks gotten 1,378,887,308

table scan rows gotten 402,976,440,057

table scans (direct read) 831

table scans (long tables) 12,400

table scans (rowid ranges) 0

table scans (short tables) 1,269,745

temp space allocated (bytes) 9,437,184

total cf enq hold time 47,620

total number of cf enq holders 7,361

total number of times SMON posted 224

transaction rollbacks 330

transaction tables consistent read rollbacks 0

0

undo change vector size 617,442,368

user I/O wait time 435,667

user calls 8,230,307

user commits 194,786

user rollbacks 339

workarea executions - onepass 2

workarea executions - optimal 1,382,404

write clones created in foreground 29

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic Begin Valuesession pga memory max 2,780,407,872

session cursor cache count 63,322

session uga memory 2,843,602,767,712

opened cursors current 393

logons current 76

session uga memory max 15,174,387,352

session pga memory 1,632,789,920

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic Total

transaction tables consistent reads - undo records applied

Back to Instance Activity StatisticsBack to Top


log switches (derived) 48

IO Stats

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000

ordered by (Data Read + Write) desc

Function Name Reads: DataDirect Reads 105.6G

RMAN 70.7G

Buffer Cache Reads 30G

Others 8.4G

LGWR 15M

DBWR 1M

Direct Writes 0M

Streams AQ 0M

TOTAL: 214.8G

IOStat by Filetype summary


Small Read and Large Read are average service times, in milliseconds

Ordered by (Data Read + Write) desc

Filetype Name Reads: DataData File 204.4G

Control File 6.9G

Log File 1.7G

Archive Log 1.7G

Temp File 17M

Other 27M

TOTAL: 214.8G


IOStat by Function summaryIOStat by Filetype summaryIOStat by Function/Filetype summaryTablespace IO StatsFile IO Stats

Back to Top

Back to IO StatsBack to Top

Back to IO Stats

IOStat by Function/Filetype summary


Ordered by (Data Read + Write) desc for each function

Function/File Name Reads: DataDirect Reads 105.6G

Direct Reads (Data File) 105.6G

RMAN 70.7G

RMAN (Data File) 68.8G

RMAN (Archive Log) 1.7G

RMAN (Control File) 201M

Buffer Cache Reads 30G

Buffer Cache Reads (Data File) 30G

Others 8.4G

Others (Control File) 6.7G

Others (Log File) 1.7G

Others (Archive Log) 0M

Others (Data File) 3M

LGWR 15M

LGWR (Log File) 0M

LGWR (Control File) 15M

DBWR 0M

DBWR (Data File) 0M

Direct Writes 0M

Direct Writes (Data File) 0M

Streams AQ 0M

Streams AQ (Data File) 0M

TOTAL: 214.7G

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace ReadsWB_DATA 1,107,866

UNDOTBS1 65,616

SYSAUX 43,391

SYSTEM 30,140

TEMP 73

USERS 60

File IO Stats

Back to Top



ordered by Tablespace, File

Tablespace FilenameSYSAUX +FLC_DATA/flcp/datafile/sysaux.257.736791025

SYSTEM +FLC_DATA/flcp/datafile/system.256.736791025

TEMP +FLC_DATA/flcp/tempfile/temp.268.736791089

UNDOTBS1 +FLC_DATA/flcp/datafile/undotbs1.258.736791025

USERS +FLC_DATA/flcp/datafile/users.259.736791025

WB_DATA +FLC_DATA/flcp/datafile/wb_data.270.736797079

WB_DATA +FLC_DATA/flcp/datafile/wb_data_01.dbf

Buffer Pool Statistics

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle

Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P Number of BuffersD 67,014

Checkpoint Activity

Total Physical Writes: 291,424

MTTR Writes Log Size Writes0 0

Advisory Statistics


Buffer Pool StatisticsCheckpoint Activity

Back to Top

Back to Buffer Pool StatisticsBack to Top

Back to Buffer Pool StatisticsBack to Top

Instance Recovery StatsMTTR AdvisoryBuffer Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

Targt MTTR (s)B 0

E 0

MTTR Advisory


Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed

ordered by Block Size, Buffers For Estimate

P Size for Est (M)

D 48

D 96

D 144

D 192

D 240

D 288

D 336

D 384

D 432

D 480

D 528

D 544

D 576

D 624

PGA Aggr SummaryPGA Aggr Target StatsPGA Aggr Target HistogramPGA Memory AdvisoryShared Pool AdvisorySGA Target AdvisoryStreams Pool AdvisoryJava Pool Advisory

Back to Top

Back to Advisory StatisticsBack to Top


D 672

D 720

D 768

D 816

D 864

D 912

D 960

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit % W/A MB Processed100 1,044,202

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)B 2,656

E 2,656

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal High Optimal2K 4K

64K 128K

128K 256K

256K 512K

512K 1024K

1M 2M

2M 4M

4M 8M

16M 32M




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 Factr

332 0.13

664 0.25

1,328 0.5

1,992 0.75

2,656 1

3,187 1.2

3,718 1.4

4,250 1.6

4,781 1.8

5,312 2

7,968 3

10,624 4

15,936 6

21,248 8

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 Factr400 0.5

480 0.6

560 0.7

640 0.8

720 0.9

800 1

880 1.1

960 1.2

1,040 1.3

1,120 1.4

1,200 1.5

1,280 1.6

1,360 1.7

1,440 1.8

1,520 1.9

1,600 2



Back to Advisory Statistics

SGA Target Advisory

SGA Target Size (M) SGA Size Factor768 0.5

1,152 0.75

1,536 1

1,920 1.25

2,304 1.5

2,688 1.75

3,072 2

Streams Pool Advisory

Size for Est (MB) Size Factor16 1

32 2

48 3

64 4

80 5

96 6

112 7

128 8

144 9

160 10

176 11

192 12

208 13

224 14

240 15

256 16

272 17

288 18

304 19

320 20

Java Pool Advisory

Java Pool Size(M) JP Size Factr32 1

48 1.5

64 2

Back to Top



Back to Advisory Statistics

Wait Statistics

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class Waitsdata block 65,532

undo block 142

undo header 40

Enqueue Activity

only enqueues with waits are shown

Enqueue stats gathered prior to 10g should not be compared with 10g data

ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason) RequestsTX-Transaction (row lock contention) 127

CF-Controlfile Transaction 97,136

TX-Transaction (index contention) 11,978

PV-KSV slave startup (syncstart) 467

KO-Multiple Object Checkpoint (fast object checkpoint) 2,241

TM-DML 829,824

SQ-Sequence Cache 34,537

TC-Tablespace Checkpoint 3

JS-Job Scheduler (queue lock) 302,279

CR-Reuse Block Range (block range reuse ckpt) 1,079

RO-Multiple Object Reuse (fast object reuse) 369

RF-Data Guard Broker (synch: DG Broker metadata) 336,247

Undo Statistics

Back to Top

Buffer Wait StatisticsEnqueue Activity

Back to Top

Back to Wait StatisticsBack to Top

Back to Wait StatisticsBack to Top

Undo Segment SummaryUndo Segment Stats

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)2 86.51

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time Num Undo Blocks5/31/2013 22:52 184

5/31/2013 22:42 230

5/31/2013 22:32 312

5/31/2013 22:22 282

5/31/2013 22:12 1,024

5/31/2013 22:02 2,448

5/31/2013 21:52 681

5/31/2013 21:42 1,192

5/31/2013 21:32 711

5/31/2013 21:22 378

5/31/2013 21:12 673

5/31/2013 21:02 1,320

5/31/2013 20:52 1,440

5/31/2013 20:42 1,175

5/31/2013 20:32 1,077

5/31/2013 20:22 1,092

5/31/2013 20:12 1,167

5/31/2013 20:02 590

5/31/2013 19:52 1,016

5/31/2013 19:42 473

5/31/2013 19:32 853

5/31/2013 19:22 624

5/31/2013 19:12 426

5/31/2013 19:02 483

5/31/2013 18:52 623

5/31/2013 18:42 364

5/31/2013 18:32 796

5/31/2013 18:22 303

5/31/2013 18:12 227

5/31/2013 18:02 1,038

Back to Top

Back to Undo StatisticsBack to Top

5/31/2013 17:52 428

5/31/2013 17:42 739

5/31/2013 17:32 637

5/31/2013 17:22 916

Latch Statistics

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 Name Get RequestsAQ deq hash table latch 92

ASM Keyed state latch 3,974

ASM allocation 115,980

ASM db client latch 165,489

ASM map headers 71,385

ASM map load waiting list 11,919

ASM map operation freelist 5,559

ASM map operation hash table 29,619,299

ASM network background latch 145,216

ASM network state latch 34,329

AWR Alerted Metric Element list 654,144

Change Notification Hash table latch 27,644

Consistent RBA 247,079

DML lock allocation 4,405,320

DMON Work Queues Latch 17,134

Event Group Locks 2,078

FAL Queue 3,683

FIB s.o chain latch 23,804

FOB s.o list latch 33,207

File State Object Pool Parent Latch 92

I/O Staticstics latch 92

IPC stats buffer allocation latch 92

In memory undo latch 1,668,383

JOX JIT latch 1

JOX SGA heap latch 167

Back to Undo StatisticsBack to Top

Latch ActivityLatch Sleep BreakdownLatch Miss SourcesMutex Sleep SummaryParent Latch StatisticsChild Latch Statistics

Back to Top

JS Sh mem access 212

JS broadcast autostart latch 1

JS mem alloc latch 400

JS queue access latch 492

JS queue state obj latch 604,558

JS slv state obj latch 2,188

KFC FX Hash Latch 92

KFC Hash Latch 92

KFCL LE Freelist 92

KFK SGA Libload latch 2,996

KFMD SGA 124

KGNFS-NFS:SHM structure 92

KGNFS-NFS:SVR LIST 92

KJC message pool free list 92

KJCT flow control latch 92

KMG MMAN ready and startup request latch 28,325

KMG resize request state object freelist 4

KTF sga latch 448

KWQMN job cache list latch 24

KWQP Prop Status 46

KWQS pqsubs latch 138

KWQS pqueue ctx latch 414

LGWR NS Write 494,157

Locator state objects pool parent latch 92

Lsod array latch 26,911

MQL Tracking Latch 0

Memory Management Latch 912

Memory Queue 92

Memory Queue Message Subscriber #1 92




Memory Queue Subscriber 92

MinActiveScn Latch 918

Mutex 92

Mutex Stats 92

NSV command ID generation latch 1,655

NSV creation/termination latch 1,655

OS process 12,068

OS process allocation 172,490

OS process: request allocation 3,974

PL/SQL warning settings 69,327

PX hash array latch 92

QMT 92

RSM process latch 8,270

Real-time plan statistics latch 47,946

Request id generation latch 5,252

Reserved Space Latch 193

SGA IO buffer pool latch 47

SGA blob parent 92

SGA bucket locks 92

SGA heap locks 92

SGA pool locks 92

SQL memory manager latch 23

SQL memory manager workarea list latch 7,234,261

Shared B-Tree 3,897

Streams Generic 92

Testing 92

Token Manager 92

WCR: sync 92

Write State Object Pool Parent Latch 92

X$KSFQP 15,643

XDB NFS Security Latch 92

XDB unused session pool 92

XDB used session pool 92

active checkpoint queue latch 192,698

active service list 316,741

alert log latch 241

archive control 627,555

archive process latch 6,970

begin backup scn array 2,268

buffer pool 98

business card 92

cache buffer handles 470,029

cache buffers chains 2,986,385,684

cache buffers lru chain 604,096

cache table scan latch 317,389

call allocation 203,087

cas latch 92

change notification client cache latch 92

channel handle pool latch 5,378

channel operations parent latch 1,250,612

checkpoint queue latch 4,266,406

client/application info 29,000

compile environment latch 2,264

corrupted undo seg latch 34,575

cp cmon/server latch 92

cp pool latch 92

cp server hash latch 92

cp sga latch 1,458

cvmap freelist lock 92

database property service latch 14

deferred cleanup latch 1,458

device information 12

dml lock allocation 1,540

done queue latch 92

dummy allocation 4,622

enqueue hash chains 6,529,451

enqueues 4,092,888

fifth spare latch 92

file cache latch 5,563

flashback copy 92

fourth Audit Vault latch 92

gc element 92

gcs commit scn state 92

gcs partitioned table hash 92

gcs pcm hashed value bucket hash 92

gcs resource freelist 92

gcs resource hash 92

gcs resource scan list 92

gcs shadows freelist 92

ges domain table 92

ges enqueue table freelist 92

ges group table 92

ges process hash list 92

ges process parent latch 92

ges resource hash list 92

ges resource scan list 92

ges resource table freelist 92

ges value block free list 92

global KZLD latch for mem in SGA 867

global ctx hash table latch 2

global tx hash mapping 92

granule operation 92

hash table column usage latch 3,587

hash table modification latch 2,332

heartbeat check 92

internal temp table object number allocation latch 61

interrupt manipulation 1

intra txn parallel recovery 92

io pool granule metadata list 92

job workq parent latch 371

job_queue_processes free list latch 841

job_queue_processes parameter latch 18,255

k2q lock allocation 92

kcbtsemkid latch 48

kdlx hb parent latch 92

kgb parent 92

kgnfs mount latch 92

kmcptab latch 6

kmcpvec latch 0

kokc descriptor allocation latch 328

krbmrosl 293

ksfv messages 92

ksim group membership cache 92

kss move lock 1,026

ksuosstats global area 5,586

ksv allocation latch 3,327

ksv class latch 206,681

ksv instance latch 658

ksv msg queue latch 23,642

ksz_so allocation latch 3,974

ktm global data 1,755

kwqbsn:qsga 3,230

lgwr LWN SCN 250,108

list of block allocation 42,818

loader state object freelist 47,088

lob segment dispenser latch 92

lob segment hash table latch 366

lob segment query latch 92

lock DBA buffer during media recovery 92

logical standby cache 92

logminer context allocation 115

logminer work area 92

longop free list parent 2,480

managed standby latch 2,262

mapped buffers lru chain 92

message pool operations parent latch 39,367

messages 2,219,987

mostly latch-free SCN 250,511

msg queue latch 92

multiblock read objects 1,691,233

name-service namespace bucket 92

ncodef allocation latch 1,458

object queue header heap 454,341

object queue header operation 9,901,687

object stats modification 707

parallel query alloc buffer 11,060

parallel query stats 92

parameter list 1,303

parameter table management 9,007

peshm 94

pesom_free_list 725

pesom_hash_node 903

pesom_heap_alloc 7

post/wait queue 256,560

process allocation 4,976

process group creation 3,974

process queue 92

process queue reference 92

qmn task queue latch 12,123

query server freelists 92

queued dump request 275

queuing load statistics 92

readredo stats and histogram 245,758

recovery domain hash list 92

redo allocation 1,235,848

redo copy 92

redo writing 1,052,068

reservation so alloc latch 97

resmgr group change latch 7,946

resmgr:active threads 6,938

resmgr:actses change group 1,966

resmgr:actses change state 316

resmgr:free threads list 4,616

resmgr:method mem alloc latch 20

resmgr:plan CPU method 108

resmgr:resource group CPU method 103

resmgr:schema config 3,004

resmgr:session queuing 92

rm cas latch 92

row cache objects 24,073,733

rules engine rule set statistics 2,300

second Audit Vault latch 92

second spare latch 92

segmented array pool 23,748

sequence cache 2,299,685

session allocation 418,854

session idle bit 16,873,658

session queue latch 92

session state list latch 6,300

session switching 11,490

session timer 27,695

shared pool 794,221

shared pool sim alloc 225

shared pool simulator 61,831

sim partition latch 92

simulator hash latch 135,084,515

simulator lru latch 136,870

sort extent pool 151,394

space background state object latch 237

space background task latch 79,177

state object free list 46

statistics aggregation 12,880

tablespace key chain 512

temp lob duration state obj allocation 57

temporary table state object allocation 239

test excl. parent l0 92

test excl. parent2 l0 92

third spare latch 92

threshold alerts latch 3,007

trace latch 1

transaction allocation 477,276

undo global data 2,009,238

virtual circuit buffers 92

virtual circuit holder 92

virtual circuit queues 92

Latch Sleep Breakdown

ordered by misses desc

Latch Name Get Requestscache buffers chains 2,986,385,684

row cache objects 24,073,733

simulator hash latch 135,084,515

session idle bit 16,873,658

enqueue hash chains 6,529,451

enqueues 4,092,888

messages 2,219,987

shared pool 794,221

redo allocation 1,235,848

ksv class latch 206,681

simulator lru latch 136,870

cache buffers lru chain 604,096

mostly latch-free SCN 250,511

Back to Latch StatisticsBack to Top

object queue header operation 9,901,687

undo global data 2,009,238

In memory undo latch 1,668,383

space background task latch 79,177

sequence cache 2,299,685

archive process latch 6,970

call allocation 203,087

ASM map operation hash table 29,619,299

ksv msg queue latch 23,642

checkpoint queue latch 4,266,406

JS Sh mem access 212

ASM map headers 71,385

object queue header heap 454,341

post/wait queue 256,560

process allocation 4,976

qmn task queue latch 12,123

Latch Miss Sources

only latches with sleeps are shown

ordered by name, sleeps desc

Latch Name WhereASM map headers kffmAllocate

ASM map operation hash table kffmTranslate

In memory undo latch ktiFlush: child

In memory undo latch kticmt: child

In memory undo latch ktichg: child

In memory undo latch kturbk

JS Sh mem access jsksGetShMemLatch

PC and Classifier lists for WLM No latch

archive process latch kcrrsarc

archive process latch kcrrgpll

cache buffers chains kcbgtcr: fast path (cr pin)

cache buffers chains kcbrls_1

cache buffers chains kcbgtcr_2

cache buffers chains kcbchg1: kslbegin: bufs not pinned

cache buffers chains kcbgtcr: fast path

cache buffers chains kcbgtcr: kslbegin excl

cache buffers chains kcbgcur_2

cache buffers chains kcbzwb

cache buffers chains kcbrls_2

cache buffers chains kcbget: pin buffer

cache buffers chains kcbgcur: fast path (shr)

cache buffers chains kcbget: exchange rls

cache buffers chains kcbzibmlt: multi-block read: nowait

cache buffers chains kcbchg1: kslbegin: call CR func

cache buffers chains kcbget: exchange

cache buffers chains kcbnew: new latch again

cache buffers chains kcbzhngcbk2_1


cache buffers chains kcb_is_private

cache buffers chains kcbgkcbcr

cache buffers chains kcbnlc

cache buffers lru chain kcbzar: KSLNBEGIN

cache buffers lru chain kcbzgws

call allocation ksuxds

checkpoint queue latch kcbswcu: Switch buffers

enqueue hash chains ksqrcl

enqueue hash chains ksqgtl3

enqueues ksqgel: create enqueue

enqueues ksqdel

ksv class latch ksvclsl: rdp - recycle

ksv class latch ksvclsl: checkpool

ksv class latch ksvclsl: receive

ksv msg queue latch ksvmql: getwork

lgwr LWN SCN kcs023

messages ksaamb: after wakeup

messages ksarcv

object queue header heap kcbo_link_q:alloc

object queue header operation kcbo_link_q

object queue header operation kcbo_link_q:reget

object queue header operation kcbo_switch_cq

post/wait queue ksliwat:add:nowait

process allocation ksucrp:1

qmn task queue latch kwqmnmvtsks: delay to ready list

redo allocation kcrfw_redo_gen: redo allocation 1

resmgr:resource group CPU method kgkprrpicknext

resmgr:resource group CPU method kgkprraddtorl

row cache objects kqreqd: reget

row cache objects kqreqd

row cache objects kqrpre: find obj

sequence cache kdnnxt: cached seq

session idle bit ksupuc: set busy

session idle bit ksupuc: clear busy

session idle bit ksuxds

shared pool kghalo

shared pool kghupr1

shared pool kghalp

shared pool kghfre

shared pool kghfrunp: clatch: nowait

simulator hash latch kcbsacc: lookup dba

simulator hash latch kcbsacc: remove dba

simulator hash latch kcbsacc: insert dba

simulator lru latch kcbs_simulate: simulate set

space background task latch ktsjCreateTask

undo global data ktudba: KSLBEGIN

Mutex Sleep Summary

ordered by number of sleeps desc


Mutex Type LocationLibrary Cache kglpndl1 95

Library Cache kglhdgn2 106

Library Cache kglpin1 4

Library Cache kglpnal1 90

Cursor Pin kksfbc [KKSCHLFSP2]

Cursor Pin kksLockDelete [KKSCHLPIN6]

Cursor Pin kkslce [KKSCHLPIN2]

Library Cache kglGetHandleReference 124

Library Cache kglget1 1

Library Cache kgllkc1 57

Cursor Stat kkocsStoreBindAwareStats [KKSSTALOC8]

Parent Latch Statistics


Child Latch Statistics


Segment Statistics




Segments by Logical ReadsSegments by Physical ReadsSegments by Physical Read RequestsSegments by UnOptimized ReadsSegments by Optimized ReadsSegments by Direct Physical ReadsSegments by Physical WritesSegments by Physical Write RequestsSegments by Direct Physical WritesSegments by Table ScansSegments by DB Blocks ChangesSegments by Row Lock WaitsSegments by ITL WaitsSegments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 1,494,038,414

Captured Segments account for 98.8% of Total

Owner Tablespace NameSABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SYS SYSTEM

Segments by Physical Reads

Total Physical Reads: 17,774,468



SABLE_CX WB_DATA

SYS SYSTEM

SABLE_CX WB_DATA

SYS SYSAUX

Segments by Physical Read Requests

Total Physical Read Requests: 1,106,218



SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,106,218

Back to Top

Back to Segment StatisticsBack to Top





SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by Optimized Reads


Segments by Direct Physical Reads

Total Direct Physical Reads: 13,846,226



SABLE_CX WB_DATA

SYS SYSTEM

SYS SYSAUX

SABLE_CX WB_DATA

Segments by Physical Writes

Total Physical Writes: 291,424



SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by Physical Write Requests





Total Physical Write Requestss: 166,107



SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by Direct Physical Writes

Total Direct Physical Writes: 4,816



SABLE_CX WB_DATA

SABLE_CX TEMP

SABLE_CX TEMP

SABLE_CX TEMP

Segments by Table Scans

Total Table Scans: 66,946



SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared

with total DB Block Changes for all segments captured by the Snapshot





SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared

with total row lock waits for all segments captured by the Snapshot


SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

Segments by ITL Waits

% of Capture shows % of ITL waits for each top segment compared

with total ITL waits for all segments captured by the Snapshot


SABLE_CX WB_DATA

SABLE_CX WB_DATA

SYS SYSAUX

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared

with total Buffer Busy Waits for all segments captured by the Snapshot


SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA

SABLE_CX WB_DATA





Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)

"Final Usage" is the number of cache entries being used

Cache Get Requestsdc_awr_control 2,079

dc_constraints 261

dc_files 726

dc_global_oids 1,766

dc_histogram_data 400,233

dc_histogram_defs 341,369

dc_object_grants 1,226

dc_objects 1,374,273

dc_profiles 1,997

dc_rollback_segments 45,946

dc_segments 117,373

dc_sequences 111,310

dc_table_scns 20

dc_tablespaces 2,843,057

dc_users 2,842,514

global database name 56,806

outstanding_alerts 552

qmtmrciq_cache_entries 82

qmtmrctn_cache_entries 82

qmtmrctq_cache_entries 82

sch_lj_objs 18

sch_lj_oids 318

Library Cache Activity

"Pct Misses" should be very low

Namespace Get RequestsACCOUNT_STATUS 1,737

APP CONTEXT 2

BODY 7,606

CLUSTER 372

DBLINK 1,896

DIRECTORY 7

EDITION 1,625

INDEX 2,494

JAVA DATA 3

JAVA SOURCE 1

OBJECT ID 93

QUEUE 69

SCHEMA 1,988

SECURITY CLASS 259

SQL AREA 515,956

Back to Top

SQL AREA BUILD 4,017

SQL AREA STATS 3,677

TABLE/PROCEDURE 37,233

TEMPORARY INDEX 178

TEMPORARY TABLE 486

TRIGGER 9,214

XDB ACL 82

XDB CONFIG 82

XML SCHEMA 410

Memory Statistics

Memory Dynamic Components

Min/Max sizes since instance startup

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred

ordered by Component

Component Begin Snap Size (Mb)ASM Buffer Cache 0

DEFAULT 16K buffer cache 0





DEFAULT buffer cache 544

KEEP buffer cache 0

PGA Target 2,656.00

RECYCLE buffer cache 0

SGA Target 1,536.00

Shared IO Pool 112

java pool 32

large pool 16

shared pool 800

streams pool 16

Back to Top

Memory Dynamic ComponentsMemory Resize Operations SummaryMemory Resize OpsProcess Memory SummarySGA Memory SummarySGA breakdown difference

Back to Top

Back to Memory StatisticsBack to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured

ordered by Component

Component Min Size (Mb)DEFAULT buffer cache 544

shared pool 768

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size

Status: COMplete/CANcelled/INActive/PENding/ERRor

ordered by start_time desc,component

Start Ela (s)5/1/1931 22:00 9

5/1/1931 22:00 9

5/1/1931 0:13 0

5/1/1931 0:13 0

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

CategoryB Other

Freeable

PL/SQL

SQL

E Other

Freeable

PL/SQL

SQL

SGA Memory Summary




SGA regions Begin Size (Bytes)Database Buffers 687,865,856

Fixed Size 2,226,912

Redo Buffers 7,348,224

Variable Size 905,970,976

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

Pool Namejava JOXLE

java free memory

java joxs heap

large ASM map operations hashta

large PX msg pool

large free memory

shared FileOpenBlock

shared KGLH0

shared KGLHD

shared KGLS

shared SQLA

shared XDBSC

shared free memory

streams KTG hash buckets

streams free memory

buffer_cache

fixed_sga

log_buffer

shared_io_pool

Streams Statistics



Streams CPU/IO UsageStreams CaptureStreams Capture RateStreams ApplyStreams Apply RateBuffered QueuesBuffered Queue SubscribersRule SetPersistent QueuesPersistent Queues Rate

Streams CPU/IO Usage

Streams processes ordered by CPU Time, descending

Session Type First LogonQMON Slaves 0528 17:42:55

QMON Coordinator 0528 17:42:50

Streams Capture


Streams Capture Rate


Streams Apply


Streams Apply Rate


Buffered Queues


Persistent Queue Subscribers

Back to Top

Back to Streams StatisticsBack to Top





Back to Streams Statistics

Buffered Queue Subscribers


Rule Set


Persistent Queues

Ordered by Queue Name

* indicates queue (re)started between Begin/End snaps

%Exp Msgs - % of msgs enqueued with expiry

%Delay Msgs - % of msgs enqueued with delay

%Trasf Time - % of Enqueue time spent in transformation

%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name Enq MsgsSYS.ALERT_QUE(12603) 0

Persistent Queues Rate

Ordered by Queue Name

* indicates queue (re)started between Begin/End snaps

Queue Name Enqueue Msgs/secSYS.ALERT_QUE(12603) 0

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name

* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue Enqueue MsgsHAE_SUB(1)/SYS.ALERT_QUE 0

Back to Top





NGCLKLXFLCDB_3872_FLCP(22)/SYS.ALERT_QUE 0

Resource Limit Stats


Shared Server Statistics

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections Avg Active Connections0 0

Shared Servers Rates

Common Queue Per Sec Disp Queue Per Sec0 0

Shared Servers Utilization

Statistics are combined for all servers

Incoming and Outgoing Net % are included in %Busy

Total Server Time (s) %Busy82,746 0


Back to Top

Shared Servers ActivityShared Servers RatesShared Servers UtilizationShared Servers Common QueueShared Servers Dispatchers

Back to Top

Back to Shared Server StatisticsBack to Top


Shared Servers Common Queue


Shared Servers Dispatchers

Ordered by %Busy, descending

Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue

Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name Avg ConnsD000 0

init.ora Parameters

init.ora Parameters

Parameter Name Begin valuearchive_lag_target 0

audit_file_dest /u01/app/oracle/admin/FLCP/adump

audit_trail DB

compatible 11.2.0.0.0

control_file_record_keep_time 43

control_files

db_block_size 8192

db_create_file_dest +FLC_DATA

db_domain WORLD

db_name FLCP

db_recovery_file_dest +FLC_DATA

db_recovery_file_dest_size 32212254720

dg_broker_start 1

diagnostic_dest /u01/app/oracle




init.ora Parametersinit.ora Multi-Valued Parameters

Back to Top

+FLC_DATA/flcp/controlfile/current.261.736791085, +FLC_DATA/flcp/controlfile/current.260.736791085

dispatchers (PROTOCOL=TCP) (SERVICE=FLCPXDB)

fal_server flcp_ibclxflcdb01

local_listener

log_archive_config dg_config=(FLCP, FLCP_STBY)

log_archive_dest_1

log_archive_dest_2

log_archive_dest_state_2 ENABLE

log_archive_format %t_%s_%r.dbf

log_archive_max_processes 4

log_archive_min_succeed_dest 1

log_archive_trace 0

open_cursors 300

pga_aggregate_target 2785017856

processes 150

remote_login_passwordfile EXCLUSIVE

resource_manager_plan

sec_case_sensitive_logon 0

sga_target 1610612736

spfile +FLC_DATA/flcp/spfileflcp.ora

standby_file_management Auto

undo_tablespace UNDOTBS1

init.ora Multi-Valued Parameters

This section only displays parameters that have more one value

'(NULL)' indicates a missing parameter value

A blank in the End Snapshot indicates the same value as the BeginSnapshot

Parameter Name Begin valuecontrol_files +FLC_DATA/flcp/controlfile/current.260.736791085

+FLC_DATA/flcp/controlfile/current.261.736791085

log_archive_dest_1 location=USE_DB_RECOVERY_FILE_DEST

valid_for=(ALL_LOGFILES, ALL_ROLES)

log_archive_dest_2

service="FLCP_IBCLXFLCDB01"

valid_for=(all_logfiles, primary_role)

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=57.28.246.84)(PORT=1521))))

location=USE_DB_RECOVERY_FILE_DEST, valid_for=(ALL_LOGFILES, ALL_ROLES)

service="FLCP_IBCLXFLCDB01", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="FLCP_STBY" net_timeout=30, valid_for=(all_logfiles, primary_role)

SCHEDULER[0x310A]:DEFAULT_MAINTENANCE_PLAN

Back to init.ora ParametersBack to Top

LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="FLCP_STBY" net_timeout=30

Back to init.ora ParametersBack to Top

Dynamic Remastering Stats


End of Report

Back to Top

Instance Inst numFLCP 1

CPUs Cores2

Snap Time Sessions5/31/2013 0:00 76

5/31/2013 23:00 74

1,379.31 (mins)

814.38 (mins)

End544M Std Block Size:

800M Log Buffer:

Per Transaction Per Exec0.3 0.01

0.2 0

8,839.10

7,656.80

60.6

91.1

1.5

42.2

7.2

0

5.4

0

45.2

0

Redo NoWait %: 100

In-memory Sort %: 100

Soft Parse %: 99.69

Latch Hit %: 99.92

% Non-Parse CPU: 98.97

End86.03

84.15

83.92

Time(s) Avg wait (ms)38,848

2,251 3

1,243 4

1,109 50

604 6

%User %System24.5 0.7

2.3

End7,855.70

1,536.00

440.4

25.16

%DB time waiting for CPU (Resource Manager)

Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic

% of DB Time94.37

79.5

1.03

0.94

0.94

0.43

0.07

0.06

0.06

0.02

0.02

0.01

0.01

0.01

0

End Value

0

%busy %user

46.65 45.1

34.36 33.12

16.33 15.73

15.05 14.46

25.38 24.67

17.32 16.72

13.52 12.92

17.48 16.85

12.9 12.28

15.62 14.9

21.4 20.46

15.13 14.42

21.73 20.9

21.87 20.96

41.25 39.72

41.23 39.72

38.6 37.27

34.23 33.02

22.33 21.37

30.83 29.92

30.49 29.61

23.61 22.85

29.03 28

%Time -outs Total Wait Time (s)38,848

0 4,265

0 1,109

0 418

0 93

0 85

0 37

0 24

100 15

7 1

0 0

%Time -outs Total Wait Time (s)0 2,251

0 1,243

0 1,109

0 604

0 418

0 159

0 84

0 48

34 31

0 22

0 14

0 13

0 10

0 5

0 4

0 4

0 3

0 3

0 3

100 2

0 2

0 2

0 2

0 1

0 1

0 1

0 1

0 1

0 1

100 1

0 0

0 0

0 0

0 0

0 0

0 0

93 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 1,962,606

100 16,153

0 20

100 1

0 0

%Time -outs Total Wait Time (s)0 5,665

0 639

0 444

0 336

0 208

0 197

0 125

0 49

0 47

0 45

0 39

0 35

0 28

0 21

0 11

0 8

0 4

0 4

0 3

0 3

0 3

0 1

0 1

0 1

0 1

0 1

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

100 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

66 1,735,764

100 413,782

0 413,571

100 165,403

97 124,067

100 82,761

99 82,757

0 82,753

100 82,750

50 82,750

99 82,747

100 82,746

50 82,739

0 82,738

17 82,694

0 48,617

0 143

93 104

0 49

99 9

% of Waits<1ms <2ms

34.1 3.3

96.3 2.5

100

100

94.6 2.1

0

79.8

97.4 1.9

13.1 12.1

99.7 0.1

95.9 1.1

99.9 0

43.8 33.3

86.8 2.8

12 16.3

88.2 7.4

100 0

90.1 5.7

100 0

89.5 2.4

100 0

91.6 1.4

100

3.7

82.4 9.3

90.2 3.8

23.5 3.1

100

70 15

1.5

91.7 5

36.6 11

46.3 8.9

100

18.8 37.1

75

82.4 6.6

44.8 23.9

2

100

33.3

58.6 23.4

100

97.3 2.7

83.8 1.4

15.5 4.3

92.8 5.9

66.2 3.1

81.8 4.5

67.9 4.8

90

66.7 33.3

100

86.7

75

100

76.5 9.8

51.9 7.4

52.9 2.9

100

6.9

92 2.4

84.3 7.4

33.9 8.3

94.3 2.6

76.8 11.6

88.7 0.6

38.3 14.5

93.9 2.7

2.8 1.8

61.8 10.9

42.9

99.1 0.7

45 6.8

7.1

90 4.7

8 4.1

0.7 0.4

55.4 28.2

1 0

48.7 0.5

2.2

15 2.6

0

4.3 0.7

2.5 0.7

0.4 0.1

% of Total Waits<32ms <64ms

98.3 1.2

99.2 0.8

99.2 0.5

99.8 0.1

96.8 3.2

100 0

100 0

99.7 0.2

99.6 0.3

100 0

99.7 0.1

100 0

95.5 0.3

100 0

99.2 0.3

99 0.5

99.6 0.2

99.4

94.3 3.1

99.8 0.1

99.3 0.5

99.3 0.4

97.7 1.8

98.7 0.6

95.5 1.5

61.6 28.3

97.9 0.4

100

92.2 2.6

8.3

96.9 2.3

96.9 2.3

88.9

82.4

100

31

98.9 0.5

99.2 0.4

95 3.7

46.2 53.8

98.7 0.6

86.2 8

98.7 0.6

98.9 0.8

100

99.5 0.5

49.3 23.4

50

71.4

Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)

% of Total Waits<2s <4s

100 0

75

99.9 0.1

66.7 25

DB CPU (s) Physical Reads (K)38,837 17,725

11 0

0 0

0 50

Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network

User I/O Wt Time Concurcy Total Wts4264 4614

1 1

92 1025


% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time per Exec (s) %Total0.03 22.79

0.07 21.49

1.08 10.57

1.2 9.52

0.51 8.97

0.03 7.73

0.02 6.54

0.02 6.48

0.57 4.7

0.37 4.42

0.24 2.35

1.05 1.24


CPU per Exec (s) %Total0.03 25.47

0.06 24.84

0.77 9.51

0.02 8.92

0.87 8.69

0.02 7.5

0.02 7.5

0.26 5.88

0.42 4.29

0.27 4.03

0.22 2.72

0.77 1.14


UIO per Exec (s) %Total0.23 44.76

0.24 26.73

0.26 22.97

0.13 11.62

0.07 9.83

231.99 5.32

1.03 4.53

0.23 3.01

0.36 2.41

100.56 2.31

7.94 1.82

1.1 1.66

0.01 1.03


Gets per Exec %Total1,761.67 17.76

1,761.31 17.76

1,761.83 17.76

1,761.50 17.76

14,867.82 8.6

20,113.65 6.44

22,795.88 5.9

209.44 5.05

8,750.96 3.45

10,963.45 2.93

5,817.47 1.87

226.46 1.75

4,792.56 1.6

Reads per Exec %Total1,534.29 74.58

11,432.55 12.29

342 9.21

285.43 6.21

141.14 3.18

75.54 2.5

1,062.94 1.75

432.6 1.4

114,003.00 0.64

1,519.02 0.38

Executions UnOptimized Reqs per Exec3,999 41.4

5,887 19.82

1 38,148.00

1 18,046.00

1,064 14.42

1 12,296.00

10 1,051.50

1 6,762.00

36 146.81

1 3,748.00

Rows per Exec Elapsed Time (s)1 54.52

1 45.45

0.06 11,133.45

1 134.66

0.82 53.84

1 6.78

0 10,498.93

0.01 3,774.83

0.01 3,196.26

0 3,166.02

0.57 8.45

0.5 16.78

39.47 111.93

1 17.9

% Total Parses SQL Id8.31

7.64

1.72

1.66

1.6

1.08

0.88

0.88

dsnk22bby5s7b4m7m0t6fjcs5xarvad97suq7p18ums58rsq08u1ftj9uawt4wwzb0bkjwu3swz0wy2bjggjqk03ar8bmquxnvdftw7t

0.87

0.83

% Total SQL Id0.39

0.34

0.28

0.27

0.26

0.2

0.19

0.17

0.16

0.16

0.15

0.14

0.13

0.13

0.13

SQL Id SQL ModuleJDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

DBMS_SCHEDULER

dxb7nztnykx9qf12tdjj14dvpw

1znntxfy46782bqqwtnz5f54q45xxxrg5ckv1k33j2p1zh0uazqj72ukkfmh7y7dz01d5n1nm17r2hdb3q2xdrx0fsdbghk5x23n06824x866jn4mj1uy1znntxfy46782fuyrx4r46bgxw17jn6anhgwns5ab3swhv5g138ya927uzs9sa0zd6wm3n4d7bnddg

1znntxfy467821znntxfy467821znntxfy467821znntxfy467821znntxfy467821znntxfy467821znntxfy46782bqqwtnz5f54q4bqqwtnz5f54q4bqqwtnz5f54q48xgd2r1h0kr34

per Second per Trans0.01 0.01

0 0

0.12 0.05

0 0

0 0

0.03 0.01

0.01 0

0 0

0.08 0.03

0 0

0.14 0.06

0.01 0

46.84 19.87

46.2 19.59

2.49 1.06

0.21 0.09

0.21 0.09

76.46 32.43

3.34 1.42

0 0

0 0

0.03 0.01

0 0

0.07 0.03

1.1 0.46

7,304.05 3,097.87

25.25 10.71

0.04 0.02

0.01 0

0.13 0.06

0.37 0.16

2,454.07 1,040.85

1.98 0.84

0.06 0.03

0.04 0.02

0.01 0

0.01 0.01

6,291.95 2,668.61

0.01 0

0 0

0 0

1.36 0.58

0.01 0.01

26.37 11.18

26.48 11.23

0 0

91.17 38.67

10,136.24 4,299.09

0 0

0 0

0 0

3.7 1.57

0.03 0.01

0 0

0 0

6.36 2.7

0 0

648.96 275.25

6,433.69 2,728.73

6,477.28 2,747.21

24,914.85 10,567.16

97.75 41.46

9.41 3.99

56.51 23.97

2,933,258.67 1,244,085.66

0.06 0.03

2.72 1.15

1.87 0.79

0.07 0.03

303.72 128.82

74.25 31.49

0 0

0 0

0 0

0 0

0.23 0.1

0 0

0.04 0.02

0.01 0

13.12 5.56

12.84 5.45

0 0

0 0

1.18 0.5

0.09 0.04

37.38 15.86

17,863.39 7,576.41

176.67 74.93

167.3 70.96

17,696.08 7,505.46

17,430.92 7,392.99

0.01 0.01

34.46 14.61

142.88 60.6

189.59 80.41

0.05 0.02

189.54 80.39

45.02 19.09

4.04 1.71

0.07 0.03

0.44 0.19

0 0

39.21 16.63

39.21 16.63

0 0

0.01 0

0 0

106.66 45.24

0 0

45,221.36 19,179.78

57.46 24.37

52.38 22.22

0.26 0.11

2.97 1.26

1.93 0.82

2.18 0.92

0 0

0 0

0.66 0.28

86.56 36.71

197.21 83.64

0.91 0.39

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

15.84 6.72

15.84 6.72

0.91 0.39

0.91 0.39

4.06 1.72

4.06 1.72

4.06 1.72

4.06 1.72

0.06 0.03

0.15 0.06

0.11 0.05

0.09 0.04

0.08 0.03

0.03 0.01

0.01 0.01

5.2 2.21

5.2 2.21

0 0

0 0

17,591.45 7,461.08

139.35 59.1

16.88 7.16

77.34 32.8

0 0

0.01 0

0.05 0.02

16.95 7.19

0.48 0.2

0.57 0.24

13.37 5.67

1,759,436.99 746,231.60

20.25 8.59

2,786,644.21 1,181,901.93

3.76 1.59

214.78 91.09

47.47 20.13

35.54 15.07

167.31 70.96

0.03 0.01

0 0

0 0

2.01 0.85

28,847.12 12,234.95

10.39 4.41

146,614.46 62,183.72

0.17 0.07

3.52 1.49

0.06 0.02

0.03 0.01

0.02 0.01

3.46 1.47

1.38 0.58

0.03 0.01

0 0

0 0

0.04 0.02

1 0.42

107.68 45.67

6.11 2.59

43.29 18.36

21.38 9.07

21.38 9.07

21.41 9.08

9.21 3.91

44.11 18.71

0 0

66.13 28.05

0 0

0 0

0.96 0.41

20,840.59 8,839.14

249.44 105.79

1.59 0.67

0.23 0.1

0.52 0.22

5,172.58 2,193.85

2.08 0.88

1,003.25 425.51

0.56 0.24

2.98 1.27

0.14 0.06

0.05 0.02

35.07 14.88

1.4 0.59

0 0

33.13 14.05

18,052.98 7,656.83

37.61 15.95

0 0

10.34 4.39

47,580.15 20,180.21

0.04 0.02

0.01 0

0.35 0.15

1.14 0.48

3,345.73 1,419.03

15.15 6.43

16,661.57 7,066.69

4,869,303.22 2,065,221.99

0.01 0

0.15 0.06

0 0

15.34 6.51

114.03 48.36

0.58 0.24

0.09 0.04

0 0

0 0

0 0

0 0

7,460.77 3,164.34

5.26 2.23

99.45 42.18

2.35 1

0 0

0 0

16.7 7.08

0 0

End Value3,235,059,384

89,437

4,042,007,768,960

387

74

21,157,549,760

2,092,094,488

per Hour

2.09


Reqs per sec Data per sec1.37 1.30709

1.81 0.874737

12 0.370777

5.05 0.10452

0.01 0.000181

0 0.000012

0 0M

0 0M

20.24 2.65732



4.83 0.085368

0.03 0.021387

0.04 0.021049

0 0.000205

0.27 0.000326

20.25 2.6573



1.37 1.30709

1.81 0.874737

1.7 0.851259

0.04 0.021049

0.07 0.002428

12 0.370765

12 0.370765

4.78 0.104194

4.75 0.082758

0.03 0.021399

0 0M

0.01 0.000036

0.01 0.000181

0 0M

0.01 0.000181

0 0M

0 0M

0 0M

0 0M

0 0M

0 0M

19.98 2.65697

Av Reads/s Av Rd(ms)13 2.91

1 0

1 4.97

0 3.63

0 4.93

0 0.33

Reads Av Reads/s43,391 1

30,140 0

73 0

65,616 1

60 0

1,024,492 12

83,374 1

Pool Hit% Buffer Gets100 1,479,971,084

Log Ckpt Writes Other Settings Writes0 0

Estd MTTR (s) Recovery Estd IOs15 1564

14 821

Size Factor Buffers (thousands)

0.09 6

0.18 12

0.26 18

0.35 24

0.44 30

0.53 35

0.62 41

0.71 47

0.79 53

0.88 59

0.97 65

1 67

1.06 71

1.15 77

1.24 83

1.32 89

1.41 95

1.5 101

1.59 106

1.68 112

1.76 118

Extra W/A MB Read/Written6

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(M) PGA Mem Alloc(M)2,070 470.71

2,098 440.36

Total Execs Optimal Execs370,762 370,762

7,265 7,265

11,170 11,170

1,974 1,974

941,710 941,710

39,807 39,807

99 97

46 46

9,573 9,573

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

W/A MB Processed

4,882,692.14 866,835.28

4,882,692.14 33.57

4,882,692.14 33.57

4,882,692.14 33.57

4,882,692.14 33.57

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0

4,882,692.14 0


Est LC Size (M) Est LC Mem Obj14 1,004

95 6,243

174 9,310

254 11,578

334 14,072

414 16,863

494 19,364

574 23,632

654 26,181

734 28,594

814 31,669

886 34,203

914 35,648

914 35,648

914 35,648

914 35,648

Estd Extra W/A MB Read/ Written to Disk

Est DB Time (s) Est Physical Reads166,761 29,791,273

165,286 29,553,754

163,828 28,965,749

163,124 28,965,749

163,074 28,965,749

163,074 28,965,749

163,074 28,965,749

Est Spill Count Est Spill Time (s)0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

Est LC Size (M) Est LC Mem Obj11 179

17 299

18 316

Total Wait Time (s) Avg Time (ms)161 2

0 1

0 1

Succ Gets Failed Gets126 0

97,133 3

11,978 0

467 0

2,241 0

829,824 0

34,537 0

3 0

302,279 0

1,079 0

369 0

336,247 0

Number of Transactions Max Qry Len (s)332,823 2,887

Number of Transactions Max Qry Len (s)1,941 679

2,483 1,282

2,210 681

1,733 1,285

3,021 684

3,997 1,288

2,362 687

2,053 1,290

2,035 817

1,453 216

2,465 977

3,589 376

3,022 694

3,236 168

2,492 697

2,890 1,300

3,333 700

1,868 1,795

3,440 1,195

2,310 1,306

4,130 705

3,225 69

2,444 708

1,767 107

1,585 710

1,666 109

2,967 66

1,630 1,315

1,990 714

3,803 1,318

1,829 717

2,971 1,320

3,030 1,206

2,956 605

Pct Get Miss Avg Slps /Miss0

0.03 0

0

0

0 1

0

0

0 0.13

0

0 0

0

0

0 0

0 0

0

0

0

0

0

0

0

0

0 0.54

0

0

1.42 1

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0 0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0 0

0

0

0

0

0

0

0

0

0

0

0

0 0

0

0

0.22 1

0

0

0

0

0.09 0

0.01 0.14

0

0 0.33

0

0

0

0 0

0 0.25

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.01 0.03

0.01 0.02

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.06 0.04

0

0.02 0.2

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.07 0

0.01 0.02

0.03 0.02

0

0 0

0

0

0 1

0 0.06

0

0

0

0

0.01 0

0

0

0

0

0 1

0.02 1

0

0

0

0.01 1

0

0

0

0

0

0.01 0.4

0

0 0

0

0

0

0

0

0

0

0

0

0

0

0

0.01 0.01

0

0

0

0

0 0.05

0 0

0 0.01

0

0

0

0

0.02 0.2

0

0

0

0 0.07

0.06 0.21

0

0

0.03 0.08

0

0

0

0

0

0

0

0

0

0

0

0 0.02

0

0

0

Misses Sleeps2,575,754 2,752

2,287 28

906 66

641 7

538 15

343 7

187 4

184 36

128 51

117 5

82 17

74 10

64 1

63 4

46 1

41 22

26 2

20 1

15 15

9 3

8 1

5 1

4 1

3 3

1 1

1 1

1 1

1 1

1 1

NoWait Misses Sleeps0 1

0 1

0 16

0 5

0 2

0 1

0 3

0 1

0 14

0 1

0 2,274

0 805

0 118

0 54

0 42

0 41

0 20

0 13

0 12

0 8

0 5

0 3

0 3

0 2

0 2

0 2

0 2

0 1

0 1

0 1

0 6

0 4

0 3

0 1

0 9

0 6

0 4

0 3

0 3

0 1

0 1

0 1

0 1

0 3

0 1

0 1

0 2

0 1

0 1

0 1

0 1

0 1

0 51

0 3

0 1

0 22

0 4

0 1

0 1

0 4

0 3

0 1

0 28

0 6

0 1

0 1

0 1

0 48

0 11

0 7

0 17

0 1

0 1

Sleeps Wait Time (ms)862 1,588

702 19

642 598

510 932

354 36

4 0

2 22

1 0

1 0

1 0

1 0

Object Name Subobject NameFLIGHT_ULD_DGR

FLIGHT_ULD

FLIGHT_LOAD_SEQ

PK_FLIGHT_ULD

COLTYPE$

Object Name Subobject NameFLIGHT_ULD

LOADSHEETACARS

AUD$

IDXTUN_AUDIT_LOG

SCHEDULER$_EVENT_LOG


IDXTUN_AUDIT_LOG

LOADSHEETACARS

AUDIT_LOG

IDX_AUDIT_LOG


IDXTUN_AUDIT_LOG

LOADSHEETACARS

AUDIT_LOG

IDX_AUDIT_LOG


LOADSHEETACARS

AUD$

SCHEDULER$_EVENT_LOG

SYS_LOB0000091730C00008$$

Object Name Subobject NameIDXTUN_AUDIT_LOG

IDX_AUDIT_LOG

AUDIT_LOG

PK_AUDIT_LOG

IND_FK_FLCP_ACTDLP


IDX_AUDIT_LOG

AUDIT_LOG

IND_FK_FLCP_ACTDLP

PK_AUDIT_LOG

Object Name Subobject NameSYS_LOB0000091730C00008$$

SYS_LOB0000091730C00004$$

TEMP_FLIGHT_ROUTE

PK_TEMP_FLIGHT_ROUTE

PK_TEMP_FLIGHT_ROUTE


PK_FLIGHT_ULD

UK_ACT_DECK_LOAD_POS_NAU

UK_ACTDLPD_ACTDLP_ID_DGR_ID

LOADSHEETACARS

Object Name Subobject NameFLIGHT_LOAD_SEQ

FLIGHT_ULD_DGR

IDX_AUDIT_LOG

PK_AUDIT_LOG

IDXTUN_AUDIT_LOG

Object Name Subobject NameIDX_AUDIT_LOG

PK_AUDIT_LOG

IDXTUN_AUDIT_LOG

NDX_TT_TIMESTAMP

PK_AUDIT_FLIGHT


PK_AUDIT_LOG

IDX_AUDIT_LOG

SYS_IL0000006306C00038$$

Object Name Subobject NamePK_CTX_SESSION_USER

PK_AUDIT_LOG

FLIGHT_LOAD_SEQ

IDX_AUDIT_LOG

FLIGHT_ULD

Pct Miss Scan Reqs0 0

33.72 0

0 0

0.4 0

1 0

1.86 0

0.16 0

0.06 0

0 0

0 0

0.13 0

0 0

100 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

16.67 0

1.26 0

Pct Miss Pin Requests0 0

50 4

0.21 2,432,217

0.54 375

0 0

57.14 14

0 2,762

7.46 2,274

0 0

100 1

100 0

0 16,615

0.1 0

0 259

0.24 9,086,789

72.32 0

67.64 3,677

0.58 3,490,927

64.61 178

17.28 486

0.17 1,597,635

0 82

0 82

0 738

Current Size (Mb) Min Size (Mb)0 0

0 0

0 0

0 0

0 0

0 0

544 432

0 0

2,656.00 2,656.00

0 0

1,536.00 1,536.00

112 112

32 16

16 16

800 768

16 16

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured

Max Size (Mb) Avg Size (Mb)576 560

800 784

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size

Component Oper Typ/Modbufcache SHR/DEF

shared GRO/DEF

bufcache GRO/DEF

shared SHR/DEF

Alloc (MB) Used (MB)387.35

69.31 0

9.79 5.12

4.68 3.02

357.79

72 0

8.9 4.91

1.7 0.15

End Size (Bytes) (if different)

N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Begin MB End MB20.24 20.23

10.96 10.97

0.79 0.79

0.38 0.38

0.47 0.47

15.16 15.16

9.72 9.72

167.14 154.11

28.49 23.02

15.66 10.36

330.88 337.67

14.12 14.12

89.38 111.74

0.63 0.63

15.37 15.37

544 544

2.12 2.12

7.01 7.01

112 112

CPU time(s) User IO Wait time(s)0.22 0.31

0.06 0

Deq Msgs %Exp Msgs0

Dequeue Msgs/sec Avg Enqueue sec / msg0

Dequeue Msgs Expire Msgs0 0

0 0

Avg Total Shared Srvrs Avg Active Shared Srvrs1 0

Server Msgs/Sec Server KB/Sec0 0

%Idle Incoming Net %100 0

Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Total Disp Time (s) %Busy82,746 0

End value (if different)

End value (if different)

SCHEDULER[0x310B]:DEFAULT_MAINTENANCE_PLAN

Startup Time Release RAC5/28/2013 17:05 11.2.0.2.0 NO

Sockets Memory (GB)7.67

Cursors/Session5.2

5.2

8K

7,176K

Per Call0.01

0

% DB time Wait Class79.5

4.61 User I/O

2.54 User I/O

2.27 Scheduler

1.24 User I/O

%WIO %Idle2.4 74.6

%sys %idle %iowait

1.06 53.35 4.31

0.84 65.64 9.17

0.46 83.67 1.18

0.47 84.95 1.3

0.51 74.62 1.52

0.45 82.68 1.69

0.46 86.48 1.06

0.48 82.52 1.21

0.46 87.1 1.15

0.54 84.38 1.3

0.68 78.6 1.46

0.54 84.87 1.01

0.6 78.27 1.61

0.68 78.13 1.88

1.15 58.75 3.55

1.11 58.77 2.21

0.96 61.4 1.78

0.89 65.77 2.01

0.73 77.67 1.35

0.66 69.17 1.84

0.64 69.51 4.23

0.54 76.39 2.45

0.72 70.97 6.83

Avg wait (ms) %DB time79.5

4 8.73

50 2.27

2 0.86

0 0.19

1 0.17

8 0.07

71 0.05

0 0.03

12 0

49 0

Avg wait (ms) Waits /txn % DB time3 3.35 4.61

4 1.62 2.54

50 0.11 2.27

6 0.53 1.24

2 0.87 0.86

4 0.2 0.33

1 0.46 0.17

0 38.67 0.1

19 0.01 0.06

1855 0 0.05

496 0 0.03

5 0.01 0.03

1 0.07 0.02

5 0 0.01

17 0 0.01

0 1.08 0.01

3 0.01 0.01

2 0.01 0.01

20 0 0.01

0 3.06 0

838 0 0

61 0 0

14 0 0

74 0 0

4 0 0

9 0 0

0 0.02 0

2 0 0

8 0 0

84 0 0

225 0 0

5 0 0

6 0 0

29 0 0

6 0 0

322 0 0

11 0 0

6 0 0

3 0 0

3 0 0

1 0 0

2 0 0

0 0 0

1 0 0

54 0 0

49 0 0

0 0.01 0

0 0 0

0 0 0

2 0 0

35 0 0

7 0 0

12 0 0

22 0 0

1 0 0

2 0 0

2 0 0

2 0 0

0 0 0

0 0 0

2 0 0

260 38.67

501 0.17

6 0.02

1003 0

0 0

Avg wait (ms) Waits /txn % bg time1416230 0 63.44

5 0.65 7.16

2 1.27 4.98

1 1.59 3.77

1 0.74 2.33

2 0.5 2.21

1 0.81 1.4

3 0.08 0.55

41 0.01 0.53

5 0.05 0.5

0 1.26 0.44

35 0.01 0.39

1 0.11 0.31

8 0.01 0.23

2871 0 0.13

9 0 0.09

1052 0 0.05

9 0 0.04

36 0 0.04

0 0.13 0.04

3 0 0.03

8 0 0.01

1020 0 0.01

13 0 0.01

5 0 0.01

8 0 0.01

0 0 0

26 0 0

2 0 0

4 0 0

6 0 0

1 0 0

1 0 0

1 0 0

1 0 0

1 0 0

2 0 0

1 0 0

33 0 0

1 0 0

59 0 0

0 0.02 0

5 0 0

2 0 0

1 0 0

7 0 0

0 0 0

19 0 0

6 0 0

9 0 0

0 0 0

1 0 0

0 0.02 0

0 0 0

0 0 0

0 0 0

1 0 0

0 0 0

2162 4.11

5003 0.42

11239 0.19

1006 0.84

4894 0.13

10004 0.04

996 0.43

1307 0.32

30004 0.01

184297 0

2988 0.14

60004 0.01

13967 0.03

27306 0.02

281 1.51

48616920 0

3 0.26

7439 0

11 0.02

12 0

% of Waits<4ms <8ms <16ms

12.7 33.1 12.7

0.4

0.8 0.5 0.5

100

67.6 27.8 3.6

4 75 12.9

14.5 2.4

0.3

37.4 36.3 0.9

0.1 0 0

0.7 0.6 0.6

0 0 0

14.6 6.3 2.1

2.2 4.2 3

24.8 30.6 13.8

2.9 1.5

0 0 0

2.5 0.9 0.3

0 0 0

1.2 0.5 0.5

0 0 0

1.1 2.2 1.6

3.7 92.6

2.3 1.2 2.9

1.6 1.8 1.6

1.2 43.2 28.4

10

5.2 25.8 39.7

1.5 0.6 0.5

18.2 24.7 6.7

17.1 19 6.4

16.7 8.9 9

25

2.7 1.9 3.2

16.4 4.5 4.5

4 28.3

33.3 33.3

7.5 3.3 3.3

5.4 5.4

12.9 25 24.1

8.3

0.7

4.6 4.6 8.5

4.5 9.1

4 5.4 7.4

10

6.7 6.7

5.9 5.9

11.1 3.7 7.4

2.9 17.6 2.9

3.4 13.8

1.1 0.8 1.2

2.3 1.6 2.5

10.7 18.3 16.3

1.6 1

23.1 7.7

25 25

3.7 2.3 3

16.1

6.3 1.3 1.3

17.2 19.5 6.8

0.2 1.5 0.7

3.2 6 12.6

3.6 5.5 16.4

50

28.6

0.1 0.2

1.8 0.8 8.4

1.6 0.8 0.8

7.1 8.8 11

0.1 0.4 90.6

7.2 3.4 1.3

0 0 0

0.1 0.2 0.1

2.2 1.9 3.6

2.1 3.1 3.7

0.7 0.7 0.9

2.5 0.9 0.4

% of Total Waits<1/8s <1/4s <1/2s

0.2 0.2

0.2 0.1 0

0

0

0 0 0

0.1 0 0

0.1 0

0 0

0.1 0.1 0

1.2 0.3 2.2

0

0.5

0.4 0.1 0

0.1 0 0

0.6

1 1 0.5

0.1 0 0

0.1 0.1 0

0.2 0.1 0

0.3 0.1 0

0.4 0.3

3

9.1 1

1.3 0.4

100

3.4 1.7

8.3

0.8

0.6 0.1 0

3.7

8.8 2.9

3.4 20.7

0.2 0.2 0.2

0.3 0.2 0

1 0.2 0

0.4 0.2 0

2.2 1.8 1.3

0.6

0.2 0.1 0

50 50

20.3 6.6 0.4

50

14.3 14.3

% of Total Waits<8s <16s <32s

0 0

25

0.1

8.3

Logical Reads (K)1,492,593

145

0

1,305

Concurcy Wt Time Admin Total Wts Admin Wt Time37 0 0

0 9705 5725

35 0 0

%CPU %IO SQL Id88.88 0

91.92 0

71.54 22.54

72.61 21.52

52.11 44.51

91.79 0.02

91.2 0

92.04 0.04

72.59 22.07

72.46 19.84

91.9 0.19

73.13 21.55

Elapsed Time (s) %CPU %IO11,133.45 88.88 0

10,498.93 91.92 0

5,166.13 71.54 22.54

3,774.83 91.79 0.02

4,649.69 72.61 21.52

3,196.26 91.2 0

3,166.02 92.04 0.04

4,381.32 52.11 44.51

2,294.44 72.59 22.07

2,158.54 72.46 19.84

1,149.18 91.9 0.19

608.02 73.13 21.55

f68tgm3hzwnnz53a8kaygxu00w239n3h55fcak1a7a6ygz8y77625f0qauvgms6ndd0ckx4p2hrg917417dx8xc2n5ufugp3z26mj1adajud2fbak4n5qf30k0j8r8wbx2ah7s7nxmj2n5w1q3jj96ycbjtb

Elapsed Time (s) %CPU %IO4,381.32 52.11 44.51

5,166.13 71.54 22.54

4,649.69 72.61 21.52

2,294.44 72.59 22.07

2,158.54 72.46 19.84

340.12 17.65 68.21

205.84 4.43 95.91

608.02 73.13 21.55

358.13 65.25 29.31

124 3.82 81.1

96.04 1.38 82.65

85 14.61 85.14

195.02 72.11 23.11


10,498.93 91.92 0

3,166.02 92.04 0.04

3,196.26 91.2 0

4,381.32 52.11 44.51

5,166.13 71.54 22.54

4,649.69 72.61 21.52

11,133.45 88.88 0

2,158.54 72.46 19.84

2,294.44 72.59 22.07

1,149.18 91.9 0.19

111.93 93.76 0.02

233.88 81.42 14.92


205.84 4.43 95.91

5,166.13 71.54 22.54

4,649.69 72.61 21.52

2,294.44 72.59 22.07

2,158.54 72.46 19.84

358.13 65.25 29.31

608.02 73.13 21.55

340.12 17.65 68.21

56.67 56.41 40.26

%Opt %Total SQL Id0 14.97

0 10.55

0 3.45

0 1.63

0 1.39

0 1.11

0 0.95

ajud2fbak4n5qf30k0j8r8wbx2b6usrg82hwsa35zruc4v6y32f9424h0nf7bhqzd6mcpb06rctk0x8szmwam7fysa3

0 0.61

0 0.48

0 0.34

%CPU %IO SQL Id94.29 0

96.01 0

88.88 0

92.56 0.13

92.32 0

91.66 0

91.92 0

91.79 0.02

91.2 0

92.04 0.04

86.18 1.91

92.33 0.07

93.76 0.02

93.82 0.26

SQL Module SQL TextTOAD background query session DELETE FROM CTX_SESSION WHERE ...

update seq$ set increment$=:2,...

JDBC Thin Client BEGIN pack_audit.set_context_u...

JDBC Thin Client DELETE FROM ctx_user

select condition from cdef$ wh...

SELECT value, type FROM v$para...

SELECT dest_id FROM v$archive_...

SELECT value FROM v$parameter ...

c2p32r5mzv8hb9wygvu6cx2npy3958xb2mvh047

477jzbnj2kkjcdxw3x3na1vsxnf68tgm3hzwnnzarvad97suq7p13jyk3kjz0bwwaa94ftn6jmcrpm53a8kaygxu00wd0ckx4p2hrg917417dx8xc2n5ufugp3z26mj1addb4s8nqngnr03dsnk22bby5s7b23xqu9u9s36zd4m7m0t6fjcs5x

JDBC Thin Client select FLL_DATE, FLL_USR_CODE ...

JDBC Thin Client SELECT FLUS_ID, FLUS_FLU_ID, F...

SQL Module SQL TextJDBC Thin Client select fl_id, acr_act_id, fl_t...

JDBC Thin Client select fl_id, acr_act_id, fl_t...

DBMS_SCHEDULER MERGE /*+ dynamic_sampling(ST ...

JDBC Thin Client INSERT INTO FLIGHT (FL_S_FBLST...

JDBC Thin Client UPDATE FLIGHT SET FL_S_FBLST =...

select nvl2(stale_stats, decod...

JDBC Thin Client UPDATE FLIGHT_ULD SET FLU_ULD_...

JDBC Thin Client INSERT INTO FLIGHT_ULD (FLU_UL...

emagent_SQL_oracle_database SELECT PROPAGATION_NAME, MESS...

JDBC Thin Client select fl_id, acr_act_id, fl_t...

emagent_SQL_oracle_database select capture_name streams_n...

JDBC Thin Client INSERT INTO FLIGHT_ULD (FLU_UL...

select OBJOID, CLSOID, RUNTIME...

DBMS_SCHEDULER select 'INTER_MEDIA' as name, ...

SELECT source, (case when tim...

SQL Textselect fl_id, acr_act_id, fl_t...

select fl_id, acr_act_id, fl_t...









insert into wri$_adv_sqlt_plan...

Writes: Data Reqs per sec Data per sec2M 0 0.000024

74M 0.01 0.000894

0M 0 0M

5.5G 2.38 0.068343

3.5G 6.01 0.04327

2.2G 1.97 0.027066

17M 0.01 0.000205

0M 0 0M

11.3G 10.39 0.139804

Writes: Data Reqs per sec Data per sec2.2G 2.01 0.027308

3.1G 2.36 0.038195

3.5G 5.99 0.043077

1.7G 0.02 0.021375

16M 0 0.000193

0M 0 0M

10.5G 10.38 0.130149

Writes: Data Reqs per sec Data per sec2M 0 0.000024

2M 0 0.000024

74M 0.01 0.000894

0M 0 0M

0M 0 0M

74M 0.01 0.000894

0M 0 0M

0M 0 0M

5.5G 2.38 0.068343

3G 2.33 0.037083

0M 0 0M

1.7G 0.02 0.021375

818M 0.03 0.009884

3.5G 6.01 0.04327

3.5G 5.99 0.043077

16M 0.01 0.000193

2.2G 1.97 0.027066

2.2G 1.97 0.027066

17M 0.01 0.000205

17M 0.01 0.000205

0M 0 0M

0M 0 0M

11.3G 10.39 0.139804

Av Blks/Rd Writes Av Writes/s19.62 134,036 2

63.92 14,422 0

6.65 14,055 0

18.81 3,427 0

27.71 119 0

11.48 48 0

Av Rd(ms) Av Blks/Rd Writes4.97 6.65 14,055

3.63 18.81 3,427

4.93 27.71 119

0 63.92 14,422

0.33 11.48 48

2.85 19.93 84,118

3.63 15.89 49,918

Physical Reads Physical Writes Free Buff Wait3,928,322 286,608 0

Autotune Ckpt Writes Thread Ckpt Writes274,285 0

Actual RedoBlks Target RedoBlks Log Sz RedoBlks21560 57593 165888

7565 34125 165888

Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time

1.26 36,552 1

1.04 30,035 1

1.01 29,249 1

1 29,073 1

1 29,016 1

1 28,994 1

1 28,983 1

1 28,978 1

1 28,973 1

1 28,969 1

1 28,967 1

1 28,966 1

1 28,965 1

1 28,954 1

1 28,925 1

1 28,896 1

1 28,868 1

1 28,840 1

0.99 28,811 1

0.99 28,783 1

0.98 28,440 1

W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem2.09 0.44 100

0 0 0

1-Pass Execs M-Pass Execs0 0

0 0

0 0

0 0

0 0

0 0

2 0

0 0

0 0

Estd PGA Cache Hit % Estd PGA Overalloc Count Estd Time

85 15,913 6,333,373,968

100 0 5,378,551,245

100 0 5,378,551,245

100 0 5,378,551,245

100 0 5,378,551,245

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270

100 0 5,378,514,270


Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s)211,981 1 5,221

212,032 1 5,170

212,307 1 4,895

212,500 1 4,702

212,605 1 4,597

212,680 1 4,522

212,712 1 4,490

212,723 1 4,479

212,729 1 4,473

212,731 1 4,471

212,732 1 4,470

212,732 1 4,470

212,732 1 4,470

212,732 1 4,470

212,732 1 4,470

212,732 1 4,470

Est Unspill Count Est Unspill Time (s)0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s)12 1 4,522

12 1 4,522

12 1 4,522

Waits Wt Time (s) Av Wt Time(ms)12 24 2,027.50

99 3 34.44

116 2 13.71

1 1 1,020.00

239 1 4.23

1 0 330

74 0 2.03

1 0 60

9 0 3.33

41 0 0.24

37 0 0

6 0 0

Max Tx Concurcy Min/Max TR (mins) STO/ OOS20 15/61.1 0/0

Max Tx Concy Tun Ret (mins) STO/ OOS4 23 0/0

6 33 0/0

4 23 0/0

4 33 0/0

6 23 0/0

7 33 0/0

4 23 0/0

4 34 0/0

5 26 0/0

5 16 0/0

5 28 0/0

6 18 0/0

5 24 0/0

5 15 0/0

4 24 0/0

4 34 0/0

5 24 0/0

4 42 0/0

4 32 0/0

5 34 0/0

6 24 0/0

6 15 0/0

5 24 0/0

4 15 0/0

3 24 0/0

6 15 0/0

10 15 0/0

3 34 0/0

4 24 0/0

7 34 0/0

5 24 0/0

5 34 0/0

5 32 0/0

4 22 0/0

Wait Time (s) NoWait Requests Pct NoWait Miss0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 242,955 0

0 1 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 26,785 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 1,653 0

0 28,325 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 47 0

0 0

0 0

0 0

0 0

0 82,242 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 328,416 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

13 109,888,349 0

0 301,393,442 0.02

0 317,388 0

0 0

0 0

0 0

0 0

0 0

0 274,825 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 12 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 17,456,825 0

0 0

0 0

0 0

0 0

0 0

0 0

0 279 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 2 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 23,545 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 169 0

0 0

0 0

0 0

0 0

0 0

0 0

0 9 0

0 0

0 0

0 72,475 0

0 3,823 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 170,945 0

0 1,986 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 5,472,806 0.01

0 5,472,949 0.03

0 0

0 0

0 0

0 5,375 0

0 0

0 0

0 0

0 0

0 0

0 0

0 358 0

0 0

0 0

2 3,204 0

0 0

0 0

0 0

0 0

0 0

0 415,145 0

0 0

0 0

0 0

0 0

0 0

2 0

0 0

0 0

0 0

1 0

0 111,071,571 0.18

0 0

0 0

0 55,289 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0 0

Spin Gets2,573,105

2,260

844

635

523

336

183

150

77

112

65

64

63

59

45

19

24

19

0

6

7

4

3

0

0

0

0

0

0

Waiter Sleeps0

0

6

2

15

1

3

0

0

14

897

2,193

130

25

12

60

7

5

32

6

1

0

0

22

6

0

0

9

0

1

0

0

0

0

1

14

6

1

0

1

0

1

0

0

4

0

0

0

0

0

0

0

0

4

0

0

0

28

0

5

3

0

9

19

4

4

0

63

2

0

0

0

1

Obj. Type Logical Reads %TotalTABLE 1,065,583,088 71.32

TABLE 210,480,336 14.09

TABLE 78,246,240 5.24

INDEX 24,550,720 1.64

TABLE 19,034,992 1.27

Obj. Type Physical Reads %TotalTABLE 14,931,233 84

TABLE 2,183,678 12.29

TABLE 94,938 0.53

INDEX 22,906 0.13

TABLE 8,017 0.05

Obj. Type Phys Read Requests %TotalTABLE 930,729 84.14

INDEX 22,906 2.07

TABLE 18,366 1.66

TABLE 6,644 0.6

INDEX 5,519 0.5

Obj. Type UnOptimized Reads %TotalTABLE 930,729 84.14

INDEX 22,906 2.07

TABLE 18,366 1.66

TABLE 6,644 0.6

INDEX 5,519 0.5

Obj. Type Direct Reads %TotalTABLE 11,242,436 81.19

TABLE 2,183,616 15.77

TABLE 94,936 0.69

TABLE 3,260 0.02

LOB 1,575 0.01

Obj. Type Physical Writes %TotalINDEX 64,068 21.98

INDEX 16,150 5.54

TABLE 11,385 3.91

INDEX 6,652 2.28

INDEX 4,787 1.64

Obj. Type Phys Write Requests %TotalINDEX 56,539 34.04

INDEX 8,361 5.03

TABLE 4,978 3

INDEX 3,973 2.39

INDEX 3,032 1.83

Obj. Type Direct Writes %TotalLOB 1,299 26.97

LOB 856 17.77

TABLE 498 10.34

INDEX 403 8.37

INDEX 351 7.29

Obj. Type Table Scans %TotalTABLE 12,132 18.12

INDEX 8,662 12.94

INDEX 1,525 2.28

INDEX 1,094 1.63

TABLE 128 0.19

Obj. Type DB Block Changes % of CaptureTABLE 1,946,096 26.77

TABLE 775,440 10.67

INDEX 674,096 9.27

INDEX 658,672 9.06

INDEX 651,328 8.96

Obj. Type Row Lock Waits % of CaptureINDEX 5,155 42.58

INDEX 3,523 29.1

INDEX 2,609 21.55

INDEX 138 1.14

INDEX 60 0.5

Obj. Type ITL Waits % of CaptureINDEX 11 61.11

INDEX 4 22.22

INDEX 2 11.11

INDEX 1 5.56

Obj. Type Buffer Busy Waits % of CaptureINDEX 53 26.9

INDEX 39 19.8

TABLE 38 19.29

INDEX 26 13.2

TABLE 13 6.6

Pct Miss Mod Reqs Final Usage48 1

261 1

0 6

0 123

4,047 7,662

2,503 4,848

0 193

663 4,920

0 2

0 47

521 1,582

111,310 51

0 0

0 8

0 191

0 1

0 4

0 1

0 1

0 2

0 13

0 26

Pct Miss Reloads Invali- dations0 0

25 0 0

0 5 0

0.53 0 0

0 0

57.14 0 0

0 0 0

18.34 60 0

0 0

100 0 0

0 0

0 0 0

0 0

0 0 0

0.1 1,688 1,399

0 0

67.64 0 0

0.07 1,481 0

100 63 0

100 402 0

0 56 0

0 0 0

0 0 0

0 0 0

Max Size (Mb) Oper Count Last Op Typ/Mod0 0 STA/

0 0 STA/

0 0 STA/

0 0 STA/

0 0 STA/

0 0 STA/

576 2 SHR/DEF

0 0 STA/

2,656.00 0 STA/

0 0 STA/

1,536.00 0 STA/

112 0 STA/

32 0 GRO/IMM

16 0 STA/

912 2 GRO/DEF

16 0 STA/

Re- Sizes Grows Shrinks2 1 1

2 1 1

Init Size (M) Delta Target Delta576 -32

768 32

544 32

800 -32

Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB)4.97 8.66 45

1.54 2.24 9

0.13 0.31 2

0.1 0.28 2

4.71 8.4 45

1.57 2.3 10

0.12 0.33 2

0.04 0.04 0

% Diff-0.06

0.11

0

0

0

0

0

-7.79

-19.22

-33.84

2.05

0

25.01

0

0

0

0

0

0

SYS IO Wait time(s)0

0

%Delay Msgs Enq Time(s) Deq Time(s)0 0

Avg Dequeue sec / msg

Enqueue Msgs/sec Dequeue Msgs/sec Expire Msgs/sec

0 0 0

Avg Total Dispatchers Avg Active Dispatchers1 0

Common Queue Total Disp Queue Total Server Total Msgs0 0 0

Outgoing Net %0

%Idle Total Queued Total Queue Wait (s)100 0 0

% of Waits<32ms <=1s

2.6 1.7

0.8

0.8 0.7

25

75

0.8 0.2

4.8 3.2

3.2

0.4

0.3

0 0

1.1

0 0

0.7 0.3

2.2 0.4

0 0

0.3 0.3

0 0

1.4 4.4

0 0

1.4 0.8

1 1

0.5 0.4

0.6

5

100

22.2 5.7

0.3 0.2

2 0.7

1.6 0.7

7.1 2.3

1.8 1.3

1.5 4.5

27.3 38.4

1.7 2.1

100

4.1

100

100

10.3 7.8

8.3

0.7

10 3.1

7.5 3.1

25

2

7.4 11.1

2.9 17.6

100

6.9 62.1

1.3 1.1

1 0.8

7.4 5

0.5

15.4 53.8

50

1.4 1.3

70.2 13.6

0.6 1.3

2.5 1.1

100

100

100

0.5 0.5

22.9 50.7

1.8

50

28.6

8.5 2.1

98.2

1.2 0.9

6.8 54.3

100

6.7 1.1

1.5 2.4

0.1 0.7

0.3 0.2

9.8 43.4

0 100

0 0.3

2.5 49.9

1.6 17.2

0.1 95.7

% of Total Waits<1s <2s

0.1

0 0

25 50

75 25

0

0

0

0.4 0.1

0

0

0

100

50

7.4

5.9

37.9 6.9

0.1

0

0

0.3 0.2

100

0

% of Total Waits< 1m < 2m

Network Total Wts Network Wt Time7766812 93

2257 0

245904 39

SQL Module SQL TextJDBC Thin Client SELECT vwflls_flu_id, vwflls_a...

JDBC Thin Client INSERT INTO flight_uld_dgr (fl...

JDBC Thin Client UPDATE FLIGHT_ULD B SET FLU_TF...

JDBC Thin Client DELETE FROM FLIGHT_ULD WHERE F...

JDBC Thin Client SELECT COUNT(vwflls_flu_id) FR...

JDBC Thin Client DELETE FROM flight_uld_dgr WHE...

JDBC Thin Client SELECT fludgr_id FROM flight_u...


JDBC Thin Client BEGIN pack_reload.deassign_pos...

JDBC Thin Client BEGIN pack_reload.assign_uld(:...

JDBC Thin Client SELECT COUNT(vwflls_flu_id) FR...

JDBC Thin Client delete from FLIGHT_ULD where F...


JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

f68tgm3hzwnnz53a8kaygxu00w239n3h55fcak1d0ckx4p2hrg91a7a6ygz8y77627417dx8xc2n5ufugp3z26mj1ad5f0qauvgms6ndajud2fbak4n5qf30k0j8r8wbx2ah7s7nxmj2n5w1q3jj96ycbjtb


JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

DBMS_SCHEDULER

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

DBMS_SCHEDULER

DBMS_SCHEDULER

sqlplus@CLKLXFLCDBP01 (TNS V1-V3)

JDBC Thin Client


JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

5f0qauvgms6nd239n3h55fcak1a7a6ygz8y7762ajud2fbak4n5qf30k0j8r8wbx2b6usrg82hwsa35nfc6vt4wa3td1q3jj96ycbjtbg9pv2yphydjtm6mcpb06rctk0x8szmwam7fysa369x26sjrctxv8bwf4gb43gftx2

d0ckx4p2hrg9153a8kaygxu00wfugp3z26mj1ad7417dx8xc2n5u5f0qauvgms6nd239n3h55fcak1a7a6ygz8y7762f68tgm3hzwnnzf30k0j8r8wbx2ajud2fbak4n5qah7s7nxmj2n5w

SQL*Plus

JDBC Thin Client


JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

JDBC Thin Client

DBMS_SCHEDULER

JDBC Thin Client

SQL Module SQL TextJDBC Thin Client BEGIN pack_reload.deassign_pos...

JDBC Thin Client BEGIN pack_reload.assign_uld(:...

DBMS_SCHEDULER call dbms_stats.gather_databas...

DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...

DBMS_SCHEDULER SELECT sqlset_row(sql_id, for...

DBMS_SCHEDULER call dbms_space.auto_space_adv...

DBMS_SCHEDULER insert into wri$_adv_objspace_...

23xqu9u9s36zdgm67aj46qd3sd

5f0qauvgms6nd5nfc6vt4wa3td239n3h55fcak1a7a6ygz8y7762ajud2fbak4n5qf30k0j8r8wbx2g9pv2yphydjtm1q3jj96ycbjtbb6usrg82hwsa3gr8ks2caytam9

BEGIN prvt_advisor.delete_expi...

DELETE FROM WRI$_ADV_MESSAGE_G...

DBMS_SCHEDULER select /*+ no_parallel_index(t...

SQL Module SQL TextSQL*Plus SELECT COUNT (*) FROM CTX_USER...

SQL*Plus SELECT CTXU_USER FROM CTX_USER

JDBC Thin Client SELECT vwflls_flu_id, vwflls_a...

JDBC Thin Client BEGIN pack_audit.set_context_u...

JDBC Thin Client UPDATE CTX_USER SET CTXU_USER ...

JDBC Thin Client SELECT SEQ_AUDIT_LOG.NEXTVAL F...

JDBC Thin Client INSERT INTO flight_uld_dgr (fl...

JDBC Thin Client DELETE FROM flight_uld_dgr WHE...



JDBC Thin Client SELECT fludgr_weight, fludgr_t...

TOAD background query session DELETE FROM CTX_SESSION WHERE ...

SQL*Plus SELECT COLUMN_NAME FROM USER_T...

update seq$ set increment$=:2,...

Waits: Count Avg Tm(ms)0

6338 0.33

987.2K 3.28

512.6K 0.92

248.9K 1.43

40 0

0

16 18.81

1755.1K 2.32

Small Read Large Read3.12 1.06

0.73 5.8

1.49 0.22

2.45 2.3

1.6 8.39

0.97

2.38 1.09

Waits: Count Avg Tm(ms)0

0

5751 0.36

23 0.04

144 1.35

5584 0.33

987K 3.27

987K 3.27

394.2K 0.76

393.1K 0.75

632 0.83

47 5.32

438 6.46

1349 1.45

384 1.89

965 1.27

0

0

0

0

16 18.81

16 18.81

1388.2K 2.55

Buffer Waits Av Buf Wt(ms)65,516 2.45

182 0.71

0 0

16 5.63

0 0

0 0

Av Writes/s Buffer Waits0 0

0 16

0 0

0 182

0 0

1 60,122

1 5,394

Writ Comp Wait Buffer Busy Waits0 65,714

Log Ckpt Timeout RedoBlks Log Ckpt Interval RedoBlks57593

34125

Est %DBtime for Rds

42921

19542

16722

16090

15886

15805

15767

15748

15729

15716

15708

15706

15702

15663

15558

15455

15353

15252

15150

15049

13818

%Man W/A Mem Global Mem Bound(K)0 271,970

0 271,970

Est LC Load Time Factr Est LC Mem Obj Hits (K)1.15 11,231

1.14 63,438

1.08 63,459

1.04 63,473

1.02 63,479

1 63,484

0.99 63,485

0.99 63,486

0.99 63,486

0.99 63,487

0.99 63,487

0.99 63,487

0.99 63,487

0.99 63,487

0.99 63,487

0.99 63,487

Est LC Load Time Factr Est LC Mem Obj Hits1 190

1 276

1 276

uS/uR/uU/ eS/eR/eU0/0/0/0/0/0

uS/uR/uU/ eS/eR/eU0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

0/0/0/0/0/0

Final (M) Sta544 COM

800 COM

576 COM

768 COM

Hist Max Alloc (MB) Num Proc47 78

45

3 76

40 48

47 76

46

3 74

40 46

%Transf Time %Eval Time

Server Total(KB)0

Avg Queue Wait (ms)

% of Waits>1s

0

100

75

25

0

0.2

83.3

6.9

0.2

26.5

1.8

100

92.9

0

0

0.6

98.2

100

50

97.8

100

100

21.5

100

99.7

33.8

100

75.9

0.1

% of Total Waits>=2s

0

25

0.1

33.3

% of Total Waits>=2m

SQL TextSELECT vwflls_flu_id, vwflls_a...

INSERT INTO flight_uld_dgr (fl...

UPDATE FLIGHT_ULD B SET FLU_TF...

DELETE FROM flight_uld_dgr WHE...

DELETE FROM FLIGHT_ULD WHERE F...

SELECT fludgr_id FROM flight_u...


SELECT COUNT(vwflls_flu_id) FR...

BEGIN pack_reload.deassign_pos...

BEGIN pack_reload.assign_uld(:...


delete from FLIGHT_ULD where F...

SQL TextSELECT COUNT(vwflls_flu_id) FR...





call dbms_stats.gather_databas...

SELECT LS_VERSION, USR_CODE, L...



call dbms_space.auto_space_adv...

insert into wri$_adv_objspace_...

select segment_name, segment_t...

UPDATE flight_load_seq SET fll...

SQL TextDELETE FROM flight_uld_dgr WHE...

INSERT INTO flight_uld_dgr (fl...






SELECT vwflls_flu_id, vwflls_a...




SELECT COLUMN_NAME FROM USER_T...

UPDATE flight_uld SET flu_on_l...

SQL TextSELECT COUNT(vwflls_flu_id) FR...

SELECT LS_VERSION, USR_CODE, L...







call dbms_stats.gather_databas...


Av Buf Wt(ms)0

5.63

0.71

0

2.47

2.2

Opt Log Sz(M) Estd RAC Avail Time

Num Alloc78

45

76

39

76

46

74

36

awrrpt_1_21676_21699

Documents