tutorailwale

Query To Check Total Scheduled Requests SELECT request_id, id,Nvl(meaning, ‘UNKNOWN’),status,user_concurrent_program_name, pname,To_char(request_date, ‘DD-MON-RR HH24:MI:SS’), submitted,To_char(requested_start_date, ‘DD-MON-RR HH24:MI:SS’) requestedFROM fnd_concurrent_requests fcr,fnd_lookups fl,fnd_concurrent_programs_vl fcpvWHERE phase_code = ‘P’AND (fcr.requested_start_date … Read more

Query To Check List Of Running Requests SELECT q.concurrent_queue_nameqname,f.user_name,a.request_id“Req Id”,Decode(a.parent_request_id, –1, NULL,a.parent_request_id)“Parent”,a.concurrent_program_id“Prg Id”,a.phase_code,a.status_code— ,b.os_process_id “OS”— ,vs.sid— ,vs.serial# “Serial#”— ,vp.spid,a.oracle_process_id“spid”,( Nvl(a.actual_completion_date, SYSDATE) – a.actual_start_date ) * … Read more

There are many Oracle GoldenGate parameters for the extract, pump, and replicate processes. We will explain each of them step by step. Oracle GoldenGate Parameters: … Read more

OSWatcher is a tool that collects information from commands like top, ps, vmstat, netstat, iostat, and meminfo. It records data files and automatically looks for … Read more

To generate ASH Report in an Oracle database. It’s simple and very easy, please follow the below steps. ASH Report to identify performance bottlenecks. ASH … Read more

To generate ADDM Report in an Oracle database. It’s simple and very easy, please follow the below steps. Full form of ADDM report: Automatic Database … Read more

To generate AWR report, ASH report, and ADDM report for Oracle RAC and non-RAC databases. Below are the sql scripts to execute as a Sysdba … Read more

To check an Oracle user permission in an Oracle database, you can query the data dictionary views like DBA_SYS_PRIVS and DBA_TAB_PRIVS, which store information about … Read more

We tried to start the database but got “ORA 27102 out of memory” errors. There was a DB activity to perform and we normally shut … Read more