SQL> select b.recid,to_char(b.first_time,'dd-mon-yy hh24:mi:ss') start_time,a.recid,
2 to_char(a.first_time,'dd-mon-yy hh24:mi:ss')end_time,round(((a.first_time-b.first_time)*24)*60,2) minutes
3 from v$log_history a,v$log_history b where a.recid=b.recid+1 order by a.first_time asc;
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
1 17-may-10 00:14:58 2 17-may-10 01:17:44 62.77
2 17-may-10 01:17:44 3 17-may-10 01:17:51 .12
3 17-may-10 01:17:51 4 17-may-10 09:35:05 497.23
4 17-may-10 09:35:05 5 17-may-10 17:26:46 471.68
5 17-may-10 17:26:46 6 18-may-10 01:18:00 471.23
6 18-may-10 01:18:00 7 18-may-10 01:18:43 .72
7 18-may-10 01:18:43 8 18-may-10 10:53:25 574.7
8 18-may-10 10:53:25 9 18-may-10 20:18:57 565.53
9 18-may-10 20:18:57 10 19-may-10 01:18:27 299.5
10 19-may-10 01:18:27 11 19-may-10 01:18:46 .32
11 19-may-10 01:18:46 12 19-may-10 11:04:49 586.05
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
12 19-may-10 11:04:49 13 19-may-10 20:31:20 566.52
13 19-may-10 20:31:20 14 20-may-10 01:17:59 286.65
14 20-may-10 01:17:59 15 20-may-10 01:18:17 .3
15 20-may-10 01:18:17 16 20-may-10 11:06:14 587.95
16 20-may-10 11:06:14 17 20-may-10 20:35:37 569.38
17 20-may-10 20:35:37 18 21-may-10 01:15:59 280.37
18 21-may-10 01:15:59 19 21-may-10 01:16:17 .3
19 21-may-10 01:16:17 20 21-may-10 10:54:53 578.6
20 21-may-10 10:54:53 21 21-may-10 21:06:55 612.03
21 21-may-10 21:06:55 22 22-may-10 01:15:54 248.98
22 22-may-10 01:15:54 23 22-may-10 01:16:12 .3
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
23 22-may-10 01:16:12 24 22-may-10 10:47:45 571.55
24 22-may-10 10:47:45 25 22-may-10 20:03:40 555.92
25 22-may-10 20:03:40 26 23-may-10 01:15:51 312.18
26 23-may-10 01:15:51 27 23-may-10 01:16:12 .35
27 23-may-10 01:16:12 28 23-may-10 11:00:08 583.93
28 23-may-10 11:00:08 29 23-may-10 20:44:28 584.33
29 23-may-10 20:44:28 30 24-may-10 01:15:37 271.15
30 24-may-10 01:15:37 31 24-may-10 01:15:53 .27
31 24-may-10 01:15:53 32 24-may-10 10:49:26 573.55
32 24-may-10 10:49:26 33 24-may-10 20:16:44 567.3
33 24-may-10 20:16:44 34 25-may-10 01:15:43 298.98
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
34 25-may-10 01:15:43 35 25-may-10 01:16:02 .32
35 25-may-10 01:16:02 36 25-may-10 10:42:22 566.33
36 25-may-10 10:42:22 37 25-may-10 20:15:47 573.42
37 25-may-10 20:15:47 38 26-may-10 01:15:54 300.12
38 26-may-10 01:15:54 39 26-may-10 01:16:14 .33
39 26-may-10 01:16:14 40 26-may-10 10:37:48 561.57
40 26-may-10 10:37:48 41 26-may-10 20:06:51 569.05
41 26-may-10 20:06:51 42 27-may-10 01:16:52 310.02
42 27-may-10 01:16:52 43 27-may-10 01:17:13 .35
43 27-may-10 01:17:13 44 27-may-10 10:44:25 567.2
44 27-may-10 10:44:25 45 27-may-10 20:16:20 571.92
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
45 27-may-10 20:16:20 46 28-may-10 01:16:54 300.57
46 28-may-10 01:16:54 47 28-may-10 01:17:13 .32
47 28-may-10 01:17:13 48 28-may-10 10:41:18 564.08
48 28-may-10 10:41:18 49 28-may-10 20:24:56 583.63
49 28-may-10 20:24:56 50 29-may-10 01:15:46 290.83
50 29-may-10 01:15:46 51 29-may-10 01:16:04 .3
51 29-may-10 01:16:04 52 29-may-10 10:59:12 583.13
52 29-may-10 10:59:12 53 29-may-10 20:49:16 590.07
53 29-may-10 20:49:16 54 30-may-10 01:14:59 265.72
54 30-may-10 01:14:59 55 30-may-10 01:15:16 .28
55 30-may-10 01:15:16 56 30-may-10 11:02:15 586.98
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
56 30-may-10 11:02:15 57 30-may-10 20:45:02 582.78
57 30-may-10 20:45:02 58 31-may-10 01:15:04 270.03
58 31-may-10 01:15:04 59 31-may-10 01:15:21 .28
59 31-may-10 01:15:21 60 31-may-10 10:46:46 571.42
60 31-may-10 10:46:46 61 31-may-10 20:08:18 561.53
61 31-may-10 20:08:18 62 01-jun-10 01:15:40 307.37
62 01-jun-10 01:15:40 63 01-jun-10 01:16:01 .35
63 01-jun-10 01:16:01 64 01-jun-10 10:42:50 566.82
64 01-jun-10 10:42:50 65 01-jun-10 20:07:56 565.1
65 01-jun-10 20:07:56 66 02-jun-10 01:15:51 307.92
66 02-jun-10 01:15:51 67 02-jun-10 01:16:13 .37
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
67 02-jun-10 01:16:13 68 02-jun-10 10:36:34 560.35
68 02-jun-10 10:36:34 69 02-jun-10 20:39:52 603.3
69 02-jun-10 20:39:52 70 03-jun-10 01:15:19 275.45
70 03-jun-10 01:15:19 71 03-jun-10 01:15:35 .27
71 03-jun-10 01:15:35 72 03-jun-10 10:52:24 576.82
72 03-jun-10 10:52:24 73 03-jun-10 20:34:43 582.32
73 03-jun-10 20:34:43 74 04-jun-10 01:16:02 281.32
74 04-jun-10 01:16:02 75 04-jun-10 01:16:19 .28
75 04-jun-10 01:16:19 76 04-jun-10 10:35:23 559.07
76 04-jun-10 10:35:23 77 04-jun-10 20:07:45 572.37
77 04-jun-10 20:07:45 78 05-jun-10 01:17:21 309.6
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
78 05-jun-10 01:17:21 79 05-jun-10 01:17:42 .35
79 05-jun-10 01:17:42 80 05-jun-10 03:37:03 139.35
80 05-jun-10 03:37:03 81 05-jun-10 12:53:55 556.87
81 05-jun-10 12:53:55 82 05-jun-10 22:05:13 551.3
82 05-jun-10 22:05:13 83 06-jun-10 01:16:23 191.17
83 06-jun-10 01:16:23 84 06-jun-10 01:16:37 .23
84 06-jun-10 01:16:37 85 06-jun-10 10:50:27 573.83
85 06-jun-10 10:50:27 86 06-jun-10 20:25:39 575.2
86 06-jun-10 20:25:39 87 07-jun-10 01:17:04 291.42
87 07-jun-10 01:17:04 88 07-jun-10 01:17:24 .33
88 07-jun-10 01:17:24 89 07-jun-10 10:37:18 559.9
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
89 07-jun-10 10:37:18 90 07-jun-10 19:51:13 553.92
90 07-jun-10 19:51:13 91 08-jun-10 01:15:19 324.1
91 08-jun-10 01:15:19 92 08-jun-10 01:15:39 .33
92 08-jun-10 01:15:39 93 08-jun-10 11:05:01 589.37
93 08-jun-10 11:05:01 94 08-jun-10 20:53:40 588.65
94 08-jun-10 20:53:40 95 09-jun-10 01:15:37 261.95
95 09-jun-10 01:15:37 96 09-jun-10 01:15:53 .27
96 09-jun-10 01:15:53 97 09-jun-10 11:36:19 620.43
97 09-jun-10 11:36:19 98 09-jun-10 21:02:53 566.57
98 09-jun-10 21:02:53 99 10-jun-10 01:14:47 251.9
99 10-jun-10 01:14:47 100 10-jun-10 01:15:02 .25
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
100 10-jun-10 01:15:02 101 10-jun-10 11:02:05 587.05
101 10-jun-10 11:02:05 102 10-jun-10 20:35:57 573.87
102 10-jun-10 20:35:57 103 11-jun-10 01:14:53 278.93
103 11-jun-10 01:14:53 104 11-jun-10 01:15:12 .32
104 11-jun-10 01:15:12 105 11-jun-10 11:15:10 599.97
105 11-jun-10 11:15:10 106 11-jun-10 21:03:34 588.4
106 11-jun-10 21:03:34 107 12-jun-10 01:15:08 251.57
107 12-jun-10 01:15:08 108 12-jun-10 01:15:25 .28
108 12-jun-10 01:15:25 109 12-jun-10 11:21:31 606.1
109 12-jun-10 11:21:31 110 12-jun-10 21:03:05 581.57
110 12-jun-10 21:03:05 111 13-jun-10 01:15:02 251.95
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
111 13-jun-10 01:15:02 112 13-jun-10 01:15:18 .27
112 13-jun-10 01:15:18 113 13-jun-10 11:13:56 598.63
113 13-jun-10 11:13:56 114 13-jun-10 20:42:05 568.15
114 13-jun-10 20:42:05 115 14-jun-10 01:15:22 273.28
115 14-jun-10 01:15:22 116 14-jun-10 01:15:38 .27
116 14-jun-10 01:15:38 117 14-jun-10 10:48:28 572.83
117 14-jun-10 10:48:28 118 14-jun-10 20:31:01 582.55
118 14-jun-10 20:31:01 119 15-jun-10 01:15:13 284.2
119 15-jun-10 01:15:13 120 15-jun-10 01:15:31 .3
120 15-jun-10 01:15:31 121 15-jun-10 10:43:38 568.12
121 15-jun-10 10:43:38 122 15-jun-10 20:25:40 582.03
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
122 15-jun-10 20:25:40 123 16-jun-10 01:15:19 289.65
123 16-jun-10 01:15:19 124 16-jun-10 01:15:42 .38
124 16-jun-10 01:15:42 125 16-jun-10 10:56:48 581.1
125 16-jun-10 10:56:48 126 16-jun-10 20:36:13 579.42
126 16-jun-10 20:36:13 127 17-jun-10 01:15:31 279.3
127 17-jun-10 01:15:31 128 17-jun-10 01:15:52 .35
128 17-jun-10 01:15:52 129 17-jun-10 10:55:38 579.77
129 17-jun-10 10:55:38 130 17-jun-10 20:17:30 561.87
130 17-jun-10 20:17:30 131 18-jun-10 01:15:30 298
131 18-jun-10 01:15:30 132 18-jun-10 01:15:51 .35
132 18-jun-10 01:15:51 133 18-jun-10 10:53:15 577.4
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
133 18-jun-10 10:53:15 134 18-jun-10 20:19:57 566.7
134 18-jun-10 20:19:57 135 19-jun-10 01:15:08 295.18
135 19-jun-10 01:15:08 136 19-jun-10 01:15:26 .3
136 19-jun-10 01:15:26 137 19-jun-10 10:53:03 577.62
137 19-jun-10 10:53:03 138 19-jun-10 20:26:38 573.58
138 19-jun-10 20:26:38 139 20-jun-10 01:17:40 291.03
139 20-jun-10 01:17:40 140 20-jun-10 01:17:57 .28
140 20-jun-10 01:17:57 141 20-jun-10 11:27:17 609.33
141 20-jun-10 11:27:17 142 20-jun-10 20:19:17 532
142 20-jun-10 20:19:17 143 21-jun-10 01:15:18 296.02
143 21-jun-10 01:15:18 144 21-jun-10 01:15:39 .35
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
144 21-jun-10 01:15:39 145 21-jun-10 10:47:35 571.93
145 21-jun-10 10:47:35 146 21-jun-10 20:21:04 573.48
146 21-jun-10 20:21:04 147 22-jun-10 06:35:58 614.9
147 22-jun-10 06:35:58 148 22-jun-10 15:37:46 541.8
148 22-jun-10 15:37:46 149 23-jun-10 00:49:38 551.87
149 23-jun-10 00:49:38 150 23-jun-10 01:15:39 26.02
150 23-jun-10 01:15:39 151 23-jun-10 01:15:41 .03
151 23-jun-10 01:15:41 152 23-jun-10 10:48:06 572.42
152 23-jun-10 10:48:06 153 23-jun-10 20:13:56 565.83
153 23-jun-10 20:13:56 154 24-jun-10 01:17:03 303.12
154 24-jun-10 01:17:03 155 24-jun-10 01:17:22 .32
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
155 24-jun-10 01:17:22 156 24-jun-10 11:12:38 595.27
156 24-jun-10 11:12:38 157 24-jun-10 20:24:18 551.67
157 24-jun-10 20:24:18 158 25-jun-10 01:17:32 293.23
158 25-jun-10 01:17:32 159 25-jun-10 01:17:51 .32
159 25-jun-10 01:17:51 160 25-jun-10 12:07:03 649.2
160 25-jun-10 12:07:03 161 25-jun-10 21:00:09 533.1
161 25-jun-10 21:00:09 162 26-jun-10 01:15:21 255.2
162 26-jun-10 01:15:21 163 26-jun-10 01:15:42 .35
163 26-jun-10 01:15:42 164 26-jun-10 11:15:36 599.9
164 26-jun-10 11:15:36 165 26-jun-10 19:44:42 509.1
165 26-jun-10 19:44:42 166 27-jun-10 01:15:30 330.8
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
166 27-jun-10 01:15:30 167 27-jun-10 01:15:54 .4
167 27-jun-10 01:15:54 168 27-jun-10 10:49:32 573.63
168 27-jun-10 10:49:32 169 27-jun-10 20:23:44 574.2
169 27-jun-10 20:23:44 170 28-jun-10 01:15:06 291.37
170 28-jun-10 01:15:06 171 28-jun-10 01:15:24 .3
171 28-jun-10 01:15:24 172 28-jun-10 10:43:56 568.53
172 28-jun-10 10:43:56 173 28-jun-10 19:50:18 546.37
173 28-jun-10 19:50:18 174 29-jun-10 01:15:43 325.42
174 29-jun-10 01:15:43 175 29-jun-10 01:16:05 .37
175 29-jun-10 01:16:05 176 29-jun-10 10:37:23 561.3
176 29-jun-10 10:37:23 177 29-jun-10 19:46:59 549.6
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
177 29-jun-10 19:46:59 178 30-jun-10 01:15:38 328.65
178 30-jun-10 01:15:38 179 30-jun-10 01:16:01 .38
179 30-jun-10 01:16:01 180 30-jun-10 10:35:24 559.38
180 30-jun-10 10:35:24 181 30-jun-10 19:51:33 556.15
181 30-jun-10 19:51:33 182 01-jul-10 01:15:29 323.93
182 01-jul-10 01:15:29 183 01-jul-10 01:15:54 .42
183 01-jul-10 01:15:54 184 01-jul-10 10:42:19 566.42
184 01-jul-10 10:42:19 185 01-jul-10 19:58:36 556.28
185 01-jul-10 19:58:36 186 02-jul-10 01:16:39 318.05
186 02-jul-10 01:16:39 187 02-jul-10 01:17:04 .42
187 02-jul-10 01:17:04 188 02-jul-10 10:50:09 573.08
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
188 02-jul-10 10:50:09 189 02-jul-10 20:06:15 556.1
189 02-jul-10 20:06:15 190 03-jul-10 01:16:39 310.4
190 03-jul-10 01:16:39 191 03-jul-10 01:17:02 .38
191 03-jul-10 01:17:02 192 03-jul-10 10:42:54 565.87
192 03-jul-10 10:42:54 193 03-jul-10 19:57:11 554.28
193 03-jul-10 19:57:11 194 04-jul-10 01:16:52 319.68
194 04-jul-10 01:16:52 195 04-jul-10 01:17:13 .35
195 04-jul-10 01:17:13 196 04-jul-10 10:46:49 569.6
196 04-jul-10 10:46:49 197 04-jul-10 20:19:56 573.12
197 04-jul-10 20:19:56 198 05-jul-10 01:17:09 297.22
198 05-jul-10 01:17:09 199 05-jul-10 01:17:31 .37
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
199 05-jul-10 01:17:31 200 05-jul-10 03:07:43 110.2
200 05-jul-10 03:07:43 201 05-jul-10 12:15:55 548.2
201 05-jul-10 12:15:55 202 05-jul-10 21:10:31 534.6
202 05-jul-10 21:10:31 203 06-jul-10 01:18:25 247.9
203 06-jul-10 01:18:25 204 06-jul-10 01:18:42 .28
204 06-jul-10 01:18:42 205 06-jul-10 10:48:40 569.97
205 06-jul-10 10:48:40 206 06-jul-10 20:10:13 561.55
206 06-jul-10 20:10:13 207 07-jul-10 01:17:36 307.38
207 07-jul-10 01:17:36 208 07-jul-10 01:17:59 .38
208 07-jul-10 01:17:59 209 07-jul-10 10:56:47 578.8
209 07-jul-10 10:56:47 210 07-jul-10 20:17:26 560.65
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
210 07-jul-10 20:17:26 211 08-jul-10 01:18:16 300.83
211 08-jul-10 01:18:16 212 08-jul-10 01:18:37 .35
212 08-jul-10 01:18:37 213 08-jul-10 10:58:56 580.32
213 08-jul-10 10:58:56 214 08-jul-10 20:18:27 559.52
214 08-jul-10 20:18:27 215 09-jul-10 01:18:14 299.78
215 09-jul-10 01:18:14 216 09-jul-10 01:18:38 .4
216 09-jul-10 01:18:38 217 09-jul-10 11:03:18 584.67
217 09-jul-10 11:03:18 218 09-jul-10 20:38:52 575.57
218 09-jul-10 20:38:52 219 10-jul-10 01:17:45 278.88
219 10-jul-10 01:17:45 220 10-jul-10 01:18:03 .3
220 10-jul-10 01:18:03 221 10-jul-10 11:07:54 589.85
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
221 10-jul-10 11:07:54 222 10-jul-10 20:45:42 577.8
222 10-jul-10 20:45:42 223 11-jul-10 01:16:35 270.88
223 11-jul-10 01:16:35 224 11-jul-10 01:16:55 .33
224 11-jul-10 01:16:55 225 11-jul-10 11:19:15 602.33
225 11-jul-10 11:19:15 226 12-jul-10 01:15:55 836.67
226 12-jul-10 01:15:55 227 12-jul-10 01:16:29 .57
227 12-jul-10 01:16:29 228 12-jul-10 21:43:06 1226.62
228 12-jul-10 21:43:06 229 13-jul-10 00:08:25 145.32
229 13-jul-10 00:08:25 230 13-jul-10 01:18:38 70.22
230 13-jul-10 01:18:38 231 13-jul-10 01:19:00 .37
231 13-jul-10 01:19:00 232 13-jul-10 10:34:21 555.35
RECID START_TIME RECID END_TIME MINUTES
---------- --------------------- ---------- --------------------- ----------
232 13-jul-10 10:34:21 233 13-jul-10 20:00:38 566.28
233 13-jul-10 20:00:38 234 14-jul-10 01:15:38 315
234 14-jul-10 01:15:38 235 14-jul-10 01:15:51 .22
235 14-jul-10 01:15:51 236 15-jul-10 16:24:20 2348.48
236 15-jul-10 16:24:20 237 15-jul-10 17:51:40 87.33
237 15-jul-10 17:51:40 238 15-jul-10 21:32:26 220.77
238 15-jul-10 21:32:26 239 15-jul-10 21:55:13 22.78
239 15-jul-10 21:55:13 240 15-jul-10 22:07:19 12.1
240 15-jul-10 22:07:19 241 15-jul-10 22:16:48 9.48
241 15-jul-10 22:16:48 242 16-jul-10 00:15:38 118.83
242 16-jul-10 00:15:38 243 16-jul-10 22:00:15 1304.62
242 rows selected.
SQL>
阅读(1020) | 评论(0) | 转发(0) |