Re: Table that exists only in memory

There are some possibilities. Specifically, if your platform is large enough, set your SGA db buffers and shared pool to huge (as big as you can go and not cause paging). Then you can pin the table to the shared area. Caveats: Best with small table and huge ram. If you are using V8.x, consider setting the table to NOLOGGING with CACHEing. Depending on table size, sga size,activity types, these may help.

The RAM disk can't hurt.

In article <368f9944.21846693_at_news.prestel.co.uk>,   Uge_at_VaxMan.prestel.co.uk wrote:
> Not an Oracle way. Oracle always generates rollback for read
> consistancy (perhaps for other users' benefit). The only exceptions
> are index creation, EXP and SQL*Loader where under some conditions you
> can avoid it.
> Your only hope is to either create a RAM disk at OS level and then
> force each transaction in your session to use a rolback you create in
> there, or buy a hardware solution which effectively does the same.
> Note however, that this will be unsupported and in the event of a
> failure, recovery may prove interesting.
>
> Eugene (Oracle Certified dba looking for work on NT or VMS platforms).
> ====================================
> robertch_at_mindspring.com (Robert Chung) wrote:
>
> >
> > I need a table that does not interact with hard disk but is stored
> > only in memory for performance boost. I will be modifying this table
> > big time, but never commit. I am afraid normal tables will modify
> > roll back segs while I update those tables (and therefore access hard
> > disk and slow down operation) but for this table, I will never be
> > commiting but I will be doing a lot of update and insert then rollback
> > everything. Is there any way to create special table like this?
> > Thanks in advance.
> >
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 05 1999 - 07:53:59 CST