How to Monitor UNIX CPU Usage by Process
OP usually have been told and trained to use "top" command to monitor the overall status of a server, the "top" command can show many… Read More »How to Monitor UNIX CPU Usage by Process
Unix
How to Retrieve a Directory Recursively by FTP Alternatively
There is no direct FTP command that can recursively download a directory, so don't expect that you can do this operation in one or few… Read More »How to Retrieve a Directory Recursively by FTP Alternatively
Irix Mode vs. Solaris Mode in Top Command
On Solaris, the top command always takes all cpu usage as a maximum 100%, no matter how many cpus are there on the board. In… Read More »Irix Mode vs. Solaris Mode in Top Command
How to Remove ^M Character from Files
Editing on client side computer has many advantages than on server side. In real world, Windows takes the largest market share on client environment, therefore,… Read More »How to Remove ^M Character from Files
How to Monitor Real-Time Top SQL on CPU Consuming
You can identify the most cpu-consuming SQL statements from database memory by querying v$sql.cpu_time, but they are not real-time data, they are history data. If… Read More »How to Monitor Real-Time Top SQL on CPU Consuming
How to Clean ASM Candidate Disks
OS administrator might claim the candidate disks prepared for you to install ASM are newly created and very clean. But if they are not, then,… Read More »How to Clean ASM Candidate Disks
How to Write Control File into Raw Device
Control File in Raw Device? Since raw devices cannot be read/write as a normal file operation, you cannot write a controlfile directly into a raw… Read More »How to Write Control File into Raw Device
How to Remove No-Name or Empty-Name Files
After you finish your shell scripting, you'd like to try your scripts to see the result in your test environment. In the debug phase, you… Read More »How to Remove No-Name or Empty-Name Files
How to Resolve Only at Command is Available to Schedule Jobs
Only at Command Available When you are a customer DBA at your client's site to do routine db data collection or planned health check tasks,… Read More »How to Resolve Only at Command is Available to Schedule Jobs
How to Monitor Unix Memory Usage by Processes
Monitor Memory Usage In Unix, you have many tools to monitor the overall memory usage, such as vmstat, sar, top and free. Using vmstat Command… Read More »How to Monitor Unix Memory Usage by Processes