select s1.username || ‘@’ || s1.machine
|| ‘ ( SID=’ || s1.sid || ‘ ) is blocking ‘
|| s2.username || ‘@’ || s2.machine || ‘ ( SID=’ || s2.sid || ‘ ) ‘ AS blocking_status, s1.SQL_ID
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and […]

Popularity: 15% [?]

path: …/Oracle Home/bin/orakill.exe or find manually
command: orakill <sid> <spid>
example: C:\Oracle9\bin\orakill ORCL 2760

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F11%2F15%2Fkill-sesion-oracle-in-windows%2F’;
addthis_title = ‘kill+sesion+oracle+in+windows’;
addthis_pub = ”;

Popularity: 13% [?]

Popularity: 13% [?]

The ” tcopy ” tility used to copies the magnetic tape mounted on the tape drive specified by the source argument. Simply, the ” tcopy ” used for copies one tape to another tape.
Rewind the tape first
# mt -f /dev/rmt/0 rewind
# mt -f /dev/rmt/1 rewind
And […]

Popularity: 15% [?]

$ su - oracle
SQL> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
If No Response
SQL> shutdown abort
Monitoring Instance when restart database
$ tail -f $ORACLE_HOME/admin/bdump/alert_$ORACLE_SID.log

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F07%2F18%2Fshutdown-oracle%2F’;
addthis_title = ‘Shutdown+Oracle’;
addthis_pub = ”;

Popularity: 9% [?]

Popularity: 9% [?]

Monitoring Commands
nmon
vmstat
iostat
sar
topas
nmon
svmon
filemon
rmss

addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F07%2F05%2Fperformance-monitoring%2F’;
addthis_title = ‘Performance+Monitoring+Commands’;
addthis_pub = ”;

Popularity: 11% [?]

Popularity: 11% [?]

To get your wwn at your Solaris machine, you can use this command
# prtpicl -v | grep wwn
:node-wwn 50 01 04 f0 00 5f 0a 85
:port-wwn 50 01 04 f0 00 […]

Popularity: 18% [?]

System boot process:

Power on
PDC executes CPU, Memory and other tests
PDC initialize the console to display messages
Looks for Primary boot path
It loads and executes Initial System Loader (ISL). Roll of boot ROM ends.
ISL loads the secondary system loader called “hpux”. It resides on boot area of the disk
“hpux” loads “/stand/vmunix” into memory and hands control over […]

Popularity: 23% [?]

This optional software, you must install Ignite-UX, work only in HP-UX 11.11 n later
And only root
# print_manifest | more
System Information
Your Hewlett-Packard 9000 computer has software installed and
configured as follows.
The system was created January 09, 2003, 12:10:05 SST.
It was created with Ignite-UX revision B.4.1.61.
————————————————————-
NOTE: You should retain this information for future reference.
————————————————————-
Serial number: XXXXXXXXX
Order number: […]

Popularity: 19% [?]