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