Re:RE: O9i Licensing

2001-07-10 Thread dgoulet
Walt, Thanks man, my 401K can use the boost!! Dick Goulet Reply Separator Author: "Weaver; Walt" <[EMAIL PROTECTED]> Date: 7/10/2001 8:02 AM Well, if you're lucky enough to use the Enterprise Edition you'll be saving money. We use the Standard

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. I

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: 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 though

Re:RE: Rollback Segments

2001-05-09 Thread dgoulet
Kev, A public rollback segment is immediately placed on line after creation and is automatically picked up by the instance at startup. Consequently doing maintenance on them is a real pain in the A&^. Private rollback segments on the other hand have to be listed in your init.ora file to be

Re:RE: Rollback Segments

2001-05-09 Thread dgoulet
Anita, True on all counts with one caveat. Transactions is derived from sessions which is derived from processes. So in a practical world you need every public rollback segment you have, therefore they all come online immediately. In my case with processes = 300 that comes to 18 rollback s

Re:RE: RE: Bulkcopy

2001-05-22 Thread dgoulet
Walt, I'm going to refrain from sendign teh enire thread as it's getting BIG. Ahyhow, No it will not be retrofitted to Oracle 8/8I. And it may or may not be totally functional in 9.0. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAI

Re:RE: historical data

2001-05-22 Thread dgoulet
Chris, I've been exporting data in a similar way as you since V5. The 8i version of import still reads them without trouble. Dick Goulet Reply Separator Author: Christopher Spence <[EMAIL PROTECTED]> Date: 5/22/2001 7:13 AM Take a look at Thom

Re:RE: MS access

2001-05-24 Thread dgoulet
Kevin!!! Li, In reality Access does have a file size limit, but I believe it is much lower than 1GB. Regrettably there is no way around it, except as Kevin stated to use a pass through query to Oracle. One should understand that Access is designed as a single user system that gets bastardiz

Re:RE: MS access

2001-05-24 Thread dgoulet
LI, Great idea, wonder where that came from! Just DON'T push the table definitions from Access into Oracle via Access. else you'll have objects that are a nightmare to access forever. Dick Goulet Reply Separator Author: "Li; Xiangli" <[EMAIL PROTECTE

Re:RE: New member

2001-05-25 Thread dgoulet
We like the troublemakers here!! Reply Separator Author: "Speaks; Chuck W." <[EMAIL PROTECTED]> Date: 5/25/2001 8:21 AM Sounds great. I am a Lazy DBA refugee and I must say that I like the tone and banter on this list a lot better. I'll be talking

Re:RE: New member

2001-05-25 Thread Ron Rogers
When Chuck Speaks people listen! I couldn't resist the play on words. ROR mô¿ôm >>> [EMAIL PROTECTED] 05/25/01 01:52PM >>> We like the troublemakers here!! Reply Separator Author: "Speaks; Chuck W." <[EMAIL PROTECTED]> Date: 5/25/2001 8:21 AM -- P

Re:RE: MS access

2001-05-29 Thread dan williams
I've been working in Oracle for 4 years and Access for 6 years, and can assure you that for Access 97 (size limit is 1 g), Access 2000 (size limit is 2 g), Access 2002 (size limit is 4g). I've had 500 mg database that work fine in a multiuser environment, however if there is a need for a enterpri

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 sequen

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 th

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 Repl

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 d

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 d

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 dr

Re:RE: MetaSlop (OFFTOPIC)

2001-02-27 Thread dgoulet
Jesse & company, Might I ask how many of you who've had a problem with MetaStink have taken the time to file a TAR with customer service on Metalink? I know I've filed 5 in the last week. The squeaky wheel normally gets the grease! Dick Goulet Reply Separator__

Re:RE: Re:RE: RE: Oracle DBA evolution path - please share y

2001-03-19 Thread dgoulet
54-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com RE: Re:RE: RE: Oracle DBA evolution path - please share your opi > -Original Message- > From: Michael Netrusov [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]

Re:RE: Re:RE: RE: Oracle DBA evolution path - please share y

2001-03-20 Thread dgoulet
Well, Since I started this I guess I'll wade back in, but I'll save everyone some bandwidth in the process. To Jaques (sorry I don't think I spelled that right) point and Mike's too most of the rotten third party software I've seen does have a BAD management team behind it in one way or

Re:RE: oracle and America

2001-03-12 Thread dgoulet
Mladen, Well, hold onto your b&^t because about a year ago I read about a certain Navy Aircraft carrier that was headed back to port because their MicroSlop SQL*Server DB had irreparably crashed. I understand it was replaced by "another vendor's DB". Wonder who that could have been? Dick G

Re:RE: oracle and America

2001-03-12 Thread dgoulet
Kevin, With the COTS (that's Commercial Off The Shelf) mentality that is permeating the military procurement system, stranger things have happen!! Believe me, I've seen them. Dick Goulet Reply Separator Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]> D

RE: Re:RE: very urgent

2001-03-28 Thread Rahul
Ajay's going to try that one too, and we are going to get 5 more mails ! :)) > -- > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 4:27 AM > To: Ajay Jain; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re

Re:RE: Temporary Tablespace Design

2001-04-12 Thread dgoulet
Steve, Thanks for reminding me of that one other operation that does also take up temp. Again, I think that depends on how often you calculate statistics & if your using partitioning. We do statistics once a week, and do it partition by partition so it does not take up that much. Dick Goul

Re:RE: Oracle vs DB2

2001-04-24 Thread dgoulet
Patrice, I just read that from IBM's WEB site (http://www.ibm.com/news/2001/04/24.phtml) for those interested. Looks like the DB market in the near future will be Oracle & DB2, with a little SQL*Server sprinkled in for spice. My retirement fund may get better, but will I be able to survive

Re:RE: Oracle vs DB2

2001-04-25 Thread dgoulet
So isn't PostGres, but neither is a close competitor. Reply Separator Author: "Gene Sais" <[EMAIL PROTECTED]> Date: 4/24/2001 1:28 PM hmmm, mysql is free, best price of all. >>> [EMAIL PROTECTED] 04/24/01 04:27PM >>> At 10:46 AM 4/24/01 -0800, you w

Re:RE: Oracle vs DB2

2001-04-25 Thread Gene Sais
true, but when cost is the decisive factor w/ a startup, go with the one of the freebies. if the company was too cheap to buy the right product, time to find a company w/ deeper pockets. now w/ ibm buying informix, merging w/ db2, they will have a new product called db4mix :). the free db's

Re:RE: Centralized StatsPack Repository

2003-01-03 Thread dgoulet
I also was informed during the iTAR process that they will support a centralized repository, but you'll have to wait till 10i for it. Heck I've haven't gotten a play instance of 9i up yet. 10i, maybe by 2010!!! I really don't want to wait that long!! Dick Goulet Reply Separ

Re:RE: oracle or mssql

2002-10-24 Thread dgoulet
As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 1

Re:RE: Database Monitoring tool

2002-11-01 Thread dgoulet
Come on now Mark. Get up on your soapbox & hand us the sales pitch. *-) Dick Goulet Reply Separator Author: "Mark Leith" <[EMAIL PROTECTED]> Date: 11/1/2002 1:33 AM I could give you a great little list, but that would kind of defeat my job purposes

Re:RE: Database Monitoring tool

2002-11-01 Thread dgoulet
Paul, If your into all that fatty food that the French like (like I do, OOPS my roots are showing) Then you NEED all that alcohol to keep the "plumbing clean". Now, if you don't mind I'm off to home for some Foigra and Wine!! Sauteed in Butter to boot!! Dick Goulet Rep

Re:RE: dumping microsoft desktop?

2002-11-14 Thread dgoulet
David, Just like beauty, winning or loosing in a lawsuit is in the eye of the beholder. Actually in MicroSlop's case it was the justice department that bailed and more than likely King George who sat on the judge. You got to love those political action committees and their BIG donors!! In p

Re:RE: RE: CONSISTANT GETS

2002-11-15 Thread dgoulet
Raj, I needed a 12 pack adter this one, it's from PeopleSlop: SELECT 0001560265,OPL.BUSINESS_UNIT,OPL.PRODUCTION_ID,OPL.OP_SEQUENCE, PID.INV_ITEM_ID,TMP.COST_ELEMENT,'04',0,0,0,0,0,0,PID.ORIG_UOM,PID.PRDN_AREA_COD E, PID.PRODUCTION_TYPE,OPL.QTY_SCRAPPED,OPL.PERCENT_COMP,' ',1,0,' ','

Re:RE: Value of OCP

2003-03-20 Thread dgoulet
Good old Duct Tape, the "handyman's secret weapon"!! Reply Separator Author: Stephen Lee <[EMAIL PROTECTED]> Date: 3/20/2003 6:34 AM > -Original Message- > Did you learn anything from the previous crash to prevent it from > happening again? >

Re:RE: Data Capture program

2003-03-20 Thread dgoulet
Santosh, If that's what your after I'd suggest you get into WEB development mode. Using Access means using ODBC which means installing the Oracle client. Take a look at ColdFusion, or 9IAS or some Java based approach. In any case your going to need a WEB server and browser on the client sid

Re:RE: Proc*C Errors

2003-03-20 Thread dgoulet
Oh Stephane, your such a woos. I absolutely hate the OCI interface, talk about a place to blow your head off! 99.9% of the time that the C compiler tosses a fur ball is something you've done in C that is wrong, although I'll admit is sometimes gets real hairy trying to find it. If the Proc p

Re:RE: Value of OCP

2003-03-20 Thread dgoulet
I will admit to getting mine simply as part of an ego trip. I figured that after 15 years of being an developer/DBA with Oracle I should have one. Has it made a difference to my salary or employment potential? Not one bit. Dick Goulet Reply Separator Aut

Re:RE: Another simple question

2003-01-24 Thread dgoulet
Dennis, Allow me to add another item to the pile from the OLD days. Back in SQL*Net V1 it was recommended to select a database name/SID that was "case insensitive". That restriction/recommendation was due to older DOS based clients that handled all of that sort of data as upper case. Theref

Re:RE: comparing null values

2003-01-31 Thread dgoulet
Sony and Gary, Null is a "special" condition of data. A data point cannot equal or not equal null, therefore 'like' and 'not like' also does not work as neither is true. Therefore SQL recognizes 'null' and 'not null' for the purpose of evaluating nulls. Consider the null state as being the

Re:Re: A STRANGE QUERY

2004-01-12 Thread system manager
It is not an expensive query.It runs really fast without the primary key in production but we dont have this problem in the test instance. -- Original Message Date: Mon, 12 Jan 2004 14:04:42 -0800 >Even stranger is, that you expect us to solve your

Re:RE: DBMS_JOB interval wierdness

2002-07-16 Thread dgoulet
Jesse, Is this 8.1.6? If so there's a bug filed against dbms_stats. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 7/16/2002 12:24 PM Nope. 1 PM just like it should, only every day instead of every week. I've tri

Re:RE: RE: (Fwd/2)

2002-07-18 Thread dgoulet
Wednesday, July 17, 2002 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: (Fwd/2) > > > Mike, > > Apple is still trying to compete with MicroSlop & having > a hard time of it > as well. I believe Apple's major problem competing is t

new OEM / Re:RE: Rant

2002-07-23 Thread Eric D. Pierce
Hold on does that mean that since I never learned it, I should just wait for the new one? :) Will it support 8.1.7 in client-server mode? :):) (Or "just" Oracle9i?) regards, ep On 22 Jul 2002 at 10:13, [EMAIL PROTECTED] wrote: > YUP, Saw the new version at an Oracle event in Boston a c

PTFM? / Re:RE: RE: Rant

2002-07-23 Thread Eric D. Pierce
You can get a color laser printer cheaper than that. besides RTFM, is there going to now be PTFM? On 22 Jul 2002 at 12:36, [EMAIL PROTECTED] wrote: > Patrice, > > You can still get them, you just have to order them seperatly at a platinum > plated cost. Last time I looked is was $1500 p

Re:RE: B&R solutions

2002-07-25 Thread dgoulet
I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long en

Re:RE: missed Anjo's webcast..

2002-08-09 Thread dgoulet
Ian, You have run into something that I've seen in the past which is a performance problem, but which is not caused by a bad BHR. What I have noticed are PeopleSoft queries, done by their query tool(YUCK), that have all of their data in memory and are just spinning around and around the same

Re:RE: Oracle Arm Twisting?

2002-08-14 Thread dgoulet
One should alos remember that on some products Oracle has a minimum number of users, If you don't have that many, well too bad!! Dick Goulet Reply Separator Author: Steven Lembark <[EMAIL PROTECTED]> Date: 8/14/2002 6:08 AM -- John Weatherman <[EM

Re:RE: PL/SQL Editor.

