-
编辑 删除
新博开张 http://www.orafan.net
谢谢Kamus提供的空间，欢迎访问Oracle Tech Zone：http://www.orafan.net这里的文章将陆续转过去，并且不再继续更新
-
编辑 删除
查询session sid and serials, how to get Oracle session sid and serials
column program format a20column Name-User format a20column osuser format a20column process format a10select s.sid, s.serial#, s.SQL_ADDRESS, s.process , p.spid "OS Thread", b.name "Name-User", s.osus...
-
编辑 删除
查询等待的session
Find any waiting session , and you have to execute several timeto identify which one is the supicious oneset numwidth 10column state format a7 trucolumn event format a25 trucolumn last_sql format a40 ...
-
编辑 删除
非本机登录ASM实例 How to Login ASM remotely
In common, ASM instance is only access by database instance.DOC ID:340277.1Keyword: ORA-12541, ORA-15000, ORA-12528Solution:1. Edit listener.oraAddSID_LIST_LISTENER = (SID_LIST = &nb...
-
编辑 删除
How to delete old useless archivelog in FLASHDG diskgroup in ASM
If FLASHDG diskDG was not enough, delete previous days old archivelog and crosscheck archivelog in RMAN also(Please make sure we have archivelog backup before you delete themselect 'alter diskgroup D...
