RE: Logfiles in RAC database

From: Luca Canali <Luca.Canali_at_cern.ch>
Date: Wed, 9 May 2007 09:30:39 +0200
Message-ID: <B18EB20A5208EB4DBE0DD2412549861C310283@cernxchg47.cern.ch>

Have a look at v$thread. Ex:

select instance,thread# from v$thread;

Cheers,
L.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manmohan Jalsingh
Sent: Tuesday, May 08, 2007 11:47 PM
To: Guang Mei
Cc: oracle-l_at_freelists.org
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_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 2

2 1

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 Wed May 09 2007 - 02:30:39 CDT