how to pull just a single member from v$logfile
From: godba blore <racoradba_at_gmail.com>
Date: Fri, 21 Nov 2008 13:57:35 -0500
Message-ID: <eae33bca0811211057p664f4f3au408e2da3a5ebc661@mail.gmail.com>
Date: Fri, 21 Nov 2008 13:57:35 -0500
Message-ID: <eae33bca0811211057p664f4f3au408e2da3a5ebc661@mail.gmail.com>
Hi group,
Need help in writing a query.
I have 6 groups in a database and in each of these groups I have 2 members.
I need to write a query where in it pulls only one member from each of the
group
select a.group#,a.thread#,b.member from v$log a,v$logfile b where a.group#=b.group#;
GROUP# THREAD# MEMBER
---------- ---------- --------------------
1 1 /dev/rorarptlv00801 1 1 /dev/rorarptlv00901 2 1 /dev/rorarptlv00802 2 1 /dev/rorarptlv00902 3 1 /dev/rorarptlv00803 3 1 /dev/rorarptlv00903 4 1 /dev/rorarptlv00804 4 1 /dev/rorarptlv00904 5 1 /dev/rorarptlv00805 5 1 /dev/rorarptlv00905 6 1 /dev/rorarptlv00806 6 1 /dev/rorarptlv00906
I know this is a wrong place to ask, but I think my dba community can help me out here.
Any help will be greatly appreciated.
Thanks in advance
Sam
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 21 2008 - 12:57:35 CST