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

Re: Oracle & SAN Experiences?

SAN, I believe it's possible to have a great Oracle/SAN > implementation if it's setup correctly and tuned. Other resources that you > can Google are "Using SVA SnapShot with Oracle", "Performance Benchmark LSI > Logic E4600 (STK D178)", "SAN Storage for Ope

RE: Installing iAS 9.0.2.0.1

se feel free 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

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 which ANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of h

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

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

OAS 9i anyone?

ce for any 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:

RE: Oracle Advanced Replication

ich throws 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, Februar

RE: replication

on although 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: Multipl

RE: The OCP bar is being raised

uot; since 8, but never bothered with 8i upgrade, 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 hop

RE: Oracle 8.1.7 on MS 2000

the patched up 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 -

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

Rachel, Dorothy (sorry Ross, I couldn't resist) The instructor of the Parallel Server class I mentioned was Mary Jane Bryksa. I took the class in Iselyn, New Jersey center. Just looked at paperwork, it wasn't last year, but January of this year. Gary Weber Senior DBA Charles

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

Job queue in 8.1.7.2.1 on Win2k - dead

check 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 officia

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

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

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

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

RE: Comparison Statistics between Oracle and MS SQL

SQL 2000 and Oracle 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 S

Re: RE: Duhvelopers and DB-ehs?

I am the only human DBA. We have three helper monkeys at remote locations > but they are currently on strike. > > I have to run 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 affo

RE: Oracle Applications patches

ga 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 -Orig

RE: EMC Timefinder

ails, plus 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

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

RE: Evaluation questions

Rachel, I believe your second wish from below (locking SQL) has been granted by former Savant product called Q Diagnostic Center, currently owned by Precise. Drill down to locks, including user and SQL info - its a bliss. Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529

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-

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

RE: Does OEM affect Oracle performance

y OEM 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

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: [E

RE: RAID5 question, take 2

o separate 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 -Origin

RAID5 question, take 2

d 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 > >

Re: RAID5 - to split or not to split

E-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 To REMOVE y

RAID5 - to split or not to split

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

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:

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, 20

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 FU

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 the

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

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?

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:

RE: OT: Archiving not possible with SQL Server?

ys have 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-505

OT: Archiving not possible with SQL Server?

e try some logic: 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 Serv

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

e anymore? I'll switch political sides and jump the ship to IBM, or 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 (saleswome

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

echnology stack alone, 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 -

RE: Oracle and Lawson

knowing 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

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,

RE: Ability for non DBA user to kill session.

ncel" long 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-L

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 PROT

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

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: Standby db license for 8.1.6

--- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT 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

RE: Oracle Masters program

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 -- Author: Gary Weber INET: [EMAIL PR

RE: Integrating Excalibur with an Oracle-based application

LP 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, Californi

RE: 8.1.6 upgrade

cial 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 To RE

RE: Oracle Designer issues and opinions

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 -- Author: Gary Weber INET: [EMAIL PROTE

RE: Informatica on Solaris - how about HP?

e in 8.1.5 database. Don't know if there is newer version, 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.or

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

quite some 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,

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

(note EXACT 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://w

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: working with CLOBS

r 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 Intern

RE: working with CLOBS

d 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: automatic startup and shutdown of LISTENER

-- 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: OT RE: Async I/O on Windows - CacheFusion

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: OEM/IA and DB shutdown

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

RE: Who wants to build a tablespace...

, residing happily on EMC Symmetrix...   Gary Weber   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky WelchSent: Friday, February 02, 2001 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: Who wants to build a tablespace... The question is...One BIG