Re: Oracle hints

On Wed, 30 Jan 2008 01:10:42 -0800, sybrandb wrote:

Oracle is also merciless for people not using bind variables.

No it isn't. CURSOR_SHARING=FORCE

Oracle is merciful. Halelujah!

--
Mladen Gogala
http://mgogala.freehostia.com
.

Relevant Pages

  • Re: Free Oracle Server for intranet?
    ... Mladen Gogala wrote: ... Express Oracle is a serious toy, ... standard edition, license fee is $4500/CPU. ...
    (comp.databases.oracle.server)
  • Re: unknown files in /tmp
    ... Mladen Gogala wrote: ... developing purposes. ... In directory /tmp I found some files I've never seen before: oracle ... files were created on startup, the other part on 5:00 the ...
    (comp.databases.oracle.server)
  • Re: 5.1.2 woes
    ... Mladen Gogala wrote: ... > Application connects to Oracle 10.2. ... Are you sure the extension was compiled correctly? ... Prev by Date: ...
    (comp.lang.php)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... Mladen Gogala, 10.11.2008 13:05: ... Oracle should have a look at the source code as they now ... I think rdb had data partitioning built in long before Oracle was even thinking about it. ... I'm definitely not a fan of SQL Server but I like transactional DDL and SQL Server isn't the only one to have this. ...
    (comp.databases.oracle.server)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... Mladen Gogala, 10.11.2008 11:56: ... meaningfully monitor the system and run explain plan on SQL statements. ... Oracle should have a look at the source code as they now own that product:) ...
    (comp.databases.oracle.server)