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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Net message to client

Re: SQL*Net message to client

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Thu, 24 Nov 2005 10:24:29 -0500
Message-ID: <20051124152429.GA8806@cns.vt.edu>


Using my desktop email client - $450
Hardware for Oracle server - $25000

Oracle license -             $1000000
Listing with Jonathan -     priceless  


On Wed, Nov 23, 2005 at 10:53:12PM -0000, Jonathan Lewis wrote:
>
> select view_definition from v$fixed_view_definition
> where view_name = 'GV$SESSION_WAIT'
> /
>
> This gives the definition of (g)v$session_wait in
> terms of the underlying X$ objects, and shows
> you the way in which some of the v$ columns
> are derived by decodes from (particularly)
> the microsecond wait time.
>
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
> Cost Based Oracle: Fundamentals
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 4th Nov 2005

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 24 2005 - 09:26:59 CST

Original text of this message

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