Hinzinfotech

1.To list long-running forms user sessions select s.sid,s.process,p.spid,s.status ,s.action,s.module, (s.last_call_et/3600) fromv$session s, v$process p where round(last_call_et/3600) >4 and action like ‘%FRM%’ andp.addr=s.paddr ; 2.To list inactive Sessions respective username SELECT username,count(*) num_inv_sessFROM v$sessionwhere last_call_et > 3600and username is not nullAND STATUS=’INACTIVE’group by usernameorder by num_inv_sess DESC; SELECT count(*) FROM v$session where last_call_et > 43200 and […]

In today’s digital era, cloud computing has revolutionized the way businesses operate, providing scalable, cost-effective, and reliable solutions to meet diverse IT requirements. Among the leading cloud service providers, Amazon Web Services (AWS) stands out as a powerhouse, offering a comprehensive suite of services to cater to the needs of organizations worldwide. What is AWS? […]