OraFAQ Forum: Server Administration » find out export process

Home » RDBMS Server » Server Administration » find out export process

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find out export process [message #171501]

Wed, 10 May 2006 04:55

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

hi all

as a DBA i want to monitor export process which is going on in ohter's session and i dont know in which session.

i want to find out that who is making export.
i have tried with the v$longops view but it shows nothing.
how can i do that????

thanks in advance

Report message to a moderator

Re: find out export process [message #171513 is a reply to message #171501]

Wed, 10 May 2006 05:18

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

hey amit,
This might not help you out with your problem but i just wanted to know that how did you get your first job as a DBA as i wish the same. How did you start off your oracle career?

Thanks and regards
Yasir hashmi

Report message to a moderator

Re: find out export process [message #171640 is a reply to message #171501]

Wed, 10 May 2006 15:58

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

do a ps -ef | grep exp from the server .. it will give u the pid ..basing on which you can identify the session associated with it ..
-Sai

Report message to a moderator

Re: find out export process [message #171642 is a reply to message #171501]

Wed, 10 May 2006 16:37

ebrian
Messages: 2794
Registered: April 2006

Senior Member

select username, pid, program from v$process;

To get the associated username and pid for the export process. Look for exp.exe on Windows or exp on UNIX under the program column.

Report message to a moderator

Re: find out export process [message #171714 is a reply to message #171501]

Thu, 11 May 2006 03:48

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

Thanks for the response

i got it. its working on linux. but i want to know how can i identify processes (PID) on windows.

Thanks again.

Report message to a moderator

Re: find out export process [message #171745 is a reply to message #171714]

Thu, 11 May 2006 05:51

ebrian
Messages: 2794
Registered: April 2006

Senior Member

To get the pid for the exp.exe process on Windows you could simple run:

tasklist | findstr "exp.exe"
OR
tasklist /fi "imagename eq exp.exe"

[Updated on: Thu, 11 May 2006 05:58]

Report message to a moderator

Previous Topic:	how to calculate free tablespace ?
Next Topic:	commit work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:30:37 CDT 2024