OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.10.0.0
방법 : 오라클 19c AWR 에 저장된 정보 확인(awrinfo.sql)
awr repository에 대한 정보를 제공하는 스크립트를 실행하면
sysaux에 저장되어있는 awr 데이터들의 다양한 정보를 볼수있음
- ADDM 관련 정보
- AWR 보존 설정
- AWR 스냅샷 크기 추정(일별, 인스턴스별 주별 및 데이터베이스별 주별)
- 가장 오래된 - 기준이 아닌 AWR 스냅샷
- 테이블별 SYSAUX 점유 공간 사용량
- 등록되지 않은 스키마에 의한 SYSAUX 공간 사용량
- 스키마 소유자별로 구성된 SYSAUX 테이블스페이스 사용량 요약
- 총 AWR 스냅샷 수
sqlplus 접속 후 스크립트 실행
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
SQL> @?/rdbms/admin/awrinfo.sql
This script will report general AWR information
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Specify the Report File Name
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrinfo.txt. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: <-- 리포트 이름 지정 또는 엔터
.
.
**********************************
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)
**********************************
Foreground % 22.2
Background % 77.8
MMNL % 0.0
End of Report
Report written to awrinfo.txt
|
awrinfo 항목 요약
|
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
|
AWR INFO Report 항목
(I) AWR Snapshots Information
(1a) SYSAUX usage - Schema breakdown (dba_segments)
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
(1c) SYSAUX usage - Unregistered Schemas
(1d) SYSAUX usage - Unaccounted space in registered schemas
(2) Size estimates for AWR snapshots
(3a) Space usage by AWR components (per database)
(3b) Space usage within AWR Components (> 500K)
(4) Space usage by non-AWR components (> 500K)
(5a) AWR snapshots - last 50
(5b) AWR snapshots with errors or invalid
(5c) AWR snapshots -- OLDEST Non-Baselined snapshots
(6) AWR Control Settings - interval, retention
(7a) AWR Contents - row counts for each snapshots
(7b) AWR Contents - average row counts per snapshot
(7c) AWR total item counts - names, text, plans
(II) Advisor Framework Info
(1) Advisor Tasks - Last 50
(2) Advisor Task - Oldest 5
(3) Advisor Tasks With Errors - Last 50
(III) ASH Usage Info
(1a) ASH histogram (past 3 days)
(1b) ASH histogram (past 1 day)
(2a) ASH details (past 3 days)
(2b) ASH details (past 1 day)
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)
|
awrinfo.txt 파일 전체 확인
|
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
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
|
~~~~~~~~~~~~~~~
AWR INFO Report
~~~~~~~~~~~~~~~
Report generated at 23:52:28 on Nov 04, 2021 ( Thursday ) in Timezone +09:00
Warning: Non Default AWR Setting!
--------------------------------------------------------------------------------
Snapshot interval is 60 minutes and Retention is 8 days
DB_ID DB_NAME HOST_PLATFORM INST STARTUP_TIME LAST_ASH_SID RAC VERSION
------------ --------- ---------------------------------------- ----- ----------------- ------------ --- -----------------
* 362905073 ORCL19 ORACLE19 - Linux x86 64-bit 1 15:51:40 (09/02) 20382473 NO 19.0.0.0.0
########################################################
(I) AWR Snapshots Information
########################################################
*****************************************************
(1a) SYSAUX usage - Schema breakdown (dba_segments)
*****************************************************
|
| Total SYSAUX size 955.7 MB ( 3% of 32,768.0 MB MAX with AUTOEXTEND ON )
|
| Schema SYS occupies 871.9 MB ( 91.2% )
| Schema XDB occupies 62.9 MB ( 6.6% )
| Schema SYSTEM occupies 12.6 MB ( 1.3% )
| Schema WMSYS occupies 6.6 MB ( 0.7% )
| Schema GSMADMIN_INT occupies 0.9 MB ( 0.1% )
| Schema DBSNMP occupies 0.8 MB ( 0.1% )
|
********************************************************
(1b) SYSAUX occupants space usage (v$sysaux_occupants)
********************************************************
|
| Occupant Name Schema Name Space Usage
| -------------------- -------------------- ----------------
| SM/AWR SYS 379.9 MB
| SM/OPTSTAT SYS 282.3 MB
| XDB XDB 62.9 MB
| SM/OTHER SYS 34.8 MB
| SQL_MANAGEMENT_BASE SYS 28.6 MB
| SM/ADVISOR SYS 27.9 MB
| LOGMNR SYSTEM 10.8 MB
| WM WMSYS 6.6 MB
| JOB_SCHEDULER SYS 6.4 MB
| SMON_SCN_TIME SYS 3.4 MB
| PL/SCOPE SYS 2.9 MB
| AO SYS 1.9 MB
| STREAMS SYS 1.7 MB
| LOGSTDBY SYSTEM 1.6 MB
| EM_MONITORING_USER DBSNMP 0.8 MB
| AUTO_TASK SYS 0.6 MB
| AUDIT_TABLES SYS 0.0 MB
| AUDSYS AUDSYS 0.0 MB
| EM SYSMAN 0.0 MB
| EXPRESSION_FILTER EXFSYS 0.0 MB
| ORDIM ORDSYS 0.0 MB
| ORDIM/ORDDATA ORDDATA 0.0 MB
| ORDIM/ORDPLUGINS ORDPLUGINS 0.0 MB
| ORDIM/SI_INFORMTN_SC SI_INFORMTN_SCHEMA 0.0 MB
| SDO MDSYS 0.0 MB
| STATSPACK PERFSTAT 0.0 MB
| TEXT CTXSYS 0.0 MB
| TSM TSMSYS 0.0 MB
| ULTRASEARCH WKSYS 0.0 MB
| ULTRASEARCH_DEMO_USE WK_TEST 0.0 MB
| XSAMD OLAPSYS 0.0 MB
| XSOQHIST SYS 0.0 MB
|
| Others (Unaccounted space) 102.8 MB
|
******************************************
(1c) SYSAUX usage - Unregistered Schemas
******************************************
| This section displays schemas that are not registered
| in V$SYSAUX_OCCUPANTS
|
| Schema GSMADMIN_INT occupies 0.9 MB
|
| Total space 0.9 MB
|
*************************************************************
(1d) SYSAUX usage - Unaccounted space in registered schemas
*************************************************************
|
| This section displays unaccounted space in the registered
| schemas of V$SYSAUX_OCCUPANTS.
|
| Unaccounted space in SYS/SYSTEM 101.9 MB
|
| Total space 101.9 MB
|
*************************************
(2) Size estimates for AWR snapshots
*************************************
|
| Estimates based on 60 mins snapshot INTERVAL:
| AWR size/day 42.4 MB (1,810 K/snap * 24 snaps/day)
| AWR size/wk 296.9 MB (size_per_day * 7) per instance
|
| Estimates based on 24 snaps in past 24 hours:
| AWR size/day 42.4 MB (1,810 K/snap and 24 snaps in past 24 hours)
| AWR size/wk 296.9 MB (size_per_day * 7) per instance
|
**********************************
(3a) Space usage by AWR components (per database)
**********************************
COMPONENT MB % AWR KB_PER_SNAP MB_PER_DAY MB_PER_WEEK TABLE% : INDEX%
--------- --------- ------ ------------ ---------- ----------- ----------------
FIXED 253.5 66.7 1,207 28.3 198.1 45% : 55%
EVENTS 59.1 15.6 282 6.6 46.2 47% : 53%
SPACE 13.0 3.4 62 1.5 10.2 51% : 49%
SQL 11.9 3.1 57 1.3 9.3 52% : 48%
SQLPLAN 11.0 2.9 52 1.2 8.6 64% : 36%
ASH 1.4 0.4 7 0.2 1.1 50% : 50%
SQLTEXT 0.9 0.2 4 0.1 0.7 87% : 13%
SQLBIND 0.8 0.2 4 0.1 0.6 46% : 54%
RAC 0.6 0.2 3 0.1 0.5 50% : 50%
**********************************
(3b) Space usage within AWR Components (> 500K)
**********************************
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
FIXED 4.0 WRH$_SYSMETRIC_SUMMARY - 61% TABLE
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5610 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5778 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5754 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5634 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5658 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5682 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5706 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5730 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5754 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY.WRH$_SYSMETRIC_HISTORY_362905073_5778 - 59% TABLE PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 66% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSMETRIC_HISTORY_INDEX.WRH$_SYSMETRIC_HISTORY_362905073 - 65% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_2478 - 76% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5610 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5634 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5658 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5682 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5706 - 74% INDEX PARTITION
FIXED 3.0 WRH$_SYSSTAT_PK.WRH$_SYSSTAT_362905073_5730 - 74% INDEX PARTITION
FIXED 2.0 WRH$_CON_SYSMETRIC_SUMMARY - 30% TABLE
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_362905073_2478 - 50% TABLE PARTITION
FIXED 2.0 WRH$_LATCH.WRH$_LATCH_362905073_5610 - 54% TABLE PARTITION
EVENTS 3.0 WRH$_BG_EVENT_SUMMARY_PK - 45% INDEX
EVENTS 3.0 WRH$_ENQUEUE_STAT_PK - 50% INDEX
EVENTS 2.0 WRH$_BG_EVENT_SUMMARY - 41% TABLE
EVENTS 2.0 WRH$_ENQUEUE_STAT - 60% TABLE
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5778 - 75% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5754 - 73% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5730 - 73% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5706 - 73% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5682 - 74% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5658 - 82% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5634 - 82% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_5610 - 82% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM_PK.WRH$_EVENT_HISTOGRAM_362905073_2478 - 77% INDEX PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5778 - 41% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5754 - 38% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5730 - 40% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5706 - 43% TABLE PARTITION
COMPONENT MB SEGMENT_NAME - % SPACE_USED SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_2478 - 35% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5610 - 42% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5634 - 40% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5658 - 40% TABLE PARTITION
EVENTS 2.0 WRH$_EVENT_HISTOGRAM.WRH$_EVENT_HISTOGRAM_362905073_5682 - 43% TABLE PARTITION
EVENTS 0.7 WRH$_LIBRARYCACHE - 52% TABLE
EVENTS 0.6 WRH$_LIBRARYCACHE_PK - 58% INDEX
SQL 0.7 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5706 - 82% TABLE PARTITION
SQL 0.7 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5682 - 77% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5778 - 79% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5754 - 75% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5610 - 87% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5634 - 90% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5658 - 84% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_2478 - 79% TABLE PARTITION
SQL 0.6 WRH$_SQLSTAT.WRH$_SQLSTAT_362905073_5730 - 89% TABLE PARTITION
SQLPLAN 7.0 WRH$_SQL_PLAN - 26% TABLE
SQLPLAN 4.0 WRH$_SQL_PLAN_PK - 41% INDEX
SQLTEXT 0.8 WRH$_SQLTEXT - 60% TABLE
**********************************
(4) Space usage by non-AWR components (> 500K)
**********************************
COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR 104.0 SYS.I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST INDEX
NON_AWR 52.0 SYS.I_WRI$_OPTSTAT_H_ST INDEX
NON_AWR 36.2 SYS.SYS_LOB0000010460C00001$$ LOBSEGMENT
NON_AWR 24.1 SYS.SYS_LOB0000007421C00004$$ LOBSEGMENT
NON_AWR 24.1 SYS.SYS_LOB0000011146C00038$$ LOBSEGMENT
NON_AWR 16.2 SYS.SYS_LOB0000000357C00040$$ LOBSEGMENT
NON_AWR 11.0 SYS.I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST INDEX
NON_AWR 8.0 SYS.HEATMAP SYSTEM STATISTI
CS
NON_AWR 6.0 SYS.I_WRI$_OPTSTAT_HH_ST INDEX
NON_AWR 5.0 SYS.WRI$_OPTSTAT_OPR_TASKS TABLE
NON_AWR 4.2 SYS.SYS_LOB0000008765C00040$$ LOBSEGMENT
NON_AWR 4.0 SYS.SQLOBJ$PLAN TABLE
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4729 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3969 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4769 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4509 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4474 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4249 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4009 TABLE PARTITION
NON_AWR 4.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4214 TABLE PARTITION
NON_AWR 4.0 SYS.SCHEDULER$_EVENT_LOG TABLE
NON_AWR 4.0 SYS.WRI$_ADV_PARAMETERS_PK INDEX
NON_AWR 3.2 SYS.SYS_LOB0000011138C00004$$ LOBSEGMENT
NON_AWR 3.0 SYS.SMON_SCN_TO_TIME_AUX CLUSTER
NON_AWR 3.0 SYS.WRI$_ADV_PARAMETERS TABLE
NON_AWR 3.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_TGST INDEX
NON_AWR 2.2 SYS.SYS_LOB0000008705C00008$$ LOBSEGMENT
NON_AWR 2.1 SYS.SYS_LOB0000000339C00003$$ LOBSEGMENT
NON_AWR 2.0 SYS.SQLOBJ$PLAN_PKEY INDEX
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4809 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4389 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4349 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4129 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4609 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4429 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4649 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4269 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3869 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4029 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3909 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3789 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4549 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4909 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4689 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4309 TABLE PARTITION
COMPONENT MB SEGMENT_NAME SEGMENT_TYPE
--------- --------- --------------------------------------------------------------------- ---------------
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4109 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4829 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3929 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4069 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P3829 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4589 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4169 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SYS_P4869 TABLE PARTITION
NON_AWR 2.0 SYS.WRI$_ADV_SQLT_PLANS TABLE
NON_AWR 2.0 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPOBJ INDEX
NON_AWR 1.2 SYS.SYS_LOB0000000351C00005$$ LOBSEGMENT
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4812 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4788 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4668 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4628 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4928 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4708 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4848 LOB PARTITION
NON_AWR 1.2 SYS.SYS_LOB0000009064C00008$$ LOBSEGMENT
NON_AWR 1.2 SYS.SYS_LOB0000007421C00005$$ LOBSEGMENT
NON_AWR 1.1 SYS.SYS_LOB0000009068C00005$$ LOBSEGMENT
NON_AWR 1.1 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4748 LOB PARTITION
NON_AWR 1.1 SYS.SYS_LOB0000007450C00009$$.SYS_LOB_P4888 LOB PARTITION
NON_AWR 1.0 SYS.LTXID_TRANS.LTXID_TRANS_1 TABLE PARTITION
NON_AWR 1.0 SYS.SYS$SERVICE_METRICS_TAB TABLE
NON_AWR 0.8 SYS.I_WRI$_OPTSTAT_OPR_TASKS_STIME INDEX
NON_AWR 0.8 SYS.I_WRI$_OPTSTAT_OPR_TASKS_OPID INDEX
NON_AWR 0.7 SYS.I_WRI$_OPTSTAT_TAB_OBJ#_ST INDEX
NON_AWR 0.7 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P3966 TABLE PARTITION
NON_AWR 0.7 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4506 TABLE PARTITION
NON_AWR 0.7 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4246 TABLE PARTITION
NON_AWR 0.7 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4211 TABLE PARTITION
NON_AWR 0.7 SYS.WRI$_OPTSTAT_IND_HISTORY TABLE
NON_AWR 0.6 SYS.I_WRI$_OPTSTAT_IND_OBJ#_ST INDEX
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4726 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4766 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4471 TABLE PARTITION
NON_AWR 0.6 SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SYS_P4006 TABLE PARTITION
NON_AWR 0.6 SYS.I_PLSCOPE_ACTION$ INDEX
NON_AWR 0.6 SYS.WRI$_OPTSTAT_TAB_HISTORY TABLE
NON_AWR 0.5 SYS.PLSCOPE_ACTION$ TABLE
**********************************
(5a) AWR snapshots - last 50
**********************************
Total snapshots in DB 362905073 Instance 1 = 215
DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
362905073 5751 1 +00000 00:00:01.5 22:00:05 (11/02) 15:51:40 (09/02) 0 0
362905073 5752 1 +00000 00:00:00.5 23:00:19 (11/02) 15:51:40 (09/02) 0 0
362905073 5753 1 +00000 00:00:00.5 00:00:34 (11/03) 15:51:40 (09/02) 0 0
362905073 5754 1 +00000 00:00:00.6 01:00:49 (11/03) 15:51:40 (09/02) 0 0
362905073 5755 1 +00000 00:00:00.5 02:00:03 (11/03) 15:51:40 (09/02) 0 0
362905073 5756 1 +00000 00:00:00.4 03:00:17 (11/03) 15:51:40 (09/02) 0 0
362905073 5757 1 +00000 00:00:00.4 04:00:31 (11/03) 15:51:40 (09/02) 0 0
362905073 5758 1 +00000 00:00:00.3 05:00:45 (11/03) 15:51:40 (09/02) 0 0
362905073 5759 1 +00000 00:00:00.3 06:00:59 (11/03) 15:51:40 (09/02) 0 0
362905073 5760 1 +00000 00:00:00.4 07:00:13 (11/03) 15:51:40 (09/02) 0 0
362905073 5761 1 +00000 00:00:00.5 08:00:27 (11/03) 15:51:40 (09/02) 0 0
362905073 5762 1 +00000 00:00:00.4 09:00:41 (11/03) 15:51:40 (09/02) 0 0
362905073 5763 1 +00000 00:00:00.4 10:00:56 (11/03) 15:51:40 (09/02) 0 0
362905073 5764 1 +00000 00:00:00.3 11:00:10 (11/03) 15:51:40 (09/02) 0 0
362905073 5765 1 +00000 00:00:00.4 12:00:23 (11/03) 15:51:40 (09/02) 0 0
362905073 5766 1 +00000 00:00:00.4 13:00:37 (11/03) 15:51:40 (09/02) 0 0
362905073 5767 1 +00000 00:00:00.3 14:00:51 (11/03) 15:51:40 (09/02) 0 0
362905073 5768 1 +00000 00:00:00.3 15:00:04 (11/03) 15:51:40 (09/02) 0 0
362905073 5769 1 +00000 00:00:00.3 16:00:19 (11/03) 15:51:40 (09/02) 0 0
362905073 5770 1 +00000 00:00:00.4 17:00:34 (11/03) 15:51:40 (09/02) 0 0
362905073 5771 1 +00000 00:00:00.3 18:00:48 (11/03) 15:51:40 (09/02) 0 0
362905073 5772 1 +00000 00:00:00.3 19:00:02 (11/03) 15:51:40 (09/02) 0 0
362905073 5773 1 +00000 00:00:00.3 20:00:17 (11/03) 15:51:40 (09/02) 0 0
362905073 5774 1 +00000 00:00:00.3 21:00:31 (11/03) 15:51:40 (09/02) 0 0
362905073 5775 1 +00000 00:00:01.4 22:00:46 (11/03) 15:51:40 (09/02) 0 0
362905073 5776 1 +00000 00:00:00.5 23:00:00 (11/03) 15:51:40 (09/02) 0 0
362905073 5777 1 +00000 00:00:00.4 00:00:16 (11/04) 15:51:40 (09/02) 0 0
362905073 5778 1 +00000 00:00:00.6 01:00:31 (11/04) 15:51:40 (09/02) 0 0
362905073 5779 1 +00000 00:00:00.5 02:00:45 (11/04) 15:51:40 (09/02) 0 0
362905073 5780 1 +00000 00:00:00.4 03:00:59 (11/04) 15:51:40 (09/02) 0 0
362905073 5781 1 +00000 00:00:00.5 04:00:13 (11/04) 15:51:40 (09/02) 0 0
362905073 5782 1 +00000 00:00:00.4 05:00:27 (11/04) 15:51:40 (09/02) 0 0
362905073 5783 1 +00000 00:00:00.5 06:00:42 (11/04) 15:51:40 (09/02) 0 0
362905073 5784 1 +00000 00:00:00.4 07:00:56 (11/04) 15:51:40 (09/02) 0 0
362905073 5785 1 +00000 00:00:00.6 08:00:10 (11/04) 15:51:40 (09/02) 0 0
362905073 5786 1 +00000 00:00:00.3 09:00:25 (11/04) 15:51:40 (09/02) 0 0
362905073 5787 1 +00000 00:00:00.3 10:00:40 (11/04) 15:51:40 (09/02) 0 0
362905073 5788 1 +00000 00:00:00.3 11:00:54 (11/04) 15:51:40 (09/02) 0 0
362905073 5789 1 +00000 00:00:00.4 12:00:09 (11/04) 15:51:40 (09/02) 0 0
362905073 5790 1 +00000 00:00:00.5 13:00:23 (11/04) 15:51:40 (09/02) 0 0
362905073 5791 1 +00000 00:00:00.4 14:00:39 (11/04) 15:51:40 (09/02) 0 0
362905073 5792 1 +00000 00:00:00.3 15:00:53 (11/04) 15:51:40 (09/02) 0 0
362905073 5793 1 +00000 00:00:00.3 16:00:07 (11/04) 15:51:40 (09/02) 0 0
362905073 5794 1 +00000 00:00:00.3 17:00:22 (11/04) 15:51:40 (09/02) 0 0
362905073 5795 1 +00000 00:00:00.6 18:00:36 (11/04) 15:51:40 (09/02) 0 0
362905073 5796 1 +00000 00:00:00.3 19:00:50 (11/04) 15:51:40 (09/02) 0 0
362905073 5797 1 +00000 00:00:00.3 20:00:05 (11/04) 15:51:40 (09/02) 0 0
DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
362905073 5798 1 +00000 00:00:00.3 21:00:20 (11/04) 15:51:40 (09/02) 0 0
362905073 5799 1 +00000 00:00:01.8 22:00:35 (11/04) 15:51:40 (09/02) 0 0
362905073 5800 1 +00000 00:00:00.8 23:00:50 (11/04) 15:51:40 (09/02) 0 0
**********************************
(5b) AWR snapshots with errors or invalid
**********************************
no rows selected
**********************************
(5c) AWR snapshots -- OLDEST Non-Baselined snapshots
**********************************
DBID INST SNAP_ID ENDTM STATUS ERROR_COUNT
---------- ----- ---------- ----------------- ------ -----------
362905073 1 5586 01:00:55 (10/27) 0 0
**********************************
(6) AWR Control Settings - interval, retention
**********************************
DBID LSNAPID LSPLITID LSNAPTIME LPURGETIME FLAG INTERVAL RETENTION VRSN
----------- -------- -------- -------------- -------------- ----- ----------------- ----------------- ----
362905073 5800 5778 11/04 23:00:51 11/04 00:33:18 2 +00000 01:00:00.0 +00008 00:00:00.0 30
**********************************
(7a) AWR Contents - row counts for each snapshots
**********************************
SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
5751 1 2 98 295 0 83 138
5752 1 11 99 800 0 85 138
5753 1 1 87 246 0 85 138
5754 1 3 93 262 0 77 138
5755 1 1 88 288 0 85 138
5756 1 0 89 275 0 85 138
5757 1 2 93 276 0 82 138
5758 1 0 84 262 0 84 138
5759 1 1 81 236 0 84 138
5760 1 2 72 233 0 82 138
5761 1 1 72 232 0 84 138
5762 1 1 69 230 0 84 138
5763 1 1 85 284 0 79 138
5764 1 2 70 237 0 82 138
5765 1 0 87 248 0 83 138
5766 1 0 71 225 0 83 138
5767 1 4 70 231 0 83 138
5768 1 2 70 230 0 84 138
5769 1 1 86 245 0 80 138
5770 1 0 83 237 0 85 138
5771 1 1 71 207 0 81 138
5772 1 3 68 208 0 85 138
5773 1 3 69 211 0 85 138
5774 1 1 68 207 0 84 138
5775 1 6 100 363 0 86 138
5776 1 11 89 685 0 85 138
5777 1 1 91 309 0 86 138
5778 1 3 96 299 0 79 138
5779 1 0 85 263 0 85 138
5780 1 1 84 251 0 86 138
5781 1 2 91 287 0 83 138
5782 1 1 86 243 0 83 138
5783 1 2 81 273 0 83 138
5784 1 0 67 206 0 82 138
5785 1 4 66 216 0 82 138
5786 1 3 61 192 0 84 138
5787 1 1 74 257 0 84 138
5788 1 0 58 187 0 83 138
5789 1 0 77 209 0 83 138
5790 1 0 63 202 0 85 138
5791 1 2 61 200 0 82 138
5792 1 1 59 192 0 82 138
5793 1 0 80 233 0 86 138
5794 1 1 75 263 0 85 138
5795 1 1 63 189 0 83 138
5796 1 0 61 193 0 84 138
5797 1 4 59 189 0 85 138
SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
5798 1 0 60 188 0 84 138
5799 1 9 109 439 0 87 138
5800 1 8 94 713 0 85 138
**********************************
(7b) AWR Contents - average row counts per snapshot
**********************************
SNAP_COUNT INST ASH SQLSTAT SQLBIND FILES SEGSTAT SYSEVENT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
215 1 1.93 77.85 282.95 0 83.74 137.64
**********************************
(7c) AWR total item counts - names, text, plans
**********************************
SQLTEXT SQLPLAN SQLBMETA SEGOBJ DATAFILE TEMPFILE
---------- ---------- ---------- ---------- ---------- ----------
597 12310 2993 956 4 0
########################################################
(II) Advisor Framework Info
########################################################
**********************************
(1) Advisor Tasks - Last 50
**********************************
OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
SYS/SQL Tuning 1/SYS_AUTO_SQL_TUNING_TASK 18:31:21 (01/11) 4 ########## AUTO COMPLETED
SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 18:31:22 (01/11) AUTO INITIAL
SYS/SQL Access 5/SYS_AUTO_INDEX_TASK 18:31:22 (01/11) AUTO INITIAL
SYS/SQL Perfor 4/SYS_AI_VERIFY_TASK 18:31:22 (01/11) AUTO INITIAL
SYS/SPM Evolve 2/SYS_AUTO_SPM_EVOLVE_TASK 18:31:22 (01/11) 7 ########## AUTO COMPLETED
SYS/Statistics 12/INDIVIDUAL_STATS_ADVISOR_TASK 18:31:26 (01/11) CMD INITIAL
SYS/Statistics 11/AUTO_STATS_ADVISOR_TASK 18:31:26 (01/11) 33 ########## CMD COMPLETED
SYS/ADDM 6115/ADDM:362905073_1_5758 05:00:45 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6116/ADDM:362905073_1_5759 06:00:59 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6117/ADDM:362905073_1_5760 07:00:13 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6118/ADDM:362905073_1_5761 08:00:27 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6119/ADDM:362905073_1_5762 09:00:42 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6120/ADDM:362905073_1_5763 10:00:56 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6121/ADDM:362905073_1_5764 11:00:10 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6122/ADDM:362905073_1_5765 12:00:24 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6123/ADDM:362905073_1_5766 13:00:37 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6124/ADDM:362905073_1_5767 14:00:51 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6125/ADDM:362905073_1_5768 15:00:05 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6126/ADDM:362905073_1_5769 16:00:19 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6127/ADDM:362905073_1_5770 17:00:34 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6128/ADDM:362905073_1_5771 18:00:49 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6129/ADDM:362905073_1_5772 19:00:03 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6130/ADDM:362905073_1_5773 20:00:17 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6131/ADDM:362905073_1_5774 21:00:31 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6140/ADDM:362905073_1_5775 22:00:47 (11/03) 1 1 AUTO COMPLETED
SYS/ADDM 6141/ADDM:362905073_1_5776 23:00:01 (11/03) 0 0 AUTO COMPLETED
SYS/ADDM 6142/ADDM:362905073_1_5777 00:00:16 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6143/ADDM:362905073_1_5778 01:00:32 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6144/ADDM:362905073_1_5779 02:00:46 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6145/ADDM:362905073_1_5780 03:00:59 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6146/ADDM:362905073_1_5781 04:00:13 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6147/ADDM:362905073_1_5782 05:00:28 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6148/ADDM:362905073_1_5783 06:00:42 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6149/ADDM:362905073_1_5784 07:00:56 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6150/ADDM:362905073_1_5785 08:00:11 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6151/ADDM:362905073_1_5786 09:00:25 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6152/ADDM:362905073_1_5787 10:00:40 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6153/ADDM:362905073_1_5788 11:00:54 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6154/ADDM:362905073_1_5789 12:00:09 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6155/ADDM:362905073_1_5790 13:00:24 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6156/ADDM:362905073_1_5791 14:00:39 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6157/ADDM:362905073_1_5792 15:00:53 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6158/ADDM:362905073_1_5793 16:00:07 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6159/ADDM:362905073_1_5794 17:00:22 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6160/ADDM:362905073_1_5795 18:00:37 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6161/ADDM:362905073_1_5796 19:00:51 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6162/ADDM:362905073_1_5797 20:00:06 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6163/ADDM:362905073_1_5798 21:00:20 (11/04) 0 0 AUTO COMPLETED
SYS/ADDM 6164/ADDM:362905073_1_5799 22:00:37 (11/04) 1 1 AUTO COMPLETED
SYS/ADDM 6165/ADDM:362905073_1_5800 23:00:51 (11/04) 0 0 AUTO COMPLETED
**********************************
(2) Advisor Task - Oldest 5
**********************************
OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
SYS/ADDM 5333/ADDM:362905073_1_5061 04:00:31 (10/05) 0 0 AUTO COMPLETED
SYS/ADDM 5334/ADDM:362905073_1_5062 05:00:45 (10/05) 0 0 AUTO COMPLETED
SYS/ADDM 5335/ADDM:362905073_1_5063 06:00:58 (10/05) 0 0 AUTO COMPLETED
SYS/ADDM 5336/ADDM:362905073_1_5064 07:00:11 (10/05) 0 0 AUTO COMPLETED
SYS/ADDM 5337/ADDM:362905073_1_5065 08:00:24 (10/05) 1 1 AUTO COMPLETED
**********************************
(3) Advisor Tasks With Errors - Last 50
**********************************
OWNER/ADVISOR TASK_ID/NAME CREATED EXE_DURATN EXE_CREATN HOW_C STATUS
-------------- -------------------------------- ---------------- ---------- ---------- ----- ------------
TASK_DESC
--------------------------------------------------------------------------------------------------------------
ERROR_MSG
--------------------------------------------------------------------------------------------------------------
SYS/SPM Evolve 3/SYS_AI_SPM_EVOLVE_TASK 18:31:22 (01/11) AUTO INITIAL
Description: Automatic SPM Evolve Task
Error Msg :
SYS/SQL Perfor 4/SYS_AI_VERIFY_TASK 18:31:22 (01/11) AUTO INITIAL
Description:
Error Msg :
SYS/SQL Access 5/SYS_AUTO_INDEX_TASK 18:31:22 (01/11) AUTO INITIAL
Description:
Error Msg :
SYS/Statistics 12/INDIVIDUAL_STATS_ADVISOR_TASK 18:31:26 (01/11) CMD INITIAL
Description:
Error Msg :
########################################################
(III) ASH Usage Info
########################################################
**********************************
(1a) ASH histogram (past 3 days)
**********************************
NUM_ACTIVE_SESSIONS NUM_SAMPLES
-------------------- ------------
0000 - 0004 113
0005 - 0009 2
**********************************
(1b) ASH histogram (past 1 day)
**********************************
NUM_ACTIVE_SESSIONS NUM_SAMPLES
-------------------- ------------
0000 - 0004 36
0005 - 0009 1
**********************************
(2a) ASH details (past 3 days)
**********************************
INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
1 00:30:58 (11/02) 23:30:58 (11/04) 24,961 142 0.01
**********************************
(2b) ASH details (past 1 day)
**********************************
INST MIN_TIME MAX_TIME NUM_SAMPLES NUM_ROWS AVG_ACTIVE
---- ---------------- ---------------- ------------ ------------ ----------
1 00:13:44 (11/04) 23:30:58 (11/04) 8,187 45 0.01
**********************************
(2c) ASH sessions (Fg Vs Bg) (past 1 day across all instances in RAC)
**********************************
Foreground % 22.2
Background % 77.8
MMNL % 0.0
End of Report
|
리포트 수집 방법 및 AWR 관련 링크
오라클 19c AWR 란 ( https://positivemh.tistory.com/1013 )
오라클 19c AWR 리포트 수집 방법 ( https://positivemh.tistory.com/1012 )
오라클 19c ASH 리포트 수집 방법 ( https://positivemh.tistory.com/1011 )
오라클 19c AWR 비교 리포트 수집 방법 ( https://positivemh.tistory.com/1014 )
오라클 19c AWR 에 저장된 정보 확인(awrinfo.sql) ( https://positivemh.tistory.com/780 )
오라클 19c AWR 데이터 export 방법 ( https://positivemh.tistory.com/836 )
오라클 무료 모니터링 툴 ASH Viewer 설치 가이드 ( https://positivemh.tistory.com/966 )
'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c ahf(tfa) 업그레이드 가이드 (0) | 2021.12.25 |
|---|---|
| 오라클 11g R2 서버 기동시 db 자동실행 설정 (0) | 2021.11.13 |
| 오라클 19c 무료 클라이언트, 모니터링 툴 (0) | 2021.11.03 |
| 오라클 19c 윈도우 환경에서 아카이브 로그 정리 방법(archive log) (0) | 2021.10.27 |
| 오라클 19c 윈도우 환경에서 ahf(tfa) 설치 및 로그수집 가이드(SRDC) (0) | 2021.10.20 |