Re: SQL*Plus with readline

> On Tue, 16 Dec 2003, Carel-Jan Engel wrote: >> Does this tool have the same 'functionality'? So, be carefull, or take >> advantage of it ;-). > > Nope, the only history it stores are the commands you type once the > program it execs is fired up. Now, if you connect scott/tiger from within > sqlp

RE: NT -> Win2K causes performance degradation..

Title: Message Half of all memory to kernel is consistent with MS policy of taking half your entire IT budget to give you products that do half the advertised work.   Raj Rajendra dot Jamadagni at nospamespn dot

RE: NT -> Win2K causes performance degradation..

Title: Message Advanced Server costs quite a bit more than the boiler plate variety of 2000.   Patrice. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: December 16, 2003 8:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: NT -> Win2K caus

RE: NT -> Win2K causes performance degradation..

Interesting. We noticed the same thing on Windows2000, it doesn't get mentioned often. Does it mean not many people maintain databases that require more than 1.5G of memory on their Windows servers? My impression so far: - one can't use virtual memory on the Windows platform for a busy database,

RE: connection pooling from an application server to oracle

Bellow, Bambi scribbled on the wall in glitter crayon: > To extrapolate, then, do you think that Neanderthals(at a cranial > capacity of over 1700 cc) would have been using Oracle 11h, or do you > think they would have prefered OODBMSs? i think they'd are smart enough to use what works best for

RE: Re: Who are certified Oracle Masters?

So we have to take two advanced Oracle courses... I have a bad feeling that the Oracle Internals Seminars by Scott Gossett don't count. Would that be correct? They are not part of the OCP tracks. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patr

Re: connection pooling from an application server to oracle

I think that Neanderthals are in the damagement and would prefer the best looking salesperson which also happens to agree with their view, formed by reading Computerworld. As for the cranial capacity, it's the same thing as with the silicon based CPUs: most of capacity is vasted doing unnecessary

Re: Re: Who are certified Oracle Masters?

I've taken those for 8i. Scott is a great guy and the course is excellent. In NYC there was a waiting list for his course. On 12/17/2003 09:19:26 AM, "Boivin, Patrice J" wrote: > So we have to take two advanced Oracle courses... > > I have a bad feeling that the Oracle Internals Seminars by Sc

DISASTER RECOVERY with Continous Access

Anybody Setup an Oracle Disaster recovery with the product Continuous Access on San at an alternative location? I have a few options but would like to know what other people found good. I prefer having the disaster recovery site being validated on a continous basis with automated restores etc. b

Stored Outline Problem

Hi all, I'm trying to set up stored outlines and am running into the following problem (OUTLN tables are initially empty and the shared pool has just been flushed): ALTER SESSION SET CREATE_STORED_OUTLINES = TRUE; SELECT 'THISISMYTEST' FROM DUAL; ALTER SESSION SET CREATE_STORED_OUTLINES = FAL

RE: Stored Outline Problem

I think it is the hash value for sql text something like hash(sql_text_here) ... probably used to do a fast match with trying to lookup outlines ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views e

Fwd: Stored Outline Problem

Additional information: The problem described below occurs on 9.2.0.4 (Linux). I have just tried re-producing on 8.1.7.4 (Solaris) and it actually worked fine there (hash values in ol$ and v$sql matched). Once again, any input welcome. Thanks, - Bill. Hi all, I'm trying to set up stored outl

RE: Unreadable time_stamp format

Jared,   It is epochtime.  When I run your given SQL I got TO_DATE output is “24-NOV-03”.  Is it actual date translated from epochtime “1069716948959” ?    How do I query to select only 100 records?     SQL> select to_date('01/01/1970','mm/dd/') + ( 1069716948959 / (24*60*60*100

Re: Re: Who are certified Oracle Masters?

I ended up going to Bethesda from NYC to take the class with him --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > I've taken those for 8i. Scott is a great guy and the course is > excellent. > In NYC there was a waiting list for his course. > On 12/17/2003 09:19:26 AM, "Boivin, Patrice J" wrote:

Re: SQL*Plus with readline

On Wed, 17 Dec 2003, Carel-Jan Engel wrote: > > > On Tue, 16 Dec 2003, Carel-Jan Engel wrote: > >> Does this tool have the same 'functionality'? So, be carefull, or take > >> advantage of it ;-). > > > > Nope, the only history it stores are the commands you type once the > > program it execs is f

RE: Re: Who are certified Oracle Masters?

That's correct. I believe the reasoning is that the advanced courses (listed below) that are included have to include hands on. The Internals seminars are not hands on. As a couple of asides, Scott is not the only instructor who runs those internals seminars, and I'm not even sure if he's runnin

Re: Fwd: Stored Outline Problem

Bill,   I tried your example on my systems.  On Sun solaris 9.2.0.4 has the same issue of non matching hash values.  Sun Solaris 8.1.7.3 has matching hash_values.Bill Buchan <[EMAIL PROTECTED]> wrote: Additional information:The problem described below occurs on 9.2.0.4 (Linux).I have just tried re-

Re: Re: Who are certified Oracle Masters?

Bethesda city center on Wisconsin Av.? Nice place with some rather fancy restaurants around. I drove around Washington and Bethesda and I must say that it is a beautiful area. I would like to live in Reston, VA. Did you know that propery prices in Reston are comparable to those on LI? On 12/17/

Please read - Re: connection pooling from an application server to oracle

Off topic ( way off topic ) threads have been consuming a lot of bandwidth on this list. Focus please. Mladen Gogala <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  12/17/2003 06:39 AM  Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PRO

RE: Unreadable time_stamp format

David, Not trying to sound condescending or disrespectful, but I think you need some serious practice time with SQL.  Break out the SQL manual, and find out how to join various tables.  A good place to start would be the demo account scott/tiger, with the demo tables in $ORACLE_HOME/sqlplus/dem

RE: Re: Who are certified Oracle Masters?

high 300K to 0.5M for a townhouse and 500K to 1M for single house -Original Message- Sent: Wednesday, December 17, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Bethesda city center on Wisconsin Av.? Nice place with some rather fancy restaurants around. I drove around Washington

RE: Unreadable time_stamp format

Jared,   Sure I will.  Thanks for you help.   Regards, David   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 11:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unreadable time_

Career Advice

As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use

Re: Career Advice

Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that ba

OCP 8i

Title: OCP 8i Hi Listers, Does anyone know how long the 8i OCP tests will be offered.  I can't seem to find it on the Oracle Education Web site. Thanks Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED]

RE: Re: Who are certified Oracle Masters?

This is OT... 3-bedroom Houses in Halifax, Canada sell for about CDN$130K now. Patrice. -Original Message- Sent: December 17, 2003 1:09 PM To: Multiple recipients of list ORACLE-L high 300K to 0.5M for a townhouse and 500K to 1M for single house -- Please see the official ORACLE-L FA

Re: Career Advice

Have you ever considered a career in country music? Try getting "Stand By your man" just right and the rest will come. You have to learn both kinds of music, country and western. May Jake and Elwood be with you. On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: > As an applications analyst/j

Zooming in...

Jared, I just read your post. I'll be focusing. Please, delete my "career advice" without reading it as it reveals despicable lack of focus. I'm zooming in on oracle now. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala IN

RE: Career Advice

Sadly, I do agree with you, but it’s a silly world out there.   You can’t get a job working with these packages without experience, and you can’t get experience if you don’t work with these packages. So my alternatives are few to none. Indeed, the Tecsys applications are comparable to ma

RE: Career Advice

Hi Somani, This is, of course, just one opinion. YMMV. I would recommend that you go deep enough on the Oracle server until you would be willing to take the junior off your title. The reason for this recommendation is that the server is an intricate piece of software that rewards study and exper

RE: Career Advice

Wow... as talented and knowledgeable as you are, you are one really bored DBA. You must work alone, or be self-employed. Or maybe you are trying to tell me to read between the lines... In any case, I won't get into a silly argument with you. Thanks for your advice, Saira -Original Message-

RE: Career Advice

Mladen Gogala scribbled on the wall in glitter crayon: > Have you ever considered a career in country music? Try getting > "Stand By your man" just right and the rest will come. You have to > learn both kinds of music, country and western. May Jake and Elwood > be with you. son, that there was

Re: Re: Career Advice

learn java and object oriented programming. go to sun.com and start reading the java docs. go to www.bruceeckel.com and read his java book. do a search on any job sites. a ton more work for java than oracle. people who can do both are in demand. > > From: Mladen Gogala <[EMAIL PROTECTED]> >

no longer listening

Hi all,   For the last couple of weeks, I have experienced listener down times. The listener will work fine for say a week, and then all the sudden it will no longer allow connections from remote machines. Clients use SQL*plus to connect. Interestingly enough, on the actual server I am ab

RE: Career Advice

Hi Allan, Please call me Saira :) All you are saying is true. I find that in my present role, I don't have access to the applications source code so I have to look at the database for performance tuning (which should be the case anyway to start). On the other hand, I'm the only one at this job

RE: Career Advice

I'd look to the business side of things to get your foot in the door if you want to work with some of the more well-known application suites.  While the specific knowledge of one application suite is seldom easily transferred to another application, the requirements and experience of the actual u

Re: Career Advice

That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message -

RE: Re: Who are certified Oracle Masters?

DC area is insanely expensive. you can spend $300,000 for a condo. Traffic is very bad also and getting worse. it doesnt get 'affordable' until you get up to frederick or in virginia near manassas or west of leesburg. with all the government money and the private sector IT stuff in free fall,

RE: Career Advice

Is it that difficult though? Just to get familiar with it… if you’ve worked with other similar software before?   I guess you’d be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere,

Re: Career Advice

> > Or maybe you are trying to tell me to read between the lines... I'm not. I was just kidding. I don't know any of this stuff (SAP, Siebel, Oracle Apps) and I do make my living. Frankly, I don't like specialists, because they end up just like pandas: no bamboo shoots, and they starve. Black

Re: OCP 8i

Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- "Nelson, Allan" <[EMAIL PROTECTED]> wrote: > Hi Listers, > > Does anyone know how long the 8i OCP tests will be > offered. I can't > seem to find it on the Oracle Education Web site. >

RE: Career Advice

There is no set formula now. But learning a fair amount of SQL, Oracle Database and Unix Administration can do you no wrong. IN my experience the companies or people that hire you because of "big names" on your resume are NOT the ones you want to work for. IT administration work has become more

RE: Career Advice

If you need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo linux box at home is a great learning exersize. (I've yet to do the Gentoo thing, RedHat right now)   (You need at least two computers at home...List how many computers do you have at home.be hon

RE: OCP 8i

Oh, thanks -Original Message- Jose Luis Delgado Sent: Wednesday, December 17, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hm... try this link: http://www.oracle.com/education/certification/faq/index.html?faq5.html HTH JL --- "Nelson, Allan" <[EMAIL PROTECTED]> wrote: >

Re: no longer listening

Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, "QuijadaReina, Julio C" wrote: > Hi all, > > > > For the last couple of weeks, I have experienced listener down times. > The listener will work fine for say a week, and then all t

RE: Career Advice

That is an excellent guideline. I find myself as somewhere in the middle of those two spectrums, a little more towards the second one. My personal belief is that languages can be learnt - like Java or any other code - if you possess the skills. I can read and understand 4GL code without ever bei

RE: Career Advice

"My career advice to you is: do whatever sells." Even if it is wearing a sandwich board that says, "Hot Large Pizza Now $5.00" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http:/

Re: Career Advice

Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, "Odland, Brad" wrote: > "My career advice to you is: do whatever sells." > > Even if it is wearing a sandwich board that says, "Hot Large Pizza Now > $5.00" > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -

Re: no longer listening

I had a lot of problems with the listeners going down for no reason.  I was running 8.1.7.4 with 8.1.7 listeners at the time.  I changed the ports to non-default ports and upgraded to 9.  And haven't had a problem since. "QuijadaReina, Julio C" wrote: Hi all, For the last couple of weeks,

RE: Career Advice

Saira I think you have to decide what your goal is. Then you need to decide how to best accomplish that goal. One tool that can lead you toward a goal is self-study. I have used that tool many times myself. However, with experience you learn the self-study tool has its limits. To consider self-

RE: Career Advice

Ok, we're getting way OT now My local Little Caesars Pizza has the "Hot and Ready" deal going. One large w/ pepperoni for $5, carry-out only. -Original Message- Sent: Wednesday, December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On 12

RE: Career Advice

Little Caesars. $5 CDN (Seriously). -Original Message- Mladen Gogala Sent: December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, "Odland, Brad" wrote: > "My career advice to you is: do whatever sells." > > Even if

RE: Career Advice

Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. I've hesitated to learn Perl - don't know why, but now I find I have to know it to do my job better, esp when I'm working wit

Re: Career Advice

Does "il" in your email address stand for "Illinois"? Is it in the Chicago area? If it's Peoria, then I understand. On 12/17/2003 03:39:26 PM, "Bobak, Mark" wrote: > Ok, we're getting way OT now > > My local Little Caesars Pizza has the "Hot and Ready" deal going. One large w/ > pepperoni

Re: Career Advice

On 12/17/2003 03:44:34 PM, Saira Somani-Mendelin wrote: > Well, good, now that we have that cleared up. Don't get me wrong, I do > like your keen sense of humour and sarcasm - when I know you're joking > and at times its hard to tell. Dennis has a point. The question is where do you want to go to

RE: no longer listening

Eh? -Original Message- Sent: Wednesday, December 17, 2003 2:19 PM To: Multiple recipients of list ORACLE-L Somebody might have changed network configuration. Did you look into the listener.log ? On 12/17/2003 02:19:43 PM, "QuijadaReina, Julio C" wrote: > Hi all, > > > > For the last

RE: no longer listening

Thanks for replying Leroy,   I am running Oracle 9i Enterprise Edition 9.2.0.1.0 for both the database and the listener. But I wonder if the issue is the standard port 1521, should I change to a non-standard port?   Julio Cesar Quijada-Reina Programmer Analyst Computer Services at

RE: Career Advice

Sounds like a fun time J no really… Thanks for all the details.   Right now I have one computer that is used by everyone. I have a spare laptop but I can always buy a couple of cheap computers to set up a mini lab.   Thanks, Saira   -Original Message- From: [EMAIL PROTECTED

RE: no longer listening

Mladen, I did look at the listener.log file and did not see any changes as far as network configuration. The host where the database is running on does not have a fixed IP address though. It gets a lease from a DHCP. I checked the logs on the DHCP and the IP for my database host has not changed la

RE: Career Advice

Nope, IL=I&L=Information & Learning, which is the division of ProQuest that I work for. I'm work in Ann Arbor, the place I'm refering to is in Belleville, which is between Detroit and AA. -Original Message- Sent: Wednesday, December 17, 2003 3:49 PM To: Multiple recipients of list ORACLE

Oracle 9i reports

Hi All, Can you please clarify me the following. We have been using reports 6i on Solaries, Now We would like to migrate to Reports 9i, We are told that (As Character set was depricated in 9i ) we need to keep one xterm console open and ruuning every time we execute rwrun. is this true? are ther

Re: no longer listening

I was able to track activity on the network trying to access the default port.  Not sure that was the cause or not.  I am not an expert but since I changed - no problems. I am running 9.2.0.4 on unix 5.1.     "QuijadaReina, Julio C" wrote: Thanks for replying Leroy, I am running Oracle 9i

RE: Career Advice

Dennis, As always, you offer excellent suggestions. You have all given me many things to consider. Thank you for taking the time to help me out! It is, indeed, a suberb mailing list. Saira -Original Message- DENNIS WILLIAMS Sent: December 17, 2003 3:40 PM To: Multiple recipients of li

RE: standby database configuration in 9iR2 SE ?

The docs on data guard also include the steps required for manual recovery - as a sort of afterthought admittedly but they are there. If I remember I'll dig up my docs from work on this - I keep meaning to write something on this exact subject. Drawbacks include the fact that you have to keep t

Re: no longer listening

So, how are your host names resolved? Any changes in DNS or WINS name servers? Did anybody reboot or alter PDC? On NT host names are resolved by asking PDC . If it cannot respond because of reboot, listener may shut down as well. You should try modifying yur local equivalent of nsswitch.conf. what

Re: Career Advice

Believe somebody who first learned SQL back in 83, it's too late for Java now. Run-of-the-mill skill. Any young grad will know it and will be less expensive. ERP would be a good bet, because people learn them at work, mostly. Now, would a company change be justified just for that? Probably not. As

RMAN Retention Policy

How is this set on 8.1.7 and 8.1.6 databases RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS; RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: =

Re[2]: Career Advice

Wednesday, December 17, 2003, 4:24:50 PM, Bobak, Mark ([EMAIL PROTECTED]) wrote: BM> I'm work in Ann Arbor, the place I'm refering to is in Belleville, which is between Detroit BM> and AA. Hey, I know Belleville, sort of. Back when I as a kid, my dad used to deliver potato chips to some Bellevill

RE: DISASTER RECOVERY with Continous Access

When I got my XP48 I had the option to buy Continous Access, but found it too pricey for my requirements. Got oracle data guard with ssh compression for oracle disaster recovery. -Mandar > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Spears, Bria

Re: Career Advice

Let's take this topic into a more concrete scenario. New boss, company reorg, cross-training is enforced and now DBA'S's are going to be split into development groups. Need to learn Perl(looking forward to it actually!!!) and Java. Books, web sites, docs - all these material is great. But what if 

Re: Career Advice

Perl: Since you're working with Oracle, if you were to buy only one book, you might consider: http://www.oreilly.com/catalog/oracleperl If you but 20 of them I can take my wife out to lunch. Not a bad idea to have Learning Perl, Programming Perl, The Perl Cookbook and The Perl DBI. Very few no

Re: no longer listening

I've had similar problems, however, it isn't just limited to Oracle listeners. NT and Win2k are both problematic when it comes to reliably starting services at bootup.  They both occasionally have a problem with a service dying for no apparent reason. I don't know why this is. To deal with it

RE: Career Advice

>-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Thursday, 18 December 2003 11:34 >To: Multiple recipients of list ORACLE-L >Subject: Re: Career Advice > >Perl: Since you're working with Oracle, if you were to buy only one book, you might >consider: >http://ww

Off-topic postings

I hope everyone will take Jared's admonition about off-topic postings to heart. I like to keep up with this list, and I get very frustrated at the waste of time involved in reading replies to a technical topic that contain no technical content. (And no, I'm not humorless, but work is work and ent

RE: Career Advice

Viktor My suggestion is to go for Perl as the quick win and impress your new boss. Perl also tends to be more useful for DBAs. Learning Java can be a more long-term proposition. First, you need to have a strong understanding of object-oriented design. We have trained developers in Java, an

RE: Career Advice

Dennis,   Yes, my thinking is exactly the same. Before I get too much involved with Java (it will be better to take training for Java), I am going to sharpen up my skills with Perl. Should be easier to pick it up, and the learning curve won't be as steep.   Every company reorg probably has more min

nls_lang

Hello list, I am using 9.2.0.1.0 enterprise edition on windows. Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release 1 I would get the following messages in French c:> sqlplus Entrez le nom utilisateur : But now when I specify nls_lang=French_France.US7ASCII , sqlplus sti

Any known problems using NOT IN ?

Hi Gurus,   I have a problem using NOT IN clause in Oracle. However using NOT EXISTS, gives me the right output. Are there any known limitations.   This query selects from the master records wherein child records are not active.   select * from ct_software_release csr where   csr.cl

RE: Any known problems using NOT IN ?

Siddharth,   The NOT IN query fails to return rows, if the inner sub-query returns NULL values. It is always recommended to use the NOT EXISTS clause, unless you are sure that the inner query will not return any NULLs.   Regards, Charu.   -Original Message-From: [EMAIL PROTECTED]

RE: Any known problems using NOT IN ?

Doess the column crs.os_id_fk1 contain nulls?   Regards Naveen -Original Message-From: Siddharth Haldankar [mailto:[EMAIL PROTECTED]Sent: Thursday, December 18, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: Any known problems using NOT IN ? Hi Gurus,

RE: Any known problems using NOT IN ?

Charu,   Thanks for your explanation. It is perfectly valid for me.   Thanks Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) #  : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED]   -Original Message- From: [E

db block gets /consistent gets

Hi list,   What is db block gets and consistent gets.? How can I reduce consistent gets ? Ask Tom says each consistent gets is latch, how it could be? Thanks in advance   Syed