RE: Logfiles in RAC database
- From: "Luca Canali" <Luca.Canali@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 May 2007 09:30:39 +0200
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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
