OCP Oracle Database 11g New Features for Administrators Exam

Read or Download OCP Oracle Database 11g New Features for Administrators Exam Guide PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle types, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and knowledge sharing throughout your allotted framework utilizing the professional info during this Oracle Press advisor. Oracle Streams 11g facts Replication explains easy methods to organize and administer a unified company facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software exhibit four Recipes presents an example-based method of studying program convey - the ground-breaking, fast program improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires an excellent instance or to kick begin their pondering and get pointed within the correct path.

Extra info for OCP Oracle Database 11g New Features for Administrators Exam Guide

Sample text

Because the STS is a persistent database object, you can modify the STS as you want and even select data from the STS as you would from a table. You can use an STS’s filtering capability to weed out any undesirable SQL. You can use one of the following sources to load statements into an STS: ■ Automatic workload repository (AWR) snapshots ■ AWR baselines ■ A cursor cache ■ Another STS You can either collect all the SQL statements at once or over a period of time. The SQL Performance Analyzer, which is primarily designed to predict the impact of major system changes on the SQL workload response time, does the following things when analyzing the SQL workload performance: ■ Builds different versions of SQL workload performance ■ Executes SQL serially without respecting concurrency characteristics ■ Analyzes performance differences including the response time of the before- and after-change SQL workloads ■ Uses the SQL Tuning Advisor to tune regressed SQL statements Following is the workflow involved in using the SQL Performance Analyzer: Note the characteristics of how the SQL Performance Analyzer analyzes the SQL workload.

54 Chapter 1: Installing, Upgrading, and Change Management 3. Make the system changes. Once you capture the pre-change SQL workload from the production system, make the necessary changes on the test system. For example, if you want to test the impact of an upgrade to a new version of the database, install the new Oracle release software on the test system and upgrade a copy of the production database to the new release. 4. Capture the post-change SQL workload performance. Use the SQL Performance Analyzer to capture the workload, this time on the post-change test system.

Think_time_scale An optional parameter that lets you calibrate the speed at which you send user calls to the database. The parameter scales the elapsed time between user calls from the same session. The default value for this parameter is 100. If you set this value to 0, you’ll send client requests to the database in the fastest time possible. Note the difference between how elapsed time is computed during a workload capture and a workload replay. During a workload capture, elapsed time is the sum of two components: user time and user think time.

Download PDF sample

Rated 4.78 of 5 – based on 16 votes