ALL POSTS

Teaching a Man to Fish

I like to think that I’m somewhat gifted at finding out, or coming up with li’ll useful tricks that improve a hacker’s workflow and help to optimize the pain-to-awesomeness ratio of our daily tasks. I am, however, thoroughly rotten at leveraging them once they are done. Mind you it’s not like I’m the first one…

Log Buffer #345, A Carnival of the Vanities for DBAs

There are a number of technologies, apps, and social media creations out there seeking to displace blogs as the mode of sharing between surfers, but blogging has proved hardy. It has proven its mettle and it’s here to stay. This Log Buffer Edition appreciates this strength of the blogs.

The responsibility of “root”

Systems Administrators often hold the “keys to the kingdom”.  In a data driven world, every IT asset has the potential to have multiple privileged accounts, which can introduce risk to your business and your data.  From the SuperUser to the Database Admin to the Application Owner, each day numerous people are accessing critical infrastructure, often…

Discoverer 11.1.1.7 Installation and Integration to R12.1.3 Instance

This blog gives instructions on how to install Discoverer 11.1.1.7 and get it integrated to your R12.1.3 instance. For easy installation, I have provided all of the important screen shots in a slidehare Word document. These will guide you through all the steps. You can find it here ==> Discoverer 11.1.1.7 Installation and Integration to…

Meaning of “Disk Reads” Values in DBA_HIST_SQLSTAT

This post relates to my previous writing on mining the AWR. I noticed that it’s very easy to misinterpret the DISK_READS_TOTAL and DISK_READS_DELTA columns in DBA_HIST_SQLSTAT. Let’s see what the documentation says: DISK_READS_TOTAL – Cumulative number of disk reads for this child cursor DISK_READS_DELTA – Delta number of disk reads for this child cursor You…

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…

SQL Server Instance in Script Upgrade mode

Introduction: Almost all of us in our DBA life would have patch/upgrades SQL Server instance and would have faced many issues while upgrading the SQL Server build. Today I will discuss in little detail about the background of the Script Upgrade Mode and the fix. What is Script Upgrade mode: When we apply a patch…

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…

Page 20 of 248« First...10...1819202122...304050...Last »