Re: Log files tuning

From: joel garry <>
Date: Thu, 30 Apr 2009 11:41:15 -0700 (PDT)
Message-ID: <>

On Apr 30, 8:56am, Shakespeare <> wrote:
> Michael Austin schreef:
> > ddf wrote:
> >> On Apr 30, 8:25 am, Mark D Powell <> wrote:
> >>> On Apr 30, 9:06 am, BeginnerDBA <> 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
> >>>> 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??? 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 --
> >> I do not find a 'Performance Pack' offered; I do find a 'Diagnostic
> >> Pack' which provides access to the Automatic Workload Repository, and
> >> that pack does require a license:
> >>
> > A company that I am aware of had the DiagPack included for free because
> > you cannot NOT install parts of it, nor can you remove it from 10g on...
> > And the for new "phone-home" support to function, it must be installed -
> > comes "free" with your support contract (forget what it is called
> > today). Was called CM then SCM? (tab on the main metalink page after
> > login - sorry don't have access to it at the moment).
> > Anything that cannot be removed, which means it is a CORE piece of the
> > product, IMProfessionalO should be included in any licensing agreement.
> >> David Fitzjarrell
> Unfortunately, you have to pay for options when you use them. It may be
> so they can not be removed, but they can be disabled (e.g. through EM).
> An Oracle compliancy audit will check if they are disabled. If not,
> you'll have to bleed.
> Shakespeare
> Shakespeare

I was under the impression it was more subtle than that - there are some features used internally by the db, but you have to pay to use them yourself. So you can't really disable them. Don't have time to research just now, so take with grain of salt. (I quickly found the MS FUD about AWD and ADDM tables being used internally, but wouldn't want to quote that). But I will quote this: "Instrumentation has been built into every layer of the technology stack, capturing vital metadata that will be used to diagnose problems and storing the information in the database itself in the Automatic Workload Repository (AWR)a fundamental component of the new management infrastructure that plays a central role as the "data warehouse of the database."

I will point out that there are useful displays in dbconsole that don't require the licensing. I find a few things I use all the time, much better visualization than any script I've seen, including the space and gross performance issues. For the OP situation of a newbie, my advice continues to be, get a working knowledge of dbconsole, and a deep knowledge of how to figure out stuff as Mark advised. And definitely second what Mark said about the tools, and apply it to advice in general, which has been succinctly described by the wise as "trust but verify."

I think some of the options (or their commercial equivalents) are worth it, but it can be difficult to justify to a cost-conscious management. Also note (I only just noticed the Embarcadero thing, I hope the sash stays around until I can get around to trying it).


-- is bogus.
What's in a swine, eh?
Received on Thu Apr 30 2009 - 13:41:15 CDT

Original text of this message