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

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 - 07:45:49 CST