That's what it looks like. I hate it when the database gets the blame.
I'll run a profiler and show them the completion of the calls.. and the
application is still trying to render the data..
Is there a profiler for Oracle?


Questions or comments?
619-955-5000 x1052

-----Original Message-----
From: Carolyn Jewel
[mailto:mssqldba-ezmlmshield-x79102250.[Email address protected]
Sent: Thursday, September 28, 2006 10:48 AM
To: LazyDBA Discussion
Subject: RE: DATABASE NOT PERFORMING

Monica:

Hmm. I'm a SQL Server DBA, so I can't speak to any Oracle issues.
However, my first thought is this isn't a DB issue. The problem is with
the radio link. My guess is it's timing out and dropping connections.
Maybe others on the list can comment further.

Carolyn J



<Monica said>
Our Oracle database is housed on a Unix platform The users use Staffware
forms to manipulate information in the database The database in located
in building2, users access it from building2 via a radio link.
Error messages they get are RPC connection to KIM failed (KIM = db
name), Staffware timed out etc etc
</Monica said>

> -----Original Message-----
> From: Carolyn Jewel
> [Email address protected]
> Sent: Thursday, September 28, 2006 2:58 AM
> To: LazyDBA Discussion
> Subject: RE: DATABASE NOT PERFORMING
>
> This is a pretty vague description of the problem you're having. Heck,

> it might not even be a database issue. More info would be nice. You
> can open up Profiler and see what the db is doing. In EM, you can
> check current activity and look for blocking etc. There's also sysmon
> and perfmon. What error messages are the users getting?
>
> Carolyn J
>
>
> -----Original Message-----
> From: Monica Abau-Sapulai
> [mailto:mssqldba-ezmlmshield-x69567267.[Email address protected]
> Sent: Tuesday, September 26, 2006 3:37 PM
> To: LazyDBA Discussion
> Subject: DATABASE NOT PERFORMING
>
> Is there a command I issue to see if the database is operating OK...
> Alot of users are complaining that they cannot issue DML's without
> ALWAYS receiving an error message
>
> Thanks
> MAS
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post

> a dba job: http://jobs.lazydba.com To subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page