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

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,...