| archive log [message #486731] |
Sun, 19 December 2010 11:11  |
prashant_ora
Messages: 196
Registered: July 2010
|
Senior Member |
|
|
Hi,
I have a oracle 10g database running in archive mode.There is a batch job, in which 30 lacks records are inserting into a GTT(on commit preserve). Now my question is whether that batch process witll generate any archive because of the insert statement in GTT.
Thanks
|
|
|
|
|
|
| Re: archive log [message #486773 is a reply to message #486732] |
Mon, 20 December 2010 03:33  |
prashant_ora
Messages: 196
Registered: July 2010
|
Senior Member |
|
|
Thanks.
But the same table we are updating many times and as a result its generating lots of redo. In case of insert i am using /*+append*/ hint and because of that redo generation is very less. so there is any way to reduce the redo generation for update statement.
|
|
|
|
|
|
| Re: archive log [message #486783 is a reply to message #486779] |
Mon, 20 December 2010 04:05 |
prashant_ora
Messages: 196
Registered: July 2010
|
Senior Member |
|
|
Ok.
One question, please give me the answer. My database is in archive mode and the table inside the bacth process is the GTT(on commit preserve).Now I am logging the redo generation for every statement inside the batch with this query
SELECT VALUE
INTO V_REDO_SIZE
FROM V$STATNAME
JOIN V$MYSTAT
USING(STATISTIC#)
WHERE NAME = 'redo size';
Now my question is what's the use of generated redo once the batch finsih and the session close. We have a second server where archive is tarnsfer from the produciton to make it sync.So whatever the archive generates from the batch will transfer to second server or as soon as the batch finsih and session close , it will flush out the archive generated by batch for the gtt transaction. I am little bit confused. Please expalin this.
|
|
|
|
|
|
| Re: archive log [message #487083 is a reply to message #486787] |
Wed, 22 December 2010 10:37 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
Am I reading this correctly, you're getting "lots" of redo on a GTT? Are you sure the GTT interaction is the culprit?
Or do you mean relative to other GTTs?
|
|
|
|
|
|
| Re: archive log [message #487086 is a reply to message #487085] |
Wed, 22 December 2010 10:47 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
I agree, was just clarifying if that was actually the problem, maybe there are heavy index on the tables too, they'd cause it too.
More curiosity/point clarity than anything else 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
