Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Logfiles in RAC database

Re: Logfiles in RAC database

From: Manmohan Jalsingh <mjalsingh_at_gmail.com>
Date: Tue, 8 May 2007 14:47:14 -0700
Message-ID: <7c4806e20705081447h59e019f5qa0078333723a4844@mail.gmail.com>


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-l
Received on Tue May 08 2007 - 16:47:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US