Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_crd.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Manmohan Jalsingh
> *Sent:* Tuesday, May 08, 2007 4:28 PM
> *To:* Bradd Piontek
> *Cc:* oracle-l_at_freelists.org
> *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-lReceived on Tue May 08 2007 - 16:47:14 CDT
![]() |
![]() |