| Archive log file generating [message #488629] |
Mon, 10 January 2011 04:57  |
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  |
 |
Michel Cadot
Messages: 68648
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 |
John Watson
Messages: 8931
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
). gv$archived_log sees the data concerning all the instances, so you have to only query it on one node to get the information for all of them.