Home » Server Options » Replication » How to know the log generation for an update statement (11g, 11.2.0.3, solaris10)
How to know the log generation for an update statement [message #622006] Wed, 20 August 2014 07:20 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Is there any view through which we can able to find out the number of log generation for the particular update or insert statements, IN LOGICAL STANDBY?



Regards,
Ishika

[Updated on: Wed, 20 August 2014 07:41]

Report message to a moderator

Re: How to know the log generation for an update statement [message #622013 is a reply to message #622006] Wed, 20 August 2014 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No there is none, you can do it with Log Miner at the primary site, or using a handler on the transmitted logical record to count the rows and store the result somewhere or you can add a trigger on the primary on insert or update to get the count of modified rows.

What actual problem are you trying to solve?

Re: How to know the log generation for an update statement [message #622099 is a reply to message #622013] Thu, 21 August 2014 01:55 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Since there was huge records got updated during the scheduled batch, at night. So, it's client requirement to know the log creation based on the update stmt.
Re: How to know the log generation for an update statement [message #622102 is a reply to message #622099] Thu, 21 August 2014 02:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is no such thing as log creation for an update. You have log creation for database activity and log records generation for a statement. This later information is not directly available. You can investigate the "solutions" I posted.

But the problem is the huge update.
How many is "huge"? what percentage of table?
Maybe another solution than knowing the number of redo records as, anyway, what can you do with this information?
So, once again, "What actual problem are you trying to solve?"



Previous Topic: Does Golden Gate support Table name starting with number?
Next Topic: How to replicate 50GB data every day
Goto Forum:
  


Current Time: Fri Mar 29 06:26:14 CDT 2024