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: Oracle's Myth: keep tables and indexes in separate tablespaces

Re: Oracle's Myth: keep tables and indexes in separate tablespaces

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 11 Oct 2003 16:38:00 +0100
Message-ID: <bm983g$djj$2$8300dec7@news.demon.co.uk>

The problem, I think, is that it's easy to argue the case in theory, but very hard
to set up a demonstration. You need
a high degree of concurrency with a
reasonable number of hard parses going
on to make the effect stand out. Building the test case realistically is time-consuming.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Iceland__November (tbc)
____Belgium__November (EOUG event)
____UK_______December (UKOUG conference)


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:3f881704$2$28122$afc38c87_at_news.optusnet.com.au...

> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3F869875.6305_at_yahoo.com...
>
> > I thought Steve's proof was fairly definitive - more latching. If
you
> > aren't getting on 'latch free' or CPU, then by all means, let the
pub
> > syns fly. Otherwise, buyer beware.
>
>
> I know that. You know that. Anyone with a gram
> of functioning grey matter knows that. Do you
> think for one minute it will stick with damagement
> unless it is underwritten by "credible" Oracle?
> Noooooo....
>
>
> --
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
>
>
Received on Sat Oct 11 2003 - 10:38:00 CDT

Original text of this message

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