Asif's Oracle Repository

Background:  When we run, the following SQL Query/Script will provide the profile option values set at different levels. That is Site, Application, Responsibility, User.  So, this script lists ALL Users/Responsibilities/Applications set against a particular Profile option SQL Script:   Enter 'Profile Option Name' as need to check  Eg. FND: Debug Log Enabled [You can get the exact name from table fnd_profile_options_tl]    SELECT fpo.profile_option_name SHORT_NAME,          fpot.user_profile_option_name NAME,          DECODE (fpov.level_id,                  10001, 'Site',                  10002, 'Application',                  10...

SELECT s.inst_id, NVL (s.username, 'Internal') "Database User", m.SID, s.serial#, p.spid "DB OS Process", m.TYPE, DECODE (m.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4, 'Share', 5, 'S/Row Excl.', 6, 'Exclusive', lmode, LTRIM (TO_CHAR (lmode, '990')) ) "Lock Type", DECODE (m.request, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4, 'Share', 5, 'S/Row Excl.', 6, 'Exclusive', request, LTRIM (TO_CHAR (m.request, '990')) ) "Lock Request", DECODE (command, 0, 'None', DECODE (m.id2, 0, dusr.username || '.' || SUBSTR (dobj.NAME, 1, 30), 'Rollback Segment' ) ) "Object", s.machine "Application Server", s.process "Apps OS process", m.ctime, NVL (NVL (usr.description, s.action), 'Database Session' ) "Online User,Concurrent", N...

  The Internal Workflow of an E-Business Suite Concurrent Manager Process                       Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing functionality for background jobs, and it’s used by most of the application modules. As many things depend on concurrent processing, it’s important to make sure that the configuration is tuned for your requirements and hardware specification. This is the first article in a series about the performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance, and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading! There are few things...