Originally Broadcasted 3.5.2013 If you’re like most DBAs, you may have gotten blamed for application performance issues at one time or another. Maybe the root cause of a problem did originate in the database, but maybe it didn’t. It can be difficult to tell—especially when communication among the application, storage, virtualization, and database teams isn’t…

Originally Broadcasted 3.5.2013 If you’re like most DBAs, you may have gotten blamed for application performance issues at one time or another. Maybe the root cause of a problem did originate in the database, but maybe it didn’t. It can be difficult to tell—especially when communication among the application, storage, virtualization, and database teams isn’t…

With large multi-terabyte databases it can be difficult to quickly back out a large amount of database changes. One way to back out changes and have your production database up and available for use is to use Flashback Database. And you can back out the changes from your large standby database by using Snapshot Standby.…

Partitioning and compression are technologies that have been in the Oracle database for a long time. The EXCHANGE PARTITION command is the key to large-scale and scalable data loading in a data warehouse, and a key prerequisite for the effective use of compression. But now there are many different types of compression available in Oracle…

Partitioning and compression are technologies that have been in the Oracle database for a long time. The EXCHANGE PARTITION command is the key to large-scale and scalable data loading in a data warehouse, and a key prerequisite for the effective use of compression. But now there are many different types of compression available in Oracle…

This presentation will discuss the latest Oracle database features certified and supported by SAP applications. This presentation is targeted for Oracle DBAs and SAP basis administrators responsible for managing an Oracle database running under SAP applications.

Testing data warehouse projects can be extremely challenging due to the heterogeneous nature of data sources and large volumes of data. Based on our experience in implementing data warehouses and BI systems, we have come up with a set of best practices/patterns in testing which can minimize the risks associated with OBI projects. The methodology…

Testing data warehouse projects can be extremely challenging due to the heterogeneous nature of data sources and large volumes of data. Based on our experience in implementing data warehouses and BI systems, we have come up with a set of best practices/patterns in testing which can minimize the risks associated with OBI projects. The methodology…

Testing data warehouse projects can be extremely challenging due to the heterogeneous nature of data sources and large volumes of data. Based on our experience in implementing data warehouses and BI systems, we have come up with a set of best practices/patterns in testing which can minimize the risks associated with OBI projects. The methodology…

Testing data warehouse projects can be extremely challenging due to the heterogeneous nature of data sources and large volumes of data. Based on our experience in implementing data warehouses and BI systems, we have come up with a set of best practices/patterns in testing which can minimize the risks associated with OBI projects. The methodology…