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: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mogens Nrgaard
When I was hired as a DBA by a bank here in 1987 I used 1200 baud modems to dial up and manage the 5.1.22 thing. Of course we used Kermit and set host/x25 - very cool stuff back in those days. And free. WebIV was fantastic. It was created by a few guys in Oracle UK Support, among them David

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mladen Gogala
On 2003.09.07 04:19, Mogens Nørgaard wrote: 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

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: system tablespace at 50 pct_increase in 9i?

2003-09-07 Thread Mladen Gogala
Mogens, do you happen to know the name of the Swedish or Norwegian guy who wrote WOW gateway? He used 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.

Re: How can I measure my DB performance.

2003-09-07 Thread Mogens Nrgaard
And if you have nothing better to do, study the Full Disclosure Reports. There's still cheating going on. More about that AFTER I get the award :-))). Stephane Faroult wrote: http://www.tpc.org Jake Compare to what? Another database? To what its performance should be? Dennis Williams DBA,

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mogens Nørgaard
Nope, no Bill O'Reilly isn't available here. What is it and how can I learn more about him? As for the pictures, you won't believe how fat I look. In other words, it was a good photographer who managed to capture me as I am. Here in this country we consider anyone weighing less than 100 kilos

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
His name was Magnus Lönnroth or Lonnrott or something. He moved to the US after coming out with the WOW stuff, and help bring out the OWA or whatever it was called. Mladen Gogala wrote: Mogens, do you happen to know the name of the Swedish or Norwegian guy who wrote WOW gateway? He used to be

Re: more questions

2003-09-07 Thread Mladen Gogala
On 2003.09.07 05:19, Mogens Nørgaard wrote: 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. I'm not an

Re: Oracle on RAID - Thanks

2003-09-07 Thread Mogens Nørgaard
Yes. RAID-3 is bit-level striping with a dedicated parity disk. Buy 33 disks if you're on 32 bit systems, otherwise buy 65. Then you'll have fantastic performance as long as you have concurrency for the whole disk stripe set to 1. RAID-4, as used in the IBM Shark systems, have chunk-level

Re: Congratulations Arup (DBA of the Year)

2003-09-07 Thread Mladen Gogala
On 2003.09.07 05:04, Mogens Nørgaard wrote: Nope, no Bill O'Reilly isn't available here. What is it and how can I learn more about him? I would enjoy providing a detailed response but I doubt that Jared would tolerate such an excursion into political pamphlets. I'll send you a private response

Re: offshoring article

2003-09-07 Thread Nuno Souto
- Original Message - 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

Re: DB2 has a foot in the door

2003-09-07 Thread Rachel Carmichael
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

Re: DB2 has a foot in the door

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

Re: DB2 has a foot in the door

2003-09-07 Thread Ryan
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

Re: DB2 has a foot in the door

2003-09-07 Thread Rachel Carmichael
been too long since I've done any DB2 work for me to remember it.. I was barely involved in the work then, primarily the Oracle DBA. As for the site licenses... these are likely to have been in place for a LONG time (I left Citibank in '98) and the company I work for now has been around for a

RE: Offshore threat

2003-09-07 Thread Richard Ji
Maybe the thieves are running Oracle on HP and they need to add two more CPU to their server. -Original Message- From: Mogens Nrgaard [mailto:[EMAIL PROTECTED] Sent: Sun 9/7/2003 4:49 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Offshore threat While I

Re: question for internals experts

2003-09-07 Thread Tim Gorman
In addition to the DBA_TABLESPACES view which is based on the TS$ table, the V$TABLESPACE view is based on the X$KCCTS fixed table. X$ tables are purely read-only from SQL or any other API into the RDBMS. I believe that this view came into being relatively recently, in either the v8.0 or v8.1

Re: DB2 has a foot in the door

2003-09-07 Thread Jared Still
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

Re: Dead locks how ?

2003-09-07 Thread Jared Still
There are many kinds of deadlocks in the Oracle world. The following MetaLink notes will be of interest. 166924.1 62365.1 There are no doubt others, but these are two I had bookmarked. Jared On Sat, 2003-09-06 at 00:54, Mladen Gogala wrote: Harvey Deitel: Operating Systems. Andrew

Re: DB2 has a foot in the door

2003-09-07 Thread Ryan
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

Re: offshoring article

2003-09-07 Thread M Rafiq
Most possibly Xerox, but I am not sure... Regards Rafiq

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

2003-09-07 Thread Cary Millsap
Yes, I will do that for you, my friend. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Mogens Nørgaard Sent: Sunday,

Re: external procedure as not-oracle on OS

2003-09-07 Thread Pete Finnigan
Hi This would be a security risk to have a java callout that can execute any OS command with group ID DBA, this means it could for instance.. call sqlplus -s and execute a script that changes the SYS passwordedit the password file and change the password hashes to known values...why not just

Re: question for internals experts

2003-09-07 Thread Pete Finnigan
Hi Have a look at Yong Huangs web site, I cannot remember the URL but there are links to some of his pages including his X$ speculations on my page http;//www.petefinnigan.com/orasec.htm - look for Yong Huang hth kind regards Pete In article [EMAIL PROTECTED], [EMAIL PROTECTED] writes Does

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

2003-09-07 Thread Tim Gorman
I've never been to Open World and this year will be no exception, but as it turns out I'm working Tues-Fri in Sacramento, only two hours up the road or so I'm told. If they release me by 5:00pm then (theoretically) I can be at Chevy's by 7:00pm or so. As Rachel and Jared can attest, I'll drive

Re: latch free wait event

2003-09-07 Thread Tim Gorman
You sir, are one hell of a great communicator! I'm placing my order now... on 9/5/03 7:19 AM, Cary Millsap at [EMAIL PROTECTED] 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

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

2003-09-07 Thread Rachel Carmichael
I swear, he drives insane distances for a drink and dinner. And Tim -- they NEVER have one drink and then leave these are DBAs you are speaking of! --- Tim Gorman [EMAIL PROTECTED] wrote: I've never been to Open World and this year will be no exception, but as it turns out I'm working

Parallel index read without alter index... ?

2003-09-07 Thread Mark Richard
Hi List, I was wondering if anyone knows a technique to make a query read an index in parallel without issuing an alter index ... parallel 2 command? With a table the parallel hint works fine but I've never seen it done for an index. The query which requires the hint will be issued as a

Re: 600-[25012] on delete of IOT table

2003-09-07 Thread zhu chao
hi, GovindanK: I searched metalink and cannot find note:287936.999 you mentioned. And I did not move the IOT index segment and overflow segment online. I did those operation during system outage. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message

Re: DB2 has a foot in the door

2003-09-07 Thread Mogens Nørgaard
Cost is the easy one. They run comparable to Microsoft or thereabout. They have various options I haven't looked at yet, that might make them more expensive than that. The DB2 on mainframes and the DB2 on Unix, for instance, were written by different teams. Which might explain why they didn't

Re: Forms 3 and 9i

2003-09-07 Thread Mogens Nørgaard
Nah, that's not neccessary. It's the same guy that took them from 7 to 8 and who will take them from 9 to 10 :-), namely our Jutland Department named Johannes. We had a meeting about iAS in the Danish user group the other day (OUGDK) titled Can you get by without iAS?, in other words is it

RE: Urgent INFO needed. - OFF TOPIC

2003-09-07 Thread VIVEK_SHARMA
Well-Spoken Indeed -Original Message- Sent: Friday, September 05, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Yes, in your experience...and maybe most of the other lister's experience...majority of the time its true... That's because you people are the best DBAs I've seen...