eaappprod21->UAS@(/export/home/oracle/paresh/uocuat)ipcs -A IPC status from as of Wed Aug 31 15:17:54 EDT 2005 T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID STIME RTIME CTIME Message Queues: T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME ISMATTCH Shared Memory: m 0 0x500004cf –rw-r–r– root root…
Read More “To seee semaphores and shared memory segments in Solaris” »
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”,…
