• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

orcle_diagnostiics_pack

Is the orcle diagnostics and tuning pack a good tool to have with 11g database?

is it installed with 11g Enterprise normally.

I am wondering if i should request a license to that to adminsiter a small database.

i think it s about 5 K. Is there any alternative options?
0
sam15
Asked:
sam15
  • 3
  • 3
  • 2
  • +1
3 Solutions
 
sdstuberCommented:
yes, they are handy

no, they aren't normally installed

use statspack it's still free with your existing oracle licenses.

various third party diagnostic tools

query the data dictionary yourself - but not the views associated with the packs as that would violate the license.

talk to your oracle representative, he/she should be able to get you a temporary license to try out the functionality.
If you get value out of it, then purchase,  if you don't,  then don't
0
 
slightwv (䄆 Netminder) Commented:
>>to adminsiter a small database

Diagnostics is probably overkill for a small database.  From your previous questions the DB is around 30G.

I would probably go with statspack and a couple of custom scripts to look at what you deem the most important.
0
 
sam15Author Commented:
is there a good link on what those tools do for you?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
slightwv (䄆 Netminder) Commented:
The online docs have everything you need to know about statspack.

I would also recommend the Burleson book on 9i statspack:
http://www.amazon.com/Oracle9i-High-Performance-Tuning-STATSPACK-Burleson/dp/007222360X

I realize it is 9i but I don't think statspack hasn't changed much.

He also has a tool:
http://www.dba-oracle.com/t_statspack_analyzer.htm
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
here are the details of additional pack which can be purchased from oracle and their details.

http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm
0
 
sam15Author Commented:
According to one I have, it says ou should diable access to any management packs that you have not licensed using ENterprise maanger.

set CONTROL_MAANGMENT_PACK_ACCESSS = NONE to disable diagnostics pack and tuning pack.

Does this mean they are installed by default.
0
 
sdstuberCommented:
my mistake,  I was thinking they had them disabled by default now (after much customer complaint) and you had to enable them.

 I guess I had that backwards -


 but it makes sense though,  in general, everything in oracle is always available and you're expected to pay for it if you use it.
0
 
sam15Author Commented:
it could be. the book is a 2009 copy and we are in 2011. so they might have changed things.
0
 
slightwv (䄆 Netminder) Commented:
>>so they might have changed things.

true but I stated 'I don't think'.

Statspack was starting to be phased out in 10g with all the new advisors.  If they changed anything it wasn't enough to make that book worthless.

No one will be writing an 11g statspack book.  No market for it.

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now