Re:RE: Linux taking over at Oracle

2002-02-01 Thread dgoulet
Steve, As one of the GREAT MicroSlop bashers, I pray you are more than correct. May the Penguin rule!! BTW: I've experimented with Oracle 8 8i on Linux, RedHat's variant, I'll agree it is stable, easy to use, and very supportable. The problem is the cost of Oracle on a Linux box.

Re:RE: RE: ORA-01555 Mystery (Help)

2002-01-25 Thread dgoulet
; Barbara; Multiple recipients of list ORACLE-L Subject:Re:RE: ORA-01555 Mystery (Help) Barb, I've tried Steve's idea in the past and although it sorta fixed the problem with the large batch job, it created problems elsewhere. It also did not totally fix

Re:RE: FW: Electrical background

2002-01-24 Thread dgoulet
Ross, You've got to define hum. A relay that is run off of an AC current can have a VERY faint hum. A relay that is running on AC current when designed for DC current has a distinctive 'hum' sometimes more similar to a high speed clicking. Also a relay that has a coil nearing the end of

Re:RE: dropped datafile problem

2002-01-22 Thread dgoulet
While the damage here has already been done, it should be a point of caution for us all. I make a point of dropping the tablespace in Oracle first followed by judicious use of the 'fuser' command in HP-UX to see that all processes have released the file. Now you know it's deletable. BTW:

Re:RE: dropped datafile problem

2002-01-22 Thread Jared . Still
:Re:RE: dropped datafile problem While the damage here has already been done, it should be a point of caution for us all. I make a point of dropping the tablespace in Oracle first followed by judicious use of the 'fuser' command in HP-UX to see that all processes have released the file

Re:RE: HP vs SUN for a UNIX box

2002-01-21 Thread dgoulet
Well, My SA did decide to toss in his view point: == my 2 cent euro, HPUX is by far (of the none Linux version of unix) the most stable. if this guy wants the biggest bang for his buck, then i'd go

Re:RE: HP vs SUN for a UNIX box

2002-01-18 Thread dgoulet
Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack

Re:RE: The OCP bar is being raised

2002-01-10 Thread dgoulet
Well, A number of folks have weighed in on this matter I appreciate each point of view, especially those about Oracle Education just trying to justify itself. What IMHO is good in this is the praticum exam. It lends a true degree of certified hands on professionalism to the certificate, not

Re:RE: Oracle Future???

2002-01-08 Thread dgoulet
Ron, I see the DUMB people too, especially those who make choices based solely on $ to acquire. IMHO Oracle's biggest challenge in the near future is controlling their desires for big $. If they don't they'll price themselves (and us) right out of the market. Dick Goulet

Re:RE: Oracle Future???

2002-01-08 Thread dgoulet
Mladen, Companies that want to lock themselves in to anything MicroSoft do in fact exist. I've interviewed with a couple, one of which did in fact whiter die due to failure to release their product in time. That was related to their customers not being so enchanted with everything

Re:RE: Thu Jan 3 11:53:22 2002 ORA-00600: internal error c

2002-01-04 Thread dgoulet
Ron, From Matalinks ORA-00600 parser: Bookmark Default Font Go to End Doc

Re:RE: Becoming a DBA questions

2002-01-04 Thread dgoulet
Where did I put that resume? Sounds like time to go prowling!! Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 1/4/2002 10:15 AM Lemme get this right. This guy is a *new* DBA. He's making 150k and he's not even a senior DBA, where

Re:RE: RE: database administration questions

2001-12-31 Thread dgoulet
Naw, But Jared did forget one: Do you believe that a personal life is obsolete. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 12/31/2001 4:35 AM Gee, I thought I was the only one. Regards, Patrice Boivin Systems

Re:RE: DBA_TAB_MODIFICATIONS - Performance impact?

2001-12-28 Thread dgoulet
Of course Ross. How else do we know how long sadists like you are at work?? :-) Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 12/28/2001 12:55 PM LoL timed sadistics -Original Message- Sent: Friday,

Re:RE: database administration questions

2001-12-27 Thread dgoulet
In our shop we've tried the cross training tact. Problem was that those who accepted the challenge could not take the heat, so they left the kitchen. Damn!!! Dick Goulet Reply Separator Author: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Date:

Re:RE: Change PCTINCREAE for SYSTEM Tablespace

2001-12-18 Thread dgoulet
Tom, I agree and disagree with you, respectfully. Oracle does allow some changes to be made to sql.bsq and they always leave the option open to make changes after database creation and I don't see this request as all that odd. But for the most part if you do as recommended and leave the

Re:RE: Anybody have an opinion on!

2001-12-13 Thread dgoulet
Nope, Just one of Marks associates in crime trying to plant the knife between his shoulders! :) DickG. Reply Separator Author: Hallas John [EMAIL PROTECTED] Date: 12/12/2001 6:30 AM Dick, Your boss wasn't having a dig at you was he :-) John

Re:RE: Siebel.

2001-11-29 Thread dgoulet
Henry, I am sorry to have to admit it, but my experience with third party software is that all of them don't want to imbed their referential integrity into the database. I like you also believe it is because they do not have any kind of data model, never mind a 'proper' one Although the

Re:RE: RE: Siebel.

2001-11-29 Thread dgoulet
Sounds like the path NAI's predecessor took with Support Magic. WHAT A MESS Dick Goulet Off to buy a new shovel, wonder why? Reply Separator Author: Mark Leith [EMAIL PROTECTED] Date: 11/29/2001 8:45 AM Another good one is when they change the

Re:RE: RE: Siebel.

2001-11-29 Thread dgoulet
Dennis, You ought to be a sales droid! That was a perfectly worded reply and in MANY instances I'll agree with you. The ease or of lack thereof in administering an application is very often decided on by damagement by whether or not they need a dedicated/specialized resource to handle it.

Re:RE:

2001-11-21 Thread dgoulet
OOPS! sorry, your right Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 11/21/2001 7:40 AM cascade? probably more abject ignorance on my part, but wasn't it including contents? -Original Message- Sent: Wednesday, November 21,

Re:RE: Index File Name

2001-11-20 Thread dgoulet
Correct! Reply Separator Author: Ken Janusz [EMAIL PROTECTED] Date: 11/20/2001 12:20 PM Here is a typical piece of code from the DDL SQL script that creates an index. It appears that the tablespace used for indexes is SOS2_TBLSPC. Correct? Ken

Re:RE: reattaching datafiles

2001-11-02 Thread dgoulet
Guy, Not as problem, I've been called a whole lot worse in the past. Also, nice piece if info on the old monks, and yeah that is one heck of a DB recovery or more likely a resurrection. Now to your point, when the datafile/tablespace gets dropped Oracle first off won't let you simply

Re:RE: recover on different hardware

2001-11-01 Thread dgoulet
Barbara, Like Rachel I've been in the same place you are too, a couple of times. In every instance where I've been faced with recovering a database and/or datafile the worst part of the process is getting started. Namely figuring out 1) what's broke, 2) what do I have to fix it with, 3)

Re:RE: recover on different hardware

2001-11-01 Thread Rachel Carmichael
Dick, thank you -- how come I don't get invited to speak at NOUG anymore? :( Actually, I've decided that there should be a corollary to my Rule 0 -- while that backup is being made, go and have a cup of coffee and take a pad and paper with you and start to plan what to do. This presumes that

Re:RE: Oracle Browser 2

2001-10-31 Thread dgoulet
David, OK, first off the Oracle sales droid and pre-sales droid came in to do the install of the product (9iAS Enterprise Edition which BTW, you HAVE to have the Enterprise edition or else you don't get the WEB based tool). The install manual said it would need 6GB of HP-UX disk to install

Re:RE: RE: Oracle Browser 2

2001-10-31 Thread dgoulet
David, In it's current incarnation I'd recommend against it. Dick Goulet Reply Separator Author: David Wagoner [EMAIL PROTECTED] Date: 10/31/2001 12:05 PM Wow. Thanks for your effort here Dick. Sounds like quite an ordeal. At least I'll

Re:RE: Oracle 7 documentation - Good One

2001-10-31 Thread dgoulet
Regina, Are those reports written with OCI or Pro*C? We had a miserable time with some of our machine control programs because those engineers used OCI. On the other hand those of us who used Pro*C had it very easy. Dick Goulet Reply Separator

Re:RE: RE: Network Appliance

2001-10-30 Thread dgoulet
Alan, A little leery is a lot safe!.. Dick Goulet Reply Separator Author: Aschenbrenner; Alan [EMAIL PROTECTED] Date: 10/29/2001 3:55 PM Dick, I believe that's the way it was setup. But, ever since they installed the patch on the netapp,

Re:RE: Win XP

2001-10-29 Thread dgoulet
Yesterday I was at my local OfficeMax where I found a copy of XP Home edition for $467.00US and Professional for $867.00US. I had a good laugh on my way out too!! Dick Goulet Reply Separator Author: Jesse; Rich [EMAIL PROTECTED] Date: 10/29/2001

Re:RE: Network Appliance

2001-10-29 Thread dgoulet
Alan, One of the reasons that we have not started using NETAPP with our Oracle DB's is that you should have a dedicated network connection between the server and the appliance. This can take the form of a network cable between the network card and the appliance or a dedicated VLAN. If you

Re:RE: Tools

2001-10-22 Thread Eric Swain
Thanks Doug, I haven't had the chance to dowload the file yet, but I will! I appreciate your response. Eric. Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 19 Oct 2001 11:38:58 -0800 Eric, MANY years ago, before the advent of

Re:RE: Tools

2001-10-19 Thread dgoulet
Eric, MANY years ago, before the advent of Cool-Tools UK I do believe (back in V6 days) I was seriously impeded by a similar situation to you. Namely I really hated being told that something in the DB was wrong before I could get my hat, never mind the coat, off. A few days of those 2x4's

Re:RE: Droping System User

2001-10-04 Thread JOE TESTA
I'm with ya but dont have a recent backup of the play database to try it, its scheduled for backup tomorrow night :) joe [EMAIL PROTECTED] 10/04/01 11:05AM Tom, Think again!!! But at least it was a play area.Dick GouletReply SeparatorAuthor:

Re:RE: Droping System User

2001-10-04 Thread dgoulet
Tom, Think again!!! But at least it was a play area. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 10/4/01 6:00 AM Gholam, The best way to tell if this hurts is to create a test database for yourself, and

Re:RE: Oravle vs. Informix

2001-10-04 Thread Peter Barnett
Many of the features in Oracle8i are the result of Oracle pirating away Informix developers. If DB2 is able to get the same advantages/features into DB2 we could have some real competition in the database world. This would be a very good thing! Especially, since I have two tars in that require

Re:RE: Backup Strategy

2001-10-04 Thread dgoulet
Jared Gene, Any backup strategy that gives me more than one recovery option is viable in my mind. Consequently I use a mix of hot and cold backups as well as keeping my archive logs around for a long while. At least as long as the oldest cold backup. Dick Goulet

Re:RE: Backup Strategy

2001-10-04 Thread Gene Sais
Ok, my backup strategy: 1) Prod Db's - Cold backups semi-weekly to disk. Then off to tape. Export backups (full) daily to disk, keep 7 days on disk. Archive log mode and arcs backed up to tape daily and flushed from archive filesystem with monitoring script. Typically keep 40 days worth on

Re:RE: Oravle vs. Informix

2001-10-03 Thread dgoulet
I believe that IBM will slowly merge the two so that sooner or later Informix ceases to exist and DB2 becomes the sole product. I'm sure there will be a very sweet migration path from a to b. Then the world of four will be three: DB2, Oracle, and Sql*Server. Dick Goulet

Re:RE: RE: Comparing data between two tables in two schema

2001-10-03 Thread dgoulet
the knowledge of SQL, which is a lot to ask from a poor little DBA like me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Comparing data between two tables in two

Re: Re:RE: RE: Comparing data between two tables in two schema

2001-10-03 Thread Don Granaman
Agreed. A few other pluses: 3) Lowest common denominator access requirements (e.g. If you receive a frantic call from operations when you are somewhere that doesn't have the GUI tools you know, you can still get the job done - with only character mode and a command line.) 4) Increased

Re:RE: Comparing data between two tables in two schema

2001-10-02 Thread dgoulet
Why not try the time tested brute force method? Select * from owner1.table1 intersect select * from owner2.table2; If you get the same number of rows as there are in the tables individually then they are equal. BTW: it's cheap too. Dick Goulet Reply

Re:RE: Extents size.

2001-10-02 Thread dgoulet
Back in the V6 days it was a desired characteristic to have every thing in the first extent of an object for performance reasons. Thankfully those days are gone and it really does not matter how many extents there are. Rachel has a presentation on Oracle Myths where she actually portrays having

Re:RE: Extents size.

2001-10-02 Thread Rachel Carmichael
something along those lines... as with everything there is no real black or white on this... but transactional systems that do a lot of small (non-sequential) reads you are better off with lots of extents while data warehouses are often better off with fewer extents as the reads tend to be

Re:RE: Extents size.

2001-10-02 Thread Connor McDonald
I would content that the moment the extent size is greater than SSTIOMAX (or whatever the OS can service), then you won't see any benefit from fewer extents even on data warehouse - the only exception I can think is if you were lucky enough to be the only user on a particular disk/volume during

Re:RE: Alert log from Remote client

2001-09-26 Thread dgoulet
Tony, Kindof a neat package, but I'd be looking for something that does not need a client to use it. I actually monitor my DB's from a program that then sends me the exceptions to it's capabilities. Oh, well, back to the drawing board!! Dick Goulet Reply

Re:RE: ORACLE VS. SYBASE

2001-09-26 Thread dgoulet
Humm, IMHO Larry was right. Reply Separator Author: Miller; Jay [EMAIL PROTECTED] Date: 9/26/2001 9:00 AM No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St.

Re:RE: ORACLE VS. SYBASE

2001-09-25 Thread dgoulet
First off, some one PLEASE trash that TPC-C stuff. I never believe any of that from any vendor since it's so easy to make your case very impressive, and that includes Oracle. As far as SQL, Sybase I see is not as ANSI compliant as Oracle with the SQL-92 standard, check out their literature.

Re:RE: Oracle Recovery from Cold backup.

2001-09-22 Thread dgoulet
Sorry to all if this is a little late, we're got smacked by that NIMDA virus. Anyway, If you have a full cold backup as you specify then all of the archive log files from after that backup 'do not exist'. The idea of a cold backup is to establish a point in time backup that can be used

Re:RE: I/O Performance/bottlenecks on EMC Symmetrix

2001-09-13 Thread dgoulet
!! Please do not post Off Topic to this List !! Try Precise Software's DBTuner product. It has some sort of EMC proprietary connection into the storage array so that you can actually see what disks are being whacked. Dick Goulet Reply Separator Author:

Re:RE: Re[2]:RE: STOP THE PRESS!!

2001-09-12 Thread dgoulet
Jon, No such interpretation was suggested, that would be heartless. Dick Goulet Reply Separator Author: Walthour; Jon (GEAE; Compaq) [EMAIL PROTECTED] Date: 9/12/2001 11:00 AM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re:RE: db link from oracle 8.1.7 to 8.0.5

2001-09-12 Thread dgoulet
Kimberly, I've found that describing a table at a remote database that has a public synonym on that remote instance does not work as we would expect. Try 'desc owner.tablename@database link' Also beware of describing V7 objects in V8 and above. You may get a message that states that the

Re:RE: STOP THE PRESS!!

2001-09-11 Thread Rachel Carmichael
silent hell. New Yorkers are resilient From: [EMAIL PROTECTED] Reply-To: ORACLE.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: STOP THE PRESS!! Date: Tue, 11 Sep 2001 07:25:25 -0800 For those who have not heard, one of the towers, I believe the south one, has

Re:RE: STOP THE PRESS!!

2001-09-11 Thread dgoulet
John, Are you crossing the F-117's with the A-10's? The Thunderbolt was designed as a tank killer, especially with that 30MM cannon in the nose. The Stealth's are for the purposes of getting into heavily radar monitored areas without being seen. Sadly they are a joke around Air Force One

Re:RE: STOP THE PRESS!!

2001-09-11 Thread dgoulet
I regret to say that today's events may well trigger a lot of bad responses. From individuals to governments. No doubt there will be some hate related incidents against Arab background folks in the US, GOD I hope it's nothing more than an incident. Those who are behind the attacks are no doubt

Re:RE: Oracle, security the USAF?

2001-09-10 Thread dgoulet
Last time I looked it up 'completes' was past tense, as in history. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 9/10/2001 8:25 AM Is this happening or happened? Do not criticize someone until you walked a mile in

Re:RE: shutdown immediate hangs

2001-09-10 Thread dgoulet
Jon, One correction, shutdown immediate waits till all uncommitted transactions are committed or rolled back. The client session must do one or the other, otherwise the shutdown hangs waiting for the end user. This is a good example of where setting the idle time in user_profiles is a good

Re:RE: shutdown immediate hangs

2001-09-10 Thread Jeremiah Wilton
On Mon, 10 Sep 2001, [EMAIL PROTECTED] wrote: One correction, shutdown immediate waits till all uncommitted transactions are committed or rolled back. The client session must do one or the other, otherwise the shutdown hangs waiting for the end user. No, that's shutdown transactional.

Re:RE: Hardware requirements when migration oracle from NT t

2001-09-07 Thread dgoulet
So I stand corrected, Thanks. Dick Goulet Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 9/7/2001 2:10 PM According to http://www.redhat.com/software/linux/7-1_professional.html, redhat can support upt0 8 processor SMP

Re:RE: Archive mode

2001-09-04 Thread dgoulet
Some on the list will obviously disagree with me, what else is new, but I set the archive parameter in init.ora always whether or not I intend to use it. That way when I need to it's already there. Dick Goulet Reply Separator Author: Ramon Estevez [EMAIL

Re:RE: !! Keeping the list alive

2001-08-29 Thread dgoulet
With me sitting here two hours after I should have left, you had better duck!! :-) Reply Separator Author: [EMAIL PROTECTED] Date: 8/29/2001 2:58 PM You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and

Re:RE: PeopleSoft8 Oddities

2001-08-29 Thread dgoulet
So am I, especially considering the silence on customer connection. Dick Goulet Reply Separator Author: MacGregor; Ian A. [EMAIL PROTECTED] Date: 8/29/2001 3:30 PM We'll be moving both human resources to Peoplesoft 8 before year's end. I for one

Re:RE: Permanent Tablespace for sorting.

2001-08-28 Thread dgoulet
Chris, I've always used a permanent tablespace for temp and have not had the problems you state. But it does take some consistency to maintain. 1- we never allow anyone a quota on temp or even allow anyone to have that as their default. Come to think of it only sys has system as it's

Re:RE: Permanent Tablespace for sorting.

2001-08-28 Thread Connor McDonald
I suppose the response to this would be why bother?. temp tablespaces (especially tempfile ones) will have - less impact on redo logs - allows current ( or future) use of standby for read-only - no need for any offline drop etc Cheers Connor --- [EMAIL PROTECTED] wrote: Chris, I've

Re:RE: which view?

2001-08-28 Thread dgoulet
That works if the user owns tables. They can also try all_tables and all_accessible_tables. Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 8/28/2001 12:16 PM select * from user_tables HTH Raj

Re:RE: How do you audit a DBA?

2001-08-23 Thread dgoulet
Waleed, Regrettably in our 'legalistic' world this is not possible if all you have is a suspicion, you need facts to back them up. And getting facts in this case can be very difficult at best. What could be a solution in this case is that someone has a suspicion that this person is

Re:RE: How do you audit a DBA?

2001-08-23 Thread Rachel Carmichael
ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: How do you audit a DBA? Date: Thu, 23 Aug 2001 09:36:29 -0800 Waleed, Regrettably in our 'legalistic' world this is not possible if all you have is a suspicion, you need facts to back them up. And getting facts in this case can be very difficult

Re:RE: Index space not freed when rows deleted?

2001-08-16 Thread dgoulet
Jay, Indexes while great performance enhancers are maintenance problems. Have been and always will be. The problem stems from the way that the B-Tree index structure works. When the index is created the entry point is equidistant from both ends. Sooner or latter one side gets longer and

Re: Re:RE: Index space not freed when rows deleted?

2001-08-16 Thread Jonathan Lewis
Comments in line Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 16 August 2001 18:38 |Jay, |

Re:RE: Checking if Oracle Connection still valid

2001-08-15 Thread dgoulet
Kevin, Very true, I remember it from way back in 85 on Version 4 of Oracle. The problem with sqlca and OCI is that it's not required and therefore often left out. Dick Goulet Reply Separator Author: Kevin Lange [EMAIL PROTECTED] Date:

Re:RE: Lost of all Control Files

2001-08-15 Thread dgoulet
I've stayed out of this one up till now. But based on the original I assume that all of the control files where on the same disk drive directory. Bad idea. If you have a problem with the drive and/or controller then you've been had. Place the control files on multiple spindles that are

Re:RE: mambar for Oracle by luminate

2001-08-15 Thread dgoulet
True, but just enough. Dick Goulet Thought for the day: Never be afraid to try something new. Remember that a lone amateur built the Ark. A large group of professionals built the Titanic. Reply Separator Author: Christopher Spence [EMAIL PROTECTED]

Re:RE: Datafile Migration Tool

2001-08-15 Thread dgoulet
Chris, True, but you can't transport them across OS platforms. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 8/15/2001 6:56 AM Hense transportable tablespaces. Do not criticize someone until you walked a mile

Re:RE: user holding session even after a re-boot

2001-08-15 Thread dgoulet
Kevin, I believe that is because Oracle on NT is a single multi-threaded process where one can handle this easier. On HP-UX and most other Unix variant OS's that I know Oracle runs as a bunch of independent processes, including the dedicated servers, and consequently it's harder. BTW: the

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

2001-08-14 Thread dgoulet
Lisa, I believe that is why using shutdown abort is not truly endorsed by Oracle, except as a last resort. What I've noticed on the list is the desire by some to over use this method of shutting down the DB. Now I will admit that shutdown normal is a real pain in the back side since every

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

2001-08-14 Thread Rachel Carmichael
From: [EMAIL PROTECTED] snip Now the original post stated that they had forgotten to backup this datafile. The reasons for doing so vary a lot, but there is a common and failsafe method to prevent this. It's just a matter of laying out your filesystem in such a way that you cannot miss

Re:RE: Re[2]: How can I get my DB back if I lost one of my r

2001-08-14 Thread Riyaj_Shamsudeen
| cc: | ||| Subject: | || | Re:RE: Re[2]: How can| ||| I get my DB back if I| ||

Re:RE: Deep Doo-Doo

2001-08-13 Thread dgoulet
Dave, First, hope your father gets better fast. Sounds like you could use some good news. But now that you found out about database recovery in the hot seat give the network admin the You'sa in a deep doo-doo now for not having done his/her part. Dick Goulet Reply

Re:RE: RE: 9i

2001-08-03 Thread dgoulet
: Re:RE: 9i AH SO, we go back to the idea of BIF AIF files again?? Sound like old Oracle 4 idea!! Oracle into re-cycling too then!! :) Dick Goulet Reply Separator Subject:RE: 9i Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 8/2/2001 1

Re:RE: 9i

2001-08-03 Thread Rachel Carmichael
everything old is new again it's called nostalgia, and retro :) From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:RE: 9i Date: Fri, 03 Aug 2001 06:28:12 -0800 AH SO, we go back to the idea of BIF AIF files again

Re:RE: 9i

2001-08-03 Thread dgoulet
AH SO, we go back to the idea of BIF AIF files again?? Sound like old Oracle 4 idea!! Oracle into re-cycling too then!! :) Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 8/2/2001 1:14 PM With 9i, we have a choice

Re:RE: OT -- the volume of job postings is way down

2001-08-01 Thread dgoulet
Naw, It's just that we want to keep those from the state of Canada where they are. :) Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 8/1/2001 5:10 AM I think it is all of the above. Mainly the recession and

Re:RE: Supert market desgn

2001-07-27 Thread dgoulet
Tony, That's interesting! The books look pretty good, I'll have to order a set, but that CD-ROM is kindof pricey ($300.00), isn't it? Dick Goulet Reply Separator Author: Aponte; Tony [EMAIL PROTECTED] Date: 7/27/2001 10:57 AM Wiley (

Re:RE: OT: Oracle pricing

2001-07-26 Thread dgoulet
Tom, Wish it was a joke, but this is the second year that they've brought it up. Last time we silenced them by buying a new server license. Personally I believe they're using that tactic on customers who go several years (two or more) without adding to their licenses. Dick Goulet

Re:RE: Information about User-defined Locks

2001-07-25 Thread dgoulet
Jon, Your right, thanks. But for the edification of others who may not be using user defined locks today, here is the results of Jon's query from one of my DB's that does use them: SIDSERIAL# PROCESS USERNAME TERMINAL -- --

Re:RE: Data load options

2001-07-25 Thread dgoulet
Lisa, SQL*Loader in direct path can cause you storage problems since it always appends to the table(s) ignoring blocks on the free block list. I found that out after a developer was using it for our data warehouse. At the end of a year he had burned almost 100GB of disk it kept increasing

Re:RE: Data load options

2001-07-25 Thread Mohammad Rafiq
Truncation was the solution in this case as I observed in the past that direct load option use empty blocks above HWM thus using lot of space above it. If it is possible target table should be truncated before such loads... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple

Re:RE: Data Modeling opinion? Help?

2001-07-24 Thread dgoulet
Bruce, You are correct, but I've been on both sides of that equation. If the contractor does not keep a good file of their objections I the customer will beat them over the head when I have performance issues. One reason I don't want to be a consultant/contractor any more, your never

Re:RE: Data Modeling opinion? Help?

2001-07-24 Thread dgoulet
Chris, True, except when I as the customer change the specs. Then what is right is what I say. Or as a Program Management instructor told the class As it is written, so let it be done. Dick Goulet Reply Separator Author: Grabowy; Chris [EMAIL

Re:RE: tnsnames.ora in clients

2001-07-23 Thread dgoulet
We switched to ONS 3 years ago have never regretted it. Getting rid of the tnsnames.ora file was the berries. Dick Goulet Reply Separator Author: Page; Bruce [EMAIL PROTECTED] Date: 7/23/2001 7:52 AM One method I have seen used a lot is to set

Re:RE: tnsnames.ora in clients

2001-07-23 Thread JOE TESTA
except that ONS is going away in favor of ldap. joe [EMAIL PROTECTED] 07/23/01 12:58PM We switched to ONS 3 years ago have never regretted it. Getting rid of thetnsnames.ora file was the berries.Dick GouletReply SeparatorAuthor: "Page; Bruce"

Re:RE: Another programming standard falls

2001-07-20 Thread dgoulet
Guy, Must be because your in the UK where it has not been front page news like here. The problem with Jave and Sun revolves around MicroSoft creating language extensions for their Visual J++ that would only work on Windows and Internet Explorer. That was why Sun went after MicroSoft since

Re:RE: Urgent Select statement SOS

2001-07-19 Thread dgoulet
That is dependent on their being a date of last posting or similar column in the table. If not then it depends. Assuming the table is inserted into ONLY and there have been NO deletes, then a simple 'select * from table_name' will extract the data in the order that it was most likely inserted,

Re:RE: RE: Urgent Select statement SOS

2001-07-19 Thread dgoulet
Boy have you got that right. If we're talking about a couple of hundred rows, most likely on one log file, then yeah logminer may help. But on the other hand if we're talking about a few thousand rows over a several log files!! Sheesh, what a pile of work that would be!! Dick Goulet

Re:re: [Questions about Oracle World Wide Support] / Re: ORA

2001-07-19 Thread Rachel Carmichael
nah, this was a LONG time ago... and we had all sorts of other fun to deal with with the licenses too. but it's a thought From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:re: [Questions about Oracle World Wide Support

Re:RE: New Listener Question

2001-07-17 Thread dgoulet
True, Dynamic discovery has been around since 7.3 I believe, but in my experience it has not been fault free. Dick Goulet Reply Separator Author: Hillman; Alex [EMAIL PROTECTED] Date: 7/17/2001 8:50 AM In 8i you do not need to include services in

Re:RE: Multiple Listeners

2001-07-17 Thread Stephen Andert
Dick, Well, I've not seen the bug you describe and we have over 20 db's in one listener on several different boxes. We are in 8.1.6 on Compaq Tru64. We did have a problem trying to get one listener in 8.1.6 to listed for 8.0.x and 7.3.x databases and WWS discovered that a bug they thought

Re:RE: Multiple Listeners

2001-07-16 Thread dgoulet
ED, OK, looks like you've got 2 or more servers, each supporting a single DB or are you running parallel server? I'll assume the later since that would make more sense. Therefore, set up each listener to listen for requests on it's hostname and port 1521 which is just about the standard.

Re:RE: Multiple Listeners

2001-07-16 Thread dgoulet
Alex, This gets down to the amount of trust your damagement has in you. If they are more tempted to listen to outside assertions that you have already heard, then it's time to move on because your being treated like a trained monkey. My management does ask questions on this type of subject

Re:RE: Why default domain?

2001-07-11 Thread dgoulet
I have to agree with Rich, We've used ONS from 7.3, 8.0, and now 8.1 and their never down, unless something catastrophic happens. But then we've got a cluster of 4 ONS servers, 2 at each campus for redundancy purposes. Dick Goulet Reply Separator

<    1   2   3   4   5   6   >