Re: external table access hangs
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: Dave.Herring@xxxxxxxxxx
- Date: Mon, 26 Feb 2007 23:01:52 -0500
On 02/26/2007 12:20:07 PM, Herring Dave - dherri wrote:
> Nothing in bad or discard file. This is all that's in the logfile:
Ok. What does "hang" really mean? What does V$SESSION_WAIT say?
Did you locate the accessing process? Did you try with strace/truss?
Did you try dumping process and system states and ask Oracle Corp. to
investigate, the process known as "opening a TAR"? When you say that
process hangs, does it look like this?
|/|
|/|
|/|
|/|
|/|
|/|
|/| /¯)
|/|/\/
|/|\/
(¯¯¯)
(¯¯¯)
(¯¯¯)
(¯¯¯)
(¯¯¯)
/¯¯/\
/ ,^./\
/ / \/\
/ / \/\
( ( )/)
| | |/|
| | |/|
| | |/|
( ( )/)
\ \ / /
\ `---' /
`-----'
--
Mladen Gogala
http://www.mladen-gogala.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
