Re: MSSQL Table Variable Equivalent?

Tom,

You made the following comment within the below discussion.

Your arguement, as I got it, was - leave the memory management to OS / DBMS as they do manage caches.

Please, remind me, if I'm wrong, but it is my impression that while OS / DBMS allocates memory the flag is available to mark if the memory page cachable / disposable.

If I have a page of data that might not be used for awhile, but is performance critical then I need it "in-memory" at all times to avoid caching overhead that in real-time critical apps might make a difference.

I'm not being a smart-seat, I'm truly asking.

thx, Oleg.

> Thomas Kytewrote:

In article
<1116884005.477841.45400_at_g49g2000cwa.googlegroups.com>,
> LineVoltageHalogen says...
>
> Greetings All, I was hoping that someone might be to help me out.
I
> was wondering if Oracle has a table data type like SQL server. This
is
> just a variable that lives completely in memory and has many of the
> characteristics of a table. I need to be able to store a list of
> values in a table like format in memory. I say memory because each
> session logging into the server will have to perform this operation
and
> I need it to be as fast as possible. I am aware of global temp
tables
> and that they reside in the temp tablespace. However, the data in
the
> temp table is written to the buffer cache which leads me to believe
> that there is a possibility that it could be written to disk too.
This
> would be a huge drain on performance. So, I would appreciate any
> feedback.
>
> TFD
>
>

Funny thing about caches -- if you use it they keep the data in memory, if you
do not use it, they page it out -- just like OS memory.

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle
Corporation[/quote]