Oracle Database Discussions

Is there any way to query the contents of a Global Temporary Table populated by another session?

that is, if:
- a global temporary table named MY_GTT has been created, once upon a time
- Session A has inserted rows into MY_GTT, and has issued a COMMIT
- From session B is there any way to query session A's view of MY_GTT?

Following this... is there any way to do it if process A has not committed?

This is for diagnostic purposes only - this is nothing that we would need to scale or automate.

Thanks,
Mike