Hello all,
I think problem solving is an art. No one can know every solutions for every
problems. If we don't use a methodical way, in other words if we use
TEST-AND-SEE way, we waste our time. We should not jump into problem
immediately.
For your case:
A- Problem: session/db hangs
We don't kno
Oracle supports response to my answers was to increase SHMMAX from 128M to
4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but
when I questioned why we should increase SHMMAX to more than 2x the real
memory on the machine, the answer was "I had my Unix Guru look at these and
Well, unfortunately we haven't solved the problem yet, so I don't have any
solutions to share with everyone.
We are using Sun hardware, and we have not run diagnostics on the memory. I
don't want to dismiss that idea out of hand, but I don't understand how bad
memory could be affecting only one
I am sure that you don't have any invalid objects after the patch
application. I had a lot of problem with that after a patch application
two years ago.
Sharon
--
Xiaohong Yang (Sharon)
certified Oracle DBA
Center for Bioinfomatics, CB#7100
S
Please let us know how you fixed the problem.
Are you using Sun Hardware? can you run diagnostics for the memory?
Are you connecting using IPC(meaning direct) or through TCP(network)?
Is it the network that is causing problem?
--- "Grabowy, Chris" <[EMAIL PROTECTED]> wrote:
> We have a partic
There are many things you can do to diagnose a system that is totally
unresponsive.
You should spool output from v$session_wait joined to v$session every
minute so that you have a record of what people started getting hung
up on leading up to the hang. This might allow you to trigger a
systemsta
Here is the latest on the Oracle hangs issue from the DBA working it...
--
In 8.1.7.2 we had frequent crashes, and Oracle told us to upgrade to 8.1.7.3
to solve that. The crashes then turned into these hangs. The problem is
our hangs ar
Chris,
Just do a ORADEBUG HANGANALYZE and upload the trace file to
http://www.unal-bilisim.com 's Hanganalyzer.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Chris
Sent: Monday, March 18, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
We have a particul