Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is thread# in gv$archived_log?

Ashish Kr MahantaJun 22 2016 — edited Jun 24 2016

Dear All,

We are generating report for the count of archived log at respective nodes, 2 node RAC database. Below is the script to get the result..

select count(*) from gv$archived_log

where dest_id=1

and completion_time between trunc(sysdate)+9/24 and trunc(sysdate)+18/24;

here for example, same sequence is available on both the nodes but threads are showing as 2.

So getting complex to get the proper result.

Please guide me to get the result

Regards,

Ashish Kumar Mahanta

This post has been answered by BPeaslandDBA on Jun 22 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2016

Added on Jun 22 2016

#performance-availability, #rac-asm-clusterware-installation

5 comments

2,081 views