SLOB

SLOB is an Oracle I/O workload generation tool kit, supports testing extreme REDO logging I/O (minimal amount of CPU overhead)
The SLOB package can be downloaded from Kevin Closson's Blog: SLOB Resources
SLOB 2.4.2 requires Linux with Oracle Client

Installation

Unzip the SLOB tar.gz file in the desired directory ($SLOB).
Create tablespace for SLOB data (the script creates IOPS)
$ cd $SLOB
$ sqlplus / as sysdba @ misc/ts
Load SLOB data by running setup.sh script located in the $SLOB directory. Using two mandatory parameters:
  • Tablespace into which SLOB will create and load the test schemas
  • The number of schemas to create and load
$ ./setup.sh IOPS 8

configuration

One time compilation
$ cd $SLOB/wait_kit
$ make
Edit runtime parameter in slob.conf configuration file
$ cd $SLOB
$ vi slob.conf
Execute slob using number of SLOB schemas
$ cd $SLOB
$ ./runit.sh 8
We can edit the slob.conf file to modify some parameters.
  • UPDATE_PCT - Percentage of SLOB update operations
  • SCAN_PCT - percentage of short scan SELECT operations on a short scan table
  • RUN_TIME - Wall-­clock duration of a SLOB test in seconds
  • WORK_LOOP - SLOB test duration based on iterations
  • SCALE - Number of database blocks / Size
  • SCAN_TABLE_SZ - size of the short scan table(s)
  • WORK_UNIT - scope of blocks being manipulated by each operation
  • REDO_STRESS - HEAVY -> generate significant amounts of redo logging
  • LOAD_PARALLEL_DEGREE - number of Oracle Database sessions concurrently inserting data
  • THREADS_PER_SCHEMA – sessions against each schema
  • DATABASE_STATISTICS_TYPE - “awr” or “statspack.”
  • ADMIN_SQLNET_SERVICE – separate service for admin operations
  • SQLNET_SERVICE_BASE – service for load balance and round robin connection
  • SQLNET_SERVICE_MAX - appended to SQLNET_SERVICE_BASE in a RAC testing scenario
  • DBA_PRIV_USER – sys / system or any DBA user
  • SYSDBA_PASSWD – password of the above user

Results & tools

  • iostat.out - input/output statistics: Read Thoughput (MB/sec), Write Throughput (MB/sec) and information about queue lengths.
  • mpstat.out - CPU utilization (processors related statistics)
  • vmstat.out - virtual memory statistics
  • misc/awr_info.sh - extracts interesting information from the awr.txt file
$ misc/awr_info.sh awr_pdb.txt
FILE|SESSIONS|ELAPSED|DB CPU|DB Tm|EXECUTES|LIO|PREADS|READ_MBS|PWRITES|WRITE_MBS|REDO_MBS|DFSR_LAT|DPR_LAT|DFPR_LAT|DFPW_LAT|LFPW_LAT|TOP WAIT|
awr_pdb.txt||61|0.6|1.0|695|52106|1997| 16.6|0| 53|34.8| 250|0|0|0| 192|DB CPU 33.3 54.7|

Comments

Post a Comment

Popular posts from this blog

Data Guard - Changing IP Addresses

Image
When changing IP of a host we should update/recheck the following places: /etc/hosts or DNS listener.ora tnsnames.ora Database parameters (local_listener, remote_listener) Data Guard configuration This document is also relevant when changing the IP address of the connection between the hosts, other than the original IP addresses we used during the installation. When installation is done using the hostname and not the IP address, most of the changes are not relevant except for /etc/hosts. In this document, I will describe how to change the Data Guard Broker configuration. Dataguard configuration Show the environment DGMGRL> show configuration Configuration - dr   Protection Mode: MaxAvailability   Members:   pdb7 - Primary database     fdb7 - Far sync instance       sdb7 - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS   (status updated 351 seconds ago) Show detailed information of the Primary
Read more

Install Oracle Internet Directory (OID) in Standalone mode

Image
Oracle Internet Directory (OID) is an LDAP server which uses an Oracle database as a datastore. Client machines can use the OID for all TNS lookups. With OID. Once all client machines are configured correctly any modifications to the TNS lookups can be done from a central location reducing the amount of client machine administration. This guide is about installing and using Oracle Internet Directory in Standalone mode, no need for Oracle Fusion Middleware Infrastructure. Step-by-step guide Download Oracle Internet Directory (Part of identity management) from http://www.oracle.com/technetwork/middleware/id-mgmt/downloads/index.html Install OID, follow instructions: https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/inoim/installing-product-software.html#GUID-5D47117E-3983-4BED-BADB-CB7DDD63DB34 Starting the Installation Program: ./fmw_12.2.1.3.0_oid_linux64.bin Configure the Domain: $ORACLE_HOME/oracle_common/common/bin/config.sh Start the Servers for Standal
Read more

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in: HP/Solaris /var/opt/oracle/oraInst.loc Linux /etc/oraInst.loc Windows \\HKEY_LOCAL_MACHINE\Software\Oracle\inst_loc To check if all oracle homes are registered within the Central Inventory run the following command: ${ORACLE_HOME}/oui/bin/opatch lsinventory -all Invoking OPatch 10.2.0.3.0 Oracle interim Patch Installer version 10.2.0.3.0 Copyright (c) 2005, Oracle Corporation. All rights reserved.. Oracle Home : /software/oracle/OEM10gR2/agent10g Central Inventory : /software/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.3.0 OUI version : 10.2.0.3.0 OUI location : /software/oracle/OEM10gR2/agent10g/oui Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt ----------------------------------... List of Oracle Homes:
Read more