Oracle Database session and user details
Script for Oracle Database session,user,process and sid details. col OS_USER for a25 col SID for a10 col USERNAME for a20 col PID for a20 select substr(a.spid,1,9) pid, substr(b.sid,1,5)… Read more »
Script for Oracle Database session,user,process and sid details. col OS_USER for a25 col SID for a10 col USERNAME for a20 col PID for a20 select substr(a.spid,1,9) pid, substr(b.sid,1,5)… Read more »
Database and server details Report from OEM: 1- How do get the number of databases for each category version? SELECT property_value, COUNT(*) FROM mgmt$target_properties WHERE target_type = ‘oracle_database’ AND property_name… Read more »