Oracle VMI简单测试
ORACLE 执行计划介绍与测试
ORACLE 执行计划介绍与测试(沈克勤)2005-3-31.目的：本文档的目的是通过介绍常用的HINT来了解ORACLE的优化器的工作原理及执行计划，以期望起到抛砖引玉的作用。
在实际开发中有意识地控制SQL的执行计划，以达到SQL 执行性能的最优以及执行计划稳定。
为了减少枯燥的文档描述，使用了较多的图示。
2.如何查看执行计划首先创建EXPLAIN_PLAN表不同版本的ORACLE，该表结构可能会不同。
请使用的ORACLE中$ORACLE_HOME/rdbms/admin/utlxplan.sql去创建该表。
方法1：使用SQL*PLUS 的SET AUTOTRACE ：SQL>SET AUTOTRACE ON EXPLAIN 执行SQL，且仅显示执行计划SQL>SET AUTOTRACE ON STATISTICS 执行SQL，且仅显示执行统计信息SQL>SET AUTOTRACE ON 执行SQL，且显示执行计划与执行统计信息SQL>SET AUTOTRACE TRACEONLY 仅显示执行计划与统计信息，无执行结果SQL>SET AUTOTRACE OFF 关闭跟踪显示计划与统计方法2：使用PL/SQL Developer工具方法3：使用DBMS_XPLAN.DISPLAY()方法4：直接查看表：EXPLAIN_TABLESELECT lpad(' ',level-1)||operation||' '||options||' '||object_name "Plan"FROM plan_tableCONNECT BY prior id = parent_idAND prior statement_id = statement_idSTART WITH id = 0AND statement_id = '&1'ORDER BY id;3.如何控制与改变执行计划我并没有见过单独介绍ORACLE SQL优化器原理方面的资料。
Oracle 数据库 11g ：真正应用测试与可管理性概述
Oracle 数据库 11g：真正应用测试与可管理性概述Oracle 白皮书2007 年 8 月与可管理性概述真正应用测试 (3)数据库重放 (3)可管理性 (7)面向 RAC 的 ADDM (7)SQL 调整自动化 (8)SQL 计划管理 (9)SQL ACCESS ADVISOR 增强：PARTITION ADVISOR (10)自动内存管理 (11)AWR 基准和适应式阈值 (12)运行状况检查 (14)Data Recovery Advisor (14)Sql Repair Advisor (14)Sql Test Case Builder (14)自动诊断信息库 (ADR) (14)事故打包服务(IPS) (15)支持工作台 (15)总结 (16)³与可管理性概述.引言Oracle 数据库占据着市场主导地位，受到全球众多企业以及应用程序开发人员和数据库管理员的青睐。
这些年来，企业已经开始依赖 Oracle 数据库来提供无可比拟的性能和可靠性。
在数据库 10g 中，Oracle 提供了一个自我管理数据库，该数据库具有前所未有的可管理性，从而显著降低了管理成本。
Oracle 准备再在 Oracle 数据库 11g 中更上一层楼。
数据中心为满足企业需求而快速发展和变化，Oracle 数据库 11g 正是专门针对数据中心环境设计的。
利用 Oracle 数据库 11g，企业可以快速采用新技术，将风险降至最低。
此外，通过其自我管理功能，Oracle 数据库 11g 已在可管理性和故障诊断等方面取得了显著进展。
真正应用测试现在，企业需要在硬件和软件上进行相当大的投资才能展开基础架构更改。
例如，某个数据中心可能计划将数据库转移到一个诸如 OracleEnterprise Linux 的低成本计算平台。
过去，这需要企业为整个应用程序投入一套重复的硬件，包括 web 服务器、应用程序服务器和数据库，以便测试其生产应用程序。
Oracle 应用测试套件 - Oracle E-Business Suite 功能测试加速器说明书
ORACLE APPLICATION TESTING SUITE - TESTING ACCELERATORS FOR ORACLE E-BUSINESS SUITEFEATURES• Automates complex Oracle E-Business Suite transactionsfor both functional testing andload testing• Supports automation of bothWeb and Oracle Formsapplication interfaces andprotocols• Provides custom test cases tovalidate application content• Enables parameterization oftest scripts for data-driventesting• Simulates loads of hundredsto tens of thousands ofconcurrent users whileminimizing hardwarerequirements• Gathers critical infrastructureperformance metrics toidentify bottlenecks underload• Provides an intuitive Web-based console to configureand run load tests and sharereal-time results withdistributed users• EBS Test Starter Kit withsample test scripts providedfor EBS R12 and 11iOracle Application Testing Suite’s Testing Accelerators for Oracle E-Business Suite provide a comprehensive solution for ensuring the quality and performance of Oracle E-Business Suite applications. The Functional Testing Accelerator for Oracle E-Business Suite extends Oracle Functional Testing to enable automated functional and regression testing of Oracle E-Business Suite applications. The Load Testing Accelerator for Oracle E-Business Suite extends Oracle Load Testing to enable load and performance testing of Oracle E-Business Suite applications. The Testing Accelerators for Oracle E-Business Suite are components of Oracle Application Testing Suite, the centerpiece of the Oracle Enterprise Manager solution for comprehensive testing of packaged, Web and service-oriented architecture–based applications. Ensuring Oracle E-Business Suite Application Quality Ensuring the quality of your Oracle E-Business Suite (EBS) applications is critical to your business. But testing EBS applications prior to deployment and keeping up with the pace application updates while maintaining application quality can be a challenge. Oracle Application Testing Suite (ATS) provides a comprehensive quality management solution for Oracle E-Business Suite. Oracle Functional Testing and the Functional Testing Accelerator for Oracle E-Business Suite provides an automated functional and regression testing solution to validate application functionality prior to deployment and reduce the need for manual testing. Oracle Load Testing and the Load Testing Accelerator for Oracle E-Business Suite provide a powerful load testing solution to test and tune application performance under real production workloads and identify bottlenecks. Oracle Test Manager provides an integrated solution for managing the test process including documenting test cases, test requirements and issues identified during testing in a central repository and managing test execution. Together, these products provide a comprehensive solution for ensuring EBS application quality. Functional Testing Accelerator for Oracle E-Business Suite The Functional Testing Accelerator for Oracle E-Business Suite extends Oracle Functional Testing to provide a powerful and easy-to-use solution to automate functional and regression testing of Oracle’s E-Business Suite applications. OracleFunctional Testing allows users to create test scripts that automate complex business transactions within their EBS applications, including both Web and Oracle Forms based application interfaces. Oracle Functional Testing’s OpenScript integrated scripting platform combines an intuitive graphical scripting interface to quickly create complex test scripts and a powerful Java IDE that provides users with the flexibility to extend scripts programmatically. Users can automate business transactions by simply creating a new script and recording as they step through an EBS transaction in a browser. OpenScript captures all actions performed within Web or Forms based applications interfaces which can then be played back to automatically reproduce the recorded transaction. Users can then add test cases to validate specific Web or Forms application content and parameterize their script inputs to perform data-driven testing. Additional transactions can then be recorded to create a comprehensive automated regression test suite.Figure1. Oracle Functional Testing automates Oracle E-Business Suite functional and regression testingLoad Testing Accelerator for Oracle E-Business SuiteThe Load Testing Accelerator for Oracle E-Business Suite extends Oracle Load Testing to enable automated load and performance testing of Oracle E-Business Suite applications. With Oracle Load Testing you can simulate thousands of virtual users accessing the Oracle E-Business Suite application simultaneously to measure the effect of user load on application performance.Users create their EBS load test scripts in Oracle Functional Testing’s OpenScript integrated scripting platform. OpenScript automates both Web and Forms application protocols to generate highly scalable load test scripts for Oracle EBS. The scripts are automatically correlated to handle dynamic session parameters. These scripts can then be configured to run in Oracle Load Testing against any number of virtual users.Oracle Load Testing provides a Web-based console that allows you to configure and run one or multiple scripts across thousands of virtual users to assess performance. Users can specify a number of run time parameters such as the amount of think time each user spends per page and the browser or connection speed to emulate. During the load test, Oracle Load Testing measures end-user response times as well as the performance of the underlying application infrastructure to help identify and resolve application performance bottlenecks.Comprehensive Testing for Oracle E-Business SuiteOracle Application Testing Suite provides a comprehensive testing solution for Oracle E-Business Suite. With Oracle Functional Testing and the Functional Testing Accelerator for Oracle E-Business Suite, users can effectively introduce automation into their functional test process to ensure the quality of their Oracle E-Business Suite applications and reduce testing time. With Oracle Load Testing and the Load Testing Accelerator for Oracle E-Business Suite, users can leverage a powerful solution for ensuring Oracle E-Business Suite application performance. The Oracle E-Business Suite testing accelerator includes a Test Starter Kit with pre-build test automation scripts for Oracle E-Business Suite applications. The Test Starter Kit covers a broad range of applications and user flows for both functional and performance testing based on the VISION demo database.And with Oracle Test Manager users can effectively document and manage their test process from a central location and report on application readiness.Oracle Application Testing Suite provides a powerful integrated scripting platform for automated functional & regression testing and load testing. Oracle Functional Testing’s OpenScript integrated scripting interface provides a unique combination of ease-of-use and flexibility through its intuitive graphical scripting interface and powerful Java IDE for extending scripts at the code-level. Oracle Functional Testing also provides custom capabilities for testing SOA and Oracle packaged applications through its integrated testing accelerators. Oracle Load Testing provides a fully Web-based user interface for configuring and running load tests and an integrated ServerStats module for monitoring application infrastructure during a load test to identify bottlenecks. Oracle Load Testing also enables multi-user collaboration by allowing testers to view and share real-time results during load test execution through their browser. With Oracle Application Testing Suite users can leverage a comprehensive, integrated solution for automated functional and regression testing, load testing and test process management.Contact UsFor more information about Oracle Application Testing Suite Oracle E-Business Suite Accelerators and Oracle Enterprise Manager please visit or call+1.800.ORACLE1 to speak to an Oracle representative.Copyright © 2011, Oracle and/or its affiliates. All rights reserved.This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd. 0110。
Oracle应用测试套件和实际应用测试解决方案说明书
The solutions consist of three distinct offerings.Oracle Application Testing Suite •(includes Oracle Test Manager, Oracle Functional Testing, and Oracle Load Testing)Oracle Real Application Testing • Oracle Data Masking Pack•T ogether these solutions enable you to manage your entire quality assurance (QA) process, including defining test requirements, executing automated and manual test cases, and tracking subsequent defects.Simplify T est Process ManagementManaging QA and testing programs for applications is more challenging than ever. Applications and their environments continue to grow more complex, making it increasingly difficult to understand the requirements for successful testing. Oracle T est Manager includes a flexible, easy-to-use process management solution on which you can build and organize your entire testing program.Organizations are getting ahead in today’s competitive environment by turning to the internet to improve business agility, reduce costs for the delivery of goods and services, and reach more customers. However, the internet business paradigm can create new and complex challenges. An inability to deliver a consistent, high-quality experience can put customer loyalty at risk and threaten revenue opportunities. Fixing performance issues before going live is resource-intensive and may result in time-to-market delays, but it’s still much less expensive than solving the same problems in a live production system. Y ou need a solution that lets you deploy higher-quality applications with less cost and effort. Oracle’s application-quality management solutions thoroughly test your packaged, Web-based, and service-oriented architecture (SOA)–based applications to ensure the quality, scalability, and availability of the applications and their underlying infrastructure.Deploy Higher-Quality Applications in Less Time with Secure, Comprehensive TestingHow can you ensure that your mission-critical applications perform well and comply with government regulations in the face of evolving technology, limited understanding of test parameters, and understaffed testing and development teams? The answer is simple when you test with Oracle’s application-quality management solutions.QualiTy aPPlicaTion TeSTing froM oracleThe following offerings comprise Oracle’s application-quality management solutions:Oracle Application Testing Suite • Oracle Real Application Testing • Oracle Data Masking Pack•The following products make up Oracle Application Testing Suite:Oracle Test Manager • Oracle Functional Testing • Oracle Load Testing•Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.10049850 | C17386conTacT uSTo learn more, call +1.800.ORACLE1 to speak to an Oracle representative or visit /goto/application-quality. Outside North America, visit /corporate/contact/global.html to find the phone number foryour local Oracle office.Deploy Databases with confidenceHardware and software upgrades are essential for maintaining a competitive edge and complying with changing security and privacy laws. Even though system changes are designed to have a positive business impact, they can also lead to unexpected and undesirable behaviors and performance.Oracle Real Application Testing lets you safely and rapidly adopt new database and infrastructure technologies by reducing the testing effort and the time required to ensure the robustness and quality of applications. Oracle RealApplication T esting has the unique ability to record real-world database workloads and replay them in test environments while maintaining the characteristics of the production workloads. This enables you to identify and fix performance issues and minimize undesirable results such as service outages and performance degradations.realize faster returns on investmentOracle’s application-quality management solutions maximize the efficiency of your testing, QA, and operations teams by helping themPlan testing processes• Execute rigorous functional and •performance testsReport on application readiness in •real-world deployment schedulesY ou can define testing requirements, specify and execute manual and automat-ed tests to validate those requirements, and manage the defects that the tests uncover. Coordinating your entire QA program on a single, unified platform lets you manage quality as a process through-out the lifespan of your applications.ensure functional reliabilityProperly functioning applications enhance the end-user experience and increase customer loyalty. The quickest way to ensure the functional reliability of your applications is through functional and regression testing.Oracle Functional Testing tests the functional reliability of today’s cutting-edge .NET and J2EE Web applications, as well as Oracle packaged applications. By simplifying and automating functional and regression testing, you can stream-line the scripting process and build test cases without manual checkpoints, saving your organization time and money.Maximize application PerformanceOrganizations doing business over the internet know that the costs associated with poor application performance can be staggering—especially during peak business volumes. To ensure that your applications are performing at their best, you need to analyze your applications and their infrastructure under extreme stress and then fine-tune them both for optimal performance before you go live. OracleLoad T esting lets you easily and accurately test the load performance and scalabil- ity of your Web-based software and services. Y ou can execute real business transactions while simulating hundreds of thousands of concurrent users to analyze performance under an extreme load. Y ou can also monitor your back-end application infrastructure during load tests and identify—at the source—the hard-to-find performance bottlenecks that cause application slowdowns.Protect Sensitive enterprise DataInformation leaks are responsible for a growing number of identity theft and fraud incidents every year. Whether or not your organization does business over the internet, it is imperative that you safe-guard production data and prevent leaks of sensitive or confidential information. Oracle Data Masking Pack helps organiza-tions comply with privacy and confidential-ity laws during the entire QA process. The solution uses masking rules to replace sensitive data in the database with scrubbed, realistic-looking data, letting your QA staff use real data and authentic application and database scenarios in their testing processes. By helping the QA staff maintain the integrity of your applications and mask confidential data in development, test, and staging environments, you can decrease the costs and risks associated with deploying higher-quality products,applications, and services.Testing Suite can help you reduce testing times by“Oracle Real Application Testing provides a unique tool that enables us to significantly improve our speed in rolling out technology, and reduces our costs associated with critical testing.”Erzsébet Szirjákné Birkás, expert of System Programming, Mol Hungarian oil and gas company (Mol group)。
Oracle数据库安全测评指导书
应提供符合业务系统要求的备份策略，并符合 测评要求。
时，能及时恢复数据；
2)每天至少进行一次全备份，并将备份介质存放在场外。
第 4 页，共 4 页
审计记录应包含要求的要素。
select sel,upd,del,ins,gra from dba_priv_audit_opts
3
安全审计
安全事件记录：日期和时 间、类型、 主体标识、 客体标识、事件的结果等
手工检查 记录一条日志内容，确认其包括事件发生的日期与时间、触发事件 的主体与客体、事件的类型、事件成功或失败、身份鉴别事件中请 求的来源(如末端标识符)、事件的结果等内容。
评测项
检测方法
预期结果
覆盖每个用户
手工检查 1)执行 select value from v$parameter where name='audit_trail'，查看是否开启审计功 能； 2)用不同的用户登录数据库系统并进行不同的操作，在 Oracle 数 据库中查看日志记录是否满 足要求。
应开启审计功能，并对每个用户的操作都有记 录。
2)检查 utlpwdmms.sql 中"--Check for the minimum length of
应启用复杂度函数，对口令的复杂度有一定要 求。
the password"部分中
"length(password)<"后的值；
3)或者：查看口令管理制度以及执行记录，并选择验证。
访谈
1)询问数据库的身份鉴别方式，是否使用其他鉴别技术； 手工检
应配置空闲超时设置。
资源限额；
4
资源控制
手工检查 1)确定用户使用的 profile：select username,profile from dba_users，针对指定用户的 profile，查看其限制(以 default 为例)； 2)使用命令 select limit from dba_profiles where profile='DEFAULT' and resource_name='SESSION_PER_USER'； 3)使用命令 select limit from dba_profiles where
(完整版)5-数据库安全测评(S3A3G3)-Oracle
主机
身份鉴别（S） b) 操作系统和数据库系统管理用户身份鉴别信息应具有不易被冒用的特点，口令应有复杂度要
1 1）检查主要服务器操作系统和主要数据库管理系统，查看其身份鉴别信息是否具有不易被冒用的特点，如对用户登录口令的最小长度、复杂度和更换周期进行的要求和限制； 2）渗透测试主要服务器操作系统，可通过使用口令破解工具等，对服务器操作系统进行用户口令强度检测，查看是否能够破解用户口令，
层
控制点 要求项 权重 测评实施 测评结果 符合 程度
主机
身份鉴别（S） c) 应启用登录失败处理功能，可采取结束会话、限制非法登录次数和自动退出
0.5 1）检查主要服务器操作系统和主要数据库管理系统，查看是否已配置了鉴别失败处理功能，并设置了非法登录次数的限制值；查看是否设置网络登录连接超时，并自动退出； 1）执行命令：select limit from dba_profiles where profile=’DEFAULT’ and resource_name=’FAILED_LOGIN_ATTEMPTS’，查看其值是否为unlimited，如果其值不为unlimited则说明进行了登录失败尝试次数的限制，如设置了登录失败尝试次数，则执行命令：select limit from dba_profiles where profile=’DEFAULT’ and resource_name=’PASSWORD_LOCK_TIME’，查看
1）查看每个登录用户的角色和权限，是否是该用户所需的最小权限。 查看所有权限： Select * from dba_users; Select * from all_users; Select * from user_users; 查看用户系统权限： Select * from dba_sys_privs; Select * from role_sys_privs; Select * from user_sys_privs; Select * from session_privs; 查看用户对象权限： Select * from dba_tab_privs; Select * from all_tab_privs;
OracleERPVMI用户手册1.pptx
Create Blanket Purchase Agreement (BPA)
BPA : 5009946 5009947 5009944
5009945 5009948
07000971MMT 07003921MMM 0M000461MPMF 05002681MMJ 0B001061MMM
APS instance IMJ VMI Planner responsibility
VMI User’s Guide
forecast Setup VMI items
Setup ASL Check on_hand Setup combination
Create BPA
Data collection Release job
Run ASCP and VMI Replenish Engine Release PO
If Automatic release authority set as None (IMJPLANNER received this approval request notification)
Not using this method !!
Collaborative Planning (CP) Released by IMJPLANNER
Dummy Std. PO V******* received by supplier
EXPEDITORS login IMJ VMI Consign responsibility for bonded warehouse
Perform receiving trx. against V-po
Perform Subinventory Transfer from EXPD to RM_IMJ
2023年度Oracle数据库管理系统性能测试报告
2023年度Oracle数据库管理系统性能测试报告一、引言本报告旨在对2023年度Oracle数据库管理系统的性能进行全面测试和评估，为数据库管理员和相关决策者提供准确的数据和建议，以优化系统的性能和效率。
二、测试环境本次测试使用的环境如下：- 操作系统：Windows Server 2019- 数据库管理系统：Oracle Database 19c- 处理器：*************************- 内存：128 GB- 存储：SSD RAID 10三、测试目标本次测试旨在评估Oracle数据库管理系统在以下方面的性能：1. 数据库的读写性能2. 并发用户访问下的表现3. 数据库查询的响应时间4. 系统的容错能力四、测试方法1. 压力测试：通过模拟大量用户并发访问数据库，观察系统的响应时间和吞吐量。
2. 负载测试：向数据库中插入大量数据，以测试其性能和稳定性。
3. 系统参数调优：根据测试结果和需求，对数据库系统参数进行调整，以提升系统性能和效率。
4. 容错测试：模拟系统故障和数据库崩溃情境，评估系统的恢复能力和数据完整性。
五、测试结果1. 数据库读写性能：根据压力测试数据显示，Oracle数据库管理系统在高并发读写场景下表现出色，平均响应时间低于100毫秒，并发用户数超过1000。
2. 并发用户访问表现：负载测试表明，数据库系统能够稳定处理大量并发用户的访问请求，响应时间基本稳定在200毫秒以内。
3. 数据库查询响应时间：查询响应时间测试显示，Oracle数据库管理系统能够在100毫秒内迅速响应复杂的SQL查询。
4. 系统容错能力：容错测试结果表明，系统在面对故障和崩溃情境时，能够快速恢复并保持数据的一致性。
六、测试结论根据以上测试结果，可以得出以下结论：1. 2023年度Oracle数据库管理系统具备出色的读写性能和并发处理能力，适用于大型企业和数据库密集型应用。
2. 数据库的查询响应时间迅速，可以满足用户对数据实时性的需求。
Oracle测试工具Orion使用说明
Oracle测试工具Orion使用说明orion 运行时必须输入完整的路径名称，否则加变量一样报错orion 依赖libaio库，可以使用apt-get install libaio-dev来安装orion 运行必须包含-run,-num_disks,-testname三个参数強制参数-run 一共有5种模式：simple 先运行random 8K然后运行random 1Mnormal 混合运行random 8K和1Madvanced 根据用户自定义来运行测试自定义参数如下：-size_small 定义最小的IO，默认是8，单位只能是Kb-size_large 定义最大的IO，默认是1024，单位只能是KB-type 定义是随机还是顺序，rand随机，seq顺序，默认随机-num_streamIO 定义顺序测试下，每一段流的最大IO数量，默认是4-simulate orion将所有磁盘虚拟成一种模式来提供测试，concat(磁盘串联，理论上就是无并发的状态，从一个lun到另一个lun），raid0（模拟成raid0,默认条带大小是1M)默认是concat-stripe 调整模拟raid0的条带大小-write 写入操作的百分比（默认为0），在大IO流中（顺序测试），每一段流要么是读，要是写-cache_size 单位是M，默认是先在raid卡的缓存上写两分钟，这样在大IO进来时，缓存可以发挥作用，如果设置为0，则是每一段大IO后面都跟随着一个随机的不可测算的IO，分离数据，让raid卡缓存失效，设置为其他数值就是写入多大的cache-duration 每一段数据点的持续时间，默认是60秒-matrix 创建由不同大小的IO组成的orion测试二维矩阵，矩阵的每一列代表的是小IO，每一行代表的是大IO，矩阵的第一行不包含小IO，第一列不包含大IO，测试可以只是测试一个点，或者一行，一列，乃至整个矩阵由以下参数控制矩阵（默认是basic）：basic - 测试第一行和第一列，就是simple模式，分开测试大小IOdetailed - 测试整个矩阵，就是normal模式point - 测试由num_small, num_large参数生成的点，小IO和大IO都是固定的col - 大的连续/随机IOrow - 小的连续/随机IOmax - 和detailed一样，只不过始终保持最大负载-num_small 设置随机小IO的总数，无默认值，只能在-matrix (point,col,max)下使用-num_large 设置随机大IO或者并发流的大小，只能在-matrix (point,row,max)下使用-verbose 打印进度和状态到控制台dss 运行random 1M，逐渐加强压力，直到达到最大throughput，大约耗时22分钟oltp 运行random 8K，逐渐加强压力，直到达到最大IOPS，大约耗时22分钟強制参数 -testname预先定义一个testname.lun，里面写上要测试的文件名称（可以指定某个磁盘文件，orion不能直接对某个目录测试），可以是多个：#vi oriontest.lun#cat oriontest.lun/dev/sdb/dev/sdc/mnt/nastest強制参数 -num_disks ，一次性运行的job数量（每个job一个磁盘），默认是写在testname.lun文件下的磁盘数量简单范例：假设orion_x86_64在/bin目录下。
oracle压力测试过程
Oracle10g中可以使用两个命令就可以知道，该版本的数据库系统是下载版还是商业版，使用两个命令就可以确定。
最大session数：show parameters session.....................170 sessions //170是下载版数值当前连接数：select * from v$bgprocess最大进程数：show parameters process....................150 processes //150也是下载版数值查看当前连接到数据库的用户：select * from v$session默认系统最大session=min( session,process * 1.1 +5 )2SELECT * FROM V$PARAMETER WHERE NAME LIKE 'proc%'；SQL>SQL> show parameter processesNAME TYPE V ALUE------------------------------------ ------- ------------------------------aq_tm_processes integer 1db_writer_processes integer 1job_queue_processes integer 4log_archive_max_processes integer 1processes integer 200这里为200个用户。
Select * from v$license 其中sessions_highwater纪录曾经到达的最大会话数。
3如何调整Oracle参数,使它支持更多的用户连接,在参数文件中有三个参数processeslicense_max_sessionslicense_max_users这三个参数相互作用影响着用户连接数license_max_sessions （同时连接数据库的会话数）license_max_users （数据库能够创建的用户数）如果设置为0就是不加限制。