RE: Daily job to populate table in another database

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:hkchital_at_singnet.com.sg]
> 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: clchan_at_nie.edu.sg
>
>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: 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).

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: hkchital_at_singnet.com.sg

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: 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).