NON_AWR 0.6 SYSMAN.PK_MGMT_JOB_STEP_PARAMS INDEX
NON_AWR 0.6 SYS.WRI$_ADV_PARAMETERS_PK INDEX
NON_AWR 0.5 SYS.AW_OBJ$ TABLE
NON_AWR 0.5 APEX_030200.WWV_FLOW_LIST_OF_VALUES_DATA TABLE
NON_AWR 0.5 SYSMAN.SYS_LOB0000067821C00004$$ LOBSEGMENT
**********************************
(5a) AWR snapshots - last 50
**********************************
Total snapshots in DB 239394037 Instance 1 = 23
DBID SNAP_ID INST FLUSH_ELAPSED ENDTM STARTUP_TIME STATUS ERRCNT
---------- ---------- ----- -------------------- ----------------- ----------------- ------ ------
239394037 544 1 +00000 00:00:04.2 08:00:21 (11/25) 06:25:05 (11/21) 0 0
239394037 545 1 +00000 00:00:04.2 09:00:31 (11/25) 06:25:05 (11/21) 0 0
239394037 546 1 +00000 00:00:04.4 10:00:42 (11/25) 06:25:05 (11/21) 0 0
239394037 547 1 +00000 00:00:18.4 00:50:45 (11/26) 00:39:23 (11/26) 0 0
239394037 548 1 +00000 00:00:05.5 02:00:52 (11/26) 00:39:23 (11/26) 0 0
239394037 549 1 +00000 00:00:04.7 03:00:57 (11/26) 00:39:23 (11/26) 0 0
239394037 550 1 +00000 00:00:03.9 04:00:02 (11/26) 00:39:23 (11/26) 0 0
239394037 551 1 +00000 00:00:04.9 05:00:30 (11/26) 00:39:23 (11/26) 0 0
239394037 552 1 +00000 00:00:04.7 06:00:33 (11/26) 00:39:23 (11/26) 0 0
239394037 553 1 +00000 00:00:05.5 07:00:40 (11/26) 00:39:23 (11/26) 0 0
239394037 554 1 +00000 00:00:04.6 08:00:45 (11/26) 00:39:23 (11/26) 0 0
239394037 555 1 +00000 00:00:04.3 09:00:51 (11/26) 00:39:23 (11/26) 0 0
239394037 556 1 +00000 00:00:06.5 04:28:55 (11/29) 00:39:23 (11/26) 0 0
239394037 557 1 +00000 00:00:09.4 05:00:01 (11/29) 00:39:23 (11/26) 0 0
239394037 558 1 +00000 00:00:04.3 06:00:07 (11/29) 00:39:23 (11/26) 0 0
239394037 559 1 +00000 00:00:03.1 07:00:11 (11/29) 00:39:23 (11/26) 0 0
239394037 560 1 +00000 00:00:02.5 08:00:15 (11/29) 00:39:23 (11/26) 0 0
239394037 561 1 +00000 00:00:02.8 09:00:19 (11/29) 00:39:23 (11/26) 0 0
239394037 562 1 +00000 00:01:01.1 22:41:06 (12/01) 00:39:23 (11/26) 0 0
239394037 563 1 +00000 00:00:22.1 07:10:16 (12/03) 00:39:23 (11/26) 0 0
239394037 564 1 +00000 00:00:06.1 08:00:23 (12/03) 00:39:23 (11/26) 0 0
239394037 565 1 +00000 00:00:20.7 09:00:57 (12/03) 08:17:27 (12/03) 0 0
239394037 566 1 +00000 00:00:12.2 06:49:54 (12/04) 08:17:27 (12/03) 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
---------- ----- ---------- ----------------- ------ -----------
239394037 1 544 08:00:21 (11/25) 0 0
**********************************
(6) AWR Control Settings - interval, retention
**********************************
DBID LSNAPID LSPLITID LSNAPTIME LPURGETIME FLAG INTERVAL RETENTION VRSN
----------- -------- -------- -------------- -------------- ----- ----------------- ----------------- ----
239394037 566 556 12/04 06:50:07 12/03 07:32:00 2 +00000 01:00:00.0 +00008 00:00:00.0 4
**********************************
(7a) AWR Contents - row counts for each snapshots
**********************************
SNAP_ID INST ASH SQL SQBND FILES SEGST SYSEVT
---------- ----- ---------- ---------- ---------- ---------- ---------- ----------
544 1 6 193 586 7 173 92
545 1 13 203 620 7 173 92
546 1 34 295 886 7 195 95
547 1 120 316 864 7 121 75
548 1 16 194 589 7 130 82
549 1 10 194 594 7 125 82
550 1 3 182 592 7 122 82
551 1 6 178 566 7 120 82
552 1 5 210 572 7 133 82
553 1 1