Oracle Database Discussions

in a terminal session type:

ps -ef |grep exp

Thanks Donald. This is what I got

vincent 165802 224414 1 10:51:08 pts/2 0:00 grep exp
vincent 191624 96976 0 05:05:00 - 0:02 exp vincent/passphr query="whe
re state in ('MD','CA','WI')" file=/home/vg23/fida_label_9i.dmp tables=vincent.fida_label log=/home/vg23/9I/LOGS
/fida_label_exp.log statistics=NONE

Does this indicate it is still running ?

Will the export parameter statistics=NONE by any chance slow down the export ?

Yes, that indicates your export is still running.

Be careful of what you post in the forums: vincent 191624 96976 0 05:05:00 - 0:02 exp vincent/passphr query="whe
re state in ('MD','CA','WI')" file=/home/vg23/fida_label_9i.dmp tables=vincent.fida_label log=/home/vg23/9I/LOGS
/fida_label_exp.log statistics=NONE

The parameter statistics=NONE shouldn't effect the speed. Other ways to tell if the import is running would be to add the parameter feedback=10000 - this will display a . on the screen for every 10000 rows exported. You could also look at what's getting written to the log by issuing: tail /home/vg23/9I/LOGS/fida_label_exp.log. 5 hours seems unusally long for a million row export.

QUOTE: Thanks Donald. This is what I got

vincent 165802 224414 1 10:51:08 pts/2 0:00 grep exp
vincent 191624 96976 0 05:05:00 - 0:02 exp XXXXX/XXXXX query="where state in ('MD','CA','WI')" file=/home/vg23/fida_label_9i.dmp tables=vincent.fida_label log=/home/vg23/9I/LOGS
/fida_label_exp.log statistics=NONE

Does this indicate it is still running ?

Yes, the export is still running, however the process may have hung (note the 0 after 96976 which means zero cpu this does not mean it has hung just maybe).

You can check it so:

SIGEP2_PROD>r
  1* select username, program from v$session

USERNAME                       PROGRAM
------------------------------ --------------------------
                               ORACLE.EXE
                               ORACLE.EXE
                               ORACLE.EXE
                               ORACLE.EXE
                               ORACLE.EXE
                               ORACLE.EXE
                               ORACLE.EXE
SYS                            sqlplusw.exe
MIC1_001                       sqlplus.exe
DATA_ENTRY_P                   EXP.EXE

10 rows selected.

SIGEP2_PROD>

DATA_ENTRY_P EXP.EXE

Joel Pérez
http://otn.oracle.com/experts

The view used before was this:

V$SESSION
This view lists session information for each current session.

....
USERNAME
VARCHAR2(30)
Oracle username
....
PROGRAM
VARCHAR2(48)
Operating system program name
.....

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch3171.htm#1122127

Joel Pérez
http://otn.oracle.com/experts

If you are using the parameter 'log',you could use the operating system's 'tail' command to see the last few lines of the log file.

Thank a lot for the ideas Al, Donald, Joel and 355099.
I certainly feel comfortable now with the provided suggestions and looking forward to run the same tomorrrow early morning again. Today, all I did was ask the sysadmin to kill the process exp, because the processing time of the file (.dmp) time was past and wouldn't have made sense if this has kept running. And moreover this export is a cron job, I guess I will have to monitor it while it runs at midnight. Will let you know if I have any problems again.

Ok 404045 Go ahead!

Joel Pérez