Blogs about: Monitoring Scripts
Featured Blog
Creating custom XEvent Templates
SQL Server 2012 added the Extended Events UI which made working with Extended Events session much easier. You no longer need to chalk up lengthy T-SQL scripts to spawn off your Extended Events monitor… more →
TroubleshootingSQL
Creating custom XEvent Templates
wrote 7 months ago: SQL Server 2012 added the Extended Events UI which made working with Extended Events session much ea … more →
System Health Session and beyond
— 5 comments
wrote 8 months ago: I had blogged extensively about System Health Session available in SQL Server 2008 and above. I had … more →
Oracle EBS - Monitoring Scripts
— 3 comments
wrote 1 year ago: In this space you can find some very useful scripts that helps you to monitor EBS environment. Activ … more →
EBS Diagnostic Tool Execution – 11.5.10.2
wrote 1 year ago: One can read this blog to understand how Oracle Diagnostic tool is being executed in Oracle EBS. We … more →
Awesomesauce SQL Server 2012: System Health Session
wrote 1 year ago: There have been a spate of new features and enhancements to existing functionality in SQL Server 201 … more →
Awesomesauce SQL Server 2012: Performance Dashboard
wrote 1 year ago: I had written an article on SSWUG on how to track performance problems using Performance Dashboard. … more →
Find Open WF Items for a User
wrote 1 year ago: SQL> select ORIGINAL_RECIPIENT “EMP NUMBER”, STATUS, SUBJECT, BEGIN_DATE “NOTIF … more →
Find Form Session using UNIX PID
wrote 1 year ago: SQL> SELECT s.status “Status”, s.TYPE “Type”, s.username “DB_User … more →
Find the Responsibility for a Report
wrote 1 year ago: SQL> SELECT frv.responsibility_name, frg.request_group_name, frg.description descr, fcpv.user_con … more →
Find the Responsibility Created in XX days
wrote 1 year ago: SQL> SELECT responsibility_key, creation_date FROM fnd_responsibility WHERE creation_date between … more →
Find the Active Form Sessions
wrote 1 year ago: SQL> SELECT p.spid, s.process, s.status, s.machine, to_char(s.logon_time,’mm-dd-yy hh24:mi: … more →
Find Which Manager Runs the Concurrent Program
wrote 1 year ago: SQL> SELECT user_concurrent_program_name, user_concurrent_queue_name FROM apps.fnd_concurrent_pro … more →
Find the Scheduled Concurrent Request between Time
wrote 1 year ago: SQL> SELECT select request_id, program, user_name, Responsibility_name, application_name, request … more →
Find the Scheduled Concurrent Request with Arguments and Interval
wrote 1 year ago: SQL> SELECT cr.request_id, DECODE (cp.user_concurrent_program_name, ‘Report Set’, … more →
Find Concurrent Request Completed with Error/Warning
wrote 1 year ago: SQL> SELECT f.user_name, r.request_id, prg.concurrent_program_name Module, p.USER_CONCURRENT_PROG … more →
Find the Duplicate Concurrent Request
wrote 1 year ago: SQL> SELECT request_id, NAME, argument_text, user_name FROM (SELECT cr.request_id, DECODE (cp.use … more →
Find the Concurrent Request Ran for XX mins in XX days
wrote 1 year ago: SQL> SELECT q.concurrent_queue_name “Manager”, a.actual_start_date “Start Date … more →
Find the Concurrent Request Frequency in XX Days
wrote 1 year ago: SQL> SELECT substr(cname.user_concurrent_program_name,1,40) "Program Name", creq.strt_dt, creq.oc … more →
Find the schedule for a Concurrent Program
wrote 1 year ago: SQL>SELECT DISTINCT far.request_id, SUBSTR (program, 1, 30), far.user_name, far.phase_code, far … more →
