Archive log file generating [message #488629] |
Mon, 10 January 2011 04:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_d
Messages: 117 Registered: December 2007
|
Senior Member |
|
|
Hi ,
I want to know how many archive log generating in One hour at the peak time.
We have 6 nodes RAC multiplex 2.
Is there are any query through which I can achieve the above purpose.
Note: As this is a prod instance client is not happy to implement Log Miner utility.
Regards-
P
|
|
|
|
|
|
|
|
|
Re: Archive log file generating [message #488662 is a reply to message #488661] |
Mon, 10 January 2011 07:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
On one of our 2 nodes RAC, I have:
SQL> select inst_id, count(*) from gv$archived_log group by inst_id;
INST_ID COUNT(*)
---------- ----------
2 3136
1 3136
All nodes are aware of the other ones archived logs. It is the condition to be able to be able to recover the other instance modification and release the resources (locks) in case of a node failure.
Regards
Michel
[Updated on: Mon, 10 January 2011 07:07] Report message to a moderator
|
|
|
Re: Archive log file generating [message #488681 is a reply to message #488662] |
Mon, 10 January 2011 09:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Precisely! The view has the same rows twice.
It's the same with all the gv$ views that are populated from the controlfile: gv$datafile or gv$logfile will give you each file twice.
|
|
|
|