Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp table question
On Sat, 3 Mar 2001 10:27:48 +1100, "Howard J. Rogers" <howardjr_at_www.com> wrote:
>And global temporary tables are private to the session that populated
>them -and a good thing too. One of their main benefits is that run like
>greased lightening, and they do that by not having any DML locking
>mechanisms. You can only forego record locks and the like when you can
>absolutely guarantee that no other user is going to start raising
>transactions that conflict or compete with your own... and *that* can only
>be guaranteed if the data is strictly private to your session.
>
>Regards
>HJR
Efficient multi access temporary tables could be implemented fairly
easily in several ways. If the data was kept in the SGA instead of
process space that would allow efficient and shareable access. There
would be some latching involved of course but latches are light
weight. With the data in the SGA one could allow other users to see
the data but not change it. Alternatively the first session could
release a temporary table which could be then obtained by another
session to be manipulated.
Oracle has done much more complicated things in a similiar vein with MTS and transaction processing.
Best
Kyle Hailey
Received on Sat Mar 03 2001 - 07:05:23 CST