想知道是ORCLE的什么行为产生了这个操作

qq33649394

今日查看那些进程在使用临时段时候发现如下：
SELECT
distinct se.sid,
se.username,
se.serial#,
se.sql_address,
se.machine,
se.program,
su.tablespace,
su.segtype,
su.contents
FROM gv$session se,gv$sort_usage su
where  se.saddr=su.session_addr；
发现如下进程，想知道这些进程是干什么用的？

SID	USERNAME	SERIAL#	SQL_ADDRESS	MACHINE	PROGRAM	TABLESPACE	SEGTYPE	CONTENTS
961	VGOPMK	60963	C00000062AA81378	cpda02	ude@cpda02 (TNS V1-V3)	TBS_MK_TMP	LOB_DATA	TEMPORARY
977	VGOPMK	8286	C00000062065A8B0	cpda02	ude@cpda02 (TNS V1-V3)	TBS_MK_TMP	LOB_DATA	TEMPORARY
1021	VGOPDW	56042	C00000062AA81378	cpda02	ude@cpda02 (TNS V1-V3)	TBS_DW_TMP	LOB_DATA	TEMPORARY
1011	VGOPDW	57705	00	cpda02	oracle@cpda02 (DW01)	TBS_DW_TMP	LOB_DATA	TEMPORARY
943	VGOPETL	14669	C00000063EA1CFD0	cp-etl01	ociexp@cp-etl01 (TNS V1-V3)	TBS_KR_TMP	HASH	TEMPORARY

qq33649394

谢谢刘大的回复！
那另外一个是什么呢？
下面这个：
ociexp@cp-etl01 (TNS V1-V3)

