Re: Statistics for comp.databases.oracle.server - WE 19/1/2003

Don't we search on tahiti anymore!!

It's from the "Oracle 9i Database Administrator's Guide".

Text made by you Richard??

Peter

"Telemachus" <telemachus_at_ulysseswillreturn.net> schreef in bericht news:muRX9.4729$V6.6903_at_news.indigo.ie...
> SQL Reference ?
>
> Everyone's learning.... ;-)
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:scRX9.31375$jM5.80043_at_newsfeeds.bigpond.com...
> > Hi all,
> >
> > *This is for real*
> >
> > "You create authenticated links by specifying the CONNECT TO clause,
> > AUTHENTICATED BY clause, or both clauses together in the database link
> > creation statement. For example, you can issue:
> > CREATE DATABASE LINK sales CONNECT TO scott IDENTIFIED BY tiger USING
> > 'sales';
> > CREATE SHARED PUBLIC DATABASE LINK sales CONNECT TO mick IDENTIFIED BY
> > jagger
> > AUTHENTICATED BY david IDENTIFIED BY bowie USING 'sales';"
> >
> > Honest
> >
> > Richard
> >
> > "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
message
> > news:3e2fd874$0$247$ed9e5944_at_reading.news.pipex.net...
> > > I can't resist
> > >
> > > "One popular approach to manual I/O distribution suggests separating a
> > > frequently used table from its index. This is not correct. During the
> > course
> > > of a transaction, the index is read first, and then the table is read.
> > > Because these I/Os occur sequentially, the table and index can be
stored
> > on
> > > the same disk without contention. It is not sufficient to separate a
> > > datafile simply because the datafile contains indexes or table data.
The
> > > decision to segregate a file should be made only when the I/O rate for
> > that
> > > file affects database performance."
> > >
> > > :(
> > >
> > > --
> > > Niall Litchfield
> > > Oracle DBA
> > > Audit Commission UK
> > > *****************************************
> > > Please include version and platform
> > > and SQL where applicable
> > > It makes life easier and increases the
> > > likelihood of a good answer
> > >
> > > ******************************************
> > > "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
> > > news:ppPX9.4693$V6.6776_at_news.indigo.ie...
> > > > Yep. Congrats.
> > > >
> > > >
> > > > Someone else have a go.
> > > > "Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
> > > > news:3e2f084f_3_at_mk-nntp-1.news.uk.worldonline.com...
> > > > > "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
> > > > > news:U9yX9.4542$V6.6723_at_news.indigo.ie...
> > > > > >
> > > > > > guess the manual without searching tahiti.. scout's honour
> > accepted.
> > > > > > <easy!>
> > > > > >
> > > > > > "An authalic sphere is a sphere that has the same surface area
as
> a
> > > > > > particular oblate ellipsoid of revolution representing the
figure
> of
> > > the
> > > > > > Earth."
> > > > > >
> > > > > Spatial?
> > > > >
> > > > > Regards,
> > > > > Paul
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Thu Jan 23 2003 - 13:57:47 CST