How are you loading the data?
Trying to attract traffic to your site?
Senior Oracle DBA
We are using Sqlldr
is there any Marchioness, we find out the calculation of archive_log generation only upload the data.
Can you clarify the question? Are you looking to measure the amount of redo generated, or reduce it?
This link give scripts to give you idea about how to find ,, how much redo is generated.
Since you are using SQL Loader, you can use direct patch insert option to load data. Make sure that object in which data is inserted is in NOLOGGING mode
>Make sure that object in which data is inserted is in NOLOGGING mode
only has meaning when DIRECT=YES is specified
I feel obliged to point out the risk with NOLOGGING mode - it's a nice way to reduce redo generation, but means that your table may not be recoverable in the event of media failure. Ensure you understand the risks and coordinate with your DBAs.
>> only has meaning when DIRECT=YES is specified
Below is the usage of the DIRECT=YES
sql loader Input file: dupli_recods.txt
sqlldr controlfile: sqlldr_ctl.txt
into table dup
fields terminated by ","
C:\windows\system32>sqlldr joint/joint d:\ctl.txt direct=y
SQL*Loader: Release 18.104.22.168.0 - Production on Tue Aug 26 15:36:29 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 3.
Hello, couple of questions:
1) Are you trying to determine if the upload is responsible for all that redo, or do you already know that for a fact?
2) To what purpose you need to quantify it? FRA/arch_dest sizing, standby implementation, backup strategy...?
3) Can you afford loosing that data?
>I have Faced a issue related to archive log generation is very HIgh.
yes, DML generates REDO & REDO will be archived when it is enabled.
The ONLY way to reduce the amount of archived log generation is to do less/fewer DML; INSERT, UPDATE & DELETE