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…

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…

Join us in this session to hear from Oracle WebCenter Content customer, Banner Engineering, and how they successfully deployed a mobile content management solution. This mobile library application enables their sales force to access sales collateral stored in Oracle WebCenter Content directly from Apple iPads and Android tablets, providing an interactive method for sales associates…

This presentation will look at which new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases)…

There are many hypes and terminologies in the business intelligence (BI) world today. Terminologies like enterprise data warehouse, data mart, data mining are generally associated to BI. But it is not necessary what BI really is. In the beginning of this presentation, the presentator will provide a quick overview of what BI is. After the…

Oracle Enterprise Manager provides a broad set of IT management capabilities in a single solution—capable of completely managing an enterprise cloud environment. However, to achieve the benefits of this environment, Oracle Enterprise Manager’s framework itself must be implemented properly—for scalability, availability, performance, extensibility, and required customizations for your environment. Oracle Enterprise Manager 12c provides a…

Performance tuning tips & techniques across the various components of the Oracle Webcenter environment. DB, storage, network, application, webservers, etc.

When used locally on a database server, OS Authentication can be a secure and useful connection method. When that feature is extended to remote systems on a network, risks are introduced that are greater than intended. Additionally, this feature is deprecated as of Oracle 11g. This session will review the risks associated with Remote OS…