RE: Logfiles in RAC database

Have a look at v$thread. Ex:
 
select instance,thread# from v$thread;
 
Cheers,
L.

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manmohan Jalsingh
Sent: Tuesday, May 08, 2007 11:47 PM
To: Guang Mei
Cc: oracle-l@xxxxxxxxxxxxx
Subject: 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>

         


--
http://www.freelists.org/webpage/oracle-l


Other related posts: