Ashish, Please post the statistics that show 94% of your DB time is spent
waiting for the checkpoint to complete.
Also post your dbwr statistics.
Mark Powell
Database Administration
(313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Ashish Lunawat <ashish.lunawat@xxxxxxxxx>
Sent: Wednesday, September 5, 2018 5:37:09 AM
To: Oracle-L Freelists
Subject: Datapump import disable_archive_logging will still generate redo?
Hi,
I have a Oracle database version 12.2.0.1 running in noarchivelog mode. I`m
wondering if datapump import parameter TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y will
reduce the redo generated and thus improve the import timing?
I have an import of a LOB table which takes about 10 hours to import about
85GB of data. AWR reports show almost all the time spent on "log file switch
(checkpoint incomplete)" event. There were 3 redo log groups configured with
each member size 200MB.
I increased to 6 groups with each member 1.5GB but I am still getting these
wait events accounting to 94% of the DB time. And now the Avg wait for these
events has gone up to about 34 seconds from 7-8 secs last time.
How can I get rid of the log file switch (checkpoint incomplete) events?
Increase DBwriters? FAST_START_MTTR_TARGET?
Thanks
Regards,
Ashish
DXC Technology Company -- This message is transmitted to you by or on behalf of
DXC Technology Company or one of its affiliates. It is intended exclusively for
the addressee. The substance of this message, along with any attachments, may
contain proprietary, confidential or privileged information or information that
is otherwise legally exempt from disclosure. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient
of this message, you are not authorized to read, print, retain, copy or
disseminate any part of this message. If you have received this message in
error, please destroy and delete all copies and notify the sender by return
e-mail. Regardless of content, this e-mail shall not operate to bind DXC
Technology Company or any of its affiliates to any order or other contract
unless pursuant to explicit written agreement or government initiative
expressly permitting the use of e-mail for such purpose. --.
