RE: OT RE: Async I/O on Windows - CacheFusion

, in theory, 9i OPS should perform MUCH better and scale easier, given the fast interconnect... Gary Weber -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tony JohnsonSent: Tuesday, February 06, 2001 11:11 AMTo: Multiple recipients of list ORACLE-LSubject

RE: working with CLOBS

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: working with CLOBS

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: MetaStink, Redux

Title: MetaStink, Redux They must be testing Windows 2000 as possible platform... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Thursday, February 22, 2001 11:16 AMTo: Multiple recipients of list ORACLE-LSubject: MetaStink, Redux

RE: Rolling Upgrade of Oracle on a 24*7 implementation

T spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Au

RE: Rolling Upgrade of Oracle on a 24*7 implementation

time, nownot a "new feature" either. -Original Message----- From: Gary Weber [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rolling Upgrade of Oracle on a 24*7 implementation Not 100% sure, but I don't b

RE: Informatica on Solaris - how about HP?

, but its something I'd ask if the tool is evaluated. Lastly, repository itself takes up 125 MB, after almost a year of being in production, so its a none-issue. HTH, Gary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City

RE: Oracle Designer issues and opinions

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City

RE: Oracle Masters program

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Standby db license for 8.1.6

ttp://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from thi

OEM day today?

rting Data Gatherer on that lonely Windoz box, I was able to fire up Performance Manager (part of Diagnostics pack) and view all sorts of interesting info about SQL Server databases. Has this been publicized by Oracle anywhere? Gary Weber -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: OEM day today?

Event-wise, yes, only UpDown is available out of the box. However, it lets one see inside of the windows server AND inside of SQL db (buffers/logs/hits/etc.). Far as Access and Expell, for the right price I could prolly right few tcl scripts to manage those as well :) Gary Weber -Original

HP-UX 32bit: 8.1.6.3.0 Patch Set Withdrawn?

Was anyone able to view above titled article on Metalink? #136997.1? If so, could you share your findings? I can't access the thing for usual reasons. Thanks in advance, Gary Weber -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED

RE: Ability for non DBA user to kill session.

ng running queries. I'm guessing that is the desired goal in any case. HTH, Gary Weber -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of lerobe - Lee RobertsonSent: Tuesday, April 17, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Abili

RE: DB monitoring using SNMP MIBs

Title: DB monitoring using SNMP MIBs Unless you'd like to do it yourself, Argent has done it: http://www.argent.com/products/guardian/My limited understanding is that it does exactly what you describe - read o/s snmp mib libraries. I don't use it for Oracle, but our systems folks seem to

RE: LOCALLY MANAGED TABLESPACE

Title: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of

RE: Installing iAS 9.0.2.0.1

to contact me offline for specifics. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-538-1000, ext 5529 -Original Message- Sent: Friday, October 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I

Re: Oracle SAN Experiences?

Logic E4600 (STK D178), SAN Storage for Open Systems Environments, and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services

RE: EMC Timefinder

local apps - don't undersize. 4. Train some one onsite in EMC ways. 5. Fail-over box, in our case, drives the BCV process - go from there. Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Srikanth Sent: Wednesday, August 08, 2001 1:17 PM To: Multiple

RE: Oracle Applications patches

, you're pretty much covered. Btw, the separate application modules (AR, GL, etc) don't have to be at the same patch level - this makes for even more fun. I'm speaking from Apps 11.0 experience, so YMMV. Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice

Re: RE: Duhvelopers and DB-ehs?

off now because the coffee machine is broken and no one is here to fix it except me. I had to carve my own coffe cup out of wood because I can't afford ceramic. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network

RE: Comparison Statistics between Oracle and MS SQL

8.1.7. SQL choked with 10 users - response time was sufficient, but it won't scale. MS SQL had 1 GB of RAM assigned at the time. Oracle chugged along with 50 users - same response time. SGA of 400 MBs (including db buffers). Signed PO for Oracle last Friday... Gary Weber Senior DBA Charles

RE: index in data tablespace ???

Drop tablespace. No, seriously, alter index 'bad index' rebuild index_tbs; Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, September 06, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Hi all, I got bunch of indice reside

RE: Hardware requirements for large data sets

No need for query as we know it. Strictly bulk data collection/delivery. There may be a need for some cleansing. We've had a limited exposure to Informatica and believe it would meet our light needs in that respect. Gary Weber -Original Message- Sent: Thursday, May 02, 2002 3:59 PM

RE: Hardware requirements for large data sets

Tim, Good description. Hence, my original statement for not needing RDBMS. I'm leaning towards calling this monstrosity a data parking of a sort. Just trying to figure out the best way to build the parking lot. Gary Weber -Original Message- Sent: Thursday, May 02, 2002 5:07 PM

RE: Becoming a DBA questions

Very misleading article, which may paint the world in bright blue colors for upcoming/wannabe DBAs... Alternatively, a nice piece of fiction work to forward to a superior...;) Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original

RE: Oracle 8.1.7 on MS 2000

8.1.7.2.1 on Win2k seems stable and solid. After running it for 6 months we are planning on moving into production shortly. If you're going Windows, this is the way to do it. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message

RE: The OCP bar is being raised

, and not planning to spend (read: waste) time on 8i, 9i, etc. Overall, I've found certification to be a useful experience, since during the process I uncovered Oracle features which were new to me. It looks good on a resume, but I hope that it never becomes a deciding factor. Gary Weber Senior

RE: replication

the identifying columns are indexed and have been included into Replication setup. Anyone experienced this? Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, January 10, 2002 3:56 PM To: Multiple recipients of list

RE: Intermedia

Lisa, I just went through Intermedia install on HPUX 11 and Ora 8.1.6 (32 bit) with no apparent problems. Been able to create Intermedia indexes and all is working well. Could you share what problems you've encountered? Thanks, Gary Weber -Original Message- Sent: Monday, May 14, 2001

RE: Oracle and Lawson

if you are hitting resource limits with CPU/memory/IO, would be helpful as well... Gary Weber PS. I wonder how Lawson CRM compares to Lawson Finacials in technology stack. Anyone? -Original Message- SUMMERS Sent: Friday, May 18, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Hello

RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?

, with database, forms, web server, code...arr In my humble opinion, a good Apps DBA is not only proficient in database administration, but is also aware of large ERP packages and their implications. Gary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET

RE: Fire your DBA's you don't need them anymore...

switch political sides and jump the ship to IBM, or gasp Microsoft... Far as their "superior" i-dba team, I sure hope those are different people from the ones you get on first line of Support... Gary Weber PS. Or maybe we should all become Oracle salesmen (saleswomen) -Origin

OT: Archiving not possible with SQL Server?

: Oracle's redo logs = MS transaction log(s) Oracle's archived logs = ? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: OT: Archiving not possible with SQL Server?

the possibility of another long transaction starting. HELP Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: OT: Archiving not possible with SQL Server?

Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot. Supreme Council says: All Aboard MS SQL! Me says: Abandon Ship! Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Thursday, May 31, 2001 7:35 AM

RE: Auto Extend

Never say never :) I opted for 4 GB files in a larger database which is living happily on EMC Sym box. If hardware and software allow for fewer, easier managed large files...why not? This is scratching the surface of course... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529

RE: OT: Archiving not possible with SQL Server?

Jared/all, A joke is exactly how I read it and is how I meant my request for HELP to come across :). Btw, thanks to everyone for interesting replies, reaffirming my grim suspicions about MS idea of archiving... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original

RE: who locked table??

v$locked_object Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Sent: Friday, June 01, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Hi Friends Does any body have script to see who locked the table and subsequently If needy to kill

RE: Bumper Stickers [RE: Rebuilding indexes]

