Re: Log files tuning

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sun, 03 May 2009 13:20:13 +0200
Message-ID: <49fd7ded$0$189$e4fe514c_at_news.xs4all.nl>



Michael Austin schreef:
> joel garry wrote:

>> On Apr 30, 8:56 am, Shakespeare <what..._at_xs4all.nl> wrote:
>>> Michael Austin schreef:
>>>
>>>
>>>
>>>
>>>
>>>> ddf wrote:
>>>>> On Apr 30, 8:25 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>>>>>> On Apr 30, 9:06 am, BeginnerDBA <hpcasal..._at_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 --
>>>>> 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:
>>>>> http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/optio... 
>>>>>
>>>> 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."
>> http://www.oracle.com/technology/oramag/oracle/03-sep/o5310gcover.html
>>

>> 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 http://ashmasters.com/ (I only just noticed the
>> Embarcadero thing, I hope the sash stays around until I can get around
>> to trying it).
>>

>> jg
>> --
>> _at_home.com is bogus.
>> What's in a swine, eh?
>> http://www3.signonsandiego.com/stories/2009/apr/30/un-who-swine-flu-043009/?health&zIndex=91383
>>
> 
> 
> I consider anything they include - that I am not able to remove or have 
> the option to not install like those book clubs years ago... They would 
> send you a book about jungle cats and then call and harass you until you 
> paid for it.  The law said that because you did not request it, not only 
> did you not have to pay for it, but you also did not have to return it. 
>  I see no difference in what companies like Oracle are doing.  It is 
> basically a bait-and-switch feature.  I have never seen any court 
> rulings that this is true of Oracle, but wouldn't surprise me if they 
> exist and were "sealed" to prevent us from seeing them.

Unfortunately, you accept the license terms before using the product. And it's in... the license terms. You did not accept a book club license, did you?

I have just been confronted with a customer, not disabling nor using the extra options on EE. Oracle wanted them to PAY for the options after a license audit....

We succeeded in negotiating not having to pay for them.....

Shakespeare Received on Sun May 03 2009 - 06:20:13 CDT

Original text of this message