Oracle Enterprise Manager Oracle Diagnostics Packスタート・ガイド リリース2.2
|
|
|
- かつかげ にいだ
- 4 years ago
- Views:
Transcription
1 Oracle Enterprise Manager Oracle Diagnostics Pack : J
2 Oracle Enterprise Manager Oracle Diagnostics Pack 2.2 : J Getting Started with the Oracle Diagnostics Pack, Release 2.2 A Leo Cloutier Jacqueline Gosselin and Bert Rich Copyright 1996, 2000, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA
3 ... ix 1 Oracle Advanced Event Tests Oracle Performance Manager Oracle Capacity Planner Oracle Trace Oracle TopSessions Diagnostics Pack SQL Microsoft SQL Server Advanced Events Capacity Planner Performance Manager Oracle Data Gatherer Windows NT Performance Manager i
4 Performance Manager Performance Manager Performance Manager TopSessions Trace Oracle8 Server Trace Oracle Server Trace Trace Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Performance Manager Performance Manager Oracle Performance Manager Performance Manager ii
5 Performance Manager Oracle Capacity Planner Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner iii
6 Oracle Capacity Planner iv
7 Oracle Capacity Planner vp_service_ref vp_class_ref Oracle E-Business Management Tools Web Web Web Web Apache Server Access Log Traffic Performance Overview I/O Server Utilization Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions v
8 EXPLAIN PLAN Oracle TopSessions Oracle Advanced Event Tests Microsoft SQL Server Compaq Tru HP-UX IBM AIX Solaris Windows NT Web vi
9 A Advanced Event Tests... A-2... A-2... A-2... A-4... A-5... A-5... A-5... A-6... A-6... A-6... A-6... A-7 vii
10 viii
11 Oracle Diagnostics Pack Oracle Enterprise Manager Pack Oracle Enterprise Manager Oracle Performance Manager Oracle Capacity Planner Oracle TopSessions Oracle Diagnostics Pack Oracle Event Tests Oracle Diagnostics Pack Oracle Event Tests Oracle Performance Manager Oracle Capacity Planner Oracle TopSessions Oracle Diagnostics Pack Oracle Event Tests Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager ix
12 1 Oracle Diagnostics Pack 2 Oracle Diagnostics Pack 3 Oracle Performance Manager Oracle Performance Manager 4 Oracle Capacity Planner Oracle Capacity Planner 5 Oracle E-Business Management Tools E-Business Oracle E-Business Management Tools 6 Oracle TopSessions Oracle TopSessions 7 Oracle Advanced Event Tests Oracle Diagnostics Pack Oracle Event Tests A Advanced Event Tests Oracle Diagnostics Pack Oracle Event Tests Oracle Performance Manager Oracle Capacity Planner Oracle TopSessions Oracle Diagnostics Pack Oracle Event Tests Oracle Event Tests Oracle Diagnostics Pack Oracle Event Tests Oracle Enterprise Manager Pack Oracle Enterprise Manager Oracle Change Management Pack Oracle Diagnostics Pack Oracle Tuning Pack Oracle Standard Management Pack Oracle x
13 Management Pack for Oracle Applications 6 Pack Pack Oracle Enterprise Manager Oracle Change Management Pack Baseline Viewer Change Manager DB Alter Create Baseline Compare Database Objects DB Propagate DB Quick Change Find Database Objects Plan Editor Oracle Diagnostics Pack Oracle Performance Manager Oracle Capacity Planner Oracle Trace Oracle TopSessions Oracle Advanced Event Tests Oracle Tuning Pack Oracle SQL Analyze Oracle Expert Oracle Index Tuning Wizard Reorg Wizard Tablespace Map SQL xi
14 Oracle Standard Management Pack Baseline Viewer Change Manager Create Baseline Compare Database Objects Oracle Index Tuning Wizard Oracle Performance Manager Oracle TopSessions Oracle Oracle Management Pack for Oracle Applications Oracle Performance Manager Oracle Capacity Planner Concurrent Processing Tuning Assistant Oracle Applications Event Tests Oracle Oracle Management Pack Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack Oracle Enterprise Manager Management Pack Oracle Enterprise Manager Oracle Diagnostics Pack Oracle Enterprise Manager 1 Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager Oracle Enterprise Manager xii
15 Oracle Intelligent Agent Oracle Intelligent Agent Oracle Change Management Pack Oracle Change Management Pack Change Management Pack Oracle Change Management Pack Oracle Change Management Pack Oracle Diagnostics Pack Oracle Diagnostics Pack Diagnostics Pack Oracle Diagnostics Pack Oracle Performance Manager Oracle Capacity Planner Oracle TopSessions Oracle Diagnostics Pack Oracle Event Tests Oracle Event Tests Oracle Enterprise Manager Oracle Trace Oracle Trace Oracle HTML Oracle_Home/doc/em/dbcart_webhelp/dbcart.htm Oracle - <ORACLE_HOME> Diagnostics Pack Database Charts - Help Oracle Tuning Pack Oracle Tuning Pack Tuning Pack Oracle Tuning Pack Oracle Tuning Pack Oracle SQL Analyze Oracle Expert Oracle Index Tuning Wizard Reorg Wizard Tablespace Map Oracle xiii
16 Oracle Standard Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Oracle Standard Management Pack Baseline Viewer Change Manager Create Baseline Compare Database Objects Oracle Index Tuning Wizard Oracle Performance Manager Oracle TopSessions Oracle Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Oracle Management Pack for Oracle Applications Oracle Performance Manager Oracle Capacity Planner Concurrent Processing Tuning Assistant Oracle Applications Oracle Applications Event Tests and Jobs Oracle Intelligent Agent Oracle Intelligent Agent xiv
17 1 Oracle Diagnostics Pack Oracle Server Oracle Enterprise Manager Diagnostics Pack Enterprise Manager Intelligent Agent Diagnostics Pack Oracle Advanced Event Tests Oracle Oracle Performance Manager Performance Manager I/O Oracle Capacity Planner Capacity Planner Oracle Trace Oracle Server Oracle Trace SQL 1-1
18 Oracle Advanced Event Tests Oracle TopSessions Oracle Advanced Event Tests Enterprise Manager Diagnostics Pack 7 Oracle Advanced Event Tests Enterprise Manager Oracle Performance Manager Performance Manager Oracle Server 1-2 Oracle Diagnostics Pack
19 Oracle Trace Oracle Capacity Planner Oracle Trace Performance Manager Diagnostics Pack Capacity Planner Performance Manager Capacity Planner 1 CPU Trace Oracle Server Trace Application Programming Interface API Trace Trace Trace Manager Trace Data Viewer Trace Manager Trace API Trace Manager Oracle Management Server Trace Trace Oracle Server Data Viewer Trace Data Viewer Trace Trace Data Viewer SQL Trace Oracle Enterprise Manager Oracle Trace 1-3
20 Oracle TopSessions Oracle TopSessions TopSessions n TopSessions I/O SQL SQL SQL EXPLAIN PLAN Diagnostics Pack 3 Diagnostics Pack Diagnostics Pack Advanced Event Tests 1-4 Oracle Diagnostics Pack
21 Diagnostics Pack SQL Performance Manager I/O Performance Manager Process Info SGA Oracle TopSessions CPU I/O n V$:sesstat open_cursor locks sqlarea REDO REDO 10 EXPLAIN PLAN 1-5
22 Diagnostics Pack SQL Oracle Tuning Pack SQL Analyze SQL SQL n SQL SQL SQL SQL Analyze SQL SQL Analyze Capacity Planner???? Capacity Planner Enterprise Manager SQL Performance Manager SQL SQL Analyze SQL 1-6 Oracle Diagnostics Pack
23 Microsoft SQL Server db_block_buffers Instance Manager Oracle Tuning Pack Oracle Tuning Pack Microsoft SQL Server Oracle Diagnostics Pack Oracle Server Microsoft SQL Server Performance Manager Microsoft SQL Server Capacity Planner Microsoft SQL Server Advanced Events Microsoft SQL Server Oracle Diagnostics Pack SQL Server NT Intelligent Agent Data Gatherer Intelligent Agent Data Gatherer Enterprise Manager SQL Server SQL Server SQL Server NT SQL Server Diag Pack SQL Server SQL*Server NT Agent/Data Gatherer Capacity Planner Performance Manager SQL Server 1-7
24 Microsoft SQL Server 1-8 Oracle Diagnostics Pack
25 2 Diagnostics Pack Advanced Events Capacity Planner Performance Manager TopSessions Trace 2-1 Advanced Events 2-2 Capacity Planner Performance Manager 2-2 Capacity Planner Performance Manager 2-5 TopSessions 2-6 Trace Advanced Events Oracle Advanced Events Advanced Events 2-5 TopSessions CHAINED_ROWS CHAINED_ROWS 1. SYS 2. utlchain.sql $ORACLE_HOME RDBMS ADMIN 2-1
26 Capacity Planner Performance Manager Capacity Planner Performance Manager Oracle Capacity Planner Oracle Performance Manager Oracle Data Gatherer Windows NT Performance Manager Performance Manager Performance Manager Parallel Server SQL Oracle Data Gatherer Performance Manager Capacity Planner Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Intelligent Agent Windows NT Windows NT diskperf -Y DISKPERF Microsoft Windows NT : Performance Manager Capacity Planner 2-2 Oracle Diagnostics Pack
27 Capacity Planner Performance Manager Performance Manager Performance Manager Performance Manager Enterprise Manager 2.1 Performance Manager : Performance Manager Performance Manager Performance Manager vmmmig.exe $ORACLE_HOME SYSMAN ADMIN vtmusr.txt Performance Manager vmmmig.exe Enterprise Manager vmmmig joseph/password@my_rep my_rep Enterprise Manager 2. vmm2vtm.exe vtmusr.txt Performance Manager vmm2vtm.exe Enterprise Manager V2.x Performance Manager vmm2vtm.exe joseph/password@my_rep my_db my_rep Enterprise Manager V2.x my_db 2-3
28 Capacity Planner Performance Manager Performance Manager my_db vmm2vtm.exe vtmusr.txt vtmusr.txt vmm2vtm.exe Performance Manager Performance Manager Performance Manager Enterprise Manager Performance Manager Oracle Enterprise Manager Oracle Enterprise Manager Performance Manager Performance Manager 2 Performance Manager Oracle Parallel Server Performance Manager Oracle7 Parallel Server Performance Manager a. b. ops_gdl.sql ops_dbl.sql ops_dbl.sql ops_dbl.sql c. ops_mon.sql ops_ctab.sql ops_dbl.sql ops_pack.sql Oracle7 Parallel Server Performance Manager Oracle7 V$ GV$ PL/SQL GV$ Performance Manager O$ 2-4 Oracle Diagnostics Pack
29 TopSessions 2. Oracle8 Parallel Server Performance Manager Parallel Server GV$ Oracle Oracle 8.0 Parallel Server Parallel Server Oracle Parallel Server Management TopSessions TopSessions TopSessions SELECT smptsixx.sql xx $ORACLE_HOME SYSMAN ADMIN Oracle Oracle 8.0 Oracle 8.1 smptsi73.sql smptsi80.sql smptsi81.sql smptsixx.sql 2 catbloxx.sql utlxplxx.sql 2 Oracle Advanced Events TopSessions 1. SQL*Plus Worksheet Oracle - <ORACLE_HOME> Database Administration SQLPlus Worksheet : ORACLE_HOME Diagnostics Pack Oracle 2-5
30 Trace 2. SYS Oracle Enterprise Manager Oracle Enterprise Manager 3. SELECT ANY TABLE SYSTEM smptsixx.sql SYS Security Manager Security Manager Oracle Enterprise Manager 4. smptsixx.sql smptsixx.sql TopSessions 5. ALL_CATALOG SYS catalog.sql catalog.sql $ORACLE_HOME RDBMSxx ADMIN 6. AUDIT_ACTIONS SYS cataudit.sql cataudit.sql $ORACLE_HOME RDBMSxx ADMIN 7. SQL*Plus Worksheet Trace Trace Oracle Oracle Intelligent Agent Trace Intelligent Agent Oracle Agent Oracle Management Server OMS Trace Oracle Enterprise Manager Trace Oracle8 Server Trace Oracle Server Trace 2-6 Oracle Diagnostics Pack
31 Trace Oracle8 Server Trace Oracle8 Server Trace INITsid.ORA ORACLE_TRACE_ENABLE TRUE Oracle Server Trace Trace Oracle Server Trace DB : TRACESVR Trace : DBMS_ORACLE_TRACE_AGENT SYS otrcsvr.sql otrcsvr.sql UNIX $ORACLE_HOME/otrace/admin Windows NT $ORACLE_HOME otracexx admin otrcsvr.sql $ORACLE_HOME rdbms Admin otrcsvr.sql Trace Trace Collection Services Trace Trace Trace collection_name.dat Oracle Trace Oracle Enterprise Manager Oracle Trace Oracle Trace 2-7
32 Trace 2-8 Oracle Diagnostics Pack
33 3 Oracle Performance Manager Oracle Performance Manager Oracle Enterprise Manager Oracle Performance Manager Agent Oracle Data Gatherer Oracle Data Gatherer Agent Oracle Intelligent Agent Oracle Performance Manager Agent Agent 3-2 Oracle Performance Manager 3-1 Oracle Oracle Performance Manager 3-1 Oracle Performance Manager Oracle Oracle Server Microsoft SQL Oracle Diagnostics Pack Management Pack for Oracle Applications Standard Management Pack Oracle Standard Edition Oracle Performance Manager 3-1
34 3-1 Oracle Performance Manager Oracle Performance Manager Oracle Data Gatherer Oracle Data Gatherer Oracle Performance Manager Oracle Performance Manager Data Gatherer Oracle Data Gatherer 3 3 Enterprise Manager Oracle Management Server Oracle Performance Manager Performance Manager Data Gatherer Data Gatherer Performance Manager Data Gatherer Performance Manager Data Gatherer Performance Manager Data Gatherer 3-2 Oracle Diagnostics Pack
35 Oracle Performance Manager : Agent Data Gatherer tnsnames Oracle Performance Manager Oracle Performance Manager HTML Oracle Performance Manager Oracle Enterprise Manager Oracle Performance Manager Oracle Performance Manager 3-3
36 Oracle Performance Manager Oracle Performance Manager Oracle Enterprise Manager Oracle Performance Manager Oracle Enterprise Manager Diagnostics Pack Performance Manager Oracle Enterprise Manager Diagnostics Pack Performance Manager Performance Manager Performance Manager : Oracle Enterprise Manager Oracle Performance Manager Oracle Performance Manager Oracle Enterprise Manager Oracle Management Server Oracle Performance Manager Oracle - <ORACLE_HOME> Diagnostics Pack Performance Manager : ORACLE_HOME Diagnostics Pack Oracle Performance Manager Oracle Management Server Performance Manager 3-4 Oracle Diagnostics Pack
37 Oracle Performance Manager Performance Manager Oracle Performance Manager 1. Oracle Management Server 2. Oracle Management Server Management Server Management Server Management Server Oracle Management Server Oracle Management Server Management Servers 3. OK : Enterprise Manager 2.1 Oracle Enterprise Manager Performance Manager Oracle Performance Manager Oracle Enterprise Manager OK : Oracle Performance Manager Oracle Performance Manager Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager 3-5
38 Oracle Performance Manager Oracle Performance Manager Performance Manager Performance Manager Performance Manager Diagnostics Pack SQL Server Oracle Performance Manager 3-6 Oracle Diagnostics Pack
39 Oracle Performance Manager Oracle Enterprise Manager Performance Manager + Enterprise Manager : Performance Manager Performance Manager Performance Manager Performance Manager 3. OK Performance Manager Oracle Performance Manager 3-7
40 Performance Manager Performance Manager Performance Manager Performance Manager 1. Performance Manager 2. Performance Manager Oracle Diagnostics Pack
41 Performance Manager 3-2 Memory Faults 3-2 Windows NT Memory Memory at a Glance Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager Oracle Performance Manager 3-9
42 Oracle Performance Manager 1 1 Oracle Performance Manager : 1 5 Performance Manager 5 1. Performance Manager 3-10 Oracle Diagnostics Pack
43 2. 3. OK Performance Manager Performance Manager 2. Oracle Performance Manager 10 Pagefaults Per Process Oracle Performance Manager 3-11
44 : ProcessPagefaults Per ProcessWindows NT UNIX Process DataProcess Info 1. Performance Manager Pagefaults Per Process < > Process Pagefaults Per Process : 4. Performance Manager OK CPU 10 Agent 10 CPU CPU Oracle Diagnostics Pack
45 1 1 Oracle Lock Manager 1 Performance Manager : 3-11 Performance Manager Oracle Capacity Planner Oracle Performance Manager 3-13
46 Performance Manager Oracle Capacity Planner Capacity Planner : Performance Manager Performance Manager Capacity Planner Performance Manager Oracle Capacity Planner 3-14 Oracle Diagnostics Pack
47 Performance Manager Performance Manager : Capacity Planner Performance Manager Performance Manager Performance Manager Oracle Performance Manager 3-15
48 : Performance Manager OKPerformance Manager : Performance Manager Performance Manager 3-16 Oracle Diagnostics Pack
49 : HTML 1. Performance Manager HTML Web Web Web Web HTML Oracle Performance Manager Performance Manager Oracle Performance Manager 3-17
50 Performance Manager Oracle Performance Manager Performance Manager Performance Manager : 3-18 Performance Manager Oracle Diagnostics Pack
51 : Performance Manager Oracle Performance Manager 3-19
52 SQL 2 5. SQL SQL 6. Performance Manager SQL Performance Manager 7. SQL : Agent Oracle Diagnostics Pack
53 4. SQL 3-21 Performance Manager 1 Performance Manager : Agent Performance Manager / Oracle Performance Manager Oracle Performance Manager 3-21
54 1. 2. Performance Manager OK SQL Performance Manager Oracle Performance Manager 2.1 Oracle Performance Manager 2-3 Performance Manager 3-22 Oracle Diagnostics Pack
55 [Ctrl]+[P] [Ctrl]+[R] [Ctrl]+[K] [Ctrl]+[J] [Ctrl]+[Q] [Ctrl]+[Y] [Ctrl]+[W] [Ctrl]+[F] [Ctrl]+[B] [Ctrl]+[S] [Ctrl]+[A] [Alt]+[F4] N/A N/A N/A N/A N/A N/A N/A [Ctrl]+[Q] [Ctrl]+[E] [Ctrl]+[O] Oracle Performance Manager 3-23
56 3-2 [Ctrl]+[D]... [Ctrl]+[Shift]+[U] [Ctrl]+[Shift]+[H] [Ctrl]+[H] [Ctrl]+[Shift]+[S] [F1] 3-24 Oracle Diagnostics Pack
57 4 Oracle Capacity Planner Oracle Capacity Planner Oracle Enterprise Manager Oracle Capacity Planner Oracle Capacity Planner Agent Oracle Data Gatherer Oracle Data Gatherer Oracle Data Gatherer Oracle Enterprise Manager Intelligent Agent Oracle Capacity Planner Oracle Data Gatherer Oracle Data Gatherer 4-2 Oracle Capacity Planner 4-1 Oracle Oracle Capacity Planner 4-1 Oracle Capacity Planner Oracle Oracle Microsoft SQL Oracle Diagnostics Pack Management Pack for Oracle Applications Oracle Capacity Planner 4-1
58 Capacity Planner 4-1 Oracle Capacity Planner Capacity Planner Capacity Planner Agent Capacity Planner Agent Agent Oracle Capacity Planner Agent Agent Oracle Performance Manager Oracle Data Gatherer Oracle Data Gatherer Oracle Performance Manager Oracle Performance Manager Data Gatherer 4-2 Oracle Diagnostics Pack
59 Oracle Capacity Planner Oracle Data Gatherer 3 Enterprise Manager Oracle Management Server Oracle Performance Manager Performance Manager Data Gatherer Data Gatherer Performance Manager Data Gatherer Performance Manager Data Gatherer Performance Manager Data Gatherer : Agent Data Gatherer tnsnames Oracle Capacity Planner Oracle Capacity Planner 95% I/O I/O Oracle Capacity Planner 4-3
60 Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Enterprise Manager Diagnostics Pack Capacity Planner Oracle Enterprise Manager Capacity Planner Oracle Enterprise Manager Diagnostics Pack Oracle Capacity Planner Oracle Enterprise Manager Oracle Diagnostics Pack Capacity PlannerCapacity Planner Oracle Enterprise Manager OK Oracle Capacity Planner Oracle Capacity Planner [F1] Oracle Capacity Planner 4-4 Oracle Diagnostics Pack
61 Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner 5. Oracle Capacity Planner 4-1 Oracle Capacity Planner 4-5
62 4-1 1 Oracle Diagnostics Pack Enterprise Manager Enterprise Manager Enterprise Manager 1. Oracle Capacity Planner Oracle Capacity Planner 4-6 Oracle Diagnostics Pack
63 2. 1 Oracle Enterprise Manager Oracle Capacity Planner 3. Capacity Planner + Oracle Capacity Planner Oracle Capacity Planner Windows NT Oracle Capacity Planner Oracle Capacity Planner 4-7
64 Enterprise Manager Capacity Planner Enterprise Manager Agent Capacity Planner Capacity Planner Capacity Planner Capacity Planner Capacity Planner Capacity Planner Capacity Planner Capacity Planner 3. Capacity Planner 4. OK Oracle Capacity Planner Oracle Diagnostics Pack
65 Oracle Capacity Planner Capacity Planner Agent Oracle Capacity Planner 4-9
66 : Agent Agent Agent 4-2 Oracle Capacity Planner Capacity Planner Oracle Enterprise Manager Oracle Enterprise Manager Oracle Capacity Planner Agent Oracle Capacity Planner Agent MY_DB.WORLD Agent MYNODE MYNODE Net8 SQL*Net MY_DB.WORLD MY_DB.WORLD MYNODE TNSNAMES.ORA 4-10 Oracle Diagnostics Pack
67 2 Oracle Capacity Planner : Oracle Capacity Planner Oracle Capacity Planner [ ] [ ] Oracle Capacity Planner 4-11
68 Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner 10 % 1 Oracle Capacity Planner 1 Oracle Capacity Planner % % % 4-12 Oracle Diagnostics Pack
69 12 Oracle Capacity Planner 12 % 12 Oracle Capacity Planner 12 % 12 Oracle Capacity Planner 12 % Oracle Capacity Planner 12 1 Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner 4-13
70 1. Capacity Planner 2. OK Capacity Planner 3. Capacity Planner Capacity Planner Agent Oracle Diagnostics Pack
71 4-3 System Processor Memory Capacity Planner 1 I/O I/O Oracle Capacity Planner 4-15
72 LogicalDisk Percent Free Space Free Megabyte Current Disk Queue Length Disk Writes per Second 1 1 Oracle Capacity Planner 1 1 LogicalDisk 1 2 CPU CPUcpu1 cpu2 1 Capacity Planner Oracle Diagnostics Pack
73 Capacity Planner Capacity Planner ANG-PC Capacity Planner 4-4 Capacity Planner Capacity Planner 3. Capacity Planner OK Oracle Capacity Planner 4-17
74 Capacity Planner 3. 1 Capacity Planner Web Capacity Planner 2. 1 Capacity Planner HTML Web Capacity Planner Oracle Diagnostics Pack
75 : Agent Capacity Planner 4. SQL SQL 5. Oracle Capacity Planner SQL Oracle Capacity Planner 4-19
76 : Oracle Capacity Planner Capacity Planner 1 SQL Oracle Capacity Planner Oracle Capacity Planner Capacity Planner Capacity Planner : Oracle Server Agent / 4-20 Oracle Diagnostics Pack
77 / / / / / / Oracle Capacity Planner : Oracle Capacity Planner 4-21
78 Capacity Planner SQL 4. SQL 5. SQL SQL SQL Oracle Capacity Planner 6. : Oracle Server Agent Capacity Planner Capacity Planner Oracle Diagnostics Pack
79 7. OK Capacity Planner Oracle Capacity Planner 4-23
80 Agent Oracle Capacity Planner 4-26 SQL 4-40 Oracle Capacity Planner Agent Agent $ORACLE_HOME odg log alert_dg.log Agent Oracle Enterprise Manager Intelligent Agent Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner 4-5 Oracle Capacity Planner 4-5 Oracle Capacity Planner Oracle Capacity Planner 4-24 Oracle Diagnostics Pack
81 Capacity Planner 2 Oracle Capacity Planner Oracle Capacity Planner 4-25
82 Capacity Planner Capacity Planner Oracle Diagnostics Pack
83 1. 2. Performance Manager 4-6 Oracle Capacity Planner Oracle Capacity Planner 4-27
84 Capacity Planner Oracle Capacity Planner : Oracle Diagnostics Pack
85 : / + 4. Capacity Planner OK Oracle Capacity Planner 4-29
86 5. OK Capacity Planner : OK : Oracle Diagnostics Pack
87 4. 5. OK Oracle Capacity Planner Capacity Planner Oracle Capacity Planner 4-31
88 2 1. Capacity Planner OKCapacity Planner 4-32 Oracle Diagnostics Pack
89 4-28 OK OKCapacity Planner 1 1 CPU % Oracle Capacity Planner 4-33
90 1 X / OKCapacity Planner : / [Page Down] 3 [Page Up] [Home] [End] 4-34 Oracle Diagnostics Pack
91 [ ] [ ] [ ] 8 [ ] Oracle Capacity Planner 4-35
92 100 Capacity Planner Y Oracle Capacity Planner Oracle Capacity Planner? Oracle Capacity Planner CPU 95%? Oracle Diagnostics Pack
93 2. Capacity Planner : : : Capacity Planner 4-10 Oracle Capacity Planner 4-37
94 OK : Oracle Capacity Planner Oracle Diagnostics Pack
95 OK Capacity Planner HTML 1. Capacity Planner HTML Web Web Web Web HTML Oracle Capacity Planner 4-39
96 Oracle Capacity Planner Oracle Capacity Planner Oracle Capacity Planner Microsoft Excel Oracle Capacity Planner Oracle Capacity Planner : Oracle Capacity Planner Oracle Capacity Planner vp_service_ref Oracle Capacity Planner The HOST NAME Agent The SVC_ID vp_class_ref Oracle Capacity Planner SVC_ID SVC_ID Oracle Diagnostics Pack
97 Oracle Capacity Planner CLS_ID MOD_ID SVC_ID IS_UDS CONTAINER_CLASS_LABEL I/O VP_0_2_2_8_BASE VP_0_2_2_8_HOUR VP_0_2_2_8_DAY VP_0_2_2_8_WEEK VP_0_2_2_8_MONTH VP_0_2_2_8_YEAR 2 3 Oracle Capacity Planner AV SM MN MX SD VR CT Oracle Capacity Planner 4-41
98 Oracle Capacity Planner Oracle Diagnostics Pack
99 5 Oracle E-Business Management Tools Oracle E-Business Management Tools E-Business Tools Web E-Business E-Business Tools E-Business Web Web Enterprise Manager 2.2 Apache HTTP Oracle ias 1.0 E-Business Tools 2.2 Web Enterprise Manager Web Web Web Web Web Apache Web Oracle ias Web Oracle E-Business Management Tools 5-1
100 Web Web Web I/O Web E-Business Tools Web Web 2 Web Apache Web 5-1 Web / Web Web Web Web : UNIX Windows NT Web Apache Server Access Log Traffic Web Apache HTML Apache 5-2 Oracle Diagnostics Pack
101 Web Web HTML Apache Server Access Log Traffic Apache Server Access Log Traffic Apache Server Access Log Traffic 5-2 KB 5-3 KB Oracle E-Business Management Tools 5-3
102 1 5-4 KB 00: KB Oracle Performance Manager Web Web Performance Overview I/O Server Utilization 5-4 Oracle Diagnostics Pack
103 Performance Overview Performance Overview 5-6 Performance Overview Web Server at a Glance Chart Group Web Requests per Second Web Bytes per Second Web Bytes per Request 1 Server Utilization I/O Chart Group I/O Requests per Second Web Bytes per Second Web Server Utilization Chart Group Server Utilization I/O I/O I/O 5-7 I/O Total Kilobytes Served Total Requests Served Bytes per Second Requests per Second Bytes per Request Web Web Web Web 1 Oracle E-Business Management Tools 5-5
104 Server Utilization Server Utilization 5-8 Server Utilization Busy Servers Idle Servers Total Servers 5-6 Oracle Diagnostics Pack
105 6 Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions V$SESSION V$STATNAME V$SESSTAT ALL_TAB_COLUMNS V$OPEN_CURSOR V$SQLTEXT V$LOCK SYS.DBA_OBJECTS V$ROLLNAME Oracle TopSessions 6-1
106 Oracle TopSessions PLAN_TABLE ALL_CATALOG AUDIT_ACTIONS 4 Oracle TopSessions Oracle TopSessions Oracle TopSessions smptsixx.sql Oracle Enterprise Manager Oracle TopSessions xx Oracle 7.3 smptsi73.sql Oracle 8.0 smptsi80.sql $ORACLE_HOME SYSMAN ADMIN SYS 2-5 TopSessions ALL_CATALOG AUDIT_ACTIONS SYS catalog.sql $ORACLE_HOME RDBMSxx ADMIN Oracle TopSessions Oracle TopSessions Oracle Enterprise Manager : Oracle TopSessions 6-1 Oracle TopSessions n 6-17 : Oracle TopSessions Oracle TopSessions ORACLE_HOME SYSMAN TEMP TOPSESS.OPT 6-2 Oracle Diagnostics Pack
107 Oracle TopSessions 6-1 Oracle TopSessions 6-1 Oracle TopSessions Oracle TopSessions Oracle TopSessions 6-1 Oracle TopSessions Oracle TopSessions 6-3
108 Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions / TopSessions Oracle TopSessions Oracle TopSessions / : , Oracle Diagnostics Pack
109 Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions 6-19 Oracle TopSessions / Oracle TopSessions 6-5
110 Oracle TopSessions Oracle TopSessions / / Oracle TopSessions 6-17 Oracle TopSessions Oracle TopSessions Oracle TopSessions X X Oracle TopSessions Oracle TopSessions 6-6 Oracle Diagnostics Pack
111 Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions n V$SESSION SID Oracle ID USERNAME Oracle OSUSER 4 COMMAND Oracle STATUS IDLE ACTIVE KILLED BLOCKED MACHINE Oracle TopSessions 6-7
112 PROGRAM n 6-17 V$ Oracle Server Oracle Server Oracle Server Oracle TopSessions Oracle TopSessions 4 Oracle TopSessions SID 6-8 Oracle Diagnostics Pack
113 V$SESSION V$ Oracle Server Oracle Server Oracle Server Oracle Server Oracle7 Oracle8 Oracle 7.3 Server SADDR SID Oracle ID SERIAL# SID AUDSID ID PADDR Oracle USER# ID Oracle TopSessions 6-9
114 USERNAME COMMAND Oracle TADDR LOCKWAIT NULL STATUS ACTIVE IDLE KILLED BLOCKED SERVER DEDICATED SHARED PSEUDO NONE SCHEMA# SCHEMANAME OSUSER PROCESS ID MACHINE TERMINAL PROGRAM TYPE SQL_ADDRESS SQL SQL 6-10 Oracle Diagnostics Pack
115 SQL_HASH_VALUE SQL SQL PREV_SQL_ADDR SQL SQL SQL PREV_HASH_VALUE SQL SQL SQL MODULE DBMS_APPLICATION_INFO.SET_MODULE MODULE_HASH ACTION DBMS_APPLICATION_INFO.SET_ACTION ACTION_HASH CLIENT_INFO DBMS_APPLICATION_INFO.SET_CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_ROW# ID ID ROW_WAIT_FILE# ROW_WAIT_ROW# ID ROW_WAIT_OBJ# ROW_WAIT_BLOCK# ROW_WAIT_ROW# ID ROW_WAIT_OBJ# Oracle TopSessions 6-11
116 ROW_WAIT_ROW# ID ROW_WAIT_OBJ# LOGON_TIME LAST_CALL_ET Oracle Server V$SESSTAT V$ Oracle Server Oracle Server / OK 6-12 Oracle Diagnostics Pack
117 ... $ORACLE_HOME SYSMAN TEMP TOPSESSC.INI SQL : V$ SQL EXPLAIN PLAN SYS EXPLAIN PLAN SQL SQL : SQL : SQL EXPLAIN PLAN SQL SQL EXPLAIN PLAN 6-14 EXPLAIN PLAN SQL 1 SQL SQL Oracle TopSessions 6-13
118 : SQL SQL 6-1 Oracle TopSessions : EXPLAIN PLAN SELECT INSERT UPDATE DELETE SQL SQL EXPLAIN PLAN EXPLAIN PLAN EXPLAIN PLAN SQL EXPLAIN PLAN Explain Plan SID xx y SQL EXPLAIN PLAN SQL EXPLAIN PLAN EXPLAIN PLAN EXPLAIN PLAN : Oracle 7.3 : Oracle TopSessions SYS PLAN_TABLE UTLXPLAN.SQL OK TopSessions EXPLAIN PLAN UTLXPLAN.SQL 6-14 Oracle Diagnostics Pack
119 V$LOCK V$ROLLNAME V$ Oracle Server Oracle Server / Oracle ID Oracle ID MR RT REDO UN TX TM DMLUL PL/SQL DX CF IS FS IR ST TS IV LS RWSQ TE TT NULL Row-S (SS) Row-X (SX)S/Row-X (SSX) NULL Row-S (SS) Row-X (SX)S/Row-X (SSX) TM TX Oracle TopSessions 6-15
120 USERNAME ID ID1 ID ID2 : 6-1 Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions SID Oracle TopSessions 6-16 Oracle Diagnostics Pack
121 Oracle TopSessions : Oracle TopSessions Oracle TopSessions ORACLE_HOME SYSMAN TEMP TOPSESS.OPT Oracle TopSessions Parallel Server SQL V$STATNAME CLASS CPU CPU I/O Oracle TopSessions 6-17
122 UGA Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle Diagnostics Pack
123 Oracle TopSessions : 10 1,000 Oracle TopSessions N N n 10 n Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions 6-19
124 Oracle TopSessions 6-20 Oracle Diagnostics Pack
125 7 Oracle Advanced Event Tests Oracle Enterprise Manager EMS DBAEMS DBA Enterprise Manager 7-2 Advanced Event Tests Oracle Diagnostics Pack Microsoft SQL Server Windows NT : Oracle Enterprise Manager Oracle Enterprise Manager Oracle Advanced Event Tests 7-1
126 7-1 Enterprise Manager : Intelligent Agent Intelligent Agent SQLNET Data Gatherer Web Agent Agent Management Server Agent Management Server 2 : Intelligent Agent Intelligent Agent Apache Web Oracle Advanced Event Tests Oracle Diagnostics Pack 7-2 Oracle Diagnostics Pack
127 Oracle Advanced Event Tests SQL 7-2 SQL ARCHIVELOG ORA ARCHIVELOG Oracle Advanced Event Tests 7-3
128 7-3 Oracle PL/SQL Oracle 2 16 Oracle DBMS_ JOB.BROKEN DBMS ORA ORA ORA Oracle Exception ORA-006xx ORA ORA ORA Oracle Oracle Oracle SYS.DEFERROR SYS.DEFERROR Oracle PL/SQL Oracle Oracle Oracle 16 Oracle DBMS 7-4 Oracle Diagnostics Pack
129 7-3 : RESTRICTED SESSION LICENSE_MAX_SESSIONS ORA Oracle DBMS SYS.DBA_JOBS NEXT_DATE 1 : catblock.sql 7-4 I/O I/O 1 : DB_BLOCK_BUFFERS SGA 1 DB_BLOCK_BUFFERS DB_BLOCK_SIZE DB_BLOCK_SIZE DB_BLOCK_BUFFERS Oracle Advanced Event Tests 7-5
130 7-4 I/O Oracle Server LONG LONG RAW DB_BLOCK_SIZE 1 Oracle Oracle Oracle I/O :CPU 1 1 SQL SGA 3 SQL SQL I/O I/O I/O / I/O 7-6 Oracle Diagnostics Pack
131 7-4 DBWR : % CPU I/O SQL SGA PL/SQL SQL 3 SQL SQL I/O SQL CPU Oracle Advanced Event Tests 7-7
132 7-4 I/O Redo SysStat SQL*Net I/O / I/O REDO LGWR REDO REDO REDO LGWR REDO REDO REDO REDO V$SYSSTAT V$SYSSTAT SQL Worksheet SELECT NAME VALUE FROM V$SYSSTAT SysStat V$SYSSTAT V$SYSSTAT SQL Worksheet SELECT NAME VALUE FROM V$SYSSTAT 7-8 Oracle Diagnostics Pack
133 7-5 DB_FILES DB_FILES : 30 DB_FILES 40 75% 30/ DML_LOCKS DML DML DML DML DDL DML_LOCKS DML DML_LOCKS 0 0 : 40 DML DML_LOCKS 60 67% 40/ PROCESSES PROCESSES : 40 PROCESSES 50 80% 40/ SESSIONS SESSIONS : 20 SESSIONS 25 80% 20/ Oracle Advanced Event Tests 7-9
134 7-5 LICENSE_MAX_SESSIONS LICENSE_MAX_SESSIONS LICENSE_MAX_SESSIONS : 15 LICENSE_MAX_SESSIONS 20 75% 15/ : LICENSE_MAX_SESSIONS LICENSE_MAX_USERS Oracle Server 7-6 Oracle : ARCHIVELOG REDO REDO LOG_ARCHIVE_DEST ARCHIVELOG REDO ARCHIVELOG Oracle8i : 7-10 Oracle Diagnostics Pack
135 7-6 % % % % ARCHIVELOG Oracle8i : Oracle Server Oracle Server Oracle Oracle Server : BACKGROUND_DUMP_DEST USER_DUMP_DEST % 1 Oracle Server Oracle Oracle Advanced Event Tests 7-11
136 7-6 1 MAXEXTENTS ORA : Oracle Server 100 Oracle : Oracle Oracle Oracle 7-12 Oracle Diagnostics Pack
137 7-7 SQL SQL SQL SQL SELECT : Oracle error_log SQL 50 SQL select count(*) from error_log error_log 50 >= SELECT PL/SQL PL/SQL SQL 7-8 SQLNET : Oracle Advanced Event Tests 7-13
138 Microsoft SQL Server Microsoft SQL Server Microsoft SQL Server 7-9 Microsoft SQL Server SQL Server Microsoft SQL Server SQL Server Windows NT SQL Server NT SQL Server Enterprise Manager net start mssqlsever Windows 95 Windows 98 SQL Server C: > sqlservr -c -dc <full path name of master database> -ec <location of the log file> SQL Server 1 SQL Server Oracle SYSTEM Windows NT SQL Server Compaq Tru64 HP-UX IBM AIX Solaris Windows NT 7-14 Oracle Diagnostics Pack
139 Oracle Intelligent Agent Agent Agent Management Server Agent Management Server 2 Data Gatherer Data Gatherer Data Gatherer Data Gatherer Data Gatherer Data Gatherer Data Gatherer ODG-xxxxx Data Gatherer Intelligent Agent Intelligent Agent 7-11 CPU CPU / KB/ CPU Oracle Advanced Event Tests 7-15
140 7-12 % c: Windows /tmp UNIX % Compaq Tru64 Oracle Enterprise Manager Advanced Event Tests for Compaq Tru64 : 7-13 : Compaq Tru64 KB KB % KB / /tmp * KB / /tmp * / /tmp * 7-16 Oracle Diagnostics Pack
141 7-14 Compaq Tru64 KB % % KB vppdc * 1 KB vppdc * 1 % CPU vppdc * 1 % LWPvppdc * % CPU vppdc * 1 % KB vppdc * 1 Oracle Advanced Event Tests 7-17
142 HP-UX Oracle Enterprise Manager Advanced Event Tests for HP-UX CPU : 7-15 : 7-16 : HP-UX CPU CPU 1 CPU 5 CPU 15 % % 60 CPU cpu_stat0 CPU0 * CPU CPU CPU 1 5 CPU cpu_stat0 CPU0 * CPU CPU CPU 5 15 CPU cpu_stat0 CPU0 * CPU CPU CPU 15 %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU % %CPU cpu_stat0 CPU0 * CPU CPU CPU % % 7-18 Oracle Diagnostics Pack
143 7-15 HP-UX CPU Sxbrk % % Wait % Sxbrk %CPU Sxbrk cpu_stat0 CPU0 * CPU CPU CPU Sxbrk % Sxbrk % % cpu_stat0 CPU0 * CPU CPU CPU % Wait %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU Wait Wait % 7-16 HP-UX KB KB % KB / /tmp * KB / /tmp * / /tmp * Oracle Advanced Event Tests 7-19
144 7-17 HP-UX / / I/O fork fork() 7-20 Oracle Diagnostics Pack
145 7-17 HP-UX / / 1 1 IBM AIX Oracle Enterprise Manager Advanced Event Tests for IBM AIX CPU : 7-18 : 7-19 I/O / 7-20 / : 7-21 : 7-22 : 7-23 : / DPC 7-24 Oracle Advanced Event Tests 7-21
146 7-18 IBM AIX CPU % SYS % % Wait % %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU % SYS %CPU cpu_stat0 CPU0 * CPU CPU CPU SYS % % cpu_stat0 CPU0 * CPU CPU CPU % Wait %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU Wait Wait % 7-19 IBM AIX KB KB % KB / /tmp * KB / /tmp * / /tmp * 7-22 Oracle Diagnostics Pack
147 7-20 IBM AIX I/O / / IBM AIX / KB KB KB KB KB KB I/O I/O 7-22 IBM AIX / 1 le0 * / / 1 le0 * Oracle Advanced Event Tests 7-23
148 7-22 IBM AIX / 1 le0 * / 1 le0 * / 1 le0 * 7-23 IBM AIX % % KB % CPU vppdc * 1 % % CPU vppdc * 1 % KB vppdc * Oracle Diagnostics Pack
149 7-24 IBM AIX I/O / I/O / IO / I/O / / / / I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O IO 1 cpu_stat0 * CPU CPU CPU I/O IO I/O 1 cpu_stat0 * CPU CPU CPU I/O I/O 1 I/O cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU Oracle Advanced Event Tests 7-25
150 7-24 IBM AIX / I/O / I/O / fork / / / 1 I/O cpu_stat0 * CPU CPU CPU I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O fork 1 fork() cpu_stat0 * CPU CPU CPU fork() 1 cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU 7-26 Oracle Diagnostics Pack
151 Solaris Oracle Enterprise Manager Advanced Event Tests for Solaris CPU : 7-25 : 7-26 I/O / 7-27 / : 7-28 : 7-29 : 7-30 : / DPC Solaris CPU % SYS % % %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU % SYS %CPU cpu_stat0 CPU0 * CPU CPU CPU SYS % % cpu_stat0 CPU0 * CPU CPU CPU % Oracle Advanced Event Tests 7-27
152 7-25 Solaris CPU Wait % Wait %CPU I/O cpu_stat0 CPU0 * CPU CPU CPU Wait Wait % 7-26 Solaris KB KB % KB / /tmp * KB / /tmp * / /tmp * 7-27 Solaris I/O / / 1 KB 1 1 KB Oracle Diagnostics Pack
153 7-28 Solaris / KB KB KB KB KB KB I/O I/O 7-29 Solaris / 1 le0 * / / 1 le0 * / 1 le0 * / 1 le0 * Oracle Advanced Event Tests 7-29
154 7-29 Solaris / 1 le0 * 7-30 Solaris KB % % KB vppdc * 1 KB vppdc * 1 % CPU vppdc * 1 % LWPvppdc * % CPU vppdc * 1 % KB vppdc * Oracle Diagnostics Pack
155 7-31 Solaris AS I/O / I/O / COW HAT IO / I/O / AS 1 as_fault() cpu_stat0 * CPU CPU CPU AS AS I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O COW1 1 cpu_stat0 * CPU CPU CPU COW COW HAT1 hat_fault() cpu_stat0 * CPU CPU CPU HAT HAT IO 1 cpu_stat0 * CPU CPU CPU I/O IO I/O 1 cpu_stat0 * CPU CPU CPU I/O I/O 1 cpu_stat0 * CPU CPU CPU Oracle Advanced Event Tests 7-31
156 7-31 Solaris / / / / I/O / I/O / / 1 I/O cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU 1 I/O cpu_stat0 * CPU CPU CPU I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O I/O 1 I/O cpu_stat0 * CPU CPU CPU I/O I/O 1 cpu_stat0 * CPU CPU CPU 1 cpu_stat0 * CPU CPU CPU 7-32 Oracle Diagnostics Pack
157 7-31 Solaris fork / vfork / / fork 1 fork() cpu_stat0 * CPU CPU CPU fork() vfork 1 vfork() cpu_stat0 * CPU CPU CPU vfork() 1 cpu_stat0 * CPU CPU CPU Windows NT Oracle Enterprise Manager Advanced Event Tests for Windows NT : MDL 7-32 : 7-33 : 7-34 : 7-35 : Mutex 7-36 : 7-37 : / 7-38 Oracle Advanced Event Tests 7-33
158 : 7-39 : DPC 7-40 : / DPC Windows NT / / / / / NTFS HPFS / / I/O / MDL / MDL / MDL DMA MDL / / / / 7-34 Oracle Diagnostics Pack
159 7-32 Windows NT % LAN LAN % / / / % / / / / / LANLAN / / / / / / / / NTFS HPFS / API / / Oracle Advanced Event Tests 7-35
160 7-32 Windows NT / / / I/O / / / / / 1 / MDL / MDL % % / / MDL / MDL DMA MDL / MDL MDL MDL MDL LAN LAN / / / / 7-36 Oracle Diagnostics Pack
161 7-32 Windows NT / / / / / MDL / / / NTFS HPFS / I/O / MDL / MDL DMA MDL / / / 7-33 Windows NT % 1MB = 1,048,576 % Oracle Advanced Event Tests 7-37
162 7-34 Windows NT / / LAN / / / / / / / / / / 1 1 / / / 7-38 Oracle Diagnostics Pack
163 7-34 Windows NT / / / % / / / % % Oracle Advanced Event Tests 7-39
164 7-34 Windows NT / / ntoskrnl.exe hal.dll ntldr/osloader / / / / 7-35 Windows NT / / / / / / / bps Oracle Diagnostics Pack
165 7-35 Windows NT / / / / / / / / 1 / / / / / / / / Oracle Advanced Event Tests 7-41
166 7-36 Windows NT Mutex Mutex Mutex 1 Mutex Mutex 7-37 Windows NT % % 7-38 Windows NT / / / / 7-42 Oracle Diagnostics Pack
167 7-38 Windows NT / / / / / / / / 2 1 / / / / / / / / Oracle Advanced Event Tests 7-43
168 7-38 Windows NT / / / / % % % % % % 7-39 Windows NT / / / 7-44 Oracle Diagnostics Pack
169 7-39 Windows NT % % % % Windows NT Windows NT Windows NT % % % % Windows NT Windows NT Windows NT % 1 Oracle Advanced Event Tests 7-45
170 7-39 Windows NT 7-40 Windows NT APC / DPC / DPC DPC / / DPC % APC / APC DPC / DPC DPC DPC DPC / DPC DPC / / DPC % DPC DPC DPC % 7-46 Oracle Diagnostics Pack
171 7-40 Windows NT % % % % % I/O I/O % % %Windows NT Windows NT % % % % % 7-41 Windows NT / / / / 1 Windows NT 1 1 / / / / / / Oracle Advanced Event Tests 7-47
172 7-41 Windows NT / / / / / / % DPC % % / / / / / / / % % DPC % DPC DPC % % % % % % 100% 50% % % % 100% % 50% 7-48 Oracle Diagnostics Pack
173 7-41 Windows NT % % % 100% 50% / / / APC / DPC / DPC DPC / / APC / APC DPC / DPCDPC DPC DPC DPC / DPC / / Oracle Advanced Event Tests 7-49
174 Web Web E-Business Tools Web E-Business Web / Web Web Web Web : UNIX Windows NT 7-50 Oracle Diagnostics Pack
175 A Advanced Event Tests Oracle Advanced Event Tests Oracle Enterprise Manager Diagnostics Pack DBA Advanced Event Tests DBA DBA 3 DBA DBA DBA DBA SQL Advanced Event Tests A-1
176 : Oracle Enterprise Manager Oracle Enterprise Manager DBA DBA a. Continuous 1 b. : : : : A-2 Oracle Diagnostics Pack
177 : : : Redo : Redo : : % : % c a. Daily 24 1 b. : : % : % : : : c. 3. a. Weekly Advanced Event Tests A-3
178 b. : : : : : : c. 7-1 Oracle Advanced Event Tests DBA Oracle Enterprise Manager Oracle Enterprise Manager A-1 Redo % % A-4 Oracle Diagnostics Pack
179 APP_DATA DBA DBA DBA 1. Oracle Enterprise Manager a. AppDataAddFile b. SQL*Plus c. ALTER TABLESPACE APP_DATA ADD DATAFILE 'c: orant database app02.ora' SIZE 5M; APP_DATA AppDataAddFile a. AppDataFull 1 Advanced Event Tests A-5
180 b. : : c. AppDataAddFile ='APP_DATA' d. DBA DBA SQL SQL CPU I/O Oracle Enterprise Manager DBA A-6 Oracle Diagnostics Pack
181 1. SharedPool 1 2. : : PL/SQL SQL % : % 3. DBA Oracle Expert SGA DBA SQL Oracle Expert SHARED_POOL_SIZE SQL SQL OPEN_CURSORS SQL SQL / 2 SQL SQL Advanced Event Tests A-7
182 A-8 Oracle Diagnostics Pack
183 A ACTION_HASH 6-11 ACTION 6-11 Agent Data Gatherer ALL_CATALOG Oracle TopSessions 6-2 ALL_TAB_COLUMNS Oracle TopSessions 6-1 AUDIT_ACTIONS Oracle TopSessions 6-2 AUDSID 6-9 C Capacity PlannerOracle Capacity Planner 4-1 catbloxx.sql 2-5 CLIENT_INFO 6-11 COMMAND 6-10 Oracle TopSessions 6-7 D Data Gatherer Data Gatherer Data Gatherer 4-24 E EXPLAIN PLAN 6-13 F FIXED_TABLE_SEQUENCE 6-11 L LAST_CALL_ET 6-12 LOCKWAIT 6-10 LOGON_TIME 6-12 M MACHINE 6-10 Oracle TopSessions 6-7 Microsoft SQL Server 1-7 MODULE_HASH 6-11 MODULE 6-11 O Oracle Capacity Planner Oracle Capacity Planner 4-4 Oracle Data GathererData Gatherer
184 Oracle Performance Manager Oracle TopSessions Oracle TopSessions 6-7 Oracle 7-3 OSUSER 6-10 Oracle TopSessions 6-7 P PADDR 6-9 Performance ManagerOracle Performance Manager 3-1 PLAN_TABLE Oracle TopSessions 6-2 PREV_HASH_VALUE 6-11 PREV_SQL_ADDR 6-11 PROCESS 6-10 PROGRAM 6-10 Oracle TopSessions 6-8 R ROW_WAIT_BLOCK# 6-11 ROW_WAIT_FILE# 6-11 ROW_WAIT_OBJ# 6-11 ROW_WAIT_ROW# 6-12 S SADDR 6-9 SCHEMA# 6-10 SCHEMANAME 6-10 SERIAL# 6-9 SERVER 6-10 SID 6-9 Oracle TopSessions 6-7 smptsixx.sql 2-5 SQL Server 1-7 SQL_ADDRESS 6-10 SQL_HASH_VALUE 6-11 SQL 1-7 SQL 3-20 STATUS 6-10 Oracle TopSessions 6-7 SYS.DBA_OBJECTS Oracle TopSessions 6-1 T TADDR 6-10 TERMINAL 6-10 TopSessions 2-5 Trace TYPE 6-10 U USER# 6-9 USERNAME 6-10 Oracle TopSessions 6-7 UTLXPLAN.SQL 6-14 utlxplxx.sql 2-5 V V$LOCK 6-15 Oracle TopSessions 6-1 V$OPEN_CURSOR Oracle TopSessions 6-1 V$ROLLNAME Oracle TopSessions 6-1 V$ROLLNAME 6-15 V$SESSION Oracle TopSessions
185 V$SESSTAT Oracle TopSessions 6-1 V$SESSTAT 6-12 V$SQLTEXT Oracle TopSessions 6-1 V$STATNAME 6-17 Oracle TopSessions Oracle ID Oracle TopSessions 6-7 Oracle Capacity Planner 4-4 Oracle Performance Manager 3-3 Oracle TopSessions
186 Data Gatherer Oracle TopSessions 6-6 Performance Manager 3-13 Trace Oracle TopSessions 6-19 Oracle TopSessions N Oracle Capacity Planner 4-3 Oracle Performance Manager
187 Oracle TopSessions 6-5 Oracle TopSessions ID Advanced Events 2-1 Capacity Planner 2-2 Performance Manager 2-2 TopSessions 2-5 Trace Oracle TopSessions Oracle TopSessions Oracle TopSessions Oracle TopSessions
188 Capacity Planner Oracle TopSessions 6-1 Oracle TopSessions Oracle TopSessions Performance Manager
189 Oracle TopSessions 6-5 Oracle TopSessions Oracle Capacity Planner 4-4 Oracle TopSessions Oracle TopSessions Performance Manager Oracle TopSessions 6-8 Oracle Performance Manager 3-5 Oracle TopSessions 6-3 Oracle Top Sessions 6-6 Oracle TopSessions 6-5 Oracle TopSessions 6-5 Oracle TopSessions 6-7 Oracle TopSessions 6-7 Oracle TopSessions 6-6 Oracle TopSessions Oracle TopSessions 6-6 Performance Manager 6-6 Oracle TopSessions Oracle TopSessions 6-6 Oracle TopSessions 6-6 Oracle TopSessions
190 Oracle TopSessions 6-7 Oracle TopSessions 6-7 Oracle TopSessions 6-6 Oracle TopSessions 6-5 Oracle TopSessions SQL Oracle TopSessions Oracle TopSessions 6-6 Oracle TopSessions
191
192 -10
Oracle 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
Oracle 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
new_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
Oracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6
Oracle8 Workgroup Server for Windows NT 8.0.6 2000 5 : J00213-01 Oracle8 Workgroup Server for Windows NT, 8.0.6 : J00213-01 Oracle8 Release 8.0.6 for Windows NT A69969-01 Copyright 1999, 2000, Oracle Corporation.
Oracle Diagnostics, Tuning, Change Management Pack日本語リリース・ノート, リリース2.2
Oracle Diagnostics, Tuning, Change Management Pack 2.2 2001 6 J03360-02 : Readme for Oracle Change Management, Diagnostics and Tuning Packs Release 2.2.0.0.0 A85214-02 1.... 3 1.1... 3 1.2 2.2... 3 1.3
new_logo.eps
Oracle for Windows NT and Windows 95/98 8.1.5 1999 5 : A62908-1 Oracle for Windows NT and Windows 95/98 8.1.5 : A62908-1 1 1999 5 1 Oracle Call Interface Getting Started Release 8.1.5 for Windows NT and
Oracleコール・インタフェース for Windows スタート・ガイド リリース8.1.6
Oracle for Windows 8.1.6 2000 4 : J01324-01 Oracle for Windows 8.1.6 : J01324-01 Oracle Call Interface Getting Started, Release 8.1.6 for Windows A73022-01 Eric Belden Joseph Garcia Lisa Giambruno Michael
KeySQL R5.1 Release Note
KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,
KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co
KeySQL for Microsoft Windows 6.0 2006 3 : B28350-01 Copyright 2006, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle
<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
untitled
Oracle Enterprise Repository IBM Rational ClearCase IBM Rational ClearQuest 10g 3 (10.3) 2008 10 Oracle Enterprise Repository IBM Rational ClearCase and IBM Rational ClearQuest Integration Guide, 10g Release
untitled
Oracle Enterprise Repository etrust SiteMinder 10g 3 (10.3) 2008 10 Oracle Enterprise Repository etrust SiteMinder Setup and Configuration Guide, 10g Release 3 (10.3) Copyright 2007, 2008, Oracle. All
untitled
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
橡ExCtrlPDF.PDF
THE Database FOR Network Computing Oracle Oracle Oracle Oracle Oracle Oracle (Oracle Object for OLE Oracle Developer) SQL Oracle8 Enterprise Edition R8.0.5 for Windows NT Oracle8 Enterprise Edition R8.0.5
untitled
Oracle Direct Seminar !?Oracle Database 11g Agenda Oracle Database Enterprise Manager Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000
Oracle 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
オラクルのバックアップとリカバリの必須要件
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
Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apacheパフォーマンス・ガイド, リリース1.0.2
Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apache 1.0.2 2001 2 : J02963-01 Oracle9i Application Server for Windows NT Oracle HTTP Server powered by Apache, 1.0.2 : J02963-01
Oracle8簡単チューニング 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
I
I II III IV V VI VII VIII IX X XI XII XIII XIV 1. 2 3 4 5 2. 6 7 8 3. 1 2 3 9 4 5 10 6 11 4. 1 2 3 1 2 12 1 2 3 1 2 3 13 14 1 2 1 15 16 1. 20 1 21 1 22 23 1 2 3 4 24 1 2 ok 25 1 2 26 1 2 3 27 2. 28
<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
untitled
Oracle Direct Seminar !? Oracle Database 11g - - Agenda Copyright 2009, Oracle. All rights reserved. 2 Agenda Copyright 2009, Oracle. All
KWCR3.0 instration
KeyWeb Creator R3.0 R3.0 for MS-Windows 2005 10 B25586-01 Oracle Oracle Oracle Corporation Copyright 2005, Oracle Corporation All Right Reserved KeyWeb Creator R3.0 2005 10 Copyright 1997-2005 KeyWeb Creator
Oracleの領域管理～トラブル防止のテクニック～
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...
Windows 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
Oracle 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...
意外と簡単!?
!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1 !? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database
Oracle 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
C3印刷用.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
OM.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
Recovery 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...
Oracle Lite Windows CE開発者ガイド,リリース4.0.1
Oracle Lite Windows CE 4.0.1 2000 10 : J02401-01 Oracle Lite Windows CE, 4.0.1 : J02401-01 Oracle Lite Windows CE Developper s Guide,Release4.0.1 A86147-01 Copyright 2000, Oracle Corporation. All rights
RN14.PDF
Oracle Designer/2000 for Windows 95/NT 1.4 A46659-1 1997 7 Oracle Designer/2000 for Windows 95/NT 1.4 Oracle Designer/2000 for Windows 95/NT CD-ROM (PC) ( ) CASE Exchange SQL*Net SQL*Plus OLE Designer/2000
日本語タイトルを入力
Oracle Application Server Infrastructure 2004 6 Oracle Application Server Infrastructure Oracle Application ServerInfrastructure Oracle Application Server 10g Release 9.0.4... 3... 3 i.... 4 ii.... 4...
Web 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!
<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
MultiPASS B-20 MultiPASS Suite 3.10使用説明書
TM MultiPASS Suite Ver.3.10 for Windows ii iii Copyright 1999 Canon Inc. ALL RIGHTS RESERVED iv v vi vii viii ix x 1 2 3 4 5 6 7 8 9 xi xii 1 1 1-1 1 2 3 1-2 4 5 1 1-3 6 1-4 1 7 8 1-5 9 10 11 1-6 1 1-7
Oracle 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
Windowsユーザーの為の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
A 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
~~~~~~~~~~~~~~~~~~ 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
意外と簡単！？ 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
Windows SE RAC 10g 構築手順書
Windows!? Creation Date: Oct 05, 2004 Last Update: April 19, 2005 !? Windows Windows Oracle Database 10g Windows Oracle!? Windows!? Windows!? Windows 4 1. Oracle Fail Safe 2. Oracle 3. Oracle Fail Safe
今から間にあう仮想化入門とXenについて
Xen Linux 2006 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice Agenda IA Xen. Xen 4. Xen 2 19 10 1 IA IA Server Linux Windows Linux Linux
Oracle 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
NEC 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
Oracle 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
Oracle 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
困ったときのQ&A
ii iii iv NEC Corporation 1998 v C O N T E N T S PART 1 vi vii viii ix x xi xii PART 2 xiii PART 3 xiv P A R T 1 3 1 2 PART 3 4 2 1 1 2 4 3 PART 1 4 5 5 6 PART 1 7 8 PART 1 9 1 2 3 1 2 3 10 PART 1 1 2
自己管理型データベース: アプリケーションおよびSQLチューニング・ガイド
: SQL 2005 9 : SQL... 3 SQL... 6... 8... 9 SQL :... 9 SQL... 10... 11 SQL... 12 SQL TUNING SET... 13 SQL... 14 ADDM SQL... 14 SQL... 15 STS... 15... 16 SQL... 16 DBMS_SQLTUNE... 17... 17 SQL... 19 SQL
untitled
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...
book
Bibliotheca21 Personal 3020-7-245-30 P-26D3-A114 Bibliotheca21 Personal 01-30 OS Windows 2000 Windows Server(R) 2003 Windows XP Windows Server(R) 2008 Windows Vista(R) Windows 7 Adobe Adobe Systems Incorporated
Microsoft Word - J doc
Oracle Application Server for HP-UX 4.0.8.2 2000 11 : J02449-01 : Oracle Application Server Release Notes for HP 9000 Servers and Workstations A86087-01 Oracle Application Server for HP-UX 4.0.8.2 Oracle
™…
i 1 1 1 2 3 5 5 6 7 9 10 11 13 13 14 15 15 16 17 18 20 20 20 21 22 ii CONTENTS 23 24 26 27 2 31 31 32 32 33 34 37 37 38 39 39 40 42 42 43 44 45 48 50 51 51 iii 54 57 58 60 60 62 64 64 67 69 70 iv 70 71
D1印刷用.PDF
[ D-1 ] Windows Oracle8i for Windows Oracle8i for Windows / / Visual Basic - Oracle8i SQL Oracle Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i Personal Edition Oracle8i Workgroup Server Oracle8i
自己管理データベース: 自動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
ネットワークビデオレコーダー VK-64/VK-16/VK-Lite v2.2 セットアップガイド
VK-64/VK-16/VK-Lite Ver. 2.2 VK-64 v2.2 VK-16 v2.2 ( VK-64/VK-16) VK-Lite v2.2 ( VK-Lite) VK-64/VK-16 VK-Lite 2 1. 2. 3. 4. 2. 3. ( ) ( ) canon.jp/webview Canon Canon Microsoft Windows Microsoft Internet
<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)
Pro*COBOL for Windows プリコンパイラ・スタート・ガイド リリース8.1.6/1.8.51
Pro*COBOL for Windows 8.1.6/1.8.51 2000 4 : J01326-01 Pro*COBOL for Windows 8.1.6/1.8.51 : J01326-01 Pro*COBOL Precompiler Getting Started, Release 8.1.6 and 1.8.51 for Windows A73024-01 Riaz Ahmed Eric
... 2... 7... 8... 8... 9... 10... 12... 13... 13.... 13... 13... 13... 13... 13... 13... 14... 14... 14... 14... 14... 14... 14... 14... 14.... 14... 14... 16.... 16... 16... 17 Microsoft Licensing Product
Install.PDF
Oracle OLAP Server R6.3 for Windows NT Oracle OLAP Server R6.3 for Sun SPARC Solaris 1 1. 4 1.1....4 1.2....4 2. Windows NT 5 2.1....5 2.1.1. ID... 5 2.1.2. (Windows NT )... 9 2.2....10 2.2.1. Oracle OLAP
Oracle 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...
Oracle Enterprise Manager Oracle Enterprise Manager : A
1.6.0 1998 9 : A61823-1 1.6.0 : A61823-1 1 : 1998 9 : Configuration Guide, Release 1.6.0 : A63732-01 : Eric Belden, Muralidharan Bhoopathy, Maureen Byrne, Erik DeMember, Jorge Fox, Jacqueline Gosselin,
Configuring_01
Symantec Backup Exec Dell EqualLogic Microsoft Exchange Server SQL Server IT / / 24 365 Symantec Backup Exec Advanced Disk-based Backup Option (ADBO) Dell Equal- Logic Microsoft Exchange Server 2003 2007
橡PervasiveSQL2000ReviewersGuide.PDF
Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3 Pervasive.SQL 2000...4 Pervasive.SQL
Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005との技術的比較
Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005 2005 9 Oracle Real Application Clusters 10g Release 2: Microsoft SQL Server 2005... 3 ORACLE REAL APPLICATION CLUSTERS... 4 SQLSERVER
Copyright Oracle Parkway, Redwood City, CA U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated softw
Oracle Solaris Studio 12.3 Part No: E26466 2011 12 Copyright 2011 500 Oracle Parkway, Redwood City, CA 94065 U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
MultiPASS Suite 3.20 使用説明書
TM MultiPASS Suite Ver.3.20 for Windows ii iii Copyright 2000 Canon Inc. ALL RIGHTS RESERVED iv v vi vii viii ix x 1 1 1-1 1 1 2 3 1-2 4 5 1 1-3 1 6 1-4 7 1 8 9 1-5 10 1 11 1-6 1 1-7 1 1-8 2 1 1-9 1 1
活用ガイド （ハードウェア編）
(Windows 98) 808-877675-122-A ii iii iv NEC Corporation 1999 v vi PART 1 vii viii PART 2 PART 3 ix x xi xii P A R T 1 2 1 3 4 1 5 6 1 7 8 1 9 10 11 1 12 1 1 2 3 13 1 2 3 14 4 5 1 15 1 1 16 1 17 18 1 19
日本オラクル株式会社
FISC 6 Oracle Database 10g ~ ~ : 2005 7 26 : 2005 7 31 : 1.0 2004 4 (* ) FISC ) (* ) FISC 6 (* FISC 6 ) FISC 6 Oracle g Database 10 (FISC) http://www.fisc.or.jp FISC http://www.fisc.or.jp/info/info/050307-1.htm
Infoprint 250 GA
Infoprint 250 GA88-0164-00 Infoprint 250 GA88-0164-00 ! viii 2000 5 Copyright International Business Machines Corporation 2000. All rights reserved. ii Infoprint 250 ...III... VI...VII... VIII... VIII...IX
rn_des_60j.PDF
Oracle Designer for Windows NT and Windows 95/98 6.0-1999 7 : A63067-1 Oracle Designer for Windows NT and Windows 95/98 6.0 Oracle Designer for Windows NT and Windows 95/98 Oracle Designer for Windows
<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)
konicaminolta.co.jp PageScope Net Care
konicaminolta.co.jp PageScope Net Care KONICA MINOLTA PageScope Net Care KONICA MINOLTA PageScope Net Care Web KONICA MINOLTA PageScope Net Care SNMP KONICA MINOLTA Printer-MIB KONICA MINOLTA PageScope
パソコン機能ガイド
PART12 ii iii iv v 1 2 3 4 5 vi vii viii ix P A R T 1 x P A R T 2 xi P A R T 3 xii xiii P A R T 1 2 3 1 4 5 1 6 1 1 2 7 1 2 8 1 9 10 1 11 12 1 13 1 2 3 4 14 1 15 1 2 3 16 4 1 1 2 3 17 18 1 19 20 1 1
パソコン機能ガイド
PART2 iii ii iv v 1 2 3 4 5 vi vii viii ix P A R T 1 x P A R T 2 xi P A R T 3 xii xiii P A R T 1 2 1 3 4 1 5 6 1 2 1 1 2 7 8 9 1 10 1 11 12 1 13 1 2 3 14 4 1 1 2 3 15 16 1 17 1 18 1 1 2 19 20 1 21 1 22
Oracle DatabaseとIBM DB2 UDBの技術的比較: パフォーマンスを重視
Oracle Database IBM DB2 UDB : 2005 9 Oracle Database IBM DB2 UDB :... 3... 4 Oracle Database Oracle Database IBM DB2... 4... 5... 5... 6... 7... 9... 10... 10 Oracle Database 10g Oracle Real Application
7 i 7 1 2 3 4 5 6 ii 7 8 9 10 11 1 12 13 14 iii.......................................... iv................................................ 21... 1 v 3 6 7 3 vi vii viii ix x xi xii xiii xiv xv 26 27
9 i 9 1 2 3 4 5 6 ii 7 8 9 10 11 12 .......................................... iii ... 1... 1........................................ 9 iv... v 3 8 9 3 vi vii viii ix x xi xii xiii xiv 34 35 22 1 2 1
i ii iii iv v vi vii viii ix x xi xii xiii xiv xv xvi 2 3 4 5 6 7 $ 8 9 10 11 12 13 14 15 16 17 $ $ $ 18 19 $ 20 21 22 23 24 25 26 27 $$ 28 29 30 31 $ $ $ 32 33 34 $ 35 $ 36 $ 37 38 39 40 $ 41 42 43 44
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows
Systemwalker IT Service Management Systemwalker IT Service Management V11.0L10 IT Service Management - Centric Manager Windows Systemwalker IT Service Management Systemwalker Centric Manager IT Service
EMC NetWorker Module for Microsoft SQL Server リリース5.2 SP1インストール・ガイド
EMC NetWorker Module for Microsoft SQL Server 5.2 1 P/N 300-008-657 REV A01 EMC 2-1-1 151-0053 0120-588543 9:00 17:30 URL http://japan.emc.com Copyright 1996-2009 EMC Corporation. All rights reserved.
20050314_02-4.ppt
Oracle Database 10g Oracle XML DB 2005 3 14 1 Agenda Oracle XML DB XML SQL Oracle Database 10g Release 2 Copyright Oracle Corporation, 2005 All right reserved. 2 XML Oracle Database 10g Release 2 Oracle
Oracle8 Personal Edition for Windows 95/98/NTリリース・ノート, リリース8.0.6
Oracle8 Personal Edition for Windows 95/98/NT 8.0.6 2001 1 : J02482-01 : Oracle8 Personal Edition Release Notes Release 8.0.6 for Windows NT and Windows 95/98 (A86584-01) : Oracle : Windows UNIX Windows
PHP4徹底攻略 改訂版
PHP Copyright 2002 The PHP Development Team. All rights reserved. PostgreSQL Data Base Management System formerly known as Postgres, then as Postgres95. Copyright 1994-2002 Regents of the University of
JP1/Integrated Management - Service Support 操作ガイド
JP1 Version 9 JP1/Integrated Management - Service Support 3020-3-R92-10 P-242C-8F94 JP1/Integrated Management - Service Support 09-50 OS Windows Server 2008 Windows Server 2003 OS JP1/Integrated Management
NetWorker Avamar リリース8.0統合ガイド
EMC NetWorker Avamar 8.0 P/N 300-013-563 A02 Copyright 2012 EMC Corporation. All rights reserved. 2012 7 EMC Corporation EMC Corporation EMC EMC 2 EMC EMC EMC Corporation EMC Web Technical Documentation
Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21
Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21 ... 2... 3...3...4...5 Oracle9i Platform...10 Oracle Collaboration Suite...12...15...23
ORACLEデータベース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
リファレンス
ii iii iv v vi NEC Corporation 1998 vii C O N T E N T S PART 1 PART 2 viii ix C O N T E N T S PART 3 PART 4 x xi C O N T E N T S PART 5 xii xiii xiv P A R T 1 2 1 3 4 5 1 6 7 1 8 1 9 10 11 1 12 13 1 14
etrust Access Control etrust Access Control UNIX(Linux, Windows) 2
etrust Access Control etrust Access Control UNIX(Linux, Windows) 2 etrust Access Control etrust Access Control 3 ID 10 ID SU ID root 4 OS OS 2 aaa 3 5 TCP/IP outgoing incoming DMZ 6 OS setuid/setgid) OS
Oracle 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...
Insert VERITAS™ White Paper Title Here
WHITE PAPER Microsoft SharePoint Portal Server 2003 VERITAS Backup Exec 10 for Windows Servers Microsoft SharePoint Portal Server ...3...3 SharePoint Portal Server...4...4...4...5 Backup Exec 10...5 Backup
PHP Copyright 2000 The PHP Development Team. All rights reserved. PostgreSQL Data Base Management System formerly known as Postgres, then as Postgres95. Copyright 1994-2000 Regents of the University of
rzat10pdf.ps
IBM i 7.2 IBM Navigator for i IBM IBM i 7.2 IBM Navigator for i IBM 9 IBM i 7.2 ( 5770-SS1) RISC CISC IBM IBM i Version 7.2 Connecting to your system Connecting to IBM Navigator for i Copyright IBM Corporation
実施していただく前に
SiteProtector 2.0 Service Pack 5 Service Pack 6 2006 4 7 1.... 2 Event Collector Service Pack 1.13... 3 2. SiteProtector Core SP6... 4 3. Console... 10 4. Service Pack 6... 11 5. 1 Deployment Manager...
▼ RealSecure Desktop Protector 7
System Scanner / Assuria Auditor 4.x システム要件 2006 年 9 月 8 日 System Scanner / Assuria Auditor 4.x システム要件... 1 System Scanner Console... 1 System Scanner 4.2.5 Console... 1 System Scanner 4.2 Console... 2