Re: Two sanity checks

"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news: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.

I tend to agree. Certainly a table partitioned on date looks a likely design for this purpose to me. I'd be prepared to bet as well that as the users of the system discover what the performance is like on this audit table the 'need' for extensive auditing magically evaporates.
>
> 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.

Again I agree. Certainly when we looked at a SAN environment you still ended up with raid volumes (albeit managed in whizzy new ways on a clever infrastructure). I'd also want to be sure that you still got a guranteed write when you requested one and what difference if any that makes to performance.
>
> P.S. I love external consultants, especially from world-wide companies
> with all certifications and big bills.

It is worth bearing in mind though that some consultants are worth their weight in gold.

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

******************************************