Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.85.MISMATCH!feed.xsnews.nl!border-2.ams.xsnews.nl!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!z8g2000prd.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell@eds.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Log files tuning
Date: Thu, 30 Apr 2009 06:25:01 -0700 (PDT)
Organization: http://groups.google.com
Lines: 46
Message-ID: <868ffd32-c27f-4d0c-a015-139e4321eef8@z8g2000prd.googlegroups.com>
References: <9e43bc1e-daad-48d6-b2ba-6fea9f17072f@g31g2000pra.googlegroups.com>
NNTP-Posting-Host: 192.85.50.11
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1241097901 12218 127.0.0.1 (30 Apr 2009 13:25:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 30 Apr 2009 13:25:01 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: z8g2000prd.googlegroups.com; posting-host=192.85.50.11; 
 posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Apr 30, 9:06=A0am, BeginnerDBA <hpcasal...@gmail.com> wrote:
> Hi All,
> By using Oracle Enterprise Manager I can tune my database..I have been
> using it on Windows, however not yet on Unix, I am looking for some
> advise....do you think recommendable installing EM on Unix or WISE
> product, I was hearing about it, but honestly I don't know how much
> usefull would be.
>
> One more thing....Would you mind giving me some guide how can I tune
> it in the meanwhile???...it is growing so fast.
>
> Thank you.

You do not need EM to tune your database nor do you have to have a
license for the EM Performance Pack so that you can use the AWR.  You
can tune the database using SQLPlus, statspack, and the information
available to you in the Oracle Performance and Tuning manual, the
Oracle version# Reference manual, and the DBA Administration manual.

You can install and configure EM to access your UNIX server based
Oracle databases if you wish.  EM is a nice product but it is only a
tool and sometimes the designers lowest common denominator approach
does not result in the best advice being issued from some of the EM
features.  Unless the pricing has changed on the Performance packs it
is also expensive.

The fact that you database is rapidly growing may be a space
management issue, and will likely be an applicaiton SQL tunign issue,
but is not in itself a database tuning issue.  There are several rdbms
data dictionary views that exist to help manage space including:
dba_segments, dba_data_files, dba_free_space, dba_extents, and
dba_temp_files.

The best advice anyone can give you is to read the Oracle manuals:
Concepts, DBA Admin, Backup and Recovery, first few chapters of SQL
manual, Performance and Tuning, and so on until you have read all the
manuals that cover the features you use.

There is no substitute for knowledge.

HTH -- Mark D Powell --