Re: What to look for in STATSPACK report

2004-01-23 Thread Mogens Nørgaard
Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense.

Re: What to look for in STATSPACK report

2004-01-19 Thread Mogens Nørgaard
Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in

Re: Who is Melanie Craft?

2004-01-18 Thread Mogens Nørgaard
Yeah, you might not be able to open it, but you can nearly always mount it. Rachel Carmichael wrote: as opposed to the ever-present Oracle kernel which is arbitrary, gobbles up all resources in sight and costs the earth to maintain? --- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote:

Re: oaktable people

2004-01-18 Thread Mogens Nørgaard
-Original Message- Mogens Nørgaard Sent: Tuesday, January 13, 2004 10:39 PM To: Multiple recipients of list ORACLE-L Lies, lies and viscious rumors. It was only the loft of the Garage, and the idea was to create a new, exciting space for the Oracle Museum, complete with webcams. I had planned

Re: oaktable people

2004-01-13 Thread Mogens Nørgaard
Lies, lies and viscious rumors. It was only the loft of the Garage, and the idea was to create a new, exciting space for the Oracle Museum, complete with webcams. I had planned the Miracle Master Class Teambuilding Exercise as follows: 1. On Sunday evening we would (slowly!) move the stuff

Re: another OCP question -- help me guys

2004-01-08 Thread Mogens Nørgaard
I demand to know who the other one is! Mogens Rachel Carmichael wrote: you leave me such straight lines :) which part is qualified as an accountant? you volunteer to be the sacrificial lamb? Hm, masochist? Before Jared tries to send everyone over to my list on this topic, I'll try to

Re: oaktable people

2004-01-08 Thread Mogens Nørgaard
Heh-heh. It should be said in all fairness that we don't really spend much time with our website (keeping it updated, for instance - just to mention one minor detail), so we certainly understand if people are asking for directions there :). One very un-serious question: Is it actually possible

Re: Book (was) oaktable people

2004-01-08 Thread Mogens Nørgaard
, that we also do a Profanity Class 101 for the speakers during the event? I could teach some of it. Mogens Gary Goodman wrote: We may have to add a 'Mogens Nørgaard' profanity clause to the Symposium speaker agreement. I will admit that profanity from Connor does not carry the same impact as profanity

Re: ORA-01578 data block corrupted

2004-01-08 Thread Mogens Nørgaard
If the restore/recovery thing from backup doesn't work (it usually does), it's time to panic in a controlled fashion... Dump the block to see if it's a hard or soft corruption. A hard corruption is when some kind of stray write has hit the block, causing one of many checks against eg the rows

Should we stop analyzing?

2003-12-30 Thread Mogens Nørgaard
Friends, I'd like to start a debate, which perhaps has already taken place, but if so I don't recall it: Should we stop analyzing tables and indexes? Let me clarify: I've always told people that using the 'monitoring' option (alter table X monitoring in 8i, plus alter index I monitoring in

OT: Re: 10g new features question for beta testers

2003-12-29 Thread Mogens Nørgaard
on him, gave him a beer, and put him to sleep on the floor. He thought he had received splendid support :-). I'm sure this could become a textbook case in some future book by Tom Peters and other management gurus. Mogens Carel-Jan Engel wrote: -Original Message- Mogens Nørgaard Sent

Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

2003-12-29 Thread Mogens Nørgaard
And I think it's important to realise that ratios are useless as a starting point in the tuning process on any system, not only Oracle. Most OS'es and databases use not instrumented correctly to deal with response time measurements (makes you wonder: If response TIME is what matters, how can

Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)

2003-12-29 Thread Mogens Nørgaard
I think Dave Ensor, at the recent UKOUG conference, called it his portable tuning kit: select elapsed_time, cpu_time from v$sql order by elapsed_time; Mogens Connor McDonald wrote: Yep. Simple example: Even though it seems to be sometimes a little on the 'random' side, the ELAPSED_TIME

Re: 10g new features question for beta testers

2003-12-22 Thread Mogens Nørgaard
Pihlamae, long-term Oracle DBA -Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one

Re: 10g new features question for beta testers

2003-12-21 Thread Mogens Nørgaard
It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the best of everything. That's what we have with Microsoft, isn't it? ;-) : Office stuff, OS, Database, ERP, CRM, video player,

Re: ANSI join syntax and Oracle 8i

2003-12-21 Thread Mogens Nørgaard
I don't, but perhaps Lex does? He's crazy about that Join stuff and even has a whole one-day class on mathematical methods in SQL. Also, he has written a book on SQL, that still sells well - but it's in Dutch, so you'd have to learn that language first :). Lex - welcome to the Oracle-L list

Re: New TPC benchmarks

2003-12-16 Thread Mogens Nørgaard
-- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Monday, December 15, 2003 5:44 PM To: Multiple recipients of list

Re: SAN Comparison Question

2003-12-16 Thread Mogens Nørgaard
I would go for the one that promises to have a RAID-5 implementation that doesn't suffer from the usual RAID-5 problems. Heh-heh. Mogens Jay Hostetter wrote: One of our hardware guys is seeking an opinion on SANs. He is comparing the Hitachi Thunder 9500 to the HP EVA 5000. Does anybody have

Re: for security patches - going to 9.2.0.4

2003-12-15 Thread Mogens Nørgaard
We've had to set the _optimizer_features_enabled or whatever back to 8.1.7 and/or _new_initial_join_order (which defaults to true in 9.2.0.4, at least) to false after seeing a lot of problems going from 8.1.7 to 9.2.0.4. It's happened a couple of times, but I'm not sure if it's a trend or not.

Re: Windows clustering???

2003-12-15 Thread Mogens Nørgaard
And the plans for this, I was informed from a manager at HP last week, are: - It's beta on VMS on Itanium now - It can run in a cluster with an Alpha box - Possible release in 3rd quarter of 2004 Mogens Tanel Poder wrote: Maybe you all already know that, but HP is planning to support OpenVMS on

Re: New TPC benchmarks

2003-12-15 Thread Mogens Nørgaard
I love to read the Full Disclosure Reports: There were 672 x 18GB15krpm HDD Ultra320 HP, 1344 x 36GB15krpm HDD Ultra320 HP and 224 x 146GB 10krpm HDD Ultra320 HP in the benchmarked configuration. FYI: 672+1344+224 = 2240. IBM is considering a 1.6M benchmark, and the only problem these days is

Re: New TPC benchmarks

2003-12-15 Thread Mogens Nørgaard
as I have enough internal storage to keep an entire hot backup set on disk, along with a member for each redo log, and a controlfile, just in case. Pd */Nuno Pinto do Souto [EMAIL PROTECTED]/* wrote: Mogens Nørgaard wrote: Today it's only a question

Re: rebuilding indexes - sure to cause a ruckus

2003-12-10 Thread Mogens Nørgaard
How about: Keep re-analyzing your tables and indexes. Run gather_statistics (or whatever) all the time. Bobak, Mark wrote: I think this subject has been done to death. We should talk about less contentious issues such as: - The buffer cache hit ratio, your friend in expert Oracle tuning! -

Re: what happened to baarf.net?

2003-12-05 Thread Mogens Nørgaard
It's on www.baarf.com and there are some pretty good articles there. Best regards, Mogens [EMAIL PROTECTED] wrote: anyone got the articles about why raid 5 is bad for databases? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=

Re: ETAGON...

2003-12-05 Thread Mogens Nørgaard
expensive. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Thursday, December 04, 2003 3:29 AM

Re: ETAGON...

2003-12-04 Thread Mogens Nørgaard
Etagon invited me to come and visit them at their stand at the UKOUG conference in Birmingham next week. Don't know if I'll have time or not, but in general I'm still looking for hard evidence of financial savings using RAC, ie a real comparison where switching to RAC (on whatever platform)

Re: Which storage solution is good or you will recommend

2003-12-02 Thread Mogens Nørgaard
Just wait till we post Jesper Haure's RAID-4/5 simulator, where a home-written XOR function plus a table with column A = disk A, etc... It should be ready RSN. Mogens Carel-Jan Engel wrote: Hi Jack, Any BAARF-compliant solution will do. Look at www.baarf.com At 12:34 2-12-03 -0800, you

Re: Copying stats between/amongst schemas

2003-12-02 Thread Mogens Nørgaard
dbms_stats is the only sanctioned way to do it. Orr, Steve wrote: 1 database instance, 2 nearly identical schemas. What's the best sanctioned way to copy stats, (including histograms), from one schema to another? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

Re: what is oracle rdb?

2003-11-27 Thread Mogens Nørgaard
Oh yes, even Lego complained about the price increase of support, upgrade rights and software. It was very steep. But they all accepted that the real price of their software had been covered up by Digital selling other things like hardware... Oracle just sells software. Still it was a problem

Re: what is oracle rdb?

2003-11-27 Thread Mogens Nørgaard
a political issue, and therefor most of the BS has been avoided. Nothing - nothing - beats leaving the folks alone to do the job. That's why the bearded fellows have kept working at the NEDC (New England Development Center), as I think it's called. Mogens Thater, William wrote: Mogens Nørgaard

Re: what is oracle rdb?

2003-11-25 Thread Mogens Nørgaard
As the AWE (Award-Winning Educator) of the year, I have a huge responsibility placed on my shoulders: I have to answer questions regarding Rdb truthfully. So here we go... Back in the year 1994, Digital very discreetly asked their three biggest customers (including Lego) what they thought of

Re: what is oracle rdb?

2003-11-24 Thread Mogens Nørgaard
It's still on the price list. Download the latest price list from Oracle and search for rdb - it's on page 4 out of 9. $40K per cpu - just like Oracle EE. Trusted Oracle, to my knowledge, had nothing to do with Rdb. Lots of useful stuff came into the Oracle code from the Digital guys. Bellow,

Re: FW: SAN configuration for Banner

2003-11-19 Thread Mogens Nørgaard
Oh well, even though we're not talking about RAID-F anymore, let's break the rule now and then :-). It's funny to see how the technical guys say the correct things, the vendor guy says some rubbish, and the manager guy decides to do as the vendor says. Maybe that sort of interesting decision

Re: Does anything run on RAC? paper

2003-11-14 Thread Mogens Nørgaard
I didn't think there were other clustered databases?! Mogens Pete Sharman wrote: If you're a member of the UKOUG (probably unlikely, but worth a try!) it's on their web site I believe. I still haven't managed to get Jonathan to add my editorial but every example you give would wreck ANY

Re: Uncle Larry, wake up!!!

2003-11-09 Thread Mogens Nørgaard
Amen. In Miracle we'll do nicely in the years to come by being able to support VMS, PL/SQL (the COBOL of the databases - widely used, very efficient, not in vogue anymore for new projects), perhaps Oracle (if it goes the way we could fear), UNIX (which is certainly dead now - if you had any

Re: Oracle /db2

2003-10-26 Thread Mogens Nørgaard
At the Database Forum here in Denmark recently we had one presentation comparing stuff between Oracle, SQL Server and DB2: The Heterogeneous DBA by Chuck Sodowsky from Quest. It seemed to me like he knew what he was talking about. Maybe he can help? I don't have his email present. Mogens *//*

Re: Oracle pricing ain't going down

2003-10-26 Thread Mogens Nørgaard
You had everybody convinced by your speach down there in South Africa! I think actually SQL Server SE is 1/3, not 2/3, of Oracle SE and 1/2 of EE as you state. DB2 is about the same as SQL Server. No idea about Sybase. I have this radical idea that Oracle should include RAC in SE at no extra

Re: Your new book

2003-10-26 Thread Mogens Nørgaard
I think Cary has put performance tuning on a solid math foundation, not just the Oracle one. I'm writing a little paper (not much yet) on why you can not optimise any other system right than the MVS environment and the Oracle database. The MySQL people are currently reading Cary's book and

Re: Your new book

2003-10-26 Thread Mogens Nørgaard
What's wrong with having a Scandinavian accent?!? :-). I remember taking a class by Andre Bakker, a Dutch genius, who at one point was VP of Support in Oracle, when I joined Oracle. I couldn't figure out why on Earth you would want Oracle version 6 to run on a fax... until I realised a few

Re: Separate Indexes and Data

2003-10-16 Thread Mogens Nørgaard
A fine response, Richard. Thank you. One of the guys coding the index stuff was/is Jonathan Klein, and I remember asking him some years ago about reuse of index blocks, and he - at that point - said that he was pretty sure he put the reuse of leaf blocks into 7.1, but that branch blocks didn't

Re: Where can I download 10g ?

2003-10-16 Thread Mogens Nørgaard
At least I would then die with a broad smile on my face, knowing that that version was delayed, too... Pete Sharman wrote: Sure, I've got an accurate rumour. Of course, I'd have to kill you if I told you. Do you really want to know that much? :) Pete Controlling developers is like herding

Is RBO there in 10g?

2003-10-16 Thread Mogens Nørgaard
We had a question recently on the list about RBO still physically being there in 10g or not. I asked Graham Wood in Development, and here's his reply: == RBO is still there. De-supported means that if you find a bug, such as wrong results, in RBO it will not be

Re: OW Paris get-together, was : Re: where is Tanel ?

2003-10-16 Thread Mogens Nørgaard
I'll be in Paris. Have to receive my Oracle Magazine reward and admire La Defense - or vice versa. Mogens Stephane Faroult wrote: I have just received an e-mail from Tanel saying he had not had the time to participate recently and enquiring about any list get-together at Oracle World Paris. I

Re: SUPPRESS SQL STATEMENTS

2003-10-13 Thread Mogens Nørgaard
Start the script from another script? Johan Muller wrote: A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback

Re: A funny thing happened today on the way to OraPerf.com ...

2003-10-11 Thread Mogens Nørgaard
Gaja, Anjo - The question was: Is the data that users have uploaded to OraPerf now available to Veritas? It's a fair question that deserves more than a no need for any concern answer :-).. Perhaps it would be good if Anjo explained why and how this happened. You know I love you, Gaja, but why

Re: Desupport of RBO

2003-10-11 Thread Mogens Nørgaard
I'm pretty sure that RBO is still there in 10g :-), but that it will not be enhanced, P2 and beyond issues won't be fixed, etc. But to be certain, I have asked Graham Wood. Mogens Cary Millsap wrote: I'm pretty sure that RBO is *gone* in 10g. If I understood correctly what I learned this

Re: Using ' in Update statement

2003-10-11 Thread Mogens Nørgaard
Tom has a small staff to help him answer the questions. I find the comment from Raj to be less than fair and intelligent - or we all misunderstood what he meant (including me). Mogens [EMAIL PROTECTED] wrote: I don't know whether Tom does all of the asktom site on his own time, but I doubt

Re: FW: Oracle Performance Software from Veritas

2003-10-11 Thread Mogens Nørgaard
It went very well. Gaja was flying, and it was good to see 15 members of the OakTable playing air guitar at the same time on stage. The girls were crazy with Gaja, and for good reasons. I have decided to make a musical next year, too. This massive mass of talent must not be wasted. Mogens

Re: SAN-Eva3000 experiences

2003-10-10 Thread Mogens Nørgaard
Check out www.baarf.com regarding RAID levels. Check especially the Sane SAN paper by James Morle as to do's and dont's. EVA stuff is expensive, and some of our customers have had to spend much time and money on spare parts and consultants. Others have been happy with it. Mogens Jeroen van

Re: FW: Oracle Performance Software from Veritas

2003-10-10 Thread Mogens Nørgaard
May I just add that his real name is Gaja Vahatneyhatneyhatney. That is what I called him in BAARF. The Musical.. [EMAIL PROTECTED] wrote: Our good friend Gaja Vaidyanatha is now with Veritas, so this isn't really too surprising. :) Jared *David Wagoner [EMAIL PROTECTED]* Sent by:

Re: Oracle Compress Option

2003-09-26 Thread Mogens Nørgaard
Not at all, Chris - here you go. Chris Stephens wrote: Hey Mogens... Would you mind sending me a copy of that paper? Thanks either way!! chris -Original Message- Sent: Wednesday, September 24, 2003 9:05 PM To: Multiple recipients of list ORACLE-L Compress to impress? by Julian Dyke

Re: Storage Frust....

2003-09-26 Thread Mogens Nørgaard
Sir Visser - The honour is mine. We shall BAARF around the world in the years to come. Mogens Piet de Visser wrote: Sir Norgaard, Group, Accepted, I think #43 is rather cool, as in: life, the universe and everyting++ I'll have to postpone review/critque/shredding of any text, statement or

Re: Fwd: RE: RAC for download -- re RAC Pricing and Partitioning

2003-09-26 Thread Mogens Nørgaard
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: RAC for download I've seen the same kind of confusion with respect to the partitioning option, where people have been

Re: 10g: SQL Plus

2003-09-26 Thread Mogens Nørgaard
Indeed. It's SO cool to run the version 5 thing again. Will you be at the UKOUG conference in Birmingham in December by any chance? Robson, Peter wrote: Ah-a - NOW I see why you want my old version 5 manuals!! peter edinburgh -Original Message- From: Mogens Nørgaard [mailto:[EMAIL

Re: any else try trace analyzer?

2003-09-26 Thread Mogens Nørgaard
And of course the Trace File Repository thing that Torben Holm from Miracle made. Not half bad either. And free. But nothing beats the Hotsos profiler in completeness and ability to interpret the complex situations in these 10046 traces correct. And the whole notion of not-accounted-for is

Re: SQL AREA and LIBARARY CACHE size?

2003-09-26 Thread Mogens Nørgaard
Was it not Dave Ensor that once concluded that x$ tables actually change less than v$ tables? Tanel Poder wrote: I'd suggest, when possible, not to use any x$ views, but stich with plain old documented ways. That way you'll probably avoid a lot of confusion, especially when database versions

Re: RAC for download

2003-09-24 Thread Mogens Nørgaard
I've seen the same kind of confusion with respect to the partitioning option, where people have been informed by their sales rep that partitioning option is part of EE. Well, yes, if you pay extra for it. Mogens Hemant K Chitale wrote: If the question is about price [referring to

Re: 10g: SQL Plus

2003-09-24 Thread Mogens Nørgaard
Well, we have a good, working 5.25 floppy drive installed on our Oracle Museum PC (486, 25 MHz) now, and we're planning on installing WordPerfect 4.2, Lotus 1-2-3 (with the plug-in for Oracle, which Cary will bring over for the Database Forum next week), and other goodies. We have 5.1 running,

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Sir Visser, It would be my honour to enroll you in the BAARF party as party member # 43 if you like. Also, if you enroll, I'll send you the whole BAARF.zip file (33 K) which contains the story, the dialogues, and the song texts of the BAARF musical which we'll do at the Database Forum Gala

Re: ROW CACHE HIGH - Priority 1

2003-09-24 Thread Mogens Nørgaard
I HAVE to ask this question: Is it possible for you to turn off RAC and thereby completely avoiding this issue? Yeah, that's kind of funny. Except it isn't, really. Invalidations of objects, drops, in general breaking of breakable parse locks - they will all need to be communicated to all the

Re: guidance

2003-09-24 Thread Mogens Nørgaard
Just talked to Jonathan Lewis from Helsinki. He went through some of the examples given in the latest issue of Oracle Magazine, and they were just plain wrong. I can't recall them in detail, but I think one of the questions were which parameter to set in order to let a user do large sorts. In

Re: RAC for download

2003-09-24 Thread Mogens Nørgaard
an additional check to sign. I got a verbal confirmation from my oracle sales rep and I'll try getting a written (email) one as well. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Wednesday, September

Re: Oracle Compress Option

2003-09-24 Thread Mogens Nørgaard
Compress to impress? by Julian Dyke is a good presentation on this topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm). I do have the article - 202 K with no compression, 147 K with compression :). Let me know if you're interested, and I'll email it directly to you.

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Oh man, that would be cool. He can choose any membership number above 44...for instance 10046 :-). PS Would you like to be a member yourself? Mogens MacGregor, Ian A. wrote: Garth Gibson, one of the original inventors of RAID (http://www.panasas.com/bio_gibson.html), and currently CTO of

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Well, Sir Tim - congratulations with your BAARF party membership # 44. The BAARF.zip file will be shipped in a second. Mogens Johnston, Tim wrote: Hey... I'm jealous!!! BAARF! BAARF! BAARF! Tim -Original Message- Sent: Wednesday, September 24, 2003 7:30 PM To: Multiple recipients

Re: Storage Frust....

2003-09-24 Thread Mogens Nørgaard
Can't deny you such a good and simple wish. Welcome as BAARF Party member # 69. Mogens Joe Testa wrote: I figure I have to wait for a while to get BAARF party membership #69, bwahahahahahha i'll go back to programming php against mysql :) joe Mogens Nørgaard wrote: Well, Sir Tim

Re: oraperf.com is now Veritas

2003-09-23 Thread Mogens Nørgaard
Pity not the tree. Pity the twig. Thank God he didn't use too many colors. Wolfgang Breitling wrote: Download it for yourself from https://www.oracleworld2003.com/published/36849/36849_Kolk.ppt and see for yourself. But you better have a high speed connection. At 05:19 AM 9/22/2003 -0800, you

Re: OFA and Shared Storage

2003-09-23 Thread Mogens Nørgaard
I'm way beyond the simple RAID-F systems these days. I now want mirrored RAID-F systems! We could call them RAID-F1, and they're unique. You might waste parity disks in the first place ... but then you mirror them. Mladen Gogala wrote: Files are kept safe simply by RAID-5 mechanism. RAID-5

Re: oraperf.com is now Veritas

2003-09-22 Thread Mogens Nørgaard
Yeah, I was reading and reading for hours studying the fine print of his presentation :-). Niall Litchfield wrote: All of it? how did you plough through all the detail? Niall -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Jamadagni,

Re: Anyone have a copy of DUL ??

2003-09-21 Thread Mogens Nørgaard
Bernard of Oracle Holland made DUL (Direct UnLoader) several years ago. I took the very last internals class conducted by Oracle Support EMEA Vice President Andre Bakker (the only VP to conduct internals classes, I think. I also think he quit Support in disgust some time later :-) ), and we

Re: Is Cary's new book shipping now?

2003-09-17 Thread Mogens Nørgaard
Lies, all lies. I've heard myself snoring. Pete Sharman wrote: I can guarantee that won't happen, since Cary's singing is pretty much akin to Mogens's snoring! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that!

Re: RAC Parallel Query Issues

2003-09-15 Thread Mogens Nørgaard
I'm not sure I understand. Is this a query that should access a 470 record table and which uses Parallel Query in a RAC environment? And when it works, it executes in less than a second? If yes, have you tested this query without Parallel Query? If no, where did I misunderstand you? Best

Re: ora 1575?

2003-09-13 Thread Mogens Nørgaard
I'm very sorry. By some error I never got this message sent. So here it is, over a month too late. Fantastic... Mogens == Ah, good to be back online with Tim Gorman on the old and wonderful 1575. 1575 was introduced in 7.1. Not as an

Re: db_file_multiblock_read_count

2003-09-13 Thread Mogens Nørgaard
Connor rules. Tim Gorman wrote: I've performed nm -o oracle and strings -a oracle on the Oracle executable, searching for the phrase sstiomax to no avail. To me, that implies that SSTIOMAX is not a variable in the C program that is Oracle. Instead, by C programmer conventions, any name

Re: ora 1575?

2003-09-13 Thread Mogens Nørgaard
Well, no I haven't seen him actually take a shower, but one must hope that the sound of running water for 42 minutes followed by silence for another 21 minutes must mean that water has run down Cary and not just down the drain. And although I haven't seen him take the shower, we're many

Re: what is BAARF?

2003-09-12 Thread Mogens Nørgaard
Well, we've begun to put good stuff about RAID-F on www.BAARF.com, including the good writing by Art Kagel mentioned below. One of the fantastic gems that just arrived today from a good source is the one from Sun where they describe a very unique way of implementing RAID-10 that actually makes

Re: 10g

2003-09-09 Thread Mogens Nørgaard
Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. Babette Turner-Underwood wrote: Yes, but then all the listers who have been DYING to fill us in, will be allowed to finally spill their guts, no? - Babette -Original Message- Mogens Norgaard Sent: Monday, September

Re: 10g

2003-09-09 Thread Mogens Nørgaard
It's also called Graham in a Box internally in Development because Graham Wood put some effort into it. It's Statspack on steroids plus more, but it will of course still be as useless as Statspack wrt system-wide measurement data. It does contain the SQL stuff if you ask it to, and that's

Re: 10g

2003-09-09 Thread Mogens Nørgaard
/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

Re: offshoring article

2003-09-09 Thread Mogens Nørgaard
Makes sense. Peter Barnett wrote: Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs

Re: 10g

2003-09-09 Thread Mogens Nørgaard
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

Re: 10g

2003-09-08 Thread Mogens Nørgaard
Yes, Larry will announce it tomorrow. The software will not be available to customers for a while, though. Boivin, Patrice J wrote: The release date and the shipping dates may be different, not sure. They also may not have it ready for all platforms at the same time, see OCS Release 2, there

Re: DB2 has a foot in the door

2003-09-08 Thread Mogens Nørgaard
Yeah, it's rather cool to read. I think it was Connor who originally forwarded them to the OakTable list. But we ran into one example where it made sense: A customer needed to move an application from Sybase to either Oracle og SQL Server. Well, it was way easier to move the Transact SQL (or

Re: Urgent INFO needed. - OFF TOPIC

2003-09-08 Thread Mogens Nørgaard
Yeah, well, when all the American IT companies conquered (spelling?) the world and ran the Danish HW-vendors in the ground, as well as a lot of small and medium sized SW-shops, I think - but I could be awfully wrong here :-) - most Americans thought that was because we were too expensive, too

Re: test

2003-09-07 Thread Mogens Nørgaard
No, no, no, no. You just live on the wrong side of the world, these days. TestG is old, gone, dead. It's Test/g/ now. Has been for a couple of weeks. Notice the italics. Don't make users more ten'se than neccessary. The first one who sees a production version of Tense/g /will forever be known

Re: No more Oracle development here

2003-09-07 Thread Mogens Nørgaard
It's not easy, because IBM has about 42 versions of DB2, but in general their SE/EE prices are similar to SQL Server, ie a third and half of Oracle's. It's a good point about support costs. Microsoft runs at 25%, Oracle at 22%. Comparing is hard, of course, since you can often get

Re: Oracle World - Listers get together (proposed Tuesday Sep 9)

2003-09-07 Thread Mogens Nørgaard
Wish I could be there, but I can't. It will be Paris for me this year, and of course an award-winner lunch with the editor of Oracle Magazine and others :-). I wish I could be there with you guys, though. Cary - could you have a Margarita for me, please? Double, lots of salt? Mogens Steve

Re: offshoring article

2003-09-07 Thread Mogens Nørgaard
They're hired by the people who came out of those very same universities. Most often McKinsey et al are hired to OK decisions that management have a hard time OK'ing themselves for various reasons. To be fair, of all the consulting companies that make money out of telling people that water

Re: DB2 has a foot in the door

2003-09-07 Thread Mogens Nørgaard
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

Re: Oracle Masters exam

2003-09-07 Thread Mogens Nørgaard
As another shareholder of Oracle (worth about $1.42 as I recall it), I think it's worth noticing that the richest guy in the universe at first thought this Internet thing wasn't really going to take off. When it did, he moved his company around very, very fast to embrace it. Perhaps not

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Oracle thinks the combined readership of Oracle Magazine and Profit Magazine is about 1 million. Sounds plausible to me. Of those 1 million, about 10 will see the ugly pictures of me in the November issue. Two of them will remember it. The other one will be my financee Anette, who also works

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Well, the title is You PROBABLY don't need RAC, and I did actually (but just for fun to see his reaction) propose to Cary that I would do a You Probably Don't Need Oracle presentation at the Hotsos Symposium. He didn't reply to that. So instead I'll do You probably don't need a goat. The

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
And Tom Kyte is Author of the Year, by the way. Man, I feel honored and humble at being in company with Arup and Tom on this stuff. At least they do real work. All directors do is talk to other directors on the mobile or have lunch with other directors. Niall Litchfield wrote: Congratulations

Re: 32 or 64?

2003-09-07 Thread Mogens Nørgaard
Yep. If you benefit from using more memory than what 32 bit stuff can handle, then of course 64 bit will help. If you don't benefit from more memory (that's likely to be the case for most), then 64 will just add overhead. But if the vendors are pushing 64 bit, then management will buy it. It

Re: latch free wait event

2003-09-07 Thread Mogens Nørgaard
Can instead of Will is probably only in the case where there's only one user on the system :-))). Cary Millsap wrote: Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with system-wide scope can waste your time. For a 34-page introduction to the rationale behind this proposition,

Re: Offshore threat

2003-09-07 Thread Mogens Nørgaard
While I was still in Oracle, thieves broke into the offices of Oracle in Oslo, Norway, and removed two HP cpu's from the main computer there. They ignored all the nice laptops on the tables around them. Now, that is weird. Mladen Gogala wrote: Two IBM mainframes stolen? Boy, the times are

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
feminine. If you're not a member of Club 100, you're not a real man, in other words. For Cary's information, 100 Kilograms is about 4TB Pounds rounded to the nearest SquareGallon. Mladen Gogala wrote: On 2003.09.07 04:19, Mogens Nørgaard wrote: Oracle thinks the combined readership of Oracle

Re: Future demand for DBAs

2003-09-07 Thread Mogens Nørgaard
By the time of the UKOUG conference in December we should have Miracle Breweries up and running. Capacity will not exceed two batches per week. However, each batch will be 400 liters each. For Cary's information, that's about 0.42 gallons. Niall Litchfield wrote: Jesse wrote Put down the

Re: more questions

2003-09-07 Thread Mogens Nørgaard
Another fun fact about the OS390 port: If you set max dumb ( :) ) file size to 50 MB, then the session will write 50MB, close the file, open another one, and continue writing trace data to this one, and so one, until the session is done. Tim Gorman wrote: As an interesting side note, Oracle

Re: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mogens Nørgaard
to be a member of this list. WOW was the first thing to be able to access the oracle database through the CGI interface. That guy was phenomenal, I believe that he has had a part in WebIV as well. On 2003.09.07 04:34, Mogens Nørgaard wrote: When I was hired as a DBA by a bank here in 1987 I used 1200

  1   2   3   4   >