Re: bash: ./genclntsh: bad interpreter: Permission denied

2002-06-27 Thread Nils Höglund
> ltiu wrote: > > > > Hello, > > > > Could someone help me decipher the following: > > > > "sh: ./genclntsh: bad interpreter: Permission denied" > > > > Thanks. > > > > ltiu > > Comes from #!/bin/sh on the first line. You must run some kind of > extraterrestrial Unix where sh is not located

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Sujatha Madan
But Tim just said what I said! ... how dumb am I! duh!!! I think I'll creep back into my corner! Sorry Tim, Kirti and whoever else. -Original Message- Sent: Friday, 28 June 2002 4:03 PM To: Multiple recipients of list ORACLE-L Kirti, Taking another tack... Why would they want to

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Sujatha Madan
Kirti, I forgot to add this: If you are using Thin clients you can't read v$session properly. For some reason it doesn't populate properly and you can't correlate anything. Regs, Sujatha -Original Message- Sent: Friday, 28 June 2002 4:03 PM To: Multiple recipients of list ORACLE-L

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Sujatha Madan
Hi Kirti, We ran into the same kind of issues with IBM's Websphere. I think that is kind of like WebLogic. We kept hitting max_processes each time and the customer blamed the listener then they blamed the firewall for timing all the connections out. After extensive tests we found that it was a p

Re: Rollback OPTIMAL setting

2002-06-27 Thread Tim Gorman
cool! thanks! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 10:28 PM > I do the same thing. No optimal setting, manual (automated job) shrinking of > rollback segments when database has no DML activity (mostly just bef

Re: WebLogic, Oracle JDBC related

2002-06-27 Thread Tim Gorman
Kirti, Taking another tack... Why would they want to use JDBC Thin? Typically, the "thin" driver is intended for environments where the "Oracle Client" is not expected to be installed (i.e. applets on the browser) and the JDBC "OCI" driver for environments where the "Oracle Client" is expected

Re:Oracle Performance Tuning steps

2002-06-27 Thread Chetan
Dick , Thanks a ton for ur feedback. I ran UTLBSTAT/UTLESTAT and found out that the problem was with memory. Then I went and queried V$SGASTAT, V$SQLAREA, V$SQLTEXT. Can u tell me if there can be any other problems ? I found out later that there were some indexes added afterwards. Thanks nyways. Ch

RE: the ora certified masters cert

2002-06-27 Thread Rodd Holman
Mike, I am moderator on a yahoo group. Just last month we had one of these scam purveyors trying to peddle their stolen exams to list members. She was quickly banned from the list for such postings. I get at least a post or two like that sent to me every 2 -3 months. Most of the thieves I've s

Re: Virtual drive on Solaris

2002-06-27 Thread Tim Gorman
Ferenc, What a small world! That class in Dallas was the very first teach of the excellent "Oracle Server Internals" seminars anywhere, ever. Originally, Scott Gossett was supposed to teach all of them, but he was booked at the time so Oracle Education hired me as a replacement contractor to de

RE: Rollback OPTIMAL setting

2002-06-27 Thread Deshpande, Kirti
I do the same thing. No optimal setting, manual (automated job) shrinking of rollback segments when database has no DML activity (mostly just before midnight). No ORA-1555 in several years now. About the space for rollback, we are very generous. Tom Kyte explains this very well in his wonderful b

Re: WebLogic, Oracle JDBC related

2002-06-27 Thread Murali Vallath
Good discussion. We have exactly the same setup. You are correct Suzy. However would like to confirm that WL manages the connection pools and like Suzy has mentioned is how they are set. Before starting the application a minimum number of connection pools are defined for weblogic and when the

Re: the ora certified masters cert, yet again

2002-06-27 Thread Henry Poras
I don't know. Sort of makes me feel like a poodle. Henry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 9:13 AM > The question is, are you going to allow your > clearminded moral stance and total disdain for a > thinly ve

Re: WebLogic, Oracle JDBC related

2002-06-27 Thread Suzy Vordos
Again, I'm a little rusty on WL, it's been awhile (4.5) and don't have access to a current working environment. So, someone please correct where I'm wrong... The WL server does manage the connection pool. The WL server creates a pool of database connections at server startup (initialCapacity)

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Rodd Holman
First you must have a demonstrated need to have access to classified material (that's US Gov't Classified not business classified). Then you need to submit the reams of paperwork through your security officer that will initiate the SBI. This is the stuff where you write down everything you ever

RE: the ora certified masters cert, yet again

2002-06-27 Thread Grant Allen
Don Granaman[SMTP:[EMAIL PROTECTED]] wrote: > >"What do you hate/find-frustrating about Oracle?" (Let me count the > ways... > >) That could easily be the most > >revealing interview question ever conceived! I love it!!! > It works wonderfully for me. I've seen a few faces go completely blank

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Long . Nguyen
Suzy, You said "The app java code should be managing the allocation and release of connections within the pool". Do not know anything about connection pool, so this might be a naive question: It seems to me that it is not a good set up if the applications have to do the pool managing themselve

RE: recording SQLPlus activity

2002-06-27 Thread Craig Munday
Title: RE: recording SQLPlus activity Ray, The integration problems you seem to be having sounds like the problem is more with the cowboys...errrdevelopers :-)  Or with the processes and procedures in your development group. I would have thought that with a hundred or so developers it

RE: Oracle AQ & MQ Series

2002-06-27 Thread Peter . McLarty
That's probably because they want to sell you Interconnect, it is Oracles version of MQ and by linking messaging gateway to AQ you are replicating a lot of the base functionality of MQ or Interconnect, ie you have a messaging component that can store and manage messages. Keep adding appropriat

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread MacGregor, Ian A.
When i was stationed with the Navy in Panama.  I got  to store the  suitcase which CINCLANT  carries around with  him in case the bubble goes up.  No,  I couldn't of started World War III.  No OCP's  to target.  The trouble was that I had no SIOP clearance.  No one stationed in Panama did. 

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Khedr, Waleed
Let's go back to OCP! -Original Message- Sent: Thursday, June 27, 2002 6:33 PM To: Multiple recipients of list ORACLE-L I would suggest we take this thread off line as it really is irrelevant with what this list is for. Jared, correct me if Im wrong. Mike -Original Message- [

RE: bash: ./genclntsh: bad interpreter: Permission denied

2002-06-27 Thread Surendra . Tirumala
Pl check the execute permission on the script. I remember I had the same error message with my bash shell. -Original Message- Sent: Thursday, June 27, 2002 4:56 PM To: Multiple recipients of list ORACLE-L ltiu wrote: > > Hello, > > Could someone help me decipher the following: > > "s

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Johnson, Michael
I would suggest we take this thread off line as it really is irrelevant with what this list is for. Jared, correct me if Im wrong. Mike -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Get a job requiring the

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Bill Pass
We are using WebLogic EJB on my current project. We maintain around 150 connections to the main database (+ a whole bunch to other data sources) and this particular aspect of the project works as advertized. My suspicion is that the person setting up the app server does not know how to properly co

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Cornio, Georgette Ms USACFSC
  What BOAT were you on.   I was on the SSBN 618 Thomas Jefferson, for 3 yrs, from 1970-1974.   I did my 1st patrol cycle as a driver myself,  later switched to Fire Control Ballistic, which is where I got started with computers.   I would be the person to launch the Missiles and destroy t

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
Get a job requiring the clearance, either as a direct government employee or as a contractor. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 4:39 PM > To: Multiple recipients of list ORACL

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Johnson, Michael
If a company or a civilian govt agency wants to hire you and put you in for one then it will happen, but like the earlier note said, you have to have a need to have one. FWIW ! Mike -Original Message- Sent: Thursday, June 27, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Yes t

RE: ORACLE API's

2002-06-27 Thread Michael P Sale
Yea, it's called OEM ;) In particular check out the EMD that is part of the new iAS product. This is the future of OEM and in many cases uses shell scripts, perl scripts, tcl scripts, etc... To find this information. The OEM and EMD both have SDKs (emd's just isn't available yet) that allow you

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Thomas Day
My understanding is that they can be held by civilians but that you cannot have one unless your job requires it. Of course, to have that sort of a job you generally have to already have a clearance. That's why they're so valuable in the job market. It's very hard to get one unless you already

RE: Upgrade on Windows Question?

2002-06-27 Thread Michael P Sale
Title: Message If you need to go to 8.1.7 I'd stick with 8.1.7.1 with the latest PSE set (8.1.7.3) or go straight to 8.1.7.4. I am assuming that you are running into no problems and that you will have some decent level of testing before implementing 817 in production. Regards,Michael SaleAut

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Freeman, Robert
For the curious around, does anyone know how one would do such a thing? RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features  Mastering Oracle8i    Clark Griswold: Eddie, has anyone ever told you tha

RE: Re: Re:MTS performance is too bad.

2002-06-27 Thread Michael P Sale
I suspect that if you are getting 4030s with 50 concurrent users that you will get NO benefit from MTS, in fact it will likely cause just the problems you are seeing and you will start to get 4030s sooner than you would have before. MTS is not appropriate as a tool to address your 4030 errors if

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread mkb
Have to add in my 2 cents worth. I last held a Top Secret clearance with the State Dept and it expired sometime in 99 when I left the company that placed me with the State Dept. Basic requirements are that you have to be a US citizen and have a 'clean' background. The TS investigation goes back

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Michael Cupp
Yes to both? Yes to the 1st? Yes to the 2nd? Yes to neither? It wasn't a Yes/No Question - it was a X or Y question. Let me ask a more simple question then - Can a civilian pursue a clearance? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:44 PM To: Mult

RE: PL/SQL & Analyze/validate

2002-06-27 Thread kkennedy
Have you considered "EXECUTE IMMEDIATE 'analyze table etc. etc. etc.'"? Our statistics gathering procedure uses that method quite successfully. Maybe one day I'll get motivated enough and have time to convert to the DBMS_STATS package. Kevin Kennedy First Point Energy Corporation -Origin

Re: Rollback OPTIMAL setting

2002-06-27 Thread Stephen Andert
Tim, I rebuilt the rollback segments without OPTIMAL in one case because the shrinks were causing ORA-1555's at bad times. I have a procedure that is scheduled via DBMS_JOBS to manually shrink the rollback segments to a preset size. This runs at what we have found is a relatively quiet time an

RE: Re[2]: Re:MTS performance is too bad.

2002-06-27 Thread Michael P Sale
As of 8i and beyond you can bump that up to 200 users before it returns benefits, this problem is related to memory issues. Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- [EMAIL PROTECTED

Re: bash: ./genclntsh: bad interpreter: Permission denied

2002-06-27 Thread Stephane Faroult
ltiu wrote: > > Hello, > > Could someone help me decipher the following: > > "sh: ./genclntsh: bad interpreter: Permission denied" > > Thanks. > > ltiu Comes from #!/bin/sh on the first line. You must run some kind of extraterrestrial Unix where sh is not located under /bin (perhaps /usr/bin

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
Yes. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Michael Cupp [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 3:12 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, > Ohio.. > > But

Upgrade on Windows Question?

2002-06-27 Thread Casey A. Jordan
I am upgrading from 8.1.6 EE to a supported release on Windows 2000.  My initial thought is to upgrade to 8.1.7.3.  My questions is has anyone had any problems with 8.1.7.3 on Windows, and what would you suggest as the most stable release for Windows.  I am not looking for new features but m

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
Don't. Its not worth the hassle. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Michael Cupp [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 1:53 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle DBA with TS SCI Clearance Needed

Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread KENNETH JANUSZ
Title: Message I don't know I was in the USN at the time.  Naval Intelligence did my background check, etc. - Original Message - From: Michael Cupp To: Multiple recipients of list ORACLE-L Sent: Thursday, June 27, 2002 3:11 PM Subject: RE: Oracle DBA with TS SC

Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread KENNETH JANUSZ
You should see what we were watching! - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Thursday, June 27, 2002 3:17 PM Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. Uncle Larry is watching y

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread DENNIS WILLIAMS
Michael - My experience (admittedly small) is that the job comes first. Your prospective employer will hire you in the expectation that you will receive the appropriate clearances. You might wind up studying manuals (non-classified) for a month until you receive a clearance. The employer factors t

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Farnsworth, Dave
Uncle Larry is watching you. -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 27, 2002 2:55 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. If your background is clean the

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Michael Cupp
Title: Message But can they be pursued by a civilian, or do they have to be gov't sponsored?  -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:55 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle DBA with TS S

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Scott . Shafer
And then you could have a background like mine which made it rather painful... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 2:55 PM > To: Multiple recipients of list ORACLE-L > Subject:

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread johanna . doran
UH oh you allowed to tell us that? . > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "KENNETH JANUSZ" ><[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle

PL/SQL & Analyze/validate

2002-06-27 Thread Hand, Michael T
I have been building a PL/SQL block to run an 'analyze table validate structure cascade' against a subset of tables in one schema of our database (8.1.7 - daily backup copy of production). I've initially set this up to use OPEN_CURSOR . . . PARSE . . . EXECUTE, but was looking for a prepackaged

Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread KENNETH JANUSZ
If your background is clean these clearances should be no big deal.  When I was driving submarines for a living I had TS, Crypto and COMSUBPAC Special Intelligence clearances.  SI is above TS.   Ken Janusz, CPIM Former U.S.N. Submariner - Original Message - From: Khedr, Wal

Re: Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Alex
Anna Kornikova On Thu, 27 Jun 2002, Jenkins, Michael - EDS wrote: > Just some humor to pass the day. Top things you can do while writing > scripts in the Korn Shell: > > * Listen to a Korn CD > * Eat some popKorn > * Munch on a roasted ear of Korn > * Rub the Korns on your feet > * Have a

RE: Example of AND-EQUALS

2002-06-27 Thread Khedr, Waleed
AND_EQUAL The AND_EQUAL hint explicitly chooses an execution plan that uses an access path that merges the scans on several single-column indexes. The syntax of the AND_ EQUAL hint is: Look at ch7 in Oracle8i Designing and Tuning for Performance Regards, Waleed -Original Message- Sen

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Khedr, Waleed
Another certification! -Original Message-From: Jesse W. Asher [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 27, 2002 3:15 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..Very good question!  I've wondered th

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread MacGregor, Ian A.
What is important is having been investigated and that the investigation is current. Each agency will evaluate the applicant for clearance. Having been given some SCI tickets is no guarantee that you will be allowed access to others. Lie detector tests were quickly becoming de rigeur for

Example of AND-EQUALS

2002-06-27 Thread Jesse, Rich
Hi all, Struggling w/Oracle Support over a possible BUG on 8.1.6.0.0 and Solaris 2.8 where the shared pool can become fragmented by statements which have "AND-EQUALS" access. This has the effect of eventually hitting ORA-4031s. Can someone explain what an "AND-EQUALS" access would be? I assume

Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Jesse W. Asher
Very good question!  I've wondered the same thing myself! Michael Cupp wrote: How would one begin the process of getting one? Or does it have to be government sponsored? -Original Message- Sent: Thursday, June 27, 2002 2:35 PM To: Multiple recipients of list ORACLE-L It is my u

RE: Oracle AQ & MQ Series

2002-06-27 Thread Khedr, Waleed
Title: RE: Oracle AQ & MQ Series I did the same thing: opened a TAR, asked for a product that has this functionality, was told there is no such product, posted some of the doc of the messaging GW, TAR was forwarded to the INTERNAL group, and finally was told I can use the messaging gateway.

Re: Career Opportunities Announcement

2002-06-27 Thread Bill Christison
OK --- Jared Still <[EMAIL PROTECTED]> wrote: > > Please take this offline. > > The management > > On Wednesday 26 June 2002 12:17, KENNETH JANUSZ wrote: > > Any Oracle in Minneapolis / St. Paul, MN? > > > > Thanks, > > Ken Janusz, CPIM > > > > > > - Original Message - > > To: "Multiple

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Michael Cupp
How would one begin the process of getting one? Or does it have to be government sponsored? -Original Message- Sent: Thursday, June 27, 2002 2:35 PM To: Multiple recipients of list ORACLE-L It is my understanding that it currently takes 1.5 to 2 years to get this clearence mainly due

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Johnson, Michael
In some cases this is true. It all depends on the government agency. FWIW. Mike -Original Message- Sent: Thursday, June 27, 2002 8:18 AM To: Multiple recipients of list ORACLE-L I think that test includes a polygraph exam. :-| -Original Message- Sent: Wednesday, June 26, 200

RE: Oracle AQ & MQ Series

2002-06-27 Thread YTTRI Lisa
Title: RE: Oracle AQ & MQ Series Waleed -   I tried implementing AQ to MQ with the MEssaging Gateway.  I could not find anyone at Oracle to support it.  When I would open a TAR, the analyst would come back and say 'this is not an Oracle product'.  I finally got it escalated to the point tha

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Johnson, Michael
It is my understanding that it currently takes 1.5 to 2 years to get this clearence mainly due to events of 9/11. So, if you have one, it behooves you to keep it current. They used to estimate these clearences were worth an additional $10K a year for salary. Im thinking at least $25K now.Al

Oracle to buy part of HP....

2002-06-27 Thread Ron Rogers
>From the searchdatabase site. Is Oracle trying to corral all corners of the market?? == ELLISON CONFIRMS INTEREST IN HP'S MIDDLEWARE | IDG Oracle CEO Larry Ellison confirmed that his company is talking to Hewlett-Packard about buying all or part of HP's middleware business. Ellison said buyi

RE: report showing free space per tablespace over time

2002-06-27 Thread Hately Mike
Hi, on the subject of graphing tools there's a tool on technet called Chart Builder. This is the blurb: Oracle Chart Builder is a real-time Java charting API (Java Bean). It enables more effective communication and analysis of information for business graphics and performance applications. Chart

RE: Forms Question

2002-06-27 Thread Michael Cupp
I'm running 6, how would I go about it? -Original Message- Sent: Thursday, June 27, 2002 12:29 PM To: Multiple recipients of list ORACLE-L It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible t

Tuning NON-network client-server communication

2002-06-27 Thread Tim Bunce
Is there any scope for tuning NON-network client-server communication? Where the client and Oracle server are on the same machine and don't communicate via the network? Are Net8 tuning parameters like SDU size still relevant? Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: the ora certified masters cert, yet again

2002-06-27 Thread johanna . doran
Title: RE: the ora certified masters cert, yet again Wow, I guess Tom Hanks was right!  All of the the answers to life CAN be found in the Godfather! hehehehehhe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Ser

RE: Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Whittle Jerome Contr NCI
Title: RE: Things to do when writing scripts in the Korn Shell Tell Korny jokes. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- Just some humor to pass the day.  Top things you can do while writing scripts in the Kor

Re: Rollback OPTIMAL setting

2002-06-27 Thread Tim Gorman
I personally prefer to have it set, but I think the reasoning against setting it has to do with allowing rollback segments to "find themselves"...  :-)   In other words, it is based on the idea that space allocation (and deallocation) for rollback segment extents is unnecessary and harmful. 

RE: the ora certified masters cert, yet again

2002-06-27 Thread Hately Mike
Waleed, Without wanting to cause offence here (honestly!) I couldn't disagree more with this. At least in the UK right now the Oracle job market is VERY tight. We already have to compete with people padding their CVs and bluffing their way into interviews (a practice which I'm pathologically incap

Re: Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Suzy Vordos
David Korn meets KoRn http://www.kornshell.com/fun/ "Jenkins, Michael - EDS" wrote: > > Just some humor to pass the day. Top things you can do while writing > scripts in the Korn Shell: > > * Listen to a Korn CD > * Eat some popKorn > * Munch on a roasted ear of Korn > * Rub the Korns on

RE: report showing free space per tablespace over time

2002-06-27 Thread kkennedy
Can't recall the name of the graphing tool I used. I selected it because my client was already using it for something else. I don't remember being thrilled with it, but it did the job. As I said before, I used the Kevin Loney scripts originally poached from the Oracle 7 DBA Handbook. Column

Re: Career Opportunities Announcement

2002-06-27 Thread Jared Still
Please take this offline. The management On Wednesday 26 June 2002 12:17, KENNETH JANUSZ wrote: > Any Oracle in Minneapolis / St. Paul, MN? > > Thanks, > Ken Janusz, CPIM > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, June

Survivor Immunity Idols: OCP; Book Authorships; Conference Presen

2002-06-27 Thread Orr, Steve
Hmmm... remember what the comedian Gallagher suggested? Everyone gets a dart gun with 3 rounds to use on bad drivers and when someone accumulates 10 darts sticking to their car they are arrested and their license is taken away. Is the conference presentation rating system is supposed to be like th

RE: the ora certified masters cert - finally bloody sick

2002-06-27 Thread kkennedy
-Original Message- What merit is there in saying "doctors have malpractice insurance and OCP ... should have one too.". [pouring oil on troubled waters] Uhmmm, I took that as humor. I don't think anybody in their right mind wants to link the DBA profession to the legal profession in th

RE: Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Robertson Lee - lerobe
Get therapy -Original Message- Sent: 27 June 2002 17:38 To: Multiple recipients of list ORACLE-L Just some humor to pass the day. Top things you can do while writing scripts in the Korn Shell: * Listen to a Korn CD * Eat some popKorn * Munch on a roasted ear of Korn * Rub the Kor

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread Molina, Gerardo
Kirti, We had a similar situation here where the database hit max_processes due to the number of connection requests. It wasn't the database or listener. I believe it turned out to be a problem with weblogic configuration file. HTH, Gerardo -Original Message- Sent: Thursday, June 27,

Re: WebLogic, Oracle JDBC related

2002-06-27 Thread Suzy Vordos
I'm really rusty on this topic, but... Connection pooling is configured in weblogic.properties, and would look something like this: weblogic.jdbc.connectionPool.=\ url=jdbc:oracle:thin:@hostname:port:db_name,\ driver=oracle.jdbc.driver.OracleDriver,\ initialCapac

RE: Re: Re:MTS performance is too bad.

2002-06-27 Thread Baker, Barbara
Bunyamin: Is performance bad overall, or just for a few sessions? If you have not done so, get the mts script from Tim Gorman's web site (www.evdbt.com). In particular, run the section on active circuit statistics. This should return no rows. If it returns rows, you're in trouble. Track back t

Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Jenkins, Michael - EDS
Just some humor to pass the day. Top things you can do while writing scripts in the Korn Shell: * Listen to a Korn CD * Eat some popKorn * Munch on a roasted ear of Korn * Rub the Korns on your feet * Have a Cream Korn fight with your mate in the next cube. * See how many Korn Chips you ca

RE: WebLogic, Oracle JDBC related

2002-06-27 Thread DENNIS WILLIAMS
Kirti - I'm hoping you get some really good replies to this because it looks like I'll be the victim of BEA shortly. Just my pessimistic side. I really mean to say that the developers will be using WebLogic and I'll have to figure it out from the Oracle perspective. My guess is that WebLogic p

RE: the ora certified masters cert, yet again

2002-06-27 Thread DENNIS WILLIAMS
Thomas - I think you've hit the nail on the head. Reminds me of a line from the Godfather. The old Don is dying and giving his son advice on how to deal with the other Mafia gangs. He says "Don't make them guess what you're up to. They aren't good guessers." Consider HR an obstacle to get past so

RE: Forms Question

2002-06-27 Thread Shaw John-P55297
It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240

RE: the ora certified masters cert, yet again

2002-06-27 Thread Khedr, Waleed
I enjoyed this thread a lot and this is how I see it: If a company is hiring a DBA and they have no people with database experience to interview the candidates then probably any certification could be a factor here. Most of the companies that hire DBA are usually looking for a talent that adds

RE: Re: Re:MTS performance is too bad.

2002-06-27 Thread Wong, Bing
So far, I did not see what is the specific performance problem here. I support one of the five warehouses that has over 300 users and we implemented dedicated servers but we ended up with heavy disk swap because application had external call procedure which gets Unix timestamp from Oracle. Thi

Re[2]: Re: Re:MTS performance is too bad.

2002-06-27 Thread dgoulet
What you get when you read messages in reverse chronological order!! OK, if you've got memory problems, start with trying to address those first. Can you decrease the size of the SGA? Cut the DB_BLOCK_BUFFERS back by a third is possible, limit the shared_pool if you can,and get more memory agai

Re[2]: Re:MTS performance is too bad.

2002-06-27 Thread dgoulet
Pardon me, but I believe I've read somewhere on MetaStink that if your database has less than 150 concurrent users you should not bother with MTS. I've followied that rule of thumb & it does appear correct. Dick Goulet Reply Separator Author: "Yechiel Adar

Re: How to check the charcater set of the export file

2002-06-27 Thread Suzy Vordos
Check Metalink doc# 48644.1 surinder makkar wrote: > > Hi List, > > I keep on taking exports from one machine having > oracle and import it on some other machine with oracle > software. I usually face the problem like this :-- > IMP-00016 required character set conversion (num to > num) not su

RE: conferences - IOUG vs OOW

2002-06-27 Thread Rachel Carmichael
Bill, Don't start salivating for September. For the first time since 9/11, we will be back downtown at the College of Insurance Rachel --- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote: > rachel: > unfortunately i won't be able to make the July meeting or the Hotsos > clinic > - will be on a long

Rollback OPTIMAL setting

2002-06-27 Thread Fink, Dan
One of the constant comments regarding rollback segments is not to set optimal. I am wondering why this setting is often discouraged. I have my own ideas, but I want to gather more opinions and experiences. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456  

RE: the ora certified masters cert, yet again

2002-06-27 Thread Hayes, Scott
How about a newbie's point of view. I have been in IT for twelve years and the last year I have supported 1 Oracle database. Yes I know it's not much but at least it is a start. I have been "lurking" on this list for the past year and have learned a lot from all of you and been confused by all o

Re: the ora certified masters cert, yet again

2002-06-27 Thread Nuno Souto
- Original Message - > list of specifications that were given to them. They also use resume > processing software that is looking for specific hits on specific words. That has always been the problem. Most of these things were written for jobs that have NOTHING to do with IT. Reminds m

Re: the ora certified masters cert

2002-06-27 Thread ltiu
It's like drivers license. You can have one but still be a lousy driver, but if you don't have one and tell people you are a good driver, would people believe you? ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network S

RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-27 Thread Robson, Peter
Title: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. Has this thread got anything to do with WorldCOM?    (... sorry...)   peter edinburgh -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]]Sent: 27 June 2002 15:13To: Multiple recipients

RE: the ora certified masters cert - finally bloody sick

2002-06-27 Thread Weaver, Walt
Psst! Kirti, I have the questions to the exam. Meet me in the alley behind the drugstore downtown and we can hash out a deal... --Walt -Original Message- Sent: Thursday, June 27, 2002 8:19 AM To: Multiple recipients of list ORACLE-L I will now return to my 8i OCP prep. Anyone wants to

RE: conferences - IOUG vs OOW

2002-06-27 Thread Magaliff, Bill
rachel: unfortunately i won't be able to make the July meeting or the Hotsos clinic - will be on a long-awaited vacation. look forward to september meeting (the food at columbia faculty house is pretty good!) -Original Message- Sent: Wednesday, June 26, 2002 10:23 PM To: Multiple recipi

WebLogic, Oracle JDBC related

2002-06-27 Thread Deshpande, Kirti
We are in the process of rolling out a Web Appl that uses BEA WebLogic and Oracle JDBC, thin driver calls to connect to database. These are dedicated connections (No MTS). The listener is overwhelmed with connection requests that at times reach 250+ per second. The 'preferred vendor' is blaming it

Re: Re: Re:MTS performance is too bad.

2002-06-27 Thread Bunyamin Karadeniz
Michael , I have tried all of them , but still performance is very bad. When switch to dedicated mode I get ora:04030.. Have you ever switched to MTS and seen the same performance , I wonder if you are sure about MTS performance is good. What ever I did did not give the same performance as dedic

Re: the ora certified masters cert, yet again

2002-06-27 Thread Jack Silvey
Good morning Don, I know that you are not suggesting that those with the OCP are bad persons. Listers, I suggest that we drop this topic now, since it might start to offend if it goes further. We all have much more in common that we have that divides us, and this topic is a downright silly thin

Database Hung with all processes waiting on locks

2002-06-27 Thread Tortorelli, Mary Jo
We were running 11i Autoupgrade (from 10.7) on HP-UX 8.1.7.3 64-bit Oracle. Yesterday the database hung with every session having a WAITING status in v$session_wait. The MTS processes were 'rdbms ipc message', several workers were waiting on 'row cache lock' and 'library cache pin' and backgro

Re: Career Opportunities Announcement

2002-06-27 Thread Bill Christison
Ken, The 250 miles SE from the twin cities reference was my cute way of suggesting;the position was in Lincolnshire,Illinois(NChicago suburb)If you've Oracle Clinical I'll contact my MINN/STPAUL pharmaceutical client company to ascertain potential staffing need(s).Thanks, Bill Christison --- KE

  1   2   >