Re: Log files tuning

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 03 May 2009 16:57:49 -0500
Message-ID: <4roLl.28461$yr3.8630_at_nlpi068.nbdc.sbc.com>



Shakespeare wrote:
> 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?

You make sure you talk to the sales guy before downloading, installing and using it to ensure you only pay for what you use/want.

> 
> 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.....

Again, if you cannot decline to install or remove "extra-cost items" they cannot in all good conscience make you pay for them regardless of the licensing agreement that you never signed.

>
> Shakespeare Received on Sun May 03 2009 - 16:57:49 CDT

Original text of this message