Maclean Liu(刘相兵

1.

首先 ，  是ORACLE  不是 ORCLE

2.

UDE 一般是 data pump client  如 使用 expdp 、 impdp  工具观察 data pump 作业的完成进度

[oracle@vrh8 ~]$ expdp attach="SYSTEM"."SYS_EXPORT_FULL_01"

Export: Release 10.2.0.5.0 - 64bit Production on Friday, 11 May, 2012 4:37:19

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_EXPORT_FULL_01
  Owner: SYSTEM                        
  Operation: EXPORT                        
  Creator Privs: FALSE                          
  GUID: BFBFA4D094C8E17EE040A8C0BF015B5B
  Start Time: Friday, 11 May, 2012 4:37:17
  Mode: FULL                           
  Instance: G10R25
  Max Parallelism: 1
  EXPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        system/******** full=y                  
  State: EXECUTING                     
  Bytes Processed: 0
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /s01/oracle/product/10.2.0.5/db_1/rdbms/log/expdat.dmp
    bytes written: 4,096
  
Worker 1 Status:
  State: EXECUTING                     
  Object Schema: SYS
  Object Type: DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
  Completed Objects: 14
  Total Objects: 14
  Worker Parallelism: 1


SQL> select program from v$session;

PROGRAM
------------------------------------------------
sqlplus@vrh8.oracle.com (TNS V1-V3)
ude@vrh8.oracle.com (TNS V1-V3)
oracle@vrh8.oracle.com (q004)


就帖子中的信息可以看到  有 data pump 作业正在被执行， 且有人 通过data pump client 监控 这一过程。

qq33649394

版本信息：
SQL> select * From v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0    Production
TNS for HPUX: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

qq33649394

想知道是ORCLE的什么行为产生了这个操作，UDE是什么用户？ 还是ORCLE自身的什么功能？.
select  * from  gv$sqlarea t
where t.sql_id = 'gn74qsy7sv4z4'

INST_ID	SQL_TEXT	SQL_FULLTEXT	SQL_ID	SHARABLE_MEM	PERSISTENT_MEM	RUNTIME_MEM	SORTS	VERSION_COUNT	LOADED_VERSIONS	OPEN_VERSIONS	USERS_OPENING	FETCHES	EXECUTIONS	PX_SERVERS_EXECUTIONS	END_OF_FETCH_COUNT	USERS_EXECUTING	LOADS	FIRST_LOAD_TIME	INVALIDATIONS	PARSE_CALLS	DISK_READS	DIRECT_WRITES	BUFFER_GETS	APPLICATION_WAIT_TIME	CONCURRENCY_WAIT_TIME	CLUSTER_WAIT_TIME	USER_IO_WAIT_TIME	PLSQL_EXEC_TIME	JAVA_EXEC_TIME	ROWS_PROCESSED	COMMAND_TYPE	OPTIMIZER_MODE	OPTIMIZER_COST	OPTIMIZER_ENV	OPTIMIZER_ENV_HASH_VALUE	PARSING_USER_ID	PARSING_SCHEMA_ID	PARSING_SCHEMA_NAME	KEPT_VERSIONS	ADDRESS	HASH_VALUE	OLD_HASH_VALUE	PLAN_HASH_VALUE	MODULE	MODULE_HASH	ACTION	ACTION_HASH	SERIALIZABLE_ABORTS	OUTLINE_CATEGORY	CPU_TIME	ELAPSED_TIME	OUTLINE_SID	LAST_ACTIVE_CHILD_ADDRESS	REMOTE	OBJECT_STATUS	LITERAL_HASH_VALUE	LAST_LOAD_TIME	IS_OBSOLETE	IS_BIND_SENSITIVE	IS_BIND_AWARE	CHILD_LATCH	SQL_PROFILE	SQL_PATCH	SQL_PLAN_BASELINE	PROGRAM_ID	PROGRAM_LINE#	EXACT_MATCHING_SIGNATURE	FORCE_MATCHING_SIGNATURE	LAST_ACTIVE_TIME	BIND_DATA	TYPECHECK_MEM	IO_CELL_OFFLOAD_ELIGIBLE_BYTES	IO_INTERCONNECT_BYTES	IO_DISK_BYTES
1	SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1	SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1	gn74qsy7sv4z4	19023	4208	3264	0	1	1	0	0	0	0	51364	0	0	1	2012-05-07/15:47:15	0	51364	0	0	0	0	670	0	0	0	0	0	3	ALL_ROWS	1	###########################################	3472564287	0	0	SYS	0	C000000609CA7330	2408420324	2932808863	3093310103	ude@cpda02 (TNS V1-V3)	-1469151939		0	0		27210000	41335929		C000000609CA71F0	N	VALID	0	2012-5-7 15:47:15	N	N	N	0				10801	2860	1.16017E+19	1.16017E+19	2012-5-11 15:53:18		0	0	0	0
2	SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1	SELECT COUNT(*) FROM gv$datapump_job WHERE job_id = :1	gn74qsy7sv4z4	18895	4208	3264	0	1	1	1	1	75807	75808	75807	75807	1	1	2012-04-20/17:11:24	0	75855	0	0	4	0	22012692	0	0	0	0	75807	3	ALL_ROWS	1	###########################################	1709183432	0	0	SYS	0	C00000062065A8B0	2408420324	2932808863	3093310103	ude@cpda02 (TNS V1-V3)	-1469151939		0	0		416400000	2777977700		C0000005FE3D6E68	N	VALID	0	2012-4-20 17:11:24	N	N	N	0				10801	2860	1.16017E+19	1.16017E+19	2012-5-11 15:53:23	BEDA0B1007004FACC4B8000101C0172010BFBC663EEF420DAAE044001F290DA911	0	0	0	0

qq33649394

我通过SID 查找到对应的session信息如下：
SID=977:
select * from gv$session t
where t.SID = '977';

INST_ID

SADDR

SID

SERIAL#

AUDSID

PADDR

USER#

USERNAME

COMMAND

OWNERID

TADDR

LOCKWAIT

STATUS

SERVER

SCHEMA#

SCHEMANAME

OSUSER

PROCESS

MACHINE

TERMINAL

PROGRAM

TYPE

SQL_ADDRESS

SQL_HASH_VALUE

SQL_ID

SQL_CHILD_NUMBER

SQL_EXEC_START

SQL_EXEC_ID

PREV_SQL_ADDR

PREV_HASH_VALUE

PREV_SQL_ID

PREV_CHILD_NUMBER

PREV_EXEC_START

PREV_EXEC_ID

PLSQL_ENTRY_OBJECT_ID

PLSQL_ENTRY_SUBPROGRAM_ID

PLSQL_OBJECT_ID

PLSQL_SUBPROGRAM_ID

MODULE

MODULE_HASH

ACTION

ACTION_HASH

CLIENT_INFO

FIXED_TABLE_SEQUENCE

ROW_WAIT_OBJ#

ROW_WAIT_FILE#

ROW_WAIT_BLOCK#

ROW_WAIT_ROW#

LOGON_TIME

LAST_CALL_ET

PDML_ENABLED

FAILOVER_TYPE

FAILOVER_METHOD

FAILED_OVER

RESOURCE_CONSUMER_GROUP

PDML_STATUS

PDDL_STATUS

PQ_STATUS

CURRENT_QUEUE_DURATION

CLIENT_IDENTIFIER

BLOCKING_SESSION_STATUS

BLOCKING_INSTANCE

BLOCKING_SESSION

SEQ#

EVENT#

EVENT

P1TEXT

P1

P1RAW

P2TEXT

P2

P2RAW

P3TEXT

P3

P3RAW

WAIT_CLASS_ID

WAIT_CLASS#

WAIT_CLASS

WAIT_TIME

SECONDS_IN_WAIT

STATE

WAIT_TIME_MICRO

TIME_REMAINING_MICRO

TIME_SINCE_LAST_WAIT_MICRO

SERVICE_NAME

SQL_TRACE

SQL_TRACE_WAITS

SQL_TRACE_BINDS

SQL_TRACE_PLAN_STATS

SESSION_EDITION_ID

CREATOR_ADDR

CREATOR_SERIAL#

2

C000000671152DE8

977

8286

3.34E+08

C00000066C9B7890

31

VGOPMK

3

2.147E+09

C0000006617696A8

ACTIVE

DEDICATED

0

SYS

oracle

7462

cpda02

pts/4

ude@cpda02 (TNS V1-V3)

USER

C00000062065A8B0

2408420324

gn74qsy7sv4z4

0

2012-4-20 18:33:09

33555219

C00000061AC098D0

2133220919

d51ra7dzkcrjr

0

2012-4-20 18:33:09

33589034

7775

12

ude@cpda02 (TNS V1-V3)

2825815357

0

179709031

-1

0

0

0

###############

1804723

NO

NONE

NONE

NO

DISABLED

ENABLED

ENABLED

0

UNKNOWN

63966

284

PX Deq Credit: send blkd

sleeptime/senderid

2.69E+08

0000000010010E0F

passes

7E+05

00000000000A6F3E

qref

1.38351E+19

C000000612BFFB10

2723168908

6

Idle

0

0

WAITING

481809

2018191

0

SYS$USERS

DISABLED

FALSE

FALSE

FIRST EXEC

100

C00000066C9B7890

174

[ 本帖最后由 qq33649394 于 2012-5-11 16:05 编辑 ]