hard-parse - the "first" time a query is presented to
oracle - it has to do ALL of the work - is it valid ?
syntax ? privs etc etc etc
soft-parse - its been used before, but someone else
now wants to run it. Its the same sql, but we still
need to check privileges etc
hth
connor
- Raymond Lee Meng Hong <RAYMOND_at_infopro.com.my>
wrote: > Hello Christopher,
>
> What is the meaning of hard parse / soft parse on
> the article on 'Are
> synonyms really bad?'
> Latch mean for what ???
>
> Sorry for asking sooo stupied question. but I just
> start my DBA knowledge
> .previously I'm a informix developer.
>
> I have download some really good article from your
> site about Oracle
> concept and standard , in order to growth out my
> knowledge of oracle.
>
>
>
> -----Original Message-----
> Sent: Monday, May 21, 2001 9:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thank you, no actually it is Bill Gates mutating
> into the devil. Then
> scaring the pants off the mouse.
> Was bored :)
>
>
> Christopher,
> www.vampired.net
>
> -----Original Message-----
> Sent: Monday, May 21, 2001 3:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Chris,
>
> Is that you, bellow your main page?
> I mean before that guy mutates to something else of
> course. : )
>
> You have lot of experience and know lots of
> technology.
>
>
> Sinardy.
>
> -----Original Message-----
> Spence
> Sent: Saturday, 19 May 2001 4:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Some of you already know me from Lazyda list, some
> of your don't (prob
> glad). Well I have been working on putting up yet!
> another dba portal site.
> I have articles, scripts, and forums. I been really
> busy lately fire
> fighting a huge new product of ours, so I haven't
> got as much content as I
> wanted to have by now, but i do have about 45
> articles and 30 or so scripts.
> Most of the famous and popular (or ones I liked)
> articles are already up
> their as I always had them an arms reach away. Feel
> free to contact me
> (please use email on site) for any additions one may
> feel appropriate. And
> unlike OTHER lists, none of the information on the
> site I claim as my own
> unless it is of course, my own. Everyone who
> participates gets due credit
> and there are no royalties with the site either (go
> figure heh?).
>
> Now that everyone is asleep from me running on, here
> is the URL:
>
> www.vampired.net Aka Vampire D's Oracle Den.
>
> Christopher,
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Christopher Spence
> INET: cspence_at_FuelSpot.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Sinardy Xing
> INET: sinardyxing_at_bcsis.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Christopher Spence
> INET: cspence_at_FuelSpot.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Raymond Lee Meng Hong
> INET: RAYMOND_at_infopro.com.my
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue May 22 2001 - 02:46:05 CDT
