Re: Log files tuning
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 04 May 2009 21:54:10 +0200
Message-ID: <49ff47e4$0$184$e4fe514c_at_news.xs4all.nl>
Michael Austin schreef:
>>>> On Apr 30, 8:56 am, Shakespeare <what..._at_xs4all.nl> wrote:
>>>> 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
Date: Mon, 04 May 2009 21:54:10 +0200
Message-ID: <49ff47e4$0$184$e4fe514c_at_news.xs4all.nl>
Michael Austin schreef:
> 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
Well, just wait for the Oracle cops to arrive..... you DO sign for them indirectly by accepting the license agreement. I agree with you, but Oracle does not.
Shakespeare Received on Mon May 04 2009 - 14:54:10 CDT