Skip to content

Instantly share code, notes, and snippets.

@foobarbaz-pl

foobarbaz-pl/session_holding_gtt.sql

Created August 6, 2020 10:17
Show Gist options
  • Save foobarbaz-pl/93629bb1a37084f6e1e8536f78207779 to your computer and use it in GitHub Desktop.
Save foobarbaz-pl/93629bb1a37084f6e1e8536f78207779 to your computer and use it in GitHub Desktop.
Download ZIP
Session Using Global Temporary Table
Raw
session_holding_gtt.sql
select sid
from v$lock
where type = 'TO'
and id1 = (select object_id
from dba_objects
where object_name = '&temp_table_name');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment