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

Home -> Community -> Usenet -> c.d.o.server -> p1 in v$session_wait

p1 in v$session_wait

From: freCho <svenson1_at_libero.it>
Date: Tue, 25 Nov 2003 11:53:19 +0100
Message-ID: <pan.2003.11.25.10.53.19.540387@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 - 04:53:19 CST

Original text of this message

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