[sqr-users] How SQR program is connection to the database

[yelena_kontorovich@baxter.com]

Hello, everyone,
I'm tracing my SQR programs trying to figure out where the time is going
and it looks that some of my programs are "chatty" - too many calls to the
database and waits for SQL*Net messages to and from client were really
high.  For some program I can change business logic, for some I can't.  Our
DBA have changed network protocol in tnsnames.ora from TCP to BEQ, and I
see that it is taking BEQ protocol:

  oracle  5784  5766  5 16:21:58 ?       10:59 oracleTEST (DESCRIPTION
=(LOCA
L=YES)(ADDRESS=(PROTOCOL=beq)))

but I don't see any difference in SQR execution time.  Theoretically it
should be a huge difference between connection thru the network vs
connection locally.  For me it means that connectivity is set up somewhere
else.

We are Unix/Oracle shop running PeopleSoft, so we call SQR using PeopleSoft
pssqr program:

sqr $PS_HOME/sqr/$sqr_name -PRINTER:LP -XTOC -XLFF -XTB -f$PS_LOG/output/
${name}.lis -i\
$PS_HOME/ctmsqc/,$PS_HOME/user/sqr/,$PS_HOME/sqr/ \
-ZIF$PS_HOME/sqr/pssqr.bax $ORA_PASS $ORACLE_SID |tee $PS_LOG/log/
${name}.log

I don't have a source code for this program, only binary code, so I don't
know how parameters are being used.

Does any body know if there is additional parameter somewhere which defines
SQR connectivity to Oracle?  I hope I made myself clear, if you have any
additional questions - please ask.

Thanks,
Yelena Kontorovich
Technical Consultant
847.948.2927
yelena_kontorovich@baxter.com
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, re-transmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.  If you received
this in error, please contact the sender and delete the content.


------------------------------------------------------------------------------
The information transmitted is intended only for the person(s)or entity to
which it is addressed and may contain confidential and/or legally privileged
material.  Delivery of this message to any person other than the intended
recipient(s) is not intended in any way to waive privilege or confidentiality.
Any review, retransmission, dissemination or other use of , or taking of any
action in reliance upon, this information by entities other than the intended
recipient is prohibited.  If you receive this in error, please contact the
sender and delete the material from any computer.

For Translation:

http://www.baxter.com/email_disclaimer
==============================================================================

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