Re: p1 in v$session

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 25 Nov 2003 12:46:39 -0000
Message-ID: <bpvj9s$h0i$1$8302bc10@news.demon.co.uk>

That looks like an oddity in reporting.
Convert the number of hex, then each
pair of digits is an ascii letter, reading "beq" for bequeath protocol.

It looks as if the wait should be reading something like: "SQL*Net message from client".

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"freCho" <svenson1_at_libero.it> wrote in message
news:pan.2003.11.25.10.53.19.540387_at_libero.it...


> Hi all,

> I have a question about p1 column in v$session_wait.

> We use Oracle 8.0.6.2.0 Enterprise Edition on solaris 7 server.

> The query "select p1 from v$session_wait where sid in (....)  returns the

> number 1650815232. The event for the sessions is "buffer busy waits".

> This values is not an existing file_id in dba_data_files.

>

> Note:181306.1 from metalink does not help.

>

> Any ideas??

>

> thank's

Received on Tue Nov 25 2003 - 06:46:39 CST

Re: p1 in v$session_wait