Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORACLE TCP Comunication

18 views
Skip to first unread message

Sids

unread,
Jun 7, 2004, 9:52:25 AM6/7/04
to
Hi All,

I would like to capture the traffic of a oracle server & oracle clinet
exist on the same machine. would like to capture all the query coming
through loopback.. i have put my program between tcp & ip layer to
capture the loopback traffic .. but seems it uses some sharred memory
.. could any body lemme know the parameters i need to change to
disable the shared memory uses


Thanks in advance

regards

Michael Austin

unread,
Jun 7, 2004, 10:26:36 AM6/7/04
to
Sids wrote:

Operating system and versions??? what applicatin are you using to make
the connection? SQL*Plus? homegrown? what does your connect statement
look like? Depending on OS etc... using username/password@sid (must
have TNSNAMES and Listener properly configured) will generally force it
to use the network as it's transport.

Michael Austin.

Sids

unread,
Jun 8, 2004, 12:55:43 AM6/8/04
to
Michael Austin <mau...@firstdbasource.com> wrote in message news:<wW_wc.4940$xS6...@newssvr22.news.prodigy.com>...

Thanks Michal,

I am using sql*plus. actally i need to know which parameter i need to
change to force it to use network as it's transport.

thanks

Frank van Bortel

unread,
Jun 8, 2004, 2:03:51 PM6/8/04
to
Sids wrote:

sqlnet.ora configuration file.
Add:
trace_level_client= [OFF, USER, ADMIN, SUPPORT]
Look for a .trc file

--

Regards,
Frank van Bortel

0 new messages