DBMS_JOB problem
I have a job: DECLARE myjob NUMBER; BEGIN dbms_job.submit(myjob, 'FWHI.Fwh_Gen_Txt.GENALLFILES ( ''||@||'', 1 );', SYSDATE, 'sysdate+10*60/24*60*60'); commit; END ; PL/SQL procedure successfully completed the job_queue_processes 4 job_queue_interval 60 If I force the execution is generating the right number of txt files, 74, if I wait to be triggered it generates just 8 files and it stops. Why? Ciprian Maftei -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mac 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: Oracle SAN Experiences?
Guess I wasn't clear with my earlier post. Here is the information from the SA's when confronted with the results of some I/O tests. Configuration on system 1 ( poor IO performance ): Large filesystem -- device driver -- hardware controller -- SAN switch -- SAN Server Configuration on system 2 ( better IO performance ): filesystem1 -- device driver -- | filesystem2 -- device driver -- hardware controller -- SAN switch -- SAN Server | filesystem3 -- device driver -- In configuration 1 the system was bottlenecked in the device driver, the SAN hardware was running fine. In configuration 2 the system was able to spread IO over multiple device drivers and gave better performance. Hope this clears things up. Might have been a deficiency in the volume manager software. Point I was trying to make was that when you switch to SAN storage you still have to be aware of the limitations of the host systems IO subsystems and look at tuning / configuration on both the SAN hardware and your host system. -Original Message- Sent: Saturday, November 09, 2002 3:19 PM To: Multiple recipients of list ORACLE-L It would be extremely surprising if there was a static relationship between the number of file-systems and the number of I/O controllers used by each. Sounds more like a mis-configuration, a mis-interpretation of the symptoms, or (most likely) a cover-up story to redirect blame. There is no awareness of controllers or other devices (other than logical volumes a.k.a. raw devices) in file-systems. This is a configuration issue for the SAN controller hardware/firmware/software, although I believe that the Veritas VxVM software can perform dynamic multi-pathing, so it could be performed at the LVM (logical volume manager) layer as well... Load-balancing and failover amongst I/O controller devices is common in SAN environments. It doesn't make sense to allow $200.00 controller cards to be either a bottleneck or a single-point-of-failure in an I/O subsystem costing millions of dollars... - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, November 09, 2002 12:33 PM One observation I have made at sites running SAN storage for Oracle is a tendency for the SA's to present the disk to the database server as a small number of large filesystems. On some OS platforms this can create a bottleneck on the host as all data to this large filesystem is routed through a single device driver. Solution is to present more filesystems and therefore have more channels from the OS perspective to access the disk. -Original Message- Sent: Friday, November 08, 2002 6:59 AM To: Multiple recipients of list ORACLE-L The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and Id like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (its possible to use smaller disks in the SAN) -Prove it! After reading the Sane SAN article and a case study about Volvo implementing a SAN, I believe its possible to have a great Oracle/SAN implementation if its setup correctly and tuned. Other resources that you can Google are Using SVA SnapShot with Oracle, Performance Benchmark LSI Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Brooks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To
ORACLE QUERY
Hi All, I want to know about one query. I have two views and I want to get the sum of count of two view ex I have a query like select record_identifier from records where rownum(40-(select count(*) from customer_view+select count(*) from unit_view)); But this is not working in oracle. Is there any other way to do this without writing a function -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet)
sqlplus ~no~output
Title: sqlplus ~no~output for the sake of select * against a pinned table I want row output totally turned off. in the past I thought set serveroutput off, set termout off, set pagesize 0 was sufficient, but its still dumping row data on me. What have I forgotten ? TIA
RE: SQL loader
Hello Nirmal, The FILLER command is available in sqlloader to allow you to miss a field out something like LOAD (field 1 ... field2 ... dum_rec FILLER, field3 ) may work but I am not sure that this will work in 7.3 of Oracle as I think FILLER came out in 8.0x However an easy way ( I was going to say the easiest but I figured someone would send in a 1 character script to achieve the same thing) is to use awk to concatanate the fields as in the following example cat j.txt a ccc cat j.txt | awk '{print $1,$2 $3,$4 }' a ccc I think that gives you what you want and you just use your loader routine to load the amended data HTH John -Original Message- Sent: 10 November 2002 07:33 To: Multiple recipients of list ORACLE-L Hi list, LOAD DATA INFILE 'c:\temp\file2.csv' APPEND INTO TABLE dc_temp1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ( name, old_po_box, dn, gsm, nregc, cr_no, new_po_box , remark, ncli) The above is my control file for loading data. i need to refer the two columns of data from the datafile 'c:\temp\file2.csv' should go into one column(remark) of my table. Oracle7.3.1. Any ideas pls. Thanks. Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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.com -- 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).
Re: Adding more space to server
Title: Adding more space to server Is the server dedicated to Oracle data files or you have more data in it. We have for each server a lot of data that was loaded in the database + a daily export. I saved a lot of space by compressing the folders for the data and the export. Yechiel AdarMehish - Original Message - From: Hussain Ahmed Qadri To: Multiple recipients of list ORACLE-L Sent: Sunday, November 10, 2002 7:03 AM Subject: Adding more space to server Hi all, We are running out of space on our server and I was going to add another hard disk to it. I had thought about somewhat crude but easy way to go about it. Since I can afford to shutdown my database for a couple of hours tomorrow, I thought that I would shutdown the database, move some datafiles to other partitions, redefine the partitions as to increase their size (WinNT 4 and Oracle 8i) and then move back the datafiles and then start the database. This way I would have more space to accommodate any increase in size of the datafiles and not worry about changing any of the database complexities (plus more space for the archives generated, as the database is in archive mode). Neither the control file nor any of the parameters would have to be changed as no change in location took place. Is there anything wrong in this method? What could be the other options, if any? Anything else that I need to keep in mind? Thanks and regards, Hussain Ahmed Qadri DBA SKMCHRC
Re: Changing column format
You do not need to change the primary key unless different user names can have the same userid. Just add a unique + not null constraint on the user name column. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 10:33 PM I create a table to store user account information and set userid column to be primary key. I now want to set username to be primary key instead of userid, how do I change it? There are couple hundreds of records in table. Please advise. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M 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.com -- Author: Yechiel Adar 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: sqlplus ~no~output
Markham, Richard wrote: for the sake of select * against a pinned table I want row output totally turned off. in the past I thought set serveroutput off, set termout off, set pagesize 0 was sufficient, but its still dumping row data on me. What have I forgotten ? TIA spool. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: ORACLE QUERY
select record_identifier from records where rownum( select 40-count(*) from (select1 from customer_view union all select2 from unit_view) ); Just a thought, HTH. Nirmal. -Original Message-From: Savita [mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 11:13 AMTo: Multiple recipients of list ORACLE-LSubject: ORACLE QUERYHi All, I want to know about one query. I have two views and I want to get the sum of count of two view ex I have a query like select record_identifier from records where rownum(40-(select count(*) from customer_view+select count(*) from unit_view)); But this is not working in oracle. Is there any other way to do this without writing a function -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet)
Re: Oracle 10i new releases
I used Oracle V3 on an old Unisys x86-based server. When I said that to a local Oracle representative he did not believe that. So, did anyone use V2 on this list? If so do you still have the tapes and is there a way to revive this beast on a PDP-11 emulator? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:03 AM i did use some version 5 on 386 PC :) joe John Kanagaraj wrote: Move over Joe and Tim. I used 5.1.17 on a propreitary *nix box way back in '89! I do know there are a few on this list that do go back farther than that! John -Original Message- From: Johnston, Tim [mailto:TJohnston;quallaby.com] Sent: Friday, November 08, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 10i new releases Oh... I'm sure they are many other who back farther then that... But, I do remember 6.0.36... As a matter of fact it was 6.0.36.1.53 on IBM VM... Ah the memories... Tim -Original Message- Sent: Friday, November 08, 2002 4:04 PM To: Multiple recipients of list ORACLE-L anyone remember the 6 days, 6.0.36 on sunos :) joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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.com -- Author: Nicolai Tufar 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).
Oracle daylight saving
How does Oracle handle daylight saving time changes. presumably it gets its time from the OS? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Oracle daylight saving
John Yep, Oracle gets whatever the server has. Under Oracle9i, the new time zone features offer more possibilities to consider. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 6:59 AM To: Multiple recipients of list ORACLE-L How does Oracle handle daylight saving time changes. presumably it gets its time from the OS? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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.com -- Author: DENNIS WILLIAMS 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: Oracle 10i new releases
Wow! I used Version 4 5 under Dos(286 and 386) and Ver 5 under Xenix with 386(16 Mhz). All with 4MB ram...Basically we developed Fianacial Accounting package using Sqlplus, Sqlforms and sql Report(rpt). It was 1988. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 11 Nov 2002 02:58:25 -0800 I used Oracle V3 on an old Unisys x86-based server. When I said that to a local Oracle representative he did not believe that. So, did anyone use V2 on this list? If so do you still have the tapes and is there a way to revive this beast on a PDP-11 emulator? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:03 AM i did use some version 5 on 386 PC :) joe John Kanagaraj wrote: Move over Joe and Tim. I used 5.1.17 on a propreitary *nix box way back in '89! I do know there are a few on this list that do go back farther than that! John -Original Message- From: Johnston, Tim [mailto:TJohnston;quallaby.com] Sent: Friday, November 08, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 10i new releases Oh... I'm sure they are many other who back farther then that... But, I do remember 6.0.36... As a matter of fact it was 6.0.36.1.53 on IBM VM... Ah the memories... Tim -Original Message- Sent: Friday, November 08, 2002 4:04 PM To: Multiple recipients of list ORACLE-L anyone remember the 6 days, 6.0.36 on sunos :) joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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.com -- Author: Nicolai Tufar 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: M Rafiq 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: Oracle 10i new releases
I remember Oracle 4 on 3 5.25 floppies on a PC/XT with 640kb RAM (who would ever need more then that?). It had UFI, RPT/RPF, IAP/IAG (no IAD) and a utility called oralink which was supposed to function like SQL*Net, but I couldn't get it to work. Oracle 5 was on a decent machine (mVAX 3900 with incredible 16M RAM) and VMS 4.7 (the last one with NULL.COM and NULL process). It was all happening in the late jurassic, anno domini 1988. -Original Message- From: MacGregor, Ian A. [mailto:ian;SLAC.Stanford.EDU] Sent: Friday, November 08, 2002 7:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 10i new releases Ha I remember Oracle 5 on VM. Ah the joys of minidisks. I started with Oracle on VMS in 1984, but I cannot recall the exact version. BI files, IOR, UFI, RPT and RPF, IAP and IAG when IAP was completely text driven. I was Dba'ing before there was SQL*NET. Back in those days one was the DBA, the developer etc. The advantage was one fixed one's own mistakes. Sometimes People query, How did you know what happened?, they think I'm a genius. Little do they know, they made the same blunder I did in 1986. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, November 08, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Oh... I'm sure they are many other who back farther then that... But, I do remember 6.0.36... As a matter of fact it was 6.0.36.1.53 on IBM VM... Ah the memories... Tim -Original Message- Sent: Friday, November 08, 2002 4:04 PM To: Multiple recipients of list ORACLE-L anyone remember the 6 days, 6.0.36 on sunos :) joe Mercadante, Thomas F wrote: Robert, I guess what you say makes sense. But why the need to move the release level from 8, to 8i, to 9i to 10i all within 5 years? Granted, there were huge improvements from 8 to 9i. I guess what I'm arguing for is - lets stay at 9i for awhile. There is nothing wrong with 9i release 1 thru 15. Are the new features that will be available in 10i really that radical that justifies a major release? Give the rest of us a chance to catch up to 9i. My feeling is that Oracle will get hurt sooner or later - people will just plain not move to the newer release, just to face migrating again in just a few months. Makes no sense to me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 08, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Is it that Oracle's business model is pushing these releases or is it the rapid pace of technology change and the demand of the user for features? The push to the web, XML, Java, and new feature requests (rename column, fk's , drop column, etc...). Then there is competition too that has to be considered. If Oracle doesn't keep up with the Joneses as it were, what kind of market share will it have 5 and 10 years down the line. So, in my opinion, Oracle really has no choice but to pursue the course that it is. I think they have learned some lessons down the road, and I'm willing to bet that 10.0.1 (or whatever) will be far more stable than 9.0.1 was. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Friday, November 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L does this bother anybody else as much as it bothers me? just what is Oracle's business model for pushing these release's out this fast? are there that many new features, or a market to capture, that justifies this? makes no sense to me. the shelf life of an oracle release is now about a year and a half. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 08, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Heard from Tom Kyte that 10i should be out by Dec'03. He also said that the code is already frozen and beta testing is going on. Prakash -Original Message- Sent: Thursday, November 07, 2002 14:09 To: Multiple recipients of list ORACLE-L The day we all finish upgrading our databases to 9i. Sunil Nookala DBA Dell Corp. -Original Message- Sent: Thursday, November 07, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: When will Oracle 10i be out?
In colloquial English, they are out of their @#$%! mind. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, November 08, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: When will Oracle 10i be out? I believe, in the manufacturing world, it's called "planned obselescence"
RE: ORACLE-Function problem
Had a similar problem recently where characterset on database differed than client. We had to add NLS_CHARSET.zip (or was it .jar?) to the CLASSPATH. - Babette Turner-Underwood -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of SavitaSent: Monday, November 11, 2002 2:33 AMTo: Multiple recipients of list ORACLE-LSubject: ORACLE-Function problemHi All, I have a problem executing the function in oracle through JDBC. I have written a select statement inside which I am calling a function. The query is something like select OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as CASE_MSG__OS_CASE_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUSTOMER_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUST_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID as CASE_MSG__OS_UNIT_ID, OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE, 'OS_1' as CASE_MSG__UPDATED_BY FROM OSP_CRM_EXCHANGE_CASE_VIEW WHERE ROWNUM lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2)) ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID); here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function. When I execute this query in command prompt Itis working fine,but when I use it insied a executeQueryStatement(query) in JDBC I am getting following error ORA-00911: invalid character I am not able to figure out how to modify this. Any help will be highly appriciated. -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet)
how to avoid mutating table error in triggers
Good day all, Have the following setup - Oracle 8.1.7.2 on solaris parent-child realtionship between 2 tables: table p1 has primary key pk1 table f1 has foreign key p1pk1 back to table p1. Table p1 also has a field haschild number(1), used to indicate if there are ANY child records in table f1. Any insert into table F1 sets the haschild field in the corresponding row in table P1 to 1 (true). Trying to write an on delete trigger for table f1 that will set that boolean to 0 when there are now more child rows. Came up with this: create or replace trigger nochildtrg after delete on f1 for each row declare tv_count number; begin select count(*) into tv_count from f1 where p1pk1 = :old.p1pk1; if tv_count = 0 then update p1 set haschild = 0 where pk1 = :old.old.p1pk1; end if; commit; end; / This plays right into the no-no's that produce the mutating table error on table f1 - selecting against it as part of a trigger. Does anyone have any kind of workaround? I could implement a counter trigger, that increments a count on the parent table for each new row in the child, and decrements the count for each deleted row, but I wanted to see if there was another way. thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill 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: Oracle SAN Experiences?
Title: The Sys A client site that I was supporting a while ago had big problems with their NAS. While doing Oracle backups to tape, the application would drop connections. In a SAN environment, there might also be similar problems. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David WagonerSent: Friday, November 08, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle SAN Experiences? The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and Id like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (its possible to use smaller disks in the SAN) -Prove it! After reading the Sane SAN article and a case study about Volvo implementing a SAN, I believe its possible to have a great Oracle/SAN implementation if its setup correctly and tuned. Other resources that you can Google are Using SVA SnapShot with Oracle, Performance Benchmark LSI Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA
RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS **CLOSED**
Thanks everyone. I did decide on CHOOSE. It seemed like the best choice considering most of our queries aren't run interactively through tools like SQL*Plus. In fact it should become an even better choice as our applications are becoming more and more browser based. ALL_ROWS also looked like it would be the best choice considering our batch reporting requirements. Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 04, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS Hi Mike, Your article was very good in describing RBO vs. CBO. I hope you don't mind me using it to help better describe why we're switching from RBO to CBO to my team. I forgot to mention this before, but you should also look at Tim Gorman's excellent paper on the CBO at http://www.evdbt.com - search in the library. On the other hand it didn't help me much in practical use of ALL_ROWS (CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the paper. Yes, but we can always discuss this here in the list :) The problem I have with the FIRST_ROWS is that _all_ queries would default to use this mode. While this may be good for a specific interactive query, it certainly would perform poorly for batch jobs, more so when the table joins larger tables. IMHO, you are better off leaving it to default to CHOOSE and control specific modes. This can be done via a variety of methods, including login triggers, Outlines, anf finally the code itself. Note: When leaving your web page I was notified that my IP address was captured. I didn't like that. My web page is served by Yahoo! Geocities, and I obtained that when it was free (and still is free). I suppose that they capture some info and do manipulate cookies. This is the first time, though that I have come across such a message. I will need to investigate further... Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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.com -- Author: Armstead, Michael A 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: Oracle SAN Experiences?
Babette - Sounds like a problem I wrestled with for a long time. Turns out that RMAN opens quite a few connections and the NAS isn't usually set up for that many connections. Of course, instead of an error message, it just hangs. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 9:29 AM To: Multiple recipients of list ORACLE-L A client site that I was supporting a while ago had big problems with their NAS. While doing Oracle backups to tape, the application would drop connections. In a SAN environment, there might also be similar problems. -Original Message- Sent: Friday, November 08, 2002 9:59 AM To: Multiple recipients of list ORACLE-L The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and I'd like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB - 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (it's possible to use smaller disks in the SAN) -Prove it! After reading the Sane SAN article and a case study about Volvo implementing a SAN, I believe it's possible to have a great Oracle/SAN implementation if it's setup correctly and tuned. Other resources that you can Google are Using SVA SnapShot with Oracle, Performance Benchmark LSI Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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).
Is nothing sacred? (Oracle vs The Experts)
So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I only said the Packers would be 12-4 this year -- I never said that they couldn't do better! WOO-HOO! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Join vs. Subselect
I'll leave it to others to explain why but it's sometimes faster to do an outer join with a not null: select whatever from table1, table2+ where table2.whatever is not null; I've had selects of that form run in seconds where the sub-select or the straight join form took hours. Carle, William TTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] (Bill), cc: ALCAS Subject: Join vs. Subselect wcarle @att.com Sent by: root 11/11/2002 11:23 AM Please respond to ORACLE-L Hi, Here is the situation. The application coded a query that looks like this: select * from table1 where objid in (select objid from table2); There is an index on objid in table 1 that isn't being used. An explain shows it is using this system view vw_nso_1 that is used to transform an IN subquery to a join. If you recode the query to: select a.* from table1 a, table2 b where a.objid = b.objid; Then it will use the index. My question is: shouldn't it use the index in both cases. I know the join is a better way to code it and I have told the application that, but I would think that the first way would use an index anyway. Ideas? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS 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.com -- Author: Thomas Day 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).
combine or not combine into one database?
Hi all, I would like to know any advantage and disadvantage to combine the following databases into one: Finance in Lawson HR in Lawson OEM repository and historical database Any comments are very appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
RE: Is nothing sacred? (Oracle vs The Experts)
Find Cary's paper about misunderstanding Oracle index internals. It spells out the % Of Rows Returned fallacy. The key issue is that Oracle does not read rows, it reads blocks. If 10% of the rows of interest are scattered among 95% of the blocks, is it better to index or use FTS? If 25% of the rows of interest are clustered in 5% of the blocks, an index is more attractive. There is also an excellent presentation 'How to Improve Performance with Full Table Scans' by Jeff Maresh that can be located on www.evdbt.com. Dan Fink -Original Message- Sent: Monday, November 11, 2002 9:58 AM To: Multiple recipients of list ORACLE-L So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I only said the Packers would be 12-4 this year -- I never said that they couldn't do better! WOO-HOO! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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.com -- Author: Fink, Dan 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: Is nothing sacred? (Oracle vs The Experts)
Well, besides the paper you found, Jonathan Lewis has a myths section with his site: http://www.jlcomp.demon.co.uk/myths.html Gaja also has a good myths article: http://www.quest-pipelines.com/newsletter-v3/0302_F.htm Rachel, weren't you doing a presentation on Oracle myths (or did you just put that in DBA 101)? Jeffery Stevenson Chief Databeast Slayer Medical Present Value, Inc. Austin, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:58 AM So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I only said the Packers would be 12-4 this year -- I never said that they couldn't do better! WOO-HOO! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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.com -- Author: Jeffery Stevenson 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).
NETWORK Performance how?
Hi I want to check network perforamce between app servers and DB servers. How to check ? Is netstat/tracert help or there is another command which could help to find out? Thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Is nothing sacred? (Oracle vs The Experts)
Marlene and I did exploding the myths a while back and Jeremiah Wilton did a myths presentation at OOW last year as well. Rachel --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Well, besides the paper you found, Jonathan Lewis has a myths section with his site: http://www.jlcomp.demon.co.uk/myths.html Gaja also has a good myths article: http://www.quest-pipelines.com/newsletter-v3/0302_F.htm Rachel, weren't you doing a presentation on Oracle myths (or did you just put that in DBA 101)? Jeffery Stevenson Chief Databeast Slayer Medical Present Value, Inc. Austin, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:58 AM So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I only said the Packers would be 12-4 this year -- I never said that they couldn't do better! WOO-HOO! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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.com -- Author: Jeffery Stevenson 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!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Is nothing sacred? (Oracle vs The Experts)
Jesse, Rich wrote: So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? This ratio is something I have taught (with 'about') in version 5 days. This was a time when a 500M database was considered to be reasonably big. The bigger the table, the smaller the ratio - you see the problem with a 50 million row table. Add to this that there was nothing such as parallel queries nor partitioning, hash join, etc, etc, which have strongly improved full scan performance and further tipped the balance. You have a lot of numbers around which once were valid but have never been updated. 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? Anything preached by somebody, including myself, who did a thorough benchmark 12 years ago and didnt't retry it recently _may_ be false today. Oracle evolves, that's the trouble. I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. You'd better get accustomed to it :-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: NETWORK Performance how?
On Mon, Nov 11, 2002 at 10:48:57AM -0800, Seema Singh wrote: Hi I want to check network perforamce between app servers and DB servers. How to check ? Is netstat/tracert help or there is another command which could help to find out? ttcp http://ftp.arl.mil/~mike/ttcp.html http://www.pcausa.com/Utilities/pcattcp.htm cisco had it hidden on some of their gear, if you can get the ne guys to help: http://www.cisco.com/warp/public/471/ttcp.html Thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: combine or not combine into one database?
Tao - If I understand your situation, you currently have 3 separate databases, 2 separate Lawson databases and another OEM database? You can combine your two Lawson databases, but you'll need to develop a careful project plan. Right now your Lawson HR database probably sends data to your Lawson GL system, so that needs looked at before you do the combination. There is a Lawson email list that can answer that question in more detail. Is the OEM repository and historical database more of a data warehouse or OLTP system? Data warehouses tend to have spikey usage and don't play well with OLTP databases such as your Lawson system. I would tend to keep it separate just based on the limited information you've provided. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Hi all, I would like to know any advantage and disadvantage to combine the following databases into one: Finance in Lawson HR in Lawson OEM repository and historical database Any comments are very appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Is nothing sacred? (Oracle vs The Experts)
Rich - Actually, if you took an Oracle Performance Tuning class from Oracle Education right now, you would find the BHR mentioned little and Oracle waits emphasized a great deal. I took that class about a month ago and the instructor described how Cary had prevailed in convincing the people at Oracle that counted and the class materials were being rewritten for the next class after mine. Well, being a computer professional is a hard burden, what with the underlying assumption ever changing. Actually, given the extensive discussions we've had on this forum about BHR vs. waits, I'm surprised it caught you unawares. This was where I'd first heard about the new emphasis on waits. Of course, with waits becoming the conventional wisdom, Cary and others will have to find another windmill to tilt at. Cary - anything lined up? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 10:58 AM To: Multiple recipients of list ORACLE-L So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Disclaimer: I only said the Packers would be 12-4 this year -- I never said that they couldn't do better! WOO-HOO! :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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.com -- Author: DENNIS WILLIAMS 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).
Character Sets - 2 different kinds, same server
Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and Oracle binaries were installed with US7ASCII, how can you convert it to UTF8 without having to reinstall everything? This is Oracle 8.1.7.3 on Solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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: Is nothing sacred? (Oracle vs The Experts)
Actually, I did know about the BHR thing, primarily from this list, just as you did. It was the indexing one that cought me off-guard. I was just using the former as a reference. Speaking of which, your Don Quixote reference is priceless! Facts are the enemy of truth. :D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: DENNIS WILLIAMS [mailto:DWILLIAMS;LIFETOUCH.COM] Sent: Monday, November 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Is nothing sacred? (Oracle vs The Experts) Rich - Actually, if you took an Oracle Performance Tuning class from Oracle Education right now, you would find the BHR mentioned little and Oracle waits emphasized a great deal. I took that class about a month ago and the instructor described how Cary had prevailed in convincing the people at Oracle that counted and the class materials were being rewritten for the next class after mine. Well, being a computer professional is a hard burden, what with the underlying assumption ever changing. Actually, given the extensive discussions we've had on this forum about BHR vs. waits, I'm surprised it caught you unawares. This was where I'd first heard about the new emphasis on waits. Of course, with waits becoming the conventional wisdom, Cary and others will have to find another windmill to tilt at. Cary - anything lined up? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 10:58 AM To: Multiple recipients of list ORACLE-L So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
IOUG Papers
Does anyone know what the expected time-frame is for the IOUG paper seletion committee to select papers? I submitted a couple and am on pins and needles. Thanks Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Need Help on Operational Data Store
Gee Dennis, you make it sound glamorous. Will your next career be one as a spin doctor? :) Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/10/2002 05:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Need Help on Operational Data Store Jared And just think, if you'd given it a snappy name like ODS, you'd be jetting around to big conventions and big corporate clients, hosting the greatest technical advice line on the Internet . . . oh, wait you already do those things. Never mind! Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 08, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Dennis, Well, as a matter of fact, I do prefer Kimball to Inmon. I was unaware of their disagreement on ODS, which makes sense I guess, since I've read little of Inmon. My thoughts on ODS were based on discussions with former colleagues. We did have something at BlueCross that we expended a lot of energy in designing, though we didn't call it an ODS. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/08/2002 11:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Need Help on Operational Data Store Jared Oh, I wouldn't let Bill Inmon hear you say that. He coined the term Operational Data Store. I do not purport to be a data warehouse expert at the least, but several years ago I studied the literature quite a bit and tried to keep on top of the topics. And the subject has evolved some since then. At that time, there tended to be two separate camps, followers of Ralph Kimball's ideas and followers of Bill Inmon's ideas. Well, truthfully there was a third group, the rabid Fifth Normal Form advocates that insisted on fully normalizing their DW model. The issue that split the Inmon and Kimball camps was the ODS. The two titans of the industry even had some head-to-head debates at large conferences. Ralph always claimed that the ODS was no big deal, you probably had a loading area somewhere and if you had to give it a name, fine call it an ODS. Bill insisted very strongly that the ODS was THE crucial concept in data warehousing and if you didn't design that part correctly your data warehouse was sure to fail. Since I could easily read and understand Ralph's articles and I could never figure out what Bill was saying, I tended to follow Ralph's advice. Given your statements, Jared you sound like a classic Kimball follower as well. But the world moves on, and since the hot topic has been real-time data warehouses, so I assume the ODS controversy is now moot. Today Inmon's big topic is the Corporate Information Factory. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 08, 2002 11:20 AM To: Multiple recipients of list ORACLE-L Dennis, I think you got it wrong right off when you stated that there's a lot of confusion in ODS vs. DW . It isn't that issue at all. No two people can agree on what an ODS is at all, much less compare it to a DW. To me for instance, an ODS is a place to stage data for the final stages of some other process, be it a DW, or anything else. An ODS is a rather generic term, and therefor whatever you want it to be. Jared On Friday 08 November 2002 07:59, [EMAIL PROTECTED] wrote: Greetings - I need some help with building an Operational Data Store. I know there are a lot of confusion in ODS vs. DW but I belong to the camp of 'ODS should be used only for operational reporting, not decision support'. So while Kimball talks a lot about building a DW in his books, he does not cover ODS much. Are there any books/websites/third parties that deal with building an ODS? TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: ORACLE QUERY
Savita, I assume the problem is the subquery... You can't add the two select count(*) queries together like that. A valid option is to use a sum function like this: select record_identifier from records where rownum(40-(select sum(num) from (select count(*) num from customer_view union all select count(*) from unit view))); The union all is important incase two counts are the same (union on its own would halve the result). The alias num is given to the first column so that there is something to enter in the sum clause. Regards, Mark. PS: There are other ways of doing this also. Savita savita@india. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hp.com cc: Sent by: Subject: ORACLE QUERY [EMAIL PROTECTED] om 11/11/2002 19:13 Please respond to ORACLE-L Hi All, I want to know about one query. I have two views and I want to get the sum of count of two view ex I have a query like select record_identifier from records where rownum(40-(select count(*) from customer_view+select count(*) from unit_view)); But this is not working in oracle. Is there any other way to do this without writing a function -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard 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: OT: RAID 7137 configutation on AIX
smitty pdam (PCI SCSI Disk Array Manager) That is what I used to configure our IBM 2104-TU3 disk array, the menu lets you select the type of raid you want to configure. Hope this helps! Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: chao_ping [mailto:chao_ping;vip.163.com] Enviado el: Sunday, November 10, 2002 1:13 AM Para: Multiple recipients of list ORACLE-L Asunto: Re: OT: RAID 7137 configutation on AIX Rahul, smit ssaraid, if it is ssa disk array like 7133. I am not sure whether it works for your 1737 disk array, just try:). Hope it helps. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net === 2002-11-07 23:43:00 ,you wrote£º=== list, we are trying to install the external disk array IBM 1737 to our J50 rs/6000 we do not have any documents/manuals .. this disk array can be configured as raid5 or raid0, but how to configure it ?? anyone ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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.com -- Author: chao_ping 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.com -- Author: Veronica Levin 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: Oracle daylight saving
Under Oracle9i, the new time zone features offer more possibilities to consider. And much more confusion. http://otn.oracle.com/oramag/oracle/02-nov/o62sql.html Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/11/2002 05:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle daylight saving John Yep, Oracle gets whatever the server has. Under Oracle9i, the new time zone features offer more possibilities to consider. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 6:59 AM To: Multiple recipients of list ORACLE-L How does Oracle handle daylight saving time changes. presumably it gets its time from the OS? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
RE: Partition Question
I agree too, You have to know what is best for you, I just partitioned several tables by date value... left the historic records in one partition (let's say date Jan 2002) and the rest of the records in another partition.but that was because it was the best for us, some users generate historic reports, and other users just update the transactions of the day and generate reports of that day... Hope this helps, Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -Mensaje original- De: Mark Richard [mailto:mrichard;transurban.com.au] Enviado el: Tuesday, November 05, 2002 4:09 PM Para: Multiple recipients of list ORACLE-L Asunto: Re: Partition Question I agree... What are you trying to accomplish with partitioning? Partitioning by year / month / day / whatever can make it easy to truncate / archive old data. The only trick is to create new partitions before they are required. Another goal of partitioning may be query execution. You might partition a table by a certain column what is frequently stored in a where clause. This might restrict the query to a partition rather than the entire table and (depending on the query) could give a performance gain. If you are lucky partitioning will achieve both, if you are unlucky partitioning will just introduce a maintenance hassle. Think about why you want to partition the table and what you expect to gain by doing it. Whatever you do, don't partition simply because you can. Regards, Mark. Don Jerman [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.nc.uscc: Sent by: Subject: Re: Partition Question [EMAIL PROTECTED] m 05/11/2002 05:54 Please respond to ORACLE-L It depends on your reason for partitioning -- if you mean to drop a partition in the future (to roll off the 1999 data or whatever) then the ID range is potentially a valid approach, as long as ID is serial. If you just want to put chunks on different disk volumes, you could use the type or even a hash partitioning scheme. It's down to what you're trying to accomplish, and what is good for one partition key is probably bad or neutral for the other. Hamid Alavi wrote: Hi List, I have a question regarding partitioning: If I want to partition a table which strategy is better, like do i have to use a value which from first day of using this table all those partion is using or just using first partion, then second etc. E.G: If I do partion tableA based on ID range 1000, so for few month the only first partion of this table will be used then second partion, but if I partion it on Type (1,2,3,4,5) any record can be any of these type and from first day all of the partions will be used. Just want to check with you guys which way is better for performance? THanks for HELP Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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). (See attached file: djerman.vcf) Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to
RE: Is nothing sacred? (Oracle vs The Experts)
I like to think of it this way: If a table is defined as small when it does not need to be indexed, then there is no such thing as a small table Others didn't mention - but you may want to look at using IOT's for some of the cases you've mentioned Cheers Connor --- Jesse, Rich [EMAIL PROTECTED] wrote: Actually, I did know about the BHR thing, primarily from this list, just as you did. It was the indexing one that cought me off-guard. I was just using the former as a reference. Speaking of which, your Don Quixote reference is priceless! Facts are the enemy of truth. :D Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: DENNIS WILLIAMS [mailto:DWILLIAMS;LIFETOUCH.COM] Sent: Monday, November 11, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Is nothing sacred? (Oracle vs The Experts) Rich - Actually, if you took an Oracle Performance Tuning class from Oracle Education right now, you would find the BHR mentioned little and Oracle waits emphasized a great deal. I took that class about a month ago and the instructor described how Cary had prevailed in convincing the people at Oracle that counted and the class materials were being rewritten for the next class after mine. Well, being a computer professional is a hard burden, what with the underlying assumption ever changing. Actually, given the extensive discussions we've had on this forum about BHR vs. waits, I'm surprised it caught you unawares. This was where I'd first heard about the new emphasis on waits. Of course, with waits becoming the conventional wisdom, Cary and others will have to find another windmill to tilt at. Cary - anything lined up? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 10:58 AM To: Multiple recipients of list ORACLE-L So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process that runs 20 minutes out of every hour of the day (despite my protests to it's design). After it starts having problems (go figure), it becomes a priority to speed it up. Thanks to a 10046 trace, we see that the query taking the most elapsed time does FTSs on each of two very small tables (1 block and 4 blocks -- 8K blocksize). These tables are not indexed, as per the official Oracle recommendation. After reading the excellent Hotsos paper When to index a table (THANKS, CARY!), I added an index to reduce elapsed time on this query by 50% (150 to 75 seconds in test), proving to me that the paper is valid. And I've only read to page four! OK, first I'm taught by Oracle to look at Buffer Cache Hit Ratios as a measure of performance, then told (and thoroughly convinced) by experts that this is bunk. Now, I found out that the 15% (or 10% or whatever, depending on version) ratio of rows returned to total rows in determining when to use an index in a query is garbage. 1) Why is this? 2) What other pearls of performance wisdom from Oracle Corp should I completely disregard as false? I know there's an Oracle Fallacy website somewhere... It just looks bad on me, our department, and Oracle when, once again, something I've been preaching to our developers as gospel turns out to be completely false. Maybe I'm grumpy because it's snowing on my leaves right now... sigh Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
OT: Day 1: OracleWorld
So far strike rate of 0 for 3. ie 3 presentations, all of which were fluff and no reasonable technical content to speak of... Positives so far: The internet access PCs are nice and quick. If you're here in SF - come check out the OakTable Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused
All, Environment: HP-UX 11i We had Oracle 8i (8.1.7) running successfully on our one host. This host also has Oracle 9i AS already too. Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN backup and recovery on another host). Since then our one application (FAMIS from PRISM) is having problems taking connections through the web (9i AS). One person here did some research and says perhaps when 9i DB was installed (to support doing RMAN backups for a 9i DB system on another box), it overlaid the prior version of Apache. Sounds good to me. We don't have that much experience in the 9iAS, so we can't really say where the problem is. The database is up and open and I can hit it from command line sqlplus. Any ideas what went wrong and how to fix it? Should we have done a reboot of the host after the Oracle 9i install? We did not. message: === ERROR The requested URL could not be retrieved While trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login The following error was encountered: · Connection Failed The system returned: (61) Connection refused The remote host or network may be down. Please try the request again. Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) === Thanks. - Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED] Web page: http://www.harpercollege.edu The only limit to our realization of tomorrow will be our doubts of today. - FDR
RE: combine or not combine into one database?
Thanks a lot for you info. Do you know how I can subscribe the Lawson email list? Thanks again. -Original Message- Sent: Monday, November 11, 2002 2:59 PM To: ORACLE-L Tao - If I understand your situation, you currently have 3 separate databases, 2 separate Lawson databases and another OEM database? You can combine your two Lawson databases, but you'll need to develop a careful project plan. Right now your Lawson HR database probably sends data to your Lawson GL system, so that needs looked at before you do the combination. There is a Lawson email list that can answer that question in more detail. Is the OEM repository and historical database more of a data warehouse or OLTP system? Data warehouses tend to have spikey usage and don't play well with OLTP databases such as your Lawson system. I would tend to keep it separate just based on the limited information you've provided. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Hi all, I would like to know any advantage and disadvantage to combine the following databases into one: Finance in Lawson HR in Lawson OEM repository and historical database Any comments are very appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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.com -- 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).
Solaris vs Windows 2000
Dear List, Believe me, I am not trying to rehash an old topic, start any flame wars, nor look for supporting evidence for my admitted bias toward unix operating systems. Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. This is for an SAP implementation. We are currently running SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget just which server ) As part of our process to upgrade the system to 4.6c and more recent versions of Oracle ( like 8.1.7 ), we are trying to do a comparison of the features, benefits and advantages of using Win2k Server and Solaris. Please don't refer me to such sites as www.kirch.net and www.osdata.com. The information at www.kirch.net is dated and applies to NT, not Win2k. osdata.com is a nice site, but doesn't really offer comparisons, just information on each OS. There is quite a bit of material available at www.microsoft.com. Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ PC Mag has a nice article comparing different platforms for use as a webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp They actually chose IBM running Windows 2000. Windows 2000 is in use here as a server platform for one database that is used as the backend to a rather troublesome application. The Win2k server is running Oracle 8.1.6.2. The database has been bounced 2 or 3 times in the last year. Once was to clear up a strange but non-fatal problem with Oracle. That was back in July, the previous system restart had been in December 2001. Server and database were up without interruption for 7 months. Though I prefer Solaris, I'm having a difficult time coming up with many valid reasons for recommending it over Win2k. A few that I do have: Sun service is superior to Dell service. They've proven this to us. ( We have other Sun machines in house ) Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to go past that I would think we should go with Sun. I don't know about Win2k Advanced Server, as it is a 64 bit platform, and I think the licensing would go up quite a bit. I welcome all objective comparisons of Solaris and Win2k Server, whether your own thoughts, or a link or links to articles you are aware of. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Re: Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused
Don, Oracle 8.1.7 RDBMS, 9iAS and 9.2 RDBMS should all be installed in separate ORACLE_HOME's. If may be that the 9.2 database install went to the same ORACLE_HOME as the 9iAS install. If so, you will likely need to reinstall both 9iAS and 9iR2. Jared Don Malzahn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/11/2002 02:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused All, Environment: HP-UX 11i We had Oracle 8i (8.1.7) running successfully on our one host. This host also has Oracle 9i AS already too. Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN backup and recovery on another host). Since then our one application (FAMIS from PRISM) is having problems taking connections through the web (9i AS). One person here did some research and says perhaps when 9i DB was installed (to support doing RMAN backups for a 9i DB system on another box), it overlaid the prior version of Apache. Sounds good to me. We don't have that much experience in the 9iAS, so we can't really say where the problem is. The database is up and open and I can hit it from command line sqlplus. Any ideas what went wrong and how to fix it? Should we have done a reboot of the host after the Oracle 9i install? We did not. message: === ERROR The requested URL could not be retrieved While trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login The following error was encountered: · Connection Failed The system returned: (61) Connection refused The remote host or network may be down. Please try the request again. Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) === Thanks. - Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]Web page: http://www.harpercollege.edu The only limit to our realization of tomorrow will be our doubts of today. - FDR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
Solaris 2.7/8.1.6.3/Listener
Hi Everyone: I currently have two instances on a machine. Since one is used little if at all, I want to roll the active schema into the other instance, which is used more. Is there a way that I can fool the listener so that when a connection request comes in for the DB I want to shut down it will connect to the other one? If you have an RTFM suggestion, please indicate the FM to R. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: ORACLE-Function problem
At 12:33 AM 11/11/2002, you wrote: select OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as CASE_MSG__OS_CASE_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUSTOMER_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUST_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID as CASE_MSG__OS_UNIT_ID, OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE, 'OS_1' as CASE_MSG__UPDATED_BY FROM OSP_CRM_EXCHANGE_CASE_VIEW WHERE ROWNUM lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2)) ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID); Do you intend for the lt; to be in the query? I'm not sure what you expect this to do, but I suspect that's your illegal character. here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function. When I execute this query in command prompt Itis working fine,but when I use it insied a executeQueryStatement(query) in JDBC I am getting following error ORA-00911: invalid character I am not able to figure out how to modify this. Any help will be highly appriciated. -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave 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: VC++ to Oracle connectivity without installing client
Thanks a lot guys! I really appreciate your input. FYI...we are already in the process of webifying the system, I wanted a solution until we complete that project. Muru --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Muru - I agree with Richard. This is the time to investigate a Web interface for this application. Otherwise you're just starting down the path of a long headache that will only get worse with time. As to your direct question, the only interface that I am aware of that bypasses the SQL*Net interface is JDBC thin client. And in my limited experience, I've seen zero problems when JDBC thin client is used (have heard others on this list have experienced some), but a lot of problems with the Microsoft ADO interface. Now you just have to figure out how to interface VC++ and Java. But, I would expect that Microsoft has some code that will cause the PC to self-destruct if you attempt it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 08, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Hrm. But that's why everyone is doing web-based(three-tier) applications to avoid doing that kind of thing. Even if you manage to include Oracle client into your app, you will still face the challenge of rolling your app on 1000 PCs. Plus subsequent fixes, new versions. -Original Message- Sent: Friday, November 08, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Hello Gurus, I would like to program our VC++ application to directly connect to Oracle database using OO4O or OCI. But the problem is this VC++ app is gonna run on 1000s of desktops where we may have to install Oracle client which will be a time consuming in-efficient process. I am trying to see if the required client dlls and other files can be combined in the VC++ package itself and delivered to those 1000s of desktops. Can any of you give some insight into this, please? Any help would be highly appreciated. Thanks, Muru __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muru 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.com -- Author: Ji, Richard 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.com -- Author: DENNIS WILLIAMS 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!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muru 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
Re: Solaris vs Windows 2000
Linux Rulz!!! On Monday 11 November 2002 03:13 pm, [EMAIL PROTECTED] wrote: Dear List, Believe me, I am not trying to rehash an old topic, start any flame wars, nor look for supporting evidence for my admitted bias toward unix operating systems. Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. This is for an SAP implementation. We are currently running SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget just which server ) As part of our process to upgrade the system to 4.6c and more recent versions of Oracle ( like 8.1.7 ), we are trying to do a comparison of the features, benefits and advantages of using Win2k Server and Solaris. Please don't refer me to such sites as www.kirch.net and www.osdata.com. The information at www.kirch.net is dated and applies to NT, not Win2k. osdata.com is a nice site, but doesn't really offer comparisons, just information on each OS. There is quite a bit of material available at www.microsoft.com. Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ PC Mag has a nice article comparing different platforms for use as a webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp They actually chose IBM running Windows 2000. Windows 2000 is in use here as a server platform for one database that is used as the backend to a rather troublesome application. The Win2k server is running Oracle 8.1.6.2. The database has been bounced 2 or 3 times in the last year. Once was to clear up a strange but non-fatal problem with Oracle. That was back in July, the previous system restart had been in December 2001. Server and database were up without interruption for 7 months. Though I prefer Solaris, I'm having a difficult time coming up with many valid reasons for recommending it over Win2k. A few that I do have: Sun service is superior to Dell service. They've proven this to us. ( We have other Sun machines in house ) Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to go past that I would think we should go with Sun. I don't know about Win2k Advanced Server, as it is a 64 bit platform, and I think the licensing would go up quite a bit. I welcome all objective comparisons of Solaris and Win2k Server, whether your own thoughts, or a link or links to articles you are aware of. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu 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: Character Sets - 2 different kinds, same server
Character set are defined the database level. If you have two different databases, then you can have any two different character sets you wish. This is generally defined at the time you run the create database... statement. Understand of course that in your scenario there would be limits on sharing data between the two databases. The UTF8 database could handle anything stored in the USASCII database because it is a superset, but you could not necessarily share data the other direction. -Ron- -Original Message- Richmond Sent: Monday, November 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and Oracle binaries were installed with US7ASCII, how can you convert it to UTF8 without having to reinstall everything? This is Oracle 8.1.7.3 on Solaris. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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.com -- Author: Ron/Sarah Yount 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: Solaris vs Windows 2000
-Original Message- Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. My personal bias against Windows is based mostly on three things. 1. Incompatibility with everything else. Microsoft makes its products as incompatible as it can get away with so that once you start going down the Microsoft path, you become more and more locked into that path. 2. It is a single-user operating system. Microsoft has done a pretty good job of making it look otherwise by tacking on some multi-user extensions; but it is, in fact, NOT a multi-user OS. Just try creating a general user so that user can install, upgrade, and maintain their application without having administrator privilege. It ain't gonna happen. And that brings up the main problem with this arrangement: Every user that must support an application on the box must have administrator privilege. This, of course, presents a completely insecure environment. 3. In its normal form, there is an amazing lack of the kind of support and scripting utilities the are normal on Unix. True, if one wants to spend the time, many of the utilities can be set up on NT; but that involves additional setup and maintenance time -- which your NT admins might not be inclined to do if the bureaucracy of your organization requires that they do it. If your scripting abilities are substantial, then you, no doubt, automate many things with scripts. If you have built these scripts with a non-standard environment, then you have built your house on shifting sand. (By the way, this is why I do not fully support Linux.) I must agree that I do like the Dell Poweredge stuff. I was using it years ago, and the value is certainly compelling. It's too bad that Sun did the same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up about it and over-priced the crap out of everything until it was too late). But the Sun hardware (and IBM too) ain't all that shabby either. And my past experience -- when I was a sys admin work -- with Sun customer support was very positive. IBM eh, so-so ... maybe. Perhaps another thing to consider: If you have ever tried to upgrade the OS on a NT box supporting third-party applications, I suspect you discovered that it can be an excrutiatingly painful experience ... If you even succeeded at all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: Solaris vs Windows 2000
Seriously now. I know you are trying to evaluate Solaris and Windows, but ... Linux is the way to go. Sun's are expensive machines. NT/2K are cheap(er) but locks you into an expensive software upgrade cycle. Linux costs very little and runs on cheap hardware. -- Lyndon Tiu On Monday 11 November 2002 06:58 pm, Stephen Lee wrote: -Original Message- Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. My personal bias against Windows is based mostly on three things. 1. Incompatibility with everything else. Microsoft makes its products as incompatible as it can get away with so that once you start going down the Microsoft path, you become more and more locked into that path. 2. It is a single-user operating system. Microsoft has done a pretty good job of making it look otherwise by tacking on some multi-user extensions; but it is, in fact, NOT a multi-user OS. Just try creating a general user so that user can install, upgrade, and maintain their application without having administrator privilege. It ain't gonna happen. And that brings up the main problem with this arrangement: Every user that must support an application on the box must have administrator privilege. This, of course, presents a completely insecure environment. 3. In its normal form, there is an amazing lack of the kind of support and scripting utilities the are normal on Unix. True, if one wants to spend the time, many of the utilities can be set up on NT; but that involves additional setup and maintenance time -- which your NT admins might not be inclined to do if the bureaucracy of your organization requires that they do it. If your scripting abilities are substantial, then you, no doubt, automate many things with scripts. If you have built these scripts with a non-standard environment, then you have built your house on shifting sand. (By the way, this is why I do not fully support Linux.) I must agree that I do like the Dell Poweredge stuff. I was using it years ago, and the value is certainly compelling. It's too bad that Sun did the same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up about it and over-priced the crap out of everything until it was too late). But the Sun hardware (and IBM too) ain't all that shabby either. And my past experience -- when I was a sys admin work -- with Sun customer support was very positive. IBM eh, so-so ... maybe. Perhaps another thing to consider: If you have ever tried to upgrade the OS on a NT box supporting third-party applications, I suspect you discovered that it can be an excrutiatingly painful experience ... If you even succeeded at all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu 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: Solaris vs Windows 2000
You have to understand that different people / organisations have different requirements. Some companies will pay huge amount of cash for the peace of mind that they can ring Sun and have someone onsite at 4:00am Sunday morning (or whatever time people hate working at) when required. They might require extremely expensive hardware with guaranteed uptimes, or they might require massive hardware (RAM / CPU) to get the job done in the available time frame. Some companies (especially some universities) might already have licensing deals with Microsoft which make configuring an additional Win2K server effectively free. Or perhaps they have 50 support staff that are skilled in Microsoft and very weak *nix skills. Unless the organisation is a startup there is probably some kind of existing infrastructure to fit within, and this can have a significant impact on both availability and cost. Buying the actual OS is probably one of the cheapest costs. How can anyone here propose that Solaris beats Win2K, or vice versa, without knowing the specific requirements or existing environment? Regards, Mark. PS: Yes, I've worked at both ends of the spectrum (from desktop PC's being used as servers with no redundancy, etc to obscene amount of Solaris hardware in secure data centre type environments). In both situations I thought the hardware was appropriate for the environment. Lyndon Tiu [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fu.ca cc: Sent by: Subject: Re: Solaris vs Windows 2000 [EMAIL PROTECTED] om 12/11/2002 14:34 Please respond to ORACLE-L Seriously now. I know you are trying to evaluate Solaris and Windows, but ... Linux is the way to go. Sun's are expensive machines. NT/2K are cheap(er) but locks you into an expensive software upgrade cycle. Linux costs very little and runs on cheap hardware. -- Lyndon Tiu On Monday 11 November 2002 06:58 pm, Stephen Lee wrote: -Original Message- Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. My personal bias against Windows is based mostly on three things. 1. Incompatibility with everything else. Microsoft makes its products as incompatible as it can get away with so that once you start going down the Microsoft path, you become more and more locked into that path. 2. It is a single-user operating system. Microsoft has done a pretty good job of making it look otherwise by tacking on some multi-user extensions; but it is, in fact, NOT a multi-user OS. Just try creating a general user so that user can install, upgrade, and maintain their application without having administrator privilege. It ain't gonna happen. And that brings up the main problem with this arrangement: Every user that must support an application on the box must have administrator privilege. This, of course, presents a completely insecure environment. 3. In its normal form, there is an amazing lack of the kind of support and scripting utilities the are normal on Unix. True, if one wants to spend the time, many of the utilities can be set up on NT; but that involves additional setup and maintenance time -- which your NT admins might not be inclined to do if the bureaucracy of your organization requires that they do it. If your scripting
RE: Solaris vs Windows 2000
Jared, I've never managed a UNIX server, but we do have some VMS servers and some Windows servers. Some thoughts: Some changes in your Network require a reboot on each server - specifically consider the following: your DNS server changes - AFAIK need a reboot your WINS server changes - AFAIK need a reboot Yes, you can get around most of this by using a local hosts file - but that's more administration (and have you ever tired (for example) to do a net send to a server specified by name where the name is in a host file It didn't work for me - maybe a lmhosts file will get around this - don't know. You want to change the domain the server is in - AFAIK time to reboot Now, I'm not against Windows servers as such and I know you can run them for long uptimes, but it can be frustrating when events external to the administration of that box force you to reboot (eg you can't just stop the IP component reconfigure it and restart that bit). Support Which company (Dell or Sun) will give you (for free) spares to locate on your site to allow quick replacements? Do you get Dell's premier support, or just standard customer support Out of band remote console Yes you can use PC Anywhere / VNC / whatever, but doesn't help if it freezes during the reboot. I take it you're aware of Dell's DRAC / ERA (Embedded Remote Assistance) cards that provide this. Have you looked into Dell's IT Assistant for monitoring its servers. Disk Infrastructure With the disk infrastructure you are going to be using for your Dell box, can you add new disks without rebooting? It's frustrating to require a reboot just to add another disk. Oracle support What's your company's sway with Oracle? Many big customers seem to be on Unix, meaning that any particular patch may well come out first for Solaris. (Then again the consolidated patch sets that they release for Windows are handy - get all the fixes in 1 go (once that patch set is released). SAP - how many SAP customers have their DB on Unix vs Windows? ie if you run into a SAP specific Oracle issue, is it more likely to be fixed first on Solaris or on Windows? Scalability - Do you get the free Dell Power solutions magazines (articles are also available on their web site)? They've had a few articles on benchmarking on some on migrating Sun based BEA Weblogic servers to Dell servers running Red Hat / W2K. Their cluster special edition in 2002 had an article comparing performance for 2/4/8 CPUs (admittedly this test was using SQL Server). Have fun let us know what you find... Regards, Bruce Reardon -Original Message- Sent: Tuesday, 12 November 2002 1:59 PM -Original Message- Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. My personal bias against Windows is based mostly on three things. 1. Incompatibility with everything else. Microsoft makes its products as incompatible as it can get away with so that once you start going down the Microsoft path, you become more and more locked into that path. 2. It is a single-user operating system. Microsoft has done a pretty good job of making it look otherwise by tacking on some multi-user extensions; but it is, in fact, NOT a multi-user OS. Just try creating a general user so that user can install, upgrade, and maintain their application without having administrator privilege. It ain't gonna happen. And that brings up the main problem with this arrangement: Every user that must support an application on the box must have administrator privilege. This, of course, presents a completely insecure environment. 3. In its normal form, there is an amazing lack of the kind of support and scripting utilities the are normal on Unix. True, if one wants to spend the time, many of the utilities can be set up on NT; but that involves additional setup and maintenance time -- which your NT admins might not be inclined to do if the bureaucracy of your organization requires that they do it. If your scripting abilities are substantial, then you, no doubt, automate many things with scripts. If you have built these scripts with a non-standard environment, then you have built your house on shifting sand. (By the way, this is why I do not fully support Linux.) I must agree that I do like the Dell Poweredge stuff. I was using it years ago, and the value is certainly compelling. It's too bad that Sun did the same thing with Solaris on Intel that IBM did to OS/2 (got very stuck up about it and over-priced the crap out of everything until it was too late). But the Sun hardware (and IBM too) ain't all that shabby either. And my past experience -- when I was a sys admin work -- with Sun customer support was very positive. IBM eh, so-so ... maybe. Perhaps another thing to consider: If you have ever tried to upgrade the OS on a NT box supporting third-party
Re: ORACLE-Function problem
Hi justin, Thanks for the help,actually this query will send to an XML Processore and lt; will replaced with .But my problem was something else.I have resolved that problem now. Thanks once again for the help. Justin Cave wrote: At 12:33 AM 11/11/2002, you wrote: select OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID as CASE_MSG__OS_CASE_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUSTOMER_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_CUSTOMER_ID as CASE_MSG__OS_CUST_ID, OSP_CRM_EXCHANGE_CASE_VIEW.OS_UNIT_ID as CASE_MSG__OS_UNIT_ID, OSP_CRM_EXCHANGE_CASE_VIEW.CREATED_DATE as CASE_MSG__CREATED_DATE, 'OS_1' as CASE_MSG__UPDATED_BY FROM OSP_CRM_EXCHANGE_CASE_VIEW WHERE ROWNUM lt;=(40 - OSP_CRM_EXCHANGE_getMaxDataId(2)) ORDER BY to_number(OSP_CRM_EXCHANGE_CASE_VIEW.OS_CASE_ID); Do you intend for the lt; to be in the query? I'm not sure what you expect this to do, but I suspect that's your illegal character. here OSP_CRM_EXCHANGE_getMaxDataId(2) is the function. When I execute this query in command prompt Itis working fine,but when I use it insied a executeQueryStatement(query) in JDBC I am getting following error ORA-00911: invalid character I am not able to figure out how to modify this. Any help will be highly appriciated. -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave 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). -- Best Regards - Savita Hewlett Packard (India) +91 80 2051288 (Phone) 847 1288 (HP Telnet) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Savita 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: Solaris vs Windows 2000
Jared -- I tend to agree with your statements. Although, personally, I tend to think that Windows NT/2000/XP is a wholly inappropriate environment for any enterprise database. The general reasons I tend to choose to back my statements: 1. Scalability. (I'm sorry, clustering is an availability solution, not a scalability one. If you can't grow beyond 4 CPUs [Intel's problem more than M$FT's, here] and need to, then an Intel platform is not for you.) 2. Managibility. I can do practically anything I need to on a unix box over a 300bps modem, if necessary. (This omits, of course, inserting media and hitting the power switch... oh, and installing oracle now that they have this java-based installer... fortunately, that's not *that* common of an occurance in ordinary maintenance) 3. Did I mention scalability? Most *nix platforms scale in a much more linear fashion. (i.e. 2 cpu's are more likely to give you double the performance on a RISC-based system than on an x86 based one.) Note: I'm saying only that RISC systems tend to be *more* linear than x86 ones. 4. Supportability. (yeah, I know, not really a word). I've supported Oracle on both (especially Oracle Applications). Personally, unix platforms tend to provide much more useful information when something does go wrong. The standard Microsoft error message of it's broke doesn't really tell me anything useful. 5. Security. How many security flaws have been found in 'doze? And don't even get me started on M$FT Look-out! (otherwise known as a security hole that occasionally delivers mail). It's also nice that *nix platforms are immune to all of the _really_common_ virii that hit the news these days (Melissa, I Love You, etc.). (Not that *nix is truly immune to virii... but the big-bad-ugly-ones you hear about tend to exploit flaws in... hows that again? Right... Windows and Lookout... Although it helps somewhat that the *nix security model tends to compartmentalize things a bit more than windows does [by default]). 6. Do you *really* want all of the overhead of a tightly-coupled GUI on a _server_? Admittedly, Windows 2000 does appear to be far more stable than previous versions. And the NT-derivatives don't tend to crash in a wholesale manner like the Windows/386 derivatives ('95,'98,ME). But, personally, I should _NEVER_ have to reboot a machine to upgrade/patch a web browser. -- James == James J. Morrow Nascent Systems, Inc. Dallas, TX mailto:jmorrow;warthog.com [EMAIL PROTECTED] wrote: Dear List, Believe me, I am not trying to rehash an old topic, start any flame wars, nor look for supporting evidence for my admitted bias toward unix operating systems. Now that that's out of the way, what I am trying to do is find objective material comparing the use of MS Windows 2000 Server on Intel HW to Solaris on Sun HW. This is for an SAP implementation. We are currently running SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget just which server ) As part of our process to upgrade the system to 4.6c and more recent versions of Oracle ( like 8.1.7 ), we are trying to do a comparison of the features, benefits and advantages of using Win2k Server and Solaris. Please don't refer me to such sites as www.kirch.net and www.osdata.com. The information at www.kirch.net is dated and applies to NT, not Win2k. osdata.com is a nice site, but doesn't really offer comparisons, just information on each OS. There is quite a bit of material available at www.microsoft.com. Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ PC Mag has a nice article comparing different platforms for use as a webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp They actually chose IBM running Windows 2000. Windows 2000 is in use here as a server platform for one database that is used as the backend to a rather troublesome application. The Win2k server is running Oracle 8.1.6.2. The database has been bounced 2 or 3 times in the last year. Once was to clear up a strange but non-fatal problem with Oracle. That was back in July, the previous system restart had been in December 2001. Server and database were up without interruption for 7 months. Though I prefer Solaris, I'm having a difficult time coming up with many valid reasons for recommending it over Win2k. A few that I do have: Sun service is superior to Dell service. They've proven this to us. ( We have other Sun machines in house ) Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to go past that I would think we should go with Sun. I don't know about Win2k Advanced Server, as it is a 64 bit platform, and I think the licensing would go up quite a bit. I welcome all objective comparisons of Solaris and Win2k Server, whether your own thoughts, or a link or links to articles you are aware of. Thanks, Jared --
URGENT
Hi, While trying to compile a procedure i face the error PLS-00201 - sys.dbms_lock must be declared Which script do I need to run for this. Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilmohan 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).
Schedule Backup in UNIX
Dear List, We are working with Oracle 8i Database under UnixWare Plateform. My question is How to do Schedule Backup? I tried to do Schedule backup but it does not work. I'll show u the steps that I did... 1) I wrote my batch. 2) cd /var/spool/cron/crontabs 3) crontab -e oracle it will open a text file. Oracle- # 5 14 * * * /usr/oracle/backup.ksh 21 1/dev/null # --- 4) cd /usr/oracle 5) I did write backup.ksh like this: backup.ksh- # # This Procedure for ORACLE export # exp payroll/pay file=/usr/oracle/pay02.dmp # exit --- Any clues why this is not working ... regards, Ashraf __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH 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).