SQL*Plus: Release 10.2.0.3.0 – Production on Sun Sep 21 16:32:13 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: xxxxx
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> spool sql.lst
SQL> select * from academic;
ACNUM DEPTNUM FAMNAME GIVENAME INITIALS
———- ———- ——————– ——————– ———-
** rows selected.
SQL> spool off
sql.lst is saved at your home directory.
1. Get vmware rpm server from http://www.vmware.com
2. Install vmware rpm
ns2 ~ # rpm -ivh VMware-server-1.0.7-108231.i386.rpm
3. Configure vmware with vmware-config.pl
ns2 ~ # /usr/bin/vmware-config.pl
agree license and where it says
“None of the pre-built vmmon modules for VMware Server is suitable for your
running kernel. Do you want this program to try to build the vmmon module for
your system (you need to have a C compiler installed on your system)? [yes] yes
Using compiler “/usr/bin/gcc”. Use environment variable CC to override.
Your kernel was built with “gcc” version “4.3.1”, while you are trying to use
“/usr/bin/gcc” version “4.3”. This configuration is not recommended and VMware
Server may crash if you’ll continue. Please try to use exactly same compiler as
one used for building your kernel. Do you want to go with compiler
“/usr/bin/gcc” version “4.3” anyway? [no] yes
4. after you install vmware is ready to use.
if you like to install VMware-mui-1.0.7-108231.tar.gz
download from www.vmware.com decompress install with ./vmware-install.pl
expect scripts for automated login with ssh connection.
set timeout 60
set PASS xxxxx
spawn /usr/bin/ssh root@ns2
expect “Password: “; send “$PASS\r”
To check File IO, this iotop is one of best solution.
“Linux has always been able to show how much I/O was going on (the bi and bo columns of the vmstat 1 command).
Iotop is a Python program with a top like UI used to show of behalf of which process is the I/O going on. It requires Python ≥ 2.5 and a Linux kernel ≥ 2.6.20.”
For Suse 11
Simply type “yum install iotop”.