tutorailwale Query To Check Top 10 Database Load Queries SELECT *FROM (SELECT sql_text,cpu_time / 1000000 cpu_time,elapsed_time / 1000000 elapsed_time,disk_reads,buffer_gets,rows_processedFROM v$sqlareaORDER BY cpu_time DESC,disk_reads DESC)WHERE ROWNUM < … Read more
Query To Check List Of Locks In The Database SELECT a.inst_id,a.sid,a.TYPE,a.id1,a.id2,Decode(a.lmode, 0, ‘NONE’,1, ‘NULL’,2, ‘ROW SHARE’,3, ‘ROW EXCLUSIVE’,4, ‘SHARE’,5, ‘SHARE ROW EXCLUSIVE’,6, ‘EXCLUSIVE’,‘?’),Decode(a.request, 0, ‘NONE’,1, … Read more
Query To Check Blocking Sessions Per User SELECT s1.username|| ‘@’|| s1.machine|| ‘ ( SID=’|| s1.sid|| ‘ ) is blocking ‘|| s2.username|| ‘@’|| s2.machine|| ‘ ( … Read more
Query To Check Size Of All Tablespaces SELECT /* + RULE */ df.tablespace_name‘Tablespace’,df.bytes / ( 1024 * 1024 )‘Size (MB)”’,SUM(fs.bytes) / ( 1024 * 1024 … Read more
Query To find the details of the Accounting Flexfield structure SELECT gls.name,idfs.id_flex_num chart_of_accounts_id,idfs.segment_num,idfs.flex_value_set_id,fvs.flex_value_set_name,idfs.application_id,idfs.id_flex_code,idfs.application_column_name,idfs.segment_name,fvs.security_enabled_flag,( CASEWHEN fvs.validation_type = ‘F’ THEN ‘Table’WHEN fvs.validation_type = ‘I’ THEN ‘Independent’WHEN fvs.validation_type … Read more
Query To Find a Scheduled Job for a particular program SELECT a.requested_by,a.status_code,a.phase_code,a.request_id,b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date,c.execution_method_code,d.execution_file_name,d.execution_file_pathFROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs_tl b,apps.fnd_concurrent_programs c,apps.fnd_executables dWHERE a.status_code IN ( ‘Q’, ‘I’ )AND a.concurrent_program_id = … Read more
How to Find Scheduled Concurrent Program SELECT a.requested_by,a.status_code,a.phase_code,a.request_id,b.user_concurrent_program_name,c.concurrent_program_name,a.requested_start_date,c.execution_method_code,d.execution_file_name,d.execution_file_pathFROM apps.fnd_concurrent_requests a,apps.fnd_concurrent_programs_tl b,apps.fnd_concurrent_programs c,apps.fnd_executables dWHERE a.status_code IN ( ‘Q’, ‘I’ )AND a.concurrent_program_id = b.concurrent_program_idAND b.concurrent_program_id = c.concurrent_program_idAND … Read more
How to Find the Request Group Associated with a Program. SELECT rg.application_id“Request Group Application ID”,rg.request_group_id“Request Group – Group ID”,rg.request_group_name,rg.description,rgu.unit_application_id,rgu.request_group_id“Request Group Unit – Group ID”,rgu.request_unit_id,cp.concurrent_program_id,cp.concurrent_program_name,cpt.user_concurrent_program_name,Decode(rgu.request_unit_type, ‘P’, … Read more
Query To Find Global Locks Select Count(*)FROM gv$lock aWHERE a.id1 IN (SELECT id1FROM gv$lockWHERE request <> 0); Read More Articles Query To Check Web Sessions … Read more
Query To Check Web Sessions SELECT Count(*)FROM v$process p,gv$session sWHERE p.addr = s.paddrAND s.program = ‘JDBC Thin Client’; Read More Articles Query To Verify Workflow … Read more