Feroz DBA'S Blog

I have seen many people are facing issues/trouble to copy the files from the host machine to virtual box, here are the step how to copy the files/folders, Steps to copy the files using pendrive to virtual box: 1. Copy the required files to the pendrive. 2. After copied, simply disconnect and connect the pendrive again. 3. Go to currently running virtual box, select Devices-----> USB Devices ---> select your pendrive,       once selected it automatically install the pendrive drivers on the hosts to access the pendrive in the      virtual box. 4. go to Virtual box and copy the files. Select  Devices-----> USB Devices ---> select your pendrive  (for me the pendrive (HP v220w [1100])

Issue: You may come across the application users reporting that the database performance is slow, and that pint of time you may need to determine there are any systems resource bottlenecks on the reported database server. Cause:  There may be high memory utilization, high processes, high paging, high disk I/O utilization and CPU utilization Workaround Steps: A single OS command VMSTAT will  result all the above bottlenecks. Output of VMSTAT: Interpret the result of VMSTAT (virtual memory disk): These are the general guidelines to interpret the output:       a. If the wa (wait time for I/O) column is high, then it’s an indication that the storage subsystem is            overloaded and next is to investigate further the cause/source of I/O contention.       b. If b (process Sleeping) is continuously greater than 0, then it indicate the not enough CPU     ...