Database upgrades are a part of DBA life. However, the standard upgrade path of simply installing new Oracle binaries and upgrading a database is often not possible. Clients want to benefit from the advantages often associated with newer hardware, operating systems, storage systems and network features. The challenge for the DBA then becomes how to…

Database upgrades are a part of DBA life. However, the standard upgrade path of simply installing new Oracle binaries and upgrading a database is often not possible. Clients want to benefit from the advantages often associated with newer hardware, operating systems, storage systems and network features. The challenge for the DBA then becomes how to…

Database upgrades are a part of DBA life. However, the standard upgrade path of simply installing new Oracle binaries and upgrading a database is often not possible. Clients want to benefit from the advantages often associated with newer hardware, operating systems, storage systems and network features. The challenge for the DBA then becomes how to…

Database upgrades are a part of DBA life. However, the standard upgrade path of simply installing new Oracle binaries and upgrading a database is often not possible. Clients want to benefit from the advantages often associated with newer hardware, operating systems, storage systems and network features. The challenge for the DBA then becomes how to…

Query’s execution plan has significant impact on Oracle database performance which depends upon variety of factors like optimizer statistics, optimizer related parameter, schema definition etc. If execution plan changes, there is no guarantee whether it is better than the previous one or worse so in past DBAs have been locking the plan using Stored Outlines…

We do tech refresh almos every 2 years as our business is growing too fast. But we can not take downtime for this. We have upgraded our AIX-p770 to AIX-p795 with ZERO down time. We did the same from Solaris T3 to T4 upgrade. In the upgrade process, even we have upgraded our private interconnect…

We do tech refresh almos every 2 years as our business is growing too fast. But we can not take downtime for this. We have upgraded our AIX-p770 to AIX-p795 with ZERO down time. We did the same from Solaris T3 to T4 upgrade. In the upgrade process, even we have upgraded our private interconnect…

We do tech refresh almos every 2 years as our business is growing too fast. But we can not take downtime for this. We have upgraded our AIX-p770 to AIX-p795 with ZERO down time. We did the same from Solaris T3 to T4 upgrade. In the upgrade process, even we have upgraded our private interconnect…

We do tech refresh almos every 2 years as our business is growing too fast. But we can not take downtime for this. We have upgraded our AIX-p770 to AIX-p795 with ZERO down time. We did the same from Solaris T3 to T4 upgrade. In the upgrade process, even we have upgraded our private interconnect…

It’s no secret that proper usage of Global Temporary Tables (GTT’s) can result in tremendous performance improvement and dramatic resource usage reduction. This is because data for a GTT are stored in temporary segments and redo logs are not generated. Undo creation is minimized as well. Generally GTT’s are good for applications where there are…