Skip to main content

Posts

Hossam Moustafa Certificates 1.7

Executive Data Science Specialization Johns Hopkins University https://www.coursera.org/account/accomplishments/specialization/certificate/6GSML3NA5GKA Introduction to Artificial Intelligence (AI) IBM https://www.coursera.org/account/accomplishments/certificate/VK865NG8KYQB Cybersecurity Roles, Processes & Operating System Security IBM https://www.coursera.org/account/accomplishments/certificate/U9V5EQVRFKD3 The Bits and Bytes of Computer Networking Google https://www.coursera.org/account/accomplishments/certificate/HXTB8V6WPREC Data Science in Real Life Johns Hopkins University https://www.coursera.org/account/accomplishments/certificate/9LJDLNX7WDZU Initiating and Planning Projects University of California, Irvine https://www.coursera.org/account/accomplishments/certificate/RTCM63Z4ZMXX Budgeting and Scheduling Projects University of California, Irvine https://www.coursera.org/account/accomplishments/certificate/GP7DSQJ7DGFQ Foundations for Big Data Analysis with SQL (with Honors
Recent posts

Long Running Requests ( SQL Script)

SQL script  Long Running Requests set lines 130 column start_time format a15 column USER_CONCURRENT_PROGRAM_NAME format a40 select b.REQUEST_ID, a.USER_CONCURRENT_PROGRAM_NAME, b.phase_code,        (sysdate - b.actual_start_date) * 24 "running",        to_char(b.request_date, 'mm/dd/yyyy hh24:mi') "request_date",        to_char(b.actual_start_date, 'mm/dd/yyyy hh24:mi') "start_time"    from APPS.FND_CONCURRENT_PROGRAMS_VL a,        APPS.FND_CONCURRENT_REQUESTS b  where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID    and a.APPLICATION_ID = b.PROGRAM_APPLICATION_ID    and b.STATUS_CODE = 'R'    and b.PHASE_CODE = 'R'    and ((sysdate - b.actual_start_date) * 24) > 4    and a.CONCURRENT_PROGRAM_ID NOT IN(36887,43393,38121,42789,31556);

cloning Oracle WebLogic

 cloning WebLogic Oracle Note  #A Movement Scripts and Move Plans https://docs.oracle.com/middleware/12212/lcm/ASADM/GUID-97CFD814-A56C-447B-938E-B8CF9CDB04EF.htm#ASADM11899 #20 Moving from a Test to a Production Environment https://docs.oracle.com/middleware/12212/lcm/ASADM/GUID-E1986997-3BC2-411E-8EE4-12B2B769D016.htm#ASADM339