RE: AW: RMAN: I don't trust it

Quoting Richard Ji <richard.ji_at_mobilespring.com>:

> Why should the default be scalable? Please tell me, how does
> Oracle know
> how many CPU, Memory, the type of IO system, transaction volume and
> whether
> it's OLTP or DSS, on and on... Every database application is
> different.
> Scalability means different things to different database
> environments.
> And editing init.ora is not how you achive scalability. Some of
> the tuning
> solution might come down to change a init parameter but most of
> them aren't.

I got this from the idea from "Why should default OS installs be secure?" Most Linux and even MS are making their OS more secure by default right after a fresh install.

Why can't Databases be like that (more scalable)? Can't it be more intelligent? Can't it figure out on it's own how many cpu and how much memory it runs on? Can't it figure out on it's own that a temp tablespace for sorting is being used all the time while there is a 1GB of free extra memory available for sorting and that it should increase sort memeory space dynamically?

Database tuning should be made more automatic - somewhat like Oracle's locally managed tablespace feature.

Perhaps this is the way databases should go - intelligent self-tuning. It will be hard to accomplish but is possible. Hopefully, we will get there (slowly) one day.

-- 
Lyndon Tiu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lyndon Tiu
  INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).