On 19/05/11 10:28, P S Jameel Ahamed wrote:
> I tried a simple SQL with 100 records in the table and refcursor. The SQL
> response if I fire it in SQL developer or TOAD is 0.09 seconds
>
> But If I fire the same thing in Java program below is the analysis. You can
> clearly see that the when sta
27;Tim Bunce'
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
Try doing a very simple refcursor and see if you still have the same
performance issues.
John
From: P S Jameel Ahamed [mailto:jaha...@idexcel.com]
Sent: Wednesday, May 18, 2011 5:04 AM
To: 'John Scoles';
'; 'Martin Evans'; dbi-users@perl.org; 'Tim
Bunce'
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
When I say simple, I mean on a table with just a few rows. You may want to
look at how many rows are pulled back from the database at a time on your large
table (batching
:46 AM
To: P S Jameel Ahamed; 'John Scoles'; 'Martin Evans'; dbi-users@perl.org; 'Tim
Bunce'
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
Try doing a very simple refcursor and see if you still have the same
performance issues.
John
From: P S Jameel Ahamed [ma
___
From: John Scoles [mailto:byter...@hotmail.com]
Sent: 18 May 2011 12:21
To: jaha...@idexcel.com; Martin Evans; dbi-users@perl.org; carlso...@llnl.gov;
Tim Bunce
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
Does this have anything to do at all with DBD::Oracle???
You mentioned you are calling
12:21
To: jaha...@idexcel.com; Martin Evans; dbi-users@perl.org;
carlso...@llnl.gov; Tim Bunce
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
Does this have anything to do at all with DBD::Oracle???
You mentioned you are calling this with JAVA??
Where is the Perl code??
> From: jaha...@ide
here.
Perhaps you should rethink the refcursor idea or try spliting it up into two
or more calls
Cheers
From: jaha...@idexcel.com
To: byter...@hotmail.com; martin.ev...@easysoft.com; dbi-users@perl.org;
carlso...@llnl.gov; tim.bu...@pobox.com
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
Subject: RE: (Fwd) Re: DBD::Oracle Slow cursors
> Date: Wed, 18 May 2011 11:07:56 +0100
>
> Hi All,
>
> First of all I thank you all in replying to my email. Below are details of
> one of the SP which we are having issues with.
>
> In the below SP we are passing in a
D M.country_code = C.country_code)
);
OPEN rcSelectDashBoard FOR
SELECT dashboard_type as type, rec_count as
count, average_age, count_above_5days, count_closed_5days, avg_response_time
FROM tbl_qm_dashboard;
END sp_select_dashboard
On 17/05/2011 22:18, Tim Bunce wrote:
- Forwarded message from P S Jameel Ahamed -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamed
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
HI Tim,
We are facing huge iss
What is the issue exatly?
It is just slow??
Can you give us some examples code to play with.
Slowness can be caused by anything from low-ban width, poor SQL, a badly
partiioned DB or just too much data??
We need to know the version of DBD::Oracle you are using as well
Cheers
John
>
Don't use dynamic queries? You can use PL/SQL variables directly in the SQL
statement w/o specifying them as bind variables. That is, pass them as
parameters to your stored procedure, then just put them directly in the SQL
without decoration. Return XML CLOB instead of cursor?
Just some ide
Tim Bunce schrieb am 17.05.2011 um 22:18 (+0100):
> - Forwarded message from P S Jameel Ahamed
>We are facing huge issues with the SYS_refcurors of oracle
> 10G when returning from Stored procedure. Is there any solution
> you found for the issue?
Care to expand a little on what precisel
13 matches
Mail list logo