RE: cache buffer chains contention

2002-04-11 Thread Adams, Matthew (GEA, 088130)
Title: RE: cache buffer chains contention Would it seem likely for Oracle to be doing ANYTHING for a full 30 seconds without hitting another wait? Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Jonathan Lewis

RE: MetaLink problems

2002-04-10 Thread Adams, Matthew (GEA, 088130)
Title: RE: MetaLink problems Logged in with no problems. Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 11:24 AM To: Multiple

cache buffer chains contention

2002-04-10 Thread Adams, Matthew (GEA, 088130)
Title: cache buffer chains contention Ok, some guru please explain this to me. process is waiting for 'latch free' according to v$session_wait and the value of P2 = 26 which is the cache buffer chains latch. (while holding the HW enqueue, with a bunch of processes waiting on HW) State

RE: SQL Server vs. Oracle 9i

2002-04-03 Thread Adams, Matthew (GEA, 088130)
The Walklett Group, the author of the paper cited, is a consulting/services company and has Microsoft listed on their "Alliances" web page, although the exact nature of the relationship is not defined. The paper makes a number of assumptions that I would question. After reading it, I

RE: Customize my SQLPlus login

2002-03-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: Customize my SQLPlus login If you want it set for yourself, but not for everyone, AND need it to take effect from everywhere you run sqlplus, create a login.sql file in some directory under $HOME, and then set $SQLPATH to this directory. Matt Adams - GE Appliances -

generating a shared library for writing blobs to a file

2002-03-11 Thread Adams, Matthew (GEA, 088130)
Title: generating a shared library for writing blobs to a file Has anybody used the document 150107.1 How To Unload LOBs to a File in Oracle 8 (SCR 1276) to generate a shared library to unload blobs to a file? The compile line given (to generate the library) is make -f

RE: IOUG : Was: PocketDBA

2002-03-07 Thread Adams, Matthew (GEA, 088130)
Title: RE: IOUG : Was: PocketDBA I'll be there (and presenting) again. Matt Adams - GE Appliances - [EMAIL PROTECTED] Another month has ended. All goals met All customers satisfied All staff ready and enthusiastic All pigs fed and ready to fly -Original Message- From: John

RE: database startup warning message?

2002-02-25 Thread Adams, Matthew (GEA, 088130)
Title: RE: database startup warning message? most likely the value of SHMMAX is too small in the /etc/system file Matt Adams - GE Appliances - [EMAIL PROTECTED] If carpenters built buildings the way programmers write programs, the first woodpecker to come along would destroy

RE: HOW TO MAKE FAST EXPORT

2002-02-14 Thread Adams, Matthew (GEA, 088130)
Title: RE: HOW TO MAKE FAST EXPORT Check the Utilities manual for the DIRECT=Y parameter Matt Adams - GE Appliances - [EMAIL PROTECTED] I've been so downhearted ever since the day we met. You're love ain't nothin' but the blues. Baby how blue can you get? - Jonny Moore and the

RE: MC/Serviceguard vs Sun Clusters

2002-02-07 Thread Adams, Matthew (GEA, 088130)
Title: RE: MC/Serviceguard vs Sun Clusters Were you only running a single heartbeat connection? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)

Linux taking over at Oracle

2002-01-31 Thread Adams, Matthew (GEA, 088130)
Title: Linux taking over at Oracle For anyone who missed it: - Ellison says Oracle's 'whole business' to run on Linux The Oracle chairman and CEO said the company will replace three Unix servers that run the bulk of its business applications with a cluster of

Truncating the table

