Unix

How to Monitor IO Performance and Disks Activities on Solaris

by Ed Chen
February 12, 2014November 22, 2022

Mostly, we can monitor overall IO activities by using "top" in Solaris, in there, an indicator called "iowait" can be a good target to watch:$… Read More »

How to Estimate File Space Usage by du

by Ed Chen
September 26, 2013November 22, 2022

Command "du" is very common tool to calculate the overall used space in Unix and very useful in tracing potential growing files and directories. For… Read More »

External Procedures May Consume a Lot of Memory

by Ed Chen
April 7, 2013March 31, 2018

External procedures are very special procedures stored outside of the database, and it can be coded by C or Java language. Since the external libraries… Read More »

How to Comment Out a Huge Block of Shell Code

by Ed Chen
March 10, 2013November 22, 2022

You might want to comment out some lines of shell script code during debug-time, you can just add a pound sign # to the head… Read More »

ksbsrv: No Startup Acknowledgement From Forked Process After 30 Seconds

by Ed Chen
February 26, 2013March 28, 2018

If the database server was in performance bottlenecks, there could be various kinds of errors. Here is one case of low memory. First of all,… Read More »

How to Monitor UNIX CPU Usage by Process

by Ed Chen
December 18, 2012April 1, 2018

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 »

Irix Mode vs. Solaris Mode in Top Command

by Ed Chen
December 15, 2012July 5, 2018
4 Comments

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 »

How to Remove ^M Character from Files

by Ed Chen
December 11, 2012December 19, 2022

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 Monitor Real-Time Top SQL on CPU Consuming

by Ed Chen
December 6, 2012March 28, 2018

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 Clean ASM Candidate Disks

by Ed Chen
November 9, 2012February 24, 2021

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 »