... 3 Oracle on Linux I/O I/O... 5 I/O io_request_lock... 6 I/O GB RAM SGA GB RAM Very Large M

Similar documents
Linux上のOracle Real Application Clustersの記憶領域オプション

Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005との技術的比較

Acronis Backup & Recover 10 Deduplication

untitled

untitled

Recovery Managerのバックアップおよびリカバリの最適化

Oracle Identity Managementの概要およびアーキテクチャ

Oracle Database 10gのOracle Data Guard

Red Hat Enterprise Linux 2.1 ASからRed Hat Enterprise Linux 3へのアップグレード時のOracle Database 10g環境の保持

自己管理データベース: 自動SGAメモリー管理

Oracle Enterprise Manager 10g R2 Grid Control: データベース管理の新機能

untitled

オラクルのバックアップとリカバリの必須要件

new_logo.eps

今から間にあう仮想化入門とXenについて

Oracle Application Server10g (9.0.4) - OracleAS PortalによるOracleAS Web Cacheの配置

Windows SE RAC 10g 構築手順書

Oracle Database 10g Release 2を使用したデータベース・パフォーマンス

Oracle DatabaseとIBM DB2 UDBの技術的比較: パフォーマンスを重視

Microsoft SQL Server 2012 における EMC パフォーマンスの高速化EMC VFCache、EMC Symmetrix VMAX 10K、および EMC FAST VP

日本語タイトルを入力

<Documents Title Here>

Oracle Application Server 10g Release 3(10.1.3)- アジャイル・エンタープライズ(俊敏な企業)のためのデータ・アクセス

VNSTProductDes3.0-1_jp.pdf

Oracle HTML DB 導入ガイド

INR-HG5290b_users_Linux-RHEL4_.doc

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2

INR-HG5579a_Netshut_Guide_Linux-Solaris_.doc

Copyright 2006 KDDI Corporation. All Rights Reserved page1

untitled


HP High Performance Computing(HPC)

Microsoft Word - 01-RAC11gR2_for_HPUX-overview.doc

Office BCP () Office Microsoft Exchange Exchange Server Exchange Online Exchange Server Exchange Online Exchange Exchange 1997 Exc

A book

untitled

FUJITSU Software Systemwalker Operation Manager V13 カタログ

1 Microsoft Windows Server 2012 Windows Server Windows Azure Hyper-V Windows Server 2012 Datacenter/Standard Hyper-V Windows Server Windo

GRマルチパスドライバ(Linux版)サポートOS・機種、接続条件

untitled

untitled

SANworks

Oracle Application Server 10g (9.0.4): Manually Managed Cluster

日本語タイトルを入力

PrintWalker/LXE インストールガイド

<Documents Title Here>

EMC NetWorker Module for Microsoft SQL Server リリース5.2 SP1インストール・ガイド

1 / 1 idrac8 CPU 1 Intel Xeon E v5 Intel Pentium Intel Core i3 Intel Celeron Intel C236 Microsoft Windows Server 2008 R2 SP1 Microsoft Windows S

keysql42_usersguide

相続支払い対策ポイント

150423HC相続資産圧縮対策のポイント

ハピタス のコピー.pages

Copyright 2008 All Rights Reserved 2

KDDI

1996 Only One Technology NetJapan System Data Protection Solutions 2009 ActiveImage Protector ActiveImage Protector OS NetJapan System Protection Solu

untitled

クラウド時代のインフラ構成/変更管理とコンプライアンス管理

Northern Lights Server

sanboot-whitepaper.pdf

▼ RealSecure Desktop Protector 7

Microsoft Windows向けOracle Database 12cでのOracleホーム・ユーザーの導入

untitled

キャラクタ・セットの移行に関するベスト・プラクティス

INR-HF51882d_users_Linux-Solaris_.doc

untitled

スライド 1

konicaminolta.co.jp PageScope Net Care

Oracle8簡単チューニング for Windows NT

Dell Red Hat OpenStack - Version Dell Inc.


HPE Moonshot System ~ビッグデータ分析&モバイルワークプレイスを新たなステージへ~

意外と簡単!? Oracle Database 11g -バックアップ・リカバリ編-

11U Dell CPU RAID 1U 1 Intel Xeon E v5 Intel Pentium Intel Core i3 Intel Celeron Intel C236 Microsoft Windows Server 2008 R2/2008 R2 SP1 Standar

EMC Celerra NS-480システム(4ブレード)インストール ガイド

Oracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6

PRIMEQUEST 1000シリーズ Linux設計ガイド

Enterprise Software Support(ESS)とEnterprise Software Support Standard(ESS Standard)のサポート対象OSおよびアプリケーションリスト

mvd_nas_2.0.5_release_notes_v1_ja.doc

Printer Driverセットアップ編


