| Monitor imports... [message #121371] |
Fri, 27 May 2005 16:35  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
Hi,
We r running a import that would run for days (~2 days)
i need to monitor the import process.
i use the query that i found at
http://www.orafaq.com/faq/import_export
for monitoring.
my qn is
is it possible to do the monitoring process via a cron job and send me mails regarding the update process every hr.
how do i do it..
code wud b appreciated..
thanx in advance
bala.
|
|
|
|
| Re: Monitor imports... [message #121402 is a reply to message #121371] |
Sat, 28 May 2005 07:30  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>2 days to import~!.
Is this import really worthy? ( if the idea is to duplicate the data, thing about using RMAN).
did you try to improve the process?
( more sort_area_size, import the data only and recreate the indexes manually in parallel,increasing buffers )
To monitor , the same policy applies.
wrap the sql into a cronjob and execute it every 1 hour.
or
just email the log file for import job every 1 hour.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
