Re: Two sanity checks

First one -

    Doesn't sound sensible. A one-TB object is     asking for trouble. It looks like the table is     begging to be partitioned by date and locally     indexed.

Second one -

    High precision information, intelligence, and     sensible placement will show significant benefits     on extreme systems.

    A little finesse and care will be beneficial on     most systems.

    Total ignorance and lack of attention seems to     be adequate fairly often.

    SANs and their ilk can eliminate a lot of the need     for careful planning - but it is still possible to do     better with a little care, and it is possible to produce     extremely poor results without a little care. It is     particularly easy to get into trouble if (a) the disks     are too big and/or (b) the big black box is shared     with another application.

Sorry, I don't have the certification, but I can do the big bill if you insist.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Dusan Bolek wrote in message
<1e8276d6.0202070251.73fa427e_at_posting.google.com>...


>First One:

>

>There is a need for storing up to one terabyte of audit informations

>(not Oracle internal audit, just general one). Proposal is to use one

>single non-partitioned table with two indexes. One is on date and the

>second one is on system indentifier which is varchar2(256). Looks to

>me like a pretty crappy design and performance will be terrible.

>

>Second One:

>

>Some people says that OFSA (Oracle Flexible Storage Architecture) is

>obsolete, because new modern storages like SAN disk arrays with

>stripping, caching technologies etc. can spread I/O load with no

>support from special data placing.

>That sounds to me like (sorry for that word) a bullshit, because disk

>I/O is still very slow (comparing to memory, interfaces etc.) and

>having everything in one big mess can't bring the same performance as

>properly distributed files (OFSA) even with help of all stripes and

>caches in the universe.

>

>P.S. I love external consultants, especially from world-wide companies

>with all certifications and big bills.

>--