2002-01-29 Thread Adams, Matthew (GEA, 088130)
Title: Truncating the table That is incorrect JoJo. When a table is truncated, all rows are removed. In addition this statement does not generated Undo Blocks, and therefore cannot be rolled back. Use with care. The OracleX SQL Reference manual has more information (where X is either 8, 8i

RE: adpatch question

2002-01-29 Thread Adams, Matthew (GEA, 088130)
Title: RE: adpatch question If he's not interested, I am. Please post a summary upon completion. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Discussing a black rectangle silhouetted on a martian landscape That is the top of the calibration target, that is NOT in fact a

FW: Electrical background

2002-01-23 Thread Adams, Matthew (GEA, 088130)
, Then all will be productive - The Tao of Programming -Original Message- From: Adams, Matthew (GEA, 088130) Sent: Wednesday, January 23, 2002 1:10 PM To: 'olist' Subject: Electrical background Anybody got a EE or electronics background? I've got a question about relays

RE: Oracle Performance monitoring tools.

2002-01-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: Oracle Performance monitoring tools. What's the current price tag of Quest's Spotlight? Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming

Socket directory under solaris

2002-01-14 Thread Adams, Matthew (GEA, 088130)
Title: Socket directory under solaris Under HP-UX, NET8 sets up a directory called /tmp/.oracle and creats a number of sockets there. Does Oracle have a similar directory containing sockets under solaris? Where? (It does not appear to be /tmp). Matt Adams - GE Appliances - [EMAIL

RE: Num. of blocks multiple of 5?

2001-12-21 Thread Adams, Matthew (GEA, 088130)
This has been the documented behavior for non-LMT for quite a while. From the storage clause section of the SQL Reference Manual "Oracle rounds values up to the next multiple of the data block size for values less than 5 data blocks, and rounds up to the next multiple of 5 data blocks

Omniback and RMAN integration

2001-12-18 Thread Adams, Matthew (GEA, 088130)
Title: Omniback and RMAN integration I've got Omniback 3.5 and Oracle 8.0.5 with RMAN on one machine, along with the Omniback/RMAN integration piece from HP. I run util_oracle8.exe -CONFIG (bunch of parameters) everything looks fine. No appearant errors. I immediately try to run

RE: OOW presentation materials download/ Re: ORACLE-L Digest -- V

2001-12-17 Thread Adams, Matthew (GEA, 088130)
Title: RE: OOW presentation materials download/ Re: ORACLE-L Digest -- Volume 2001, Number 347 Once again, it looks like a good portion of the presenters does not have a paper (at least online), including Niemiec. Shame on them. Matt Adams - GE Appliances - [EMAIL PROTECTED] The

RE: RECOMPILE INVALID OBJECTS

2001-12-17 Thread Adams, Matthew (GEA, 088130)
Title: RE: RECOMPILE INVALID OBJECTS from dba_objects A, sys.order_object_by_dependency B Doesn't work under 8.1.6, there is not such view as 'sys.order_object_by_dependency', however, you can replace this with an inline view of from dba_objects a, (select max(level) dlevel,

RE: tablespace in backup mode

2001-12-10 Thread Adams, Matthew (GEA, 088130)
Title: RE: tablespace in backup mode check the STATUS column in v$backup Matt Adams - GE Appliances - [EMAIL PROTECTED] If C gives you engouth rope to hang yourself, then C++ gives you enough rope to hang yourself, your dog, your co-workers, and everyone in your neighborhood.

RE: background processes

2001-12-05 Thread Adams, Matthew (GEA, 088130)
Title: RE: background processes ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ORacle MTS (multithreaded server) server processes ora_p000_ora8 ora_p001_ora8 Oracle parallel query processes Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user

RE: Upgrade 8.0.5 to 8.1.6

2001-11-21 Thread Adams, Matthew (GEA, 088130)
Title: RE: Upgrade 8.0.5 to 8.1.6 Ed, There's more to it than just setting the COMPATIBLE parameter. The basic steps are 1) install new 8.1.6 executables 2) copy init.ora file from old 8.0.5 home to 8.1.6 home, making whatever modifications are necessary due to new or obsoleted

RE: applying patch 2032040 to Oracle Purchasing

2001-11-21 Thread Adams, Matthew (GEA, 088130)
Title: RE: applying patch 2032040 to Oracle Purchasing I looked in metalink and maybe I'm just blind, but I don't find a 'Maintaining Oracle Applications' manual. URLs would be greatly apprecieated. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an

applying patch 2032040 to Oracle Purchasing

2001-11-20 Thread Adams, Matthew (GEA, 088130)
Title: applying patch 2032040 to Oracle Purchasing After applying the c.drv portion of the patch, I'm attempting to apply the d.drv portion of patch the patch above and adwork1 is failing applying the d.drv file. In the adwork1.log file I see, jre -mx128m -nojit

applications patches

2001-11-19 Thread Adams, Matthew (GEA, 088130)
Title: applications patches I just got a lovely requirement to patch an Oracle Purchasing instance. (Evidently, I'm suddenly an Oracle Applications DBA, how did that happen?) Anyway, the patch (2094819) appears to depend on another patch (2092683) that does not appear to exist anywhere I

RE: applications patches

2001-11-19 Thread Adams, Matthew (GEA, 088130)
Title: RE: applications patches Whoops... Ron is right. I read the readme.txt file too fast. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)

seouc in Feb.

2001-11-14 Thread Adams, Matthew (GEA, 088130)
Title: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like

RE: seouc in Feb.

2001-11-14 Thread Adams, Matthew (GEA, 088130)
, Chris schrieb: Going to try, since it's only 30 min from the house. --Chris [EMAIL PROTECTED] -Original Message- From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 8:59 AM To: Multiple recipients of list ORACLE-L Subject: seouc

RE: Oracle 7 documentation - Good One

2001-11-01 Thread Adams, Matthew (GEA, 088130)
Title: RE: Oracle 7 documentation - Good One We have 44 instances still running one of 8 versions of Oracle7, ranging from 7.2.2.3 to 7.3.4.4. They don't give me as many headaches as some of my 8.0 and 8.1 instances Matt Adams - GE Appliances - [EMAIL PROTECTED] It will make sense

RE: Oracle 7 documentation - Good One

2001-11-01 Thread Adams, Matthew (GEA, 088130)
- From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 8:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 7 documentation - Good One We have 44 instances still running one of 8 versions of Oracle7, ranging from 7.2.2.3

negative value in v$shared_server

2001-10-26 Thread Adams, Matthew (GEA, 088130)
Title: negative value in v$shared_server Does Oracle still show negative numbers in some of the v$ tables if the values go above 2 billion in version 8.0.5? (the old signed vs. unsigned 32 bit integer problem) I though they fixed all those issues in 7.3 or 8.0.3, but I'm getting reports of

RE: Oracle Open World

2001-10-01 Thread Adams, Matthew (GEA, 088130)
Title: RE: Oracle Open World I'd be going if I could get work to pay for it. heck, I'd go if I could get free hotel (and pay the rest myself). That being said, the IOUG-A conference in the spring is a MUCH MUCH better conference (IMHO), and I encourage all those who can only go to one

RE: Physical access to servers for maintenance

2001-09-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package for your PC (Exceed, ChameleonX, Reflection X?, etc). I've been here 3 years, installed at least 30 new systems and have never been in

RE: Physical access to servers for maintenance

2001-09-26 Thread Adams, Matthew (GEA, 088130)
, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Physical access to servers for maintenance Are you talking NT only or install in general? On unix all you need is a decent X-windows package

recovery

2001-09-26 Thread Adams, Matthew (GEA, 088130)
Title: recovery It's been a while for this scenerio for me. Other dba takes a tablespace offline to shuffle files around. Accidently nukes on of the files clear out of exsistence. DB is in archivelog mode. Recovery steps as I recall them. 1) get missing file from last backup 2) Get

RE: recovery

2001-09-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: recovery The control files are all intact and the database is open. Only one datafile (for an offline tablespace) is missing. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message-

RE: looking for a parsing script

2001-09-25 Thread Adams, Matthew (GEA, 088130)
for a parsing script Matt, What kind of file will the SQL be in? Do you have a sample? Jared On Monday 24 September 2001 07:15, Adams, Matthew (GEA, 088130) wrote: Before I go out an re-invent the wheel (again), I wanted to ask if anyone has a script (preferably pl/sql

interesting floating point problem with oracle

2001-09-25 Thread Adams, Matthew (GEA, 088130)
Title: interesting floating point problem with oracle ran across something interesting on metalink. from Doc ID: Note:1012478.7 Problem Description === Doing floating point arithmetic involving multiplication and division causes unpredictable results. For example, if

RE: interesting floating point problem with oracle

2001-09-25 Thread Adams, Matthew (GEA, 088130)
Title: RE: interesting floating point problem with oracle Further investigation revealed that this error appears only to occur on Alpha based NT systems. see bugs [BUG:714600] Abstract: FLOATING POINT ARITHMETIC ERROR [BUG:889434] Abstract: NT ALPHA CALCULATION MADE AGAINST DUAL RETURN A

pro*cobol in 9i

2001-09-25 Thread Adams, Matthew (GEA, 088130)
Title: pro*cobol in 9i Is anyone trying to use pro*cobol in 9i? I beleive that under 8i, two versions of pro*cobol were available for install, an 8.1.X and a 1.8.X Under 9i, it looks like only 1.8.X is there. Anybody know what happend to the more recent version? Matt Adams - GE

looking for a parsing script

2001-09-24 Thread Adams, Matthew (GEA, 088130)
Title: looking for a parsing script Before I go out an re-invent the wheel (again), I wanted to ask if anyone has a script (preferably pl/sql) for parsing out table references from an SQL statement. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an

Oracle Pure Name and Address

2001-09-17 Thread Adams, Matthew (GEA, 088130)
Title: Oracle Pure Name and Address Recently got a 8.1.7 shipment (for hp-ux) and found some CDs I've never seen in an Oracle shipment before Oracle Pure Name Address (5.5.0.33) Oracle Pure Name Address (North America) (5.5.0.33) Oracle Pure Name Address (Europe, Middle East Africa ,

8.1.7.2.1 patch for hp-ux 64 bit

2001-09-17 Thread Adams, Matthew (GEA, 088130)
Title: 8.1.7.2.1 patch for hp-ux 64 bit Has anybody successfully downloaded this patch from Oracle Metalink? I can't get the tar file to extrace from the zip file. Matt

RE: 8.1.7.2.1 patch for hp-ux 64 bit

2001-09-17 Thread Adams, Matthew (GEA, 088130)
-Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 1:51 PMTo: Multiple recipients of list ORACLE-LSubject: 8.1.7.2.1 patch for hp-ux 64 bit Has anybody successfully downloaded this patch from Oracle Metalink? I

IOUG-A deadline

2001-09-14 Thread Adams, Matthew (GEA, 088130)
Title: IOUG-A deadline For those of you planning to submit papers, today is the deadline for the call-for-papers for IOUG-A 2002. see www.ioug.org for more details

RE: RE: STOP THE PRESS!!

2001-09-11 Thread Adams, Matthew (GEA, 088130)
Title: RE: RE: STOP THE PRESS!! Oh, my god. Racheal is in NY!! Anybody know where the building she works in is located? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:25 AM To: Multiple recipients of list ORACLE-L

RE: Duhvelopers and DB-ehs?

2001-08-31 Thread Adams, Matthew (GEA, 088130)
Title: RE: Duhvelopers and DB-ehs? Thirty one systems and twelve DBAs? My god, we should have 51 Dbas here!! Wait till I talk to management. ;) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death

RE: Statistically OT RE: ADMIN: It has been decided...

2001-08-31 Thread Adams, Matthew (GEA, 088130)
Title: RE: Statistically OT RE: ADMIN: It has been decided... You going to assign a Z score? (sorry, couldn't resist, I just got my six sigma certification this morning) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to

RE: RedoLogs switching

2001-08-24 Thread Adams, Matthew (GEA, 088130)
Title: RE: RedoLogs switching You can look in the alert.log file or in the v$log_history table. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl)

startup time v7

2001-08-24 Thread Adams, Matthew (GEA, 088130)
Title: startup time v7 The v$instance table has the following two entries in Oracle7. STARTUP TIME - Julian 2452043 STARTUP TIME - SECONDS 9476 Doing the obligitory RTFM, I find all it says is that STARTUP TIME - Julian is the startup date and time in Julian format. (Thanks oracle,

RE: DBA tasks

2001-08-20 Thread Adams, Matthew (GEA, 088130)
Title: RE: DBA tasks And we do it in 30 minutes and still have time for commercials Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original

RE: but will it run windows?

2001-08-17 Thread Adams, Matthew (GEA, 088130)
Title: RE: but will it run windows? I gotta disagree with you on one particular point here. When an application gets a error and OS crashes, it IS the OS fault. The OS should be written in such a way that when an application error occurs, the OS doesn't have to be rebooted. I believe it IS

RE: OT: cryptography speech

2001-08-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: OT: cryptography speech Even paranoids have enemies Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original Message- From:

RE: 8.1.6 support cut off?

2001-08-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: 8.1.6 support cut off? According to docs I saw on metalink about 6 months ago Error Correction support ends Oct 31, 2001, Extended support ends Oct 31, 2004 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: Comment on 'Practical Oracle 8i' What wrong with a 100MHz Pentium? I still do a lot of LaTex work (and other stuff) on a 386-25. As long as the machine serves your needs and works, use it. For example. 100MHz Pentium is no where near 1/15 the speed of the 1.5GHz AMD. So

RE: OT -- training

2001-08-13 Thread Adams, Matthew (GEA, 088130)
Either to don't need to incorporate, or my tax accountant lied to me, I don't know which, but I have written off training and IOUG-A trips (that were paid for 100% by me) while I was an employee of a consulting firm. (Is that the IRS I hear knocking?) Matt Adams - GE Appliances -

RE: computer history stories - Now: Age discrimination?

2001-08-08 Thread Adams, Matthew (GEA, 088130)
Title: RE: computer history stories - Now: Age discrimination? Eric, When challenged (at a party), to use to word 'horticulture' correctly in a sentence, Dorethy Parker immediately replied' You can lead a horticulture, but you can't make her think didn't some famous person such as

RE: transportable tablespaces

2001-08-02 Thread Adams, Matthew (GEA, 088130)
, again down to patches. Rachel From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: transportable tablespaces Date: Wed, 01 Aug 2001 12:41:38 -0800 do transportable tablespaces work between

transportable tablespaces

2001-08-01 Thread Adams, Matthew (GEA, 088130)
Title: transportable tablespaces do transportable tablespaces work between different OSes? I wouldn't think so, but I thought I'd ask. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi.

RE: OT, WOW really early

2001-07-25 Thread Adams, Matthew (GEA, 088130)
Title: RE: OT, WOW really early For those of you who have been speakers before, there appears to be a new wrinkle in the submission process. They now want an outline of the presentation submitted along with the abstract. I don't remember submitting an outline for past conferences.

re-archiving a redo log file

2001-07-25 Thread Adams, Matthew (GEA, 088130)
Title: re-archiving a redo log file Is it possible to re-archive an already archived but still online redo log file? the 8.1.6 sql*plus manual says it is, but I can't get the syntax down right apparently. SQL archive log 227 returns a ORA-16013 (does not need archiving) error and SQL

RE: OT, It's all about Alex

2001-07-25 Thread Adams, Matthew (GEA, 088130)
Title: RE: OT, It's all about Alex Don't feel bad for Alex. Almost nobody from the list came to any of mine, and I did four. But, I had a great time doing it. I plan to submit 3 abstracts this time (last time I submitted four, hoping to get one accepted). Matt Adams - GE Appliances

RE: SQL ERROR--Nebulous definition

2001-07-05 Thread Adams, Matthew (GEA, 088130)
Title: RE: SQL ERROR--Nebulous definition It's saying that execute permissions on sys.dbms_sql must be granted to ROSTERDBA Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry

RE: Why this sql is running in parallel ??

2001-06-29 Thread Adams, Matthew (GEA, 088130)
Title: Why this sql is running in parallel ?? Whoops, I sent my earlier message too fast. You've already checked the degree on table and index. Hmmm... Puzzling... I'm curious to see the answer if you ever get one. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour

RE: Why this sql is running in parallel ??

2001-06-29 Thread Adams, Matthew (GEA, 088130)
Title: Why this sql is running in parallel ?? Have you checked the column DEGREE in DBA_TABLES for this table? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate blank Give me a car, fill up the tank Tell me a boat

RE: Mark's Wild A** Vid Card

2001-06-27 Thread Adams, Matthew (GEA, 088130)
Title: RE: Mark's Wild A** Vid Card It's been 10 years since I read it, but this is the guy who wrote Zen and the Art of Motorcycle Maintenance, right? Robert Pirsig called those gumption traps, and they can make us wind up cranky, misanthropic NT haters. (He didn't say that last part.)

RE: Common Oracle RDBMS Misconceptions

2001-06-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: Common Oracle RDBMS Misconceptions I missed the call for presentations for OOW! Is it too late? Where do I find it? (looked at ioug.org, didn't see it) R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate

dbms_obfuscation package

2001-06-15 Thread Adams, Matthew (GEA, 088130)
Title: dbms_obfuscation package Has anyone taken the scripts for the dbms_obfucscation package and tried to make it work under 8.0.5? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.

RE: Oracle 8i database ER diagram

2001-06-12 Thread Adams, Matthew (GEA, 088130)
Title: RE: Oracle 8i database ER diagram Has any tried Q-Designer from Quest? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - hig

2001-06-11 Thread Adams, Matthew (GEA, 088130)
Title: RE: Re: OT - Wrap-up of 'Serious Question ' - now book idea - high I haven't written it yet :), but Don G. and I have talked about writing it together a couple of times. The only thing stopping me from the attempt is the how much time it'll take me away from my kids. R. Matt

recovery puzzler

2001-06-08 Thread Adams, Matthew (GEA, 088130)
Title: recovery puzzler This is puzzling me. On monday morning, the log file switched from sequence 66 to 67. On monday night, a hot backup was taken. On Friday, this backup was written to an alternate machine an attempt was made to do a point-in-time-recovery to Friday Morning. Why

RE: TUSC and Kevin Loney

2001-06-05 Thread Adams, Matthew (GEA, 088130)
Title: RE: TUSC and Kevin Loney So is Rachel, but last I heard she wasn't taking them too seriously. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Mike Killough

procedure builder

2001-06-01 Thread Adams, Matthew (GEA, 088130)
Title: procedure builder Is procedure builder currently bundled as part of Oracle's Internet Developer Suite? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.

RE: About parallel server

2001-05-31 Thread Adams, Matthew (GEA, 088130)
Title: RE: About parallel server Dick, What are you using for your source for this information? This does not jibe with other things I have read. If your not going to use a shared raw device for the online redo logs, how can one instance to instance recovery for another instance that

RE: ??? strange database link problem

2001-05-17 Thread Adams, Matthew (GEA, 088130)
Title: RE: ??? strange database link problem Check out the global_name init.ora parameter. It is probably set to true, which forces the name of the database link to be the same as the alias. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for

RE: DB Link Between Prod and Test?

2001-05-15 Thread Adams, Matthew (GEA, 088130)
Title: RE: DB Link Between Prod and Test? Is he an idiot? (I couldn't resist) We go to extreme lengths to ensure that nobody can link our devlopement and production databases together in any shape or form. It's just a bad idea. R. Matt Adams - GE Appliances - [EMAIL PROTECTED]

svrmgrl return code

2001-05-14 Thread Adams, Matthew (GEA, 088130)
Title: svrmgrl return code on unix (hpux 11) can svrmgrl return any value other than a zero (0)? even a exit 1 returns a 0 to the calling script R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.

RE: When to go for ORACLE NAMES Server

2001-05-11 Thread Adams, Matthew (GEA, 088130)
Title: RE: When to go for ORACLE NAMES Server There is one thing to be aware of. In a very large environment, (which you may or may not have) you don't always want everyone to be able to connect to everywhere. By using tnsnames.ora files, we can control which clients are allowed to connect

9i ship date

2001-05-09 Thread Adams, Matthew (GEA, 088130)
Title: 9i ship date From the InformationWeek Daily e-mail newletter --- ** IBM One-Ups Oracle With DB2 Ship Date It looks like IBM and Oracle will ship the next major releases of their databases within a week of each other, next month. IBM says DB2 version 7.2,

RE: restrict login with known IP address

2001-05-08 Thread Adams, Matthew (GEA, 088130)
Title: RE: restrict login with known IP address use the tcp.invited_nodes paramter in a protocol.ora file (.protocol.ora if you are on 8.1.6 due) R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger.

RE: Taking your time when a crisis occurs

2001-05-07 Thread Adams, Matthew (GEA, 088130)
Title: RE: Taking your time when a crisis occurs I usually hire a large, mean and extremely rude person to stand at the entrance to my cube and say Mr. Adams is busy right now. Come back later. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff,

RE: Off Topic: OracleTuning.com call for papers

2001-04-26 Thread Adams, Matthew (GEA, 088130)
CTED]]Sent: Thursday, April 26, 2001 10:36 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Off Topic: OracleTuning.com call for papers Looks like borker's trolling. Alex Hillman -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTE

RE: Off Topic: OracleTuning.com call for papers

2001-04-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: Off Topic: OracleTuning.com call for papers I not saying this is not on the level, but when I see somebody talking about Oracle and using the name scott tiger, I just have to wonder Is that really his real name? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle

RE: Urgent - tnsnames problem..

2001-04-26 Thread Adams, Matthew (GEA, 088130)
Title: RE: Urgent - tnsnames problem.. what error are you getting? Is the listener process running? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Manivannan

running oidadmin

2001-04-25 Thread Adams, Matthew (GEA, 088130)
Title: running oidadmin I'm having problems getting the OID admin (v2.0.6) utility to run under hp-ux 11. When I try to start it, it get a java error no nldapj8 in shared library path The libnldapj8.sl file is in $ORACLE_HOME/network/admin and this directory is in the $SHLIB_PATH

RE: Listener.log

2001-04-24 Thread Adams, Matthew (GEA, 088130)
No, you do not have to restart the listener. touch the listener.log file (we do a 'cp /dev/null $ORACLE_HOME/network/log/listener.log) and the listener will start writing to it again. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is

Recall: Listener.log

2001-04-24 Thread Adams, Matthew (GEA, 088130)
Title: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, Listener.log.

RE: Recall: Listener.log

2001-04-24 Thread Adams, Matthew (GEA, 088130)
-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 24, 2001 5:00 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Recall: Listener.log Adams, Matthew (GEA, 088130) would like to recall the message, "Listener.log". Matt, No

RE: Meeting at IOUG

2001-04-17 Thread Adams, Matthew (GEA, 088130)
Title: RE: Meeting at IOUG I'm going to be there (I better, I'm supposed to be giving four presentations) Also, for anyone in the central Ohio area, on thursday the Ohio Oracle Users group will be meeting at which Gaja and I will both be presenting. See www.ooug.org for more details

RE: Meeting at IOUG

2001-04-17 Thread Adams, Matthew (GEA, 088130)
: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Meeting at IOUG just to clarify, that's THIS Thursday, right? Not the last day of IOUG :) From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply

oracle background process priorities

2001-04-06 Thread Adams, Matthew (GEA, 088130)
Title: oracle background process priorities After reading the section of Steve Adams book regarding priority degradtion of background Oracle processes, I have decided to investigate further. Has anyone else already looked at this? Does HP-UX degrade priorities based on lenght of time a

RE: why is there dinosaur statues and evolution of human concious

2001-04-05 Thread Adams, Matthew (GEA, 088130)
Title: RE: why is there dinosaur statues and evolution of human conciousness / RE: OT : Sinclair was RE: Metalink Again I've said it before and I'll say it again. Eric, you have entirely too much free time on your hands. ;) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear

RE: 'PMON did not start after 120 seconds'

2001-04-04 Thread Adams, Matthew (GEA, 088130)
Title: RE: 'PMON did not start after 120 seconds' What version of oracle and OS? I have seen this on 8.1.7 on hp when trying to use asyc i/o and the setprivgrp command has not been run. Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is

RE: OPS Setup Steps ?

2001-03-27 Thread Adams, Matthew (GEA, 088130)
Title: RE: OPS Setup Steps ? This is documented in the Oracle 8i Parallel Server Setup and Configuration Guide (chapter nine) and basically consists of the following tasks (copied straight from the doc.) Task 1: Configure Hardware Task 2: Evaluate Tablespaces and Log Files of Single

RE: Why is there air?

2001-03-23 Thread Adams, Matthew (GEA, 088130)
Title: RE: Why is there air? Actually, in the Bill Cosby routine this is taken from, I beleive the gym teacher say volleyball, not basketball. (I'll listen to it again when I get home tonight ;) Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative

perl problem on linux

2001-03-23 Thread Adams, Matthew (GEA, 088130)
Title: perl problem on linux I've got some developers trying to get perl's dbi/dbd stuff working on linux, and they keep getting ORA-2035 every time the execute from a for loop. Anybody seen this before? Linux kernal 2.2.16 with 8.1.7 client installed Matt Adams - GE Appliances -

RE: How long will 8.0.6 be supported?

2001-03-20 Thread Adams, Matthew (GEA, 088130)
Title: RE: How long will 8.0.6 be supported? According to a spreadsheet I've got normal support ends 30-Sep-2001 Extended Assistance Support ends 30-Sep-2004 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone

RE: Offtopic: Canada and America

2001-03-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: Offtopic: Canada and America Red Sox Fan? Wait til next year? Ha! Try being a die hard Cubs fan. Do they still play the blues in Chicago when baseball season rolls around? - A Dying Cub Fan's Last Request Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans

RE: AW: Script for reversing a string?

2001-03-14 Thread Adams, Matthew (GEA, 088130)
, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, 088130)Sent: Tuesday, March 13, 2001 3:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: AW: Script

  1   2   >