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

In article <t1XX9.31539$jM5.80538_at_newsfeeds.bigpond.com>, "Howard says...
>
>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....?
>
>
>;-)

You know, I think we need to get Mark to add an extra stat if he could - another "OCR" for Oracle Content Rating. Sometimes our discussions here get a long way from the DB! BTW, I'm not saying that's a bad thing - I'm just as guilty (if not more so!) than others. :)

Pete
>
>"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
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Jan 23 2003 - 18:15:26 CST