Oracle数据库数据迁移讲述.docx

查看执行计划方法总结之一：explain plan命令? 2014-04-10 00:20:37 分类：?Oracle 查看执行计划的方法有很多种，笔者今后将在博客里一一为大家介绍。本文介绍的是第一种方法，利用explain plan命令来查看执行计划。1.用hr用户登录数据库[oracle@ENMOEDU ~]$ sqlplus hr/oracle@ENMOEDU?SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 10 00:11:00 2014Copyright (c) 1982, 2011, Oracle. ?All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsHR@ENMOEDU ?2.使用explain plan命令HR@ENMOEDU explain plan for select salary from employees where first_name like Pat;Explained.3.查看执行计划HR@ENMOEDU select * from table(dbms_xplan.display);PLAN_TABLE_OUTPUT------------------------------------------------------------------------Plan hash value: 3033625502-------------------------------------------------------------------------------------------| Id ?| Operation ? ? ? ? ? ? ? ? ? | Name ? ? ? ?| Rows ?| Bytes | Cost (%CPU)|?Time ? ? |-------------------------------------------------------------------------------------------| ? 0 | SELECT STATEMENT ? ? ? ? ? ?| ? ? ? ? ? ? | ? ? 1 | ? ?11 | ? ? 2 ? (0)|?00:00:01 || ? 1 | ?TABLE ACCESS BY INDEX ROWID| EMPLOYEES ? | ? ? 1 | ? ?11 | ? ? 2 ? (0)|?00:00:01 ||* ?2 | ? INDEX SKIP SCAN ? ? ? ? ? | EMP_NAME_IX | ? ? 1 | ? ? ? | ? ? 1 ? (0)|?00:00:01 |-------------------------------------------------------------------------------------------Predicate Information (identified by operation id):---------------------------------------------------? ?2 - access(FIRST_NAME=Pat)? ? ? ?filter(FIRST_NAME=Pat)15 rows selected.至此，执行计划查看成功。 Oracle数据库迁移之一：RMAN? 分类：?Oracle 数据库的迁移方式千变万化，各有千秋。今天为大家呈现的是第一种方法，利用RMAN来完成数据库的迁移工作。1.打开RMAN[oracle@ENMOEDU ~]$ rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Sun Apr 6 17:52:06 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.? All rights reserved.connected to target database: ENMOEDU (DBIDRMAN?2.查看当前的配置信息并修改配置信息RMAN