Re: Help understand raw trace data.

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Sun, 6 Sep 2009 08:32:51 +1000
Message-ID: <77a615a70909051532n213e868coe4541bc53129c994_at_mail.gmail.com>

It's early for me, but what exactly is your question?

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

2009/9/6 Fred Tilly <ftilly_at_btinternet.com>

> Hi,
>
> The procedure accepts the following parameters:
>
> ALOGID NUMBER;
> AINTREF VARCHAR2(50);
> ACLIENTTYPE NUMBER;
> ACLIENTID VARCHAR2(20);
> ACLIENTSUBID VARCHAR2(50);
> ASTARTTIME varchar2(20);
> ACHANNEL NUMBER;
> AINITUSERGROUP NUMBER;
> AINITUSERGROUPNAME VARCHAR2(50);
> AINITUSERID VARCHAR2(100);
> AINITUSERNAME VARCHAR2(50);
> AREFERENCE VARCHAR2(50);
> ADATA VARCHAR2(500);
> AVERIFIED CHAR(1);
> ACLIENTCATEGORY NUMBER;
> ACLIENTNAME VARCHAR2(255);
> AENDDATE varchar2(20);
>
> And it is being called via JDBC, but I have no access to the calling
> routine.
>
> The main problem is that this query is used by a telephone based
> application and at times takes 2 seconds or more to respond but most of the
> time it has a subsecond response. However the database is being blamed but I
> do not think this is the case, I am looking at gathering evidence and the
> trace was my starting point.
>
>
> Thanks
>
> Fred
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Sat Sep 05 2009 - 17:32:51 CDT