Tom,
Wow, where to begin?
First, what OS and what version of Oracle are you using. I can compare it to
mine. It has never "crashed" the box or for that matter caused any problems,
it ran on 6.5 to 7.0
You can turn on system file logging, using SYSLOG from Allegro. Run the Oracle
gateway, then analyze the log files to determine the number of records read.
This could show a serial vs. index read issue.
Are you using any tools, like Glance to monitor the Gateway to determine if it
is heavy I/O? Finally, do you have the memory dump, maybe you could send a
snapshot of PROCESS_CURRENT and post it to the list.
Finally, you may want to check the TNS names file for corruption or changes.
Good luck.
-Craig
--- "Emerson, Tom" <[log in to unmask]> wrote:
> I'm kind of coming in on the tail end of this myself, but it seems we have a
> process on an Oracle database [if you can say "ON an oracle database..."]
> that is accessing an Image database via Oracle's "gateway" [which I've just
> learned today is "unsupported"]
>
> this process has run fine for (years, months, whatever...) and "all of a
> sudden" caused a system failure. That's right -- flat out crashed the box.
> I'm "told" that "no changes" have occurred [but I'll bet you've heard that
> song-and-dance before...] (*) and this "process" has worked with at least
> twice as many records as the current input file; it has also processed the
> input file "on another system" without error, but crash dumps are pointing a
> finger at this "gateway" and something to do with a memory leak or bounds
> violation [you can imagine my skepticism of THAT -- yes, this can happen, but
> it shouldn't bring down the box...]
>
> [unless for some UNGODLY reason Oracle decided they MUST use PM rather than
> remain in "user space" as they say in Unix-land]
>
> Does any of this sound familiar? Is there a particular version of the
> "gateway" that I should be looking for? [or at least to pass along to the
> sysadmin to check against]
>
> I've also learned that this system is excruciatingly slow -- it is taking
> upwards of a minute PER TRANSACTION [and on a 4-way box to boot!] so I'm
> suspecting the "query" that is being used is, shall we say, "less than
> optimal"? [can you say, "serial read of the entire dataset..."? I thought
> you could...] Is there any way I can prove [or disprove] this theory? [for
> instance, where would I look for a "log" file showing what transactions are
> occurring? I'm thinking something like the "odbclog" that is written by the
> ODBC listener for normal "allbase/sql/PC" traffic...]
>
> Tom
>
> (*) OK, confirmed that "no changes" was indeed a bit of a fib: the process on
> the Oracle side of things has had a change rolled in on the day this problem
> started. Not enough to point the finger solidly yet, because if the problem
> is inherent in the gateway, it was just "waiting to happen" and might have
> happened regardless of changes to the oracle process...
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
