Skip to main content

Script to get the list of sessions for a user currently in the Database

-

Script to get the list of sessions for a user currently in the Database

select
sid,serial#,username,status,module,command,
to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON", program,last_call_et
from
v$session
where
username like '%&usr%'
order by logon_time;

 Changes the usr as per your requirement.

Comments

Post a Comment

Popular posts from this blog

Output Post Processor - EBS 12.2.4 Troubleshoot

-
Output Post Processor TroubleShooting Issue 1 Output Post Processor is Down with Actual Process is 0 And Target Process is 1 1. Shutdown Concurrent Managers 2. To ensure concurrent manager down; check there is no FNDLIBR process running. ps -ef | grep FNDLIBR 3. Run adadmin to relink FNDSVC executable. a. Invoke adadmin from command prompt b. Choose option 2 (2. Maintain Applications Files menu) c. Choose option 1 (1. Relink Applications programs ) d. Then type FND When prompted; ( Enter list of products to link (all for all products) [all] : FND ) e. Ensure adrelink is exiting with status 0 4. Start Concurrent Managers 5. Check the Output Post Processor Issue 2 Concurrent Processing  R12 Output Post Processor Service Not Coming Up Reason : If Service Manager for the node is not running.  Possible cause might be service manager definition is missing under Concurrent ->Manager ->Define form. If the Service Manager is not pr...
Read more

ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pmucalm coll)

-
During Subscriber Removal we were getting below Oracle Error. SQL> DECLARE   subscriber   SYS.aq$_agent; BEGIN   subscriber := SYS.aq$_agent ('ORA_692K6D2264P48DHO6OR3ACPJ6T', NULL, NULL);   DBMS_AQADM.remove_subscriber (queue_name      => 'WF_BPEL_Q',                                 subscriber      => subscriber                                ); END;  / DECLARE * ERROR at line 1: ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pmucalm coll) ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7560 ORA-06512: at "SYS.DBMS_AQADM", line 441 ORA-06512: at line 5 == We were running a PL/SQL package or procedure and are consistently encountering an ORA-4030 when the process uses 4GB.  The values for the _PGA_MAX...
Read more

How to Diagnose Workflow Notification Mailer Issue

-
Outbound Notification Emails : 1. Check if the notification is present in the recipient/user's Worklist/Notifications page.If it does not exist     then it means that notification itself is not created and need to check the corresponding workflow     status.You may also query the notification from the wf_notifications table SQL> select recipient_role,notification_id,status,mail_status from wf_notifications where recipient_role like '&user_name';    The e-mail notification is sent only if all of following are true.                --Notification status is OPEN or CANCELED                --Notification mail_status is MAIL or INVALID 2. Check Recipient role has a valid e-mail address and notification preference MAIL% SELECT email_address, nvl(WF_PREF.get_pref(name, 'MAILT...
Read more