常用sql大全oracle
| 阿里云国内75折 回扣 微信号：monov8 |
| 阿里云国际，腾讯云国际，低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号：monov8 飞机：@monov6 |
一
查看占用端口进程
lsof -i:26807
grid 14038 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 14039 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 14040 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))查看占用端口进程是否为后台进程，通过查询可以看出，占用端口的操作系统进程SPID 14038、14039、14040，对应会话连接类型TYPE均为USERS，即应用连接会话，而非BACKGROUND后台进程。
SELECT s.sid, s.serial#, s.status,s.username, s.osuser,s.sql_id, p.spid, p.terminal, s.program,s.type
FROM gv$session s, gv$process p
WHERE s.INST_ID=p.INST_ID and s.paddr = p.addr order by program;
SID SERIAL# STATUS USERNAME OSUSER SQL_ID SPID TERMINAL PROGRAM TYPE
---------- ---------- -------- ------------------------------ ------------------------------ ------------- ------------------------
1831 11 INACTIVE SYS grid 14039 UNKNOWN iatrack@ORCL01(TNS V1-V3) USER
1709 29 INACTIVE SYS grid 14038 UNKNOWN iatrack@ORCL01(TNS V1-V3) USER
1953 3 INACTIVE SYS grid 14040 UNKNOWN iatrack@ORCL01(TNS V1-V3) USER
1099 3 INACTIVE SYS grid 12075 UNKNOWN oraagent.bin@ORCL01(TNS V1-V3) USER
1038 3 INACTIVE SYS grid 12073 UNKNOWN oraagent.bin@ORCL01(TNS V1-V3) USER
1160 3 INACTIVE SYS grid 12077 UNKNOWN oraagent.bin@ORCL01(TNS V1-V3) USER
1343 5 ACTIVE grid 74899 UNKNOWN oracle@ORCL01(ASMB) BACKGROUND
672 1 ACTIVE grid 12045 UNKNOWN oracle@ORCL01(CKPT) BACKGROUND
550 1 ACTIVE grid 12041 UNKNOWN oracle@ORCL01(DBW0) BACKGROUND
428 1 ACTIVE grid 12037 UNKNOWN oracle@ORCL01(DIA0) BACKGROUND
367 1 ACTIVE grid 12035 UNKNOWN oracle@ORCL01(DIAG) BACKGROUND| 阿里云国内75折 回扣 微信号：monov8 |
| 阿里云国际，腾讯云国际，低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号：monov8 飞机：@monov6 |