Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle capability i / o (stress test database server i / o performance)     - Zabbix monitors the status of TCP connections (Server)

- pkg-config to use (Linux)

- Single Instance ASM under CRS-4124, CRS-4000 error handling (Database)

- Linux system started to learn: Teaches you install Fedora 22 on VirtualBox (Linux)

- Elasticsearch 2.20 Highlight (Server)

- Use $ BASH ENV variable to mention the right way under Linux (Linux)

- View and modify Linux machine name (Linux)

- Configuring s3c-linux- appears Unable to find the QT3 installation (Linux)

- Install Redis 2.6 5.5 32 position CentOS error resolved (Linux)

- Oracle Standby Redo Log experiment (Database)

- Create, modify, delete users, user groups under linux (Linux)

- Oracle 10046 Event (Database)

- iOS in the event delivery and the responder chain (Programming)

- Examples of safety testing system notes for RedHat Linux (Linux)

- Using C / C ++ extensions Python (Programming)

- A brief description of Java 8 new features introduced syntax (Programming)

- Nginx Beginner Guide (Server)

- About Hibernate cache, you want the latest data have trouble even session.clear (Database)

- Docker: Mirroring and container operations (Server)

- New experience Budgie (Budgerigar) desktop environment (Linux)

  Oracle capability i / o (stress test database server i / o performance)
  Add Date : 2018-11-21      
  Briefly explain one of the factors affect how redo data, that is, i / o throughput, Oracle media recovery depends on i / o, if i / o bottlenecks, it will certainly affect the standby database media recovery.
Then i / o stack contains hbas, storage-related switches, the physical disk storage. Then the oracle is recommended when the application is deployed, it is recommended to verify the i / o avoid problems. But there is a problem before it sting, and that is how to verify i / o throughput side, in other words how to verify i / o throughput is more in line with real production environment.
  In Oracle Database 11g, the Real Application Testing feature (Capture / Replay) was introduced to inject real (captured) workload into the system. However, another new 11g feature is available to help assess the I / O capability of the database's storage system, and gauge maximum IOPS and Mbytes / s.

  capability i / o feature is based on a database of internal functions (dbms_resource_manager.calibrateio ()), this function is integrated inside the oracle database, to better meet the test i / o problems, and in the final report information related to the output.
  Then execute the package need to pay attention to what?
1, permissions, you must have the sysdba privileges to perform this procedure, you need to open additional timed_statistics.
2. Determine the asynchronous i / o all data files and temporary files in the database have been used to start, we can v $ datafile and v $ views associated iostat_file be confirmed.
col name format a50
 select name, asynch_io from v $ datafile f, v $ iostat_file i
 where f.file # = i.file_no
 and (filetype_name = 'Data File' or filetype_name = 'Temp File');
If asynchronous i / o does not start, set disk_asynch_io = true start of this feature, it is enabled by default, if the linux biggest slots used up, it will automatically turn off Karma function, which is why although a disk_asynch_io = true up but still did not achieve the desired effect. The biggest slots can check / proc / sys / fs / aio-max-nr currently in use can be viewed / proc / sys / fs / aio-nr to confirm respectively.
3. Make sure the server only needs to open the test database, to avoid affecting other applications.
4, for the RAC, the need to ensure that all instances are open, because you will do a comprehensive proofreading for all nodes, perform the procedure to just one instance.
5, to ensure that only a user to perform a proofreading i / o operations. You can view the current status identified by v $ io_calibration_status.
Also we learned that there are so few data View procedure:
The calibration will run in different phases. In the first phase, small block random I / O
 workload is performed on each node and then concurrently on all nodes. The second
 phase will generate large block sequential I / O on each node. Note, that the Calibrate
 I / O is expecting that a datafile is spread across all disks specified in NUM_DISKS
 variable. Furthermore, offline files are not considered for file I / O.
Once completed, the results will be present in dba_rsrc_io_calibrate table.
All right.
Learned these, you can start to experiment operation. Let practice was truth.
The syntax is as follows:
  lat INTEGER;
  iops INTEGER;
  mbps INTEGER;
    DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat);
  DBMS_OUTPUT.PUT_LINE ( ​​'max_iops =' || iops);
  DBMS_OUTPUT.PUT_LINE ( ​​'latency =' || lat);
  DBMS_OUTPUT.PUT_LINE ( ​​'max_mbps =' || mbps);
 Parameters as follows:
Parameter Description
  Approximate number of physical disks in the database storage (physical disk number input)
  Maximum tolerable latency in milliseconds for database-block-sized IO requests (the maximum available number of milliseconds delay tolerant input)
  Maximum number of I / O requests per second that can be sustained. The I / O requests are randomly-distributed, database-block-sized reads. (Continued in requests per second maximum i / o number of output)
  Maximum throughput of I / O that can be sustained, expressed in megabytes per second. The I / O requests are randomly-distributed, 1 megabyte reads. (Maximum sustained throughput M units)
  Average latency of database-block-sized I / O requests at max_iops rate, expressed in milliseconds (average delay)
- Graphic Git (Linux)
- CentOS7 yum install third-party source EPEL (Linux)
- Java multi-threaded communications pipeline flow (Programming)
- Python image processing library (PIL) to install and simple to use (Linux)
- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)
- The Zabbix2.4.5 source compiler installation under Ubuntu 14.04 (Server)
- and localhost difference (Server)
- Try to use Lets Encrypt (Linux)
- Mistakenly deleted redo log file group being given the lead to start the database ORA-03113 (Database)
- SSL VPN SSL VPN access to security websites patron (Linux)
- To install GCC development environment under SUSE11 (Linux)
- How to download video youtube-dl in Linux (Linux)
- Linux Demo dd IO test (Linux)
- Construction CA certificate using OpenSSL command line (Server)
- CentOS 6.5 three ways to configure the IP address (Linux)
- Hive handle count distinct inclination to produce data processing (Database)
- How to disable UEFI to install Linux on Win8 (Linux)
- Linux administrator should command: sed and awk (Linux)
- ORA-01839 error caused by incorrect system date setting (Database)
- Binding unofficial Google Drive and Ubuntu 14.04 LTS (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.