Oracle for Linux を使いこなす技
|
|
- こうじ かんざとばる
- 7 years ago
- Views:
Transcription
1 Oracle9i for Linux
2 Linux Monitoring the Oracle Monitoring the Server
3
4 vs vs OS vs Oracle vs SQL vs
5
6
7 3 I/O I/O
8 STEP1: STEP2:DB DB STEP3: STEP4: DB etc
9 STEP5:SQL SQL STEP6: Oracle STEP7: I/O I/O STEP8: STEP9:OS
10 1. ( ) 2. ( ) 3. ( ) 4. ( )
11 SQL
12 Oracle OS DB: STATSPACK OS: vmstat, iostat I/O Oracle 20%
13 Linux
14 Linux
15 MIRACLE LINUX V2.0 I/O MIRACLE LINUX V2.0 CD-ROM kernel Web kernel Red Hat Linux 7.1 CD-ROM kernel Web kernel-2.4.9
16 Oracle SGA SGA Oracle9i Database R1(9.0.1) 1.8GB Oracle9i Database R2(9.2) 62GB 4GB
17 SHMMAX 1 SHMMAX SHMSEG Oracle SHMMAX 1/2 SGA 1 SGA<SHMMAX kparam sysctl ipcs Oracle sysresv
18 kparam kparam MIRACLE LINUX MIRACLE LINUX
19 kparam /etc/sysconfig/kparam # vi /etc/sysconfig/kparam /proc/sys/kernel/semopm 100 /proc/sys/kernel/shmmax /proc/sys/kernel/sysrq 0 /proc/sys/kernel/panic 10 /proc/sys/kernel/sem kparam # service kparam restart
20 Oracle OS MIRACLE LINUX V2.0/2.1 ext2, ext3, ReiserFS, RAW I/O RAW ext2 ext3 HA ext3 MIRACLE LINUX V2.0/V2.1 ext3 ext3 mkinitrd
21 i-node -j ext3 # mke2fs [-j] -b -T i-node Oracle OS OS : 4K Oracle 4K, 8K, 16K # tune2fs -l
22 # mke2fs -b -T i-node 1024,2048,4098 i-node News Largefile Largefile4 4KB 1node 1MB 1node 4MB 1node # mke2fs -j -b T largefile4 /dev/sdb1
23 UNIX/Linux atime 3 mtime ctime atime atime
24 atime 2 /etc/fstab noatime /dev/sdb2 /home ext2 defaults,noatime 1 2 $ chattr +A * $ cd < > stat $ stat
25 Monitoring the Oracle
26 SQL Oracle SQL /tkprof EXPLAIN PLAN SQL*Plus BSTAT/ESTAT STATSPACK Oracle Enterprise Manager Diagnostics Pack/Tuning Pack V$
27 Oracle8i R8.1.6 STATSPACK BSTAT/ESTAT 2
28 STATSPACK STATSPACK $ sqlplus / as sysdba 2 SQL> connect perfstat/pertstat SQL> execute statspack.snap # SQL> execute statspack.snap(i_snap_level=>5)
29 STATSPACK SQL> connect perfstat/pertstat Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (s) Wt Time log file parallel write SQL*Net more data from dblink 39, SQL*Net message from dblink sort segment request
30 Monitoring the Server
31 I/O CPU I/O I/O CPU CPU Oracle
32 Linux Linux vmstat sysstat sar,iostat,mpstat,isag netstat ps aux ipcs free uptime Linux /proc
33 CPU Run Queue/Wait Queue vmstat cpu(usr, sys, idl) sar -U vmstat r/b vmstat memory (free,swpd,buff,cache) sar -r vmstat bi/bo Disk I/O sar -B sar -b vmstat si/so I/O sar -W iostat -x await DiskQueue iostat -x avgqu-sz
34 vmstat vmstat IO CPU 1 OS CPU I/O Excel vmstat [s] $ vmstat procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id
35 2 $ vmstat 2 vmstat CTRL+C n 1 tee Excel $ vmstat -n 2 tee output_vmstat
36 Process r: CPU vmstat b: I/O r CPU b Memory swpd: (KB) free: (KB) buff: (KB) cache: (KB)
37 vmstat Swap si: (kb/s) so: (kb/s)
38 vmstat IO bi: (blocks/s) bo: (blocks/s) CPU CPU us: sy: id:
39 I/O iostat CPU iostat [s] $ iostat -dt 2 Linux mlsmp (host.your.domain.name) 03/01/02 Time: 07:35:06 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn dev dev Time: 07:35:08 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn dev dev
40 iostat iostat $ iostat -d -x $ iostat -d -x sdb 2 Linux mlsmp (dhcp-0198.miraclelinux.com) 03/01/02 Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sdb Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util sdb
41 iostat avgqu-sz I/O I/O await I/O [m sec] %util I/O CPU
42
43 STATSPACK, iostat, vmstat
44 STATSPACK STATSPACK A Load Profile ~~~~~~~~~~~~ Per Second Per Transaction Redo size: 443, ,577, Logical reads: , Block changes: , Physical reads: , Physical writes: ,148.89
45 STATSPACK 1 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: Redo NoWait %: Buffer Hit %: In-memory Sort %: Library Hit %: Shared Pool Statistics Begin End Memory Usage %: % SQL with executions>1: % Memory for SQL w/exec>1: SQL 2
46 STATSPACK Top5 Wait Events Top 5 Wait Events ~~~~~~~~~~~~~~~~~ Wait %Total Event Waits Time (s) Wt Time log file switch (checkpoint incomplete) 1,182 1, log file parallel write 4, log buffer space 3, control file parallel write 1, log file switch completion % Wait REDO
47 vmstat (CPU, Process) Wait queue 1
48 vmstat ( free
49 STATSPACK CPU wait queue 1 I/O REDO REDO REDO :10MB 1GB REDO :500KB 5MB 2
50 Appendix: sar/isag free Web
51 sysstat sar iostat mpstat CPU sar sadc sar isag sar sadc iostat I/O
52 sar UNIX/Linux CPU -o -f
53 sar I/O 2 10 $ sar -b 2 10 Linux mlsmp (host.your.domain.name) 10/15/01 16:52:30 tps rtps wtps bread/s bwrtn/s 16:52: $ sar -W 2 0 Linux mlsmp (host.your.domain.name) 10/15/01 16:55:17 pswpin/s pswpout/s 16:55: :55: B pgpgin/s pgpgout/s I/O
54 2 sar 100 outfile $ sar -A o outfile outfile I/O $ sar -b -f ourfile /var/lib/sa $ sar
55 MIRACLE LINUX V2.0 sadc(sar) 10 /etc/cron.hourly/sysstat, /etc/cron.daily/sysstat /var/lib/sa $ ls /var/log/sa sa21 sa23 sa25 sa27 sar21 sar23 sar25 sar27 sa22 sa24 sa26 sa28 sar22 sar24 sar26 sar28 sann NN sarnn NN
56 isag(interactive System Activity Grapher) sar/sadc I/O CPU etc
57 isag isag [-p datafile_path] datafile_path /var/lib/sa $ isag -p. Chart
58 free $ free total used free shared buffers cached Mem: /+ buffers/cache: Swap: Mem Total OS Used Free OS (cached) (buffers) Shared
59 free -/+ buffers/cache Used Mem:Used - buffers - cached Free Mem:Free + buffers + cached Swap Total swap Used Free Kernel-4.html
60 Web MIRACLE LINUX MIRACLE LINUX MIRACLE LINUX MIRACLE LINUX
61 Web Oracle Technology Network Japan Linux & Windows Linux OTN Oracle Technology Network
62 Web How to Get Maximum Performance from Linux and Oracle Linux Performance Tuning Oracle FAQ sysstat home page
63 Oracle9i Oracle9i Oracle 13 Oracle 2 Mark Gurry, Peter Corrigan Oracle Oracle8
64 Oracle SQL Tuning Pocket Reference Mark Gurry, O REILLY Oracle9i Oracle9i for Windows 2000 Tips & Techniques Scott Jesse,Matthew Hart, OSBORNE Oracle9i Windows 2000 Windows 2000 Oracle9i ORACLE High-Performance SQL Tuning Donald K.Burleson, OSBORNE SQL
65 Oracle SQL High-Performance Tuning 2nd Guy Harrison,Prentice Hall 1 cle DBA on Unix and Linux Michael Wessler, SAMS Linux/UNIX
~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co
072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait
More informationuntitled
Oracle Direct Seminar SQL Agenda SQL SQL SQL SQL 11g SQL FAQ Oracle Direct SQL Server MySQL PostgreSQL Access Application Server Oracle Database Oracle Developer/2000 Web Oracle Database
More information[ D-4 ] Oracle9i Database
[ D-4 ] Oracle9i Database 1. ( ) 2. ( ) 3. ( ) 4. ( ) SQL DB DB DB SQL I/O OS init.ora SQL Oracle Oracle Oracle Oracle9i Database Tuning New Features Oracle9i New Features Tuning SGA PGA V$SQL_PLAN UNDO
More information<Documents Title Here>
Oracle Sensor Edge Server 10g (10.1.3) Creation Date: Apr 05, 2006 Version: 1.00 Document Control Author Hisashi Onoda Hirotaka Miura Hideki Ito - Oracle Sensor Edge Server 10g (10.1.3) - 2 Document Control...2
More information<Documents Title Here>
Oracle9i Database R9.2.0 for Windows Creation Date: Mar 06, 2003 Last Update: Mar 24, 2003 CD 1 A99346-01 Oracle9i Database Release 2 (9.2.0.1.0) for Microsoft Windows NT/2000/XP CD 1 of 3 2 A99347-01
More information... 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
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
More informationOracle Enterprise Manager概説 リリース2.2
Oracle Enterprise Manager 2.2 2000 11 : J02261-01 Oracle Enterprise Manager 2.2 : J02261-01 Oracle Enterprise Manager Concepts Guide, Release 2.2 A85250-01 Copyright 1996, 2000, Oracle Corporation. All
More informationuntitled
Oracle Direct Seminar !? Oracle Database 11g - - Agenda Copyright 2009, Oracle. All rights reserved. 2 Agenda Copyright 2009, Oracle. All
More informationはじめに コース概要と目的 Oracle データベースのパフォーマンス問題の分析方法 解決方法を説明します 受講対象者 データベース管理者の方を対象としています 前提条件 データベース アーキテクチャ データベース マネジメント を受講された方 もしくは同等の知識 をお持ちの方 テキスト内の記述につ
はじめに コース概要と目的 Oracle データベースのパフォーマンス問題の分析方法 解決方法を説明します 受講対象者 データベース管理者の方を対象としています 前提条件 データベース アーキテクチャ データベース マネジメント を受講された方 もしくは同等の知識 をお持ちの方 テキスト内の記述について 構文 [ ] 省略可能 { A B } A または B のどちらかを選択 n _ 数値の指定 デフォルト値
More informationRecovery Managerのバックアップおよびリカバリの最適化
Recovery Manager 2005 7 Recovery Manager... 3 Recovery Manager... 4 Recovery Manager... 4... 4... 5... 5... 5... 6... 6... 6... 7... 7... 8... 9 I/O I/O... 9... 10... 12... 12... 12... 13... 14 /... 14...
More informationuntitled
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
More information意外と簡単!? Oracle Database 11g -バックアップ・リカバリ編-
Oracle Direct Seminar !?Oracle Database 11g -- Agenda Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database
More informationOracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2
Oracle Enterprise Manager Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2 2000 11 : J02263-01 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack 2.2
More information<Documents Title Here>
Oracle Application Server 10g(10.1.2) for Microsoft Windows Portal Oracle Application Server 10g(10.1.2) for Microsoft Windows Portal Oracle Application Server 10g(10.1.2) Oracle Application Server(OracleAS)
More informationOracle HTML DB 導入ガイド
Oracle HTML DB Oracle Database 10g ... 4... 4 1... 4... 4 2... 5 2.1 Oracle HTTP Server... 6... 6... 7 2.2 root... 9 UNIX... 9 UNIX... 10 2.3 Oracle... 10... 11 (Bash )... 12 2.4 Oracle HTML DB... 13 2.5...
More informationuntitled
Oracle RAC 10gRAC Agenda 1. Why Oracle on Dell Dell Oracle on Linux Dell Oracle Dell Oracle 2. Oracle Clustering Solution Oracle Real Application Cluster 3. Case Study 4. Oracle RAC Solution on Dell Oracle
More informationimt_817_tuning_11_1822.PDF
intermedia Text Tuning Guide Creation Date: Mar 12, 2001 Last Update: Apr 19, 2001 Version: 1.1 4 intermedia Text 4 5 5 5 6 6 intermedia 6 6 6 7 7 7 7 8 8 8 8 R816 9 10 10 10 12 12 13 14 15 catalog index
More information<Documents Title Here>
Oracle Application Server 10g(9.0.4) for Microsoft Windows Portal Oracle Application Server 10g(9.0.4) for Microsoft Windows Portal Oracle Application Server 10g(9.0.4) Oracle Application Server(OracleAS)
More informationuntitled
Oracle Direct Seminar !?Oracle Database 11g Agenda Oracle Database Enterprise Manager Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000
More information<Documents Title Here>
Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone
More informationOracle Database 10gのOracle Data Guard
Oracle Database 10g Oracle Data Guard 2004 Oracle Data Guard... 3... 3... 3 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 4 Oracle Data Guard... 5 Oracle Data Guard... 6 Oracle Data
More informationuntitled
Oracle Direct Seminar IT Agenda 1. Oracle RAC on Oracle VM 2. Oracle Database 11gR2 3. Oracle Exadata Oracle Direct Concierge SQL Server MySQL PostgreSQL Access
More informationPowerPoint プレゼンテーション
TEL:045-866-8114 E-Mail: s-masui@msa.hitachi-sk.co.jp TEL:03-3491-7688 E-Mail: improj@pmcnet.co.jp PMC ( ) http://www.pmcnet.co.jp PS PS PS etc. etc. etc. W3C DOM XML XML B2 Enterprise Publisher
More information雲の中のWebアプリケーション監視術!~いまなら間に合うクラウド時代の性能監視入門~
Oracle Direct Seminar Web Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database http://www.oracle.com/lang/jp/direct/services.html
More informationWindowsユーザーの為のOracle Database セキュリティ入門
Oracle on Windows etc http://www.oracle.co.jp/campaign/mb_tech/ Windows Server System Center / OTN Japan http://www.oracle.com/technology/global/jp/tech/windows/.net + Oracle Database.NET Developer Center
More informationOracle Application Server 10g(9
Oracle Application Server 10g(10.1.2) for Microsoft Windows Infrastructure Oracle Application Server 10g(10.1.2) for Microsoft Windows Infrastructure...2...3...4...5...7...7...7 OS...10...12...13...15...29...29
More informationNull
Oracle Database Connect 2017 ~ 最新のデータベース技術がここにある ~ エキスパートはどう考えるか? 体感! パフォーマンスチューニング Japan Oracle User Group 日本オラクル株式会社クラウド テクノロジー事業統括 Database & Exadata プロダクトマネジメント本部 Copyright 2017, Oracle and/or its
More informationuntitled
FutureNet Microsoft Corporation Microsoft Windows Windows 95 Windows 98 Windows NT4.0 Windows 2000, Windows XP, Microsoft Internet Exproler (1) (2) (3) COM. (4) (5) ii ... 1 1.1... 1 1.2... 3 1.3... 6...
More informationOracle Enterprise Manager 10g R2 Grid Control: データベース管理の新機能
Oracle Enterprise Manager 10g R2 Grid Control: 2005 8 Oracle Enterprise Manager 10g R2 Grid Control:... 3... 3 GRID CONTROL... 4... 4... 4... 5... 5 GRID CONTROL... 5... 5 SQL /... 6... 7 HANG ANLYSIS...
More informationOracle Application Server 10g( )インストール手順書
Oracle Application Server 10g (10.1.2) for Microsoft Windows J2EE Oracle Application Server 10g (10.1.2) for Microsoft Windows J2EE and Web Cache...2...3...3...4...6...6...6 OS...9...10...12...13...25...25
More informationOracle Application Server 10g(9
Oracle Application Server 10g (9.0.4) for Microsoft Windows J2EE Oracle Application Server 10g (9.0.4) for Microsoft Windows J2EE and Web Cache...2...3...3...4...6...6...6 OS...9...10...12...13...24...24
More informationNEC Storage series NAS Device
NEC Storage NV Series NAS Device Guide for Oracle Storage Compatibility Program Snapshot Technologies is-wp-04-001 Rev-1.00(J) Oct, 2004 NEC Solutions NEC Corporation. - 1 - Copyright 2004 NEC Corporation
More information<Insert Picture Here> Oracle Business Intelligence 2006/6/27
Oracle Business Intelligence 2006/6/27 Oracle Business Intelligence Suite Enterprise Edition Oracle Warehouse Builder 10g Release 2 Agenda BI FY07 3 Oracle Business Intelligence 2007
More informationLinux上の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...
More informationMicrosoft Word - nvsi_050090jp_oracle10g_vlm.doc
Article ID: NVSI-050090JP Created: 2005/04/20 Revised: Oracle Database10g VLM 環境での NetVault 動作検証 1. 検証目的 Linux 上で稼動する Oracle Database10g を大容量メモリ搭載環境で動作させる場合 VLM に対応したシステム設定を行います その環境において NetVault を使用し
More informationo8i_816_LinuxTips_02_1015
Oracl8i on Miracle Linux Page 1 1 Ajenda Miracle Linux Linux + Oracle Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique Miracle Linux Oracle8i for Linux Windows Oracle
More informationnakayama15icm01_l7filter.pptx
Layer-7 SDN SDN NFV 50 % 3 MVNO 1 2 ICM @ 2015/01/16 2 1 1 2 2 1 2 2 ICM @ 2015/01/16 3 2 Service Dependent Management (SDM) SDM Simple Management of Access-Restriction Translator Gateway (SMART-GW) ICM
More information自己管理データベース: 自動SGAメモリー管理
: SGA Tirthankar Lahiri, Arvind Nithrakasyhap, Brian Hirano, Kant Patel, Poojan Kumar, Sushil Kumar Oracle Corporation Oracle Database 10g 1 SGA Oracle Oracle Oracle SGA SQL PL/SQL Java Java Java SGA shared_pool_size
More informationuntitled
Oracle Direct Seminar Oracle Database.NET NET Visual Studio Oracle Copyright 2010, Oracle. All rights reserved. 2 .NET Oracle.NET + Oracle Visual Studio + Oracle.NET + Oracle Copyright
More informationNull
Technical Discussion Night ~ 今宵のテーマ : エキスパートはどう考えるか? 体感! パフォーマンスチューニング ~ Japan Oracle User Group 日本オラクル株式会社クラウド テクノロジー事業統括 Database & Exadata プロダクトマネジメント本部 Copyright 2017, Oracle and/or its affiliates.
More informationSlide 1
Oracle Direct Seminar 実践!! パフォーマンスチューニング - モニタリング編 - 日本オラクル株式会社 Agenda 1. なぜモニタリングが必要か 2. モニタリングを行う方法紹介 3. パフォーマンスの分析方法 4. GUI によるパフォーマンス監視 チューニング Oracle Direct の無償技術サービス SQL Server
More informationOracle Database 10g Automatic Storage Management の NEC iStorage S シリーズへの適用
Oracle Database 10g TM Automatic Storage Management NEC istorage S An Oracle and NEC White Paper August 2005 2006/04-1 - Copyright 2005 NEC and Oracle Corporation. All rights reserved. Oracle, Oracle Database
More informationOM.indd
_ INDEX 3 4 5 6 7 8 9 Platinum 10 Gold 12 Silver 14 Bronze 16 18 20 FAQ 21 22 1997 10 15 Platinum Platinum IT 保々雅世 3 IT Control Real Application Cluster Grid Oracle Application Server 10g CLE MASTER ORA
More informationOracle Database 11g × Hitachi Storage Solutionsのベストプラクティス
- 1 - 1... 4 2... 5 2.1 ORACLE11G DATABASE REPLAY... 5 2.1.1 DB... 5 2.1.2... 6 2.2 DATABASE REPLAY... 6 2.2.1 DB... 6 2.2.2... 6 3... 8 3.1 ORACLE DATABASE 11G DATABASE REPLAY... 8 3.1.1 Database Replay...
More informationスライド 1
VMware CIT Japan 006 6 CIT Agenda VMWARE Pfizer Japan Inc. 953 648 6 09 -5-00 Discovery Approaches 7,000,000 Compounds Screened,000 Screening Hits Candidates 6 Candidates Product 700 MR* MR Medical Representative
More informationオラクルのバックアップとリカバリの必須要件
WHITE PAPER 1 WHITE PAPER...3...3...4 NetBackup Oracle...6...7 VERITAS NetBackup Oracle Agent...7 VERITAS NetBackup Oracle Agent...8 VERITAS NetBackup Oracle...8...9 GUI RMAN...9 VERITAS NetBackup Oracle
More informationuntitled
Oracle Direct Seminar Agenda Oracle VM Appendix Oracle VM VM Server Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database
More informationuntitled
ALTIRIS DEPLOYMENT SOLUTION 6.9 Quick Startup Guide Rev. 1.2 2008 7 11 1.... 2 DEPLOYMENT SERVER... 2 DEPLOYMENT CONSOLE... 2 DEPLOYMENT DATABASE... 2 DEPLOYMENT SHARE... 3 PXE SERVER... 3 DEPLOYMENT AGENT...
More informationuntitled
Oracle Enterprise Manager 10g Oracle Application Server 2003 11 Oracle Enterprise Manager 10g Oracle Application Server... 3 Application Server... 4 Oracle Application Server... 6... 6... 7 J2EE... 8...
More informationD2印刷用.PDF
[ D-2 ] Oracle8i on Linux Agenda Oracle for Linux Miracle Linux Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique Oracle for Linux 1999/03 O8 WGS for Linux R8.0.5 1999/12
More informationスライド 1
Zabbix のデータベース ベンチマークレポート PostgreSQL vs MySQL Yoshiharu Mori SRA OSS Inc. Japan Agenda はじめに Simple test 大量のアイテムを設定 Partitioning test パーティションイングを利用して計測 Copyright 2013 SRA OSS, Inc. Japan All rights reserved.
More information自動シャットタ<3099>ウンクイックインストールカ<3099>イト<3099>.indb
OMRON Corporation. 2011 All Rights Reserved. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 title Red Hat Enterprise Linux Server (2.6.18-8.el5xen serial) root (hd0,1) kernel /xen.gz-2.6.18-8.el5 console=vga xencons=ttys16
More informationリアルタイムシステム
1/38 ...4 (Dispatch Latency)...6...7...8...9...10 CPU...10...12...12...13...14...16 (SCHED_FIFO)...17 (SCHED_RR)...18 (FBS)...18...19...21...23...25...29...29...31...33...33 2/38 ...34...34...34...34...34...34...34
More informationFUJITSU Software Systemwalker Operation Manager V13 カタログ
FUJITSU Software Systemwalker 1 24:00 6:00 A B UPS / JCL 2 Systemwalker & 23 x x x n Windows Linux Solaris Solaris WindowsUNIX Linux ERP(Oracle E-Business Suite SAP ERP) FUJITSU Software Interstage GUI
More informationsg_lenovo_os.xlsx
System x OS System Guide Windows Server 1/41 2/41 3/41 4/41 Lenovo OEMRed Hat Enterprise Linux 5/41 6/41 7/41 8/41 9/41 10/41 11/41 12/41 13/41 14/41 15/41 16/41 VMware Lenovo 17/41 18/41 19/41 20/41 21/41
More informationスライド 1
! ~Oracle Database を監視しよう ~ Session by Shinnosuke Akita 2014.02.00 Self Introduction Shinnosuke Akita Oracle DBA をやっています 今の現場は DB 設計もやっています 入社 2 年目 休日はランニングと家族サービス たまに小説も書いたり 勉強会にでかけたり 大衆酒場めぐりがマイブーム Today
More informationuntitled
PRIMERGYPRIMEPOWER Solid STOR PRIMERGY TX200S2, PRIMERGY PRIMEPOWER 450 2006 4 3 2006 4 14 Platform Solution Center ) Solid STOR DRAM Solid State DiskSSD 300 450 Fibre Channel( FC) (FCP) IA PRIMERGY UNIX
More informationA book
Hitachi Multi Payment Network communications server 3000-3-493-40 P-1B43-6111 Hitachi Multi Payment Network communications server Base 01-03( OS HP-UX 11.0 HP-UX 11i) P-1B43-6311 Hitachi Multi Payment
More informationWindows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.
Windows Oracle -Web - Copyright Oracle Corporation Japan, 2004. All rights reserved. Agenda Oracle Windows Windows Oracle 1 / Active Directory/Enterprise User Security 1-1 Windows 1-2 Kerberos 1-3 Enterprise
More informationLinux2.4でのメモリ管理機構
Linux2.2 on x86 Dec 2001 x86 Linux Linux (demand paging, copy on write ) (buddy system, slab allocator) x86 x86 ( ) (required) (= ) ( ) (optional) x86 Physical address( ) Linear address( ) Logical address(
More informationHow to Use the PowerPoint Template
運用ヘルスチェックでトラブルを予防しよう! 今西由人スタッフコンサルタント クラウド テクノロジーコンサルティング統括本部テクニカルアーキテクト本部 DB ソリューション部 2 以下の事項は 弊社の一般的な製品の方向性に関する概要を説明するものです また 情報提供を唯一の目的とするものであり いかなる契約にも組み込むことはできません 以下の事項は マテリアルやコード 機能を提供することをコミットメント
More informationOracle8簡単チューニング for Windows NT
Oracle8 ... 2 0.... 3 1.WINDOWS NT... 4 1.1.CPU...4 1.2....8 W INDOWS NT...9 2.ORACLE... 10 2.1.SHARED_POOL_SIZE...10 2.2.DB_BLOCK_BUFFERS...11 2.3.SORT_AREA_SIZE...14 2.4.DB_FILE_MULTIBLOCK_READ_COUNT...15
More informationLinux @ S9 @ CPU #0 CPU #1 FIB Table Neighbor Table 198.51.100.0/24 fe540072d56f 203.0.113.0/24 fe54003c1fb2 TX Ring TX Ring TX Buf. Dsc. RX Buf. Dsc. TX Buf. Dsc. RX Buf. Dsc. Packet NIC #0 NIC #1 CPU
More informationEA3.PDF
METI METI EA EA EA EA EA EA CEO CIOCIO 1 EA METI EA EA EA EA EA 2 METI IT 3 4 METI IT Enterprise (Mission & Principles) METI Principles Mission 5 6 METI EA EA DA AA TA ERD) ERD) BA ERD) (Mission & Principles)
More informationMicrosoft Word - nvsi_090196_r1_vaultdr_offline_rhel_dualpath.doc
Article ID: NVSI-090196JP_R1 Created: 2009/08/17 Revised: 2010/07/9 Multipath 構成の RHEL5.3 での VaultDR Offline 追加復旧手順 1. 概要 Multipath 構成の Red Hat Enterprise Linux 5.3 は OS 内部に LUN 固有の ID を含んでいる場合があります その場合
More informationORACLEデータベース10G データ・ポンプ: 超高速データ移動ユーティリティの基盤
Oracle Database 10g Data Pump: George H. Claborn, Oracle Corporation Data Pump Data Pump Oracle Database Oracle Database 10g Data Pump PL/SQL DBMS_DATAPUMP Data Pump expdp impdp Web Enterprise Manager
More informationAgenda はじめに 目的とゴール Part1の振り返り AWRを使用した性能分析 AWR 概要 AWRに格納される情報 AWR レポートにおける分析アプローチ AWR 確認ポイント Case Study AWRとアーキテクチャの関係 まとめ Part2のポイント まとめ Copyright 20
Oracle Direct Seminar オラクルコンサルタントが語る性能分析の真髄 Part2 日本オラクル株式会社 Agenda はじめに 目的とゴール Part1の振り返り AWRを使用した性能分析 AWR 概要 AWRに格納される情報 AWR レポートにおける分析アプローチ AWR 確認ポイント Case Study AWRとアーキテクチャの関係
More informationETERNUS SF総合
FUJITSU Storage FUJITSU Storage ICT ICT ICT AdvancedCopy Manager Recovery Manager for Oracle ETERNUS DX serieseternus AF series Oracle Recovery ManagerOracle DB TSM ICT 1 Storage Cruiser ETERNUS I/OQoS
More informationクラウド時代のインフラ構成/変更管理とコンプライアンス管理
Oracle Direct Seminar / 2009 11 11 Agenda IT / / Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database
More informationWeb Microsoft 2008 R2 Database Database!! Database 04 08
Database Database Web http://www.microsoft.com/japan/sqlserver/2008/r2/solution/comparison/default.mspx Microsoft 2008 R2 Database Database!! 03 2009 6 1 Database 04 08 vs. Database 12 2008 R2 5 14! 5!
More information1 Microsoft Windows Server 2012 Windows Server Windows Azure Hyper-V Windows Server 2012 Datacenter/Standard Hyper-V Windows Server Windo
Windows Server 2012 2012 1 Cloud OS Windows Azure Platform On-Premises Service Provider 1 Microsoft Windows Server 2012 Windows Server 2012 1 Windows Azure Hyper-V Windows Server 2012 Datacenter/Standard
More informationOracle Fail Safe For Windows NT and Windows 2000 リリース・ノート、リリース 3.1.2
Oracle Fail Safe for Windows NT and Windows 2000 3.1.2 2001 7 : J04372-01 Oracle Applications 11i Oracle E-Business Suite 11i Oracle Oracle Oracle Corporation JInitiator Oracle7 Oracle8 Oracle8i Oracle
More informationOracleの領域管理~トラブル防止のテクニック~
THE Database FOR Internet Computing Oracle ... 3... 4... 4... 5... 5... 7... 8... 9... 12... 13... 13... 16... 17... 18... 20... 22... 23... 23... 24... 25... 25... 26... 28... 31... 31... 31... 33...
More information,,.,,., II,,,.,,.,.,,,.,,,.,, II i
12 Load Dispersion Methods in Thin Client Systems 1010405 2001 2 5 ,,.,,., II,,,.,,.,.,,,.,,,.,, II i Abstract Load Dispersion Methods in Thin Client Systems Noritaka TAKEUCHI Server Based Computing by
More informationcover1.indd
OMRON Corporation. 2010 All Rights Reserved. Power Credit UPS PowerAct Pro Ver.4.x PA PowerAct Pro PA UPS Power Credit 2 3 4 5 6 7 8 9 10 11 12 13 title Red Hat Enterprise Linux Server (2.6.18-8.el5xen
More informationperf_tool.PDF
Oracle RDBMS Creation Date: Jan. 16, 2000 Last Update: Oct. 18, 2001 Version: 1.0 1 SQL EXPLAIN PLAN SQL*Plus AUTOTRACE SQL Oracle Enterprise Manager Tuning Pack SQL SQL*Plus AUTOTRACE SQL STATSPACK Oracle
More informationRed Hat Enterprise Linux 2.1 ASからRed Hat Enterprise Linux 3へのアップグレード時のOracle Database 10g環境の保持
Red Hat Enterprise Linux 2.1 AS Red Hat Enterprise Linux 3 Oracle Database 10g 2005 1 Red Hat Enterprise Linux 2.1 AS Red Hat Enterprise Linux 3 Oracle Database 10g... 3... 3... 4 1. Oracle... 4 2....
More informationMicrosoft Word - マニュアル4.1J
Yellow Dog Linux 4.1J 20060605 1. 2. 2.1 2.2 2.3 Mac OS X 2,4 Mac OS 9 2.5 3. Yellow Dog Linux 3.1 Welcome to Yellow Dog Linux 3.2 Language Selection 3.3 3.4 3.5 3.5.1 3.5.2 Disk Druid 3.5.3 3.6 3.7 3.8
More informationBIG_RM_BAS_OPEN
Oracle8 & 1998 1 21 1 1 1998 1 21 2 2 1998 1 21 3 3 1998 1 21 4 4 1998 1 21 5 5 1998 1 21 6 6 7 1998 1 21 7 Oracle Oracle Enterprise Enterprise Manager Manager Recovery Recovery Manager Manager GUI Oracle8
More informationこれは何? ORACLE の内部状態を示す情報の一つである 待機イベントについて解説します 待機イベントを知ることで 一歩進んだパフォーマンスチューニングが出来ます また 待機イベントという切り口を通して ORACLE のアーキテクチャに対する理解を深めていきます なお ORACLE のバージョンは
ORACLE 入門講座待機イベントを知ろう アリエル ネットワーク鈴木健介 これは何? ORACLE の内部状態を示す情報の一つである 待機イベントについて解説します 待機イベントを知ることで 一歩進んだパフォーマンスチューニングが出来ます また 待機イベントという切り口を通して ORACLE のアーキテクチャに対する理解を深めていきます なお ORACLE のバージョンは 10.2 を想定しています
More informationArmadillo-9 ソフトウェアマニュアル
Software Manual http://www.atmark-techno.com/ http://armadillo.atmark-techno.com/ Armadillo-9 software manual ver.1.0.16 1.... 1 1.1.... 1 1.2.... 1 1.3.... 1 1.4.... 2 1.5.... 2 1.6.... 2 2.... 3 2.1....
More informationC3印刷用.PDF
[ C-3 ] Oracle8i On Windows Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow Windows Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i
More informationFileMaker Server Getting Started Guide
FileMaker Server 13 2007-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
More informationVMware VirtualCenter: Virtual Infrastructure Management Software
VMware : CPU 1998 VMware : 50(R&D) : Workstation1999 GSX Server 2001 ESX Server 2001 : 900 100805%VMware 200 100 10,000 2 VMware Workstation 1999 Linux x86 3 VMware GSX Server Windows Linux x86 4 VMware
More informationIBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati
IBM Software Group XML Features in DB2 UDB V8 IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Information Integrator
More informationuntitled
VMware 2006 4 14 ( ) 30 : VM: ( CPU HDD NIC HBA VMware ESX Server 1 : Virtual Center VMotion VMotion ( Virtual Center ESX Server ) SAN VMware AGENDA 2005 11 4 IDC 150 IDC OS 2 4 x86 x86 Survey respondents
More information1 2 3 6 10 < > 13 16 16 4 17 13 00 15 30 5
2004 16 3 23 q 4 21 r 1 2 3 6 10 < > 13 16 16 4 17 13 00 15 30 5 13 2 2 16 4 4 17 3 16 3 1 16 3 2 905 1438 1201 1205 1210 70 1812 25 1635 1654 3 44 47 10 10 911.18-R 1193 34 1652 4 911.107-H 1159 1685
More information56 OS OS OS OS 1 OS HDD OS 1 OS HDD HDD OS OS OSOS HDD 図 1 二重キャッシュ環境 3. 負の参照の時間的局所性 3.1 参照の局所性 Locality of Reference Temporal locality Spatial localit
116 26 4 1 2 2 1 3 An Analysis of Locality of Reference in Virtualized Environment Hiroki SUGIMOTO 1, Kousuke TAKEUCHI 2, Kouya HINAGAWA 2 and Saneyasu YAMAGUCHI 1 3 Abstract As cloud computing has spread
More informationH1
CA ARCserve r16.5 CA ARCserve Backup r16.5 CA ARCserve D2D r16.5 CA ARCserve Replication / CA ARCserve CA ARCserve r16.5 3.11 IT IT CA ARCserve r16.5 CA ARCserve CA ARCserve CA ARCserve r16.5 D 3.4% C
More informationOracle XML DB によるスケーラビリティおよびパフォーマンス検証 - MML v.3.0
Oracle XML DB MML v3.0 2004 5 27 1 Memo 1 Agenda XML MML v3.0 2 Oracle XML Oracle XML DB XML API Oracle XML DB W3C XML Schema 1.0 XPath 1.0 XSLT 1.0 Oracle W3C XML Schema Oracle 2 XML Oracle XML Developer
More information<Documents Title Here>
Oracle Application Server 10g(9.0.4) for Microsoft Windows Discoverer Oracle Application Server 10g(9.0.4) for Microsoft Windows Discoverer Oracle Application Server 10g(9.0.4) Oracle Application Server(OracleAS)
More informationHULFT-DataMagic Ver2.2.0 製品対応OS
Ver2.2.0 製品対応 OS 2014 年 2 月 5 日以降適用 版最新 Version 2.2.0 for コード変換 オプション for DB 接続 オプション (Oracle) for DB 接続 オプション (DB2) for DB 接続 オプション (PostgreSQL) for DB 接続 オプション (SQL Server) for Excel オプション for テンプレート
More informationSybase on CLUSTERPRO for Linux HowTo
Sybase on CLUSTERPRO for Linux HowTo 1 2006 2 6-1- ... 3... 4... 5... 7 DB... 8 DB... 9... 10 DB... 11 DB... 12 CLUSTERPRO... 13... 20-2- Sybase Adaptive Server Enterprise Red Hat Enterprise Linux AS3
More information... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2
1 ... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 3 4 5 6 7 8 9 Excel2007 10 Excel2007 11 12 13 - 14 15 16 17 18 19 20 21 22 Excel2007
More informationWebSphere Application Server V5.0 for Linux Ver. 1.11
WebSphere Application Server V5.0 for Linux Ver. 1.11 1.... 3 2.... 4 2.1.... 4 2.2.... 4 2.3. ( ) rpm... 5 2.4.... 6 3. WebSphere Application Server V5 Base... 7 3.1. WebSphere Application Server... 7
More informationApache Web Server 2 Compaq ActiveAnswers Deskpro Compaq Insight Manager Fastart Systempro Systempro/LT ProLiant ROMPaq Qvision SmartStart NetFlex Quic
Technical Guide 1999 5 Internet and E-Commerce Solutions Business Unit Enterprise Solutions Division Apache Web Server Compaq Linux Apache HTTP Compaq Computer Corporation...3...3...4...5...6...7...7...7...8...10...10...16...16
More informationnew_logo.eps
Oracle Enterprise Manager 2.0.4 :A62835-1 Oracle Enterprise Manager 2.0.4 :A62835-1 1 :1999 4 1 :Oracle Enterprise Manager Installation, Release 2.0.4 :A67818-01 Copyright 1999, Oracle Corporation. All
More informationOracle Database 10g Release 2を使用したデータベース・パフォーマンス
Oracle Database 10g Release 2 2005 9 Oracle Database 10g Release 2... 3... 3... 3 Automatic Workload Repository AWR... 3 Automatic Database Diagnostic Monitor ADDM... 4 Automatic SQL Tuning SQL... 4 SQL
More information21 20 20413525 22 2 4 i 1 1 2 4 2.1.................................. 4 2.1.1 LinuxOS....................... 7 2.1.2....................... 10 2.2........................ 15 3 17 3.1.................................
More information