Oracle uses bare devices to store data

Source: Internet
Author: User

Under normal circumstances to write data to the table first through the library, the library to tell the operating system, the operating system to find the disk, after 3 steps!


Table----> Libraries----> Operating systems----> disks


Bare devices do not have a file system, at the system level can not control the disk, this is the bare device.

Bare equipment directly to the library, I will save data, data, library and disk direct interaction, not through the system layer, less a layer of patrol, can improve speed.

We ext3 the default block 4 K, the database of the default block 8 block, the data will certainly be stored in the disk, if the system layer must be 4K saved, need to convert it, relatively more troublesome.




The benefits of the bare device, skip the operating system layer directly to find the disk, the system layer has not recognized the disk, it uses the disk as a file "This file can not be stored directly, to Oracle use"



When you install Oracle, you can use 3 types of storage:

1. File system

2. Bare Equipment

3. ASM




Benefits of using bare devices

Since the use of bare devices avoids the layer of the operating system, the data is transferred directly from disk to Oracle,

Therefore, using bare devices can greatly improve the performance of database system for read-write database applications.

Of course, this is a very large disk I/O, disk I/O is already known as a system bottleneck in the case of the establishment.

If disk reads and writes are so frequent that disk reads and writes become a system bottleneck,

Then the use of bare equipment can greatly improve performance, the maximum can even increase to 40%, very obvious.


"10.0. Version 2.3 only started to support bare devices "


Power off, add a piece of disk



[[email protected] ~]# fdisk-l "View disk Partition"

[[email protected] ~]# fdisk/dev/sdb "N P 1 return car +100m w"

[[email protected] ~]# fdisk/dev/sdb "N P 2 return car +100m w"


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6D/D6/wKioL1VtUHjSA5evAAH2PA4K43c934.jpg "title=" 1.png " alt= "Wkiol1vtuhjsa5evaah2pa4k43c934.jpg"/>


Create PV, create VG


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/D6/wKioL1VtULezRb93AAHuSiNY0_M059.jpg "title=" 2.png " alt= "Wkiol1vtulezrb93aahusiny0_m059.jpg"/>


Create LV


650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/D6/wKioL1VtUv2ya8-0AABk7jWNxoU006.jpg "title=" 3.png " alt= "Wkiol1vtuv2ya8-0aabk7jwnxou006.jpg"/>


binding, Authorization, querying

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6D/DA/wKiom1VtUYrDFyrpAADTHHyPDh0761.jpg "title=" 4.png " alt= "Wkiom1vtuyrdfyrpaadthhypdh0761.jpg"/>


Using Bare devices in Oracle

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6D/DA/wKiom1VtT_ySnHlrAALnaMRGE8s526.jpg "title=" 5.png " alt= "Wkiom1vtt_ysnhlraalnamrge8s526.jpg"/>



Note

Archived logs cannot be placed on bare devices and can only be placed on the file system or on tape

)


This article is from "Allen Lee Oracle" blog, please make sure to keep this source http://lipengfei666666.blog.51cto.com/6384154/1657500

Oracle uses bare devices to store data

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.