Re: Disabling logging on tables

Chloe Crowder wrote:
>
> Hi
>
> is there any way (in 8.1.7) of switching off logging on specific
> tables? We have a system where the redo log IO rate is of concern
> (lots of log file sync waits being caused). A significant amount of
> the logging is on tables which are only used to store "session" data,
> which would not be of use or interest in the event of a recovery being
> required. The business has agreed that these tables are not required
> to be recovered (they are in fact cleared out on a regular basis
> anyway).
>
> Looking at the ALTER TABLE NOLOGGING command, this only seems to
> impact bulk-load type operations.
>
> Unfortunately the system is a third-party application, so I have no
> control over how the application operates, but any other bright ideas
> would be appreciated.
>
> Chloe Crowder

'log file sync' are often due to an excessive amount of commits (as opposed to purely excessive work, and hence excessive redo).

Could the tables concerned by temporary ? or are they more persistent than a session?

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------