"Ramamurthi, Radha" wrote:
>
> Hi:
>
> Nologging will generate reduced logging only under certain direct
> operations. If your application is not using them, it does not help. I
> thought in oracle8i tables such as you describe could be created as
> temporary tables within the application. That should reduce the redo
> considerably. You should talk to the vendor.
>
> Radha
>
> -----Original Message-----
> From: John Podoletz
> To: LazyDBA.com Discussion
> Sent: 6/28/02 2:06 PM
> Subject: selective archiving
>
> Hi,
>
> Is there a way to selectively stop archiving of an apps tables?
>
> We have a purchased an oltp application that has a function, based on
> the user's lookup/query, writes large amounts of data into temp
> application tables, the data is then manipulated, presented to the user,
> and is then deleted.
>
> Correct me if I'm wrong but each time the data is written/committed to
> the temp app table and then deleted a redo/archive before/after images
> are captured.
>
> I would like to shut off archiving to the temp app tables if possible.
Thanks alot to all of you. Thats what I thought
Podo
>
> Recovering the temp app tables isn't an issue.
>
> Could I use nologging option on the tables?
>
> Thanks for your time.
>
> Podo
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page