Category Archives: Scripts

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 »

Database and server details Report from OEM

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 »