查看oracle 导出进程,【学习笔记】Oracle 通过v$session查看imp进程信息的案例

天萃荷净

运维DBA反映需求在执行Oracle imp导入时需要查看导入的进程信息，通过v$session分析imp导入进程在服务器端v$session中的username列不是imp登陆用户名，而是imp命令中touser参数值。

测试环境：RHEL 4.8 DB:10.2.0.4.8

1，通过监听方式导数据，在WIN平台导数据

E:\wendang\SkyDrive\rs2\sql>imp system/oracle@orcl10g file=e:/install/test.dmp fromuser=scott touser=scott

Import: Release 11.2.0.3.0 - Production on Sat Jun 8 22:54:08 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses ZHS16GBK character set (possible charset conversion)

. importi