set linesize 200;
set pagesize 100;
col inst_id for 9999999 heading 'Instance #'
col file_nr for 9999999 heading 'File #'
col file_name for A50 heading 'File name'
col checkpoint_change_nr for 99999999999999 heading 'Checkpoint #'
col checkpoint_change_time for A20 heading 'Checkpoint time'
col last_change_nr for 99999999999999 heading 'Last change #'
SELECT
fe.inst_id,
fe.fenum file_nr,
fn.fnnam file_name,
TO_NUMBER (fe.fecps) checkpoint_change_nr,
fe.fecpt checkpoint_change_time,
-- fe.fests last_change_nr,
DECODE (
fe.fetsn,
0, DECODE (BITAND (fe.festa, 2), 0, 'SYSOFF', 'SYSTEM'),
DECODE (BITAND (fe.festa, 18),
0, 'OFFLINE',
2, 'ONLINE',
'RECOVER')
) status
FROM x$kccfe fe,
x$kccfn fn
WHERE ( (fe.fepax != 65535 AND fe.fepax != 0 )
OR (fe.fepax = 65535 OR fe.fepax = 0)
)
AND fn.fnfno = fe.fenum
AND fe.fefnh = fn.fnnum
AND fe.fedup != 0
AND fn.fntyp = 4
AND fn.fnnam IS NOT NULL
AND BITAND (fn.fnflg, 4) != 4
ORDER BY fe.fenum
/
Instance # File # File name Checkpoint # Checkpoint time STATUS
--------------------------------------- --------------- -------------------- --------------- ---------------
1 1 +DATA2/db11g/system.256.868 1026049 01/29/2015 17:39:04 SYSTEM
1 2 +DATA2/db11g/sysaux.257.868 1026049 01/29/2015 17:39:04 ONLINE
1 3 +DATA2/db11g/undotbs.258.868 1026049 01/29/2015 17:39:04 ONLINE
1 4 +DATA2/db11g/users.259.868 1026049 01/29/2015 17:39:04 ONLINE
To check Datafile fuzziness:
=======================
set numwidth 30;
set pagesize 50000;
alter session set nls_date_format = 'DD-MON-RRRR HH24:MI:SS';
set line 1000
SQL> select status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, count(*), fuzzy from v$datafile_header group by status,checkpoint_change#,checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy;
STATUS CHECKPOINT_CHANGE# CHECKPOINT_TIME RESETLOGS_CHANGE# RESETLOGS_TIME COUNT(*) FUZ
------- ------------------ -------------------------- ------------------------------ -------------------------- ------------------------------ ---
ONLINE 6798623301 03-DEC-2008 10:47:36 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 7116772157 17-FEB-2009 15:49:37 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 7180206429 02-MAR-2009 12:08:35 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 7340089977 07-APR-2009 00:28:19 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18205667200 13-DEC-2014 14:45:30 3264889930 06-APR-2006 16:39:38 4 NO
ONLINE 18205667200 13-DEC-2014 14:45:30 3264889930 06-APR-2006 16:39:38 10 YES
ONLINE 18207657100 14-DEC-2014 05:18:47 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18207657100 14-DEC-2014 05:18:47 3264889930 06-APR-2006 16:39:38 1 YES
ONLINE 10983307652 05-JAN-2011 09:19:51 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18187780810 09-DEC-2014 15:08:55 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18205667203 13-DEC-2014 14:45:30 3264889930 06-APR-2006 16:39:38 3 NO
ONLINE 18205667203 13-DEC-2014 14:45:30 3264889930 06-APR-2006 16:39:38 2 YES
ONLINE 18205696549 13-DEC-2014 15:11:27 3264889930 06-APR-2006 16:39:38 2 NO
ONLINE 18205696549 13-DEC-2014 15:11:27 3264889930 06-APR-2006 16:39:38 1 YES
ONLINE 18205701941 13-DEC-2014 15:15:52 3264889930 06-APR-2006 16:39:38 2 NO
ONLINE 18205722195 13-DEC-2014 15:35:18 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18205722195 13-DEC-2014 15:35:18 3264889930 06-APR-2006 16:39:38 1 YES
ONLINE 18205727227 13-DEC-2014 15:40:24 3264889930 06-APR-2006 16:39:38 2 NO
ONLINE 18205809760 13-DEC-2014 16:00:01 3264889930 06-APR-2006 16:39:38 2 NO
ONLINE 18205822343 13-DEC-2014 16:04:56 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18205822343 13-DEC-2014 16:04:56 3264889930 06-APR-2006 16:39:38 1 YES
ONLINE 18205850552 13-DEC-2014 16:24:22 3264889930 06-APR-2006 16:39:38 1 NO
ONLINE 18205850552 13-DEC-2014 16:24:22 3264889930 06-APR-2006 16:39:38 1 YES
ONLINE 18205854452 13-DEC-2014 16:29:28 3264889930 06-APR-2006 16:39:38 2 NO
ONLINE 18205902094 13-DEC-2014 16:48:44 3264889930 06-APR-2006 16:39:38 2 NO
Jadwal Cockfight SV388 2 Maret 2019 di Situs Judi Sabung Ayam Online Melalui Agen Resmi Taruhan Sabung Ayam Live Asli Thailand.
ReplyDeleteJudi Sabung Ayam - Sabtu, Aceh 2 Maret 2019 – Kami Selaku Agen Sabung Ayam 2018 Akan Memberikan Informasi Mengenai Jadwal Cockfight SV388 2 Maret 2019.
Untuk Info Lebih Lanjut Bisa Hub kami Di :
wechat : bolavita
line : cs_bolavita
whatsapp : +628122222995
BBM: BOLAVITA
,.,,,
Hello Everybody,
ReplyDeleteMy name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of $250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of $250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius, call/whats-App Contact Number +918929509036 via email:(urgentloan22@gmail.com) Thank you.