Hallo out there,
ist there a way to find out which session uses a specific GTT and thus preventing its modification?
I'm trying to modify a GTT and keep getting
14450 - "attempt to access a transactional temp table already in use"
So is there a way to find out, which session it is?
I found an SQL that gives the usage of temporary tablespace per session but not groken down to the name of single GTTs.