Database App Development, Management and Performance

Project Management Plan is the crucial document needed for proper execution and control of a project.
Integration management knowledge area briefs the steps needed to create a project management plan.
Project management plan is a document composed of many sub-plans.
The subsidiary plans included in project management plan includes scope management plan, time management plan, quality management plan, [...]

Project life cycle comprises of the following 5 phases
1. Initiation2. Planning3. Executing4. Monitoring and controlling5. Closing
Rolling wave planning is the process of performing detailed planning during each and every phase of the project.

In a project the major tool used to develop a schedule(time duration taken to complete each and every activity comprising the project) is network diagramming method. There are two major diagramming methods.
1. Precedence diagramming method( Activity on node)Activities are represented in the form of nodes. The nodes are interconnected using arrows. Arrows are used to [...]

Cost management a crucial knowledge area in Project management is composed of many processes. Few important ones are cost estimating and cost budgeting.
Often these two terms are confusing.
Cost estimating is the process of calculating the cost needed to accomplish a task(activity level or work package(combination of activities leads to work package)).This combines contingency reserves. Contingency [...]

Sometimes problem exist in a system for years, but only become apparent when you prepare for a big change. This war story begins when our storage admin decided to replace our Netapp disks with new disks, twice as large. It is a cheap way to increase disk space and IO wait times.
While assessing the impact [...]

NoCoug, the North California Oracle User Group, will hold its fall conference on Thursday, November 13. You can read the full details in our website.
If you are in the area, you really don’t want to miss this. Jonathan Lewis will give a keynote and a session about partitioning, Dan Tow will explain tuning for recent [...]

Last year, with version 11.1.0.6, I investigated how useful the new flashback data archive was for implementing journaling on a table in this post. There were two main issues:
1) The documented restriction "DDLs that alter the structure of a table (such as drop/modify column, move table, drop partition, truncate table/partition, and add constraint) invalidate any [...]

While doing a quality check on new code, I encountered some row by row processing. This always triggers me to make a remark about rewriting the code to a single SQL, or at least bulk processing. But in this case, inside the loop, several local variables were used to do some counting. And at the [...]

Sometimes the simplest tricks just ease your life the nice way.
While typing code in TOAD, I just found out those two handy keyboard shortcuts
<CTRL> + . = Autocompletes tablenames
<CTRL> + T = Popups the list of column names
I want to select everything from emp and dept joined on deptno.

SELECT*FROM E<CTRL+.> e,D<CTRL+.> d
where e.<CTRL+T><down><enter>=d.<CTRL+T><enter><CTRL+ENTER>

Especially useful [...]

Blink and 3 weeks goes by and I forgot to blog any new updates!
I’ve got a few new entries that will be coming along after my last 2 weeks being up to my eyeballs in Oracle Application Server 10.1.3, but that will wait. The exciting news is:
I’m going to present at Hotsos Symposium 2009! I’m [...]