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 Quick Tour CD-ROM... 4 1.4... 4 2.... 5 2.1... 5 2.2 Intelligent Agent Oracle Server... 5 2.3 Enterprise Manager Intelligent Agent... 6 2.4 Enterprise Manager Management Server /... 6 2.5 Intelligent Agent Management Pack... 7 3. Oracle Management Pack... 7 4. Oracle Enterprise Manager... 8 4.1... 8 4.2... 11 4.3... 12 4.4... 14 4.5... 15 Oracle Oracle Oracle Corporation Oracle Enterprise Manager Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved
4.6 DBA Management Pack... 15 4.7 Oracle Management Server OMS... 16 4.8 Enterprise Manager Configuration Assistant... 18 4.9 Enterprise Manager Migration Assistant... 18 4.10 Enterprise Manager... 18 4.11... 19 4.12... 20 5. Oracle Change Management Pack... 22 5.1... 22 5.2... 22 6. Oracle Diagnostics Pack... 28 6.1... 28 6.2... 28 7. Oracle Tuning Pack... 38 7.1... 38 7.2... 38 2 Oracle Diagnostics, Tuning, Change Management Pack
1. 1.1 Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Pack Oracle Management Pack 2.2 Oracle Management Pack 1.2 2.2 Oracle Management Server 2.2.0.0.0 Oracle Enterprise Manager Migration Assistant 2.2.0.0.0 Oracle Change Management Pack 2.2.0.0.0 Oracle Diagnostics Pack 2.2.0.0.0 SQL Server Monitoring Option 2.2.0.0.0 * Diagnostics Pack Documentations 2.2.0.0.0 Oracle Tuning Pack 2.2.0.0.0 Oracle Enterprise Manager Events 2.2.0.0.0 Oracle Diagnostics Pack Advanced Events 2.2.0.0.0 Oracle Management Pack for SAP R/3 Advanced Events 2.2.0.0.0 * Oracle Management Pack for Oracle Applications Advanced Events 2.2.0.0.0 Oracle Enterprise Manager Pack Client 2.2.0.0.0 Oracle DBA Management Pack 2.2.0.0.0 Oracle Schema Manager 2.2.0.0.0 Oracle Storage Manager 2.2.0.0.0 Oracle Security Manager 2.2.0.0.0 Oracle Instance Manager 2.2.0.0.0 SQL*Plus Worksheet 2.2.0.0.0 Oracle DBA Studio 2.2.0.0.0 1. 3
Oracle Enterprise Manager Integrated Applications 2.2.0.0.0 Oracle intermedia Text Manager 2.2.0.0.0 Oracle Spatial Index Advisor 2.2.0 * Oracle Directory Manager 2.1.1.0.0 Oracle Forms Server Manager 2.2.0.0.0 Oracle Enterprise Security Manager 2.0.0.1.0 Net8 Integration 8.1.7.0.0 Oracle Enterprise Manager Migration Assistant 2.2.0.0.0 Oracle Enterprise Manager Web Site 2.2.0.0.0 Oracle HTTP Server 1.3.12.0.1a Oracle HTTP Server Extentions 8.1.7.0.0 Apache Module for Oracle Servlet Engine 8.1.7.0.0 Oracle Mod PL/SQL Gateway 3.0.0.8.0 BC4J Runtime 3.2.1 Apache Configuration for Oracle XML Developer s Kit 8.1.7.0.0 Oracle Enterprise Manager Quick Tours 2.2.0.0.0 Enterprise Manager Documentations 2.2.0.0.0 Oracle Enterprise Manager Paging Server 2.2.0.0.0 1: 2: * 1.3 Quick Tour CD-ROM Oracle Management Pack 2.2 Quick Tour Quick Tour Quick Tour CD-ROM 1.4 1. Enterprise Manager Web 150 200MB Installer Windows NT TEMP Solaris /tmp Bug#1357839 4 Oracle Diagnostics, Tuning, Change Management Pack
2. / Enterprise Manager Configurations Assistant EMCA EMCA Bug#1379570 2. 2.1 Oracle Management Pack 2.2 7.3.4 8.0.6 8.1.x Oracle 2.2 Intelligent Agent Oracle Server Oracle Intelligent Agent Intelligent Agent Oracle Intelligent Agent Intelligent Agent Oracle Intelligent Agent Oracle Intelligent Agent Oracle Server Intelligent Agent Agent Oracle Server Intelligent Agent 7.3.4 1 8.0.6 8.1.5 8.1.6 8.1.7 Intelligent Agent v7.3.4 Intelligent Agent v8.0.6 2 Intelligent Agent v8.1.5 2 Intelligent Agent v8.1.6 2 Intelligent Agent v8.1.7 2 1: Management Pack 7.3.4 Management Pack 2: Intelligent Agent 8.0.6 8.1.x Data Gatherer 2. 5
2.3 Enterprise Manager Intelligent Agent Oracle Management Pack 2.2 Intelligent Agent 7.3.4 Windows NT Intelligent Agent Enterprise Manager 2.x 8.1.5 Intelligent Agent 7.3.x 8.0.x Intelligent Agent Intelligent Agent 7.3.4.1 Intelligent Agent 8.0.6 2.4 Enterprise Manager Management Server / Enterprise Manager DBA Management Pack Management Pack Management Server 2.1 Management Server 2.2 2.1 Management Server 2.2 Management Pack Enterprise Manager 2.2 2.2 Management Server Oracle Enterprise Manager Oracle DBA Management Pack Oracle Tuning Pack Oracle Diagnostics Pack Oracle Change Management Pack Oracle Management Pack for Oracle Applications Oracle Standard Management Pack Management Server Management Server 2.2 Enterprise Manager 2.2 Diagnostics Pack 2.1 Change Management Pack 2.1 Management Server 2.2 2.2 Management Pack Management Server 2.2 Management Pack Oracle Enterprise Manager 6 Oracle Diagnostics, Tuning, Change Management Pack
2.5 Intelligent Agent Management Pack 8.1.7 Intelligent Agent Intelligent Agent 8.1.7 Intelligent Agent Intelligent Agent Oracle Oracle Intelligent Agent 3. Oracle Management Pack Enterprise Manager Oracle Management Pack Performance Manager Capacity Planner Change Manager TopSessions SQL Analyze Index Tuning Wizard Oracle Trace Manager Oracle Trace Data Viewer Oracle Expert Performance Manager Capacity Planner Change Manager Windows TopSessions SQL Analyze Index Tuning Wizard Oracle Trace Manager Oracle Trace Data Viewer Oracle Expert Bug#1344568 1714960 3. Oracle Management Pack 7
4. Oracle Enterprise Manager 4.1 Oracle Enterprise Manager 2.2 4.1.1 Enterprise Manager Intelligent Agent 8.1.7 4.1.2 DBA Studio DBA Studio Web jar 4.1.3 Apache Web Apache for ias Web Apache ias Apache Web Diagnostics Pack Oracle Enterprise Manager 2 Oracle Enterprise Manager Oracle Diagnostics Pack 5 Oracle E-Business Management Tools 7 Oracle Advanced Event Tests 8 Oracle Diagnostics, Tuning, Change Management Pack
4.1.4 4.1.4.1 Intelligent Agent 8.1.7 Oracle Enterprise Manager 5 4.1.4.2 4.1.5 Intelligent Agent Oracle Enterprise Manager 1 4.1.6 Management Server HTML Oracle Enterprise Manager 1 HTML Enterprise Manager 4. Oracle Enterprise Manager 9
4.1.7 DBA Studio : DDL DML Replication Manager : DBA Studio JServer DDL 8i DBMS_STATS : / 4.1.8 OMS OMS OMS - oms.vdp.ping_interval - oms.vdg.max_out_conns - oms.vdg.max_in_conns - oms.repository.connect_timeout 10 Oracle Diagnostics, Tuning, Change Management Pack
- oms.repository.connect_numtries Oracle Enterprise Manager 4.1.9 Intelligent Agent 8.1.7 NIC : Intelligent Agent NIC / Agent NIC NIC : : nmumigrate Intelligent Agent Data Gatherer Intelligent Agent 8.1.7 Data Gatherer Intelligent Agent 8.1.7 Enterprise Manager : MS Windows NT : Intelligent Agent Data Gatherer Oracle Intelligent Agent 4.2 1. [Alt]+[Tab] Bug#806713 2. Management Server foo.us.oracle.com Management Server DNS Management Pack 'hosts' Management Server IP 3. 1 2 4. Oracle Enterprise Manager 11
Bug#618771 4. OEM. TRACING.ENABLED TRACING.LEVEL $ORACLE_HOME sysman config clientconfig.properties Oracle Enterprise Manager 5. DBA Studio 6. Bug#1721004 7. (&P) (&P) 8. 4.3 1. 5 Data Gatherer 12 Oracle Diagnostics, Tuning, Change Management Pack
a) EM b) 2. Enterprise Manager 2.2 Intelligent Agent 8.1.7 80% 60% USERS 8.1.7 Intellgent Agent Intelligent Agent EM 8.1.6 Intelligent Agent Enterprise Manager 2.1 8.1.5 Intelligent Agent Enterprise Manager 2.0.4 3. 2 Enterprise Manager 2.2 Intelligent Agent 4. Enterprise Manager 2.0.4 Enterprise Manager 2.0.4 Enterprise Manager 2.2 Enterprise Manager 2.0.4 4. Oracle Enterprise Manager 13
2.2 5. Bug#819774 6. Windows 2000 Windows 2000 C: winnt temp 21041345280.99 Windows 2000 TEMP TEMP TEMP TEMP TEMP 7. Oracle Management Server DBA Studio (Bug 1377901) 8. SQL SQL EXTENTMANAGEMENT LOCAL Bug#1478964 9. Bug#1479075 10. Intelligent Agent 8.1.6 Windows NT Bug#1478931 11. TCL / convertin convertout 4.4 1. Bug#1283307 14 Oracle Diagnostics, Tuning, Change Management Pack
2. OEM Bug#1363847 4.5 1. 11 30 1 30 2 11 30 12 12 1 1 30 2 Bug#1036820 2. : 07/30/00 : < > Bug#1367312 4.6 DBA Management Pack 1. "." Bug#1055740 2. listener.ora tnsnames.ora Oracle8i Net8 3. OS / Management Server OS 4. SQL*Plus Worksheet SP2-0738 Restricted command SQL*Plus OMS OMS SQL*Plus... SQL*Plus Worksheet 5. DBA Studio Replication Management 4. Oracle Enterprise Manager 15
6. LONG LONG RAW IOT LONG LONG RAW IOT LONG LONG RAW LONG/LONG RAW 7. SYSDBA NORMAL SYSDBA NORMAL SYSDBA Bug#1360896 8. DBA Studio Enterprise Manager DBA Studio Bug#1365244 9. DBA Studio OK Bug#1377721 10. SQL*Plus Worksheet $ORACLE_HOME sysman config dbappscfg.properties SQLPLUS_NLS_LANG= NLS_LANG SQLPLUS_SYSTEMROOT= %SystemRoot% dbappfcfg.properties < > SQLPLUS_NLS_LANG=Japanese_Japan.JA16SJIS SQLPLUS_SYSTEMROOT=C: WINNT 11. DBA Studio xx.xx% xx.xx % 4.7 Oracle Management Server OMS 1. Windows OMS Windows NT Windows 2000 OMS Enterprise Manager Configuration Assistant EMCA 16 Oracle Diagnostics, Tuning, Change Management Pack
OMS EMCA OMS OMS OMS OMS 1) 2) OMS Oracle<Oracle >ManagementServer 3) 2. OMS oemctrl OMS OMS OMS OMS OMS oemctrl Windows NT 2000 OMS Windows NT 2000 OMS OMS $ORACLE_HOME/sysman/log oms.nohup 3. OMS Windows NT 2000 OMS Oracle Enterprise Manager 4. OMS OMS oemctrl oemctrl ping oms OMS 5. Solaris HP OMS Solaris EM HP 10.20 SQLNET.ORA OMS DISABLE_OOB=ON 4. Oracle Enterprise Manager 17
SQLNET.ORA $ORACLE_HOME/network/admin $ORACLE_HOME OMS Sun HP TCP sqlnet OMS 6. Oracle Management Server oemctrl status oms < >/< > VXA-2009 4.8 Enterprise Manager Configuration Assistant 1. 2.2 Oracle Enterprise Manager 2.2 Enterprise Manager DBA Studio Management Pack 2.2 EMCA 2. EMCA Configuration Assistant EMCA DBA EMCA EMCA Windows NT 2000 EMCA EMCA OMS 4.9 Enterprise Manager Migration Assistant 1. 1.x 2.2 2.2 Bug#751627 4.10 Enterprise Manager 1. Enterprise Manager 1 Web 18 Oracle Diagnostics, Tuning, Change Management Pack
2 MSVCRT.DLL 5.00.7303 MSVCRT.DLL dll dll dll c: winnt40 system32 dll dll Windows NT dll dll dll DOS : 1) dll 2) msvcrt.dll _msvcrt.dll 3) msvcrt.dll 4) 2 Web jar EM 3. Enterprise Manager EM DBA Studio SQL Worksheet 4. Web Enterprise Manager URL http://< >:3339/EmWebSite_xx.html (xx ja ) EmWebSite_xx.html EmWebSite.html http://< >:3339/ URL 4.11 4.11.1 Oracle intermedia Text Manager 1. Oracle intermedia Text Manager intermedia Text Manager 2. intermedia Text Manager 4. Oracle Enterprise Manager 19
3. intermedia Text Manager INDEX_SET Bug#1480444 4. intermedia Text Manager MULTI_STOPLIST MULTI_STOPLIST Bug#1480463 5. intermedia Text Manager ConText Server Job failed: Error Output from job xxx lost. OEM Console ConText Server Bug#1587092 4.11.2 Oracle Forms Server Manager 1. Forms Bug#1286040 2. Forms Bug#1370422 4.11.3 Oracle Enterprise Security Manager 1. Enterprise Security Manager Enterprise Security Manager Bug#1183164 4.11.4 Oracle Parallel Server Manager 1. Parallel Server Bug#1051444 2. Parallel Server Oracle Enterprise Manager Parallel Server Parallel Server Parallel Server Bug#1051439 3. Oracle Enterprise Manager Oracle Parallel Server Bug#1106032 1106004 4.12 1. Enterprise Manager Enterprise Manager Windows 95 Windows 98 DOS DOS DOS 20 Oracle Diagnostics, Tuning, Change Management Pack
Enterprise Manager Bug#1161051 2. JRE Oracle JRE 1 1 Enterprise Manager 2.2 Enterprise Manager 2.0 2.1 2.2 JRE Java Runtime Environment JRE 1.1.7.30o JRE 1.1.7.5o 1.1.7.24o Enterprise Manager 2.2 Enterprise Manager 2.2 Enterprise Manager 2.0 2.1 8.1.7 Oracle JRE Enterprise Manager 2.2 CD-ROM 8.1.7 CD-ROM JRE 1.1.7.30o Oracle Universal Installer JRE Installer JRE 3. Enterprise Manager 4. Oracle Enterprise Manager 21
5. Oracle Change Management Pack 5.1 Oracle Change Management Pack 2.2 5.1.1 5.1.2 DB Diff 5.1.3 -l GUI DOS DOS 5.1.4 5.2 5.2.1 Oracle Change Management Pack 1. Change Manager Bug#630628 643516 22 Oracle Diagnostics, Tuning, Change Management Pack
2. Oracle 8i Oracle Change Manager Bug#1140157 3. 0 1 Bug#1354935 4. VBZ$HISTORY object_type object_owner object_name Bug#1274702 5.2.2 1. Oracle7 Server Oracle8 Server ROWID V7 V8 Bug#790579 2. 1 Bug#790574 3. Bug#685123 4. RECOVERABLE ARCHIVELOG ARCHIVELOG ARCHIVELOG RECOVERABLE Bug#789258 5. Oracle Change Management Pack 23
5. Change Manager "set SCRIPTID nnnnnnnn" ID VBZ$JOB_TABLE_SID script_id ID last_step 1 UNDO last_step 1 UNDO Bug#782142 6. ORA-955 Bug#1246254 7. TCL NLS ASCII Bug#1320961 8. ALTER NEXT_EXTENT Bug#1094357 5.2.3 Plan Editor 1. Plan Editor Bug#687631 5.2.4 1. 2 2 1 2. 32KB PL/SQL Bug#1337177 24 Oracle Diagnostics, Tuning, Change Management Pack
3. Bug#1334680 5.2.5 1. Create Baseline SQL SQL SQL Baseline Viewer Bug#1041775 2. 7.3.4 Oracle ASCII ORA-01026 Bug#1171762 5.2.6 CLI 1. Windows95/98 CLI DOS DOS Bug#1154171 2. Windows95/98 Oracle OMS Bug#1219008 5.2.7 Oracle Enterprise Manager Oracle Change Management Pack Oracle Change Management Pack Oracle Change Management Pack Oracle 5.2.7.1 5. Oracle Change Management Pack 25
LOB FLOAT NUMBER(n,n) / 5.2.7.2 : Compare Database Objects 26 Oracle Diagnostics, Tuning, Change Management Pack
1 SELECT : [NOT] DEFERRABLE EXCEPTIONS INTO < > 5.2.7.3 Oracle Change Management Pack : SHARED AUTHENTICATED BY STORAGE BUFFER_POOL CREATE SNAPSHOT CLUSTER CREATE SNAPSHOT LOG NOLOGGING : 5. Oracle Change Management Pack 27
6. Oracle Diagnostics Pack 6.1 Oracle Diagnostics Pack 2.2 Tuning Pack SQL Analyze SQL Web Apache Web Solaris HP-UX NT 6.2 6.2.1 Performance Manager 1. 2. Windows NT Performance Manager Capacity Planner Windows NT diskperf -Y 3. 4. Bug#682636 5. select * ArrayIndexOutOfBoundsException Bug#784409 6. Bug#681800 28 Oracle Diagnostics, Tuning, Change Management Pack
7. 8. Performance Manager 9. Performance Manager Performance Manager Performance Manager 10. 6.2.2 Capacity Planner 1. Intelligent Agent 8.1.7 Capacity Planner 2. 50 1 50 / 3. Capacity Planner Performance Manager Capacity Planner 10 60 Agent Data Gatherer 4. 1 Capacity Planner Bug#682384 5. Capacity Planner Capacity Planner 6. 6. Oracle Diagnostics Pack 29
Oracle Enterprise Manager 7. Capacity Planner 8. 1 Capacity Planner Bug#788116 9. 1 1 10. 11. Capacity Planner 2 Capacity Planner Agent Data Gatherer Agent Data Gatherer 12. Capacity Planning Data Gatherer Data Gatherer Data Gatherer Data Gatherer 13. Capacity Planner CapacityPlanner Capacity Planner 14. Capacity Planner Oracle Management Server 6.2.3 Oracle Trace Manager 1. Oracle 7.3.3 Oracle Trace Manager 7.3.3 Oracle Oracle Tcl Oracle Trace Manager $ORACLE_HOME/network/agent/jobs/oracle/otrace/general Oracle Trace Tcl 2. Oracle Trace Manager Oracle8 Oracle 8i Oracle Oracle8 Server 8.0.3 SQL*Net 30 Oracle Diagnostics, Tuning, Change Management Pack
Oracle Trace Manager Oracle8 SQL*Net 3. < >:< >:<SID> 8.1.6 Enterprise Manager 4. Oracle8i Server 8.1.6 Connect_Disconnect CACHEIO SQL_Text_Only SUMMARY Wait_Events SQL_Txns_and_Stats ALL DEFAULT EXPERT SQL_and_Wait_Stats SQL_Stats_and_Plan Trace Manager Trace Data Viewer Trace Data Viewer 5. Oracle Trace Trace 6. Oracle Trace Oracle 8.1.7 Trace Oracle 8.1.7 Bug#1349207 7. Oracle8i Server 8.1.7 Oracle Trace Data Viewer 2.x Oracle Trace Manager SQL delete from epc_collection where collection_id = <coll_id> Bug#1361074 8. Intelligent Agent 8.1.7 UNIX Oracle Trace Manager Agent Oracle 8.1.5 Oracle Trace TCL Bug#1349161 9. Oracle Trace 10. Trace Manager Trace Manager 6. Oracle Diagnostics Pack 31
11. Trace Manager Trace Manager 6.2.4 Oracle Trace Data Viewer 1. Oracle8 Oracle 8i Oracle Trace init<sid>.ora ORACLE_TRACE_ENABLE TRUE 2. WAIT Oracle Trace Data Viewer timed_statistics DBA Studio 3. Oracle Trace Data Viewer 4. SUN OS Oracle Server 7.3.3 CPU 5. 2.0.4 Trace Data Viewer Oracle Enterprise Manager Oracle Trace C SELECT_ANY_TABLE SYSTEM 6. Trace Data Viewer 1.x 2.x 1.x 2.x 2.x 1.x 7. 8. Oracle Trace Oracle8 Server 8.0.5 CPU Trace CPU Oracle Trace Oracle Enterprise Manager Oracle Trace A 8.0.4 8.0.5 $ORACLE_HOME bin otrcfmt.exe 9. CPU CPU Input_IO Output_IO Pagefaults Pagefault_IO Max_resident_set_size NT Oracle8 Server 8.0.5 CPU 32 Oracle Diagnostics, Tuning, Change Management Pack
Data Viewer / 10. EPC_FACILITY_REGISTRATION Oracle Server 8.0.4 XP-21016: : SELECT DISTINCT FACILITY_NUMBER, FACILITY_VERSION, VENDOR FROM EPC_FACILITY_REGISTRATION WHERE COLLECTION_ID - :1 ORA-00942: 11. EPC_FACILITY_REGISTRATION Oracle Enterprise Manager Oracle Trace C Trace Data Viewer 12. Trace Manager XP-21162: ORA-12154: TNS Enterprise Manager tnsnames.ora Enterprise Manager tnsnames.ora 13. SQL Trace Data Viewer SYS SQL Oracle Server 8.1+ 14. Data Viewer Oracle Forms 15. Oracle Trace Manager SQL_text_only SQL SQL SQL_and_Stats Default 6.2.5 Oracle Advanced Events 1. Intelligent Agent 8.1.7 SUN Solaris IBM AIX HP-UX Tru64 Microsoft NT Enterprise Manager 2.2 OS OS 6. Oracle Diagnostics Pack 33
Intelligent Agent 8.1.7 1 Intelligent Agent 8.1.7 2. Data Gatherer 5 Enterprise Manager 3. SysStat SysStat Delta SQL Bug#637664 4. 2 Bug#739646 5. % >1 % * Bug#752982 6. Solaris AIX Compaq Tru64 HP UNIX 8.1.7 Intelligent Agent * 7. Windows NT % Bug#1350889 34 Oracle Diagnostics, Tuning, Change Management Pack
8. * 9. 8.1.7 Intelligent Agent 5 8.1.7 Intelligent Agent Bug#738833 10. Windows NT Bug#1355912 11. Solaris AIX Compaq Tru64 2 Enterprise Manager Bug#1358645 12. Windows NT NT 13. NT "DISKPERF -Y" 14. Windows 2000 Windows 2000 Agent 6. Oracle Diagnostics Pack 35
Bug#1379645 15. Windows NT Windows 2000 O/S Windows 2000 Bug#1380614 % % % / DPC % % DPC / DPC DPC / APC / Windows 2000 Windows Windows 2000 Agent Windows 2000 8.1.7 Agent Patch #1380614 Windows Agent 6.2.6 Oracle TopSessions 1. TopSessions TopSessions 2. TopSessions 20 36 Oracle Diagnostics, Tuning, Change Management Pack
3. TopSessions F1 6.2.7 E-Business Management Tools 1. Windows NT Server Utilization NT Bug#1307809 2. E-Business Management Tools PERL 5 3. Solaris Web Performance Manager Server Utilization/Idle Servers Data Gather ArrayOutofBound Exception Web Bug#1392143 4. 1 2 : C: C: C: temp C: temp C: temp Bug#1378763 6. Oracle Diagnostics Pack 37
7. Oracle Tuning Pack 7.1 SQL Analyze 2.2 : 1 EXPLAIN PLAN SQL Analyze SQL Analyze SQL Analyze EXPLAIN PLAN SQL PL/SQL Tablespace Map Reorg Wizard 2.2 Tablespace Map Tablespace Map Tablespace Map Reorg Wizard HTML Tablespace Map Reorg Wizard 7.2 7.2.1 SQL Analyze 1. SQL Analyze Oracle Tuning Pack Tuning Pack Tuning Pack Bug#778225 38 Oracle Diagnostics, Tuning, Change Management Pack
1) SQL SQL Analyze 2) SQL Oracle Expert 3) SQL Analyze SQL 2. SQL Analyze SQL SQL Analyze SQLADMIN oracle_home sysman admin VMQROLE.SQL 3. PLAN_TABLE SQL Analyze PLAN_TABLE SQL Analyze PLAN_TABLE SQL Analyze 4. SQL Analyze 3 SQL Analyze 1 10 5. SQL SQL SQL SQL SQL Analyze Oracle Expert Oracle Expert SQL SQL SQL Analyze SQL Analyze SQL SQL SQL Analyze SQL SQL SQL Oracle SQL SQL SQL SQL SQL 6. SQL Analyze Schema Manager SQL Analyze SQL Analyze 7. SQL Analyze SQL Analyze SQL Analyze 7. Oracle Tuning Pack 39
8. SQL Analyze SQL SQL SQL SQL SQL Analyze SQL REM SQL 9. SQL SQL SQL Analyze SQL 10. TopSQL SQL SYS TopSQL SQL SYS SQL 11. SQL Analyze SQL EXPLAIN PLAN EXPLAIN PLAN EXPLAIN PLAN 12. SQL 13. SQL MINUS UNION * 14. Oracle8 SQL 1/ TopSQL 2/ Diagnostics Pack Performance Manager SQL Analyze 3/ SQL SQL Analyze SQL SQL SQL Analyze SQL SQL 15. SQL Analyze SQL SQL Bug#1723321 16. SQL Analyze PL/SQL Tab Enter Bug#1787576 40 Oracle Diagnostics, Tuning, Change Management Pack
7.2.2 Oracle Expert 1. Oracle Expert dba_tab_column dba_constraints dba_users dba_data_files dba_objects dba_indexes dba_segments dba_ind_columns dba_tables dba_rollback_segs dba_sequences dba_views dba_tablespaces dba_synonyms dba_ts_quotas dba_clusters 2. Oracle Expert Oracle Expert PC 3. Oracle Expert Oracle Expert Oracle Expert Oracle Management Server Bug#1359935 4. SYS System Oracle Expert 5. Bug#604088 6. SQL 8KB SQL 7. Oracle Expert Oracle8 8. DB SQL DB 9. SQL Oracle Expert.xdl Oracle Expert / SQL Bug#651722 10. 1024 11. Oracle Expert Oracle8i Server 8.1.6 BUFFER_POOL_KEEP BUFFER_POOL_RECYCLE 7. Oracle Tuning Pack 41
2 8.1.6 8.1.5 2 8.1.5 BUFFER_POOL_KEEP=(buffers:nnn, lru_latches:nnn) BUFFER_POOL_RECYCLE=(buffers:nnn, lru_latches:nnn) Bug#1357057 12. Oracle Expert Bug#1793680 7.2.3 Tablespace Map Reorg Wizard 1. Tuning Pack 2.1 Oracle Tablespace Manager Tablespace Map Reorg Wizard 2 2. Reorg Wizard LOB LOB Reorg 3. Reorg 4. NOVALIDATE 5. Reorg Wizard 32KB LONG LONG RAW Intelligent Agent 8.1.6 6. 7. 42 Oracle Diagnostics, Tuning, Change Management Pack