Use $ top last pid: 17552; load averages: 0.04, 0.03, 0.04 15:16:01 93 processes: 88 sleeping, 2 zombie, 3 on cpu CPU states: % idle, % user, % kernel, % iowait, % swap Memory: 8192M real, 3841M free, 2867M swap in use, 5629M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU…
use $psrinfo 0 on-line since 03/10/05 14:49:00 1 on-line since 03/10/05 14:49:09 4 on-line since 03/10/05 14:49:09 5 on-line since 03/10/05 14:49:09 8 on-line since 03/10/05 14:49:09 9 on-line since 03/10/05 14:49:09 10 on-line since 03/10/05 14:49:09 11 on-line since 03/10/05 14:49:09 12 on-line since 03/10/05 14:49:09 13 on-line since 03/10/05 14:49:09
exp userid=cs/cs file=cs_uocqa_30aug05.dmp owner=cs statistics=none exp userid=scsedb/scsedb file=scsedb_uocqa_30aug05.dmp owner=scsedb statistics=none exp userid=retaildb/retaildb file=retaildb_uocqa_30aug05.dmp owner=retaildb statistics=none exp userid=pnet/pnet file=pnet_uocqa_30aug05.dmp owner=pnet statistics=none exp userid=websitedb/websitedb file=websitedb_uocqa_30aug05.dmp owner=websitedb statistics=none imp userid=cs/cs file=cs_uocqa_30aug05.dmp fromuser=cs touser=cs imp userid=scsedb/scsedb file=scsedb_uocqa_30aug05.dmp fromuser=scsedb touser=scsedb imp userid=retaildb/retaildb file=retaildb_uocqa_30aug05.dmp fromuser=retaildb touser=retaildb imp userid=pnet/pnet file=pnet_uocqa_30aug05.dmp fromuser=pnet touser=pnet imp userid=websitedb/websitedb file=websitedb_uocqa_30aug05.dmp fromuser=websitedb touser=websitedb
/********* Wait.sql ************/ set pages 2000 set lines 132 column p1text format a18 column event format a35 column WT format 9999 column SW format 9999 select sid, event,p1text,p1raw,p1,p2,p3,seconds_in_Wait “SW”,Wait_time “WT” from v$session_wait where event not in( ‘KXFQ: Dequeue Range Keys – Slave’, ‘KXFQ: Dequeuing samples’, ‘KXFQ: kxfqcls – consumer closing TQ’, ‘KXFQ: kxfqdeq – dequeue…
Read More “Wait Based Tuning Step by step with SQL statement” »
Renaming oracle instance (from UOCTEST to UAS) Note : Remember to rename datafile, logfile, controlfile, parameterfile and passwordfile. Aslo need to change listener. ******** Parameter File *************************** (1) check whether instance is using SPFIlE. using “show parameter spfile” (2) SQL> connect / as sysdba SQL> “create pfile from spfile” in 10g by default it will…
How does one monitor and trace Unix processes? To trace what a Unix process is doing enter: truss -rall -wall -p truss -p $ lsnrctl dbsnmp_start NOTE: The “truss” command works on SUN and Sequent. Use “tusc” on HP-UX, “strace” on Linux, “trace” on SCO Unix or call your system administrator to find the equivalent…
Make sure the entry for your database SID in the ORATAB file ends in a capital “Y”. Eg: # $ORACLE_SID:$ORACLE_HOME:[N|Y] # ORCL:/u01/app/oracle/product/8.0.5:Y # The scripts for starting and stopping databases are: $ORACLE_HOME/bin/dbstart and dbshut. SQL*Net (or Net8) is started with the lsnrctl command. Add the following entries to your /etc/rc2.d/S99dbstart (or equivalent) file: su –…
Read More “How do I get Oracle to automatically start when my server boots up?” »
How does one list all installed Oracle products? One can display all installed products with version information by executing one of the following commands. For Oracle7 up to 8.0: cd $ORACLE_HOME/orainst ./inspdver For Oracle 8i and above: cd $ORACLE_HOME/install cat unix.rgs
Can one export directly to a tape drive? —————————————– One can use a tape device name instead of a normal file name. When using a device, one also needs to specify the VOLSIZE= parameter. Look at this example: exp userid/password file=/dev/rmt0 table=emp volsize=1.2G Note: The volume size is a number ending with a “m”, “k”,…
If one cannot afford to buy extra disk space one can run the export and compress utilities simultaneously. This will prevent the need to get enough space for both the export file AND the compressed export file. Eg: # Make a pipe mknod expdat.dmp p # or mkfifo pipe # Start compress sucking on the…
