| daily export hanging [message #53609] |
Tue, 01 October 2002 12:43  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Hello,
We have a oracle 7.3.4 database on solaris 8. Sometimes the daily exports hang. We do a daily export at 11pm. Usually it takes about 5 - 10 minutes. But sometimes it hangs. Is there a possibility that the export will hang, if some process is pulling/updating a lot of data in the database? I set a trace for sometime, and I couldn't find anything suspicious at all. Any help will be great.
Thanks.
|
|
|
|
| Re: daily export hanging [message #53614 is a reply to message #53609] |
Tue, 01 October 2002 15:15  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Check your parameter file. If it has consistent=y and there is a high activity in the database, your export might hang for a while, but not so long.
Since you are on Solaris OS, when the export is running, do:
$ps -ef | grep exp
get the exp process PID, and then run:
$truss -p PID
You should be able to see what is happening with the process on the kernel level.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: daily export hanging [message #53620 is a reply to message #53614] |
Tue, 01 October 2002 15:49 |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Is there any way to identify which user or machine has submitted the job (by using the session id or something? Because when we try to shutdown the databsae for cold backup , it looks like its waiting for something to complete:
Dump file /orcle/archbop/bop_ora_11307.trc
Oracle7 Server Release 7.3.4.4.0 - Production
With the distributed option
PL/SQL Release 2.3.4.4.0 - Production
ORACLE_HOME = /opt/Oracle_7.3.4
System name: SunOS
Node name: dbssrv00
Release: 5.8
Version: Generic_108528-15
Machine: sun4u
Instance name: bop
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 11307, image: oraclebop
*** SESSION ID:(46.303) 2002.09.28.03.07.11.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.12.16.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.17.21.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.22.26.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.27.31.000
SHUTDOWN: waiting for active calls to complete.
*** 2002.09.28.03.32.36.000
SHUTDOWN: waiting for active calls to complete.
:
:
:
:
:
:
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
