Hi All,
Need help here
I want to know regarding performance of oracle in Linux
Suppose oracle db is inastelled in a partition like /dev/sda5
Oracle DBA's are cpomplaining that Oracle db is running very very slow, means its giving poor performnca somehow, Though it was running fine before
How to troubleshoot in above secenerio
I have given the iostat command but i need to know what we need to check wid below commands
iostat -x command
I belive that iowait should not been high for the disk, if suppose its giving high i/o wait , then what to ask to DBA Guys to make something which makes in less i/o wait
what all other paramaters we need to check in iostat command and what should be ideal value of iowait so that we need not to worry?
Is vmstat is suitable in above scenerio?
I belive that in vmstat we need to check bi bo, si so paramaters, what should be the ideal value of these fields
Please let me know about your inputs to troubleshoot the situation like dis
My second question
Suppose a system is having 2GB of swap , I checked and found that its giving high memory blocks at buffer/cache+ in "free -m" command say about 1.5GB is there in buffer/cache +, what is meaning of that??
I belive that buffer/cache management is done by kernel itself and if a program is executing frequently and taking swap, so kernel keeps it in buffer /cache so that it dont .need to fatch it from Hard disk and access it much faster.
1 High Buffer/cache in "free -m" command is good for system or bad?
2. Low Buffer/cache in "free -m" is good for system or bad?
Supose If i installed a new Linux OS, and i don't see much process running on the system but i would see that high buffer/cache+ in that? why is it so?
My 3rd Question
Suppose I installed the new kernel in Red Hat Linux and want to switch to that kernel without rebooting the system, Is it possible?? ( Its a physical system , no xen or VM env is there in it)
I have searched and found there is a utility called kexec available but you need to install it , Is any other way is there to do that??
My 4th question
How to find its a Storage or local disk? I got the explanation by Dragon City but its unclear to me, as per him it depends upon the vendor, but i belive its not as we need not to know abt the vendor abt the same
DragonCity any more inputs here? I have a partition and I wana know wheather its a local or SAN.....
As per my last thread i mentioned the cat /proc/scsi/scsi0 file and i talked abt dmesg | grep -i attach to know the same, but still it is not so much clear to me
My fifth question
Is there is any way to limit the memory to certain processes/users in linux
I belive that we can do from ulimit command, Can someone tell is it ok ? If yes please let me know how to make it permanent? I belive we need to make entry in some file but i dont remember
Could I have your valuable inputsfrom all experts?
Thanks all
Gaurav
