alter session set nls_date_format='yyyymmdd hh24:mi:ss';
select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ----------------- ------------ -----------------
1 1 129317 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 04:01:34 1.0224E+13 20200207 04:03:19
2 1 129318 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 04:03:19 1.0224E+13 20200207 04:05:07
3 1 129319 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 04:05:07 1.0224E+13 20200207 04:07:05
4 1 129316 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 03:59:52 1.0224E+13 20200207 04:01:34
5 1 129320 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 04:07:05 1.0224E+13 20200207 04:08:53
6 1 129321 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 04:08:53 1.0224E+13 20200207 04:10:44
7 1 129322 1073741824 512 1 NO CURRENT 1.0224E+13 20200207 04:10:44 2.8147E+14
8 1 129315 1073741824 512 1 NO INACTIVE 1.0224E+13 20200207 03:58:00 1.0224E+13 20200207 03:59:52
|