INSERT INTO...SELECT into a TEMP table is executing for very long time.It is running for last 3 hrs and expected to insert 2000 records into the temporary table.
This is GLOBAL temporary table with ON COMMIT delete clause.TEMP table is having an index and the explain plan shows a cost of 8000 for the select query.
Also there is no errors seen related to tablespace yet.DB is Oracle 12c.
Any idea how we can debug the issue.