/* Formatted on 6/4/2014 2:04:42 PM (QP5 v5.115.810.9015) */
SELECT a.terminal, a.osuser, a.username
FROM v$session a, v$transaction b
WHERE b.ses_addr = a.saddr AND a.audsid <> USERENV ('SESSIONID');
TERMINAL OSUSER USERNAME
------------------------------ ------------------------------ --------
applbkp APPS
SELECT a.terminal, a.osuser, a.username
FROM v$session a, v$transaction b
WHERE b.ses_addr = a.saddr AND a.audsid <> USERENV ('SESSIONID');
TERMINAL OSUSER USERNAME
------------------------------ ------------------------------ --------
applbkp APPS
virtualnuggets offering oracle dba online training,corporate training services.
ReplyDeleteOracle database 10g offers the new Data pump feature, a server-side infrastructure for fast data movement between Oracle databases. The data pump feature enables DBAs to transfer large amounts of data and metadata at very high speeds compared with the older export/import technology.
Oracle Data Pump feature enables very high-speed movement of data and metadata from one database to another. This feature is the basis for Oracle’s new data movement utilities, Data Pump Export and Data Pump Import.