Re: Upgrading Database to 8.1.74 - RMAN still 8.1.6

2003-02-18 Thread rabbit
As I suspected, now I have to break the news , without breaking the person thanks jared - Original Message - Date: Tuesday, February 18, 2003 8:43 am You can't register and 8.1.7 database in an 8.1.6 catalog. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: how to make sql prompt like USER@DATABASE ?

2003-02-18 Thread Rajesh Dayal
Sorry, I missed your question earlier (too busy to check all the mails everyday).. In the last line of my last mail I had mentioned that Alternatively you can create a file with above lines, put that file in bin and call it anytime to make your prompt... So you can create a

RMAN Upgrading to 8.1.74. Voices in my head.

2003-02-18 Thread Jenner Mike
RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago

RE: metadata repository

2003-02-18 Thread Robson, Peter
'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To: Multiple recipients of list ORACLE-L Is anybody aware of a freeware metadata repository tool that is configurable

Re: Reconfiguring datafiles

2003-02-18 Thread Rachel Carmichael
first, you listed only two datafiles second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep going --- Sony kristanto [EMAIL PROTECTED] wrote: Dear Listers, Would someone on this list help me to solve these problems, 1. I've three

RE: Optimizer help, get query to run as good as with RULE hint

2003-02-18 Thread Toepke, Kevin M
Glenn What is the execution plan _without_ the DISTINCT? I'd be willing to bet that it uses the same indexes as the RBO. If so, try the following: SELECT /*+ NO_MERGE(x) */ DISTINCT * FROM(original query without the distinct) x; Kevin -Original Message- Sent: Friday,

RE: Reconfiguring datafiles

2003-02-18 Thread Rajesh Dayal
Good point H ;-) -Original Message- Carmichael Sent: Tuesday, February 18, 2003 3:44 PM To: Multiple recipients of list ORACLE-L first, you listed only two datafiles second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep

RE: metadata repository

2003-02-18 Thread gs.natesh
Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps -

[Q] how to setup OEM check DB down and notify user?

2003-02-18 Thread dist cash
We have OEM 2.X on NT server to monitor the ORACLE 8.1.7 databases. does anyone know how to setup OEM to check databases down and notify DBA either by E-mail or phone? Thanks. _ The new MSN 8: smart spam protection and 2

RE: Oracle alert #51 - is bug fix in 8.1.7.4.7 for win32 (W2K on

2003-02-18 Thread Boivin, Patrice J
The readme is incorrect, the fix for Windows will be available in 8.1.7.4.8. Pat. -Original Message- Sent: Friday, February 14, 2003 4:39 PM To: Multiple recipients of list ORACLE-L on Patrice, Thanks for replying. Others replied stating that the fix for bug 2620726 is not in

RE: metadata repository

2003-02-18 Thread DEEDSD
try 'www.databee.com' gs.natesh@iflexsolutio ns.com

RE: metadata repository

2003-02-18 Thread Mark Leith
Hi, The URL is http://www.databee.com. The free tool that Peter mentioned (thanks for the plug Peter!), is actually DataBee DBATool (DataBee proper is a data subsetting tool, and has a license fee). A direct link to DBATool is: http://www.databee.com/dt_home.htm Or, also available from

RE: metadata repository

2003-02-18 Thread Ron Rogers
www.databee.com [EMAIL PROTECTED] 02/18/03 07:48AM Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent: Tuesday, February 18, 2003 4:04 PM To: Multiple recipients of list ORACLE-L 'Databee' may just be appropriate

RE: metadata repository

2003-02-18 Thread Robson, Peter
You are quite correct. Spelling error - try www.databee.com peter -Original Message- Sent: 18 February 2003 12:49 To: Multiple recipients of list ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message-

How does the Oracle Home selector get installed

2003-02-18 Thread Rick_Cale
Hi All, I have installed Oracle 8.1.6 and 8.1.7 on WinNT in different Homes. When I had multiple Oracle homes in the past there was always an Oracle home selector installed. It was not this time. How does this get installed? I want to install this portion. Thanks Rick -- Please see the

RE: metadata repository

2003-02-18 Thread Ofer Harel
Databee home: http://www.databee.com/main.htm Ofer -Original Message- Sent: Tuesday, February 18, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S -Original Message- Sent:

Re: metadata repository

2003-02-18 Thread Igor Neyman
www.databee.com Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 7:48 AM Hi Rabson I think www.databaee.com is not found Can pls send the right one Regards Natesh G.S

8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Smith, Ron L.
I have an 8.1.7 Oracle instance on a server that does not create an SGADEF file when it is started up. There are no errors in the log or trace files. As a result of this file not being created, I cannot connect to the database from a remote client. I get an error that says the instance is not

RE: Reconfiguring datafiles

2003-02-18 Thread DENNIS WILLIAMS
Sony 1. You can expand a datafile if it is full, assuming your storage device still has space and you are not near your operating system limit. 2. You can move a datafile to another storage device if you need to. 3. If you need to move data out of a datafile, the easiest way to do this is

RE: RMAN Upgrading to 8.1.74. Voices in my head.

2003-02-18 Thread DENNIS WILLIAMS
Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]

DBMS_JOB

2003-02-18 Thread Mark Leith
Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless the time of day is between X and Y (for example 00:00am 03:00am)? All help appreciated! Pointers to RTFM more than welcome! ;) Mark === Mark Leith

RE: 8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Deshpande, Kirti
Ron, This is not a problem due to the absence of sgadef file. This file was obsolete with 8i. Your problem seems to be Oracle environment /or Sql*Net related. Please check tnsnames.ora, sqlnet.ora, service names etc. on the client. Can you connect to any other instance from this client?

Lgwr , CKPT - Some Misc. basic Qs.

2003-02-18 Thread VIVEK_SHARMA
Any Brief info on following :- Qs lgwr writes the redo log buffer to disk when posted by the smon process under what conditions ? Qs What is metadata ? How are Changes to metadata managed in the log_buffer ? Qs Why does the Checkpoint process (CKPT) maintains a heartbeat with the

RE: 8.1.7 Instance not creating an SGADEF file

2003-02-18 Thread Nelson, Allan
This file is an Oracle 7 artifact AFAIK. I have looked through our 8.1.7 instances to be sure and I don't have that file anywhere. You might want to start checking your TNS setup. Can you tnsping the instance from the client? On the server can you say sqlplus system/passwd@instance and

RE: RMAN Upgrading to 8.1.74. Voices in my head.

2003-02-18 Thread Freeman Robert - IL
Good point Dennis. For all you RMAN users out there, always remmeber, no mater what happens to your catalog or even your control file as long as your backup sets are on media somewhere, they are recoverable. You might need Oracle to assist you with such a recovery (and it can be painful), but they

Re: DBMS_JOB

2003-02-18 Thread Jay Hostetter
The PL/SQL packages that we have running as jobs resubmit themselves when the job is complete. So we can just add logic before calling DBMS_JOB.SUBMIT. Can your PL/SQL be modified in this way? Jay [EMAIL PROTECTED] 02/18/03 09:14AM Hi All, Does anybody know a way of to get DBMS_JOB to run

Re: DBMS_JOB

2003-02-18 Thread Pat Hildebrand
use a function: check if 15 minutes after current time is in the don't run interval if it is return the first time after the interval if not return 15 minutes later Pat Hi All, Does anybody know a way of to get DBMS_JOB to run a job every 15 minutes, unless

RE: Know 1 database, know them all?

2003-02-18 Thread Orr, Steve
Title: RE: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a veiled reference to the satanic dark side Luke? -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003

Re: Teradata baned from IOUG???

2003-02-18 Thread Peter Barnett
It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is going to continue to be a viable organization and in this

RE: DBMS_JOB

2003-02-18 Thread Mark Leith
DOH! You know, I knew that I had read about this somewhere, but couldn't for the life of me remember where. You mentioning Tom kick started my aching brain! ;) The asktom site is down at the moment whilst being upgraded, but I still have the copy of Oracle magazine where Tom discussed this! For

RE: RMAN Upgrading to 8.1.74. Voices in my head.

2003-02-18 Thread Jenner Mike
Dennis, Ah, you know that never occurred to me. I'll check it out. Thanks. - Mike. -Original Message- Sent: 18 February 2003 14:04 To: Multiple recipients of list ORACLE-L Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you

RE: DBMS_JOB

2003-02-18 Thread Deshpande, Kirti
Mark, You may want to check http://asktom.oracle.com. I think there are a few examples that you will find come close to what you are looking for. - Kirti -Original Message- Sent: Tuesday, February 18, 2003 8:14 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody

RE: Know 1 database, know them all?

2003-02-18 Thread Broodbakker, Mario
Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably looking at ratio's: there are no wait statistics, there is one(1) latch wait counter though! for the complete system :( (apart from some

RE: DBMS_JOB

2003-02-18 Thread Mark Leith
Just found an online version (in the spirit of sharing solutions ;D): http://otn.oracle.com/oramag/oracle/03-jan/o13asktom.html ---snip--- Setting a Complex Interval I am using DBMS_JOB, and I want to schedule a job that runs every 15 minutes from Monday to Friday, between 6 a.m. and 6 p.m.

Re: Teradata baned from IOUG???

2003-02-18 Thread Mogens Nørgaard
Well said. It becomes a problem when TUSC aka IOUG starts censoring papers and vendors for OW and IOUG-A on the grounds that it doesn't conform with the slick TUSC messages (right or wrong as they were). Just out of curiosity: What is it that Oracle provides that IOUG can't live without? In

RE: Know 1 database, know them all?

2003-02-18 Thread Stephen Lee
Perhaps a philosophical discussion is in order on the roles of Right Angels versus Obtuse Angels versus Acute Angels. I would hypothesize that Right Angels occupy the uppermost regions of Heaven. Obtuse Angels, being obtuse and mentally slow, are responsible for the enforcement of Murphy's Law.

RE: How does the Oracle Home selector get installed

2003-02-18 Thread Wayne Straughn
Did you install the universal installer? My experience is that the home selector app is in the same directory as the Universal installer and probably is installed along with it. The UI may not installed by default , but you can install it from the CD afterwards. -Original Message-

Re: Know 1 database, know them all?

2003-02-18 Thread Mogens Nørgaard
Yeah, that could be :). OK, OK: Angle, angle, angle, angle. Undskyld. Best regards, The Oracle Angels of Denmark (TOAD) Orr, Steve wrote: RE: Know 1 database, know them all? I see it from a slightly different (and probably wrong) angel Angel? Hmmm... is that a

Re: Teradata baned from IOUG???

2003-02-18 Thread Joseph S Testa
evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate

RE: Teradata baned from IOUG???

2003-02-18 Thread April Wells
It would be great to find out what Oracle DOES do for IOUG... and other OUGs for that matter. I can't get them to even tell people about TSOUG... let alone actually GIVE us anything (meeting room, or anything else). Most of the time I can't get OUR sales rep to get back to me to tell me if

Moving data in 8.1.5.0

2003-02-18 Thread donald.holloway
Any one, I have a Compaq Tru64 Unix server with an Oracle 8.1.5.0 RDBMS on it. I have over 2tb's of raw-disk (1 gb chunks) of database storage that is comprised in 4 separate volumes(emcxxx). We upgrading the storage (1 volume at a time) and I am trying to see if there is a better option than

Programming languages that make DBA's lives easier

2003-02-18 Thread Les Ayudo
On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used?

Re: DB character set

2003-02-18 Thread Boris Dali
In case anybody is interested in the character set business: I asked this question (best char set for mixed environment of Unix and MS DBs with primarily MS clients and C/S applications) Gilles Briard, the author of article in OraMag on accomodating Euro symbol in a DB

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Ron Thomas
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

Re: Teradata baned from IOUG???

2003-02-18 Thread Igor Neyman
me too... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:11 AM evidently i'm not the only one who thinks that, interesting. joe It seems to me that IOUG has become

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Paula_Stankus
C Shell Scripting Perl Pl/SQL - "not really a programming language" Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be cool! -Original Message-From: Les Ayudo [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:56

RE: Teradata baned from IOUG???

2003-02-18 Thread Pete Sharman
Title: Message April I'm afraid I can't answer what Oracle DOES do for IOUG, being a lowly scumbag consultant, but one thing I can suggest to you and any other user group co-ordinator types is to send me (well in advance) notification of your events. I run a DBA mailing list that gets mail

Re: Teradata banned from IOUG???

2003-02-18 Thread Daniel W. Fink
IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice your opinion. Also, send feedback about things you don't like, offer solutions

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Stephen Lee
On Unix, ksh. VERY useful for automating maintenance. -Original Message- On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Cary Millsap
In priority order, I would recommend: SQL Whatever language your apps are written in: its probably Java or PL/SQL, but it might be anything (PHP, Perl, VB, ASP, Python, Tcl, C, C++, C#, ksh, csh, sh, etc.). If youve not found your job yet, then the best bets are Java

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Robson, Peter
Let the Holy Wars begin... My choice: korn shell perl pl/sql Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan Nah! - FORTRAN ! peter * This e-mail

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Boyle Candi
I have always found that both C and understanding makefiles were fundamental to running oracle on linux/unix. When the installer breaks, the knowledge comes in handy. And the installer seems to break quite often... -Candi On Tue, 2003-02-18 at 11:56, Les Ayudo wrote: On top of learning

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Jared Still
PL/SQL is not a programming language? What are your criteria that must be met before it's a programming language? Jared On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded

Re: Know 1 database, know them all?

2003-02-18 Thread Anjo Kolk
Actually there are wait stats in SQL server that you can only see with Precise Indepth for SQLServer ;-) Broodbakker, Mario wrote: Mogens, the only problem with your statement about 'oracle myths king of the new world' is that the only way of looking at SQLServer performance is probably

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Alex
If you are using C/C++ look into www.swig.org to make your life easier On Tue, 18 Feb 2003 [EMAIL PROTECTED] wrote: C Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the more developer-minded DBA's amongst us could rate them as % important that would be

Re: Teradata baned from IOUG???

2003-02-18 Thread Jared Still
Pete, I used to get your newsletter, and even resubscribed after your big move, but then lost track of it. Feel free to publish subscription info here on Oracle-L. Welcome aboard! Jared On Tuesday 18 February 2003 09:19, Pete Sharman wrote: April I'm afraid I can't answer what Oracle DOES

Re: metadata repository

2003-02-18 Thread Jared Still
Neat tool, but not what she's asking for. Jared On Tuesday 18 February 2003 02:33, Robson, Peter wrote: 'Databee' may just be appropriate here. Its free. Visit www.databaee.com peter ps - got in there before you, Dale! -Original Message- Sent: 14 February 2003 19:49 To:

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Scott Stefick
I tend to agree here. I would say: 1. PL/SQL 2. korn shell (or sh, bash, whatever you choose). 3. Perl These are 3 necessities. -Scott At 09:59 AM 2/18/03 -0800, you wrote: You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Glenn Stauffer
In my opinion, there are languages you learn because you'll have to deal with them whether it is to make use of a good set of scripts that someone has made available, orprograms you'll need to maintain at some level. And there are languages you learn because they allow you to quickly and

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Jared Still
On Tuesday 18 February 2003 09:24, [EMAIL PROTECTED] wrote: C Not much need for most DBA's to ever use C, though not a bad thing to know. Certainly doesn't belong at the top of the list for a DBA. Jraed Shell Scripting Perl Pl/SQL - not really a programming language Java Now, if the

Re: Teradata banned from IOUG???

2003-02-18 Thread Jared Still
Well said Dan. Jared On Tuesday 18 February 2003 09:30, Daniel W. Fink wrote: IOUG is a volunteer organization. If you don't like something about it, you can change it from the inside by becoming involved. Remember, the Board Of Directors election is currently open and it is a way to voice

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread James J. Morrow
Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? In (my) order of importance: 1. SQL and PL/SQL 2. Whatever shell scripting language your environment supports (sh,ksh,csh,bash

RE: Teradata baned from IOUG???

2003-02-18 Thread Pete Sharman
Jared Good to hear from you! I'd heard from Cary and Mogens you were still out there alive and kickin' somewhere, but I'd lost your email address (hence the reason you don't get the email any more). For those that want to subscribe to the mailing list, I'd suggest you first look at the back

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Jared Still
You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a DBA as Perl. Jared On Tuesday 18 February 2003 08:56, Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle?

RE: Teradata banned from IOUG???

2003-02-18 Thread Deshpande, Kirti
Thanks you, Dan. Very nicely put. - Kirti -Original Message-From: Daniel W. Fink [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 11:31 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata banned from IOUG???IOUG is a volunteer organization. If

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Alex
What's your goal? If you are writing scripts then use perl or python. IMO, python is more maintainable when your codebase gets bigger. If you're writing a system or application python is still good. If your goal is to get on the hype then go java, xml, .net, and throw in a webservice API. Also,

Re: Teradata baned from IOUG???

2003-02-18 Thread Jared Still
On Tuesday 18 February 2003 07:04, Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. No real complaint about the arrangements. Someone has to step up to the plate if IOUG is

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Paula_Stankus
Title: RE: Programming languages that make DBA's lives easier Jared your right I just see PL/SQL different from other programming languages from the perspective of its openness. For example, I write korn shell scripts to do a number of things not just related to managing an Oracle database

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Nick Wagner
you can take the (more unix friendly) ksh c c++ Java path, all those languages are very similar, or the (more windows friendly) pl/sql Delphi path... if you know pl/sql... delphi should come pretty easily. If you know ksh, or c, then c++ and Java will come pretty easily...

RE: DB character set

2003-02-18 Thread Todd Carlson
We have been dealing with the same issues here. That is great information. Thanks! Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -Original Message- Sent: Tuesday, February 18, 2003 11:11 AM To: Multiple recipients of list ORACLE-L In case anybody is

Re: Teradata baned from IOUG???

2003-02-18 Thread Jared Still
On Tuesday 18 February 2003 07:04, Peter Barnett wrote: It seems to me that IOUG has become a wholly owned subsidiary of TUSC. TUSC in turn has an incestuous relationship with Oracle. All very cozy. I can't speak for all of IOUG, but SELECT does not kowtow to Oracle. Not that there is

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Orr, Steve
Title: RE: Programming languages that make DBA's lives easier Programming languages that make DBA's lives easier: The ones you already know and feel comfortable with. (Of course Oracle connectivity is a basic requirement.) Programming languages that make DBA's lives HARDER: The ones forced

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
Anyone know if any of the 10 people running for the Board of Directors for IOUG is a TUSC employee? Noone claims it in their statements. Henry -Original Message- Sent: Tuesday, February 18, 2003 12:24 PM To: Multiple recipients of list ORACLE-L me too... Igor Neyman, OCP DBA [EMAIL

[no subject]

2003-02-18 Thread Piet de Visser
SET ORACLE-L DIGEST signature -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Boyle Candi
See, that depends on how big a shop you run. I have to pull duty as the sysadmin as well. If the installer does not work, a relink fails, etc, I can't call my unix guy and ask for it to be fixed. I have found many problems with the install programs as shipped by oracle, especially on Linux (all

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Kevin Lange
My vote as well. If you don't know PL/SQL you are not too effective as a DBA. Just a point and click addict. Knowing the shell you are in and having a utilitiy language to use while you are in it are good additions. Although , if you use Unix I would add AWK and SED to that list.

Re: Teradata baned from IOUG???

2003-02-18 Thread Daniel W. Fink
I know Stan Yellott is not a TUSC employee. He is the President of RMOUG and a great guy who has worked behind the scenes at many IOUG conferences. He is a tremendous calming influence (as many of us recall from San Diego). I don't think Ian, Mark, Bill, Stephen or Steve are TUSC Employees,

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Boivin, Patrice J
Microsoft DOS scripting for the Windows side. Patrice Boivin -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L You need to know PL/SQL if you're going to be effective with Oracle. Java is interesting, but not nearly as useful to a

Re: Teradata baned from IOUG???

2003-02-18 Thread Igor Neyman
Rich Niemiec - IOUG President Rich Niemiec - TUSC SEO Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 1:29 PM Anyone know if any of the 10 people running for the Board of

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Richard Ji
#1, 2 are a must. #3 should be whatever your favor langauage whether it's Perl or Java or C etc. Richard -Original Message- Sent: Tuesday, February 18, 2003 1:59 PM To: Multiple recipients of list ORACLE-L My vote as well. If you don't know PL/SQL you are not too effective as a

RE: Teradata banned from IOUG???

2003-02-18 Thread Karniotis, Stephen
My turn to chime in. First, thank you Mr. Fink for a great email. How true your statements are. Second, let me state that TUSC has no involvement in the selection of any presentations for Live! As a senior member of the conference committee, there are over 30 (yes thirty) volunteers that read

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Jesse, Rich
A list of languages doesn’t do much good unless you know why they are needed and how important the language is to your Oracle implementation: 1) PL/SQL. Vital! Needed in order to create database triggers, functions, procedures, and packages. Know it and know how to write it well. This

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Boivin, Patrice J
Borland tools... We have an app that was built using Borland C++, we are getting bizarre Dr.Watson errors on the NT server, regarding a ShlObj.pas unit and a SHBrowseForFolder API call. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
Neither is David Teplow (former president of NOUG) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel W. FinkSent: Tuesday, February 18, 2003 1:59 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Teradata baned from IOUG???I know

Re: Know 1 database, know them all?

2003-02-18 Thread Mogens Nørgaard
Not quite true, as far as I know There's wait stuff in there, although not enough to my taste. There's cpu in there, and the start and stop time, which makes it possible to at least make a crude R = S + W, where the difficult part is breaking down the W into meaningful stuff. A long way to

Re: Teradata baned from IOUG???

2003-02-18 Thread Mogens Nørgaard
Then why this feeling (in other countries, too) that IOUG should be called TOUG instead? Funny how certain presentations with the word "ratio" and something negative in their heading don't make it through the selection process, while presentations with the word "ratio" and something positive

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Paula_Stankus
Title: RE: Programming languages that make DBA's lives easier No offense but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl. -Original Message- From: Ron Thomas [mailto:[EMAIL PROTECTED]]

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Stephen Lee
I thought it might be worthwhile to say WHY I prefer ksh for most scripting. As one writer put it, use a language you know. I've used ksh for years, so that is certainly one big factor in preferring it. But, that aside, if you use mostly the Bourne Shell syntax and stay away from the some of

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Orr, Steve
Title: RE: Programming languages that make DBA's lives easier 3, 4, 5, 6 can be replaced with Python or Jython with wx_Python for added GUI-ness. :-) http://www.networkcomputing.com/unixworld/tutorial/005/005.html#Others http://www.linuxjournal.com/article.php?sid=3882

RE: Know 1 database, know them all?

2003-02-18 Thread Post, Ethan
If you are always wrong then you must be right about one thing (being always wrong), so there is reason to be cheerful, at least you got one thing right. -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 18, 2003 2:19 PMTo: Multiple

Cardinality Hint?

2003-02-18 Thread Freeman Robert - IL
Anyone know anything about a /*+ CARDINALITY */ hint? I noticed it while extracting some MView fast refresh SQL. I can't seem to find anything documented about it. any one have any info they want to share? Robert -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: best way to provide GUI outside of telnet

2003-02-18 Thread Paula_Stankus
Guys, Here is an interesting dilemna. Support Oracle (On Unix and/or Windows) and SQL Server (on Windows)and idea is to come up with a common GUI interface for looking at logs, schedule jobs even if it means using crontab -graphics for trend analysis -GUI console Any ideas on best

RE: Know 1 database, know them all?

2003-02-18 Thread Broodbakker, Mario
Funny..the last time I spoke with the guys in Redmond, they told me: You don't need that... And OK, I must admit there are a few undocumented wait thingies (viewable with dbcc perfmon according to my old notes..), but they are too cryptic too understand.. I like your R=S+W by the way..You

Null Event in v$session_wait

2003-02-18 Thread Chevrier, Brian E
Title: Null Event in v$session_wait All - I'm researching an performance issue with a Java program that appears to be hung in the database. I query v$session wait and it's waiting on a null event. What exactly does this mean ? I've searched several books and cannot find anything

Re: Programming languages that make DBA's lives easier

2003-02-18 Thread Ray Stell
On Tue, Feb 18, 2003 at 12:23:49PM -0800, [EMAIL PROTECTED] wrote: No offense By definition there must be an offense in a holy war! but I have noticed in the various Unix/Oracle shops I have worked that more sys. admins. and Unix types knew korn shell prog. and Java then Perl.

RE: Teradata baned from IOUG???

2003-02-18 Thread Henry Poras
Don't know. Maybe TUSC is more vocal, the IOUG president has a lot of clout, or there are a lot more people than we think that need to take Miracle and Hotsos classes. I was just curious about the TUSC numbers in IOUG (something we can measure), even though that doesn't convey their

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Jesse, Rich
Cool! How'd you get Python to run from a DBMS_JOB? :D Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, February 18, 2003 2:34 PM To: Multiple recipients of list

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Ron Thomas
No offense taken. Depending on the shop, java may be more critical than perl. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: best way to provide GUI outside of telnet

2003-02-18 Thread Paula_Stankus
Also, single console for webserver both Micor. and 9ias -Original Message-From: Stankus, Paula G Sent: Tuesday, February 18, 2003 4:22 PMTo: '[EMAIL PROTECTED]'Subject: RE: best way to provide GUI outside of telnet Guys, Here is an interesting dilemna. Support

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Janardhana Babu Donga
What are the good books you guys recommend for Shell Programming? I have old edition of UNIX shells by example (by Ellie Quigley). I need to replace this with some good book. Do I need to learn perl before reading PERL for DBAs? If so, what are the good perl books do you guys recommend? --

  1   2   >