1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Finding archive log generation Code:

SELECT B.FIRST_TIME REDO_SWITCH_TIME, C.COMPLETION_TIME,A.SEQUENCE#
FROM V$LOG_HISTORY A,
V$LOG_HISTORY B,
V$ARCHIVED_LOG C
WHERE B.SEQUENCE# = A.SEQUENCE# +1
AND B.SEQUENCE#=C.SEQUENCE#
AND A.FIRST_TIME > SYSDATE - 2;

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy