Posts Categorized: Technical Blog

SQL Server Risk Assessment – The PMP Way

Recently I had a chance to speak with my friend and colleague, Ashish Sharma. We were discussing Project Management topics (he recently passed PMP and ACP). Our discussion ended on a very interesting topic – RISK Assessment. Definition: According to PMBOK, projects can have unforeseen events or activities that can impact the project’s progress, result,…

Oracle Free Block Corruption – Test Case

My very first blog post at Pythian – Trick or Treat? So there I was, faced with more that 4000 block corruptions as shown from v$database_block_corruption. The script  corrupt_seg.sql identified the corruption as Free Block Corruption (block not associated with any segments). So how can free block corruption be removed? One method is to format the corrupted…

Improve Gather Stats in Oracle E-Business Suite

One important aspect of a healthy Oracle database is database statistics. It’s the main data on which CBO feeds to generate good execution plans for SQLs. Implementing a periodic and consistent gather statistics procedure in Oracle E-Business Suite is every Applications DBA’s duty. But often I see that they are not set up properly to…

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if you want to see how the performance changes over time. I’ve been using three really…

MSDB – Cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 Gigs is not considered big for a database. Correct, but for MSDB, it is. So, the…

Step-by-step installation of an EBS 12.2 Vision instance

It’s here! It’s here! It’s finally here! (what, you don’t get excited when you get new toys?) Now that version 12.2 of Oracle Applications has been released, it’s time for eager Apps DBAs and non-DBA EBS geeks to get their hands dirty with new features! This post will walk through the steps required to install…

Getting ready to install EBS 12.2 Vision: Quickstart notes

Getting ready for the next big thing In the wake of last week’s announcement of the general availability of Oracle E-Business Suite Release 12.2, I’ve started spinning up a 12.2 Vision instance, so I can start getting familiar with the product. Learning about the changes has been pretty fun so far, and you’ll be seeing…

Breaking News: Oracle E-Business Suite Release 12.2.2

Oracle E-Business Suite Release 12.2.2 is out! Big times ahead of us folks! My team is planning to blog about it a lot. Stay tuned. This is my prediction: Online patching a game-changer in Oracle E-Business Suite 12.2 Oracle Press Release Steven Chan’s blog You can get it from e-delivery site. Yury PS: If any of you…

Page 6 of 55« First...45678...203040...Last »