Dan schrieb am 09.08.2010 um 18:04 (-0400):
> Hello,
> I just wanted to provide some closure on this "issue", we found out
> that there was a PIX firewall between the Perl app server and the
> Oracle database, and once we removed this, the problem did go away.
Good to see the culprit revealed (a
Hello,
I just wanted to provide some closure on this "issue", we found out that
there was a PIX firewall between the Perl app server and the Oracle
database, and once we removed this, the problem did go away. The network
guys were unable to find any reason why the firewall might be causing this
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I'm writing a short script which, as part of its normal operation,
> performs a SUM on values from a Postgresql database. When running the
> summation query from the command line interface of Postgresql, it
> looks like this:
>
> dev=> EXPLA
I'm writing a short script which, as part of its normal operation,
performs a SUM on values from a Postgresql database. When running the
summation query from the command line interface of Postgresql, it
looks like this:
dev=> EXPLAIN ANALYZE SELECT SUM(bytes) AS bytes FROM
files,users,files_heade
On 05/08/10 13:41, lokasu lokasu wrote:
> Thank you for your reply. Indeed I meant any "table", sorry for the
> confusion .
>
> I also get the expected results with:
>
> SELECT (2+3), cursor(select 2+3 from dual), cursor(select 2+3 from
> dual) FROM dual where rownum < 10
>
> 5 DBI::st=HASH(0x3