Host concurrent program whom call ar60runb
Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Re: Host concurrent program whom call ar60runb
Hi Hemant, Many thanks. You are right. It's all about the variable environments. Now it works fine. Have nice day. Ben --- Hemant K Chitale [EMAIL PROTECTED] wrote: Does your TEST.prog include the environment for ar60runb ? If it runs as a shell script, does it have $ORACLE_HOME, and $PATH setup correctly ? Hemant At 07:09 AM 21-01-04 -0800, you wrote: Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
RE: Reporting database
Hi Faan, Thanks Faan for this effectively critical point. Like you I have faced this problem after applying some patch (FND patches on 11.5.7) and since I have standby database as emergency environment. It was big problem. I wrote a scripts to detect such events and I read some metalink docs that said Oracle will leave these unrecoverable options on their future patches. Have nice day, Kader --- Faan DeSwardt [EMAIL PROTECTED] wrote: Kader, Just a word of caution when considering options. Keep an eye on all the Apps objects that have NOLOGGING set. Last time I checked there were over a thousand of those which were mostly indexes but there are some tables among them. These are a real pain when using redo log refreshing/updating techniques like Quest's SharePlex and Dataguard. Definitely check out Metalink notes 216212.1 and 216211.1 when considering and implementing this refreshing technique. Good Luck and may the Force be with you! -f -Original Message- Sent: Wednesday, December 03, 2003 1:45 PM To: Multiple recipients of list ORACLE-L At 06:24 3-12-03 -0800, you wrote: Hi Listers, I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i. I'm concerned about the strategies that have a minimum impact on the overload of production database. Could you please give me your advise and experience. Any input well be very appreciated. Hi Kader, What do you mean with ETL? Is your reporting database a DWH, and are you considering unload from production and ETL into it? Or do you just need an exact copy of your production database? What frequency should it be updated? Daily, Weekly, real-time? For some of these options Data Guard might be a solution, for others not. For a daily update you can create a (physical) standby database and put it in read-only mode. You can query along, transactions get forwarded but not processed in the meantime. Every midnight, for instance, you switch the standby from R/O to Managed Recovery mode, and it will 'synchronise' using the redologs received since the last synchronisation. After synchronisation put it back into R/O mode, and you can query all day long. During synchronisation the database isn't available for reporting. Data Guard comes for free with your Oracle Licence. However, as discussed in an earlier thread on this list, you have to pay for the standby server, unless , AFAIK, you're paying according to the named-user-plus model. It will give you the lowest possible overhead on your production database, except from using non-oracle storage level options like mirroring disks and detach them every n hours. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Faan DeSwardt 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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
Reporting database
Hi Listers, I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i. I'm concerned about the strategies that have a minimum impact on the overload of production database. Could you please give me your advise and experience. Any input well be very appreciated. Have nice day, Kader __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Embaded transactions
Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Re: RE: Embedded transactions
Thanks guys for your inputs, I just want include a procedure (which include commit) into my package testing. Have nice a day, Kader --- [EMAIL PROTECTED] wrote: if you need to 'rollback' everything, then you should make it one transaction. You can add savepoints and rollback to: if you want to limit it that way. commit means complete. You should not commit unless you are sure you may not want to rollback. why are you committing in the inner transaction? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/09/16 Tue PM 12:29:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 - RE: Embedded transactions no. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, September 16, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have two transactions one embedded into another. The inner transaction have commit. Is it possible to rollback all (the inner and the outer) transaction if the outer one fail? Thank you for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Re: rename data file on standby database
Many thanks Louis for your input, Have nice day, Kader --- Jose Luis Delgado [EMAIL PROTECTED] wrote: Hi Kader... you do not need to do the same on the standby database... That logical changes are reflected automatically... The only thing is that your physical datafile remain as initially, but your controlfile has the changes. Was I clear? note that the only changes that you need to do at your standby database is when you add tablespaces/datafiles to your primary database, then you need to add them to your standby database. HTH JL --- Kader Ben [EMAIL PROTECTED] wrote: Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recovering incoming archives without any error but the data file renamed on the primary database is on the its original location on the standby database. Many thanks for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
rename data file on standby database
Hi Listers, I have standby database working fine (until now!). I have renamed one datafile on the primary database and I'm wondering if I have to do the same thing on the standby database to reflect the structure change. I have renamed the file yesterday and the standby database stil recovering incoming archives without any error but the data file renamed on the primary database is on the its original location on the standby database. Many thanks for your help, Kader __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Gather stats on 11i
Hi Listers, I'm using concurrent program of 11i (Oracle financials) on 9i RAC to gather schemas stats but the program never finished because generates deadlock on several tables. I have to kill many sessions to allow program to finish. Did same one experienced this problem? Thank you for your input. Ben __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Re: Fixed_date and dbms_job
Thnks Michal for your input, All seems right for me: SQL show parameter job NAME TYPEVALUE --- -- job_queue_interval integer 90 job_queue_processes integer 2 Michal I cannot put next_date to 'sysdate+1/86400' because this date will never be reached since I use ALTER SYSTEM SET FIXED_DATE = sysdate+deta Where the delta is the incremental time to simulate pseudo-time in the future. And the main objective of the procedure to do. Ben --- Michal Zaschke [EMAIL PROTECTED] wrote: Hi, 1) check job_queue_processes and job_queue_interval parameters in your init.ora file 2) have a commit after dbms_job.submit 3) if you want the procedure to be executed every second, then the next date should be 'sysdate+1/86400' = dbms_job.submit(:job_num, 'myprocedure;',sysdate, 'sysdate+1/86400'); Mike Kader Ben wrote: Hi Listers, I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, 'myprocedure;', sysdate, 'sysdate'); the dba_jobs table show me the right interval un next_date: BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC INTERVAL N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate And the sysdate is: 13-JUN-2003 17:50:06 But the job never execute. Could you please give me hint how to resolve this problem? Thanks you, Ben __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Ing. Michal Zaschke DB Administrator Sokolovska uhelna, a.s. tel.: +420 352 465417 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michal Zaschke 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). __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
RE: Fixed_date and dbms_job
Thanks Jacques, Yes I did: VARIABLE jobno number; BEGIN DBMS_JOB.SUBMIT(:jobno, 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate', true); commit; end; / Ben --- Jacques Kilchoer [EMAIL PROTECTED] wrote: After calling dbms_job.submit, did you issue a commit? -Original Message- From: Kader Ben [mailto:[EMAIL PROTECTED] I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, 'myprocedure;', sysdate, 'sysdate'); the dba_jobs table show me the right interval un next_date: BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC INTERVAL N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate And the sysdate is: 13-JUN-2003 17:50:06 But the job never execute. __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Re: Fixed_date and dbms_job
Many thanks Jared, Definitely I think this is only one away to resolve my problem. Have nice week end, Ben --- [EMAIL PROTECTED] wrote: You can't call a job every second via DBMS_JOB. I believe that at best the resolution is 1 minute. You could just open another session and run something like this: declare fd varchar2(50) := '01/01/2010 00:00:00'; v_sql varchar2(200); begin loop v_sql := 'alter system set fixed_date = ' || fd || ''; execute immediate v_sql; dbms_lock.sleep(1); fd := to_char(to_date(fd,'mm/dd/ hh24:mi:ss') + 1/86400, 'mm/dd/ hh24:mi:ss'); end loop; end; / Jared Kader Ben [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/13/2003 03:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Fixed_date and dbms_job Hi Listers, I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, 'myprocedure;', sysdate, 'sysdate'); the dba_jobs table show me the right interval un next_date: BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC INTERVAL N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate And the sysdate is: 13-JUN-2003 17:50:06 But the job never execute. Could you please give me hint how to resolve this problem? Thanks you, Ben __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Fixed_date and dbms_job
Hi Listers, I'm simulating the date in future with fixed_date. I wrote procedure to be called every seconde through dbms_job to increment the fixed_date. I did that dbms_job.submit(:job_num, 'myprocedure;', sysdate, 'sysdate'); the dba_jobs table show me the right interval un next_date: BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC INTERVAL N 13-JUN-03 00:00:00 13-JUN-03 17:50:06 sysdate And the sysdate is: 13-JUN-2003 17:50:06 But the job never execute. Could you please give me hint how to resolve this problem? Thanks you, Ben __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
Performance issue
Hi Lisetrs, I have enough free memory from shared_pool_size and I run stats every week but the BD still shows up the low hit ratio and some times the later full down to 15%! Here is some informations: Obj mem: 79503437 bytes Shared sql: 23852410 bytes Cursors: 244875 bytes Free memory: 204512816 bytes (195.04MB) Shared pool utilization (total): 124320866 bytes (118.56MB) Shared pool allocation (actual): 3 bytes (286.1MB) Percentage Utilized: 41% Hit Ratio : 74.2249062 I appreciate to give me some guidelines. Thanks, Ben __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
fnd_global user_id
Hi Listers, I'm running concurrent program to create user (that's call fnd_user_pkg.CreateUser procedure) on 11i but the program fails because the fnd_global.user_id return -1! Can someone help me how resolve this problem? Thanks you so much, Ben __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
RE: Monitoring Tool Evaluation methodology
Hi Sean, Me too I'm interested into your evaluation methodology. Thanks, Kader --- [EMAIL PROTECTED] wrote: Hello Sean, Would you mind sending me your evaluation? I'm in the process of performing a tool evaluation also, and this material would be invaluable. Thanks, Todd O'Neill, Sean [EMAIL PROTECTED] on 11/29/2002 05:34:00 AM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi there, If you are interested I can send you a word document which I used to select and evaluate an Oracle monitoring tool solution which might be useful for adapting to your needs. We're an NT/W2K site. BTW, we choose Quest I/Watch as our solution. Did not come across eHurkha product during our evaluation. HTH, - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Subject: Monitoring Tool Evaluation methodology We are evaluating a monitoring Tool (eGurkha) for Unix/NT/Oracle monitoring What features should be Looked into while Evaluating ? Are there any Best practices for doing this kind of Evaluation ? Any Comments on this tool in particular by any who might have used this tool ? etc.. This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
Cursor column name
Hi listers, Can someone tell me how to get column's name using cursor. Thanks in advance, Kader __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
Re: Parallel Server Option = TRUE
Hi Pablo, There is no known problem if you have installed OPS even thought actually you don't use it, there is also no impact on DML_LOCK if your data are accessed by only one instance. Comment out PARALLEL_SERVER if is in your parameter file. HTH Kader --- Pablo Rodriguez [EMAIL PROTECTED] wrote: Hope someone can help me with this one. I have just realized that PARALLEL SERVER = TRUE in v$option and I don't have an OPS instalation. I've installed this Oracle code in a Unix Cluster that's why Oracle has installed this option automatically, I assume. Can anyone tell me if there can be any problems in the instance because of the PARALLEL SERVER = TRUE and using a single instance database? I don't know may be a problem with the DML_LOCKS or a problem with cursors or with the shared pool, etc... thanks ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Pablo=20Rodriguez?= 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). __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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).
Failover
Hi All, I have 11i running on OPS database with two instances. I assigned each instance to group of responsibilities but I have no idea how to configure the FAILOVER. If one instance goes down I want the user who has assigned this instance can transparently connect to the other instance. I'll appreciate any suggestion. Thank you, Kader __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] 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: [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).
Re: Moving Autit Tables
Hi Chris, go to the following link you'll find a paper about that: http://www.oracle.com/oramag/oracle/99-Nov/index.html?69dbajj.html kader --- Guidry, Chris [EMAIL PROTECTED] wrote: Hi All, There has been some discussion in the past regarding moving the audit tables out of the SYSTEM table space to avoid fragmentation. Is this a good idea and if so does any have a procedure for doing so? Are there any problems to watch out for? O7345 - WinNT - RAID 0+1 -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: [EMAIL PROTECTED] 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: [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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] 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: [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).
export tables from sql Server to Oracle
Hi listers, Can someone tell me how import tables from SQLServer to Oracle. Thanks for your help, Ben __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] 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: [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).
migrate from 8i to 9i
Hi friends, I need your advise on the following question. I have DB on 8i and I want create new one on another machine with 9i. I thought do the following steps: 1 - Install oracle 9i on a new machine 2 - make full export of the 8i DB 3 - import it on the new one (9i) So before I proceed I need your input. Am I correct with these steps? There is something wrong? Many thanks for you, Kader __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] 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: [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).