Skip to content

Instantly share code, notes, and snippets.

@rochefort

rochefort/gist:1346802

Created November 8, 2011 02:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rochefort/1346802 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rochefort/1346802 to your computer and use it in GitHub Desktop.
Download ZIP
oracle memo
Raw
gistfile1.sql
-- 文字コード
SELECT VALUE FROM NLS_DATABASE_PARAMETERS
WHERE PARAMETER='NLS_CHARACTERSET'
-- lock
SELECT A.SQL_TEXT,A.ADDRESS FROM
V$SQLAREA A,V$SESSION B WHERE A.ADDRESS = B.SQL_ADDRESS
AND B.SID = ANY(SELECT SID FROM V$LOCK WHERE TYPE IN ('TX','TM'));
--SELECT * FROM V$SESSION
SELECT SID, SERIAL# FROM V$SESSION
WHERE SID IN (
SELECT SID FROM V$LOCK
WHERE TYPE IN ('TM','TX'))
alter system kill session '21, 388'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment