Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Avoiding generating redo logs

Re: Avoiding generating redo logs

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 17 Sep 2006 09:16:12 -0500
Message-ID: <uejua5rr0.fsf@rcn.com>


On Sat, 16 Sep 2006, jeremy0505_at_gmail.com wrote:
> Environment as in sig.
>
> I am a little puzzled about the logging_clause when creating a
> table. We are designing a web application which will have use , at
> times, a table to hold a "cache" for a user. For example, a query is
> executed which takes a few seconds. We store the results in the
> "cache" and then the user can sort and filter on that "cache". This
> cache I envisage as a table structure with its PK being the user_id of
> the user logged in. The data in this table is of no lasting value as
> it is just a redult of a query.
>
> I wanted to design this, if possible, so that there is no redo
> generated for DML performed on this table.

Why do you need to worry about redo?

-- 
Galen Boyer
Received on Sun Sep 17 2006 - 09:16:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US