... 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

Size: px

Start display at page:

Download "... 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"

あつひろひろなが
7 years ago
Views:

1 Oracle9i Release 2 on Linux: Red Hat Linux Advanced Server

2 ... 3 Oracle on Linux I/O I/O... 5 I/O io_request_lock... 6 I/O GB RAM SGA GB RAM Very Large Memory VLM PTE Oracle9i Release 2 RAC lsraid Oracle9iR2 on Linux: Red Hat Linux Advanced Server 2.1 2

3 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

4 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 GB 4GB 1 64K KB 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

5 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

6 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

7 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 0x 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

8 genksms -s 0x >ksms.s SGA 0x 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 0x echo >/proc/<pid>/mapped_base <pid> ID Oracle SGA 1 shmmax. echo >/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

9 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= /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

10 Oracle 512MB Oracle VLM_WINDOW_SIZE : VLM_WINDOW_SIZE= GB 64KB : Oracle attach SGA /proc/<pid>/mapped_base Oracle ORA-3113 attach IA KB 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

11 : /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 KB bigpage 5631MB bigpage bigpage bigpage bigpages = HighTotal - KB / 1024 *0.8MB CPU Advanced Server Linux Ingo Molnar O(1) CPU CPU SMP CPU CPU CPU Oracle9iR2 on Linux: Red Hat Linux Advanced Server

12 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

13 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 Oracle Cluster Manager RAC Cluster Manager Linux Oracle9iR2 on Linux: Red Hat Linux Advanced Server

14 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 Itanium Linux Intel Oracle8i IA-64 Oracle on IA-64 SGA 32 Linux CPU I/O Itanium 2 OEM Red Hat Linux Advanced Server 2.1 on IA Itanium 2 Linux Linux Oracle Red Hat Linux Advanced Server 2.1 Oracle on Linux Linux Oracle9iR2 on Linux: Red Hat Linux Advanced Server

15 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 : Jamshed N Patel : Van Okamura Lance Larsh Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA U.S.A. : : : Oracle Copyright 2002 Oracle Corporation All rights reserved.

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

Linux上のOracle Real Application Clustersの記憶領域オプション Linux Oracle Real Application Clusters 2005 1 RAC... 3... 3 Automatic Storage Management ASM... 4 ASM Oracle... 5 ASM... 6 Oracle Cluster File System... 6 OCFS Oracle... 7... 7... 7 RAW... 7 RAW Oracle...