IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

Administration Oracle Discussion :

Interpretation AWR HELP


Sujet :

Administration Oracle

Mode arborescent

Message précédent Message précédent   Message suivant Message suivant
  1. #1
    Membre expérimenté Avatar de petitfrere
    Profil pro
    Inscrit en
    Septembre 2006
    Messages
    259
    Détails du profil
    Informations personnelles :
    Âge : 42
    Localisation : France

    Informations forums :
    Inscription : Septembre 2006
    Messages : 259
    Par défaut Interpretation AWR HELP
    Bonjour messieurs les experts

    J'ai quelques soucis de charge sur ma base depuis quelques semaines, je souhaiterais avoir votre avis sur mon rapport AWR et ainsi reperer les cause de cette charge.

    Mon environnement:

    Un cluster avec 2 noeuds + 3 replicats (2 physiques et 1 logique) oracle 10.2.0.3

    Le cluster tournait jusqu'a ya pas si longtemp sur un seul noeud, j'ai activé les deux noeud mais j'ai l'impression d'avoir des effet de bord au vues du rapport AWR (voir fin de section(cluster wait) du pdf)

    J'hésite a revenir sur un seul noeud

    J'ai ajouté une version PDF pour une meilleur lisibilité (fais sur 2h)

    THANK



    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    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
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
    181
    182
    183
    184
    185
    186
    187
    188
    189
    190
    191
    192
    193
    194
    195
    196
    197
    198
    199
    200
    201
    202
    203
    204
    205
    206
    207
    208
    209
    210
    211
    212
    213
    214
    215
    216
    217
    218
    219
    220
    221
    222
    223
    224
    225
    226
    227
    228
    229
    230
    231
    232
    233
    234
    235
    236
    237
    238
    239
    240
    241
    242
    243
    244
    245
    246
    247
    248
    249
    250
    251
    252
    253
    254
    255
    256
    257
    258
    259
    260
    261
    262
    263
    264
    265
    266
    267
    268
    269
    270
    271
    272
    273
    274
    275
    276
    277
    278
    279
    280
    281
    282
    283
    284
    285
    286
    287
    288
    289
    290
    291
    292
    293
    294
    295
    296
    297
    298
    299
    300
    301
    302
    303
    304
    305
    306
    307
    308
    309
    310
    311
    312
    313
    314
    315
    316
    317
    318
    319
    320
    321
    322
    323
    324
    325
    326
    327
    328
    329
    330
    331
    332
    333
    334
    335
    336
    337
    338
    339
    340
    341
    342
    343
    344
    345
    346
    347
    348
    349
    350
    351
    352
    353
    354
    355
    356
    357
    358
    359
    360
    361
    362
    363
    364
    365
    366
    367
    368
    369
    370
    371
    372
    373
    374
    375
    376
    377
    378
    379
    380
    381
    382
    383
    384
    385
    386
    387
    388
    389
    390
    391
    392
    393
    394
    395
    396
    397
    398
    399
    400
    401
    402
    403
    404
    405
    406
    407
    408
    409
    410
    411
    412
    413
    414
    415
    416
    417
    418
    419
    420
    421
    422
    423
    424
    425
    426
    427
    428
    429
    430
    431
    432
    433
    434
    435
    436
    437
    438
    439
    440
    441
    442
    443
    444
    445
    446
    447
    448
    449
    450
    451
    452
    453
    454
    455
    456
    457
    458
    459
    460
    461
    462
    463
    464
    465
    466
    467
    468
    469
    470
    471
    472
    473
    474
    475
    476
    477
    478
    479
    480
    481
    482
    483
    484
    485
    486
    487
    488
    489
    490
    491
    492
    493
    494
    495
    496
    497
    498
    499
    500
    501
    502
    503
    504
    505
    506
    507
    508
    509
    510
    511
    512
    513
    514
    515
    516
    517
    518
    519
    520
    521
    522
    523
    524
    525
    526
    527
    528
    529
    530
    531
    532
    533
    534
    535
    536
    537
    538
    539
    540
    541
    542
    543
    544
    545
    546
    547
    548
    549
    550
    551
    552
    553
    554
    555
    556
    557
    558
    559
    560
    561
    562
    563
    564
    565
    566
    567
    568
    569
    570
    571
    572
    573
    574
    575
    576
    577
    Cache Sizes
    	Begin	End		
    Buffer Cache:	7,504M	7,504M	Std Block Size:	8K
    Shared Pool Size:	2,048M	2,048M	Log Buffer:	14,340K
     
     
    Load Profile
    	Per Second	Per Transaction
    Redo size:	11,712.86	1,066.31
    Logical reads:	13,735.98	1,250.49
    Block changes:	64.53	5.87
    Physical reads:	23.17	2.11
    Physical writes:	2.92	0.27
    User calls:	1,478.60	134.61
    Parses:	537.53	48.94
    Hard parses:	0.04	0.00
    Sorts:	366.59	33.37
    Logons:	42.50	3.87
    Executes:	857.94	78.10
    Transactions:	10.98	 
    % Blocks changed per Read:	0.47	Recursive Call %:	60.25
    Rollback per transaction %:	24.76	Rows per Sort:	2.84
     
     
    Instance Efficiency Percentages (Target 100%)
    Buffer Nowait %:	100.00	Redo NoWait %:	100.00
    Buffer Hit %:	100.13	In-memory Sort %:	100.00
    Library Hit %:	99.99	Soft Parse %:	99.99
    Execute to Parse %:	37.35	Latch Hit %:	99.92
    Parse CPU to Parse Elapsd %:	82.35	% Non-Parse CPU:	94.47
     
     
    Shared Pool Statistics
    	Begin	End
    Memory Usage %:	61.79	62.55
    % SQL with executions>1:	89.73	96.41
    % Memory for SQL w/exec>1:	92.22	94.86
     
    Top 5 Timed Events
    Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
    CPU time	 	6,545	 	86.1	 
    latch free	157,629	1,896	12	24.9	Other
    log file sync	86,571	187	2	2.5	Commit
    control file sequential read	190,920	117	1	1.5	System I/O
    log file parallel write	91,652	111	1	1.5	System I/O
     
     
     
    Instance Activity Stats
    •	
    Statistic	Total	per Second	per Trans
    active txn count during cleanout	4,862	0.45	0.04
    application wait time	15,672	1.45	0.13
    background checkpoints completed	3	0.00	0.00
    background checkpoints started	3	0.00	0.00
    background timeouts	49,599	4.59	0.42
    branch node splits	1	0.00	0.00
    buffer is not pinned count	92,333,004	8,551.20	778.48
    buffer is pinned count	528,973,446	48,989.61	4,459.88
    bytes received via SQL*Net from client	5,647,897,807	523,066.49	47,618.59
    bytes sent via SQL*Net to client	###############	801,708,245.45	72,985,394.33
    Cached Commit SCN referenced	755	0.07	0.01
    calls to get snapshot scn: kcmgss	14,541,275	1,346.71	122.60
    calls to kcmgas	287,965	26.67	2.43
    calls to kcmgcs	6,357	0.59	0.05
    change write time	1,528	0.14	0.01
    cleanout - number of ktugct calls	5,509	0.51	0.05
    cleanouts and rollbacks - consistent read gets	1,553	0.14	0.01
    cleanouts only - consistent read gets	1,004	0.09	0.01
    cluster key scan block gets	1,840,327	170.44	15.52
    cluster key scans	1,159,926	107.42	9.78
    cluster wait time	11,650	1.08	0.10
    commit batch performed	0	0.00	0.00
    commit batch requested	0	0.00	0.00
    commit batch/immediate performed	10	0.00	0.00
    commit batch/immediate requested	10	0.00	0.00
    commit cleanout failures: block lost	388	0.04	0.00
    commit cleanout failures: buffer being written	0	0.00	0.00
    commit cleanout failures: callback failure	74	0.01	0.00
    commit cleanout failures: cannot pin	124	0.01	0.00
    commit cleanouts	180,014	16.67	1.52
    commit cleanouts successfully completed	179,428	16.62	1.51
    commit immediate performed	10	0.00	0.00
    commit immediate requested	10	0.00	0.00
    Commit SCN cached	3	0.00	0.00
    commit txn count during cleanout	9,771	0.90	0.08
    concurrency wait time	4,559	0.42	0.04
    consistent changes	9,248	0.86	0.08
    consistent gets	147,596,026	13,669.25	1,244.41
    consistent gets - examination	52,885,678	4,897.88	445.89
    consistent gets direct	224,493	20.79	1.89
    consistent gets from cache	147,371,534	13,648.46	1,242.52
    CPU used by this session	588,748	54.53	4.96
    CPU used when call started	589,746	54.62	4.97
    CR blocks created	2,630	0.24	0.02
    current blocks converted for CR	0	0.00	0.00
    cursor authentications	187	0.02	0.00
    data blocks consistent reads - undo records applied	5,327	0.49	0.04
    db block changes	696,780	64.53	5.87
    db block gets	720,525	66.73	6.07
    db block gets direct	25	0.00	0.00
    db block gets from cache	720,497	66.73	6.07
    DB time	7,302,224	676.28	61.57
    DBWR checkpoint buffers written	25,589	2.37	0.22
    DBWR checkpoints	4	0.00	0.00
    DBWR fusion writes	7,694	0.71	0.06
    DBWR tablespace checkpoint buffers written	0	0.00	0.00
    DBWR thread checkpoint buffers written	0	0.00	0.00
    DBWR transaction table writes	419	0.04	0.00
    DBWR undo block writes	6,732	0.62	0.06
    deferred (CURRENT) block cleanout applications	78,315	7.25	0.66
    DFO trees parallelized	2,782	0.26	0.02
    dirty buffers inspected	48	0.00	0.00
    enqueue conversions	28,996	2.69	0.24
    enqueue releases	4,059,089	375.92	34.22
    enqueue requests	4,070,844	377.01	34.32
    enqueue timeouts	11,708	1.08	0.10
    enqueue waits	30,872	2.86	0.26
    exchange deadlocks	3	0.00	0.00
    execute count	9,263,747	857.94	78.10
    failed probes on index block reclamation	1	0.00	0.00
    flashback log writes	3,020	0.28	0.03
    frame signature mismatch	0	0.00	0.00
    free buffer inspected	165,079	15.29	1.39
    free buffer requested	200,906	18.61	1.69
    gc blocks lost	0	0.00	0.00
    gc CPU used by this session	15,209	1.41	0.13
    gc cr block build time	245	0.02	0.00
    gc cr block flush time	255	0.02	0.00
    gc cr block receive time	6,122	0.57	0.05
    gc cr block send time	317	0.03	0.00
    gc cr blocks received	102,000	9.45	0.86
    gc cr blocks served	94,750	8.78	0.80
    gc current block flush time	246	0.02	0.00
    gc current block pin time	332	0.03	0.00
    gc current block receive time	4,593	0.43	0.04
    gc current block send time	599	0.06	0.01
    gc current blocks received	62,308	5.77	0.53
    gc current blocks served	179,211	16.60	1.51
    gc local grants	12,808	1.19	0.11
    gc remote grants	21,879	2.03	0.18
    gcs messages sent	392,707	36.37	3.31
    ges messages sent	100,630	9.32	0.85
    global enqueue get time	19,455	1.80	0.16
    global enqueue gets async	3,320	0.31	0.03
    global enqueue gets sync	347,565	32.19	2.93
    global enqueue releases	310,703	28.78	2.62
    heap block compress	938	0.09	0.01
    hot buffers moved to head of LRU	83,125	7.70	0.70
    immediate (CR) block cleanout applications	2,558	0.24	0.02
    immediate (CURRENT) block cleanout applications	12,687	1.17	0.11
    index crx upgrade (found)	289	0.03	0.00
    index crx upgrade (positioned)	487,065	45.11	4.11
    index fast full scans (full)	3,160	0.29	0.03
    index fetch by key	12,186,172	1,128.59	102.74
    index scans kdiixs1	12,110,778	1,121.61	102.11
    leaf node splits	476	0.04	0.00
    leaf node 90-10 splits	97	0.01	0.00
    lob reads	634,411	58.75	5.35
    lob writes	1,697	0.16	0.01
    lob writes unaligned	1,617	0.15	0.01
    logons cumulative	458,895	42.50	3.87
    messages received	136,505	12.64	1.15
    messages sent	136,505	12.64	1.15
    no buffer to keep pinned count	8,040	0.74	0.07
    no work - consistent read gets	91,735,077	8,495.82	773.44
    opened cursors cumulative	5,816,787	538.71	49.04
    Parallel operations downgraded to serial	0	0.00	0.00
    Parallel operations not downgraded	2,782	0.26	0.02
    parse count (failures)	3	0.00	0.00
    parse count (hard)	448	0.04	0.00
    parse count (total)	5,804,087	537.53	48.94
    parse time cpu	36,200	3.35	0.31
    parse time elapsed	43,961	4.07	0.37
    physical read bytes	2,049,073,152	189,769.99	17,276.16
    physical read IO requests	229,371	21.24	1.93
    physical read total bytes	8,495,782,912	786,816.53	71,629.69
    physical read total IO requests	571,264	52.91	4.82
    physical read total multi block requests	154,870	14.34	1.31
    physical reads	250,131	23.17	2.11
    physical reads cache	25,553	2.37	0.22
    physical reads cache prefetch	10,518	0.97	0.09
    physical reads direct	224,578	20.80	1.89
    physical reads direct (lob)	224,495	20.79	1.89
    physical reads direct temporary tablespace	0	0.00	0.00
    physical reads for flashback new	1,671	0.15	0.01
    physical reads prefetch warmup	0	0.00	0.00
    physical write bytes	258,678,784	23,956.91	2,180.97
    physical write IO requests	22,854	2.12	0.19
    physical write total bytes	1,122,947,072	103,999.05	9,467.80
    physical write total IO requests	140,567	13.02	1.19
    physical write total multi block requests	93,925	8.70	0.79
    physical writes	31,577	2.92	0.27
    physical writes direct	85	0.01	0.00
    physical writes direct (lob)	2	0.00	0.00
    physical writes direct temporary tablespace	0	0.00	0.00
    physical writes from cache	31,492	2.92	0.27
    physical writes non checkpoint	14,145	1.31	0.12
    pinned buffers inspected	123	0.01	0.00
    prefetch clients - default	65	0.01	0.00
    prefetch warmup blocks aged out before use	0	0.00	0.00
    prefetch warmup blocks flushed out before use	0	0.00	0.00
    prefetched blocks aged out before use	39	0.00	0.00
    process last non-idle time	10,797	1.00	0.09
    PX local messages recv'd	16,936	1.57	0.14
    PX local messages sent	16,936	1.57	0.14
    PX remote messages recv'd	18,248	1.69	0.15
    PX remote messages sent	18,074	1.67	0.15
    queries parallelized	2,487	0.23	0.02
    recursive calls	24,199,974	2,241.22	204.03
    recursive cpu usage	273,120	25.29	2.30
    redo blocks written	304,207	28.17	2.56
    redo buffer allocation retries	4	0.00	0.00
    redo entries	378,870	35.09	3.19
    redo log space requests	4	0.00	0.00
    redo log space wait time	14	0.00	0.00
    redo ordering marks	6,049	0.56	0.05
    redo size	126,471,520	11,712.86	1,066.31
    redo subscn max counts	10,714	0.99	0.09
    redo synch time	19,301	1.79	0.16
    redo synch writes	117,378	10.87	0.99
    redo wastage	23,865,280	2,210.23	201.21
    redo write time	13,580	1.26	0.11
    redo writer latching time	5	0.00	0.00
    redo writes	91,646	8.49	0.77
    rollback changes - undo records applied	73	0.01	0.00
    rollbacks only - consistent read gets	510	0.05	0.00
    RowCR - row contention	104	0.01	0.00
    RowCR attempts	19,916	1.84	0.17
    RowCR hits	19,836	1.84	0.17
    rows fetched via callback	10,968,247	1,015.80	92.48
    session connect time	0	0.00	0.00
    session cursor cache hits	1,745,954	161.70	14.72
    session logical reads	148,316,545	13,735.98	1,250.49
    session pga memory	15,449,522,304	1,430,820.41	130,258.10
    session pga memory max	67,223,928,288	6,225,782.69	566,778.76
    session uga memory	###############	73,176,107.23	6,661,758.90
    session uga memory max	###############	11,813,896.32	1,075,505.82
    shared hash latch upgrades - no wait	703,563	65.16	5.93
    shared hash latch upgrades - wait	297	0.03	0.00
    SMON posted for undo segment shrink	0	0.00	0.00
    sorts (disk)	0	0.00	0.00
    sorts (memory)	3,958,283	366.59	33.37
    sorts (rows)	11,251,084	1,041.99	94.86
    sql area evicted	3	0.00	0.00
    sql area purged	6	0.00	0.00
    SQL*Net roundtrips to/from client	17,433,231	1,614.54	146.98
    summed dirty queue length	9,508	0.88	0.08
    switch current to new buffer	1,870	0.17	0.02
    table fetch by rowid	293,049,083	27,140.04	2,470.76
    table fetch continued row	19,963,608	1,848.88	168.32
    table scan blocks gotten	8,566,274	793.34	72.22
    table scan rows gotten	753,149,250	69,751.11	6,349.96
    table scans (cache partitions)	0	0.00	0.00
    table scans (long tables)	1	0.00	0.00
    table scans (rowid ranges)	1	0.00	0.00
    table scans (short tables)	977,852	90.56	8.24
    total number of times SMON posted	76	0.01	0.00
    transaction lock background gets	0	0.00	0.00
    transaction lock foreground requests	0	0.00	0.00
    transaction rollbacks	10	0.00	0.00
    transaction tables consistent read rollbacks	0	0.00	0.00
    transaction tables consistent reads - undo records applied	0	0.00	0.00
    undo change vector size	46,927,316	4,346.06	395.65
    user calls	15,965,392	1,478.60	134.61
    user commits	89,245	8.27	0.75
    user I/O wait time	9,373	0.87	0.08
    user rollbacks	29,362	2.72	0.25
    workarea executions - multipass	0	0.00	0.00
    workarea executions - onepass	0	0.00	0.00
    workarea executions - optimal	1,853,013	171.61	15.62
    write clones created in background	0	0.00	0.00
    write clones created in foreground	1	0.00	0.00
     
     
     
    Tablespace IO Stats
    •	ordered by IOs (Reads + Writes) desc
    Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
    DATA_1	216,968	20	0.06	1.10	7,211	1	45	2.00
    INDX_1	10,675	1	6.41	1.00	11,698	1	24	1.67
    SYSAUX	732	0	2.98	1.03	2,164	0	0	0.00
    UNDOTBS1	14	0	6.43	1.00	947	0	34	0.29
    OCTIMEDATA	506	0	3.32	1.00	421	0	0	0.00
    SYSTEM	326	0	4.51	1.15	379	0	334	1.71
    OCTIMEIDX	225	0	4.36	1.00	31	0	0	0.00
    LOB_1	6	0	0.00	1.00	6	0	0	0.00
    UNDOTBS2	3	0	0.00	1.00	3	0	13	0.00
    USERS	3	0	0.00	1.00	3	0	0	0.00
     
     
    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 Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
    D	900,011	100	148,092,575	25,560	31,492	0	0	450
     
    Buffer Pool Advisory
    •	Only rows with estimated physical reads >0 are displayed
    •	ordered by Block Size, Buffers For Estimate
    P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
    D	752	0.10	90,193	26.77	297,674,520
    D	1,504	0.20	180,386	16.63	184,883,529
    D	2,256	0.30	270,579	10.56	117,440,481
    D	3,008	0.40	360,772	6.81	75,759,379
    D	3,760	0.50	450,965	4.29	47,742,412
    D	4,512	0.60	541,158	2.77	30,747,386
    D	5,264	0.70	631,351	1.87	20,842,561
    D	6,016	0.80	721,544	1.45	16,088,322
    D	6,768	0.90	811,737	1.18	13,149,150
    D	7,520	1.00	901,930	1.00	11,117,847
    D	8,272	1.10	992,123	0.87	9,628,699
    D	9,024	1.20	1,082,316	0.78	8,663,225
    D	9,776	1.30	1,172,509	0.72	7,988,666
    D	10,528	1.40	1,262,702	0.68	7,516,949
    D	11,280	1.50	1,352,895	0.65	7,185,877
    D	12,032	1.60	1,443,088	0.62	6,850,498
    D	12,784	1.70	1,533,281	0.59	6,529,116
    D	13,536	1.80	1,623,474	0.55	6,121,981
    D	14,288	1.90	1,713,667	0.51	5,632,630
    D	15,040	2.00	1,803,860	0.44	4,864,945
     
     
    SGA Memory Summary
    •	
    SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
    Database Buffers	7,868,514,304	 
    Fixed Size	2,089,504	 
    Redo Buffers	14,684,160	 
    Variable Size	2,298,482,144	 
     
    Wait Events
    •	s - second
    •	cs - centisecond - 100th of a second
    •	ms - millisecond - 1000th of a second
    •	us - microsecond - 1000000th of a second
    •	ordered by wait time desc, waits desc (idle events last)
    Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
    latch free	157,629	0.00	1,896	12	1.33
    log file sync	86,571	0.00	187	2	0.73
    control file sequential read	190,920	0.00	117	1	1.61
    log file parallel write	91,652	0.00	111	1	0.77
    enq: UL - contention	13,885	0.20	107	8	0.12
    db file sequential read	14,931	0.00	85	6	0.13
    reliable message	9,287	0.42	79	9	0.08
    PX Deq: reap credit	131,059	89.66	67	1	1.10
    SQL*Net message to client	13,987,478	0.00	66	0	117.93
    LNS wait on SENDREQ	3,427	0.00	53	16	0.03
    gc cr block 2-way	98,812	0.00	51	1	0.83
    SQL*Net more data from client	420,027	0.00	48	0	3.54
    enq: TX - row lock contention	297	19.87	48	162	0.00
    control file parallel write	7,630	0.00	38	5	0.06
    SQL*Net more data to client	1,464,319	0.00	35	0	12.35
    LNS ASYNC control file txn	30	100.00	29	978	0.00
    gc current block 2-way	61,967	0.00	27	0	0.52
    wait for scn ack	34,885	0.00	27	1	0.29
    gc current block busy	1,062	0.00	16	15	0.01
    latch: library cache	7,355	0.00	13	2	0.06
    enq: CF - contention	4,916	0.14	13	3	0.04
    gc current grant busy	15,792	0.00	12	1	0.13
    latch: shared pool	14,571	0.00	11	1	0.12
    cursor: pin S	9,384	0.00	11	1	0.08
    cr request retry	15	66.67	10	694	0.00
    enq: PS - contention	9,473	0.00	10	1	0.08
    PX Deq: Signal ACK	4,841	33.82	9	2	0.04
    latch: session allocation	7,550	0.00	9	1	0.06
    cursor: pin S wait on X	908	81.06	9	9	0.01
    db file parallel write	9,331	0.00	8	1	0.08
    DFS lock handle	661	0.00	8	13	0.01
    IPC send completion sync	10,047	98.08	8	1	0.08
    latch: library cache lock	3,147	0.00	6	2	0.03
    gc cr block busy	2,906	0.00	6	2	0.02
    gcs log flush sync	5,051	13.80	6	1	0.04
    direct path read	214,317	0.00	5	0	1.81
    rdbms ipc reply	7,138	0.00	5	1	0.06
    row cache lock	3,287	0.00	4	1	0.03
    db file scattered read	733	0.00	4	5	0.01
    log file sequential read	169	0.00	4	21	0.00
    PX Deq Credit: send blkd	7,525	47.68	3	0	0.06
    gc cr grant 2-way	3,868	0.00	2	1	0.03
    latch: row cache objects	939	0.00	2	2	0.01
    name-service call wait	29	0.00	2	67	0.00
    latch: cache buffers chains	1,984	0.00	2	1	0.02
    os thread startup	37	0.00	2	50	0.00
    enq: WF - contention	36	2.78	2	51	0.00
    enq: US - contention	5,258	0.00	2	0	0.04
    CGS wait for IPC msg	93,771	100.00	2	0	0.79
    SQL*Net break/reset to client	4,814	0.00	2	0	0.04
    gc current grant 2-way	4,960	0.00	2	0	0.04
    Log archive I/O	145	0.00	1	9	0.00
    ARCH wait on c/f tx acquire 2	1	100.00	1	977	0.00
    ksxr poll remote instances	37,889	85.58	1	0	0.32
    gc cr multi block request	1,506	0.00	1	0	0.01
    gc buffer busy	237	0.00	1	3	0.00
    enq: TM - contention	336	0.00	0	1	0.00
    latch: enqueue hash chains	286	0.00	0	1	0.00
    latch: ges resource hash list	358	0.00	0	0	0.00
    log file switch completion	4	0.00	0	35	0.00
    latch: virtual circuit queues	293	0.00	0	0	0.00
    library cache pin	94	0.00	0	1	0.00
    enq: SQ - contention	19	0.00	0	5	0.00
    gc current retry	4	0.00	0	23	0.00
    library cache lock	97	0.00	0	1	0.00
    enq: TX - index contention	44	0.00	0	2	0.00
    buffer busy waits	223	0.45	0	0	0.00
    latch: library cache pin	30	0.00	0	2	0.00
    enq: FB - contention	69	0.00	0	1	0.00
    LGWR wait for redo copy	125	0.80	0	0	0.00
    db file parallel read	1	0.00	0	44	0.00
    PX qref latch	3,002	98.90	0	0	0.03
    enq: TA - contention	36	0.00	0	1	0.00
    enq: HW - contention	36	0.00	0	1	0.00
    enq: FL - Flashback database log	15	0.00	0	2	0.00
    flashback buf free by RVWR	4	0.00	0	4	0.00
    latch: gcs resource hash	111	0.00	0	0	0.00
    enq: RO - fast object reuse	3	0.00	0	4	0.00
    wait list latch free	1	0.00	0	11	0.00
    direct path write	66	0.00	0	0	0.00
    latch: cache buffers lru chain	12	0.00	0	1	0.00
    enq: JS - job run lock - synchronize	6	0.00	0	1	0.00
    library cache load lock	2	0.00	0	3	0.00
    gc cr failure	15	0.00	0	0	0.00
    latch: redo allocation	8	0.00	0	1	0.00
    log file single write	6	0.00	0	1	0.00
    ges inquiry response	6	0.00	0	1	0.00
    enq: MW - contention	6	0.00	0	1	0.00
    latch: messages	13	0.00	0	0	0.00
    enq: DR - contention	6	0.00	0	1	0.00
    KJC: Wait for msg sends to complete	35	0.00	0	0	0.00
    enq: WR - contention	6	0.00	0	0	0.00
    enq: PI - contention	4	0.00	0	1	0.00
    enq: AF - task serialization	1	0.00	0	2	0.00
    latch: KCL gc element parent latch	27	0.00	0	0	0.00
    enq: WL - contention	2	0.00	0	1	0.00
    log buffer space	1	0.00	0	1	0.00
    buffer deadlock	2	100.00	0	0	0.00
    latch: object queue header operation	9	0.00	0	0	0.00
    gc current split	1	0.00	0	1	0.00
    gc cr disk read	1	0.00	0	1	0.00
    enq: TT - contention	1	0.00	0	0	0.00
    enq: JQ - contention	1	0.00	0	0	0.00
    enq: TX - allocate ITL entry	1	0.00	0	0	0.00
    latch: checkpoint queue latch	2	0.00	0	0	0.00
    read by other session	1	0.00	0	0	0.00
    SQL*Net message from client	13,987,398	0.00	964,525	69	117.93
    virtual circuit status	4,844,858	0.00	170,002	35	40.85
    pipe get	15,549	79.92	31,895	2051	0.13
    LNS ASYNC end of log	2,906,384	100.00	31,351	11	24.50
    Streams AQ: waiting for time management or cleanup tasks	44	18.18	29,154	662585	0.00
    PX Idle Wait	15,928	61.36	27,247	1711	0.13
    jobq slave wait	8,819	47.37	21,073	2389	0.07
    Streams AQ: waiting for messages in the queue	5,570	57.85	21,061	3781	0.05
    gcs remote message	1,199,643	91.57	20,967	17	10.11
    class slave wait	3,645	0.82	19,911	5462	0.03
    DIAG idle wait	53,461	0.00	10,541	197	0.45
    ASM background timer	7,492	0.00	10,535	1406	0.06
    ges remote message	225,940	93.97	10,522	47	1.90
    Streams AQ: qmn slave idle wait	381	0.00	10,510	27585	0.00
    Streams AQ: qmn coordinator idle wait	770	50.52	10,510	13649	0.01
    PX Deq: Execution Msg	29,689	16.78	166	6	0.25
    KSV master wait	3,642	0.27	35	10	0.03
    PX Deq: Execute Reply	5,706	28.95	25	4	0.05
    PX Deq: Join ACK	6,612	35.15	20	3	0.06
    PX Deq: Msg Fragment	10,218	21.55	4	0	0.09
    wait for unread message on broadcast channel	984	0.00	3	3	0.01
    PX Deq: Parse Reply	6,297	39.03	2	0	0.05
    Streams AQ: RAC qmn coordinator idle wait	770	100.00	0	0	0.01
    PX Deq Credit: need buffer	7	28.57	0	0	0.00
     
     
    SQL ordered by Cluster Wait Time
    •	
    Cluster Wait Time (s)	CWT % of Elapsd Time	Elapsed Time(s)	CPU Time(s)	Executions	SQL Id	SQL Module	SQL Text
    10.79	21.56	50.03	16.55	778	7wygnqxmj6uta
    perl@*** (TNS V1-V3)	BEGIN ***_traitement_new_for…
    9.28	7.91	117.31	11.16	4,439	1g80nsk99t7ct
    installe	BEGIN DBMS_ALERT.WAITANY(...
    4.18	15.00	27.86	20.76	289	38f96pkmsfw9t
    httpd@*** (TNS V1-V3)	DECLARE alert_don...
    3.63	12.01	30.22	24.37	76,194	b81sx02jzkdyn
    perl@*** (TNS V1-V3)	SELECT ticket.id, ticket.idope...
    3.37	62.70	5.38	4.54	2,896	bsdhgdy3at72h
    httpd@*** (TNS V1-V3)	SELECT OPERATION_CODE...
    2.64	0.89	296.04	224.32	160	16d1tsnzky936
    perl@*** (TNS V1-V3)	SELECT ****.id, ****,…
    2.54	1.52	167.62	165.64	682,610	0v4fh9ruza0pm
    perl@*** (TNS V1-V3)	SELECT id.value, id.type, id.r...
    2.42	5.76	42.02	1.00	1,558	6tmkh8j0d3w0p
    perl@*** (TNS V1-V3)	UPDATE DBMS_ALERT_INFO SET CHA...
    2.15	8.63	24.92	24.51	194,720	bz7ga6p2p80c5
    perl@*** (TNS V1-V3)	SELECT TO_CHAR(the_date, 'DD/M...
    2.08	2.94	70.64	70.34	209,123	a6t78ct84pfvt
    httpd@*** (TNS V1-V3)	SELECT COUNT(1) A...
    2.04	12.15	16.82	2.62	1,825	az61njz42u0wf
    ***	BEGIN SELECT /*+ INDEX(NO...
    2.02	24.61	8.20	8.11	56,618	3ntxcmrvnkhpf
    apache@*** (TNS V1-V3)	SELECT value FROM reg_stats WH...
    2.01	32.31	6.23	5.18	5,829	f4cbwmnfmygmy
    httpd@*** (TNS V1-V3)	SELECT 1 AS FETCHED ...
    1.67	6.69	24.91	24.48	139,540	68pjkw6us7hbm
    apache@*** (TNS V1-V3)	SELECT id.value, id.type, id.r...
    1.63	2.75	59.15	58.78	162,448	3sr8pgwxwzsqp
    httpd@*** (TNS V1-V3)	SELECT NI...
    1.24	3.92	31.51	29.58	1,912	0n5b95zqfsq9t
    httpd@*** (TNS V1-V3)	SELECT IT...
    1.23	8.19	14.98	1.07	297	b1fm3ac7px5nc
    ***	UPDATE NOTIFY_QUEUE SET ETAT =...
    1.18	14.73	8.03	1.99	326	5rn0kqcvd2h2v
    ***	UPDATE TICKET SET IDETAT=:B5 ,...
    1.15	36.26	3.17	3.03	5,915	2f2tdwy5qdsxk
    httpd@*** (TNS V1-V3)	SELECT 1 AS FETCHED ...
    1.11	2.03	54.89	54.28	72,806	798w1bnqvmj7b
    perl@*** (TNS V1-V3)	BEGIN sie_probe.update_counte...
    1.07	6.33	16.87	16.54	103,174	g1kymag8xjq4s
    apache@*** (TNS V1-V3)	SELECT id.value, id.type, id.r...
    1.07	19.77	5.39	5.25	44,563	3as5f5y4r0v38
    apache@*** (TNS V1-V3)	SELECT value FROM nsl_stats WH...
    0.98	2.63	37.05	36.81	194,720	5xk7w6upwu628
    perl@*** (TNS V1-V3)	SELECT id.value, id.type, id.r...
    0.93	8.94	10.35	8.88	10,396	am38p8br61ffc
    httpd@*** (TNS V1-V3)	SELECT CONTACT_CL...
    0.88	4.11	21.30	21.17	63,484	1kmuh1rhqub48
    perl@*** (TNS V1-V3)	UPDATE mp_counters SET last_up...
    0.85	1.25	68.51	67.64	251,082	dbc23knxjp656
    perl@*** (TNS V1-V3)	SELECT TO_CHAR(the_date, 'DD/M...
    0.65	0.66	98.43	91.98	74	3krna5m1zxqzj
    apache@*** (TNS V1-V3)	select t.id, d.nom, t.seed, td...
    0.64	14.14	4.54	4.12	17,827	bhrcp276ztkju
    httpd@*** (TNS V1-V3)	SELECT ticket.id, ticket.idope...
    0.62	2.95	21.03	17.77	568	7cd19cu3k9099
    perl@*** (TNS V1-V3)	BEGIN :leresultat := CreeOuDon...
    0.62	5.62	11.03	8.52	7,500	5smmjvftxwk6q
    apache@*** (TNS V1-V3)	select t.idope, t.idetat from...
    0.59	54.60	1.08	1.00	848	5vxd73cmk28kw
    httpd@*** (TNS V1-V3)	SELECT ...
    0.47	6.12	7.65	7.06	1,278	6mtny06dxk3mb
    ***	SELECT 1 FROM ****...
    0.46	1.47	31.18	1.12	141	347h9yvgxsn51
    ***	UPDATE notify_queue SET et...
    0.34	43.37	0.78	0.68	526	dd3wd826kytr8
    ruby@*** (TNS V1-V3)	insert into zonecheck_...
    0.26	1.31	19.46	16.95	185	gca4sxc14kfc8
    perl@*** (TNS V1-V3)	UPDATE NOMDEDOMAINE SET ID=:B4...
    0.25	17.40	1.45	1.38	2,821	4m7m0t6fjcs5x
     	update seq$ set increment$=:2,...
    0.25	1.26	19.76	19.66	57,841	arsffzkdpwuvm
    perl@*** (TNS V1-V3)	SELECT id.value, id.type, id.r...
    0.21	27.46	0.75	0.71	1,536	2mcscp7c4qg7r
    httpd@*** (TNS V1-V3)	SELECT ...
    0.19	45.72	0.43	0.35	462	5ga07ud9bvuy3
    httpd@*** (TNS V1-V3)	select t.idope, t.idetat from...
    0.19	0.72	25.65	24.25	2,891	6gap50dg16c6c
    httpd@*** (TNS V1-V3)	SELECT DISTINCT com_categorie...
    0.17	7.12	2.45	2.35	526	d2kja65uscpt0
    ruby@*** (TNS V1-V3)	delete from ***...
    0.13	7.51	1.73	1.61	1,857	276y80bausshs
    apache@*** (TNS V1-V3)	select t.id, d.nom, t.seed, td...
    0.07	0.92	7.48	6.71	23	2qcpxxss1q5b3
     	SELECT ***, who...
    0.05	0.27	18.60	18.11	2,900	30x6k8vx8g8rx
    httpd@*** (TNS V1-V3)	SELECT B.* FROM ( SELECT A.*,...
    0.04	13.96	0.26	0.12	17	bqgqx5j5jvvn8
    httpd@*** (TNS V1-V3)	SELECT tc.IDTICK, t.IDETAT, ...
    0.02	9.16	0.23	0.23	903	6nw7yfqw0rx12
    httpd@*** (TNS V1-V3)	SELECT ****...
    0.01	0.17	8.26	8.23	2,652	7hpup095cg8pa
    httpd@*** (TNS V1-V3)	SELECT com_actu.ID, com_actu....
    0.01	0.04	27.38	27.24	55,094	5ap0uctrxa689
    apache@*** (TNS V1-V3)	SELECT idliste FROM contenulis...
    0.01	4.25	0.23	0.22	206	gnr8am46y6pab
    apache@*** (TNS V1-V3)	select count(*) from nomdedoma...
    0.01	16.10	0.04	0.04	68	b0y53xw7rk369
    php@*** (TNS V1-V3)	UPDATE test_services_tech SET ...
    0.01	0.01	92.15	92.00	499,456	7bvp8a2730kxd
    perl@g*** (TNS V1-V3)	SELECT adherent.id, adherent.n...
    0.01	2.93	0.20	0.09	1	1sdncrnq37hjm
    emagent@***(TNS V1-V3)	/* OracleOEM */ SELECT /*+ IN...
    Images attachées Images attachées

Discussions similaires

  1. Réponses: 3
    Dernier message: 07/04/2003, 20h06
  2. help please
    Par atom267 dans le forum CORBA
    Réponses: 2
    Dernier message: 24/01/2003, 10h41
  3. [Kylix] fichiers help kylix2 oe ??
    Par sdoura2 dans le forum EDI
    Réponses: 2
    Dernier message: 29/11/2002, 14h32
  4. Help :Problème de clignotement
    Par LE CHAKAL dans le forum Composants VCL
    Réponses: 6
    Dernier message: 14/08/2002, 10h53
  5. Help InnoSetup ou Installshield
    Par buzz dans le forum Outils
    Réponses: 4
    Dernier message: 30/07/2002, 15h26

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo