Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Don't force a commit when gathering session level statistics on a global temporary table

John_KApr 26 2019 — edited Apr 26 2019

In recent versions of the database we're able to generate session level statistics on GTT's - i.e. that set of statistics is applicable only to your session This is great... however... as per normal statistics gathering, it forces a commit. however - why should this be the case?? The statistics are applicable to only your session, so there is no need for any other sessions to be able to see them.

My idea is to allow session level statistics on a GTT be gathered without the implicit commit. This would make it a lot easier to:

do some processing

insert into GTT

gather session stats on GTT

do some more processing

etc

Whereas now, the implicit commit gives you a non-atomic transaction.

Comments
Post Details
Added on Apr 26 2019
4 comments
1,339 views