Copyright 2009 Sun Microsystems, Inc Network Circle, Santa Clara, CA U.S.A. All rights reserved. Sun Microsystems, Inc. ( Sun Microsystems

support.book

Copyright 2008 NIFTY Corporation All rights reserved. 2

VMware VirtualCenter: Virtual Infrastructure Management Software

NEC Storage series NAS Device

Standard Features 550MHz ProLiant 6400R 6/550-2M /550-1M / MHz ProLiant 6400R 6/500-

PRIMEQUEST 1000シリーズ Linux運用ガイド

Oracle Secure Enterprise Search 10gを使用したセキュアな検索

untitled

untitled

HP ProLiant Gen8とRed Hatで始めるHadoop™ ~Hadoop™スタートアップ支援サービス~

Ver. 3.7 Ver E v3 2.4GHz, 20M cache, 8.00GT/s QPI,, HT, 8C/16T 85W E v3 1.6GHz, 15M cache, 6.40GT/s QPI,, HT,

名称未設定

自己管理型データベース: 自動SGAメモリー管理

初心者にもできるアメブロカスタマイズ新2016.pages

- 2 Copyright (C) All Rights Reserved.

Using a Remote Desktop Connection with FileMaker Pro

PRIMEPOWER / PRIMERGY Interstage 1

untitled

Oracle_for_SAP :29 PM ページ 2 2 3

Transcription:

Oracle9i Release 2 on Linux: Red Hat Linux Advanced Server 2.1 2002 6

... 3 Oracle on Linux... 3... 3... 4 64 I/O... 4... 4 I/O... 5 I/O... 5... 6 io_request_lock... 6 I/O... 6... 7 4GB RAM SGA... 7 64GB RAM Very Large Memory VLM... 9... 10... 11... 12 PTE... 12 Oracle9i Release 2 RAC... 12... 13 lsraid... 13... 13... 13 64... 14... 14 Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 2

Oracle9i Release 2 on Linux: Red Hat Linux Advanced Server 2.1 Linux IT Linux Linux Linux Advanced Server Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 Oracle on Linux Linux UNIX Oracle9i Release 2 on Linux UNIX Solaris HP-UX Tru64 Oracle Linux Oracle UNIX Oracle9i Release 2 on Linux Windows UNIX Oracle on Linux Windows 1 Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 3

SGA PGA 3GB 32 Intel Pentium 3GB 8TB 64 Oracle9i Release 2 Red Hat Linux Advanced Server 2.1 Linux ext2 Oracle RAW RAW I/O RAW RAW RAC 64 I/O Linux 64 I/O Intel Pentium 32 Oracle9i Release 2 64 2GB 4GB 1 64K 1 400 16KB Oracle 64GB 16KB. 4PB Linux Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 Oracle on Linux Intel 32 IA-32 Oracle9i Release 2 Itanium 2 64 IA-64 Red Hat Linux Advanced Server Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 4

I/O Oracle I/O Advanced Server I/O I/O I/O I/O 1 I/O Advanced Server I/O I/O I/O I/O I/O I/O Oracle 1 I/O I/O I/O Oracle9i Release 2 I/O Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 Linux Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 I/O Redhat 1) $ORACLE_HOME/rdbms/lib a) make -f ins_rdbms.mk async_on b) make -f ins_rdbms.mk ioracle 2) I/O $ORACLE_HOME/rdbms/lib a) make -f ins_rdbms.mk async_off b) make -f ins_rdbms.mk ioracle 3) RAW init.ora a) disk_asynch_io TRUE 4) init.ora a) Oracle I/O ex2 Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 5

b) disk_asynch_io TRUE c) filesystemio_options asynch IA-32 1 GB 1GB Linux I/O I/O I/O Red Hat Linux Advanced Server 2.1 io_request_lock Linux 1 I/O I/O 1 I/O Red Hat Linux Advanced Server 2.1 I/O SMP I/O I/O Dell HP/Compaq EMC I/O io_request_lock Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 6

Oracle Linux VM Virtual Memory: VM Oracle Linux Virtual Memory in Red Hat Linux Advanced Server 2.1 and Oracle s Memory Usage Characteristics Shared Global Area: SGA Oracle SGA SGA SGA OS VM VM 4GB RAM SGA Red Hat Linux Advanced Server 2.1 RAM 4 GB Linux 2 Oracle SGA 1.7GB Red Hat smp 4GB RAM 2 Linux Advanced Server 2.1 /proc Linux 1 enterprise 64GB RAM Oracle RAM 3 SGA Linux Oracle 4GB RAM 2 2 CPU Oracle Oracle SGA smp Oracle 0x50000000 Linux Oracle Oracle Advanced Server 2.1 Oracle SAG Oracle cd $ORACLE_HOME/lib cp -a libserver9.a libserver9.a.org cd $ORACLE_HOME/bin cp -a oracle oracle.org cd $ORACLE_HOME/rdbms/lib Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 7

genksms -s 0x15000000 >ksms.s SGA 0x15000000 make -f ins_rdbms.mk ksms.o SGA make -f ins_rdbms.mk ioracle Linux Oracle SGA Advanced Server 2.1 /proc Oracle Oracle Oracle Oracle su root Oracle ID Oracle echo $$ Oracle 0x10000000 echo 268435456 >/proc/<pid>/mapped_base <pid> ID Oracle SGA 1 shmmax. echo 3000000000 >/proc/sys/kernel/shmmax Oracle Oracle SGA Oracle db_cache_size db_block_buffers init.ora Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 8

64GB RAM Very Large Memory VLM 4GB Advanced Server 2.1 Oracle 32 Intel RAM 4GB enterprise 3 Oracle VLM Very Large CPU Memory Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 RAM SGA 62GB 4GB RAM RAM SGA VLM SGA VLM Linux init.ora Linux OS : root /dev/shm mount -t shm shmfs -o nr_blocks=2097152 /dev/shm 8GB /dev/shm nr_block 4096 Oracle Oracle /dev/shm init.ora : init.ora use_indirect_data_buffers=true db_cache_size db_2k_cache_size db_4k_cache_size db_8k_cache_size db_16k_cache_size db_32k_cache_size db_block_buffers Oracle9i Release 2 VLM init.ora use_indirect_data_buffers=true Oracle SGA Linux Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 9

Oracle 512MB Oracle VLM_WINDOW_SIZE : VLM_WINDOW_SIZE=1073741824 1GB 64KB : Oracle attach SGA /proc/<pid>/mapped_base Oracle ORA-3113 attach IA-32 2 4KB Linux 4KB Advanced Server 2.1 Oracle9i Release 2 SGA 2MB 4MB Page Size Extension: PSE SGA Linux 4GB 4MB CPU 2 IA-32 2 Physical Address Extension: PAE 3 4KB Linux 64GB Translation Look-aside Buffer: TLB 2MB CPU 3 CPU TLB Oracle TLB 4MB 2MB TLB PTE Page Table Entry: PTE 4KB 4MB 1,024 A A+4KB A+8KB A+4MB TLB TLB KB PTE 1024 MB 1 PTE db_cache_size Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 10

: /etc/lilo.conf bigpages=<size> MB <size> : MB 2 /proc/sys/kernel/shm-use-bigpages bigpage 0 shmfs sysv bigpage 1 bigpage bigpage = HighTotal / 1024 * 0.8MB HighTotal /proc/meminfo KB 20% 8GB RAM HighTotal 7208944KB bigpage 5631MB bigpage bigpage bigpage bigpages = HighTotal - KB / 1024 *0.8MB CPU Advanced Server 2.1 2002 1 3 Linux Ingo Molnar O(1) CPU CPU SMP CPU CPU CPU Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 11

Oracle9i Release 2 on Advanced Server 2.1 I/O Oracle9i Release 2 Advanced Server RAC Oracle E-Business Suite PTE IA-32 1 GB 1GB Linux 1GB PTE Oracle9i Release 2 PTE PTE PTE VM PTE PTE 3 5 Advanced Server Oracle9i Release 2 RAC Oracle9i Oracle9i RAC Cluster Manager TCP/IP Cluster Manager 1 TCP 8 1 TCP/IP Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 12

Oracle9i Release 2 Cluster Manager UDP UDP 1 TCP/IP Linux RAC Oracle on Linux Linux Oracle Oracle9i Release 2 on Red Hat Linux Advanced Server 2.1 lsraid 1 RAID Storage Management lsraid Advanced Server 2.1 man page lsraid lsraid Linux md /etc/raidtab md lsraid lsraid md md Advanced Server 2.1 Linux 1 Red Hat Web Red Hat, Inc. s Network Console and Crash Dump Facility http://www.redhat.com/support/wpapers/redhat/netdump/index.html Oracle Cluster Manager RAC Cluster Manager Linux Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 13

RAC on Linux (Watchdog) soft_margin soft_margin soft_margin Cluster Manager Cluster Manager ioctl soft_margin Advanced Server 2.1 Oracle9i Release 2 on Advanced Server 2.1 I/O Oracle on Linux I/O shutdown abort 64 64 Itanium Linux Intel Oracle8i 8.1.7 IA-64 Oracle on IA-64 SGA 32 Linux CPU I/O Itanium 2 OEM Red Hat Linux Advanced Server 2.1 on IA-64 32 Itanium 2 Linux Linux Oracle Red Hat Linux Advanced Server 2.1 Oracle on Linux Linux Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 14

Oracle9i Release 2 on Linux: Red Hat Linux Advanced Server 2.1 Oracle Corporation Oracle9iR2 on Linux: Performance, Reliability and Manageability Enhancements on Red Hat Linux Advanced Server 2.1 2002 6 : Jamshed N Patel : Van Okamura Lance Larsh Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. : : +1.650.506.7000 : +1.650.506.7200 www.oracle.com Oracle Copyright 2002 Oracle Corporation All rights reserved.