abstract about how to use Orion.
Note that Oracle does not support Orion.
Advantages:
1. Do not need to run Load Runner and configure a large number of clinet
2. You do not need to run the Oracle database or prepare a large amount of test data.
3. The test results are more representative. For example, in random I/O testing, the software can make the storage hit
Description
This article installs the Oracle 11g Dataguard physical repository and tests the 11g Dataguard physical Repository's new feature active Data Guard, which is a function of Oracle Database Enterprise Edition, which requires the amount External authorization, this article is for testing only.
First, the environment introduction
1. Primary database env
1,swingben Introduction
The current open source Oracle Stress testing Tools on the Web are mainly ORABM and swingbench, and because ORABM does not support Oracle 11g versions, the test uses Swingben for stress testing. In addition, Swingbench can also test the RAC. Swingbench is an
Today is. I/o throughput is one of the factors that affect data redo. oracle media recovery depends on I/o, if I/o has a bottleneck, it will inevitably affect the restoration of the media in the slave database.
I/o stack contains hbas, storage related switches, and storage physical disks. Therefore, it is recommended that I/o be verified during application deployment in oracle to avoid problems. But there w
1. Preparatory workThe Oracle 11g R2 version of the database is installedCopy the ORACLE driver Ojdbc6.jar from the $oracle_home/jdbc/lib/of the database serverThe database has a table students, with 2 field IDs and a name2. Start Oracle Test1. Open the JMeter, add a test plan, locate the Oracle driver location to add2
/17 15:22:17 INFO MapReduce. importjobbase:transferred 1.4375 KB in29.3443 seconds (50.1631 bytes/sec)14/08/17 15:22:17 INFO MapReduce. Importjobbase:retrieved Bayi Records. ③ Data export Oracle and HBaseUse export to import data from HDFs into a remote database export--CONNECTJDBC racle:thin 192.168.**.**:* *:* *--username **--password=**-m1table Vehicle--export-dir/user/root/vehicle importing data to hbase sqoop import--connect jdbc Racle:thin 192.1
Tags: Oracle DBA stress testThis article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/42376661Before a business system stress test, an Oracle DBA is required to do the work ahead of time:1. If the Oracle database software is not installed by the DBA, the DBA will review the specification of the database softw
Some time ago, in Ali mother new room pressure test process used in the LR test Oracle, with the DBA (landlords) in Hangzhou netcom New computer room for 1000 users of the pressure simulation test. The entire stress test takes two days. The following are some of the experiences:
1 The stress test process found that some of the SQL scripts performed very slowly and were optimized.
2 The best concurrent testing
When testing paging records, you can use oracle loop insertion test records 1. The middle of the line is a common SQL statement, and I is the outer loop id. Oraclebeginforiin8.. 100loopINSERTINTOUSER2. FUN_STO_PRO (S_ID, AUDIT_STATUS, CREATE_TIME, UPDATE_USER, UPDATE_TIME) VALUES (I, 1, Wu Jinglin,
When testing paging records, you can use
Oracle ORION: Storage System Performance Testing Tool (I) defines ORION (Oracle I/O Calibration Tool) as an Oracle Tool for testing storage system performance bottlenecks because ORION is an independent Tool, it is very easy for users to create and run
0. Oracle test data preparation:[Oracle @ db1 ~] $ Sqlplus system/000000SQL * Plus: Release 11.2.0.3.0 Production on Tue Mar 25 10:26:06 2014Copyright (c) 1982,201 1, Oracle. All rights reserved.Connected:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application
ORION (OracleIOCalibrationTool) is an independent tool used to calibrate the IO performance of the Oracle database storage system. Calibration Results for understanding storage system performance
ORION (Oracle I/O Calibration Tool) is an independent Tool used to calibrate the I/O performance of the Oracle database's storage system. Calibration Results for underst
Java language test: connect to the Oracle database packagecom. linuxidc. jdbc; importjava. SQL. Connection; importjava. SQL. DriverManager; *** Test
Java language test Connection to the Oracle database package com. linuxidc. jdbc; import java. SQL. Connection; import java. SQL. DriverManager;/*** Test
Connect to the Oracle database through Java
(I) Definition
Orion (Oracle I/O calibration tool) is a bottleneck provided by Oracle for testing storage system performance.
As Orion is an independent tool, you do not need to create or run an Oracle database.
Orion is very simple to use. You can directly decompress the downloaded package from the official website.
Tags: logs time dba free use Baidu src es2017 sizeCurrent Oracle Database Best Test Tool otest * Otest is used for Oracle database testing, optimization, and monitoring software. * Otest is available free of charge to Oracle customers and the vast majority of DBA engineers. Developed by the original technical expert W
in 1.. 10000 loop5 Select Seq_3.nextval to x from dual;6 end Loop;7 End;8/The PL/SQL process has completed successfully.Time used: 00:00:00.37Test four:Sql> Create sequence seq_4 cache 1000;The sequence has been created.Time used: 00:00:00.04Sql> Declare2 x number;3 begin4 for I in 1.. 40000 loop5 Select Seq_4.nextval to x from dual;6 end Loop;7 End;8/The PL/SQL process has completed successfully.Time used: 00:00:01.31Sql> Declare2 x number;3 begin4 for I in 1.. 40000 loop5 Select Seq_1.nextval
/ Icgsknubvvjhicdrrejsb1affgb0epyuhnb4mic0ib79xnicxybvfp9n7gpe4cbj2uiaoieyphz0atpklhtibrsypljoq/640?wx_fmt=jpeg tp=webpwxfrom=5wx_lazy=1 "style=" Margin:1em auto;padding:0px;height:auto;border-width:0px; Font-style:inherit;font-variant:inherit;font-weight:inherit;font-size:inherit;line-height:inherit;font-family: Inherit;vertical-align:baseline;width:auto; "alt=" 640?wx_fmt=jpegtp=webpwxfrom=5wx_lazy "/> For more information, see: http://edu.51cto.com/course/2324.htmlIf you have a loss of help,
In the actual operating environment, we often encounter such requirements. For example, if you want to avoid affecting the running time of the DB patch in the current network environment, or, you want to connect to Standby DB for testing of actual business operations before performing DB switching. If you want to test Standby DB in 9i, if you do not need to create a new test environment, standby DB can be activated for
=" Wkiom1qx2v6s6yjvaakal63j5mg784.jpg "/>Modify the distributed controls to collect the test monitoring information during the test, test the connection is correct after the modification, and can count the host CPU disk IO information650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4B/BD/wKioL1Qx24DDSssqAAFmiLc2VSU132.jpg "title=" e5.jpg "alt=" Wkiol1qx24ddsssqaafmilc2vsu132.jpg "/>You can also pull out the awr report650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4B/BD/wKio
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.