| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table that exists only in memory
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).
>
> 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.
>
>
Received on Sun Jan 03 1999 - 10:50:29 CST
 |
 |