Re: [sqr-users] How SQR program is connection to thedatabase-- clarification

["George Jansen" <GJANSEN@aflcio.org>]

Yelena,

You're welcome. Sorry I wasn't clear; to elaborate

1. My point is that "SQL*Net message to client" is not necessarily a
useful measure. My tiny script allows you to run that wait event
arbitrarily high, whether you are connected through BEQ or over a
network. Same system, same time of day, yet the wait time increases
directly with the sleep interval between fetches. (See below.)

2. The two runs you quote vary only because one connected via MTS,
which throws my quick-and-dirty accounting off.

3. I don't know about complex calculations, because I don't know what
your SQR is doing. Is it a standard PeopleSoft SQR? If so, which? In
either case, do you know, within your SQR, where the time is going?

George Jansen

P.S. One more screen shot:

/tmp>sqr snooze.sqr scott/tigress 1
SQR V4.3.2.2
Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.

SQL*Net message from client -> 521
SQL*Net message to client -> 0

SQR: End of Run.
/tmp>sqr snooze.sqr scott/tigress 10
SQR V4.3.2.2
Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.

SQL*Net message from client -> 5015
SQL*Net message to client -> 0

SQR: End of Run.
/tmp>sqr snooze.sqr scott/tigress 100
SQR V4.3.2.2
Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.

SQL*Net message from client -> 50015
SQL*Net message to client -> 0



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users