Re: AWR interpretation
From: Brent Day <coloradodba_at_gmail.com>
Date: Wed, 30 Oct 2013 16:03:40 -0600
Message-ID: <CAEz8shw7vLW-bRZktn5GenYDTYF_kOP6JpUT-ea=6hJTwN9zoQ_at_mail.gmail.com>
Not sure I saw a version number but have you looked at commit_write for 10g or commit_logging/commit_wait in 11.1+
These may help you reduce the log file sync wait time and improve your load.
Date: Wed, 30 Oct 2013 16:03:40 -0600
Message-ID: <CAEz8shw7vLW-bRZktn5GenYDTYF_kOP6JpUT-ea=6hJTwN9zoQ_at_mail.gmail.com>
Not sure I saw a version number but have you looked at commit_write for 10g or commit_logging/commit_wait in 11.1+
These may help you reduce the log file sync wait time and improve your load.
As always, please make sure you understand the implications of changing these and the potential for data loss. If I was in your situation I would set this at the session level for my load.
Brent
> Question 1) If I up the redo log file size during import this should cut
> down on log file syncs?
> Question 2) IS this high DC CPU mean my CPU's are spending their time only
> focused on DB things? A good thing? Or is this high a count during an
> import a bad thing?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 30 2013 - 23:03:40 CET