(Hemant K Chitale) In 11gR2, I have demonstrated how Gather_Stats on a Global Temporary Table defined as ON COMMIT DELETE ROWS actually does a COMMIT before gathering statistics thus actually deleting the rows before gathering statistics.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help