No of archivelog generation between the period in RAC envirnoment [message #652903] |
Wed, 22 June 2016 02:18 |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear All,
While generating report for number of archivelog generated between the period is getting confused.
Below is the query I was using to generate report-
select count(*) from gv$archived_log
where dest_id=1
and applied='NO'
and completion_time between to_date('20/06/2016 09:00:00', 'dd/mm/yyyy hh21:mi:ss') and to_date('20/06/2016 18:00:00', 'dd/mm/yyyy hh21:mi:ss')
order by next_time desc;
Kindly help me out, to get correct report on RAC envirnoment. Here, thread is also making me confused.
Regards,
Ashish
|
|
|
|
|
Re: No of archivelog generation between the period in RAC envirnoment [message #652911 is a reply to message #652907] |
Wed, 22 June 2016 03:20 |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear Michel,
commented APPLIED='NO
I would like to know, how many number of archive log generated at ods-logical (query executed from ods-node1).
select count(*) from gv$archived_log
where dest_id=1
and completion_time between to_date('20/06/2016 09:00:00', 'dd/mm/yyyy hh21:mi:ss') and to_date('20/06/2016 18:00:00', 'dd/mm/yyyy hh21:mi:ss')
order by next_time desc;
'Here, thread is 1 & 2. Is this query is correct to get no of archive log generated at ODS?
|
|
|
|
|
|