Re: external table access hangs

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

--
http://www.freelists.org/webpage/oracle-l


Other related posts: