Skip to content

Instantly share code, notes, and snippets.

@xtender
Created January 23, 2023 17:39
Show Gist options
  • Save xtender/bcd1d8b935c4abd7672d3b0b7bb099e2 to your computer and use it in GitHub Desktop.
Save xtender/bcd1d8b935c4abd7672d3b0b7bb099e2 to your computer and use it in GitHub Desktop.
v$bh.objd of a global temporary table
select
o.owner
,o.object_name
,o.object_type
,o.temporary
,so.*
,bh.*
from dba_objects o, SYS.X$KTSSO so
,v$bh bh
where so.ktssoobjn=o.object_id
and so.ktssoobjd=bh.objd
--and object_name='GTT name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment