Oracle and Novell eDirectory LDAP
Hi, We are in the preliminary analysis of implementing an assurance package (Sunguard's Compass) based on Oracle (Oracle 9.2.04, Oracle 9iAS Web Services and Forms on AIX 5.2). We are using Novell eDirectory as our LDAP. I looked on Metalink but did not find much thing. The way I understand it is that you must load the LDAP info into Oracle Internet Directory. Am I right ? Anybody using Novell eDirectory integrated with Oracle ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Cobol redefine in SQL
And I thought that all old people knew cobol ;-) I'll try to think of a solution that does involve creating many tables per redefine statement. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Jared Still Sent: 27 novembre, 2003 15:09 To: Multiple recipients of list ORACLE-L Carel-Jan, Well, go ahead and spoil all our fun. ;) Seriously though, thanks for posting which part of the fine manual to peruse. If I *knew* COBOL, perhaps I could offer something useful rather than just whining. Now if anyone needs to move from Data-Flex to Oracle, I can offer some ideas. Jared On Thu, 2003-11-27 at 11:44, Carel-Jan wrote: At 05:44 27-11-03 -0800, you wrote: I'm looking for a solution that is using only one table not multiple tables. In fact a dynamic column redefinition feature (cobol redefines) is what I need in Oracle SQL. Stephane Hi Stephane, Instead of flaming Cobol I'll try help you with a solution. Please download the utilities manual, as I advised last time, look at the SQL*Loader part and take case study 5. It will tell you exactly what you want. Redefines, Occurs, all is covered. I think this will solve your problem. You can have as many INTO TABLE clauses as you like, one for each redefine. Every INTO TABLE might refer to the same table. The WHEN clause helps you to determine what INTO TABLE clause to use. To the others in this thread, IMHO Cobol might not be state of the art, whithout it IT might not have been what it is now. I hate the language, actually never ever wrote a working program in it due to some mental blocks connected with the syntax, but I've done many data-conversions of files, based on the record-layouts. Redefines might be ugly, for those of you who do not remember the amazing discovery of a 5 MB (spelled MegaByte) harddisk, and spending 3 hours discussing with 4 programmers how to use this amazing amount of diskspace in a usefull way some hsitorical awareness might help. Cobol, coming from the early sixties AFAIK, doesn't support null-values. Actually, when they started using it, there were no disks at all. Costs of storage were sky-high, and every byte saved was welcome. So, redefines, and repeating groups (OCCURS 10 TIMES in a field definition) really helped people writing usefull programs, based on serial access to data stored on ticker tapes and magnetic tapes. It is about time to get some awareness of the history of our trade, before it all fades away. Visit Miracle's Oracle museum, running Oracle V5 on a 286 / Dos 6.0 system, or similar old-fashioned. Do you condemn the T-Ford as well? That doesn't meet today's standards, but was most important to the development of a certain country in this world. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Stephane Paquette 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: Cobol redefine in SQL
Sorry, it was a typo, I meant a solution that does not involve creating many tables per redefine statement. Stéphane -Original Message- Carel-Jan Engel Sent: 28 novembre, 2003 11:49 To: Multiple recipients of list ORACLE-L At 06:49 28-11-03 -0800, you wrote: And I thought that all old people knew cobol ;-) I'll try to think of a solution that does involve creating many tables per redefine statement. I thought you needed every redefine in the same table? So you mean 'many into table clauses' ISO 'many tables'? Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Cobol redefine in SQL
I'm looking for a solution that is using only one table not multiple tables. In fact a dynamic column redefinition feature (cobol redefines) is what I need in Oracle SQL. Stephane -Original Message- Carel-Jan Sent: 26 novembre, 2003 17:29 To: Multiple recipients of list ORACLE-L At 13:34 26-11-03 -0800, you wrote: Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a redefine command. For the younger ones, it means a zone (50 caracters) that can be defined in many ways depending on a key : 2 fields of 25 char or 5 fields of 10 char or The programmers can always use substring to death to work this out but I was wandering if there was a more elegant and a less error prone solution, maybe using a record type or a function ... Stephane Paquette Hi Stephane, How are you loading the data into the Oracle database? Do you use SQL*Loader? Go to the manual and look at the examples, it is quite straightforward defining multiple record layouts, and have them loaded into defferent tables. This can be done based on the record-type indicator which will be in the record. You can handle your redefines and repeating groups with SQL*Loader. Last year I've written a kind of replication mechanism which replicates a Cobol C-Isam system into an Oracle database on a daily basis. Different record layouts can be stored in differend tables, or in the same table in different columns. The latter I do not recommend. This will giive you a nice headstart converting the data into the ultimate datamodel. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Cobol redefine in SQL
Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a redefine command. For the younger ones, it means a zone (50 caracters) that can be defined in many ways depending on a key : 2 fields of 25 char or 5 fields of 10 char or The programmers can always use substring to death to work this out but I was wandering if there was a more elegant and a less error prone solution, maybe using a record type or a function ... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
char(1) VS varchar2(1)
Hi, Some people here are telling me that using char(1) is better than varchar2(1) for a field code. I do not see why. I never used char as it may cause problems when doing some comparisons. Any reasons ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: dba interview questions
Give whisky, scotch and beer to Mladen and he'll be good -Original Message- Mladen Gogala Sent: 28 octobre, 2003 08:59 To: Multiple recipients of list ORACLE-L On 10/28/2003 06:59:24 AM, Richard Foote wrote: 1) What do you think of David Bowie, is he brilliant or what ? Or what. and providing they answer the above question positively 2) Are you any good ? I'm ad to the one. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Installing pro*cobol
Hi, We always copy the Oracle binaries rather than installing Oracle. Our standard Oracle copy does not contain Pro*cobol. After reading the doc I can summarize the installation of pro-cobol this way. (Cobol is already installed.) - Install pro*cobol 817 - Apply path 8172 for pro*cobol only. It seems I do not have to relink anything. Did I missed something ? The target server (aix433) has 28 instances with some important ones (user testing). Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 /db2
There is 2 documents I know: The one from Oracle is absolutely vendor oriented http://www.quest.com/presentations/DB2_vs_Oracle.pdf http://otn.oracle.com/deploy/performance/pdf/CWP_9IVSDB2_PERF.PDF Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Joe Testa Sent: 24 octobre, 2003 10:49 To: Multiple recipients of list ORACLE-L Well i've been tasked to do some crosstraining of db2 DBAs to teach them oracle(dark side, ok more expensive side). Does anyone know of a white paper, document, book, etc that would do DBA tasks comparisons? looking for something like alter database datafile 'filename' resize 1000m; command in oracle is equivalent to that in db2/udb. Does something like that exist? thanks, joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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: WHERE 1 = 1 (any info on this)
I'm using that predicate in FGAC functions so the function always return something. An FGAC metalink note advise to this . Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Hately, Mike (LogicaCMG) Sent: 21 octobre, 2003 07:45 To: Multiple recipients of list ORACLE-L Morning folks, the developers here are looking at a view with a where clause which specifies : WHERE 1=1 AND ... AND ... etc. I'd seen this used before as a way of tweaking the RBO into certain behaviours but it was years ago and my recollection is very hazy. The only explanation I've found so far is : the 1=1 is in there to avoid doing repetitive index scans for single rowids, when the app knows the result set is going to be manipulated rowid's for a large subset of the table. I would guess your DUAL/CBO example had some similar effect. Is anyone familiar enough with this tweak to explain it ? Cheers, Mike PS Maybe it'll head off some replies if I make it clear that this view hasn't been generated by code so the 1=1 isn't an accidental artifact It was custom written and is definitely supposed to have exactly this structure. E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Block size : what is the gain ?
Hi, All our DB have an 8k block size (8172/aix). Even the reporting/dss database where data is accessed mainly by full scan. Can we quantify the gain in % of switching from an 8k to 16k block size from a performance point of view ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: disaster recovery doc
We do disaster recovery testing twice per year. The test includes all production systems. The unix guys are sentto another city, where the unix boxes are, to do their stuff and the dba to another location : no fight this way ;-) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Mercadante, Thomas FSent: 21 octobre, 2003 15:44To: Multiple recipients of list ORACLE-LSubject: RE: disaster recovery doc poor bastard. you'll spend hours and hours developing a document nobody really wants, nobody will read, and (hopefully) you will never use. if I were you, I'd start lobbying for an outside agency to write it for you. sure, you'd have to work with them. but they would get it done faster, create a better report because they could focus on just it, and would have better experience in what to put into it. good luck! Tom Mercadante Oracle Certified Professional -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 21, 2003 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: disaster recovery doc Hi Guys , I have been recently tasked to write up procedures and steps / documentation for disaster recovery of db/system . Any help , pointers ,links related to this is highly appreciated . Thanks, -ak OCP DBA 8i
RE: Data Transfer between two instances
Db link slow ? Are you sure ? What was the bottleneck when you test ? Using insert /*+ appent */ on non-indexed tables with nologgingis usually fast enough in most cases. I know that we can playwith the SDU-TDU parameters on sql*net but I do not know what kind of performance improvement we can get from that. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Gunnar BerglundSent: 20 octobre, 2003 01:39To: Multiple recipients of list ORACLE-LSubject: Data Transfer between two instances Hi all, we have an application which needs data from other environment (which is actually SAP db). Currently we have implemented it the way we create flat files and put them in using pl/sql -procedures but I don't like this because the data in the flat files are "visible" and it is somehow "secret". What other options we might have if we do not want to use db links (because of its slowness. I very much appreciate all your suggestions... TIA gb Want to chat instantly with your online friends?Get the FREE Yahoo! Messenger
RE: CBO, RBO and will v5 ever really go away?
Is 38 that old ??? Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 18:00 To: Multiple recipients of list ORACLE-L Ah, another one who can claim experience. According to one of the previous post it's a genuine gold mine these days. Being born in the Jurassic (1961) has its advantages, but I have yet to find them. On 10/17/2003 05:29:31 PM, Stephane Paquette wrote: And also SQL*Loader will be rename to ODL (Oracle Data Loader) Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 17:19 To: Multiple recipients of list ORACLE-L Bambi, Oracle 5.1.22 was an exceptionally stable version of oracle, with very few parameters (names were TABLES,INDEXES and alike) and, as such will forever be committed to our memory. Furthermore, RBO is used in the data dictionary, just like the datatype LONG which has also, allegedly, been desupported but someone forgot to tell that to developers. There are things from V5.1.22 that I'm missing even today. There used to be something called rpf/rpt which was a very good thing for writing quick command line reports without huge and buggy gooey interface. I started learning the only other language that has formats and page handling and is not COBOL when rpt/rpf was taken away in 7.1 (your guess is correct, it's perl). In short, Oracle 5 will never go away. I here that in version 11, SQL*Plus will be renamed to UFI (= User Friendly Interface) and there will be tools for generating simple forms called IAP, IAG and IAD... On 10/17/2003 04:54:25 PM, Bellow, Bambi wrote: Friends -- I just got back from a week of benchmarking and one of the issues that came out of it was, due to some rather, um, interesting, coding techniques, running schema level statistics both wrecked performance *and* produced Oracle Bug 2954921. So we had to remove the statistics before running additional tests. Of course, RBO is being desupported soon, so we really ought to modify things. But, this brings up another issue. See, Oracle says, and here I am paraphrasing, of course, that... RBO is going to die. We're not supporting it anymore. Nope. Once you get off of 9.2, that's it. Finito. Hasta la vista, Ba-bee. Well, no, it's not really going away. YET. It will still be behind the scenes for awhile. But sooner or later, it's going to die. You've been warned. This isn't going to be like Forms2.3. No. We're serious this time. We put in all these great features that y'all aren't using because your code is dependent on RBO and RBO can't use these features and that sucks because we really like these features. Now, we figure that a slim minority of people... maybe 20%... are still using RBO. 20%. Barely noticeable. (dinosaurs, grumble, grumble) Well, we're taking it away. We're going to drag you into the new millenium and you're going to use CBO. And you're going to like it. We'll leave RBO in there for awhile, but one day you'll wake up and it will be gone. Gone, I tell you, GONE! Just you wait. 5, 10 years from now, RBO will be a mere a memory. Just like Forms2.3. Oh, and that select * from tab; that you're doing every once in awhile to see if it still works, you just wait, someday *someday* we're going to take *that* away too. And you're just going to have to live with it. HAhahahaha! So, what do you think? Will v5 ever really go away? And when will RBO just stop working? Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender
RE: CBO, RBO and will v5 ever really go away?
38 is my age, Mladen is 42 Stephane -Original Message- Bellow, Bambi Sent: 20 octobre, 2003 13:04 To: Multiple recipients of list ORACLE-L Let's do the time warp again! 2003-1961=42... But, I liked 1999 better... just a jump to the left... One thing about living in the past... The rent sure is cheaper. Bambi (feeling that 38 is a spry young thang) -Original Message- Sent: Monday, October 20, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Is 38 that old ??? Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 18:00 To: Multiple recipients of list ORACLE-L Ah, another one who can claim experience. According to one of the previous post it's a genuine gold mine these days. Being born in the Jurassic (1961) has its advantages, but I have yet to find them. On 10/17/2003 05:29:31 PM, Stephane Paquette wrote: And also SQL*Loader will be rename to ODL (Oracle Data Loader) Stephane -Original Message- Mladen Gogala Sent: 17 octobre, 2003 17:19 To: Multiple recipients of list ORACLE-L Bambi, Oracle 5.1.22 was an exceptionally stable version of oracle, with very few parameters (names were TABLES,INDEXES and alike) and, as such will forever be committed to our memory. Furthermore, RBO is used in the data dictionary, just like the datatype LONG which has also, allegedly, been desupported but someone forgot to tell that to developers. There are things from V5.1.22 that I'm missing even today. There used to be something called rpf/rpt which was a very good thing for writing quick command line reports without huge and buggy gooey interface. I started learning the only other language that has formats and page handling and is not COBOL when rpt/rpf was taken away in 7.1 (your guess is correct, it's perl). In short, Oracle 5 will never go away. I here that in version 11, SQL*Plus will be renamed to UFI (= User Friendly Interface) and there will be tools for generating simple forms called IAP, IAG and IAD... On 10/17/2003 04:54:25 PM, Bellow, Bambi wrote: Friends -- I just got back from a week of benchmarking and one of the issues that came out of it was, due to some rather, um, interesting, coding techniques, running schema level statistics both wrecked performance *and* produced Oracle Bug 2954921. So we had to remove the statistics before running additional tests. Of course, RBO is being desupported soon, so we really ought to modify things. But, this brings up another issue. See, Oracle says, and here I am paraphrasing, of course, that... RBO is going to die. We're not supporting it anymore. Nope. Once you get off of 9.2, that's it. Finito. Hasta la vista, Ba-bee. Well, no, it's not really going away. YET. It will still be behind the scenes for awhile. But sooner or later, it's going to die. You've been warned. This isn't going to be like Forms2.3. No. We're serious this time. We put in all these great features that y'all aren't using because your code is dependent on RBO and RBO can't use these features and that sucks because we really like these features. Now, we figure that a slim minority of people... maybe 20%... are still using RBO. 20%. Barely noticeable. (dinosaurs, grumble, grumble) Well, we're taking it away. We're going to drag you into the new millenium and you're going to use CBO. And you're going to like it. We'll leave RBO in there for awhile, but one day you'll wake up and it will be gone. Gone, I tell you, GONE! Just you wait. 5, 10 years from now, RBO will be a mere a memory. Just like Forms2.3. Oh, and that select * from tab; that you're doing every once in awhile to see if it still works, you just wait, someday *someday* we're going to take *that* away too. And you're just going to have to live with it. HAhahahaha! So, what do you think? Will v5 ever really go away? And when will RBO just stop working? Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error
RE: job opportunity in Dallas
And you think I used my real name ! Clark Kent -Original Message- [EMAIL PROTECTED] Sent: 20 octobre, 2003 14:59 To: Multiple recipients of list ORACLE-L Hey guys - this is funny. Don't respondit is actually a trick...various employers are using this service to determine how loyal their current DBA's are while the market is tight Just kidding -Original Message- Sent: Monday, October 20, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I wonder... in the VMS world, they were executables, so is this a VMS job? Would it be '.o'ers in Unix? Or batchers in DOS? Bambi. -Original Message- Sent: Monday, October 20, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Hummm, sounds interesting. Been doing that on Duhvelopers for the last 10 years! *-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, October 20, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Executioner. On 10/20/2003 12:14:35 PM, Stefick Ronald S Contr ESC/HRIDD wrote: What kind of job? Mail Carrier, garbage collector, retail clerk Details. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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
RE: CBO, RBO and will v5 ever really go away?
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: SQL Operation and Row size
At what step ? Oracle reads blocks, so from the datafile up to the db_buffer/db_cache its blocks. It would be logical that the filtering occurs after the where clause has chosen the data matching the search criteria, so in the select step which is the last step of the query operation. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Daniel Fink Sent: 15 octobre, 2003 16:09 To: Multiple recipients of list ORACLE-L When retrieving data, does Oracle place just the columns of interest into the result set or does it place the entire row in the result set (and filter out the columns of interest later)? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: continuously copy archive redo logfiles to tape
Well, Backtrack is working well, in fact we will buy it for our new DB2 environment since we are quite happy with it in the Oracle environment. What is the other one working ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: 14 octobre, 2003 13:19 To: Multiple recipients of list ORACLE-L I'd try using backup software. There are only two utilities that work: 1) EMC/Legato Systems Legato Networker 2) Veritas Net*Backup 3) Spectralogic Alexndria backup. 4) Syncsort Backup 5) IBM Tivoli backup. 6) HP OmniBackup 7) CA Arcserve 8) BMC SQL*BackTrack On 10/14/2003 12:59:25 PM, Roger Xu wrote: Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Database just stops
Title: Message If the archive destination is full then for sure the database will stop but it will not crash. It's probably a bug, you should probably go to 8.1.7.4. Talking about database stop, I just did an audit at a client site, during my spare time. The top3 SQL: The first onewas run 20 times per second and has 1280 gets The second one was run 14 times per minute and each executionhas 78091 gets The third one was run 1 per minute and each execution has 965637 gets. The database was really stopped !!! Of course the application vendor wastalking about adding more hardware ... Stephane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Oracle-LSent: 14 octobre, 2003 16:40To: Multiple recipients of list ORACLE-LSubject: Re: Database just stops When you mean by "stops" - do u mean you are not able to connect any more from sql*net ? or even the current sessions hang ? Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ? Babu - Original Message - From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 3:14 PM Subject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
RE: Unintentional Humor
You mean the hidden $ORACLE_HOME/bin directory Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Daniel FinkSent: Monday, October 06, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Unintentional HumorIsee what you mean. Too funny! Hmm...Iguess I've been wrong all these years. And all that time Iwasted reading the official documentation on such "undocumented" and "hidden" programs like export/import, sql*loader, tkprof... [EMAIL PROTECTED] wrote: OK, well I thought it was funny. Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? Jared
RE: data loading
You can use the partitionning option. Load into a 1 partitionned table then do a partition exchange with the target table. It allows you to have the current data live while loading into the partitionned table. Once the load is loaded just exchange the partition with the table, it is fast as it is just an update in the data dictionnary. No data is physically moved. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Nancy Hu Sent: Monday, October 06, 2003 5:14 PM To: Multiple recipients of list ORACLE-L Hi All, We have an Oracle database that is a kind of data warehouse. We load data from mainframe into the database every day. The following are the steps how we load data currently: 1. get the data file from Datacom 2. ftp the data file from mainframe to the Sun machine where the Oracle database resides 3. truncate all tables in Oracle database 4. load the data into Oracle with SQL LOADER Most tables in the Oracle database don't have primary key. Tables are not available during the loading that gives us problem for our 24x7 availability. Therefore, we would like to change our loading method. Any ideas would be highly appreciated. Nancy _ Instant message with integrated webcam using MSN Messenger 6.0. Try it now FREE! http://msnmessenger-download.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nancy Hu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: AIX ODBC driver from Oracle
I`ve used Merant ODBC driver on Sun. It worked pretty well. I'm surprised that you have problem with it. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Gene Gurevich Sent: Thursday, October 02, 2003 4:05 PM To: Multiple recipients of list ORACLE-L Hi all: A developer has installed some software from IBM, which is using an ODBC driver from Merant to connect to a remote database. And it also doesn't seem to work. So they are asking whether there is a Oracle ODBC driver for AIX which they can try instead. Does anyone know where do I start to look for that driver? I never had to deal with that stuff before. Thanks Gene __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Cary's book -- Out of stock !
I've also picked up my copy yesterday but ...I'm assuming everyone else has theirs by now and are busily reading. ... I still not have finished Tom Kite Expert one on one Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- DENNIS WILLIAMS Sent: Tuesday, September 30, 2003 9:30 AM To: Multiple recipients of list ORACLE-L I picked my copy up last night from my local Borders bookstore. They even had a copy for the shelf. I'm assuming everyone else has theirs by now and are busily reading. Please post any comments or observations. Leave it to Cary to put exercises at the end of each chapter. A quick flip through makes me want to abandon study for my last OCP exam. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 23, 2003 11:40 AM To: Multiple recipients of list ORACLE-L RE: Re: Cary's book -- Out of stock !Hi! Figure 9-14 shows an interesting situation in which a single fast CPU out-performs a system with 4 slower CPUs, for a certain condition; this is exactly the situation I am facing while testing the move of a DB (9.0.1.3.0) from a 2-processor (600 MHz) to a 4-processor (400 MHz) box and have been puzzling over reduced performance, even after playing with different degrees of parallel query and having twice as much memory for the DB on the 4-processor box Btw, that's one of the reasons why I suggest my clients to turn off Hyperthreading for their new Intel boxes. HT basically makes your CPU to 2 over 50% slower CPUs, providing that all your virtual CPUs will be loaded and you are using the same types of CPU instructions in all of your processes (I doubt that you are using MMX, SSE or even FPU that much with your Oracle database). Situation gets especially bad with parallel execution where Oracle thinks it has 4 physical processors whilst you actually got 2 for example. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Stephane Paquette 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).
Data denormalisation seems some attractive
Hi, A co-worker of mine is working on a tiny project. Let say you have commission info and commission details, there are 7 types of commissions. The 7 types of commission shares common fields (from 100% to 30%) From a conceptual point of view, you have 1 entity that is the commission info and 7 entities for the seven types of commissions since they all have private info (some fields are mandatory).. 1 commission must be 1 of the 7 types. Now at the physical level, info is write once, never update and read through a selective search criteria (agent number). Volume is about 8 000 000 commissions. You can have the physical model as the conceptual model. That means you do not have any work for managing integrity but when reading you have more work to get the data. Or You can put all data in 1 table with all fields. When data is inserted you must managed integrity (some common fields are mandatory for 1 type of commission but not for another one) but reading is fast just 1 record to read. Since, I do not know what the future of this project is I recommended the other DBA to keep data normalized. And to do a benchmark if he really wants to denormalize. Your opinions please. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: COBOL TO ORACLE
Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. You can use Sql*Loader to load flat files into Oracle or use COBOL programs with embedded SQL, you'll need to use Oracle Pro*Cobol to precompile the COBOL source before compiling them. The last time I've used Designer it was 2 years ago and I do not remember any support for transforming flat files to an ERD. Anyway, it would probably be a bad thing, I've seen applications do a 1 to 1 mapping between files and tables. The result was not good... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Thomas Day Sent: Tuesday, September 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Er ... No. COBOL is a programming language. Oracle is a relational database manager. The data used in a COBOL program can be stored in a variety of ways. It's even possilbe to have a COBOL program using data from an Oracle database. I'm not aware that Designer can translate COBOL file definitions into entities; however, if you know COBOL and Oracle it should be fairly straightforward. Muqthar Ahmed Muqthar.Ahmed To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @decoratetoday.c cc: om Subject: COBOL TO ORACLE Sent by: ml-errors 09/30/2003 03:14 PM Please respond to ORACLE-L Hi, Is there a tool available to move data from COBOL to ORACLE directly? One way to do is get COBOL data on a flat file and then use SQL*Loader to insert into ORACLE tables. The second question is did anyone use DESIGNER to connect to COBOL to create an ERD and then transform into ORACLE tabels script? Thanks Muqthar Ahmed DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Data denormalisation seems some attractive
Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10 fields), charge back (9 fields), vesting payment (1 field), subsidy (2 fields), supplementary commission (2 fields) sales bonus (3 fields), deferred commission (12 fields) I just talked to the concerned DBA, those are coming from a mainframe system and there is nothing we can do about themeven if some types are strange : For example, the manager overrided type must be linked to 1 of 4 specific types.In my mind an override is not a type but just an attribute of a type, on the mainframe system it is considred as a type. Also, it seems that they are changing some rules so I'll wait to se how my colleague is doing. Thanks Stephane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 30, 2003 2:38 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: Re: Data denormalisation seems some attractiveImportance: HighStephane, From the limited information available, I will take a stab at what seems to be going on here. I don't think there are really 8 entities here first of all, at least not for the details given. No mention is made of the person being paid the commission, who the sale was too, the items sold, etc. It would appear that there is a commission entity. When it comes to commission types though, I don't understand why there are 7 entities. What if a new commission type appears? Modify the model? This doesn't sound like a flexible solution. Please don't say it will never change: that statement has been rendered false too many times. :) Since I don't know what differentiates one type of commission from another, it's a little difficult to say just how to proceed from here. Keeping it simple, a single entity with sufficient attributes, some nullable, to capture all needed commission type info. I thought about mocking up an example for this exercise, but it would be much easier and more productive if you could provide some relevant details on the commission types, with an explanation of why it's thought that separate entities are needed for each. Jared "Stephane Paquette" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2003 07:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data denormalisation seems some attractiveHi,A co-worker of mine is working on a tiny project.Let say you have commission info and commission details, there are 7 typesof commissions.The 7 types of commission shares common fields (from 100% to 30%)From a conceptual point of view, you have 1 entity that is the commissioninfo and 7 entities for the seven types of commissions since they all haveprivate info (some fields are mandatory)..1 commission must be 1 of the 7 types.Now at the physical level, info is write once, never update and read througha selective search criteria (agent number).Volume is about 8 000 000 commissions.You can have the physical model as the conceptual model.That means you do not have any work for managing integrity but when readingyou have more work to get the data.OrYou can put all data in 1 table with all fields.When data is inserted you must managed integrity (some common fields aremandatory for 1 type of commission but not for another one) but reading isfast just 1 record to read.Since, I do not know what the future of this project is I recommended theother DBA to keep data normalized.And to do a benchmark if he really wants to denormalize.Your opinions please.Stephane PaquetteAdministrateur de bases de donneesDatabase AdministratorStandard Lifewww.standardlife.caTel. (514) 499-7999 7470 and (514) 925-7187[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephane PaquetteINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux
Title: Message Hi, We're still on 817 but I was wandering about those new automatic features (Automatic Undo Management, Automatic Segment Space management,..) how well they work ? Anybody using in production with 9i2 ? Stéphane -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tanel PoderSent: Tuesday, September 30, 2003 5:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux You still can have row migration when pctfree is set too low. ASSM doesn't resolve that. But yeah, ASSM removes the pctused and freelist/group issues (and introduces others :) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Monday, September 29, 2003 7:09 PM Subject: RE: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux And why not? Forgetting about PCTFREE/PCTUSED is the main point of automatic segment space management. Initial/next are resolved by using LMT, because that's what takes care of your extent sizes. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard FooteSent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux Hi Mladen, I can't help you with your problem, I haven't had the pleasure on NT or Tru64 but I just wanted to point out that you can't forget about PCTFREE even with ASSM. Cheers Richard - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 30, 2003 12:44 AM Subject: SEGMENT SPACE MANAGEMENT AUTO hangs on 9.2.0.4 on Linux I have RDBMS 9.2.0.4 on RH 7.3 and Iexecuted the following command: create tablespace wizard datafile '/oradata/WIZ/wizard01.dbf' size 3072M reuse autoextend on next 1024M maxsize 16385m extent management local autoallocate segment space management auto; The whole system just hung, doing I/O like crazy. I was unable to killl one of the server processes which survived even shutdown abort, so I had to bounce thw whole box. No errors, no traces, no anything. Does anybody else have experience with this? Is there a known bug (not currently known to me) with a patch that I can install? I'd really like to use "SEGMENT SPACE MANAGEMENT AUTO" and forget about pctfree/pctused stuff. --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: COBOL TO ORACLE
Mladen, maybe it is the past for you but it is quite the present for me. We just decided between 2 packages (insurance industry): one in cobol using flat files on AS400 and the other one where all jobs are in cobol but the database is Oracle. We have choose the second one. So, in the next week, I'll install Oracle Pro*Cobol on the unix boxes and then support the people having precompilation problems. Youppi ! Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Tuesday, September 30, 2003 5:15 PM To: Multiple recipients of list ORACLE-L On Tue, 2003-09-30 at 16:19, Stephane Paquette wrote: Like Thomas Day said, Oracle is an rdbms and COBOL a programming language. COBOL *** WAS *** a programming language. Horse *** WAS *** basis of transport. You should have used past tense, Stephane. I'm not really that partial when it comes to horses, but having suffered COBOL, I would really leave it in the ancient past, together with Spanish Inquisition and crucifiction as a viable capital punishment. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Using dimensions
Title: Using dimensions I`ve not used dimensions in Oracle only read about them. But I have designed DW using dimensional modeling. So from what I've read in the doc, Oracle will used the dimensions to be better atquery rewriting because it knows the hierarchy of the data (example : neighbourhood, city, region, province, country) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Monday, September 29, 2003 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: Re: RE: Using dimensions Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ uses of dimensions ... where does one use them? in SQLs? I have scannedTFM, but haven't STFW'd yet ... scared of too many hits. Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Scott Canaan [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I don't see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AMTo: Multiple recipients of list ORACLE-LSubject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) .. Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
Cursed Oracle 9i installation on windoze
Hi, I can't believe I'm loosing that much time installing Oracle 9i on my pc at home. PC is AMD Athlon/windows 2000 I've downloaded Oracle 9i release 2 from technet. When running setup.exe I have the following message The Java RunTime Environment was nout found at: C:\DOCUME~\ADMINI~\LOCALS~1\Temp\OraInstall\jre\bin\jawaw.exe. Hence the Oracle Universal Installer cannot be run. Please visit Then, I've removed all Oracle stuff (OWB, Oracle 8i,..) that I had following metalink note. I've cleaned the path, the registry, the environment variables,... It still doesn't install, even if I run from ../install/win32/setup.exe Any ideas ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Offshore protests + Idle events (to keep it On-track!)
Can you elaborate on fixing the STATS$IDLE_EVENT table. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Kirtikumar Deshpande Sent: Tuesday, September 23, 2003 2:15 PM To: Multiple recipients of list ORACLE-L If I install statspack, I always 'fix' the STATS$IDLE_EVENT table, and also change the varibale top_n_events to 10 (from 5) in spreport.sql. Statspack is a very generic tool. One must 'tune' it to reflect ones environment... :) - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Dan, You said that very well (as usual). The problem is that Management doesn't usually see the downside of their downsizing actions until the stuff hits the fan. And Larry's statements about self-tuning databases are not helping as well - they help apply pressure on a dwindling market, whether real or apparent. The ability to communicate complex problems in simple, everyday language will _always_ stand you in good stead - whether to the business, to management or your fellow workers. I recently replied patiently without sarcasm to a question on an internal Java user group about why compiling procedures/packages when users are online is a bad idea - I could have been rude and told the largerly development audience off. The VP of Development was on that list (I didn't know about this) and wrote me a nice complimentary note. I hope to stand well when there is a shake-up later on :) On Idle events - I had a situation previously when I was remotely diagnosing a performance issue and noticed a large number of PQ related idle events. Turns out that the DBA had switched on PQ to make the queries 'run faster' - the two CPU server was just choked to death after this. These 'idle' events from a Statspack report helped me solve the issue (turn off PQ on all tables - it was an OLTP system). John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Offshore protests + Idle events (to keep it On-track!)
thanks -Original Message- Kirtikumar Deshpande Sent: Tuesday, September 23, 2003 2:45 PM To: Multiple recipients of list ORACLE-L I remove from this table the events deemed not idle for the database and Application supported by it. SQL*Net message related events can be important in client/server type environments. HTH, - Kirti --- Stephane Paquette [EMAIL PROTECTED] wrote: Can you elaborate on fixing the STATS$IDLE_EVENT table. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Kirtikumar Deshpande Sent: Tuesday, September 23, 2003 2:15 PM To: Multiple recipients of list ORACLE-L If I install statspack, I always 'fix' the STATS$IDLE_EVENT table, and also change the varibale top_n_events to 10 (from 5) in spreport.sql. Statspack is a very generic tool. One must 'tune' it to reflect ones environment... :) - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Dan, You said that very well (as usual). The problem is that Management doesn't usually see the downside of their downsizing actions until the stuff hits the fan. And Larry's statements about self-tuning databases are not helping as well - they help apply pressure on a dwindling market, whether real or apparent. The ability to communicate complex problems in simple, everyday language will _always_ stand you in good stead - whether to the business, to management or your fellow workers. I recently replied patiently without sarcasm to a question on an internal Java user group about why compiling procedures/packages when users are online is a bad idea - I could have been rude and told the largerly development audience off. The VP of Development was on that list (I didn't know about this) and wrote me a nice complimentary note. I hope to stand well when there is a shake-up later on :) On Idle events - I had a situation previously when I was remotely diagnosing a performance issue and noticed a large number of PQ related idle events. Turns out that the DBA had switched on PQ to make the queries 'run faster' - the two CPU server was just choked to death after this. These 'idle' events from a Statspack report helped me solve the issue (turn off PQ on all tables - it was an OLTP system). John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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
RE: possible to have a primary key with a bitmap indx?
A bitmap index is for a low cardinality column, so I doubt it would be a good idea to use it to enforce a primary key. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 4:55 PM To: Multiple recipients of list ORACLE-L is it possible to have a primary key that is enforced with a bitmap index? if so what is the syntax? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: [Q] need help on SQLplus select distinct !!
select distinct column1, columnn2 , ... from table; Stephane -Original Message- mike mon Sent: Tuesday, September 23, 2003 11:00 AM To: Multiple recipients of list ORACLE-L I plan to select distinct data from table. anyone has suggestion? Thanks. select distinct employee from (select employee_id, lname, fname, mi, hiredate , as employee from emp) SQL SQL / from (select employee_id, lname, fname, mi, hiredate , as employee from emp) * ERROR at line 2: ORA-00936: missing expression __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Reducing the number of databases
Hi, We have around 120 databases. Most applications have 5 environments (dev, test, integrated test, acceptance, prod) some applications have more.The applications are a mix of home developped and bought application (peoplesoft, harvest, compass,...) New applications are coming in. New databases will appear soon with DB2UDB. All servers are unix/aix, there are15 production server and around 10 servers for the dev, test, integrated test and acceptance databases. All databases are at 8172 except 6-7 databases and planning to go to 9i in 2004. Off course we see the migration like a pain. We want to reduce the number of databases and instances. To obtain a significative gain I think we must reduced to around 60 databases. Anybody has done the task to consolidate on less servers and les databases ? One way to do it would be to go with 2 instances of dev 2 instances of test 2 instances of integrated test 2 instances of acceptance all prod instances are standalone. Food for thought backup Oracle version availability naming convention of objects security ... All feedback is welcome. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 et (514) 925-7187 [EMAIL PROTECTED]
RE: Connect to a remote database without a link
Title: Message You can always use sqlplus copy command to bring back some data without a db link. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor) (DAASC)Sent: Tuesday, September 16, 2003 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: Connect to a remote database without a link Does anyone have an example of connecting to a remote database without a database link? I think that I have seen it done before by putting in the username and password and tnsnamesconnection information right into the select statement. Can it be done? Tom
RE: I know its early since OOW is just over BUT
Title: RE: I know its early since OOW is just over BUT Since in its Canada, I'll definitively ask my boss to go. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Monday, September 15, 2003 5:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: I know its early since OOW is just over BUT As of now, I'm planning on going, but as always, that is subject to the whims of Damagement. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended. All Targets Met. All Systems Working. All Customers Satisfied. All Staff Enthusiastic. All Pigs Fed And Ready To Fly. -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED]] Sent: Monday, September 15, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Subject: I know its early since OOW is just over BUT Is anyone planning on going to IOUG conference in Toronto, CA, next spring(2004)??? Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
RE: Copying statistics : used a lot ????
Well no, I have bought the Expert one on one book. I check on his web site and I found one reference where he addresses the use of changing the stats. Usually you can find what is its opinion just by the tone, but this time I was not able to see if he's against or not on this. Can you share more of what's in the book ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Grabowy, Chris Sent: Thursday, September 11, 2003 5:44 PM To: Multiple recipients of list ORACLE-L By chance, do you have Tom Kyte's latest book? Effective Oracle by Design?? He states his opinion on this approach on page 30, section entitled Test Against Representative Data. -Original Message- Stephane Paquette Sent: Thursday, September 11, 2003 4:38 PM To: Multiple recipients of list ORACLE-L HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test environment to see what will be the access plan. If not used, why ? no time to look at it, bugged, not usefull ,... ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: DB2 has a foot in the door
://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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: DB2 has a foot in the door
is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: DB2 has a foot in the door
There is at least 2 Stephane : Stephane Faroult (Oriole), Stephane Paquette (Standard Life) Stephane -Original Message- Mladen Gogala Sent: Thursday, September 11, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Standard life? I thought that you work for Oriole corp.? -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: Thursday, September 11, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: RE: DB2 has a foot in the door I used to work for a large but non profit organisation (.org) and we were using Oracle, the sales rep never send us Christmas card for sure Stephane -Original Message- Mladen Gogala Sent: Thursday, September 11, 2003 11:30 AM To: Multiple recipients of list ORACLE-L There should be a low level pricing for home users, so that people who download oracle may use metalink. I would pay for home support if it was something like $150/ year for my Linux box. There should also be a low price for small companies wih 16 users. One should be able to buy a 16 users license for around $2000. I know a caterer that went with SQL Server because of the price and development tools availability as well as the atitude of the salesman that he turned to. I know that a small CT caterer with 9 employees is not Merryl-Lynch or Chase, but it is a business nevertheless and having a database in there buys a mindshare. Caterers have to keep track of the orders, ingredients and schedules and they do need a database. At present, there is a condescending attitude toward those people and that only helps our favorite company in Redmond, WA. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Goulet, Dick Sent: Thursday, September 11, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: RE: DB2 has a foot in the door I believe Mr. Ellison is responding to a lot of market pressure, and failing DB sales. I know it would be a relief here to see this inplace soon, but as always the DEVIL is in the details. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 10, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Nope, that's what voting machines are invented for. They work almost perfectly in almost every state. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nuno Pinto do Souto Sent: Wednesday, September 10, 2003 6:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: RE: DB2 has a foot in the door Boivin, Patrice J [EMAIL PROTECTED] wrote: Something like that at the bottom of this article: http://www.computerworld.com/news/2003/story/0,11280,84773,00.html Counting processors is very hard. It's very hard to count users I thought that's what count(*) was invented for? Larry can truly be the Prime Minister of the Bleeding Obvious when he wants... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network
Copying statistics : used a lot ????
HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test environment to see what will be the access plan. If not used, why ? no time to look at it, bugged, not usefull ,... ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: how can I see which database I am logged into without
Title: RE: how can I see which database I am logged into without
When
the database was cloned from prod, did the global name changed (alter databeas
db rename global_name to ...)
Maybe
ora_database_name takes it from global_name.
Stephane Paquette
Administrateur
de bases de donnees
Database
Administrator
Standard
Life
www.standardlife.ca
Tel.
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of David
WagonerSent: Thursday, September 11, 2003 3:34 PMTo:
Multiple recipients of list ORACLE-LSubject: RE: how can I see
which database I am logged into without
You might get some surprising results from SELECT
ORA_DATABASE_NAME FROM DUAL; (see below). I have a DEV database cloned
from Prod. and it still lists the Prod. DB name with that query. Where
is it reading the name from? You can see that other queries produce the
"correct" name.
SQL select instance_name from v$instance;
INSTANCE_NAME
dmedi01
SQL show parameter name;
NAME
TYPE VALUE ---
-- db_file_name_convert
string db_name
string dmedi01 global_names
boolean FALSE instance_name
string dmedi01 lock_name_space
string log_file_name_convert
string oracle_trace_collection_name
string oracle_trace_facility_name
string oracled plsql_native_make_file_name
string service_names
string dmedi01.arsenaldigital.com
SQL select ora_database_name from dual;
ORA_DATABASE_NAME
PMEDI01.ARSENALDIGITAL.COM
Best regards,
David B. Wagoner Database
Administrator Arsenal Digital Solutions
-Original Message- From:
GovindanK [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 10, 2003 10:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: how can I see which database I am logged into
without
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH GovindanK
select sys_context('USERENV','DB_NAME') from
anytable; At
10:49 AM 9/10/2003 -0800, you wrote: hi. I think there was a dbms package to get some of
the environment variables for a session, but I
can't remember anyhting specific. If someone
know what I'm talking about and has any
details, please Email me or post here
thanks
Gene
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation http://www.centrexcc.com
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: GovindanK INET:
[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).
RE: RE: DB2 has a foot in the door
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: DB2 has a foot in the door
I'm interested in the report also. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Goulet, Dick Sent: Wednesday, September 10, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Dennis, Do you have the source of this report??? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, September 10, 2003 12:10 PM To: Multiple recipients of list ORACLE-L The following may be pertinent to the current discussion of Oracle pricing models. Ellison sees new software pricing model Posted September 10, 5:07 a.m. Pacific Time SAN FRANCISCO -- The model of pricing enterprise software on a per-processor basis should be replaced with a flat annual fee that allows businesses to use as much software as they want, Oracle Corp.'s chairman and chief executive officer Larry Ellison said Tuesday. It becomes very hard to count processors and to count users, Ellison said, responding to a question on the future of software pricing at the OracleWorld show. Where I think we'll go is towards enterprise licensing. ... You pay an annual recurring fee and use as much software as you want, and I think that's a much more sensible model to use. In News -Original Message- Sent: Wednesday, September 10, 2003 9:39 AM To: Multiple recipients of list ORACLE-L For 9iAS, you have to get the whole bundle. It doesn't include Excedrin, so desperately needed by anybody unfortunate enough to have to deal with 9iAS. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: DB2 has a foot in the door is SE alot more affordable than EE? CAn you un-bundle Oracle software and just buy the pieces you want to use or do you always have to buy the whole bundle? what about 9iAS? do you have to buy the whole bundle or can you just get pieces? From: Hitchman, Peter [EMAIL PROTECTED] Date: 2003/09/10 Wed AM 09:54:35 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: DB2 has a foot in the door Hi, I looked into SE but found that Oracle would not allow it to be used on a machine that has 4 or more CPUs or can support that many CPUs, which for this company is a problem because we generally run Oracle on Sun servers. Don't know if that has changed now with later Oracle releases. Regards Pete -Original Message- Sent: 10 September 2003 13:21 To: Multiple recipients of list ORACLE-L When negotiating site licensing, does Oracle encourage the customers to buy EE licences? Or can people negotiate for a mix of EE or SE. Just curious, I don't know how that would work -- not very compatible with OracleStore, it seems to me. Patrice. -Original Message- Sent: Wednesday, September 10, 2003 5:59 AM To: Multiple recipients of list ORACLE-L We also has site licensing. It was done 3-4 years ago. Maybe Oracle changed tactics since then. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: 10g
You're up to 3 wishes and then it will crash ... I wonder if you have to rub the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Jesse, Rich Sent: Tuesday, September 09, 2003 10:35 AM To: Multiple recipients of list ORACLE-L Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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: overloading and = comparisons in SQL
You can have in a where clause a varchar2 column compared to a number column , if the varchar2 column only contains numeric then it will work. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Boivin, Patrice J Sent: Tuesday, September 09, 2003 4:49 PM To: Multiple recipients of list ORACLE-L I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: DB2 has a foot in the door
All servers are running IBM Aix here, so I hope DB2 UDB will work correctly. For the price, IBM is giving us 25% cheaper any Oracle price. The database will be bundled with all IBM's BI software. On the negative side, DB2 has not a big and accessible community like Oracle. On the web you can find a lot of good Oracle sites (orapub, hotsos, Steve Adams, J lewis, Miracleas,...) and this list , with DB2 the community is way smaller. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Ryan Sent: Sunday, September 07, 2003 2:55 PM To: Multiple recipients of list ORACLE-L how does DB2 compare to oracle cost wise? what about hard ware? does db2 require more hard ware than oracle does? how does its features compare? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 2:24 PM One of my previous employers had a site license. Not a huge site, but not too small either. About 5000 employees, lots of IT in that business. Not only a site license, but a 72% discount. We had a *good* negotiator. Jared On Sun, 2003-09-07 at 00:34, Mogens Nrgaard wrote: There's one thing that IBM can do, which Microsoft and Oracle can't offer: They do site licenses as well as cpu and user licensing. That just gives them an incredible advantage to management and others who can stop thinking about whether they should buy another server, move stuff from one server to the other, etc. I can't believe Oracle and Microsoft are not doing it (I think I can guess, but it's still not good). Mladen Gogala wrote: I believe that the answer to Stephane's question is obvious: Oracle 10g will cost 10 grands/ CPU. That's where the letter g is coming from. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Friday, September 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Stephane We've been very excited about Oracle Standard Edition. Helped stave off the interest in MS SQL. Given the budget pressures at many organizations, I'm surprised we don't hear more about this alternative. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing structure ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Ryan 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
RE: DB2 has a foot in the door
I had a 3 day training last year on db2 udb 7.2 when we were looking at it for a Siebel project who died. Yes, DB2 is not as Oracle who works the same on all platforms. I found db2 udb 7.2 missing basic functionnalities like there is no truncate table, you had to use the DB2 loader and load /dev/null in order to empty/truncate a table... The only time I used Oracle on different platforms was a while ago when we were using SQL*Forms 2.3 on DOS / Oracle 5 then moving the code to Oracle/MVS. Stephane -Original Message- Ryan Sent: Sunday, September 07, 2003 9:34 AM To: Multiple recipients of list ORACLE-L have you used DB2? How does it compare to Oracle? Ive seen tom kyte write that each platform that DB2 runs on is in essence a different database and you cant take code from one platform and move it to another. are the features comparable? what about cost? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 8:54 AM VERY interesting. They refused to do site licensing at a 2 installation here. Thank you for this tip. Rachel Carmichael wrote: Oracle does site licensing... but only if you are a very very large corporation. Citibank (when I worked there) had one. The company I work for now has one. So I don't ask do we have a license when I want to install a new version of Oracle, even if it is a new platform One of the few things that is easier working in a rigid corporate environment --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: There's one thing that IBM can do, which Microsoft and Oracle can't offer: They do site licenses as well as cpu and user licensing. That just gives them an incredible advantage to management and others who can stop thinking about whether they should buy another server, move stuff from one server to the other, etc. I can't believe Oracle and Microsoft are not doing it (I think I can guess, but it's still not good). Mladen Gogala wrote: I believe that the answer to Stephane's question is obvious: Oracle 10g will cost 10 grands/ CPU. That's where the letter g is coming from. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Friday, September 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Stephane We've been very excited about Oracle Standard Edition. Helped stave off the interest in MS SQL. Given the budget pressures at many organizations, I'm surprised we don't hear more about this alternative. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing structure ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services
RE: Offshore threat
By business as usual, I meant that executives always try to save money and will always do. Now, IT is targeted. And pepople in IT find that very difficult because the pay has been very good since 5-7 years and most people thought it would last forever. Now it's time to wake up and see that IT is becoming a job like another where you most hold to your job instead of going to job interview just for fun. Since Canada is always behind, that offshore thing will start kicking in a few months here :-( Stephane -Original Message- Nuno Souto Sent: Friday, September 05, 2003 9:35 AM To: Multiple recipients of list ORACLE-L Well, you could find a job in Canada, no? Can you find one in India too? I don't think so. So it's not business as usual. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - When working at International Air Transport Association (IATA), the company moved around 60 jobs from Geneva and London to Montreal because it was cheaper here. This is all business as usual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: How can I measure my DB performance.
15 minutes ! All our production db are set up at 1 hour interval. A summary of the stats are centralized in 1 db and we keep that 2 months. We go down to 10-15 minues to investigate problems. I find a 15 minutes interval very short. Thanks for the link to yapppack. We do a similar thing using a chart software. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 4:05 PM To: Multiple recipients of list ORACLE-L I too have mine setup to take a snapshot every 15 minutes. Can you teach me how to automate purges using sppurge.sql ? Thanks . - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 06:04 Start by installing and configuring statspack. I have mine setup to take a snapshot every 15 minutes. It collects a lot of data, I am now in the midst of automating a purge process. :) Then implement YAPPPACK from http://www.miracleas.dk/en/tech.html and use the data to create response time charts. At least, that's one way to do it. Jared Jake Johnson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/28/2003 04:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How can I measure my DB performance. Is there a standard query I can run to compare the performance of a db. (Kind of like bogomips for unix) Thanks, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Tires, and Wheel Packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jake Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
DB2 has a foot in the door
Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing structure ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: c based external procedures vs. Java Stored Procedures
We have tested a product this winter that was using an external C proc to call cobol programs. Stephane -Original Message- Jared Still Sent: Thursday, September 04, 2003 11:34 AM To: Multiple recipients of list ORACLE-L One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach. There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Stephane Paquette 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: Offshore threat
When working at International Air Transport Association (IATA), the company moved around 60 jobs from Geneva and London to Montreal because it was cheaper here. This is all business as usual. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mercadante, Thomas F Sent: Thursday, September 04, 2003 2:50 PM To: Multiple recipients of list ORACLE-L This is all very funny and interesting. Anybody read the story in yesterday's NY times? Mexica has a concern that their textile industry is being stolen by China because it is cheaper to make products there than in Mexico. Sound familiar? This is the business we have chosen to be into Himen Roth (and I know spelled his first name wrong). -Original Message- Sent: Thursday, September 04, 2003 2:10 PM To: Multiple recipients of list ORACLE-L It doesn't work in only one direction. While jobs are bieng lost to cheaper labor markets, Indian companies now have to compete with frighteningly efficient giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others. Local companies are losing the market and have to reduce their workforce, driving the cost of labor further down and closing the vicious circle. What is scary is the fact that we are an order of magnitude more efficient then the rest of the world, even with all our PHB's and damagement. How messed up is everybody else? The only difference between a US DBA and a cleaning leady, which has also been replaced by an immigrant a long time ago, is the fact that the DBA has easier access to the DBA mailing lists. If we weren't crying foul then, there is no need to do it now. We will simply have to adjust and do something else. The first thing that comes to mind is becoming a lawyer. When I want to sue somebody, I'd like to be represented by a cutthroat yankee lawyer, not by a very polite and non-aggressive gentleman from India. Lawyers do need a killer instinct, DBAs do not. For those of us who have it, it's more of a hindrance then a useful tool. Lawyers and politicians, fortunately for Indians, will never be outsourced to India. Here is our chance. -- Mladen Gogala Oracle DBA -Original Message- Souto Sent: Thursday, September 04, 2003 12:55 PM To: Multiple recipients of list ORACLE-L LOL! Funny how this globalisation bull only works in one direction, eh? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - ** Another programmer who lost his job to an Indian outsourcer is willing to relocate in India. But Indian officials have told him they don't hire Americans. Read about another politicized IT worker in No Americans Need Apply. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
RE: decode
Use greatest ... decode(greatest(sn,7),sn, substr(sn,-7),sn ) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Imran Ashraf Sent: Wednesday, September 03, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Hi, I have this query... select decode(length(sn),8),substr(sn,-7),sn )from . However i want to change it so that if the length of sn is = 8 then set sn to last 7 characters. How can i implement this? Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Urgent INFO needed.
That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Tony JohnsonSent: Wednesday, September 03, 2003 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Urgent INFO needed. All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message-From: Ora DBA [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 03, 2003 5:30 AMTo: Multiple recipients of list ORACLE-LSubject: Urgent INFO needed. Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software
RE: Application DBA
Title: Message Usually, the term used is devlopment DBA. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Boivin, Patrice JSent: Tuesday, September 02, 2003 3:54 PMTo: Multiple recipients of list ORACLE-LSubject: "Application DBA" Someone sent me this URL when I mentioned that there may be Application Administrators, but no Application DBAs. http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/StyleGuide/SECURITYANDACCESSPOLICY.htm Patrice.
RE: ERD to O-O
It's www.dulcian.com Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- DENNIS WILLIAMS Sent: Wednesday, August 27, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Melissa - Paul Dorsey of Dulican, Inc. has spoken on tools they have developed in this area. Dulican's web address should be www.dulican.com http://www.dulican.com , but I don't get a response. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 27, 2003 9:44 AM To: Multiple recipients of list ORACLE-L I working on a development project that I'm trying to take an ERD an convert it to object oriented. Does anyone know a tool or path to follow to accomplish this? TIA Jared Still [EMAIL PROTECTED] wrote: Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do! some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). _ Do you Yahoo!? The New http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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: About trcanlzr
Corrupting would have been sending the damned dbmssupp.sql and its plb file. Stephane -Original Message- Mladen Gogala Sent: Monday, August 25, 2003 5:49 PM To: Multiple recipients of list ORACLE-L I'm corrupting youth. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Monday, August 25, 2003 5:00 PM To: Multiple recipients of list ORACLE-L MessageThanks, I just try it and works well. Stephane -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mladen Gogala Sent: Monday, August 25, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: About trcanlzr Well, there is always ORADEBUG SESSION_EVENT. Granted, it's not as elegant as set_ev, but it works. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: Monday, August 25, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: About trcanlzr Hi, I just start testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility on oracle-l , that's why I went on orafaq where there is only a post by Jamadagni Rajendra Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: About trcanlzr
I was not getting result from set_ev because I used set_ev(sid,serial,10046,8,null) instead of set_ev(sid,serial,10046,8,'') I thought that null and '' can be usedwithout difference. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Cary MillsapSent: Monday, August 25, 2003 6:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: About trcanlzr FWIW, set_ev has produced over 2,000 trace files on Oracle8i that Ive seen Using DBMS_SUPPORT is probably a better idea anyway, though. Note, however, that the procedures in DBMS_SUPPORT just make calls to SET_EV. Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Hotsos Clinic101 in Sydney- Hotsos Symposium 2004 March 710 Dallas- Visit www.hotsos.com for schedule details... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane PaquetteSent: Monday, August 25, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: About trcanlzr Hi, I juststart testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility onoracle-l , that's why I went on orafaq where there is only a post by Jamadagni Rajendra . I just open a tar to get the dbms_support script to enable 10046 tracing in other session as dbms_system.set_ev is not working here (8172 aix) but Oracle says it is only legitimate to use it on 9i. So, any feedback on trcanlzr scripts andis it normal thatdbms_system.set_ev is not working on 8172 ? Any workaround ? I've 9i relaease 2on my pc, I guessI can copy the dbmssup.sql and prvtsupp.plb over the 8172/aix databases, yes/no ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]
RE: Query results to .csv/use of dblinks
You can also close the dblink to avoid having many open idle sessions on the remote database. alter session close database link dblink; Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Rafiq Sent: Tuesday, August 26, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Tanel, A quick question? How many open dblinks you have used at one time without any issues? Default setting in init.ora is 4(if I am not wrong) and I never used it more than that. If Dennis wants to use more than 4 dblinks at one time, he should modify this param(open_dblinks) in init.ora, right. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 26 Aug 2003 09:14:26 -0800 Hi! What is your goal? To finish data transfer in the shortest time or keep hardware utilization maximum during transfer? I think you should concentrate on keeping the time for doing data transfer low. Depending on your network - in case of gigabit (or 10 Gb) you could look at enabling jumbo frames, which enable ethernet packets up to 9000 bytes. Also set (SDU=32768) in your listener and tnsnames.oras (you can set it with normal 1500 byte frames as well). About parallellism, you might want to run several bulk inserts over dblink to fully utilize your network (fill the gaps when one session is busy inserting, thus not using the network). But if your source disk array (or CPUs) are slow then they might be the bottleneck. If you got SAN and a temporary spare server, do a BCV copy or mirror split, open up several clones of a database and copy data from all of them. Also, when you have SAN, there's no need for network transfer at all - you just mount the filesystem with dump/exportfiles on target database and do the load from there. If your operating systems are different, then just dump to raw device, with pipe and tar for example, or completely raw, remembering your data sizes. Note that in some (older) operating systems there were few blocks in beginning of device which were used (and written) by operating system (Tru64 had the largest I know - 64k). Thus you had to make sure you didn't write anything there (oseek=65536 for dd for example). If downtime isn't an issue for you, it might not be worth trying above recommendations, but in RVLDBs (really very large databases) all of this can help a lot. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 5:54 PM Taniel, Binley Thanks for the excellent suggestions. At this point we have been testing with two smaller test systems, moving a single table at a time, but initial indications are that the performance order is: 1. Perl dump to CSV / ftp / SQL*Loader 2. Copy across database link 3. Export/ ftp / import I need to re-run the tests once the target production system is available to re-confirm which is faster. I am pretty confident in the ability to run multiple SQL*Loader and import sessions simultaneously. I am a little nervous about the ability of the database link to scale to enough simultaneous sessions to keep the RAID sets maxed out on the target system. Several years ago when I was doing a large conversion I hit that limit. Some days I wonder if we are the beneficiary or victim of our prior experience. Oh well thanks for all the good suggestions, on to testing, testing, testing. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 25, 2003 7:09 PM To: Multiple recipients of list ORACLE-L Hi! What about several insert /*+ APPEND NOLOGGING */ commands over database link run in parallel? (Possibly over dedicated network). This is fast and is easier (in case you don't hit any compatibility problems). If you happen to be running on Windows for some reason, you could try to use named pipes network protocol instead of TCP as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 25, 2003 11:04 PM Thanks Tanel We will undoubtedly use export/import for the many small tables. We are looking for alternatives that will perform even faster. The insert phase seems to be the slowest part, and that is where SQL*Loader in direct path really shines. Now the next issue is how to produce a CSV file as fast as possible, and so far it looks like Jared's Perl program is the clear winner. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 25, 2003 1:05 PM To: Multiple recipients of list ORACLE-L Hi! Spooling from sqlplus is VERY slow. Is the source
RE: Tough Oracle DBA experience
I agree with Stephane, I faced great technical challenges in plumbing too, boy can water do a mess ! In IT you're confortably sit with a pad for your wrist and a mouse with that roller thing in the middle. In plumbing, the damn pipe is always hard to reach ... On the other hand I find myself pretty good with a VCR. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Stephane Faroult Sent: Sunday, August 24, 2003 4:15 PM To: Multiple recipients of list ORACLE-L Veeraraju_Mareddi wrote: Dear All, Thanks for ur responses. But I am expecting technical problems , Technical Challenges a DBA has faced in his life , apart from problems with others. Please respond. Thanks Rajuveera Plumbing. Some of the toughest technical challlenges I have met were linked to plumbing. Programming the VCR, too. And using about any phone today. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
About trcanlzr
Hi, I juststart testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility onoracle-l , that's why I went on orafaq where there is only a post by Jamadagni Rajendra . I just open a tar to get the dbms_support script to enable 10046 tracing in other session as dbms_system.set_ev is not working here (8172 aix) but Oracle says it is only legitimate to use it on 9i. So, any feedback on trcanlzr scripts andis it normal thatdbms_system.set_ev is not working on 8172 ? Any workaround ? I've 9i relaease 2on my pc, I guessI can copy the dbmssup.sql and prvtsupp.plb over the 8172/aix databases, yes/no ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]
RE: About trcanlzr
MessageThanks, I just try it and works well. Stephane -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mladen Gogala Sent: Monday, August 25, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: About trcanlzr Well, there is always ORADEBUG SESSION_EVENT. Granted, it's not as elegant as set_ev, but it works. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: Monday, August 25, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: About trcanlzr Hi, I just start testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility on oracle-l , that's why I went on orafaq where there is only a post by Jamadagni Rajendra
RE: Performance Problem
Was it always slow ? Are you monitoring specifics jobs ? If so, have you run tkprof your main SQL statements ? When running, what are the main ressources Oracle is waiting on ? Have you monitor from the OS ? Are you IO bound or CPU bound ? Cost base optimiser in 805 is not as good as on 8i or 9i. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Burton, Laura Sent: Monday, August 25, 2003 4:49 PM To: Multiple recipients of list ORACLE-L We currently have an application we are trying to speed up. In researching rule/cost based optimizers, I read that the cost based optimizer was the way to go (although rule had its moments) because that is where Oracle would be focusing any upgrades, enhancements, etc. So I analyzed all tables and indexes. It brought our application to a stand still!! I then deleted the statistics and the application ran like before...slow. I know that I must have missed something although it seemed so straight forward. I verified that all tables were analyzed because I read that this would cause an extra step if all the tables were not analyzed. The database is Oracle 8.0.5. This weekend I will be upgrading to 8.1.7. The operating system is NT 4.0. Does anyone know something that could point me in the right direction? Thank you for your help. Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Burton, Laura INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Nature of Oracle-l has changed
That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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: Nature of Oracle-l has changed
It also seems that once the big canned application are up and running, companies are outsourcing more and more the operations. Those canned applications need to be integrated and that's the best and last place where DBA and dev people can be today, in the BI place. Here, in the architecture principles we are buying instead of developping. That's easy to do for payroll and that kind of stuff. But when you have over 20 bought applications, you need something to integrate all this to an ODS and or DW. And those 2 are not in the canned application market (not yet, I've heard from an Oracle DW consulting manager that Oracle wants to automate that part also). Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, August 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: (long) Design question, historic and views
long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Design question, historic and views
The message did not generate many feedbacks. Any feedback is welcome on the historic and views questions. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 19, 2003 10:37 AM To: [EMAIL PROTECTED] Hi, In an ODS, it is feed in near real time during the day and pushes data to the DW and other systems at night. So it may need to keep several copies of the same data (several changes or the DW can be offline so the the ODS may need to keep several days). All tables have a surrogated PK and the PK from the source systems are used as alternate non-unique keys. All tables will have a DW_transfer indicator (yes/no) There are 2 designs I can immediately think of : 1. I keep all the data in the same table and I use fields like last_version_indicator (yes/no), start date, end date. This is fast since it implies inserting the new record and updating the previous record. 2. The last version for each rows are kept in a table and the historic are kept in a second table.Each table has its historic table. This implies inserting in the core table, insert the previous record in the historic table and deleting it. 3. another way ? The ODS must answer the following: All changes need to be transferred to the DW not only the last version. End-users will query the ODS (I do not know yet if queries will access only the last version or not). Views. In the case the solution1 is used. Would you used views to do the following table_t : the table table_last_version_v : view showing only the last version (with where last_version_indicator='YES'), used for queries. In both cases, would you used a view table_not_transferred_v : view showing records with the DW_transfer_indicator set to no, that view would be updated by the ETL processes or let the the programs do the where DW_transfer_indicator=no. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Row level security and latch waits
Title: Row level security and latch waits I've developped 3 functions for fined-grain access control and the users have tested them. There are only 3-4users in the acceptance env. and I did not noticed anything. What version are you running and how many users ? We're on 8172 Someday it will go in production here... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Tuesday, August 19, 2003 11:19 AMTo: Multiple recipients of list ORACLE-LSubject: Row level security and latch waits hi all, in the latest code release, a group implemented RLS and since then spotlight is constantly flagging 'latch waits' in the system. Yesterday the latch waits were upwards of 90%. Most active sessions seem to run the policy function defined as part of RLS. The worst part was all this wait was only on one node, the other node was healthy. While we are trying to capture more information, anything else that we can do? Any ideas? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
Design question, historic and views
Hi, In an ODS, it is feed in near real time during the day and pushes data to the DW and other systems at night. So it may need to keep several copies of the same data (several changes or the DW can be offline so the the ODS may need to keep several days). All tables have a surrogated PK and the PK from the source systems are used as alternate non-unique keys. All tables will have a DW_transfer indicator (yes/no) There are 2 designs I can immediately think of : 1. I keep all the data in the same table and I use fields like last_version_indicator (yes/no), start date, end date. This is fast since it implies inserting the new record and updating the previous record. 2. The last version for each rows are kept in a table and the historic are kept in a second table.Each table has its historic table. This implies inserting in the core table, insert the previous record in the historic table and deleting it. 3. another way ? The ODS must answer the following: All changes need to be transferred to the DW not only the last version. End-users will query the ODS (I do not know yet if queries will access only the last version or not). Views. In the case the solution1 is used. Would you used views to do the following table_t : the table table_last_version_v : view showing only the last version (with where last_version_indicator='YES'), used for queries. In both cases, would you used a view table_not_transferred_v : view showing records with the DW_transfer_indicator set to no, that view would be updated by the ETL processes or let the the programs do the where DW_transfer_indicator=no. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Design question, historic and views
It'a Bill Inmon type ;) (everything is normalized third normal form). The DW will probably want a mix of last version/all versions. Reporting or auditing may need to view all versions. What DW list, I used to be on 2 of them but not enough trafic. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- DENNIS WILLIAMS Sent: Tuesday, August 19, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Stephane What type of DW is this? Is a simple transaction system or is it more complex? What I'm asking is whether the individual changes are important or if only the last value is what you want stored. Actually, there is a good, active data warehousing list that would probably give you better answers. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 19, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hi, In an ODS, it is feed in near real time during the day and pushes data to the DW and other systems at night. So it may need to keep several copies of the same data (several changes or the DW can be offline so the the ODS may need to keep several days). All tables have a surrogated PK and the PK from the source systems are used as alternate non-unique keys. All tables will have a DW_transfer indicator (yes/no) There are 2 designs I can immediately think of : 1. I keep all the data in the same table and I use fields like last_version_indicator (yes/no), start date, end date. This is fast since it implies inserting the new record and updating the previous record. 2. The last version for each rows are kept in a table and the historic are kept in a second table.Each table has its historic table. This implies inserting in the core table, insert the previous record in the historic table and deleting it. 3. another way ? The ODS must answer the following: All changes need to be transferred to the DW not only the last version. End-users will query the ODS (I do not know yet if queries will access only the last version or not). Views. In the case the solution1 is used. Would you used views to do the following table_t : the table table_last_version_v : view showing only the last version (with where last_version_indicator='YES'), used for queries. In both cases, would you used a view table_not_transferred_v : view showing records with the DW_transfer_indicator set to no, that view would be updated by the ETL processes or let the the programs do the where DW_transfer_indicator=no. Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Stephane Paquette 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: Integration with IBM Mqueue series
I'm very interested in that question. We'll feed our ODS (Oracle) in near real time fashion using MQ-Series. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Rakesh Gupta Sent: Friday, July 25, 2003 10:54 AM To: Multiple recipients of list ORACLE-L One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Anybody using Silverrun ?
Hi, We're using Silverrun data modeling tool (RDM). I know that the Enterprise version has a central repository that allow to share the data models and other component. I'm used to Oracle Designer and Sybase PowerDesiger and liked those products. To the user of Silverrun Enterprise version, what are your feedbacks about it ? Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: 9iAS vs. Weblogic and Websphere
From past experiences, the only client I've seen using 9iAS is the one being Oracle wall to wall (and Oracle was a partner in the business, a big bio-tech startup). All the other clients running on Oracle databases were using BEA Weblogic or IBM Websphere. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- DENNIS WILLIAMS Sent: Wednesday, July 23, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Ryan I'm no Java expert and am willing to be corrected. My understanding is that Apache is just a web page server. The better comparison is between Tomcat and 9iAS. Since most web hits are for just static pages, you may even chose to have Apache front-end your 9iAS. Over Tomcat, 9iAS is J2EE compliant. Also more scalability. And if your company isn't ready for open source, 9iAS offers a big vendor to yell at. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 9:29 AM To: Multiple recipients of list ORACLE-L what functionality does 9iAS give you over just running apache? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:59 AM Ryan My impression is that 9iAS probably has the best database interface. The others look pretty primitive in comparison, basically just JDBC when you get to the bottom. Also, note that Oracle is currently running a special to lure WebLogic and Websphere users away. I think in this confusing, evolving market for application servers, a lot depends on your company's approach. If your company is highly committed to Oracle, then 9iAS is the logical choice. If you are highly committed to IBM, then Websphere is the logical choice. In our case we had to persuade people to move away from MS, and the argument was that you wouldn't be locked into one vendor, so the tendency has been to avoid Oracle for the non-DB pieces. I think the enterprise-scale AS are so complex that it is hard to compare feature-for-feature. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 22, 2003 10:54 PM To: Multiple recipients of list ORACLE-L I havent dug into 9iAS yet, but I want to learn atleast one of the major web servers. It appears that WebLogic and Websphere dominate the market. It also appears that 9iAS is tedious and has a poor design relative to these other two. What do you think? How different are the webservers? If I pick up one, does it translate? Also, what functionality does 9iAS add that Apache does not have in and of itself? I was able to run 9i Forms with just apache and OC4J? Ryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services
RE: dba age
Experience can be tricky, I know experienced DBA and developpers with a lot of years of experience and they're still junior in my mind, they're almost at the same level as when they started with Oracle. On the other hands,I know some people who have been DBA for 3 years and are very very good... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Wednesday, July 23, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak
RE: dba age
Same here, I'm 37 and the younguest one (also the one with the most hair !) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Freeman Robert - IL Sent: Wednesday, July 23, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in my group, and it seems like I'm always the youngest wherever I go... Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/23/2003 12:14 PM King Arthur: Old woman! Dennis: Man. KA: Sorry. Old man! Whose castle is that? D: I'm 37! KA: What? D: I'm 37, I'm not old! KA: Well, I can't just call you 'man'. D: Well, you could say 'Dennis'. KA: I didn't know you were called Dennis. D: You never bothered to find out, did you? At least I'm only on the cusp of 35. And I have 6 years experience with Oracle. I've lost whole databases, even, thanks to WindohsNoT running Oracle7. My experience tells me not to put Oracle on Windohs. YMMV. I've experienced upgrades, patches, and migrations -- oh my! I've experienced the joy that isn't OiD 9.0.2. I've experienced a developer who could have sworn he was in the test DB. I've experienced successful recovery with zero data loss and no downtime during core business hours. I've experienced AutoRAID. I've experienced BAARF. I've experienced Intel, Alpha, SPARC, and PA-RISC. Duhvelopers have experienced my wrath. I have experienced my own wrath during moments of Duh. I've experienced this list, with it's many helpful and some not so helpful members. And yet, there's so much I haven't experienced. Like lunch today. Standing in for Paul Harvey, I'm Rich Jesse. Good Day! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, July 23, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Now this one is difficult folks . what is average age of an experienced oracle dba ? -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: dba age
I remember UFI, RPT-RPF, Forms 2.0 (IAD-IAG-IAP), SQL-QMX (for what it last),ODL (Oracle Data Loader), but I do not remember SQLPME . What was it ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Gogala, MladenSent: Wednesday, July 23, 2003 2:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba age Wow, I remember UFI, iapgen and RPT/RPF, but I started in 1989. Do you remember SQLPME? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba age Let's see... I remember dirt.. I remember UFI. I remember version 4.1.0 that ran on DOS... PC, PC-XT.. Oracle since 1983... Good loaded question. Maks. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 23, 2003 12:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: dba age Now that's a LOADED question which I'm sure many a individual on this list will resist answering. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 23, 2003 11:55 AMTo: Multiple recipients of list ORACLE-LSubject: dba age Now this one is difficult folks . what is average age of an experienced oracle dba ? -ak
RE: comments on EXECUTE IMMEDIATE
execute immediate IS dynamic sql, it is just a new simpler synthax.
SDW.WORLD:sysset serveroutput on
SDW.WORLD:sysdeclare
2 v_count number;
3 begin
4 execute immediate 'select count(*) from dba_objects' into v_count;
5 dbms_output.put_line ('Count:'||v_count);
6 end;
7 /
Count:3681
PL/SQL procedure successfully completed.
SDW.WORLD:sys
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
Maryann Atkinson
Sent: Wednesday, July 23, 2003 2:59 PM
To: Multiple recipients of list ORACLE-L
Does anyone have any examples on use of EXECUTE IMMEDIATE
starting from small little ones?
Is EXECUTE IMMEDIATE more efficient than Dynamic SQL?
It certainly appears simpler to syntax, but would it be
wise to use it or prefer the stability of dynamic SQL?
thx
maa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Maryann Atkinson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
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: comments on EXECUTE IMMEDIATE
I just took 5 seconds to write an example.
If you want a real life example, write a stored proc to truncate table.
All DBA have done this one to allow the developpers to truncate any table in
a schema.
You can do it the old dynamic style or use execute immediate which is less
hassle.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
MaryAnn Atkinson
Sent: Wednesday, July 23, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
--- Stephane Paquette [EMAIL PROTECTED] wrote:
execute immediate IS dynamic sql, it is just a new simpler synthax.
declare
v_count number;
begin
execute immediate 'select count(*) from dba_objects'
into v_count;
dbms_output.put_line ('Count:'||v_count);
end;
Count:3681
I wouldnt use an execute immediate statement on a case like that.
I would just leave it as:
SELECT COUNT(*)
FROM DBA_OBJECTS
INTO v_Count;
I have a feeling Oracle wanted to provide different kind of
functionality with the execute immediate.
I saw somewhere else a case like the following:
Sql_Stmt := 'UPDATE table
SETcol1 = :parm1
WHERE col2 = :parm2';
EXECURE IMMEDIATE Sql_Stmt USING parm1, parm2;
-
which again I dont see any advantage. I would have just
coded the UPDATE statement without any indirection.
Both above examples give me indirection, thats all,
which I dont really think I gain anything by incorporating,
actually I feel I am losing...
thx
maa
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MaryAnn Atkinson
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Re[2]: dba age
I'm young but my memory is already going away :( -Original Message- Gogala, Mladen Sent: Wednesday, July 23, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Yup! SQL Protected Mode Executable, which loaded oracle above 1M boundary on 286 boxes. I believe that the last ones were produced for oracle 6. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 4:40 PM To: Multiple recipients of list ORACLE-L S I remember UFI, RPT-RPF, Forms 2.0 (IAD-IAG-IAP), SQL-QMX (for what it S last),ODL (Oracle Data Loader), but I do not remember SQLPME . What was it ? Ow! That makes my brain hurt. I think it was like Protected Memory Executive that allowed Oracle to run up in the above 1M region on 386's and in some special archetectures with 286's. I hadn't relived that nightmare in many years. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Increase tablespace, which way is better?
Title: Message Why not just resizing the file ? alter database datafile . resize 500M; Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Friday, July 18, 2003 4:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Increase tablespace, which way is better? what are u gaining in #1 . -ak - Original Message - From: Liu, Jack To: Multiple recipients of list ORACLE-L Sent: Friday, July 18, 2003 1:29 PM Subject: Increase tablespace, which way is better? Hi, I want to increase tablespace, just want to know which way is better:1. ALTER TABLESPACE SYSTEMADD DATAFILE '/u01/oradata/orcl/users02.dbf'SIZE 1MAUTOEXTEND ONNEXT 1MMAXSIZE 100M; 2.alter tablespace system add datafile '/u01/oradata/orcl/users02.dbf' size 100m; Thanks, Jack
RE: RMAN SQL Backtrack
Title: Message HI, We are a backtrack shop also and we are happy with it. We have not yet pressure to go to rman. If you switch to rman, I'm interested in knowing the migration effort. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Smith, Ron L.Sent: Wednesday, July 16, 2003 10:59 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN SQL Backtrack We have been using SQL Backtrack for backup and recovery forabout 6 years now. We are being pressured to start using RMAN because it is free. Makes sense but I am wondering about reliability, complexity, learning curve, etc... Has anyone had experience with both products or anyone new to RMAN that can give me an idea of what to expect? Thanks! Ron If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
RE: Rauch report: Oracle vs DB2
If you go on DB2 site, http://www-3.ibm.com/software/data/pubs/pdfs/dhbrown.pdf , you'll find a similar document that concludes that TCO of DB2 is below Oracle's one. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Jesse, Rich Sent: Wednesday, July 16, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Any Oracle/DB2 dual DBAs out there that can comment on the Rauch report (no doubt financed by Oracle Corp)? http://www.oracle.com/ip/deploy/database/theme_pages/index.html?ma_04252003. html Not that I'm particularly impressed on the ease of generating stats in Oracle vs. DB2, but I'm just curious how the DB2 side applies to real-world. I haven't used most of the Oracle GUI stuff as reported. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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).
ODS architecture
Hi all, For those having built or working with an ODS, we are in the architecture phase of building an ODS. How do check integrity between the source systems and data in the ODS ? In case of the ODS and the main source systems have lost synchronism, how do resync the ODS ? Any other major topics we should planned for ? Thanks Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Security, private vs. public synonyms and contention data di
Title: RE: Security, private vs. public synonyms and contention data dictionary I think I remember Steve Adams posting something about performance and public synonyms, you may want to check its web site www.ixora.com.au Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 11, 2003 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Security, private vs. public synonyms and contention data di Question: Are private versus public synonyms preferred for security? Are private syn. worse administration? Do 1,000 users with private syn. cause data dictionary contention?
RE: Oracle security question
Change the password of all Oracle related users (sys, system,...) Revoke access from all other users or make sure all other users have select only privilege on data. What is the use of such databases ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Don Yu Sent: Friday, July 11, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments are highly appreciated. Thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 on a mainframe (MVS)
Title: Message I've started with Oracle 5 on MVS a very long time ago, ProCobol was there. It is probably still there since it is the most popular language on mainframes. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor) (DAASC)Sent: Thursday, July 10, 2003 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle on a mainframe (MVS) We have a future needto create an Oracle database on a mainframe (MVS) which will then pull data from an Oracle database on an HPUX box. I know nothing about MVS so does anyone know of any connectivity problems between the two boxes? For example,SQL*Netdoes come with the server on MVS, correct? Does Pro*Cobol also exist on MVS?Would the connectionfromMVS toHPUX be a simple as creating adatabase link or are there moreproblems than that? Any help would be appreciated. Thanks, Tom
RE: Example to populate the dimensional tables
Well, you must load the dimension tables before the fact tables. Just beware of the precedence. Usually you cleansed the data and put it in a staging table that is identical to the target table, then you do load the target table. In my experiences we were not loading the time dimension, we initialise it for some years and that was it. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:50 PM To: Multiple recipients of list ORACLE-L Dear all, Are there articles or good examples to show how to populate the dimension and fact table in Dimensional(star) data model? Especially the time dimension. TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: salary question
Thanks Patrice, I've check for the Montreal city and by experience, I find the average a little lower than what I would expect. On the other side, the difference between the lowest and highest salary is huge. Also, this is for all DBA (sql server included... I suppose that cheaper product = cheaper dba ???) Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Boivin, Patrice J Sent: Monday, July 07, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Check out the Canadian results... http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/ I have never been able to figure this out, salaries are typically lower in Canada than in the U.S., for no apparent reason that I can think of. Patrice. -Original Message- Sent: Friday, June 27, 2003 1:10 PM To: Multiple recipients of list ORACLE-L http://www.payscale.com/research/vid-18563 choose the personal payscale report, to have an idea about what you get and what you should be getting.. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Didn't someone earlier this week post another site besides salary.com? Something with the word pay in it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 4:19 AM To: Multiple recipients of list ORACLE-L Whatever the figure may be, two things are certain if the salary is X: a) I probably don't deserve to get X b) I should be getting more than X :-) --- Helen J Mitchell [EMAIL PROTECTED] wrote: Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell 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 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] 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 Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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
RE: service name, sid ..
...when the fecal matter hits the rotary oscillator. Politically correct Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Monday, July 07, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: service name, sid . AK, You can make it as simple or complicated as you want. Personally I prefer the KISS principle. It's easier to troubleshoot when the fecal matter hits the rotary oscillator. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 07, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: service name, sid .. Tanel, Thanks for elaborate information , I really liked it . Still why do u need to provide db name in tnsnames, all one should know is which instance to connect . Instance know , which db to connect . why do net8 bother about dbname ? -ak - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Thursday, July 03, 2003 10:49 AM Subject: Re: service name, sid . Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create controlfile). You can have several databases with same db_name in one server, there is no restriction. SID - When we actually want to open and use the database, we have to start an instance whichwill be servicing the database. When starting instance, whe have to specify SID (system identifier) for it. This is actually just a operating system name for instance (or should I say SGA shared memory segments). As you know, SID is specified using ORACLE_SID OS environment variable and is only used by listener, when spawning new processesor when attaching directly to SGA using bequeath protocol. You can not have instances with same SID in one server, even if you use different oracle homes. instance_name - An Oracle parameter for specifying Oracle instance name. Seems that operating system doesn't know anything about it.For example, if you use SID_LIST parameters in your listener.ora, then listener always knows how to spawn processes for given SID, because (almost) all it takes to start another server process, is the location of oracle executable and SID value. But if you want to connect using instance name (not SID itself) then Oracle instance actually has to register itself with listener before any server processes can be spawned. Note that ORACLE_SID and instance_name variables do not have to match. (Tested on 9.2.0.1 on W2K). If my SID is ORCL for example and instance_name is TEST, then I can connect using both SID=ORCL and SID=TEST in CONNECT_DATA section of TNSNAMES (again, the instance name has to be registered with listener). V$INSTANCE still shows SID (ORCL) in instance name fielt. As we know, in OPS and RAC environment you could have several instances servicing one database, this is one ofcommon reasons why db_name and instance_name would be different. (ORCL for db_name, ORC0, ORC1, ORC2, etc.. for instance names for example). Btw, does anyone know if I can have the same instance name in all RAC nodes? RAC shouldn't care much, because it uses instance numbers anyway? service_names - this is an additionallayer for logically spreading work across nodes in RAC (and possibly other load balanced environments such replicated databases and even logical standby). For example, if you have 4 node RAC and have defined two "services" such OLTP and REPORTING, then you could assign OLTP for nodes and REPORTING for one, but during month end reporting you could still keep OLTP on 3 nodes, 1 node purely for REPORTING and add REPORTING to one or more OLTPs as well. So, when user's are connecting, they don't request a specific node or instance, they just request a service. And in load balancing environments then users are directed to instances, where appropriate service is defined. It gives somewhat flexibility, but I've never used it myself (thus my explanation here might wrong ;) Cheers, Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 02, 2003 9:49 PM Subject: service name, sid . I am reading oracle network admin guide and getting confused abt service name, instance name , db
RE: salary question
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: ODS and data modeling
Title: Message Thanks, Using one code tableis easier to manage from a development point of view but it prevents using referential integrity in the database, that's my main concern. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] -Original Message-From: Tierstein, Leslie [mailto:[EMAIL PROTECTED]Sent: Thursday, July 03, 2003 11:42 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: ODS and data modeling Handling codes in one table via separate tables has been extensively discussed in development-oriented lists. The consensus falls heavily on having one single table -- it is much easier to manage. For example, you only need one fairly simplemaintenance form to allow users to maintain/view the code values. SampleDESC for one physical table which holds multiple logical code tables: SQL desc cn_codesName Null? Type- ---CODE_IDNOT NULL NUMBER(10)ACTIVE_INDNOT NULL VARCHAR2(1)CODE_SHORT_DESC_TXTNOT NULL VARCHAR2(70)CODE_TABLE_NMNOT NULL VARCHAR2(30) -- logical code table nameCODE_VALUE_CDNOT NULL VARCHAR2(15) -- logical code valueCREATE_DTNOT NULL DATECREATE_USER_NMNOT NULL VARCHAR2(12)MOD_DTNOT NULL DATEMOD_USER_NM NOT NULL VARCHAR2(12)CODE_LONG_DESC_TXT VARCHAR2(1000)TABLE_SPECIFIC_TXTVARCHAR2(40)DISPLAY_SEQ_NBR NUMBER(3) Couple of notes on the above: (1) Above table definition includes artificial, sequence-generated PK, which is recommeded for DW or ODS, given issues with changing dimensions. (2) Don't know if you will want just an Active indicator or a range of dates in which the particular code is active. (3) OLTP system needs additional information about codes, stored in table_specific_txt; might not be required in ODS/DW environment. (4) Specific definition of table_specific_txt, and a definitive list of all the code tables is contained in another logical table, which could be another code table or stored elsewhere. (5) If required, very easy to create views on top of the above, to hide the physical table from developers. -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:56 PMTo: Multiple recipients of list ORACLE-LSubject: ODS and data modeling Hi all, I'm doing the data model for an Operational Data Store. The ODS will serve to consolidate data from many operational systems and mainly from a new ERP, then most of the data will go in an existing data warehouse. I've worked with datawarehouses before but never withODS. I've check about Bill Inmon and at IBM red book site on the web. Any other good site on ODS ? Also, what are your arguments when choosing between1 table handling all codes or having a table for each code. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]
ODS and data modeling
Hi all, I'm doing the data model for an Operational Data Store. The ODS will serve to consolidate data from many operational systems and mainly from a new ERP, then most of the data will go in an existing data warehouse. I've worked with datawarehouses before but never withODS. I've check about Bill Inmon and at IBM red book site on the web. Any other good site on ODS ? Also, what are your arguments when choosing between1 table handling all codes or having a table for each code. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]
RE: dbshut script - why shutdown so much???
All our unix servers (+-25) are AIX 4.3. We reboot only if there is a problem. Stephane -Original Message- Landrum Sent: Friday, April 04, 2003 9:29 AM To: Multiple recipients of list ORACLE-L I once read an article in an IT publication (several years ago) in which the author stated that if you are still rebooting your Unix servers routinely, your Unix admins don't know what they're doing. Yes, the language was that harsh. I thought this was ludicrous for 2 reasons: 1) The author assumes no applications have memory leaks. (Uh, yeah!) 2) Users, developers, (even DBAs) make changes. Imagine a change made which doesn't take affect until a shutdown. Now, imagine the next shutdown 4 months later. Now, imagine that change broke something. Finding the cause could be a perilous exercise. [EMAIL PROTECTED] 04/04/03 07:23AM Your reasons beat ours, Ray. We just reboot the box every weekend because we do and we always have. It is AIX, too. We don't even reboot our Win 2K machines as often. April Wells Oracle DBA/ Oracle Apps DBA -Original Message- Sent: Friday, April 04, 2003 7:01 AM To: Multiple recipients of list ORACLE-L On Thu, Apr 03, 2003 at 06:58:37PM -0800, Connor McDonald wrote: All this discussion on shutdown does motivate me to ask why is everyone shutting down so frequently? -- Here are my reasons this past year: oracle security patches sun kernel patches power issues static configuration change 8i upgrade, no 9i upgrade, no wait 10i... === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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).
Database link and connection
Hi all, Oracle 8172 with dedicated connections. I've not played that much with database links. Users from application A will accessed data from another database B with a dblink. Real time access is needed so no snapshot, tables and stored proc are accessed. There are 300 users in application A so that means that they can open 300 connections in database B. Is there a way to not used that many connections on database B ? If not, I guessed I have 2 choices 1. Use sqlnet.expire_time to deconnect session being idle x minutes 2. Use a job that kills session with the dblink username after x minutes being idle Any other choices ? TIA Stephane Paquette Administrateur de bases de donnes Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 urban legends and myths needed
Thanks, I've found some on asktom also. Stephane -Original Message- Litchfield Sent: Tuesday, April 01, 2003 3:04 PM To: Multiple recipients of list ORACLE-L I seem to be missing some of the replies etc to this so apologies for repeating anything anyone else has said. 1. A BCHR of x% means that you have a well tuned system (where x is usually 95) 2. Minimise the number of extents for each object 3. Set PCTIncrease to a small value (typically 1%) to minimise fragmentation. 4. Index blocks never get reused. 5. Rebuild indexes frequently. 6. Separation of data and indexes improves performance 7. The most selective column of a concatenated index should be the leading Column 8. If its in print it must be true 9. If 'x' says so it must be true. 10. Avoid Full Table Scans, they are always bad. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephane Paquette Sent: 01 April 2003 15:54 To: Multiple recipients of list ORACLE-L Subject: Oracle urban legends and myths needed Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 urban legends and myths needed
Hi all, I'm currently writing an Oracle user guide for our developpers about how Oracle is implemented, SQL and PL/SQL good practices, tuning, rule base vs cost base (90 on 120 databases are still rule base) ... I want to add an Oracle urban legends and myths section focussed on development. I'm missing inspiration as I only have the use an index it'll go faster one. I'm sure you have lots of them. TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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 encouraging Linux software developers
It reminds me a report (Gartner, Meta, ?) I've read in 1997 saying that after year 2000 there should be only 3 players in the rdbms market : Oracle because it has the biggest market share, IBM because it's IBM and Microsoft because Bill was throwing a lot of $$$ to develop Sql Server. In 2003, Ingres, Sybase and Informix have about a 5% marketshare all together. What's for the future ? Stephane -Original Message- WILLIAMS Sent: Thursday, March 27, 2003 9:14 AM To: Multiple recipients of list ORACLE-L Jacques - We often don't realize that at end-user sites we look at the immediate computer marketplace. Any vendor that did that would be out of business in a couple of years. A vendor, like Oracle, must predict where the the market will be in a couple of years. About two years ago the META Group predicted that in about 5 years most servers sold would be running one of three operating systems: 1. Windows 2. Linux 3. Solaris As near as I can tell, they are on the mark. The other Unix vendors are showing signs of shifting to Linux. Obviously they won't announce that directly since they need to keep selling computers today. From Oracle's point of view, they don't care who is the winner, just that Oracle is the leading database, and not something like MySQL. Remember how Unix emerged as the leading O.S. Since ATT couldn't sell computers (for awhile due to antitrust restrictions), they gave source code copies to colleges. New C.S. majors learned Unix inside out while in college. I understand today that those people are learning Linux internals in college. Obviously Microsoft is at a disadvantage since they don't want to provide source code, although I heard Microsoft has an initiative to provide limited source code to a college. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 26, 2003 7:44 PM To: Multiple recipients of list ORACLE-L For those not interested in marketing news, I would suggest skipping this message. From a Computerworld article http://www.computerworld.com/softwaretopics/os/linux/story/0,10801,79730,00. html http://www.computerworld.com/softwaretopics/os/linux/story/0,10801,79730,00 .html Oracle ups Linux efforts with ISV program By James Niccolai, IDG News Service MARCH 26, 2003 Oracle Corp. is shelling out US$150 million to encourage its software partners to develop for Linux (two US$ for every US$ spent be the vendor.) Some other interesting tidbits from the article: Separately, engineers at Oracle are working on the Linux kernel, the code at the heart of all Linux distributions, to make it more suitable for Oracle's software. The company plans to submit its work to Linus Torvalds, who oversees changes made to the Linux kernel, with the hope its work will be incorporated ... Among those efforts ... increase the amount of physical memory that can be addressed by 32-bit Intel servers running Linux. Oracle also hopes that a version of the clustered file system that it released for Linux customers last year will become part of the kernel. Why would Oracle give money to people to develop on Linux? Is it only to help bring down Microsoft? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephane Paquette 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).
