Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Empty table - many extents

Re: Empty table - many extents

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 11 Aug 2003 17:35:28 -0700
Message-ID: <73e20c6c.0308111635.6daf6570@posting.google.com>


Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA7040EBEF8_at_lnewton.leeds.lfs.co.uk>...

> Richard may well have all those problems - but at least his Buffer cache
> hit ration will be higher than 99%, so his database will be fully
> optimised and tuned.
>

Hmmmm. If I replace all my SQL by "select * from dual", do you think I'll end up with an optimised and tuned database as well? Or should I use bind variables? <d&r, vvf>

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

PS: To the troll cancelling my earlier posts: it's boring. And childish. And incompletely done... Received on Mon Aug 11 2003 - 19:35:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US