查看最近一段时间的db_time走向
old: WITH sysstat
AS (
SELECT ss.instance_number inst_id,
sn.begin_interval_time begin_interval_time,
sn.end_interval_time end_interval_time,
ss.stat_name stat_name,
ss.VALUE e_value,
LAG(ss.VALUE) OVER(partition by ss.instance_number ORDER BY ss.snap_id) b_value
FROM dba_hist_sys_time_model ss, dba_hist_snapshot sn
WHERE sn.begin_interval_time >= SYSDATE - &date
AND ss.snap_id = sn.snap_id
AND ss.dbid = sn.dbid
AND ss.instance_number = sn.instance_number
AND ss.dbid = (SELECT dbid FROM v$database)
and ss.stat_name = 'DB time'
and ss.instance_number in (select instance_number from v$instance)
)
select inst_id,
begin_interval_time,
end_interval_time,
stat_name,
round((e_value - b_value)/1000/1000/60) value_min
from sysstat
order by 2 , 3
new: WITH sysstat
AS (
SELECT ss.instance_number inst_id,
sn.begin_interval_time begin_interval_time,
sn.end_interval_time end_interval_time,
ss.stat_name stat_name,
ss.VALUE e_value,
LAG(ss.VALUE) OVER(partition by ss.instance_number ORDER BY ss.snap_id) b_value
FROM dba_hist_sys_time_model ss, dba_hist_snapshot sn
WHERE sn.begin_interval_time >= SYSDATE - 10
AND ss.snap_id = sn.snap_id
AND ss.dbid = sn.dbid
AND ss.instance_number = sn.instance_number
AND ss.dbid = (SELECT dbid FROM v$database)
and ss.stat_name = 'DB time'
and ss.instance_number in (select instance_number from v$instance)
)
select inst_id,
begin_interval_time,
end_interval_time,
stat_name,
round((e_value - b_value)/1000/1000/60) value_min
from sysstat
order by 2 , 3
INST_ID BEGIN_INTERVAL_TIME END_INTERVAL_TIME STAT_NAME VALUE_MIN
---------- ------------------------------ ------------------------------ -------------------- ----------
1 2022/7/10 18:30:18.316 2022/7/10 19:00:25.593 DB time
1 2022/7/10 19:00:25.593 2022/7/10 19:30:51.198 DB time 115
1 2022/7/10 19:30:51.198 2022/7/10 20:00:08.253 DB time 93
1 2022/7/10 20:00:08.253 2022/7/10 20:30:25.262 DB time 104
1 2022/7/10 20:30:25.262 2022/7/10 21:00:27.681 DB time 96
1 2022/7/10 21:00:27.681 2022/7/10 21:30:58.738 DB time 99
1 2022/7/10 21:30:58.738 2022/7/10 22:00:16.294 DB time 87
1 2022/7/10 22:00:16.294 2022/7/10 22:30:32.948 DB time 106
1 2022/7/10 22:30:32.948 2022/7/10 23:00:29.523 DB time 95
1 2022/7/10 23:00:29.523 2022/7/10 23:30:04.439 DB time 106
1 2022/7/10 23:30:04.439 2022/7/11 0:00:19.753 DB time 92
1 2022/7/11 0:00:19.753 2022/7/11 0:30:35.531 DB time 127
1 2022/7/11 0:30:35.531 2022/7/11 1:00:31.983 DB time 167
1 2022/7/11 1:00:31.983 2022/7/11 1:30:02.359 DB time 108
1 2022/7/11 1:30:02.359 2022/7/11 2:00:24.514 DB time 79
1 2022/7/11 2:00:24.514 2022/7/11 2:30:03.818 DB time 96
1 2022/7/11 2:30:03.818 2022/7/11 3:00:35.339 DB time 87
1 2022/7/11 3:00:35.339 2022/7/11 3:30:05.268 DB time 122
1 2022/7/11 3:30:05.268 2022/7/11 4:00:31.467 DB time 158
1 2022/7/11 4:00:31.467 2022/7/11 4:30:07.163 DB time 101
1 2022/7/11 4:30:07.163 2022/7/11 5:00:06.165 DB time 94
1 2022/7/11 5:00:06.165 2022/7/11 5:30:08.304 DB time 86
1 2022/7/11 5:30:08.304 2022/7/11 6:00:39.201 DB time 89
1 2022/7/11 6:00:39.201 2022/7/11 6:30:09.285 DB time 115
1 2022/7/11 6:30:09.285 2022/7/11 7:00:12.021 DB time 145
1 2022/7/11 7:00:12.021 2022/7/11 7:30:10.806 DB time 94
1 2022/7/11 7:30:10.806 2022/7/11 8:00:41.917 DB time 106
1 2022/7/11 8:00:41.917 2022/7/11 8:30:12.123 DB time 214
1 2022/7/11 8:30:12.123 2022/7/11 9:00:14.286 DB time 211
1 2022/7/11 9:00:14.286 2022/7/11 9:30:14.477 DB time 242
1 2022/7/11 9:30:14.477 2022/7/11 10:00:45.628 DB time 225
1 2022/7/11 10:00:45.628 2022/7/11 10:30:02.638 DB time 233
1 2022/7/11 10:30:02.638 2022/7/11 11:00:18.789 DB time 255
1 2022/7/11 11:00:18.789 2022/7/11 11:30:17.003 DB time 199
1 2022/7/11 11:30:17.003 2022/7/11 12:00:48.142 DB time 160
1 2022/7/11 12:00:48.142 2022/7/11 12:30:08.532 DB time 273
1 2022/7/11 12:30:08.532 2022/7/11 13:00:24.263 DB time 347
1 2022/7/11 13:00:24.263 2022/7/11 13:30:19.757 DB time 309
1 2022/7/11 13:30:19.757 2022/7/11 14:00:50.536 DB time 235
1 2022/7/11 14:00:50.536 2022/7/11 14:30:15.574 DB time 272
1 2022/7/11 14:30:15.574 2022/7/11 15:00:31.924 DB time 241
1 2022/7/11 15:00:31.924 2022/7/11 15:30:21.822 DB time 333
1 2022/7/11 15:30:21.822 2022/7/11 16:00:05.116 DB time 307
1 2022/7/11 16:00:05.116 2022/7/11 16:30:22.624 DB time 374
1 2022/7/11 16:30:22.624 2022/7/11 17:00:39.236 DB time 220
1 2022/7/11 17:00:39.236 2022/7/11 17:30:25.912 DB time 154
1 2022/7/11 17:30:25.912 2022/7/11 18:00:10.725 DB time 236
1 2022/7/11 18:00:10.725 2022/7/11 18:30:26.246 DB time 319
1 2022/7/11 18:30:26.246 2022/7/11 19:00:42.316 DB time 263
1 2022/7/11 19:00:42.316 2022/7/11 19:30:30.863 DB time 249
1 2022/7/11 19:30:30.863 2022/7/11 20:00:01.109 DB time 193
1 2022/7/11 20:00:01.109 2022/7/11 20:30:32.395 DB time 215
1 2022/7/11 20:30:32.395 2022/7/11 21:00:03.488 DB time 171
1 2022/7/11 21:00:03.488 2022/7/11 21:30:04.924 DB time 206
1 2022/7/11 21:30:04.924 2022/7/11 22:00:04.367 DB time 369
1 2022/7/11 22:00:04.367 2022/7/11 22:30:36.232 DB time 561
1 2022/7/11 22:30:36.232 2022/7/11 23:00:06.152 DB time 163
1 2022/7/11 23:00:06.152 2022/7/11 23:30:07.203 DB time 177
1 2022/7/11 23:30:07.203 2022/7/12 0:00:08.537 DB time 159
1 2022/7/12 0:00:08.537 2022/7/12 0:30:39.489 DB time 166
1 2022/7/12 0:30:39.489 2022/7/12 1:00:09.887 DB time 175
1 2022/7/12 1:00:09.887 2022/7/12 1:30:15.224 DB time 193
1 2022/7/12 1:30:15.224 2022/7/12 2:00:12.368 DB time 187
1 2022/7/12 2:00:12.368 2022/7/12 2:30:43.485 DB time 174
1 2022/7/12 2:30:43.485 2022/7/12 3:00:06.245 DB time 152
1 2022/7/12 3:00:06.245 2022/7/12 3:30:22.650 DB time 170
1 2022/7/12 3:30:22.650 2022/7/12 4:00:15.252 DB time 213
1 2022/7/12 4:00:15.252 2022/7/12 4:30:46.672 DB time 174
1 2022/7/12 4:30:46.672 2022/7/12 5:00:12.276 DB time 153
1 2022/7/12 5:00:12.276 2022/7/12 5:30:29.151 DB time 168
1 2022/7/12 5:30:29.151 2022/7/12 6:00:18.173 DB time 153
1 2022/7/12 6:00:18.173 2022/7/12 6:30:49.040 DB time 176
1 2022/7/12 6:30:49.040 2022/7/12 7:00:15.797 DB time 290
1 2022/7/12 7:00:15.797 2022/7/12 7:30:32.158 DB time 110
1 2022/7/12 7:30:32.158 2022/7/12 8:00:20.616 DB time 100
1 2022/7/12 8:00:20.616 2022/7/12 8:30:05.395 DB time 189
1 2022/7/12 8:30:05.395 2022/7/12 9:00:21.436 DB time 194
1 2022/7/12 9:00:21.436 2022/7/12 9:30:37.602 DB time 282
1 2022/7/12 9:30:37.602 2022/7/12 10:00:24.223 DB time 248
1 2022/7/12 10:00:24.223 2022/7/12 10:30:10.793 DB time 296
1 2022/7/12 10:30:10.793 2022/7/12 11:00:26.145 DB time 240
1 2022/7/12 11:00:26.145 2022/7/12 11:30:45.639 DB time 265
1 2022/7/12 11:30:45.639 2022/7/12 12:00:02.430 DB time 164
1 2022/7/12 12:00:02.430 2022/7/12 12:30:18.649 DB time 215
1 2022/7/12 12:30:18.649 2022/7/12 13:00:30.043 DB time 231
1 2022/7/12 13:00:30.043 2022/7/12 13:30:50.631 DB time 257
1 2022/7/12 13:30:50.631 2022/7/12 14:00:05.581 DB time 252
1 2022/7/12 14:00:05.581 2022/7/12 14:30:02.097 DB time 264
1 2022/7/12 14:30:02.097 2022/7/12 15:00:33.111 DB time 250
1 2022/7/12 15:00:33.111 2022/7/12 15:30:03.487 DB time 291
1 2022/7/12 15:30:03.487 2022/7/12 16:00:08.571 DB time 272
1 2022/7/12 16:00:08.571 2022/7/12 16:30:04.609 DB time 289
1 2022/7/12 16:30:04.609 2022/7/12 17:00:36.018 DB time 250
1 2022/7/12 17:00:36.018 2022/7/12 17:30:05.963 DB time 159
1 2022/7/12 17:30:05.963 2022/7/12 18:00:11.960 DB time 197
1 2022/7/12 18:00:11.960 2022/7/12 18:30:08.387 DB time 246
1 2022/7/12 18:30:08.387 2022/7/12 19:00:39.618 DB time 203
1 2022/7/12 19:00:39.618 2022/7/12 19:30:09.768 DB time 204
1 2022/7/12 19:30:09.768 2022/7/12 20:00:16.520 DB time 177
1 2022/7/12 20:00:16.520 2022/7/12 20:30:11.046 DB time 177
1 2022/7/12 20:30:11.046 2022/7/12 21:00:42.814 DB time 142
1 2022/7/12 21:00:42.814 2022/7/12 21:30:05.659 DB time 202
1 2022/7/12 21:30:05.659 2022/7/12 22:00:21.330 DB time 231
1 2022/7/12 22:00:21.330 2022/7/12 22:30:13.996 DB time 176
1 2022/7/12 22:30:13.996 2022/7/12 23:00:44.557 DB time 176
1 2022/7/12 23:00:44.557 2022/7/12 23:30:12.203 DB time 184
1 2022/7/12 23:30:12.203 2022/7/13 0:00:30.626 DB time 168
1 2022/7/13 0:00:30.626 2022/7/13 0:30:16.007 DB time 198
1 2022/7/13 0:30:16.007 2022/7/13 1:00:04.618 DB time 176
1 2022/7/13 1:00:04.618 2022/7/13 1:30:18.465 DB time 224
1 2022/7/13 1:30:18.465 2022/7/13 2:00:39.526 DB time 157
1 2022/7/13 2:00:39.526 2022/7/13 2:30:19.376 DB time 171
1 2022/7/13 2:30:19.376 2022/7/13 3:00:11.341 DB time 150
1 2022/7/13 3:00:11.341 2022/7/13 3:30:20.509 DB time 184
1 2022/7/13 3:30:20.509 2022/7/13 4:00:45.315 DB time 194
1 2022/7/13 4:00:45.315 2022/7/13 4:30:01.432 DB time 170
1 2022/7/13 4:30:01.432 2022/7/13 5:00:17.413 DB time 155
1 2022/7/13 5:00:17.413 2022/7/13 5:30:23.722 DB time 172
1 2022/7/13 5:30:23.722 2022/7/13 6:00:50.588 DB time 163
1 2022/7/13 6:00:50.588 2022/7/13 6:30:06.170 DB time 184
1 2022/7/13 6:30:06.170 2022/7/13 7:00:22.088 DB time 299
1 2022/7/13 7:00:22.088 2022/7/13 7:30:27.589 DB time 120
1 2022/7/13 7:30:27.589 2022/7/13 8:00:56.139 DB time 116
1 2022/7/13 8:00:56.139 2022/7/13 8:30:13.136 DB time 225
1 2022/7/13 8:30:13.136 2022/7/13 9:00:29.057 DB time 228
1 2022/7/13 9:00:29.057 2022/7/13 9:30:31.116 DB time 271
1 2022/7/13 9:30:31.116 2022/7/13 10:00:01.540 DB time 243
1 2022/7/13 10:00:01.540 2022/7/13 10:30:18.574 DB time 311
1 2022/7/13 10:30:18.574 2022/7/13 11:00:03.713 DB time 260
1 2022/7/13 11:00:03.713 2022/7/13 11:30:35.660 DB time 231
1 2022/7/13 11:30:35.660 2022/7/13 12:00:05.571 DB time 155
1 2022/7/13 12:00:05.571 2022/7/13 12:30:24.037 DB time 201
1 2022/7/13 12:30:24.037 2022/7/13 13:00:06.735 DB time 223
1 2022/7/13 13:00:06.735 2022/7/13 13:30:37.705 DB time 241
1 2022/7/13 13:30:37.705 2022/7/13 14:00:07.619 DB time 225
1 2022/7/13 14:00:07.619 2022/7/13 14:30:27.576 DB time 259
1 2022/7/13 14:30:27.576 2022/7/13 15:00:09.502 DB time 231
1 2022/7/13 15:00:09.502 2022/7/13 15:30:41.162 DB time 293
1 2022/7/13 15:30:41.162 2022/7/13 16:00:11.791 DB time 277
1 2022/7/13 16:00:11.791 2022/7/13 16:30:30.769 DB time 369
1 2022/7/13 16:30:30.769 2022/7/13 17:00:13.389 DB time 199
1 2022/7/13 17:00:13.389 2022/7/13 17:30:03.588 DB time 135
1 2022/7/13 17:30:03.588 2022/7/13 18:00:14.616 DB time 186
1 2022/7/13 18:00:14.616 2022/7/13 18:30:37.167 DB time 248
1 2022/7/13 18:30:37.167 2022/7/13 19:00:15.157 DB time 267
1 2022/7/13 19:00:15.157 2022/7/13 19:30:09.787 DB time 201
1 2022/7/13 19:30:09.787 2022/7/13 20:00:17.030 DB time 197
1 2022/7/13 20:00:17.030 2022/7/13 20:30:43.154 DB time 204
1 2022/7/13 20:30:43.154 2022/7/13 21:00:18.529 DB time 191
1 2022/7/13 21:00:18.529 2022/7/13 21:30:16.836 DB time 210
1 2022/7/13 21:30:16.836 2022/7/13 22:00:19.871 DB time 234
1 2022/7/13 22:00:19.871 2022/7/13 22:30:50.350 DB time 190
1 2022/7/13 22:30:50.350 2022/7/13 23:00:07.131 DB time 156
1 2022/7/13 23:00:07.131 2022/7/13 23:30:24.431 DB time 186
1 2022/7/13 23:30:24.431 2022/7/14 0:00:22.240 DB time 146
1 2022/7/14 0:00:22.240 2022/7/14 0:30:53.485 DB time 157
1 2022/7/14 0:30:53.485 2022/7/14 1:00:12.533 DB time 151
1 2022/7/14 1:00:12.533 2022/7/14 1:30:28.217 DB time 250
1 2022/7/14 1:30:28.217 2022/7/14 2:00:25.291 DB time 145
1 2022/7/14 2:00:25.291 2022/7/14 2:30:02.728 DB time 162
1 2022/7/14 2:30:02.728 2022/7/14 3:00:20.919 DB time 147
1 2022/7/14 3:00:20.919 2022/7/14 3:30:38.296 DB time 181
1 2022/7/14 3:30:38.296 2022/7/14 4:00:27.369 DB time 222
1 2022/7/14 4:00:27.369 2022/7/14 4:30:10.125 DB time 162
1 2022/7/14 4:30:10.125 2022/7/14 5:00:26.308 DB time 167
1 2022/7/14 5:00:26.308 2022/7/14 5:30:42.008 DB time 172
1 2022/7/14 5:30:42.008 2022/7/14 6:00:29.025 DB time 146
1 2022/7/14 6:00:29.025 2022/7/14 6:30:14.321 DB time 153
1 2022/7/14 6:30:14.321 2022/7/14 7:00:30.510 DB time 288
1 2022/7/14 7:00:30.510 2022/7/14 7:30:00.778 DB time 143
1 2022/7/14 7:30:00.778 2022/7/14 8:00:07.037 DB time 163
1 2022/7/14 8:00:07.037 2022/7/14 8:30:01.679 DB time 262
1 2022/7/14 8:30:01.679 2022/7/14 9:00:33.470 DB time 273
1 2022/7/14 9:00:33.470 2022/7/14 9:30:03.972 DB time 289
1 2022/7/14 9:30:03.972 2022/7/14 10:00:13.431 DB time 267
1 2022/7/14 10:00:13.431 2022/7/14 10:30:04.493 DB time 284
1 2022/7/14 10:30:04.493 2022/7/14 11:00:35.567 DB time 225
1 2022/7/14 11:00:35.567 2022/7/14 11:30:01.232 DB time 154
1 2022/7/14 11:30:01.232 2022/7/14 12:00:17.329 DB time 56
1 2022/7/14 12:00:17.329 2022/7/14 12:30:07.901 DB time 83
1 2022/7/14 12:30:07.901 2022/7/14 13:00:38.994 DB time 129
1 2022/7/14 13:00:38.994 2022/7/14 13:30:03.845 DB time 139
1 2022/7/14 13:30:03.845 2022/7/14 14:00:19.401 DB time 137
1 2022/7/14 14:00:19.401 2022/7/14 14:30:12.534 DB time 141
1 2022/7/14 14:30:12.534 2022/7/14 15:00:44.375 DB time 131
1 2022/7/14 15:00:44.375 2022/7/14 15:30:05.865 DB time 143
1 2022/7/14 15:30:05.865 2022/7/14 16:00:23.403 DB time 176
1 2022/7/14 16:00:23.403 2022/7/14 16:30:14.934 DB time 147
1 2022/7/14 16:30:14.934 2022/7/14 17:00:47.003 DB time 111
1 2022/7/14 17:00:47.003 2022/7/14 17:30:12.191 DB time 47
1 2022/7/14 17:30:12.191 2022/7/14 18:00:29.832 DB time 95
1 2022/7/14 18:00:29.832 2022/7/14 18:30:19.290 DB time 135
1 2022/7/14 18:30:19.290 2022/7/14 19:00:01.861 DB time 184
1 2022/7/14 19:00:01.861 2022/7/14 19:30:17.738 DB time 138
1 2022/7/14 19:30:17.738 2022/7/14 20:00:34.251 DB time 87
1 2022/7/14 20:00:34.251 2022/7/14 20:30:22.663 DB time 69
1 2022/7/14 20:30:22.663 2022/7/14 21:00:07.699 DB time 61
1 2022/7/14 21:00:07.699 2022/7/14 21:30:25.438 DB time 92
1 2022/7/14 21:30:25.438 2022/7/14 22:00:41.890 DB time 93
1 2022/7/14 22:00:41.890 2022/7/14 22:30:27.546 DB time 91
1 2022/7/14 22:30:27.546 2022/7/14 23:00:15.603 DB time 89
1 2022/7/14 23:00:15.603 2022/7/14 23:30:28.593 DB time 86
1 2022/7/14 23:30:28.593 2022/7/15 0:00:47.218 DB time 77
1 2022/7/15 0:00:47.218 2022/7/15 0:30:02.567 DB time 144
1 2022/7/15 0:30:02.567 2022/7/15 1:00:01.125 DB time 189
1 2022/7/15 1:00:01.125 2022/7/15 1:30:32.166 DB time 270
1 2022/7/15 1:30:32.166 2022/7/15 2:00:02.012 DB time 231
1 2022/7/15 2:00:02.012 2022/7/15 2:30:06.824 DB time 197
1 2022/7/15 2:30:06.824 2022/7/15 3:00:03.127 DB time 159
1 2022/7/15 3:00:03.127 2022/7/15 3:30:33.979 DB time 210
1 2022/7/15 3:30:33.979 2022/7/15 4:00:04.424 DB time 234
1 2022/7/15 4:00:04.424 2022/7/15 4:30:09.792 DB time 187
1 2022/7/15 4:30:09.792 2022/7/15 5:00:05.288 DB time 163
1 2022/7/15 5:00:05.288 2022/7/15 5:30:36.241 DB time 186
1 2022/7/15 5:30:36.241 2022/7/15 6:00:06.431 DB time 167
1 2022/7/15 6:00:06.431 2022/7/15 6:30:13.926 DB time 174
1 2022/7/15 6:30:13.926 2022/7/15 7:00:07.492 DB time 315
1 2022/7/15 7:00:07.492 2022/7/15 7:30:38.701 DB time 139
1 2022/7/15 7:30:38.701 2022/7/15 8:00:03.075 DB time 123
1 2022/7/15 8:00:03.075 2022/7/15 8:30:19.514 DB time 269
1 2022/7/15 8:30:19.514 2022/7/15 9:00:10.589 DB time 219
1 2022/7/15 9:00:10.589 2022/7/15 9:30:41.780 DB time 272
1 2022/7/15 9:30:41.780 2022/7/15 10:00:08.042 DB time 261
1 2022/7/15 10:00:08.042 2022/7/15 10:30:24.019 DB time 309
1 2022/7/15 10:30:24.019 2022/7/15 11:00:13.829 DB time 258
1 2022/7/15 11:00:13.829 2022/7/15 11:30:46.358 DB time 321
1 2022/7/15 11:30:46.358 2022/7/15 12:00:11.200 DB time 130
1 2022/7/15 12:00:11.200 2022/7/15 12:30:27.074 DB time 220
1 2022/7/15 12:30:27.074 2022/7/15 13:00:18.925 DB time 245
1 2022/7/15 13:00:18.925 2022/7/15 13:30:50.211 DB time 266
1 2022/7/15 13:30:50.211 2022/7/15 14:00:14.476 DB time 242
1 2022/7/15 14:00:14.476 2022/7/15 14:30:30.506 DB time 293
1 2022/7/15 14:30:30.506 2022/7/15 15:00:22.833 DB time 249
1 2022/7/15 15:00:22.833 2022/7/15 15:30:04.312 DB time 313
1 2022/7/15 15:30:04.312 2022/7/15 16:00:20.900 DB time 310
1 2022/7/15 16:00:20.900 2022/7/15 16:30:36.639 DB time 328
1 2022/7/15 16:30:36.639 2022/7/15 17:00:25.575 DB time 192
1 2022/7/15 17:00:25.575 2022/7/15 17:30:08.536 DB time 156
1 2022/7/15 17:30:08.536 2022/7/15 18:00:24.949 DB time 179
1 2022/7/15 18:00:24.949 2022/7/15 18:30:41.401 DB time 207
1 2022/7/15 18:30:41.401 2022/7/15 19:00:27.896 DB time 215
1 2022/7/15 19:00:27.896 2022/7/15 19:30:13.783 DB time 234
1 2022/7/15 19:30:13.783 2022/7/15 20:00:29.169 DB time 189
1 2022/7/15 20:00:29.169 2022/7/15 20:30:45.654 DB time 188
1 2022/7/15 20:30:45.654 2022/7/15 21:00:30.766 DB time 172
1 2022/7/15 21:00:30.766 2022/7/15 21:30:00.704 DB time 187
1 2022/7/15 21:30:00.704 2022/7/15 22:00:32.168 DB time 197
1 2022/7/15 22:00:32.168 2022/7/15 22:30:02.097 DB time 156
1 2022/7/15 22:30:02.097 2022/7/15 23:00:04.373 DB time 130
1 2022/7/15 23:00:04.373 2022/7/15 23:30:02.932 DB time 176
1 2022/7/15 23:30:02.932 2022/7/16 0:00:33.615 DB time 139
1 2022/7/16 0:00:33.615 2022/7/16 0:30:03.447 DB time 137
1 2022/7/16 0:30:03.447 2022/7/16 1:00:09.315 DB time 152
1 2022/7/16 1:00:09.315 2022/7/16 1:30:05.635 DB time 137
1 2022/7/16 1:30:05.635 2022/7/16 2:00:36.682 DB time 135
1 2022/7/16 2:00:36.682 2022/7/16 2:30:06.394 DB time 142
1 2022/7/16 2:30:06.394 2022/7/16 3:00:17.194 DB time 134
1 2022/7/16 3:00:17.194 2022/7/16 3:30:07.469 DB time 147
1 2022/7/16 3:30:07.469 2022/7/16 4:00:38.871 DB time 208
1 2022/7/16 4:00:38.871 2022/7/16 4:30:06.522 DB time 120
1 2022/7/16 4:30:06.522 2022/7/16 5:00:23.956 DB time 136
1 2022/7/16 5:00:23.956 2022/7/16 5:30:12.456 DB time 114
1 2022/7/16 5:30:12.456 2022/7/16 6:00:44.225 DB time 129
1 2022/7/16 6:00:44.225 2022/7/16 6:30:12.668 DB time 166
1 2022/7/16 6:30:12.668 2022/7/16 7:00:30.696 DB time 210
1 2022/7/16 7:00:30.696 2022/7/16 7:30:14.807 DB time 141
1 2022/7/16 7:30:14.807 2022/7/16 8:00:02.229 DB time 102
1 2022/7/16 8:00:02.229 2022/7/16 8:30:15.849 DB time 159
1 2022/7/16 8:30:15.849 2022/7/16 9:00:35.476 DB time 144
1 2022/7/16 9:00:35.476 2022/7/16 9:30:17.088 DB time 145
1 2022/7/16 9:30:17.088 2022/7/16 10:00:06.500 DB time 145
1 2022/7/16 10:00:06.500 2022/7/16 10:30:18.523 DB time 171
1 2022/7/16 10:30:18.523 2022/7/16 11:00:38.401 DB time 159
1 2022/7/16 11:00:38.401 2022/7/16 11:30:20.177 DB time 156
1 2022/7/16 11:30:20.177 2022/7/16 12:00:09.072 DB time 108
1 2022/7/16 12:00:09.072 2022/7/16 12:30:21.381 DB time 151
1 2022/7/16 12:30:21.381 2022/7/16 13:00:40.856 DB time 182
1 2022/7/16 13:00:40.856 2022/7/16 13:30:23.219 DB time 138
1 2022/7/16 13:30:23.219 2022/7/16 14:00:12.318 DB time 132
1 2022/7/16 14:00:12.318 2022/7/16 14:30:24.845 DB time 141
1 2022/7/16 14:30:24.845 2022/7/16 15:00:43.915 DB time 118
1 2022/7/16 15:00:43.915 2022/7/16 15:30:25.655 DB time 147
1 2022/7/16 15:30:25.655 2022/7/16 16:00:17.375 DB time 111
1 2022/7/16 16:00:17.375 2022/7/16 16:30:26.606 DB time 117
1 2022/7/16 16:30:26.606 2022/7/16 17:00:50.763 DB time 110
1 2022/7/16 17:00:50.763 2022/7/16 17:30:06.276 DB time 96
1 2022/7/16 17:30:06.276 2022/7/16 18:00:22.091 DB time 78
1 2022/7/16 18:00:22.091 2022/7/16 18:30:27.958 DB time 127
1 2022/7/16 18:30:27.958 2022/7/16 19:00:57.651 DB time 172
1 2022/7/16 19:00:57.651 2022/7/16 19:30:13.082 DB time 102
1 2022/7/16 19:30:13.082 2022/7/16 20:00:29.198 DB time 111
1 2022/7/16 20:00:29.198 2022/7/16 20:30:30.318 DB time 119
1 2022/7/16 20:30:30.318 2022/7/16 21:00:00.309 DB time 100
1 2022/7/16 21:00:00.309 2022/7/16 21:30:16.250 DB time 112
1 2022/7/16 21:30:16.250 2022/7/16 22:00:01.060 DB time 100
1 2022/7/16 22:00:01.060 2022/7/16 22:30:32.379 DB time 97
1 2022/7/16 22:30:32.379 2022/7/16 23:00:02.804 DB time 71
1 2022/7/16 23:00:02.804 2022/7/16 23:30:21.302 DB time 112
1 2022/7/16 23:30:21.302 2022/7/17 0:00:04.597 DB time 91
1 2022/7/17 0:00:04.597 2022/7/17 0:30:35.516 DB time 116
1 2022/7/17 0:30:35.516 2022/7/17 1:00:06.173 DB time 167
1 2022/7/17 1:00:06.173 2022/7/17 1:30:26.072 DB time 128
1 2022/7/17 1:30:26.072 2022/7/17 2:00:07.073 DB time 112
1 2022/7/17 2:00:07.073 2022/7/17 2:30:37.796 DB time 105
1 2022/7/17 2:30:37.796 2022/7/17 3:00:07.755 DB time 98
1 2022/7/17 3:00:07.755 2022/7/17 3:30:30.423 DB time 111
1 2022/7/17 3:30:30.423 2022/7/17 4:00:09.016 DB time 96
1 2022/7/17 4:00:09.016 2022/7/17 4:30:02.852 DB time 95
1 2022/7/17 4:30:02.852 2022/7/17 5:00:09.287 DB time 105
1 2022/7/17 5:00:09.287 2022/7/17 5:30:34.570 DB time 90
1 2022/7/17 5:30:34.570 2022/7/17 6:00:10.494 DB time 76
1 2022/7/17 6:00:10.494 2022/7/17 6:30:08.362 DB time 163
1 2022/7/17 6:30:08.362 2022/7/17 7:00:11.489 DB time 166
1 2022/7/17 7:00:11.489 2022/7/17 7:30:40.999 DB time 121
1 2022/7/17 7:30:40.999 2022/7/17 8:00:12.670 DB time 106
1 2022/7/17 8:00:12.670 2022/7/17 8:30:12.431 DB time 151
1 2022/7/17 8:30:12.431 2022/7/17 9:00:14.347 DB time 123
1 2022/7/17 9:00:14.347 2022/7/17 9:30:44.838 DB time 170
1 2022/7/17 9:30:44.838 2022/7/17 10:00:15.367 DB time 141
1 2022/7/17 10:00:15.367 2022/7/17 10:30:17.126 DB time 167
1 2022/7/17 10:30:17.126 2022/7/17 11:00:16.667 DB time 172
1 2022/7/17 11:00:16.667 2022/7/17 11:30:47.421 DB time 170
1 2022/7/17 11:30:47.421 2022/7/17 12:00:05.962 DB time 122
1 2022/7/17 12:00:05.962 2022/7/17 12:30:21.872 DB time 193
1 2022/7/17 12:30:21.872 2022/7/17 13:00:20.093 DB time 227
1 2022/7/17 13:00:20.093 2022/7/17 13:30:51.504 DB time 193
1 2022/7/17 13:30:51.504 2022/7/17 14:00:12.440 DB time 178
1 2022/7/17 14:00:12.440 2022/7/17 14:30:28.861 DB time 190
1 2022/7/17 14:30:28.861 2022/7/17 15:00:23.769 DB time 164
1 2022/7/17 15:00:23.769 2022/7/17 15:30:04.288 DB time 185
1 2022/7/17 15:30:04.288 2022/7/17 16:00:21.406 DB time 169
1 2022/7/17 16:00:21.406 2022/7/17 16:30:37.468 DB time 205
1 2022/7/17 16:30:37.468 2022/7/17 17:00:26.672 DB time 145
1 2022/7/17 17:00:26.672 2022/7/17 17:30:10.246 DB time 310
1 2022/7/17 17:30:10.246 2022/7/17 18:00:26.607 DB time 122
1 2022/7/17 18:00:26.607 2022/7/17 18:30:45.336 DB time 156
1 2022/7/17 18:30:45.336 2022/7/17 19:00:02.474 DB time 181
1 2022/7/17 19:00:02.474 2022/7/17 19:30:19.973 DB time 146
1 2022/7/17 19:30:19.973 2022/7/17 20:00:30.961 DB time 111
1 2022/7/17 20:00:30.961 2022/7/17 20:30:00.916 DB time 119
1 2022/7/17 20:30:00.916 2022/7/17 21:00:09.105 DB time 85
1 2022/7/17 21:00:09.105 2022/7/17 21:30:03.000 DB time 96
1 2022/7/17 21:30:03.000 2022/7/17 22:00:33.909 DB time 84
1 2022/7/17 22:00:33.909 2022/7/17 22:30:04.141 DB time 103
1 2022/7/17 22:30:04.141 2022/7/17 23:00:15.420 DB time 91
1 2022/7/17 23:00:15.420 2022/7/17 23:30:05.212 DB time 94
1 2022/7/17 23:30:05.212 2022/7/18 0:00:36.116 DB time 89
1 2022/7/18 0:00:36.116 2022/7/18 0:30:05.871 DB time 124
1 2022/7/18 0:30:05.871 2022/7/18 1:00:22.548 DB time 161
1 2022/7/18 1:00:22.548 2022/7/18 1:30:07.355 DB time 90
1 2022/7/18 1:30:07.355 2022/7/18 2:00:38.232 DB time 85
1 2022/7/18 2:00:38.232 2022/7/18 2:30:08.617 DB time 91
1 2022/7/18 2:30:08.617 2022/7/18 3:00:27.142 DB time 73
1 2022/7/18 3:00:27.142 2022/7/18 3:30:11.082 DB time 85
1 2022/7/18 3:30:11.082 2022/7/18 4:00:00.919 DB time 66
1 2022/7/18 4:00:00.919 2022/7/18 4:30:12.054 DB time 91
1 2022/7/18 4:30:12.054 2022/7/18 5:00:33.777 DB time 82
1 2022/7/18 5:00:33.777 2022/7/18 5:30:14.006 DB time 92
1 2022/7/18 5:30:14.006 2022/7/18 6:00:05.490 DB time 82
1 2022/7/18 6:00:05.490 2022/7/18 6:30:14.827 DB time 110
1 2022/7/18 6:30:14.827 2022/7/18 7:00:37.259 DB time 135
1 2022/7/18 7:00:37.259 2022/7/18 7:30:15.838 DB time 76
1 2022/7/18 7:30:15.838 2022/7/18 8:00:08.612 DB time 81
1 2022/7/18 8:00:08.612 2022/7/18 8:30:16.990 DB time 162
1 2022/7/18 8:30:16.990 2022/7/18 9:00:42.070 DB time 173
1 2022/7/18 9:00:42.070 2022/7/18 9:30:18.829 DB time 200
1 2022/7/18 9:30:18.829 2022/7/18 10:00:12.349 DB time 165
1 2022/7/18 10:00:12.349 2022/7/18 10:30:20.703 DB time 176
1 2022/7/18 10:30:20.703 2022/7/18 11:00:44.864 DB time 207
1 2022/7/18 11:00:44.864 2022/7/18 11:30:21.828 DB time 174
1 2022/7/18 11:30:21.828 2022/7/18 12:00:16.150 DB time 146
1 2022/7/18 12:00:16.150 2022/7/18 12:30:23.304 DB time 229
1 2022/7/18 12:30:23.304 2022/7/18 13:00:49.238 DB time 258
1 2022/7/18 13:00:49.238 2022/7/18 13:30:07.222 DB time 292
1 2022/7/18 13:30:07.222 2022/7/18 14:00:24.490 DB time 246
1 2022/7/18 14:00:24.490 2022/7/18 14:30:26.158 DB time 265
1 2022/7/18 14:30:26.158 2022/7/18 15:00:57.368 DB time 265
1 2022/7/18 15:00:57.368 2022/7/18 15:30:17.710 DB time 293
1 2022/7/18 15:30:17.710 2022/7/18 16:00:33.857 DB time 284
1 2022/7/18 16:00:33.857 2022/7/18 16:30:29.228 DB time 327
1 2022/7/18 16:30:29.228 2022/7/18 17:00:05.476 DB time 233
1 2022/7/18 17:00:05.476 2022/7/18 17:30:21.289 DB time 223
1 2022/7/18 17:30:21.289 2022/7/18 18:00:36.964 DB time 250
1 2022/7/18 18:00:36.964 2022/7/18 18:30:32.211 DB time 309
1 2022/7/18 18:30:32.211 2022/7/18 19:00:02.141 DB time 274
1 2022/7/18 19:00:02.141 2022/7/18 19:30:29.241 DB time 271
1 2022/7/18 19:30:29.241 2022/7/18 20:00:03.914 DB time 302
1 2022/7/18 20:00:03.914 2022/7/18 20:30:01.987 DB time 195
1 2022/7/18 20:30:01.987 2022/7/18 21:00:05.577 DB time 197
1 2022/7/18 21:00:05.577 2022/7/18 21:30:34.645 DB time 199
1 2022/7/18 21:30:34.645 2022/7/18 22:00:07.364 DB time 166
1 2022/7/18 22:00:07.364 2022/7/18 22:30:06.427 DB time 72
1 2022/7/18 22:30:06.427 2022/7/18 23:00:08.470 DB time 62
1 2022/7/18 23:00:08.470 2022/7/18 23:30:37.804 DB time 75
1 2022/7/18 23:30:37.804 2022/7/19 0:00:09.418 DB time 35
1 2022/7/19 0:00:09.418 2022/7/19 0:30:10.210 DB time 67
1 2022/7/19 0:30:10.210 2022/7/19 1:00:10.728 DB time 145
1 2022/7/19 1:00:10.728 2022/7/19 1:30:41.647 DB time 69
1 2022/7/19 1:30:41.647 2022/7/19 2:00:11.511 DB time 60
1 2022/7/19 2:00:11.511 2022/7/19 2:30:12.890 DB time 61
1 2022/7/19 2:30:12.890 2022/7/19 3:00:13.058 DB time 66
1 2022/7/19 3:00:13.058 2022/7/19 3:30:44.053 DB time 49
1 2022/7/19 3:30:44.053 2022/7/19 4:00:00.386 DB time 71
1 2022/7/19 4:00:00.386 2022/7/19 4:30:17.252 DB time 60
1 2022/7/19 4:30:17.252 2022/7/19 5:00:14.715 DB time 66
1 2022/7/19 5:00:14.715 2022/7/19 5:30:45.664 DB time 61
1 2022/7/19 5:30:45.664 2022/7/19 6:00:05.207 DB time 60
1 2022/7/19 6:00:05.207 2022/7/19 6:30:21.013 DB time 61
1 2022/7/19 6:30:21.013 2022/7/19 7:00:17.408 DB time 95
1 2022/7/19 7:00:17.408 2022/7/19 7:30:49.331 DB time 126
1 2022/7/19 7:30:49.331 2022/7/19 8:00:07.462 DB time 113
1 2022/7/19 8:00:07.462 2022/7/19 8:30:23.505 DB time 241
1 2022/7/19 8:30:23.505 2022/7/19 9:00:22.741 DB time 170
1 2022/7/19 9:00:22.741 2022/7/19 9:30:53.724 DB time 152
1 2022/7/19 9:30:53.724 2022/7/19 10:00:14.514 DB time 129
1 2022/7/19 10:00:14.514 2022/7/19 10:30:32.711 DB time 118
1 2022/7/19 10:30:32.711 2022/7/19 11:00:24.925 DB time 144
1 2022/7/19 11:00:24.925 2022/7/19 11:30:09.148 DB time 127
1 2022/7/19 11:30:09.148 2022/7/19 12:00:26.821 DB time 54
1 2022/7/19 12:00:26.821 2022/7/19 12:30:45.040 DB time 64
1 2022/7/19 12:30:45.040 2022/7/19 13:00:04.051 DB time 117
1 2022/7/19 13:00:04.051 2022/7/19 13:30:23.258 DB time 130
1 2022/7/19 13:30:23.258 2022/7/19 14:00:29.894 DB time 133
1 2022/7/19 14:00:29.894 2022/7/19 14:30:01.128 DB time 141
1 2022/7/19 14:30:01.128 2022/7/19 15:00:17.465 DB time 111
1 2022/7/19 15:00:17.465 2022/7/19 15:30:03.275 DB time 176
1 2022/7/19 15:30:03.275 2022/7/19 16:00:34.330 DB time 177
1 2022/7/19 16:00:34.330 2022/7/19 16:30:04.574 DB time 187
1 2022/7/19 16:30:04.574 2022/7/19 17:00:22.850 DB time 121
1 2022/7/19 17:00:22.850 2022/7/19 17:30:06.684 DB time 79
1 2022/7/19 17:30:06.684 2022/7/19 18:00:37.833 DB time 117
1 2022/7/19 18:00:37.833 2022/7/19 18:30:08.289 DB time 133
1 2022/7/19 18:30:08.289 2022/7/19 19:00:29.959 DB time 138
1 2022/7/19 19:00:29.959 2022/7/19 19:30:09.630 DB time 113
1 2022/7/19 19:30:09.630 2022/7/19 20:00:03.915 DB time 106
1 2022/7/19 20:00:03.915 2022/7/19 20:30:12.142 DB time 88
1 2022/7/19 20:30:12.142 2022/7/19 21:00:37.404 DB time 106
1 2022/7/19 21:00:37.404 2022/7/19 21:30:14.168 DB time 93
1 2022/7/19 21:30:14.168 2022/7/19 22:00:09.686 DB time 141
1 2022/7/19 22:00:09.686 2022/7/19 22:30:16.440 DB time 76
1 2022/7/19 22:30:16.440 2022/7/19 23:00:44.421 DB time 84
1 2022/7/19 23:00:44.421 2022/7/19 23:30:02.063 DB time 61
1 2022/7/19 23:30:02.063 2022/7/20 0:00:18.025 DB time 61
1 2022/7/20 0:00:18.025 2022/7/20 0:30:20.823 DB time 43
1 2022/7/20 0:30:20.823 2022/7/20 1:00:51.834 DB time 70
1 2022/7/20 1:00:51.834 2022/7/20 1:30:09.288 DB time 85
1 2022/7/20 1:30:09.288 2022/7/20 2:00:28.235 DB time 66
1 2022/7/20 2:00:28.235 2022/7/20 2:30:23.933 DB time 63
1 2022/7/20 2:30:23.933 2022/7/20 3:00:04.577 DB time 89
1 2022/7/20 3:00:04.577 2022/7/20 3:30:21.530 DB time 117
1 2022/7/20 3:30:21.530 2022/7/20 4:00:37.666 DB time 155
1 2022/7/20 4:00:37.666 2022/7/20 4:30:28.380 DB time 90
1 2022/7/20 4:30:28.380 2022/7/20 5:00:09.121 DB time 94
1 2022/7/20 5:00:09.121 2022/7/20 5:30:25.430 DB time 73
1 2022/7/20 5:30:25.430 2022/7/20 6:00:00.702 DB time 72
1 2022/7/20 6:00:00.702 2022/7/20 6:30:31.662 DB time 91
1 2022/7/20 6:30:31.662 2022/7/20 7:00:02.277 DB time 80
1 2022/7/20 7:00:02.277 2022/7/20 7:30:30.211 DB time 63
1 2022/7/20 7:30:30.211 2022/7/20 8:00:04.392 DB time 77
1 2022/7/20 8:00:04.392 2022/7/20 8:30:01.227 DB time 156
1 2022/7/20 8:30:01.227 2022/7/20 9:00:06.327 DB time 138
1 2022/7/20 9:00:06.327 2022/7/20 9:30:34.505 DB time 184
1 2022/7/20 9:30:34.505 2022/7/20 10:00:07.684 DB time 209
1 2022/7/20 10:00:07.684 2022/7/20 10:30:07.731 DB time 241
1 2022/7/20 10:30:07.731 2022/7/20 11:00:08.553 DB time 179
1 2022/7/20 11:00:08.553 2022/7/20 11:30:39.315 DB time 194
1 2022/7/20 11:30:39.315 2022/7/20 12:00:09.157 DB time 91
1 2022/7/20 12:00:09.157 2022/7/20 12:30:15.225 DB time 67
1 2022/7/20 12:30:15.225 2022/7/20 13:00:10.094 DB time 184
1 2022/7/20 13:00:10.094 2022/7/20 13:30:41.033 DB time 154
1 2022/7/20 13:30:41.033 2022/7/20 14:00:07.549 DB time 163
1 2022/7/20 14:00:07.549 2022/7/20 14:30:23.238 DB time 168
1 2022/7/20 14:30:23.238 2022/7/20 15:00:12.185 DB time 167
1 2022/7/20 15:00:12.185 2022/7/20 15:30:43.159 DB time 185
1 2022/7/20 15:30:43.159 2022/7/20 16:00:11.120 DB time 179
1 2022/7/20 16:00:11.120 2022/7/20 16:30:28.660 DB time 247
1 2022/7/20 16:30:28.660 2022/7/20 17:00:15.276 DB time 136
1 2022/7/20 17:00:15.276 2022/7/20 17:30:01.486 DB time 112
1 2022/7/20 17:30:01.486 2022/7/20 18:00:16.541 DB time 150
已选择 479 行。
oracle-查看最近一段时间的db_time走向
2022-07-20
323
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
目录
相关文章
|
SQL
|
SQL
|
SQL
|
存储
|
存储
热门文章
最新文章
1
Oracle自动清理日志脚本
2
学习环境下Oracle RAC中的Centos系统BUG解决
3
ORACLE 视图 LONG VARCHAR2
4
探索Oracle之数据库升级三 回退升级操作(11.2.0.4Downgrade 11.2.0.3)
5
Oracle 审计和测试操作
6
Oracle 11g RAC crs_stat 命令结果完整显示
7
ORACLE虚拟索引(Virtual Index)
8
oracle rac升级补丁及中间的错误提示
9
Oracle ASM实例同filesystem间的文件传输
10
Oracle 11gR2光钎链路切换crs服务发生crash
1
DataWorks操作报错合集之尝试从Oracle数据库同步数据到TDSQL的PG版本，并遇到了与RAW字段相关的语法错误，该怎么处理
77
2
DataWorks产品使用合集之在 DataWorks 中，使用Oracle作为数据源进行数据映射和查询，如何更改数据源为MaxCompute或其他类型
57
3
MongoDB与Oracle：管道函数兼容之道
39
4
Oracle索引知识看这一篇就足够
75
5
Oracle 性能优化之AWR、ASH和ADDM(含报告生成和参数解读)
353
6
一篇文章带你学会 Oracle 存储过程的基本介绍和高阶用法（下）
463
7
一篇文章带你学会 Oracle 存储过程的基本介绍和高阶用法（上）
515
8
Oracle 数据泵导出导入(映射表空间、Schema)
82
9
不小心删除表或数据后，如何利用Oracle的闪回进行恢复
82
10
Oracle PLM Agile936 单点登录配置方式
87