Re: Query that returns 2 different results in 9iRAC and 10gRac

From: Brian <brian_at_databaseknowledge.com>
Date: 9 Mar 2005 16:49:36 -0800
Message-ID: <1110415775.994837.105980@f14g2000cwb.googlegroups.com>

In 9iRAC when connected to inst_id 1 the query result is: INST_ID

---

1
1

In 9iRAC when connected to inst_id 2 the query result is: INST_ID

---

2
2

In 10gRAC the when connected to either inst_id 1 or 2 query result is: INST_ID

---

1
2
1
2

The query came from a performance monitoring tool I was writing. I needed to query gv$session and sum the number of sessions per instance.  The query in 9i returns rows for only instance, whereas, in 10g the correct result is returned for all instances.

I thought it was odd, so I removed the fluff and broke the query down to it's basic components and sent it support. I have a work around in place, however it's very odd that Oracle didn't consider this a bug. Received on Wed Mar 09 2005 - 18:49:36 CST