![]() ![]() The following dd command performs random sequential disk access across two devices reading a total of 2 GB. To estimate the maximum throughput Oracle Database will be able to achieve, you can mimic a workload of a typical data warehouse application, which consists of large, random sequential disk access. Skip=BLOCKS: skip BLOCKS BYTES-sized blocks at start of input Write to disk would erase all existing data!!! Of=FILE: write to FILE set to /dev/null to evaluate read performance If=FILE: read from FILE set to your device Use the conversion in Table 2-1 to convert the vendors' maximum throughput numbers in bits into sustainable throughput in bytes.įirst, the most important options for using dd are: bs=BYTES: Read BYTES bytes at a time use 1 MBĬount=BLOCKS: copy only BLOCKS input blocks The initial throughput you estimated and the hardware specifications from the vendors are the basis to determine the quantities of the individual components you need. Wires that connect the individual components.Įach of the components must provide sufficient I/O bandwidth to ensure a well-balanced I/O system. ![]() The interconnect must be sized separately, taking into account factors such as internode parallel execution. In an Oracle Real Application Clusters (Oracle RAC) environment, you need an additional private port for the interconnect between the nodes that you should not include when sizing the system for I/O throughput. Switches, in between the servers and a storage area network (SAN) or network attached storage (NAS).Įthernet adapters for network connectivity (GigE NIC or Infiniband). Host bus adapters (HBAs), the connectors between the server and the storage. A well-balanced I/O system must provide approximately the same bandwidth across all components in the I/O system. The end-to- end I/O system consists of more components than just the CPUs and disks. How Do I Determine Sufficient I/O Bandwidth? Ask your disk vendor for the throughput numbers of the disks. Use the following formula to determine the number of disk arrays you need:įor example, a system with 1200 MB per second throughput requires at least 1200 / 180 = 7 disk arrays.Įnsure you have enough physical disks to sustain the throughput you require. An average disk controller has a maximum throughput of 2 Gb per second, which equals a sustainable throughput of about (70% * 2 GB/s) /8 = 180 MB/s. Note that storage providers measure in Gb per second, and your initial throughput estimate is based on MB per second. ![]() Use the storage provider's specifications to find out how much throughput a disk array can sustain. Use the maximum throughput you require to find out how many disk arrays you need. Sizing that is based exclusively on storage requirements will likely create a throughput bottleneck. Subsequently, you can install a demonstration to help you learn how to complete common data warehousing tasks using Warehouse Builder.Ī commo n mistake in data warehouse environments is to size the storage based on the maximum capacity needed. Optimize the Database for use as a data warehouse as described in "Setting Up a Database for a Data Warehouse".Īccess the Oracle Warehouse Builder software.įollow the instructions in "Accessing Oracle Warehouse Builder". See the installation instructions in Oracle Database 2 Day DBA or the installation guide for your platform, such as Oracle Database Installation Guide for Linux Size and configure your hardware as described in "Preparing the Environment". Subsequently, you configure Oracle Warehouse Builder (OWB), which leverages Oracle Database and provides graphical user interfaces to design data management strategies. The procedures in this section describe how to configure Oracle Database for use as a data warehouse. General Steps for Setting Up a Data Warehouse System ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |