Re: Logfiles in RAC database

Guang,

The gv$log view is listing all threads for both instances. That's what I
found confusing. It would be nice if the view had a column to indicate which
thread is actually mounted to a particular instance.

Thanks
Manmohan


On 5/8/07, Guang Mei <GuangMei@xxxxxxx> wrote:


 No, each instance has it's own thread#.  From my 2-node rac db:



SQL> select  INST_ID,THREAD# from gv$log;



   INST_ID    THREAD#

---------- ----------

         1          1

         1          1

         1          2

         1          2

         2          1

         2          1

         2          2

         2          2



8 rows selected.



Guang
  ------------------------------

*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Manmohan Jalsingh
*Sent:* Tuesday, May 08, 2007 4:28 PM
*To:* Bradd Piontek
*Cc:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: Logfiles in RAC database



Thanks.

Looks like I have to specify both inst_id and thread# on join between
gv$logfile and gv$log. Any idea why just one of them
is not enough. Isn't  instance #1 should means thread#1 and instance#2
means thread#2.   May be I am missing something.

<snip>

Other related posts: