Re: SQL*Net message to client

  • From: Ray Stell <stellr@xxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 24 Nov 2005 10:24:29 -0500

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: