Re: Table not reusing deleted space

2003-10-03 Thread Kaing, Leng
Hi Daniel, Thank you so much for solving part of the mystery. This is the best explanation I've got yet. I think you may be right. Our avg. row len. is more than 5K and our database is 8k block. I can't believe that the 1G is spread EVERY single 4G block. So how does Oracle determine which 5

RE: how to send mail from windows command prompt?

2003-10-03 Thread Robson, Peter
Yes, doing this all the time, all in a Dos window, Use 'find' to search through your log files, extracting the lines you want to another file, which you can mail to yourself. eg: find /N ORA-1 G:\dos_work\work.log G:\dos_work\pk_violate.txt I use a simple dos mail utility called Postie

RE: how to send mail from windows command prompt?

2003-10-03 Thread Paulo Gomes
Maybe if u can contact me directly I can help. I doing it directly from the database without Enterprise manager. Regards PG -Mensagem original- De: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Enviada: quinta-feira, 2 de Outubro de 2003 23:15 Para:

RE: Seems odd to me....(bug?)

2003-10-03 Thread April Wells
Title: RE: Seems odd to me(bug?) something other than a table? Synonym that the inserter only has select on? see what you can find in all_objects or all_tables -Original Message- From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: 10/2/2003 5:39 PM Subject:

Re: Experiences setting OPEN_CURSORS for Java applications

2003-10-03 Thread Prem Khanna J
Craig, Thanx for your tool. Right now,let us (developers) use it with Jboss and let u know if there is any issue. Thanx a lt for your support. Regards, Jp. 02-10-2003 21:41:15, Craig Munday [EMAIL PROTECTED] wrote: Jp, I've forwarded you a separate email with the tool included as an

exam

2003-10-03 Thread bulbultyagi
Thanks Do you feel you learned anything from this exam? My initial answer was : If there is one thing that I have learnt from this exam , its that studying for an exam is different from studying. This principle doesn't seem to apply so much to backup and recovery , adminstration fundamentals

Re: Development environments

2003-10-03 Thread Pete Finnigan
Hi Jared Interesting article that is quite current. I have just started to use ultraedit on windows very recently after using textpad for years for development. I use vi of course on unix. I moved to Ultraedit mainly for the reason it allows macros to be edited, this is the one failing with

RE: Development environments

2003-10-03 Thread Robson, Peter
Interesting to see the reference to Ultraedit. Been my regular editor for many years now. Macros are particularly useful, but also the ability to column edit. Often used it in association with spooled output, macro manipulation, then subsequent data input (in migration work, for example). peter

RE: how to send mail from windows command prompt?

2003-10-03 Thread Mercadante, Thomas F
I use Postie with Perl also. Perl does the log file searches for error and uses postie to send mail. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, October 03, 2003 5:14 AM To: Multiple recipients of list ORACLE-L Yes, doing this all the time, all in a

EMC striping question

2003-10-03 Thread Hans de Git
Hi All, Today I saw an archived thread on orafaq about striped volumes in an EMC Symmetrix. Gaja mentioned that writing to a striped volume is performed in a sequential fashion i.e. spindle B will not start writing block 2 before spindle A has completed writing block 1. Is this still true for

Re: workarea_size_policy=auto and performance efficiency [was: Re:

2003-10-03 Thread Richard Foote
Hi Tim, Good questions. As you mention, the memory Oracle says and thinks it's released and what it actually releases to the kernel has generally been two different things. However, the behaviour with P_A_T is somewhat different. A simple little test for the unconvinced is to simply issue

Re: Deterministic Functions: am I missing something?

2003-10-03 Thread Connor McDonald
As far as I know, with all current releases of Oracle, determinism is purely for function based indexes. The deterministic keyword indicates that the function values when you created the index are still preserved when you query it. Thus the first execution was during index creation, and the

Re: Wooo.....Cary's book -- Out of stock !

2003-10-03 Thread Prem Khanna J
i got my copy too from bookpool. .need to start reading it. happy weekend (with cary's book in hand) everybody. Jp. 30-9-2003 22:54:27, Stephane Paquette [EMAIL PROTECTED] wrote: I've also picked up my copy yesterday but ...I'm assuming everyone else has theirs by now and are busily

test

2003-10-03 Thread Jeffrey Beckstrom
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: EMC striping question

2003-10-03 Thread Matthew Zito
Hi Hans, Absolutely not true, and has not been true for a long time. Writes to an EMC never go directly to disk anyway, and when they do go to disk is purely determined by the microcode algorithms, and will often have nothing to do with stripe layout at all. Thanks, Matt - Original

Re: Oracle Client for Macintosh

2003-10-03 Thread Steve Finger
You guys should look harder ;-) If you go to technet download area there is a developer release for Oracle for the Mac. After you select it you need to take a survey to get to the download area. There you will find the client software for Mac OSX. It's not an easy install but it works. It

RE: Seems odd to me....(bug?)

2003-10-03 Thread Odland, Brad
Ran into somthing like this when MS Access (Old Microsoft ODBC drivers) was used to create or copy a table from access to Oracle. It created a table with lower case letters. The table existed but when SQLPlus is used all SQL is converted to upper case. I don't know if this is your case but it

RE: how to send mail from windows command prompt?[Scanned]

2003-10-03 Thread Bob Metelsky
Use blat http://www.interlog.com/~tcharron/blat.html using blat is as simple as copying the exe to the windows system folder install as blat -install yourmailserver [EMAIL PROTECTED] 5 25 then call as shown below here is an example of blat used in a script

Re: Seems odd to me....(bug?)

2003-10-03 Thread Mladen Gogala
Chris, normally you should get only the table or view does not exist, but you are also getting ora-0604 which leads me to the conclusion that there's more to it them meets the eye. Also, the recursive SQL level 1 is confusing. My suggestion would be to catch the offending SQL, on the system

Re: 8i OCP Net8 Exam

2003-10-03 Thread Richard Foote
Hi Dennis, There's no need to apologise. I don't blame you for trying to get the OCP in manner that's reduces risk and improves one's chance of success. The path of least resistance is one that is followed by human nature and if I were in your shoes and had your pressures I would do exactly the

Re: EMC striping question

2003-10-03 Thread Hans de Git
Sorry Matt, Just checked with EMC netherlands, unfortunately, I'm right. About the cache: a shared cache is easily flooded with large io's. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 03 Oct 2003 06:01:00 -0800 Hi Hans, Absolutely not true,

Re: 8i OCP Net8 Exam

2003-10-03 Thread Richard Foote
Hi Faan, I really do sympathise with folks that are kinda dragged into this whole OCP debacle by people who have obsoletely no understanding of how it's implemented and administered (HR heavies, higher management, recruitment agencies, outsourcing and system integrating organisations, etc.). And

RE: EMC striping question

2003-10-03 Thread Khedr, Waleed
This could be true on the request level. But it will not stop it from pipelining other requests on the spindle level, so that when spindle A is done for request 1 it works on request 2. This increases the overall throughput of the system. Then using Async IO should help here. I'm talking about

RE: Deterministic Functions: am I missing something?

2003-10-03 Thread Kevin Toepke
One of the optimizations behind the DETERMINISTIC keyword is that Oracle caches previously computed values. If you pass the same values into the function twice, the function body will execute at least once and at most twice. You can NOT count on the function body being executed for each call.

Re: perl dbi dbd

2003-10-03 Thread Keith Moore
I'm in the process of doing the same thing. You can go to http://www.cmve.net/~merijn for a compiled version of Perl 5.8.1 that is prepared from DBI and DBD::Oracle. That will save you from compiling it yourself. My understanding is that you will still need gcc (or the HP ansi compiler) to compile

RE: how to send mail from windows command prompt?

2003-10-03 Thread Goulet, Dick
If you want an SMTP enabled mailer, similar to mailx, just send me a note, privately. Your absolutely welcome to it. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, October 03, 2003 5:14 AM To: Multiple recipients of list ORACLE-L Yes, doing

Cary's book

2003-10-03 Thread Mladen Gogala
I enjoy immensely reading Cary's book, but I have some questions that I want to ask publicly. Recently, I made a comment about Chris Lawson's book being a Dale Carnegie book for a DBA and now I see that Cary is also advising feeding the hungry business users (buy him a sandwich). It is true that

Re: Table not reusing deleted space

2003-10-03 Thread Daniel Fink
Leng, I am going to have to defer to others on the freelist algorithm. I have not done any examination/testing and don't want to make assertions that would cause more problems. Daniel Kaing, Leng wrote: Hi Daniel, Thank you so much for solving part of the mystery. This is the best

RE: perl dbi dbd

2003-10-03 Thread Jesse, Rich
A...I wasn't sure about the ANSI C requirement. And I see on the HP box that I've installed DBI on that gcc is installed. :) One other note: if you do use gcc, I've had a truckload of problems with v3.3.x (mostly on Linux) -- stick with v3.2.x. Rich Rich Jesse

Re: workarea_size_policy=auto and performance efficiency [was: Re:

2003-10-03 Thread Richard Foote
Hi Tim, Good questions. As you mention, the memory Oracle says and thinks it's released and what it actually releases to the kernel has generally been two different things. However, the behaviour with P_A_T is somewhat different. A simple little test for the unconvinced is to simply issue (this

RE: Seems odd to me....(bug?)

2003-10-03 Thread Chris Stephens
What am I doing wrong here? SQL alter system set events '942 trace name errorstack forever, level 10' 2 ; System altered. SQL insert into sbc_global.employee_role values ('d','dd',8); insert into sbc_global.employee_role values ('d','dd',8) * ERROR at line 1:

[no subject]

2003-10-03 Thread William . Thater
-- 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

Sequence and order by

2003-10-03 Thread Khedr, Waleed
Is this documented anywhere? SQL drop sequence test_seq; Sequence dropped. SQL SQL create sequence test_seq; Sequence created. SQL SQL select test_seq.nextval 2 from dual; NEXTVAL -- 1 SQL SQL select test_seq.nextval 2 from dual 3 order by dummy; select

Re: Cary's book

2003-10-03 Thread rgaffuri
I personally feel that its managements call to make these kinds of decisions. If they are bad decisions its both their fault and their problem. If this forces you to work an incredible amount of hours, quit and go somewhere else. Hard to say that in a slow economy though. To be fair, I feel

RE: Seems odd to me....(bug?)

2003-10-03 Thread Mladen Gogala
Are you connecting through a dedicated server connection? On Fri, 2003-10-03 at 11:29, Chris Stephens wrote: What am I doing wrong here? SQL alter system set events '942 trace name errorstack forever, level 10' 2 ; System altered. SQL insert into

Re: Huge optimization costs with 9.2

2003-10-03 Thread Richard Foote
We has problems with another undocumented parameter that changed when we migrated to 9i in August last year. _B_TREE_BITMAP_PLANS change from false to true and caused a number of issues with sub-optimal execution plans. Another possible trap for the unwary ... Cheers Richard - Original

Re: Development environments

2003-10-03 Thread Pete Finnigan
Hi Peter It does seem to be a very good editor from what I have read about it and seen from my use so far, as i say quite recent use. I write quite a lot of pl/sql and C and Pro*C and I wanted particularly to explore the macros and tools to see what code i can generate. I am a fan of generating

RE:

2003-10-03 Thread Thater, William
Thater, William scribbled on the wall in glitter crayon: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net i do apologize. it appears outlook is not playing nice with others. there was a note in there to start with. -- Bill Shrek Thater ORACLE DBA I'm going to work

Re: RE: Cary's book

2003-10-03 Thread rgaffuri
How much you open your mouth depends on who you work for. You can open your mouth to the unemployment line. Alot of managers feel that you are undermining their authority if you correct them in meetings. I had one manager tell me that I was doing just that simply by answering co-workers

RE: Cary's book

2003-10-03 Thread Mladen Gogala
Sorry for replying on your private email. Here it goes again: Robert, no doubt that what I called a geekish culture is at fault here, and to the large part, at that. Personally, I do speak up, may be even too loud. But consider this: I've recently changed jobs, because of a row over something

RE: Cary's book

2003-10-03 Thread Freeman Robert - IL
Mladen, this is not directed specifically at you, but you have raised something in my mind that often just irritates the heck out of me. I often hear the term Damagement, damagers, etc... and I understand it, and have had more than a few occasions where a damager has killed me Management is

Re: Huge optimization costs with 9.2

2003-10-03 Thread Todd Boss
How many more of these undocumented but seemingly crucial optimizer parameters has changed from 8i to 9i? I'd think these are a bit more important to know about. Anyone have a list of these changed parameters? Are they noted in the 9i docs? boss We has problems with another undocumented

RE: Cary's book

2003-10-03 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: accept a pay cut. So I left. So far, so good. I'm new at the company, I don't have enough business knowledge in this new line of work and the company is a well entrenched company with power players whose roles I don't understand quite

Re: Cary's book

2003-10-03 Thread Gudmundur Josepsson
Mladen, Hard times present problems because people do not want to pay for a competent DBA but frequently hire a shaman or a witch doctor who improves on the system based on snake oil type techniques. If I cannot get more money then some bozo after a If you know you're better than the bozo

toad on linux

2003-10-03 Thread becker . bill
Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS

Re: RE: Cary's book

2003-10-03 Thread Gudmundur Josepsson
Looks like this discussion is moving into peopleskills-l. Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

RE: alter system

2003-10-03 Thread Chris Stephens
Thank You!!! Found this in the trace file ORA-00942: table or view does not exist Current SQL statement for this session: INSERT INTO SBC_GLOBAL.MLOG$_EMPLOYEE_ROLE (dmltype$$,old_new$$,snaptime$$,c hange_vector$$) VALUES (:d,:o,to_date('4000-01-01:00:00:00','-MM-DD:HH24:MI: SS'),:c)

RE: toad on linux

2003-10-03 Thread Mark Leith
Tora. You can get a copy for Linux free of charge, although the Windoze version has a commercial license charge. For more info: http://www.globecom.se/tora/ For the Linux/Oracle 9 rpm: http://prdownloads.sourceforge.net/tora/tora-1.2.4-1oracle9.i686.rpm HTH Mark

RE: Cary's book

2003-10-03 Thread April Wells
Title: RE: Cary's book That only works up to the point where they are willing to pay. It's sad, but you can STILL get a job with the OCP letters after your name, regardless of what you can or can't do. The idea is that they are paying you bottom line because you have no experience... but

RE: toad on linux

2003-10-03 Thread Jamadagni, Rajendra
Title: RE: toad on linux TORA you'll love it. search on sourceforge.net ... Raj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, October 03, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Subject: toad on linux Hello, It

Re: toad on linux

2003-10-03 Thread Ron Rogers
Bill. There is a TOAD like producty called TORA that runs on linux. Google for it and download the tar file. The new EM 4.0 ( due out with 10G) is suppose to be browser based allowing you to run it from and os browser. Ron [EMAIL PROTECTED] 10/03/03 12:24PM Hello, It appears that Toad does

Re: Cary's book

2003-10-03 Thread Nuno Souto
- Original Message - education and my life in general. No, until there aren't more jobs, I'll keep on the safe side. That's the part where crisis and CYA methodology jump in. I have no solution, but, unfortunately, I don't have Christ-like qualities that are asked from me in every

Re: Cary's book

2003-10-03 Thread Daniel Fink
Robert, Well said. I think the problem goes farther back than just us sitting in our cubes. I hate to stereotype, but there is some truth in saying that 'geeks' tend to be somewhat introverted, where many in management are somewhat extroverted. This year's IOUG-A Live was a great example. Here we

Re: toad on linux

2003-10-03 Thread Rodd Holman
Tora http://www.globecom.se/tora Works great. On Fri, 2003-10-03 at 11:24, [EMAIL PROTECTED] wrote: Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on

RE: Cary's book

2003-10-03 Thread Freeman Robert - IL
Marketing is as much as how you present yourself as it is anything else. I've seen uncertified and unexperienced guys who could write a resume that would make you think they could walk on water, reorg, defrag, code in C#, asp and java all while designing the newest, latest, greatest hybrid

RE: Cary's book

2003-10-03 Thread Bellow, Bambi
Title: RE: Cary's book This is a difficult question that I've had to face more than I would have liked in the past 2 years. The way to do it is to mark your prices down and say that comparing bang for the buck, you've got a bigger bang... and maybe they can squeeze out a better buck... and

RE: EMC striping question

2003-10-03 Thread Tony Johnson
Why worry about how it gets written. The cache will make any implementation sing like a bird. And if you think you are having problems just add more cache and that will take care of it. - As told to us by a past EMC Sales Weenie -Original Message- Sent: Friday, October 03, 2003 6:50 AM

RE: Steps to convert a RAC to a single instance.

2003-10-03 Thread Tony Johnson
I guess this means it is breakable -Original Message- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hello All: We had purchased RAC to provide high availability of datawarehouse to our customers.

RE: Cary's book - Rapidly moving OT....

2003-10-03 Thread Freeman Robert - IL
Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. Well I've brought my share of children into the world, thats for sure I'd wager I have more than just about anyone

RE: toad on linux

2003-10-03 Thread Jesse, Rich
I agree that TOra (http://www.globecom.se/tora/) is a fine program and the best Linux alternative to TOAD, but it still lacks a lot of the spit-n-polish of TOAD that makes it more usable to me. Try it out and see. And after further review, the Bears still suck... Rich Rich Jesse

RE: Cary's book - Rapidly moving OT....

2003-10-03 Thread Brian Dunbar
Freeman Robert - IL [mailto:[EMAIL PROTECTED] on Friday, October 03, 2003 12:09 PM Well I've brought my share of children into the world, thats for sure I'd wager I have more than just about anyone else here on Oracle-L in fact... Anyone have more than 5?? I've six here. ~brian --

RE: Cary's book

2003-10-03 Thread Freeman Robert - IL
Offshore impacts are killers on rates these days... However, It is my feeling that this will be self correcting in about 2 years when everything is totally screwed up, and mark my words, things will be. I've seen way to many offshore projects fail. Big projects will be way over budget, way behind

RE: Cary's book

2003-10-03 Thread Freeman Robert - IL
Daniel, I agree 100% with what you said Somehow we must find a way to come out of our shell. I am among those coming out of my shell is HARD standing up at IOUG-A, or UKOUG or wherever and speaking to that room full of people is one of the hardest things I do. I just make myself...

Re: Cary's book

2003-10-03 Thread Rachel Carmichael
I've spent a lot of my life in highly structured corporate America -- cutthroat corporate. I've managed not to make enemies, to gain credibility, to make my issues known, to learn when to fight and when to compromise. The techniques I used are in the presentation I'm giving at UKOUG :) ---

Re: Cary's book - Rapidly moving OT....

2003-10-03 Thread Nuno Souto
- Original Message - Ooops, did I send private instead of public? Apologies if so. It's late here and I'm half asleep already. Just waiting for the flu pills to kick in. in fact... Anyone have more than 5?? 3 here. Only 2 now. Also, I'm rapidly becomming a single parent, as

Re: Cary's book - Rapidly moving OT....

2003-10-03 Thread Daniel Fink
Ah, yes... No kids here, but I do have pet potbellied pigs to support. Anyone have more than 2? ;) Dan Brian Dunbar wrote: Freeman Robert - IL [mailto:[EMAIL PROTECTED] on Friday, October 03, 2003 12:09 PM Well I've brought my share of children into the world, thats for sure I'd

RE: The Increasingly Inaptly Named Cary's book Thread

2003-10-03 Thread Bellow, Bambi
About 20 years ago, discussing this very trend, a friend mentioned that what we need is a computer professional union (CPU, we called it), but that geeks were disinclined to go that direction because we were a bunch of cowboys and wouldn't make personal sacrifices for common goals. Now that all

RE: Cary's book

2003-10-03 Thread Mladen Gogala
Let me clarify things further. In Cary's book, there is a part when he describes a meeting when a manager was saying things that were plain stupid and nobody would correct or interject his monologues. He further ruminates over that not being a proper way to handle a performance problem. Well,

RE: Seems odd to me....(bug?)

2003-10-03 Thread Chris Stephens
Title: RE: Seems odd to me(bug?) 1 select owner, object_name, object_type, status 2 from all_objects 3* where object_name='EMPLOYEE_ROLE' SQL / OWNER OBJECT_NAME OBJECT_TYPE STATUS -- -- -- ---

RE: Cary's book

2003-10-03 Thread Thater, William
Freeman Robert - IL scribbled on the wall in glitter crayon: Daniel, I agree 100% with what you said Somehow we must find a way to come out of our shell. I am among those coming out of my shell is HARD standing up at IOUG-A, or UKOUG or wherever and speaking to that room full

RE: Seems odd to me....(bug?)

2003-10-03 Thread Jamadagni, Rajendra
Title: RE: Seems odd to me(bug?) see ... it says recursive SQL ... it probably mean some trigger is firing ... on the table. Raj -Original Message- From: Odland, Brad [mailto:[EMAIL PROTECTED]] Sent: Friday, October 03, 2003 10:19 AM To: Multiple recipients of list ORACLE-L

RE: The Increasingly Inaptly Named Cary's book Thread

2003-10-03 Thread Odland, Brad
your firedsecurity will be there pack up your things and escort you to your car -Original Message- Sent: Friday, October 03, 2003 12:40 PM To: Multiple recipients of list ORACLE-L About 20 years ago, discussing this very trend, a friend mentioned that what we need is a computer

RE: Cary's book - Rapidly moving OT....

2003-10-03 Thread Bellow, Bambi
7 cats, 3 dogs and kittens on the way! -Original Message- Sent: Friday, October 03, 2003 12:40 PM To: Multiple recipients of list ORACLE-L Ah, yes... No kids here, but I do have pet potbellied pigs to support. Anyone have more than 2? ;) Dan Brian Dunbar wrote: Freeman Robert -

Re: Cary's book - Rapidly moving OT....

2003-10-03 Thread Jared . Still
Very interesting and relevant discussion. One point that stands out is that we must make ourselves valuable to the business we work for. If we don't, then we're just too easy to replace. My manager ( who is definitely *not* a damager, thank goodnes ) has made me the IT lead for Sarbanes Oxley.

RE: how to send mail from windows command prompt?

2003-10-03 Thread Jared . Still
Tom, If you're mailing from Perl, why not just use 'use Mail::Sendmail'? Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/03/2003 06:50 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

Re: Cary's book

2003-10-03 Thread Mladen Gogala
On Fri, 2003-10-03 at 12:54, Daniel Fink wrote: Robert, training, OCPs/OCMs, etc, but how many of us have taken a corporate communication class or engaged a business/personal coach? I've actually taken Dale-Carnegie class. You can judge my success by my emails. Introvert is one thing I've

Re: Cary's book - Rapidly moving OT....

2003-10-03 Thread Mladen Gogala
Reply is inline. On Fri, 2003-10-03 at 14:19, [EMAIL PROTECTED] wrote: Very interesting and relevant discussion. A good one for Friday. TGIF. I see this as an opportunity to make myself more valuable to the company, and intend to take advantage of it. Jared, you are valuable to us,

RE: Cary's book

2003-10-03 Thread April Wells
Title: RE: Cary's book HEY... I took those classes. Didn't help a wit. I REMEMBER one of the laws... but it is just SO hard.. Don't criticize, condemn or complain. April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really

RE: Cary's book

2003-10-03 Thread Thater, William
Title: RE: Cary's book -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Friday, October 03, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Cary's book If you can't get through the screeners that say... oh, you have X amount of

Re: RE: Cary's book

2003-10-03 Thread rgaffuri
experience is far more important than the OCP and degrees. In a tight market there are multiple people with experience and degrees. To be fair, experience is more important than skill. Employers often assume that someoen with alot of experience has alot of skill. We have all worked with people

Cannot use Order By with XMLAGG()

2003-10-03 Thread Jake Johnson
Hello, I cannot use order by in with my xmlagg clause. Any ideas??? Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SELECT XMLELEMENT(Department, XMLAGG(

RE: Cary's book - Rapidly moving OT....

2003-10-03 Thread Freeman Robert - IL
OH NO!!! 7 cats, 3 dogs and kittens on the way! reminds me of Ghostbusters: Dr. Peter Venkman: This city is headed for a disaster of biblical proportion. Mayor: What do you mean, biblical? Dr. Raymond Stantz: What he means is Old Testament, Mr. Mayor, real wrath-of-God type stuff. Fires and

RE: Cary's book

2003-10-03 Thread Freeman Robert - IL
If you have a mean SOB of a boss, the first rule is that he's always right. The second rule is that in case of a doubt, the 1st rule applies. I disagree, and most strongly. If you are a newbie, no experience type, then by all means SIT DOWN, SHUT UP and LISTEN. If, on the other hand, you are

RE: how to send mail from windows command prompt?

2003-10-03 Thread Mercadante, Thomas F
Jared, I know you sent me this once before. My problem is that I don't have control of my servers - I'm not the Admin on them. So I can only use the Perl stuff that was installed. And it's very basic stuff. So your suggestion is not available to me. thanks Tom Mercadante Oracle Certified

RE: Cary's book

2003-10-03 Thread DENNIS WILLIAMS
Bill - Well you could get their attention by crashing a hummer into their building. JUST KIDDING. Actually, I think the book for you might be What Color is Your Parachute. The system is set up to favor someone with the right experience and credentials and age. There are many people that don't fit

RE: Cary's book - Waxing philosophic

2003-10-03 Thread Odland, Brad
Since everyone is jumping on this non technical thread I thought I would too... Certainly the first chapter was fresh and brought some aspects of performance tuning into perspective. Specifically keeping a big picture perspectivehow true... in that vein I ask.. Why do we do the work we

RE: Cary's book

2003-10-03 Thread DENNIS WILLIAMS
I have often wondered if the problems between DBAs and management stem from mutual disrespect. The manager feels awkward in being forced to hire an expert in an area he/she knows nothing about. Tries to make suggestions in order to flush out whether this expert really knows anything. The

Re: Huge optimization costs with 9.2

2003-10-03 Thread Jared . Still
Here's a script to show differences in default parameter values between releases. Kind of interesting results. Jared -- parmdiff2.sql -- show init parms that differ between instances -- a parameter is displayed only if it appears -- in both database, and is set to default -- -- the purpose of

Re: Cary's book

2003-10-03 Thread Gudmundur Josepsson
Title: RE: Cary's book The only way you can look bad to the bottom line is if what you charge for your work costs more than the business gains by what you have done/are going to do. If you spend 40 hours shaving 5 minutes off of a 4 hour batch job that has a 5 hour window to run then you're

RE: how to send mail from windows command prompt?

2003-10-03 Thread Erik Williams
Check out a dos program called BLAT. I think that is what you are looking for. Erik -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to send mail from

Re: Cary's book

2003-10-03 Thread Rachel Carmichael
training, OCPs/OCMs, etc, but how many of us have taken a corporate communication class or engaged a business/personal coach? I've taken several. Citibank was good about training people to deal with people. --- Daniel Fink [EMAIL PROTECTED] wrote: Robert, Well said. I think the problem

RE: Cary's book

2003-10-03 Thread Paula_Stankus
Guys, Very impressive discussion. Here's the bottom-line. We cannot afford to be technically efficient/competent without also understanding the politics of the organization we work in. As DBA's we cannot just manage the backups, maintenance, tuning - nor can we ignore the applications we

RE: Cary's book - Waxing philosophic

2003-10-03 Thread Orr, Steve
In the end... They will remember who you were as a person. Hmmm... Is there a certification test I can take to prove I'm a real live boy. Pinocchio -Original Message- Sent: Friday, October 03, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Since everyone is jumping on this non

RE: Cary's book

2003-10-03 Thread Bellow, Bambi
DBAs, for the past three or four years, have been on top of the food chain when it comes to rates. I'm a bit of an exception to the DBA world, having been a DBA for 15 years, a developer for 13 years, a system manager/administrator for 9 years and a team lead/tech lead for 10 years, I can pretty

RE: Cary's book

2003-10-03 Thread Mladen Gogala
On Fri, 2003-10-03 at 15:29, DENNIS WILLIAMS wrote: The manager feels awkward in being forced to hire an expert in an area he/she knows nothing about. Tries to make suggestions in order to flush out whether this expert really knows anything. And you call a guy who makes suggestions about

RE: Cary's book[Scanned]

2003-10-03 Thread Bob Metelsky
A few years ago being an experienced DBA was a valuable commodity and we really enjoyed that. But the managers were very frustrated by having to search hard for a DBA, pay spiraling salary demands, etc. I think some managers look on these times as their revenge. What some DBAs see as pay cuts

Re: Cary's book

2003-10-03 Thread Mladen Gogala
On Fri, 2003-10-03 at 15:49, Rachel Carmichael wrote: I've taken several. Citibank was good about training people to deal with people. Navy seals do that as well. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged

RE: Cary's book - Waxing philosophic

2003-10-03 Thread Thater, William
Odland, Brad scribbled on the wall in glitter crayon: Why do we do the work we do...?? because after 35 years of programming, database design and development and DBA work, when i get to solve the problem in an elegant manor the rush is still there. -- Bill Shrek Thater ORACLE DBA

RE: Cary's book - Waxing philosophic

2003-10-03 Thread Brian McGraw
As Robert said...some battles are best left unfought (or at least given some attention) Or, as some of us in the Southern U.S. would say: A dog will whip a skunk every time. But sometimes, it's not worth the stink. Gotta love OT Fridays. :) Brian - | Brian

RE: Cary's book[Scanned]

2003-10-03 Thread Rachel Carmichael
management here doesn't believe in time off for user group meetings. which is sort of to the point of this discussion. They want me to be up to speed on all the latest, greatest, bells and whistles of Oracle but they won't give me the time or money for the acquisition of that knowledge. --- Bob

  1   2   >