Tuesday, 17 October 2023
SQL Developer displaying Junk characters (??????)
Change the Encoding in SQL Developer Preferences as below
Tools --> Preferences --> Environment --> Encoding --> UTF-8 --> Restart the SQL Developer
After Restart we get the output as below
Monday, 16 October 2023
EBS : SQL to find SID from Concurrent Request ID
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id
FROM apps.fnd_concurrent_requests a
left outer join apps.FND_CONCURRENT_PROCESSES b on a.controlling_manager = b.concurrent_process_id
left outer join GV$PROCESS c on c.pid = b.oracle_process_id
left outer join GV$SESSION d on b.session_id=d.audsid
WHERE a.request_id =&ccr_req_id
Subscribe to:
Posts (Atom)
Oracle : Database Startup Time
Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT instance_name, to_char(startup_time,...