Note in-line.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Jan 21st 2005
"Richard Foote" <richard.foote_at_bigpond.nospam.com> wrote in message
news:A9LJd.135384$K7.133006_at_news-server.bigpond.net.au...
>
> - In reality, such a pattern as you've described is unlikely and would
> require a rather manufactured insertion method by the application. That
> said, factors such as specific deletion/insertion patterns, the possible
> effects of multiple freelists and the possible effects of ASSM could
> possibly lead to similar CF patterns.
>
On the contrary - set freelists = 2 on the table, then insert rows which are
keyed on (trunc(sysdate), sequence_number), and you get that sort of
pattern almost automatically.
Received on Fri Jan 28 2005 - 16:26:48 CST
