Re: Oracle hints
From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 30 Jan 2008 01:10:42 -0800 (PST)
Message-ID: <0b57944a-2b96-408f-b15e-ccd31f6a3b3c@k39g2000hsf.googlegroups.com>
Date: Wed, 30 Jan 2008 01:10:42 -0800 (PST)
Message-ID: <0b57944a-2b96-408f-b15e-ccd31f6a3b3c@k39g2000hsf.googlegroups.com>
On Jan 30, 3:05 am, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
> For a one time query, and if I were to make many of these, caching in
> the V$SQLAREA is not necessary.
>
> Is there any Oracle hint to allow me to do that?
>
> Thanks.
There is no such hint.
Oracle is merciless for people building unscalable applications.
Oracle is also merciless for people not using bind variables.
Please try to learn Oracle.
-- Sybrand Bakker Senior Oracle DBAReceived on Wed Jan 30 2008 - 03:10:42 CST