Re: Definition of a optimized database ?

If you are talking about the logical and physical database layouts, "Optimal Flexibile Architecture" will be good reading material (present in most ORACLE DBA books, expecially the one by Kevin Loney - ORACLE Press).

If you are asking about performance goals, well it is typically driven by business requirements. Thats what makes tuning so excting - a successful solution for one installation will not work for another. Lot of factors like system availability requirements, being able to pay for extra or reduntatnt resources (disks etc) determine the amount of tuning you can perform.

Enough said, and from a user's perspective, if he presses a button on the window, and sits there for, say 2 minutes (the amount of time also is driven by user) that is not acceptable.

In article <6j69tc$nbk$1_at_news.NL.net>,   "Marco Nedermeijer" <m.n.nedermeijer_at_rtd.nl> wrote:
>
> Hello,
>
> Can someone tell me what the definition is of a optimized database (if there
> is one).
> I mean about indexes, extensions, clusters, ect.
>
> Thanks,
>
> Marco Nedermeijer
> m.n.nedermeijer_at_rtd.nl
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 12 1998 - 00:00:00 CEST