My other database is SQL Server :( Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- [EMAIL PROTECTED] Sent: Friday, June 01, 2001 4:47 PM To: Multiple recipients of list ORACLE-L 'IF YOU CAN READ THIS, YOU ARE A CERTIFIED PIG FUNDAMENT' Scott Shafer

RE: DB versions

Oracle Change Management Pack. Monthly gathering of baselines and comparison to previous month tells me exactly what changed. Than the inquisition begins... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Huntley Sent: Tuesday, June 05, 2001 2:45 PM

Enterprise User Security?

phased out in favor of LDAP, however the Names setup looks like a child's play and works like a charm, compared to info in few documents about LDAP. Anyone writing a book on this? Please? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ: http

RAID5 - to split or not to split

to make up their minds... Help Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RAID5 question, take 2

is a very good option, it has great read performance and very inexpensive. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary

RE: RAID5 question, take 2

data/index I/O Option 2: stripe everything across 9 drives for better throughput. So, methinks the Windoz admin is going to try both ways and monitor i/o... Thanks to Paul, Jared, Christopher for great input, Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message

RE: Forever running Analyze

Analyze estimate with 10% sample, alternatively analyze compute during off-hours, if possible. Most of my "million row" club tables get maintained only on weekends, or in pre-scheduled intervals. Gary WeberSenior DBACharles Jones, LLC609-530-1144, ext 5529 -Original Message-From:

RE: Oracle Advanced Replication

my indexing approach out of the window. Oracle Support has been of no help, other then suggesting different indexing for failover site. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, February 14, 2002

OAS 9i anyone?

and all responses. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-538-1000, ext 5529 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Does OEM affect Oracle performance

management server is on NT box used for other types of monitoring. Great tool, easy to use, but not as reliable as shell scripts... Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Gurevich Sent: Tuesday, June 26, 2001 12:16 PM To: Multiple recipients of list

RE: Does OEM affect Oracle performance

Yes, reliability has improved greatly - I have not had to rebuild ANY events/job over the past 12 months. Of course, OEM is not all it can be - compatibility is limited, and certain functionality does not work as designed. Do consider the tool if you must manage Apps, iAS, etc Gary Weber Senior

CA ARCserver Vs. Veritas Backup Exec?

Good morning, Can anyone share an opinion on how the CA's ARCServer compares to Veritas Backup Exec on Windows platform? This will support Windows 2000 and Oracle 8.1.7 Thanks in advance, Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L FAQ

RE: Need opinion on storage and backup solutions.

I second that curiosity - why would you want to replace EMC? If you already have the EMC infrastructure, cost must not be an issue, right? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Chris Sent: Friday, August 03, 2001 11:25 AM To: Multiple

RE: STOP THE PRESS!!

Please stop the political correctness bull shit about women/children/farmers/pets. These people have had hatred for everything American for decades. And all this time, we, Americans, have been paying to keep them fed, clothed and educated, and often protected. Enough. Gary Weber -Original

RE: Oracle Pure Name and Address

Title: Oracle Pure Name and Address Used along with Data warehouse Builder to cleanse Names and Addresses, along with geo-coding (based on US Post Office data). NOT included with any product, but an extra add-on ($20k/CPU I think). This was purchased by Oracle from someone recently and

RE: ORACLE VS. SYBASE

Isn't Sybase owned by Oracle? Oh, not yet? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Miriam Sent: Monday, September 24, 2001 3:54 PM To: Multiple recipients of list ORACLE-L Hi list, hope you guys can help us decide this issue. We are a shop

RE: the OT list

Joe, I spoke to an Oracle employee about this recently (in past month). Since we utilize Names servers extensively,I would hate to redo entire infrastructure any time soon. Basically, I was told that Names will NOT go away any time soon, if at all. The idea to move to LDAP is great, but I

RE: ORACLE VS. SYBASE

Stick to delimited text files and you'll be fine. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Miriam Sent: Wednesday, September 26, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Thanks to everyone

Job queue in 8.1.7.2.1 on Win2k - dead

for invalid objects). Alert.log is clean. There are no trace files at all. ORADEBUG attached to SNP indicates the process is not doing anything - idle. Any thoughts? Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -- Please see the official ORACLE-L

RE: Classes

Dave, Parallel Server class ruled my world last year :) Instructor was excellent. She had in-depth knowledge and a good sense of humor. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Turner Sent: Thursday, October

RE: Toad vs SQL Navigator

Our developers use both products. Light Oracle developers, including some power end-users, get by just fine with TOAD. High level folks, those into heavy PL/SQL, swear by SQL Nav. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529

RE: BackupExec Oracle

Title: BackupExec & Oracle Lisa, One of our database servers is identical to your setup - Win2K/8.1.7.2/Veritas BackupExec. You'll need to create an Oracle user in each database for Veritas to connect to instances and know what tablespaces/datafiles there. Only gotcha is the fact that this