Mladen Gogala wrote:
> 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.
My apology for taking your request literally. I thought you were really
expecting to literally find "SQL" there.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat May 05 2007 - 19:04:21 CDT
