: (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; Carlson
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
sp_select_dashboard;
Thanks
P S Jameel Ahamed
-Original Message-
From: Martin J. Evans [mailto:martin.ev...@easysoft.com]
Sent: 17 May 2011 23:00
To: jaha...@idexcel.com; dbi-users@perl.org
Subject: Re: (Fwd) Re: DBD::Oracle Slow cursors
On 17/05/2011 22:18, Tim Bunce wrote
) 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 Username and then for that user are
fetching his counts
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
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...@idexcel.com
...@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 this with JAVA??
Where is the Perl
: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 [mailto:jaha...@idexcel.com]
Sent
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 rows).
John
-Original Message
- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamed jaha...@idexcel.com
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
HI Tim,
We are facing huge
Tim Bunce schrieb am 17.05.2011 um 22:18 (+0100):
- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com
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
: (Fwd) Re: DBD::Oracle Slow cursors
- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamed jaha...@idexcel.com
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
HI
Date: Tue, 17 May 2011 22:18:22 +0100
From: tim.bu...@pobox.com
To: dbi-users@perl.org
CC: jaha...@idexcel.com
Subject: (Fwd) Re: DBD::Oracle Slow cursors
- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel
On 17/05/2011 22:18, Tim Bunce wrote:
- Forwarded message from P S Jameel Ahamedjaha...@idexcel.com -
Date: Tue, 17 May 2011 16:11:04 +0100
From: P S Jameel Ahamedjaha...@idexcel.com
To: tim.bu...@pobox.com
Subject: Re: DBD::Oracle Slow cursors
X-Mailer: Microsoft Office Outlook 11
14 matches
Mail list logo