This forum is currently locked. You can't register or post questions at this time. (read more)

Global Temporary Tables

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

coolboy98699
Member
Posts: 6
Joined: Mon Jun 25, 2012 11:14 am

Global Temporary Tables

Postby coolboy98699 » Tue Jun 26, 2012 5:49 am

Sir i have a bit idea on GTT

means like 'on commit preserve rows' and 'on commit delete rows'

But i have doubt

1.in which situation we will use
2.Is there any perfomance gain by using them

Kindly reply !!!

Thank you very much

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Global Temporary Tables

Postby Tim... » Tue Jun 26, 2012 6:54 am

Hi.

If you want the data in the table for the life of your session, then you should use preserve, or the data will be lost on the first commit. If you are happy to throw away the data on commit, then use that. You are not going to notice a difference in performance, but freeing up unused temp space is a good idea as it is then available for other sessions to use.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

coolboy98699
Member
Posts: 6
Joined: Mon Jun 25, 2012 11:14 am

Re: Global Temporary Tables

Postby coolboy98699 » Tue Jun 26, 2012 7:04 am

Sir

Thank you very much for your reply

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Global Temporary Tables

Postby Tim... » Tue Jun 26, 2012 7:09 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests