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

Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor sharing on Win32 - 'the safe bet?'

Re: Cursor sharing on Win32 - 'the safe bet?'

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 05 May 2007 21:26:31 GMT
Message-ID: <pan.2007.05.05.21.26.31@verizon.net>


On Fri, 04 May 2007 18:38:58 -0700, DA Morgan wrote:

> SELECT sid, process, program
> FROM gv$session
> WHERE service_name like '%BACKGROUND%';
>
> No wonder this query doesn't work.
>
> You expected to find SQL in gv$session ... why? SQL has never been
> there.

Well, there have been things like SQL address and SQL hash. In the version 10, there is an additional ID column. All of those are used to look at the SQL statement executed by the session you're interested in.

>
> The fact that you can't look at something doesn't mean the product is
> broken. In fact one might argue that it means the product is working as
> designed.

Daniel, with all due respect, please stop with the platitudes and patronizing. I consider that extremely annoying. I've let go of the incorrect advice when you tried to tell me that I have to configure DSA keys for my SSH in the RAC environment, but this is too much.

This has worked in all the versions before Oracle 10 and doesn't work in Oracle 10. This is, partly, explained in the note 370648.1 and partly in the documentation for the bugs it points to. There are no mysterious features here, just broken code. Even Oracle Corp. admits its fault here so please, do not try to BS me. Pretty please, with sugar on top.

-- 
http://www.mladen-gogala.com
Received on Sat May 05 2007 - 16:26:31 CDT

Original text of this message

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