Catherine,
No, SNPs, per-se don't degrade the performance. What would be at issue is
what job you are actually running. Treat it just like any user session connecting
to the database and firing off the procedure/package/sql-statements defined
in the job.
I am using DBMS_JOB in 8.1.7.2 and 8.1.7.3 instances. The only problem
I've had is with a job to sync an Intermedia Index in Oracle iFS through DBMS_JOB
-- there seems to be a memory leak [this is 8.1.7.3 on Solaris]. I had a TAR
open for a couple of weeks. The analyst agreed with me that the issue would
be more of an Intermedia Index problem rather than DBMS_JOB. Once the
list of docs pending indexing (or rather index-syncing) grew too large, the
SNP process would crash frequently. I changed the Index DEFAULT_MEMORY
and MAX_MEMORY parameters and began running optimize frequently
on the Intermedia Index and the DBMS_JOB stopped dying -- but it's process
size kept growing slowly. I know manually kill the SNP process in that
particular instance every few days [Oracle Development, as I had a Bug
logged for this issue, wanted me to upgrade to 8.1.7.4 and try to simulate
the issue. I didn't have time and the resources to clone and upgrade my 35GB production
database to 8.1.7.4 and left it at that. The Support analyst agreed that
as my "workaround" [increasing the Intermedia Index Memory parameters
and periodically killing the SNP process] was working he could close the
TAR and Bug.
Hemant
At 05:04 PM 10-12-02 -0800, you wrote:
Hi Hemant, Thanks for the tips.Does anyone know whether SNP process .ie. DBMS_JOB will degrade the database performance ? Please advise. Thanks. Regds, New Bee This communication (including any attachment) is meant only for the recipient(s) named above and may contain confidential or legally privileged information. If you are not an intended recipient, this communication has been sent to you in error and you must delete all copies of this communication from your computer system and notify the sender immediately by reply email. Unauthorised use, disclosure, dissemination, distribution, retention, copying or reliance on this communication is prohibited and may attract civil and/or criminal penalties. Thank you. -----Original Message----- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 11:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Daily job to populate table in another database See Note #1068369.6 on MetaLink. Hemant At 01:28 AM 10-12-02 -0800, you wrote: >Hi Gurus, > >If you need to copy data (after some manipulations) from database A to >another table in database B, how do you achieve that ? >Our current practice is to use crontab (schedule daily job) and sqlplus >(procedure to copy the data over to another database via dblink). > >Do you think it's more efficient to use DBMS_JOB ? Can DBMS_JOB call the >procedure at the same time daily ? Any sample? Please advise. Thanks. > >Regds, >new bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
