Oracle Premier Support - Trusted, Secure, Comprehensive

Ask the Support Blogger....he'll know (Data Collections)

Chris Warticki
Global Customer Success Management

Question: Are there any best practices around which files/logs should be collected
and uploaded proactively for different kinds of  issues?  For instance,
if it's a performance issue, they should expect to be asked for AWR
reports... so they might as well upload them as early in the process as
they can.

I receive lots of questions both internally and from our customers on best practices and resources.  I'm going to start posting them here for all to benefit.

Answer: By default - a customer should ALWAYS upload an RDA
Don't wait for Support to request it. Just give it too us when the SR
is logged. RDA is the most comprehensive Data Collector we have. They
should run via cron job every day as a best practice anyway.  Attend my next FREE Customer Workshop on RDA and DBA Diagnostics on January 26th, 2pm EST.

With regards to Performance Data Gathering:

Have the customer begin by having EVERY DBA READ - Oracle Performance
Guide (OPDG)

Then, determine if they need to use HANGFG User Guide, OSWatcher User Guide, or LTOM User Guide or all three.  If the customer is using a product solution like EM/Grid/Cloud Control then even better. Product solutions help prevent problems.  For some FREE training on those products, check out the Oracle Learning Library.

Also, instead of waiting for a webconference to be scheduled and coordinated - have the customer record their problem using CamStudio.  Don't log another SR without using it and uploading it at the time the SR is created.

Of course, there's Oracle Configuration Manager (gotta plug that one) and there's a host of other data collector tools listed in my post here. (see #5)


- Chris Warticki
#Oracle News, Info & Support

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.