Apps DBA

Query To Check Open Cursor By User SELECT SUM(a.value) total_cur,Avg(a.value) … Read more

Query To Check Top 10 Database Load Queries SELECT *FROM … Read more

Query To Check List Of Locks In The Database SELECT … Read more

Query To Check Blocking Sessions Per User SELECT s1.username|| ‘@’|| … Read more

Query To Check Size Of All Tablespaces SELECT /* + … Read more

Query To find the details of the Accounting Flexfield structure … Read more

Query To Find a Scheduled Job for a particular program … 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 … Read more

How to Find the Request Group Associated with a Program. … Read more

Query To Find Global Locks Select Count(*)FROM gv$lock aWHERE a.id1 … Read more