Created
January 23, 2023 17:39
-
-
Save xtender/bcd1d8b935c4abd7672d3b0b7bb099e2 to your computer and use it in GitHub Desktop.
v$bh.objd of a global temporary table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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