Month: May 2005
-
Oracle: CPU Used by Each Database Session
Oracle exposes cumulative database CPU time for each session through V$SESSTAT. Join it to V$STATNAME by name—never hard-code a statistic number, because statistic numbers can change between releases. Current CPU by session The statistic is cumulative for the life of the session and is traditionally recorded in hundredths of a second. It is Oracle database…
-
Oracle IPC Resources: Map Shared Memory to an Instance
On UNIX and Linux hosts with several Oracle instances, ipcs can show many shared-memory and semaphore resources without identifying the owning database clearly. Oracle’s sysresv utility maps System V IPC resources to an Oracle SID. Report resources for an instance To check one or more explicitly named instances: Run the command as the Oracle software…