Reproducing true production load in its test environments hasbeen an ongoing challenge for Boeing. Not only does it take huge amountscomputing resources to build production-sized test environments but developingsimulation scripts using traditional tools like LoadRunner is costing Boeinghundreds of man-hours. Database Replay enables Boeing to test Oracle upgrades andpatches, database parameter changes, OS upgrades and…

Thepresentation also covers steps and best practices for incorporating the maximumavailability architecture into Oracle E-Business Suite Release 12.1. on IBMLinux on System z. This session presents Oracle E-Business Suite maximumavailability architecture configuration considerations and best practices fordeploying high-availability and disaster recovery solutions with minimaldowntime. Maximum availability architecture incorporates and leverages OracleDatabase high-availability features and functions…

An introduction to key skills a database developer should have in his/her toolbelt. Including sql and pl/sql syntax as well as monitoring and debugging tools such as explain plan, tracing and profiling. Differences in db versions will be noted as each feature is discussed. In addition to (often overlooked) fundamentals, the presentation will discuss approaches…

Oracle's Data Pump provides a robust and highly capable utility for both DBAs and developers for high speed movement of data and metadata. It can export a filtered data subset to a file, import a table directly from another database or extract metadata in the form of SQL scripts. However, if you are only using…

A A successful real-time data warehouse implementation involves integrating the logical and physical model, source and target databases, ETL subsystems, and front-end dashboards and reports. In this session, we will explore how these different pieces fit together, demonstrated using the Oracle Database (including Warehouse Builder) and Oracle Business Intelligence Enterprise Edition. We will investigate alternative…

Virtualized server environments have proven their ability to reduce costs and increase flexibility by consolidating hardware assets and enabling dynamic provisioning of IT resources. However, many enterprises still follow the same time-consuming practices for installing, configuring and deploying software in virtual machines. Customers are looking to get most out of their virtualized infrastructures and create…

You did everything by the book, followed the database security checklists, and implemented security best practices, but one day you find significant security issues in one of your databases. How did this happen? After auditing hundreds of databases, I have compiled a list of common database security mistakes and potentials causes of each mistake. Common…

Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will describe a project using Oracle XML DB and discuss why XML DB was chosen, how XML DB was used, and the technical issues encountered. The author will provide several examples using XMLTYPE, CLOBs, XML DB methods,…

Oracle ACE Billy Cripe and long-time content management expert, George Sokol, bring their combined 35 years experience in helping customers deploy successful ECM projects. Topics will include such issues such as: âEngaging with the Content Management Curmudgeon," âTackling the Mount Everest of Metadata,â âBuilding a Scalable Security Paradigm,â and âTaming (or Getting Rid of) the…

Constraints are not just about data integrety, although they would be important enough if that was all they did. Constraints in a data warehouse are crucial for performance (and getting the right answer). Constraints in a transactional system are crucial for getting the right answer (and for performance). Constraints convey information to the optimizer. The…