Re: Sqltrace for someone else's session?

From David P.

There's too many undefined variables (in the loose sense of the word) in your situation.

The problem could be caused at many different points. Don't second-guess a) the location of the problem and b) how to diagnose your guess-of-a-problem.

In a system as involved as yours, you may make 10 times more work for yourself as you investigate each of your 'hunches' one after another. You may get lucky, or you may not.

We all like playing around with computers and database products but that's no excuse not to go back to Engineering first principles!

So in the case of remote ops on the 'net, gather statistics at the TCP/IP level FIRST.

[your_host_command_prompt]>netstat -a -n

[your_host_command_prompt]>netstat -a

[your_host_command_prompt]>netstat -a -n 5

and so on.

[your_host_command_prompt]>ping xxx.yyy.zzz.aaa

[your_host_command_prompt]>tnsping ....

[your_host_command_prompt]>netstat -e 5 (both on remote client and server)

These are the kind of things you should look at first. (p.s. syntax has to be adapted to your particular OS).

Once you have ensured that TCP/IP is running fine, the move one level up in the protocol stack to the Oracle networking sub-system.

And so on and so on.

If after all that you see is just a SQL statement with a resultset that's too large - THEN start to trace it and then tune it.

regards,

David P.

argosy22_at_my-deja.com wrote:
>
> HI all,
>
> We are using Oracle 7.3.4.
> and attempting to figure out what is happening on
> a database that is accessed via the web.
>
> I have used SQLTRACE to log what is happening with
> own session. Go into sqlplus and:
>
> alter session
> set sql_trace = true
>
> - do statements here.
>
> alter session
> set sql_trace = false
>
> - then look at the .trc file
>
> A remote user's session is hanging, and I am wondering
> if it is a database issue. Is it possible to set a trace
> for the user's remote session? How would I do it?
>
> Any other ideas?
>
> Thanks,
>
> Argosy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 15 2000 - 20:24:22 CST