Solaris
$ swap -s
total: 8669792k bytes allocated + 911696k reserved = 9581488k used, 89182544k available
$ swap -l
swapfile dev swaplo blocks free
/dev/vx/dsk/bootdg/swapvol 240,104002 16 16380608 16380608
Unix: command to check physical memory (RAM) in Solaris & AIX
Solaris: prtconf |grep -i mem
Aix: Determine the memory device name: lsdev -C |grep mem
$ lsdev -C |grep mem
mem0 Available Memory
lsattr -El mem0 (where mem0 is the memory device name)
Unix: Command to Find out Most CPU Consuming Processes
Linux Command
ps -eo pid,cmd,%cpu,%mem --sort=-%cpu | head -n 100
Sample Output
Unix: Command to kill multiple processes (pid) in single command
Most of the time DBAs has to perform their tasks quickly and with 100% accuracy. If we wanted to kill multiple oracle processes at time we can use below mentioned command. This command will filter the idle oracle sessions(local=no) and terminate.
Windows ORAKILL utility usage-Syntax to Kill Oracle thread
Oracle Utility orakill for windows
There are two ways to kill an oracle process (UNIX) or thread (windows). First, kill the session from database with sys as sysdba privilege using the command alter system kill session ‘sid, serial#’. Secondly, kill the process or thread from OS level. The first one has some limitations as it needs oracle database access.
Data Pump (expdp/impdp) Tuning features - PARALLEL option for faster performance behavior
Some Facts about DATA PUMP Parallel=n option
- By default the value of the parallel option is 1
- Export job creates those many threads specified in the parallel option.
- The value of the parallel option can be modified in interactive mode.
Solaris psrinfo to check number of CPU/processors SunOS
psrinfo command
In Solaris, psrinfo is the command to see the status of the CPUs/Processors. Below mentioned command will give the total number of CPUs in a Solaris server.
In Solaris, psrinfo is the command to see the status of the CPUs/Processors. Below mentioned command will give the total number of CPUs in a Solaris server.