2002-08-15 Thread dgoulet
Scott, vi, your dinosaur side is showing!! *-) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 8/15/2002 8:38 AM vi or vim. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Place for oracle [SMTP:[EM

Re:RE: PL/SQL Editor.

2002-08-15 Thread Ron Rogers
Scott, Dinosaur? When you have a good product it stays around for lng time. The complaints that I have with TOAD is that the pl/sql packages when converted to text have a lot of white space due to the formatting. Designer is not as bad but still has white space. I like to have the developers

Re:RE: Getting view definitions

2002-08-28 Thread dgoulet
Also it helps to use "create or replace" instead of drop and create. First it's one statement vs two and second it retains any grants. Dick Goulet Reply Separator Author: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 8/27/2002 2:24 PM Eric set long 20

Re:RE: PL/SQL Editor

2002-08-28 Thread dgoulet
Well, since someone else cares to mention it, I do use Procedure Builder, Oracle's PL/SQL development tool from Developer and I like it a lot. The latest version even does syntax highlighting, indentation, and "click on the error & I'll show you where it is". Dick Goulet Rep

Re:RE: OT: Misinformation Ranting

2002-09-11 Thread dgoulet
Jared, The limit on the number of extents in earlier versions was due directly to how many extent locators could be stored in the first block of an object. The bigger the block, the more extent locators that could be stored. Dick Goulet Reply Separator__

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: 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 mil

Re:RE: Oracle and Tru64

2002-06-04 Thread dgoulet
Peter, Please allow me to disagree. I came from the USAF with a very deep love for DEC hardware and software (VAX/VMS), only to be VERY disappointed by them when I was presented with DEC Ultrix. Their straying into the Unix world was a real nightmare. First off their sales folks over sold

Re:RE: Oracle and Tru64

2002-06-04 Thread Peter Barnett
Guess we had different experiences. OSF was being replaced in favor of digital unix when I started my sys admin days on DECs. They were also Oracle's preferred platform at the time. Things have changed a lot since then. --- [EMAIL PROTECTED] wrote: > Peter, > > Please allow me to disagre

Re:RE: Oracle and Tru64

2002-06-04 Thread Kip . Bryant
I never saw Ultrix but have heard other horror stories on this list and elsewhere. My first exposure to Dec was in '93 on the brand new Alpha's running openVMS. 64 bit and VLM long before any other vendor (and long before Oracle supported 64 bit, unfortunately)...and if the DEC wire-heads I wo

Re:RE: Oracle and Tru64

2002-06-04 Thread Gene Sais
I worked w/ ultrix, was horrendous! Dec OSF/1 never took off, better than Ultrix but bad unix. Then came Digital Unix, not bad, but still not the best. But I did like the advanced filesystem, esp. cloning filesets, great for quick backups! Gene >>> [EMAIL PROTECTED] 06/04/02 03:13PM >>> I n

Re:RE: Goodbye e3000 & TRU64

2002-06-12 Thread dgoulet
Brian, Wasn't that before the merger annopuncement? At a somewhat recent Oracle get together they said they were working with HP and Red Hat to get a shared filesystem developed so that RAC could run without raw devices. Compaq's TRU64 already had it. Wonder where HP thought they'd get the

Re:RE: Goodbye e3000 & TRU64

2002-06-12 Thread dgoulet
Rich, I'm sure they will, some sort of merge of TRU64 and HP-UX. Now, IF we get the best of both OS's we'll probably have a real good end product. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 6/12/2002 6:43 AM I

Re:RE: On delete cascade

2002-06-18 Thread dgoulet
Fawzia, I'm going to disagree with just about everybody on this one. Assuming, and that is a BIG assumption, that the parent and child relationships have been properly established there is no real good reason not to use 'on delete cascade'. I've one &^%$ duhveloper who does not want to use

Re:RE: Need some advice

2002-07-02 Thread dgoulet
Raj, Thanks for the help, but in this case I need to first wash a little egg off of my face. The problem here was at least was easily recoverable. What had happen was we moved a database instance from one machine to another. It's cheaper to run two instances on one box that pay Oracle for

Re:RE: Setting Up EXTPROC

2002-07-08 Thread dgoulet
John, First question, is this the first extproc listener that you've setup on this server? If your configuring a second, you can't really do that as there can be one and only one extproc_connection_data entry in your tnsnames.ora file. What you need in this case is a new library that points

Re:RE: Setting Up EXTPROC

2002-07-09 Thread dgoulet
Ian, Good points. ALthough running extproc under TCP is NOT supported by Oracle, it will work. Dick Goulet Reply Separator Author: "MacGregor; Ian A." <[EMAIL PROTECTED]> Date: 7/8/2002 4:28 PM Some security and Intermedia tips: Make sure the

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: 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: 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, Dece

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: anyone

Re:RE: dropped datafile problem

2002-01-22 Thread Jared . Still
ubject: 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 r

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 it

Re:RE: UPgrade or Reinstall ?

2002-02-06 Thread dgoulet
Lisa, I wil agree with Tom, unless this is a dry run for a real database that you have to migrate. In that case I would migrate this test area just for the experience. Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Dat

Re:RE: RE: RE: PocketDBA

2002-03-01 Thread dgoulet
Mark, Just yanking your chain, and for some reason I just could not resister applying the extra effort!! I'll send your head back via FedEx overnight!! :-) Dick Goulet Reply Separator Author: "Mark Leith" <[EMAIL PROTECTED]> Date: 3/1/2002 2:4

Re:RE: Disk is cheap?

2002-03-19 Thread dgoulet
We say that disk is cheap, but that is a relative term. Yes an individual drive may be inexpensive, but if your using anykind or raid or mirroring (as we are) then each GB of space is twice as expensive as the individual part because you need two drives. Also, don't forget the cost of backing up

Re:RE: Disk is cheap?

2002-03-19 Thread Brian_P_MacLean
[EMAIL PROTECTED] Subject: Re:RE: Disk is cheap?

Re:RE: Use of Orastaff

2002-03-20 Thread dgoulet
First, Lisa, welcome back on line. I regret to say that I did not notice until someone mentioned it in a previous reply at which time I had to remove the baseball bat from the face! :-) Second as to OraStaff. I replied to one of their posts only to have Bill reply that it was really a SQL*Serve

Re:RE: Intersystems Cache database

2002-03-21 Thread dgoulet
Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 3/21/2002 1:58 PM Yeah,

Re:RE: License standby database?

2002-04-02 Thread dgoulet
Jon, Wrong. You must license the second server identically to the original. The reason is that a standby database can be used as a read only copy of the original. Dick Goulet Reply Separator Author: Jon Baker <[EMAIL PROTECTED]> Date: 4/2/2002

Re:RE: License standby database?

2002-04-02 Thread Rachel Carmichael
yep... but it's because the database is being used, even if you don't use it for read-only the fact that the executables are running and the database is mounted is why you need the license. Now, if you have a copy of all the files, and the executables on another machine, but DON'T run anythin

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 Author:

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

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 se

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; Br

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: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: 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 ( www.w

Re:RE: Terminal Emulation Sw.

2001-05-10 Thread dgoulet
I downloaded VNC sometime ago. Works very nicely, especially on NT servers instead of PC Anywhere. Haven't tried the Unix variants though. One irratating habit it has is on screen refresh for windows not in the foreground/active. Dick Goulet Reply Separator

Re:RE: Data Reporting tools

2001-05-10 Thread dgoulet
What do you want, that I should call a spade a spade? ;-) Reply Separator Author: Paul Baumgartel <[EMAIL PROTECTED]> Date: 5/10/2001 11:26 AM Thanks, Dick, for writing "I've been given a project..." rather than "I've been tasked...". -- Please see

Re:RE: RE: historical data

2001-05-22 Thread dgoulet
Chris, Humm, did not think that was clear, but!! We started using export to extract data from our operational data store back in 92 with Oracle Version 5 to tape. These files, copied now to CD's are still usable with Oracle 8i. That's 10 years and no problems. If I can depend on something

Re:RE: About parallel server

2001-05-31 Thread dgoulet
Matt, I know I read that somewhere and yes it could also have referenced a different OS. If I manage to find the reference I'll happily share it with the rest of the group, I'm just so in vacation mode right now that I really don't give a *&^%. But, I will admit that the docs on MetaLink sa

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: STOP THE PRESS!!

2001-09-11 Thread dgoulet
For those who have not heard, one of the towers, I believe the south one, has collapsed. I dare to say that someone else's skyline will be different in the next 48 hours as well. Guess the members of the list who are based in New York will be silent for a couple of days. Dick Goulet __

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

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 b

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

<    1   2   3   4   5   6   >