RE: V$SESSION_WAIT FILE# Doesn't Exist?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Jan 2011 08:42:52 -0600
I left off some information:
Using oradebug tracing this is what I'm seeing:
....
....
WAIT #113: nam='direct path read temp' ela= 36 file number=402 first dba=863060
block cnt=15 obj#=0 tim=354894654
WAIT #113: nam='direct path read temp' ela= 23 file number=402 first dba=863075
block cnt=15 obj#=0 tim=360224962
*** 2011-01-18 08:37:35.078
WAIT #113: nam='direct path read temp' ela= 38 file number=402 first dba=863090
block cnt=15 obj#=0 tim=365500363
WAIT #113: nam='direct path read temp' ela= 36 file number=402 first dba=863113
block cnt=15 obj#=0 tim=370692553
*** 2011-01-18 08:37:45.515
WAIT #113: nam='direct path read temp' ela= 36 file number=402 first dba=863128
block cnt=15 obj#=0 tim=375937276
WAIT #113: nam='direct path read temp' ela= 15 file number=402 first dba=863143
block cnt=15 obj#=0 tim=381208109
*** 2011-01-18 08:37:56.078
WAIT #113: nam='direct path read temp' ela= 33 file number=402 first dba=863158
block cnt=15 obj#=0 tim=386497479
WAIT #113: nam='direct path read temp' ela= 47 file number=402 first dba=863173
block cnt=15 obj#=0 tim=391782434
*** 2011-01-18 08:38:06.703
WAIT #113: nam='direct path read temp' ela= 36 file number=402 first dba=863188
block cnt=15 obj#=0 tim=397115158
WAIT #113: nam='direct path read temp' ela= 75 file number=402 first dba=863203
block cnt=15 obj#=0 tim=40232084
...
...
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
From: Taylor, Chris David
Sent: Tuesday, January 18, 2011 8:33 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: V$SESSION_WAIT FILE# Doesn't Exist?
Ok, I've got a "runaway session" in my PeopleSoft database that's been
processing since last night.
I have just now started working on this and I wanted to get some input:
SELECT p1 file#, p2 block#, p3 class#
FROM v$session_wait
WHERE event = 'direct path read temp'
;
File# Block# Class#
402 862533 15
SELECT relative_fno, owner, segment_name, segment_type
FROM dba_extents
WHERE file_id = 402
--AND &block BETWEEN block_id AND block_id + &block - 1;
NO ROWS FOUND
What??
If I look at both V$DATAFILE and V$TEMPFILE I have no File# = 402 so what is
going on?
Like I said, I just started working on this so I may be missing something
simple...
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
Other related posts:
