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

This one's a trick question, Richard!!

I've seen that welcome brochure for the home for the permanently bewildered before, though I can't remember how or why.

You still checking in there every alternate Wednesday? I thought they'd asked you to refrain from doing so, because you were upsetting the other residents? Or am I confusing you with someone else....?

;-)

"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:15:26 CST