Pinned-To-Thread cannot be used with Oracle RAC databases. Another JDBC optimization technique that you experiment with is called batch updates. Finally, you learn how to configure some basic Oracle RDBMS settings to allow for an optimal interaction with Oracle WebLogic Server 12 c . During the course of these practices (7-1 to 7-3), you will use The Grinder to stress test the SimpleAuctionDbSLSB_EAR application, modifying JDBC parameters between each test, and you will record the result of each test in the following table: Configuration Mean Test Time (ms) Succes sful Tests TPS Peak TPS Errors Connections in pool: Initial = 5 and Maximum = 15 Connections in pool: Initial = 15 and Maximum = 15 Statement caching enabled – 15 statements Statement cache: Type = LRU, Size = 10 and Pinned-to-Thread , enabled Statement cache: Type = LRU, Size = 35 and Pinned-to-Thread , enabled Oracle University and In Motion Servicios S.A. use only THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Practices for Lesson 7: Overview Chapter 7 - Page 3 The following diagram shows the stress test architecture based on The Grinder: You will use the Administration Console to modify key performance-related JDBC parameters, verifying the impact of each change at the end of each test. Oracle University and In Motion Servicios S.A. use only THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Practice 7-1: Tuning JDBC Connection Pools Chapter 7 - Page 4 Practice 7-1: Tuning JDBC Connection Pools Overview In this practice, you run The Grinder to exercise the SimpleAuctionDbSLSB_EAR application. The first run shows the impact of setting the JDBC parameters as follows: Parameter Setting Initial Capacity 5 Maximum Capacity 10 Minimum Capacity 5 This run represents the baseline against which subsequent runs are compared. Tasks 1. Connect to the host01 and host02 machines. 2. Set up the practice environment. a. Perform the following commands in a terminal window on host01 to set up the environment for this practice: $ cd /practices/tune/practice07-01 $ ./setup.sh This script does the following: − Restores the domain to its original state − Starts the wlsadmin AdminServer − Deploys the SimpleAuctionDbSLSB_EAR application to the cluster − Starts the server1 managed server on host01 − Starts the server2 managed server on host02 b. Wait for all servers to log that they are in the RUNNING state before continuing. 3. Verify that the Oracle RDBMS is running. Select the VNC host02 window. Open one terminal window; in the bash shell, make sure the database is running by verifying that the pmon process for orcl is running: $ ps –ef | grep pmon oracle 21491 1 0 Oct13 ? 00:01:10 ora_pmon_orcl oracle 22816 14868 0 02:27 pts/2 00:00:00 grep pmon a. Make sure the Oracle listener is running: $ lsnrctl status b. If the pmon_orcl
You've reached the end of your free preview.
Want to read all 227 pages?
- Fall '19
- Terminal emulator, Load testing, In Motion Servicios