Pinned to thread cannot be used with oracle rac

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