Concurrency Global Temporary Table

Question

I have a global temp table that is set as commit on commit. How does it relate to the concurrency problem? I mean, what happens if another session wants to use this global temporary table? The answer probably will not be "they have the same data."

Now, if my guess is correct :), is the table locked until the first connection occurs, or does dbms create a global tempo table for each connection? (something like a table instance?)

Answer 1

In the documentation:

The data in the temporary table is visible only to the session that inserts the data into the table.

.

, Oracle , DML . DML (Insert, Delete, Update) .

DDL (: ALTER TABLE...)