Re: query taking a long time to run via sqlnet

2003-11-06 Thread Zabair Ahmed
I have included the following in my sqlnet.ora trace_file_client = osstrace_timestamp_client = truetrace_level_client = 16 Am no expert on interpreting the trace file and Oracle are not being very helpful at the moment. "M.Godlewski" [EMAIL PROTECTED] wrote: Zabair, Have you tried trace?

Re: query taking a long time to run via sqlnet

2003-11-06 Thread M.Godlewski
Zabair, Have you tried trace? Did you check trace route to see how many hops it makes to the database server?Zabair Ahmed [EMAIL PROTECTED] wrote: I've got the follwing piece of code which takes almost 3 seconds to run when I execute it on the server itself using sqlplus. DECLARE p_xml_in

query taking a long time to run via sqlnet

2003-11-05 Thread Zabair Ahmed
I've got the follwing piece of code which takes almost 3 seconds to run when I execute it on the server itself using sqlplus. DECLARE p_xml_in LONG(32760); p_xml_out LONG(32760);BEGIN p_xml_in :=