한참까먹고 있다가.. 오늘에서야 적용..

http://gyuha.tistory.com/405 를 참조하였다.

-- active session list
col sid for 999
col sql_text for a20
col event for a10
col sid new_value sid
 select
        to_char(h.sample_time,'mi:ss') as sample_time,
        h.session_id as sid,
        h.session_state as st,
        h.sql_id,
        (select sql_text from v$sqlarea a where a.sql_id = h.sql_id) as sql_text, event,
        blocking_session as blocker
 from
        v$active_session_history h
 where
        sample_id = (select max(sample_id) from v$active_session_history)
        and session_id <> userenv('sid')
;
사용방법은


지원 문법


Brush nameBrush aliasesFile name
ActionScript3 as3, actionscript3 shBrushAS3.js
Bash/shell bash, shell shBrushBash.js
ColdFusion cf, coldfusion shBrushColdFusion.js
C# c-sharp, csharp shBrushCSharp.js
C++ cpp, c shBrushCpp.js
CSS css shBrushCss.js
Delphi delphi, pas, pascal shBrushDelphi.js
Diff diff, patch shBrushDiff.js
Erlang erl, erlang shBrushErlang.js
Groovy groovy shBrushGroovy.js
JavaScript js, jscript, javascript shBrushJScript.js
Java java shBrushJava.js
JavaFX jfx, javafx shBrushJavaFX.js
Perl perl, pl shBrushPerl.js
PHP php shBrushPhp.js
Plain Text plain, text shBrushPlain.js
PowerShell ps, powershell shBrushPowerShell.js
Python py, python shBrushPython.js
Ruby rails, ror, ruby shBrushRuby.js
Scala scala shBrushScala.js
SQL sql shBrushSql.js
Visual Basic vb, vbnet shBrushVb.js
XML xml, xhtml, xslt, html, xhtml shBrushXml.js


'6. 먹고살기 > 6.2 기타' 카테고리의 다른 글

분석기  (0) 2018.08.13
.vimrc setting  (0) 2012.09.13
I/O fencing  (0) 2012.05.31
syntaxhighlighter  (0) 2011.09.06