RE: Executing a query for the output without doing the SQLNet round trips
- From: Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx>
- To: "hkchital@xxxxxxxxxxxxxx" <hkchital@xxxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2009 18:29:20 +0100
Is the option to put the query in a job, which you schedule? A job always runs
in de serversite and will not give round trips.
Herald ten Dam
Superconsult
________________________________
Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens
Vishal Gupta [vishal@xxxxxxxxxxxxxxx]
Verzonden: dinsdag 3 februari 2009 18:13
Aan: hkchital@xxxxxxxxxxxxxx; sjaffarhussain@xxxxxxxxx; hkchital@xxxxxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Onderwerp: RE: Executing a query for the output without doing the SQLNet round
trips
Hemant,
If put an your query as inline view and do a count on non-indexed column, then
you will be able to all the physical/logical IO and table accces (full or by
rowid via index) in your query and can avoid SQL*Net round trips. If this what
you are after?
eg.
select COUNT(non-indexed-column)
from (
your query
);
Regards,
Vishal Gupta
http://www.vishalgupta.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Hemant K Chitale
Sent: Tue 03/02/2009 14:15
To: sjaffarhussain@xxxxxxxxx; hkchital@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Executing a query for the output without doing the SQLNet round
trips
That could reduce the number of round-trips yes. But I am doing a
local (BEQ) connection. Also, I really want to eliminate all
round-trips but still have Oracle fetch all the rows and columns.
At 02:14 PM Tuesday, Syed Jaffar Hussain wrote:
>How about playing around with SQL *Net Packet size parameters (SDU & TDU)?
>
>Regards,
>
>Jaffar
>
>--
>Best Regards,
>
>Syed Jaffar Hussain
>Oracle Certified Master (10g)
><http://www.oracle.com/technology/ocm/shussain.html>http://www.oracle.com/technology/ocm/shussain.html
Hemant K Chitale
http://hemantoracledba.blogspot.com
"A 'No' uttered from the deepest conviction is better than a 'Yes'
merely uttered to please, or worse, to avoid trouble."
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
