| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Long time for Batch Processing
Satish,
Just a thought...
Do you have any triggers on these tables that gets fired under certain conditions?
Prakash
-----Original Message-----
Sent: Friday, April 19, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
Hello All,
We are observing a strange problem for a couple of days. One of our batch
process which usually takes about 30 minutes to complete sometimes takes
upto 8 hours to complete and this varies even though the batch load is
almost the same everynight.
Some details on the job
The job is a simple Oracle replication process of about 20-25 tables.
Put a trace on the session during the time it spent a lot of time and
observed that the inserts into our table took a very long time. No waits
were observed. The tkprof report shows the CPU time = Elapsed Time.
One other thing observed was the RBS usage jumped up to around 8 Gb.The
table size is only 700M, add about 5 indexes to it, still does not explain
why RBS usage should be so high. On normal days i.e. when it gets processed
in 30 mts., the RBS usage is only about 100M.
After the job is done, the database size increase is only about 100M, so wonder what goes into the RBS.
No transactions in the database at the time the batch runs. Behaviour is not consistent, some days are good , others bad. Did complete network testing, no problems, server tests, disk transfer tests , everythings seems fine. The DB is an 8.17 database.
Any idea folks how to proceed.
Thanks
Satish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: BALA,PRAKASH (Non-HP-USA,ex1)
INET: prakash_bala_at_non.hp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 19 2002 - 16:38:49 CDT
 |
 |