Re: 10g: chaining pipelined functions is slow

From: Frank Bergemann <FBergemann_at_web.de>
Date: Sat, 9 Oct 2010 00:29:31 -0700 (PDT)
Message-ID: <5fd4e27d-6e67-4bd2-90d7-587f57b88c54_at_28g2000yqm.googlegroups.com>

Hi John,

On 8 Okt., 23:51, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> [...]
>
> What version exactly of 10g?  Are you patched up ( somewhat? ... not
> at all ? )?

Here it is:

SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production

Unfortunately i have no rights to execute 'opatch' on the system. Is there another way to get a list of patches? - e.g. via ' connect sys as sysdba' ?
(However, i assume, that our IT department is up to date with oracle patches for the given oracle version.)

>
> What platform etc?  Have you looked for existing bugs on metalink?

The platform is:

host> uname -a
SunOS padsol40 5.10 Generic_141444-09 sun4u sparc SUNW,SPARC- Enterprise Solaris

But what do you mean with 'bugs on metalink'?

• thanks!

best regards,
Frank Received on Sat Oct 09 2010 - 02:29:31 CDT