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

try to nslookup the above site and let us  know wheather its resolving or not,

make sure to edit entry /etc/resolv.conf for remote computer

nslookup www.test.com

I did work in GLADE (GTK programming ) but its about 6 years back, so don't remember much

Anyways you can see below link, it have information to make a splash screen

http://aspn.activestate.com/ASPN/CodeDoc/Gtk-Perl/Gtk/cookbook.html

I have little idea for SAN disk
If you see the /proc/scsi/scsi file it wi give you information like below

Attached devices:
Host: scsi0 Channel: 00 Id: 00 Lun: 00
  Vendor: HP 36.4G Model: MAN3367MC        Rev: HP05
  Type:   Direct-Access                    ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 00 Lun: 00
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003
  Type:   Unknown                          ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 00 Lun: 02
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003
  Type:   Direct-Access                    ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 00 Lun: 03
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003
  Type:   Direct-Access                    ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 01 Lun: 00
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003
  Type:   Unknown                          ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 01 Lun: 02
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003
  Type:   Direct-Access                    ANSI SCSI revision: 02
Host: scsi2 Channel: 00 Id: 01 Lun: 03
  Vendor: COMPAQ   Model: HSV110 (C)COMPAQ Rev: 2003

Above indicates that HSV110 is a storage disk  and it also give the LUN numbers with scsi information

Like here it shows scsi2 is a san disk

if you wana know abt the SAN partition  do this

 dmesg | grep -i "attached "
Attached scsi disk sda at scsi0, channel 0, id 0, lun 0
Attached scsi disk sdb at scsi2, channel 0, id 0, lun 2
Attached scsi disk sdc at scsi2, channel 0, id 0, lun 3
Attached scsi disk sdd at scsi2, channel 0, id 1, lun 2

It gives the required partitions on LUN with scsi information, compare it with o/p of /proc/scsi/scsi LUN's , you wil get to know that sdb,sdc and sdd are SAN disks.

Hi Bro
Yes I was very very busy in my official work,lot of work..., so tel me howz life boss

Hi All,
Sorry loggin'g after a long long time but was very busy in other stuff.

Could anyone please tel how to differnciate between local and SAN disk in linux/solaris?
I checked google and found that /proc/scsi/scsi can tel about this but after checking this also I am not sure how to judge that..........like STK is clear that its a SAN disk
 Really its not so clear how to judge

could anyone please help?

Thanks
Gaurav

sorry not able to get you, please elobrate your requirement

For iptables tutorials check www.linuxhomenetworking.com

I m not sure wheather give exclude options with restoration or not

On thing more if you don't want to restore /sys , then its better to not to backed up at time of creation of tar file
tar -cvzf file.tar.gz / --exclude /sys

I m not sure wheather  u can able to see journilising file................., Anyways ext3 is a filesysytem and u cn see the partotions from /etc/fstab file

/etc/fstab contains all the partitions with the file system type information...........

you can see the size of any ext3 type partions, from df -h commad

hi
 if you want to redirect a partial data, you can try these commands

head -1000 oldfile >> newfile

and if u want to extract data from a middle of file, you can try the ombination of head and tail or you can try below

sed '12,36!d' oldfile >> newfile

or

sed '12,36p' oldfile >> newfile

Above commands will extract the lines from 12 to 36 from oldfile and append it into new file
try both above commands  as  I am not very much sure about  which from above sed command runs , as i dont remember much , but you can give a try above

Thanks
Gaurav

Hi Jaffry,
I have login'd to linux formed after about 8-9 months, now its totay changed, really its looking vry good...., Thanks all for your effort...............

Thanks
Gaurav

Hey bro dragoncity...., how are u mate?

Yeah dragoncity , the question  is quite confusing..........,pls eleborate ganeshgore81 


Thanks
Gaurav

Hey
I have worked wid GLADE 4 years back, Its like VB++ i.e Drag and drop, I am not able to remember much but you can assign click response to your button,

Here i m trying to make a simple project wid a window and button placed on it :


suppose u have added a window and drag some button on it, just go to button properties and on signals tab assign the event on click.......

and after the designing of windows , just click on  Build source code and it will create 6 or 8 files on the desired path named callsback.c callsback.o, main.c,main.o, {srry was not able to recall,}

 to make event  happen , u have to do changes in callsback.c

like it create the code somethg like this


on _button1_clicked {

}



In glade each object is called a widget, just write somethg like this ( By de way I m not sure as I am not able to recall)

So write somethg like dis on above block: { This code if runs perfectly .  , will open a new window whenever u click the button there }
window1=create_window1(); or window1=gtk_widget_create_window1();
{ Try both , as i am not sure which one is right or search google)

gtk_widget_show(window1);  { This is right , here i m assuming that u named window as window1 }

Try and after that
#./congiure
#make
and executing ur project as
#./project1 {where project 1 is  name of project }

Thanks
Gaurav

We were talking about shell scripting , search google to know more.

Thanks
Gaurav

Srry Login after a long time , Its Great to hear that it worked for you

Thanks
Gaurav

   Recommend LS
   Linux User Around