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 new user will need to have some low level privs in order to be effective. You would then setup Veritas Oracle Agent to backup your databases, one by one. Then within Veritas Backup Manager you could create Oracle jobs (backup AND restores) manually, or rely on wizard. Either way has proven to work well for our two Win2K boxes. Not using RMAN though. Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-538-1000, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Monday, November 25, 2002 2:12 PMTo: Multiple recipients of list ORACLE-LSubject: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that "effective immediately" Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
Re: Oracle SAN Experiences?
I am off today, recuperating from a SAN failure earlier this week. Here is a very short take: our Dell SAN went down (backplane failure), taking ALL of databases along with it. This meant that all servers attached to this SAN were offline. Upon Dell repairing the SAN, data on one volume (mapped to production server) was corrupted and I had to restore from tape and apply a week's worth of archived logs. Time it took Dell to fix their hardware? 48 hours. We also have a new EMC Sym, and are considering abandoning SAN approach and putting all eggs into Sym, since EMC guys at least monitor their hardware and would've known of such failure prior to it occurring. Am I saying SANs are bad? No. But do consider your vendor, support level, and required reliability. Gary - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 08, 2002 9:58 AM The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and I'd like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB - 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (it's possible to use smaller disks in the SAN) -Prove it! After reading the Sane SAN article and a case study about Volvo implementing a 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 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-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 removed from). You may also send the HELP command for other information (like subscribing).
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 hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy? Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leonard, GeorgeSent: Friday, October 25, 2002 10:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to educate them enough to understand something but not leaving at the same time halve way where you start getting these interesting architecture decisions or ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 25 October 2002 13:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Thursday, October 24, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema
RE: Installing iAS 9.0.2.0.1
Gene, Installed and running all (really!) components on Red Hat, HPUX, and Windows. 9.0.2 is better then 9.0.1, in part because it mostly works out of the box. Get ready to troubleshoot various individual components after initial installation. Wait, you will likely be performing two installations: one for Infrastructure and another for the mid-tier, Business Intelligence, that's the part that includes Forms and Reports, among other things. Forms Server should work out of the box. Reports server likely will not. Retry during configuration wizard may do the trick. Another show stopper - after infrastructure install, OID (Oracle Internet Directory) will listen on port 4032, yet the OID client will by default attempt to connect to port 389 - cost me few hours of frustration. Having gone through this workout few times in recent past, details are still fresh in memory. Please 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 Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I haven't even looked at deploying forms yet :). I can't wait til 10i when DBA's are no longer required, *HA!* Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 removed from). You may also send the HELP command for other information (like subscribing).
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 like the product and offered a number of time to monitor databases for me. No thanks, but hey... Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-538-1000, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jamadagni, RajendraSent: Wednesday, October 23, 2002 5:39 PMTo: Multiple recipients of list ORACLE-LSubject: DB monitoring using SNMP MIBs Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
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 To: Multiple recipients of list ORACLE-L Shouldn't there be another goal like query the data? How about query the data while refresh is running? If you're on UNIX, I'm guessing that dd and grep should do just about everything for you... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 1:29 PM 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for RDBMS Goal: to be able to refresh weekly from tapes/cds/other sources. What kinds of software/hardware may be needed to tackle this? Gary Weber -- 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 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 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: Tim Gorman 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 To: Multiple recipients of list ORACLE-L What you have is a database that only supports full table scans and only allows cold full database backups and cold full database restores. Hopefully, you're never just seeking anything less than a full file, there are no referential-integrity issues between the files, and the availability requirements allow the data to be completely quiesced (no updates at all, just reads) while those cold backups are running. Even with a week between individual cycles, adding more load/update cycles can really make a week disappear... Good luck! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 2:27 PM 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 To: Multiple recipients of list ORACLE-L Shouldn't there be another goal like query the data? How about query the data while refresh is running? If you're on UNIX, I'm guessing that dd and grep should do just about everything for you... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 1:29 PM 1-3 terabytes of raw data. ASCII format. Flat files. No requirement for RDBMS Goal: to be able to refresh weekly from tapes/cds/other sources. What kinds of software/hardware may be needed to tackle this? Gary Weber -- 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 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 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: Tim Gorman 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 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: Tim Gorman 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
OAS 9i anyone?
Greetings, We are contemplating a purchase of Oracle Application Server 9i. Anyone using it? Mind sharing your experience? What prompted you to purchase an Application Server? Why was Oracle App Server chosen, as opposed to Weblogic, etc? J2EE considerations? Ease of configuration/maintenance? Who's in charge of OAS (DBA, SysAdmin, Developer)? Stability? We've had numerous issues with Weblogic recently, hence the question. Do you feel the ROI has justified the purchase? How many developers are involved in writing apps and/or supporting your installation? Thanks in advance 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Advanced Replication
Pete, I've implemented a very similar solution recently for BEA-based application. Two database servers, Multi-master replication between two databases, 1 minute propagation interval. Works great on our hardware, which was designed for the purpose and is pretty fast. Small transactions - OLTP stuff - seem to replicate well. The same can not be said for large DML operations. So far, I've been unable to tune replication so that it is capable of propagated batch type changes for large amounts of data - the receiving site seems to be converting the DML based on internal algorithm, which 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, February 14, 2002 5:04 PM To: Multiple recipients of list ORACLE-L We are looking at Advanced Replication as a fail over option for a web site. Straight forward installation, both boxes on the same subnet on their own dmz. The servers will be located on the same rack in the computer room. Very few tables storing data from an application that is tracking click through data. Does anyone see any flaws with the basic plan? Any hidden 'features' that we may run into? Thanks = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett 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 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 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: DENNIS WILLIAMS 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: The OCP bar is being raised
Took the time and spent the money - I'm an OCM (Enterprise Scalable mojo). Haven't had a need to flash the certificate at any interviews thus far (possibly because I haven't interviewed), so it's been mostly for self gratification. I got the Master certificate last year, so didn't have to take any exams, other then the standard 5 for OCP, simply attended the classes. Btw, the minimum is three classes, with two being part of the path you choose, and a third being mandatory Data Modeling. Or at least it was that way last year. I've been Certified 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 hope that it never becomes a deciding factor. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Sent: Thursday, January 10, 2002 12:16 PM To: Multiple recipients of list ORACLE-L How many people outhere that you know do actually have OCM. Not ORACLE employees. Just curious... Regards, Viktor --- Bowes, Chris [EMAIL PROTECTED] wrote: Maybe I am completely misreading this. However, I didn't see the 8 to 9 OCP upgrade and that is why I said, you'll have to take them over again. If I am completely out to lunch and this is just a re-org of the Masters and OCP and those 8 OCP can get OCM with 2 classes and a test, then I apologize for wasting your time and bandwidth, but from what I read (and it was a quick read) even if you are 8 OCP, you still have to have the 9 OCA and OCP before you can get the 9 OCM. --Chris -Original Message- Sent: Thursday, January 10, 2002 10:41 AM To: Multiple recipients of list ORACLE-L Of course, those of us who already have the OCP and want to be called a 'master' just need to take the 2 required courses and then the OCM exam. When looking at the details, they just split the previous 5 exam OCP into two tiers, a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite. The Oracle Master was always available, but without a test -- it just required taking ILT courses. They just added a practicum exam to make the OCM cert. I can see your point about this being a 'money grab', but the only new item here is the OCM practicum exam -- everything else existed for 8 and 8i. -Joe At 07:05 AM 1/10/02 -0800, you wrote: I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then and only then, can we take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still, has to spend money in a class that they could probably teach from memory before they can get certification and that is after getting 2 other certs that have no value to them. Call me a cynic, but to me, this is nothing but a money grab. From the website: --To become an Oracle Associate, you must pass the exams required -- for the Oracle Associate level of your selected job role. Typically, --two exams are required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By --completing your Oracle Associate, you are half-way toward achieving the -- Oracle Certified Professional credential. --To become an Oracle Certified Professional, you must pass all required exams --in your selected job role, including those at the Associate level. --To become an Oracle Certified Master, you must first be an Oracle --Certified Professional. Additionally, achieving your OCM credential --requires attending two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum exam. --Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Subject: The OCP bar is being raised Anyone care to comment on the following, IMHO it's about time: --- - --- Introducing two new levels of Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and Training Services quoted database professionals and network engineers as the fastest-growing areas of Professional Certification. And in an October survey from *crn.com on Certification, 58% of respondents said that it is very difficult to find qualified Oracle Certified Professionals-Database Administrators. To meet this demand, we have recently introduced two new
RE: replication
Bill, Tread very carefully along Replication path while considering 4 GBs of data to be replicated daily. If all transactions are inserts, it may fly. If you have updates or deletes, you may encounter huge performance hit on destination site. Also, consider the fact the Replication will slow down your source destination loads. For new every transaction an entry will have to be created in a queue - double (or triple?) hit on redo logs. While setting up Replication, make sure the SYSTEM tables supporting it are outside of SYSTEM tablespace - there are instructions for this on Metalink. Replication can be setup for existing tables - no need to re-create them or do anything else with existing data. Look out for custom sequences - those don't get replicated, so a manual workaround may be required. I would still choose out of the box Replication over custom solution on the long run, but consider all downsides before committing to it and test extensively with real amounts of data. PS. I am currently working w/OraSupport on the issue where a replicated transaction is behaving in a weird way on destination database - it attempts a full table scan for delete operation 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: Multiple recipients of list ORACLE-L Greetings, I am looking for advice regarding Oracle replication. We are on 8.1.6 EE, and will be upgrading to Oracle9 later this year. At that time, we also plan to establish another Oracle instance on a separate sun machine; 1 instance will serve as a staging area, the second will be a production reporting database. We need a way to quickly move processed data from the stage instance to the production instance on a daily basis. Methods we have discussed, pros and cons (please feel free to comment): Export/Import and flat file transfers have been ruled out due to speed. Transportable Tablespaces: Pros: fastest method of moving large amounts of data Cons: Constraints - our tables are very integrated, lots of foreign keys, just about every tablespace set would have to include a core set of reference tables, or the entire thing (500GB) would need to be in the same tablespace set; not including constraints means re-building them in the production instance, including indexes for PKs and UKs (I think) and probably other problems. How do others handle these problems? Also, this transfers all data, when only a very small percentage of rows ( 1% of total rows) has actually changed that day. Seems inefficient. Oracle Replication: Pros: The documentation seems to address our situation, replicating a small (relative to total db size) batched amount of data daily. (2-4 GB) Cons: Looks complex, 2 books (~760 pgs, ~360 pages in Oracle9), 13 packages. No experience with this - How well does it work? Is it difficult to set up? Any comments regarding speed? Can replication be set up for existing tables, or do they need to be re-created and re-loaded as a materialized view? We are also considering another solution, basically borrowing many of the ideas from Oracle replication and writing it ourselves. This would be a home-grown solution involving table triggers, additional tables to store the daily changes, and scripts to propagate the changes over database links. But before we decide, I wanted to hear what others had to say regarding Oracle replication. Thanks for any advice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8.1.7 on MS 2000
Yes. Install 8.1.7, upgrade to 8.1.7.2.1, only then create databases. One of the interim patches between the two levels knocked out SNP processing in existing databases - no job would run. Unfortunately, testing jobs was not a part of the overall QA process so I don't know exactly which patch was bad. Oracle could not fix the problem and after battling it for a week I ended up rebuilding databases. There were other issues, specifically, Netassist wouldn't work with Names Server in 8.1.7.0, it would just crash, as well as some other setback I can't recall. Having said that, 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 -Original Message- L. Sent: Monday, January 07, 2002 2:51 PM To: Multiple recipients of list ORACLE-L Any experience with Oracle 8.1.7 on MS2000? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 Message- [EMAIL PROTECTED] Sent: Friday, January 04, 2002 1:16 PM To: Multiple recipients of list ORACLE-L Lemme get this right. This guy is a *new* DBA. He's making 150k and he's not even a senior DBA, where he can make 200k? That's all from me. I'm gonna go sulk now. Jared DENNIS WILLIAMS DWILLIAMS@LIFE To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COMcc: Sent by: Subject: RE: Becoming a DBA questions [EMAIL PROTECTED] m 01/04/02 09:05 AM Please respond to ORACLE-L The following eweek article might be of interest. If the link gets mangled, the article is at http://www.eweek.com Following the Data to a DBA Job by Jeff Moad. http://www.eweek.com/article/0,3658,s%253D703%2526a%253D20563,00.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 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 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: 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 -Original Message- T (Richard) Sent: Thursday, November 01, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Hi All, We are looking at purchasing TOAD or SQL Navigator from Quest. I think they have purchase EZSQL also which I liked(good and cheap). I guess there goal is to eliminate the competition. I have some experience with free version of TOAD but not with SQL Navigator. Can someone share there pros/cons,why purchase one over the other, etc. if they have used both of these products? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 25, 2001 3:21 PM To: Multiple recipients of list ORACLE-L I've taken all the standard Oracle database administration classes such as perf tuning, backup and recovery, replication, etc. What I am looking for is a really good class that's more advanced. Does anyone have a killer class they recommend? Thanks, Dave Turner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
Job queue in 8.1.7.2.1 on Win2k - dead
Hello, While I'm trying to get this resolved with Support, I wonder if anyone else encountered follow problem. Oracle EE 8.1.7.2.1 on Windows 2000 Advanced server. DBMS_JOBs don't run automatically. When executed manually, they are ok, when placed in a queue, they just sit there. SNPs processes are running. This worked fine up until 8.1.7.1, which had different bugs, and prompted an upgrade to 8.1.7.2.1. I suspect this latest upgrade introduced the stale job queue. All obvious solutions have been tried and failed (changing queue size, bouncing, submitting jobs as system, 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 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 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 removed from). You may also send the HELP command for other information (like subscribing).
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 haven't heard of a working solution yet, and apparently, neither has Oracle. Gary WeberSenior DBACharles Jones, LLC||Superior Information Services, LLC609-530-1144, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Wednesday, September 26, 2001 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: the OT list Don't forget this list is now to be used for oracle topics only. If you want to post OT stuff, feel free to join the [EMAIL PROTECTED] list. Although I've not seen the jokes/recipes on their yet, where are you posters at? Obligatory oracle msg :) I see in the 9i docs, ONAMES will be desupported in a future release, any insider know when? thanks, joe
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 that participated in this very informative, spirited and amusing discussion of these products, I'm wondering if we should go with MS server instead... Miriam -Original Message- Sent: Wednesday, September 26, 2001 1:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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 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 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: Miller, Jay 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 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 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: Bryan, Miriam 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 that 's currently running 2 MS SQL7 servers 2 MS 2k Servers 6 Sybase 12.1.1 ASE servers and 5 Oracle 8.1.7.1 servers The MS servers is used for time tracking and a helpdesk database, Sybase is used for our Online communities and a host of other things. Because of Sybase's limitation and problems 3 years ago, Oracle was supposed to be our New Production System. The idea was to migrate all other system to Oracle and have a shop running under just one platform. Well, this was over 3 years ago and things have not progressed as expected(very long story), We are still running all three platforms. Sybase has come up with new releases that have addressed some of the issues we had against it , now we don't know which platform to keep(between Oracle and Sybase). In your opinion, which one is more robust, better? we need replication and resource management. TIA, Miriam Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bryan, Miriam 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 repackaged. Gary WeberSenior DBACharles Jones, LLC609-530-1144, ext 5529 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, 088130)Sent: Monday, September 17, 2001 2:30 PMTo: Multiple recipients of list ORACLE-LSubject: 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 , Asia Pacific, and Latin America) (5.5.0.33) Oracle Geocode (US Data) (5.5.0.33) Anybody familiar with this stuff? (I could just drop it in the CD-ROM but I don't have time at the moment.) Matt Adams GE Appliances
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 Message- Sent: Wednesday, September 12, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Against who? Against Aghanistan's farmers and their families? I know how do you feel. Please accept the condolence from me. And by the way - now is the time of snipers and intelligent services. JP On Wed 12. September 2001 15:25, you wrote: War is the first way, we will figure the rest out when we are done. A great injustice has been done, and now is not the time for mercy. We have put our tails between our legs in the past, this is no time for it. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, September 11, 2001 8:12 PM To: Multiple recipients of list ORACLE-L Ohhh, my little movie soldier, will YOU take a machine gun and run in front line??? Do YOU know what are yout talking about I feel so sorry for the people being in WTC, but I hope the war is the last way. JP On Tue 11. September 2001 19:30, you wrote: Time to test all the weapons we have been buying. Hate to say it...i am such a freaking peace lover, but this has got to be fixed..NO ONE, ANYWHERE should celebrate this. btw...trying to reach Rachel by phone...she is on her way out of the city, but likely smashed in traffic -Original Message- Sent: Tuesday, September 11, 2001 1:16 PM To: Multiple recipients of list ORACLE-L According to AP. It looks like the entire island of Manhatten is one big ball of black smoke. AA Flt. 11 from Boston hit one WTC. UA FLt. 175 from boston hit the other. AA Flt. 77 hit the Pentagon. UA Flt 93 crashed in Pittsburg - questionable target?? Untold numbers of people dead in the buildings - projecting at least 20,000 inside. Possible secondary bombs exploded that collapsed the buildings. Suspect bomb in a high school nearby too. Continue to hear explosions all downtown - gas lines exploding... Pretty sure it's BinLadin who is being kept in Afghanistan. It will be WAR for sure on Afghanistan if they continue to harbor him. Pictures of Palestinians CELEBRATING this on the West Bank. -Original Message- Sent: Tuesday, September 11, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Its now 1. BOTH tower have fallen. 2. Pentagon hit by a plane. 3. All flights in US grounded And I am sure more to follow -Original Message- Sent: Tuesday, September 11, 2001 9:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two planes have crashed into the World Trade Center in New York City while an explosion has rocked the Pentagon in Washington DC. The White House is reportedly being evacuated. One report says six people have been killed in the New York incident while hundreds have been injured. Smoke is pouring from the upper storeys of both towers of the World Trade Center. The building, one of the world's tallest, has been badly damaged in what President George W Bush has described as an apparent terrorist attack. He said: We will find those who committed this attack. New York police have been quoted as saying that both planes were hijacked from Boston. A few minutes after the first tower was hit by a passenger plane, a second, similar plane was seen flying into the second tower. A huge explosion was seen. Eyewitnesses say the first plane crashed into the West Tower after flying unusually low over Manhattan Island. A BBC correspondent says 10 to 15 floors have been affected by the crash. Briton James Winter, 30, living in an apartment close to the centre, said he was woken a huge bang at around 0800 local time. I
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 in data tablespace. What's an easy, safy way to move them into index tablespace? Thank you. Janet __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Comparison Statistics between Oracle and MS SQL
Though it would be a good test to port several production systems ( of different nature ) to Oracle/ Some Compaq /2K and MsSQL Server/ Same Compaq /2K, who has the time and money to do it? Been there, done that for sister company. 200 GB database. Same 2-way Dell box, running 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 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-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Duhvelopers and DB-ehs?
A modern day classic! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 31, 2001 4:20 PM I am in charge of 273 databases at sites throughout the world, some of them in places with no electricity where we have an elephant on a treadmill supplying power. I personally had to once step in for the elephant when he was feeling under the weather. All of these databases are 26 x 8, meaning 26 hours a day eight days a week since we have to deal with the additional day caused by the international date line, and two extra hours because of some places have weird time zones. On certain days the International Time committee adds a leap second to the day which means that on those days I have to work an extra second * 273 databases which adds up to several minutes. On 19 of those databases, due to the lack of funds for storage, I have to do a backup to paper, i.e. I have to manually read every table through select statements and write them down on paper using a broken pencil. We are planning on sending a few databases out onto satellites, one of them on a probe to Neptune. I will also be in charge of the backup/uptime for those mission-critical systems, since they will be used as the back-end for a website that receives thousands of hits per minute (a Britney Spears fan club site). 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 afford ceramic. -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Applications patches
Patrice, Welcome to the wonderful and exciting world of Apps patches! Are some more critical than others? Yes, but it largely depends on the extent you're using the system. Generally, I don't bother with minor patches unless a specific bug is stumbled upon. If you roll with the mega 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 J Sent: Tuesday, August 28, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I did a quick search in Metalink for Oracle Applications patches... and Metalink returned 500 items! Are there patches that are more critical than others? I have a copy of Oracle Applications for NT, I just want to learn to install it, configure, and play with it a little. (500! Unbelievable). Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: EMC Timefinder
This is a pretty large, complex topic. Which is likely why you didn't get any replies. Myself not having enough time to go into many details, here are few key points: We run on EMC. We don't use RMAN. Biggest pro: BCV - business continuation volumes. I can afford 5 minutes of downtime weekly. In that window I get a full cold backup of few hundred gigs of database files. Cons: Complex beast to setup from EMC side. This translates in very few available resources who can do so. Double the disk - for BCV with secondary, online copy of everything. We learned with our Symmetrix box that its not the amount of disk thats costly, but the effort to add additional disks. Process to setup? 1. Identify your availability requirements. 2. Overestimate storage requirements. Multiply by two. 3. You do have a fail-over machine? It will have to support entire production load if primary fails, 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 PM To: Multiple recipients of list ORACLE-L I did posted this yesterday. I am posting it again for any valuable responses from the gurus. Thanx Srikanth -Original Message- Sent: Tuesday, August 07, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Hi Folks, Good Morning. I am very new to this forum, So Please bear with me for any mistakes. I am also relatively new to the oracle 8 front(I am coming back to oracle after a gap of 4 years). So the question may be stupid. We are trying to set up an environment using Oracle 8.1.7, Emc Timefinder and RMAN. While there are no documents to describe how to do the setup on this, We did find some notes. But those are with oracle 7.0. Is someone on the group has this kind of setup? If so, Can you update me on the process?? Any Pros and Cons to go with this? Thanx for all responses Srikanth VS [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valuthur, Srikanth 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 recipients of list ORACLE-L Hmmm...I haven't had the privilege of working with EMC stuff, so I am curious as to why you want to replace it??? Thanks. -Original Message- Sent: Thursday, August 02, 2001 8:11 PM To: Multiple recipients of list ORACLE-L Hi Fellow DBAs, My company is thinking about dumping EMC (we have everything, symmetrics, connectrix, EDM, cellara etc). In your expert opinion what's a good alternative to go if we really need to replace EMC. Is Hitachi storage good? Does Veritas' backup solution do the stuff EMC/EDM can? What would you pick to replace EMC? Any information is welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji 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 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 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: Grabowy, Chris 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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: 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Does OEM affect Oracle performance
In short, no. This is assuming you will not use production databases for OEM repository. Minimal impact in case you do. I setup OEM to hold hands for about 15 databases, with various events, jobs, etc. It's been running ok for the past year, with repository approaching 1 GB in size. My 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 list ORACLE-L Hi, We are running Oracle 8.1.6 and are planning to install OEM. Are there any issues regarding OEM affecting oracle negetively (performance or otherwise) that the people are aware of? thanks g = __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- bhatti Sent: Tuesday, June 26, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Quick question on this. When I was using 8.0.5.2.1 (OEM dba and agents), I would need to rebuild my agents every week or so and delete all my events and resubmit them back into the repository. Is this still the case with later version, especially 8.1.6 i.e has the reliability improved? thanks mkb --- Gary Weber [EMAIL PROTECTED] wrote: In short, no. This is assuming you will not use production databases for OEM repository. Minimal impact in case you do. I setup OEM to hold hands for about 15 databases, with various events, jobs, etc. It's been running ok for the past year, with repository approaching 1 GB in size. My 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 list ORACLE-L Hi, We are running Oracle 8.1.6 and are planning to install OEM. Are there any issues regarding OEM affecting oracle negetively (performance or otherwise) that the people are aware of? thanks g = __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: RAID5 question, take 2
Mogens, the super-market analogy does not apply - this is for SQL Server database. I'm not sure how far I'll be able to tweak that rdbms, hence my question did not contain many details - it was simply a request for opinions. Btw, to sum up current responses: Option 1: split 9 drives to 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 -Original Message- Nørgaard Sent: Monday, June 11, 2001 3:15 AM To: Multiple recipients of list ORACLE-L Indeed, Paul. Very good points. Gary - you're asking us to determine the number of bags we'll need at the supermarket without knowing what we're going to buy. If we had IO-stats for your datafiles/tablespaces, ie reads/writes and their size, and your availability requirements on the system, we could tell you more. Paul Drake wrote: Gary, Here is where we have to know more details. a 9 drive array on a single channel sounds like your peak I/O rate for reads would be throttled by the controller channel speed. Now, if the SCSI interface is ultra 160/m, and the drive support a sustained rate of 20 MB/sec - you're not pinched. But if the RAID controller interface is FC - and only 100MB/sec - you're going to be seriously pinched during index range, fast full and full table scans - bulk reads. Are you using fine-grained striping - such that a FTS will be using the multiblock_read_count and will hit all 8 drives (net)? what's your: db_block_size multiblock_read_count OS I/O size If your OS I/O size is 128 KB and your db_block_size is 16 KB then a multiblock_read_count = 8 and a stripe size of 128 KB - or 16 KB depth per stripe member. (as the parity drive is ignored) and each member in the stripe contributes one block in each read request for a FTS. SAME methodology would imply that your OS I/O size has been cranked up to 1 MB, and that your stripe size is also 1 MB. On a FC interface - the transfer speed for a 1 MB read would be 10 ms - on par with the average seek time. But SAME is not geared for RAID 5 - as RAID 5 supports having the drive heads out of sync to satisfy mutliple independent requests concurrently. SAME is geared more for RAID 0+1 - where the drive heads in an array move in unison - with all drives returning the results of one request at a time. What do you want to return for your read requests - (1 db_block, multiblock_read_count, 1 MB)? This will depend entirely on the access paths that are used in YOUR application. Basically - a 3 drive RAID 5 array is useless. Don't even consider it. Better off to have a single RAID 1 volume with a hot spare. If I were to break the 9 drives up (it would be as a RAID 0+1 of 4 drives each) - it would be as a 5 drive and 4 drive array (assuming that 2 channels are available). if most of the read requests have been driven by an index - and only one block is being requested - the 9 disk RAID 5 config is the way to go - as seek time will dominate transfer time. just my opinion. Paul -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RAID5 question, take 2
The reply below was a great post! As were replies prior to it. But, none of the replies were for the original question. The issue in hand is not which raid level to use or whether to use at all. The question is, and I promise this is the very last time I post it: given 9 hard drives dedicated for RAID5, should data reside on 6 drives via volume group A and indexes on the other 3 drives via volume group B, or should data and indexes be placed on all 9 drives via one volume group? The data is absolutely static. Gary - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 10, 2001 7:15 PM Since RAID5 means that data is striped, of course read performance is OK. As soon as you talk write performance, however, RAID5 becomes something of a joke since it was invented back in the 70's to offer a cheap alternative to the fast, extremely expensive disks offered by IBM back then. So the focus was on limiting the number of disks. Today, where disks in general are cheap and caches are expensive, I really have a hard time figuring out why people buy RAID5 (few disks, cache required to compensate for the horrible write penalty) instead of RAID1+0 (more disks, no cache required). And I have a hard time figuring out why the vendors are pushing RAID5 solutions, if RAID1+0 means selling more disks to the customers :-). The answer, of course, is that they are making money on caches, not disks. Technically speaking, RAID1+0 will always be better than RAID5, of course. Oh, they will try to compensate with caches and talk of RAID3 techniques and what have you. RAID1+0 is still superior to RAID5 in any techinal aspect. It becomes really absurd when you look at the SAN offerings on the market. For instance, IBM's Shark only offers the customer the choice between JBOD (Just a Bunch Of Disks, ie., Non-RAID) and RAID5. IBM has a red book out regarding this and on page 127 out of 228 or so you can read the headline: JBOD or RAID5? and that's when it dawns on you that Shark (which is very expensive) cannot under any circumstances be configured for anything else than RAID5 or non-RAID. Workaround: Place a file system on top that at least can be striped (Veritas, for instance). EMC has a standard offering where they'll suggest RAID-S (S looks a lot like 5, doesn't it?) and the standard answer if write performance is not good enough is: Add more cache. Well, we had a customer who reached 32 GB of cache (not MB, mind you, but GB) and write performance was still bad (of course) for restores and recovery operations and file copying and all those things where a cache can never help you. Fortunately, EMC can be re-configured for RAID1+0, which the customer finally did, and all went well. They could then return the expensive cache and save some money :). Same problem with HP (Hitachi) - they'll try to pursuade you to buy a very expensive RAID5 system. It's like trying to talk you into paying a lot of money for a WWII Spitfire, claiming that the avionics have been upgraded a great deal and that for the general user, this is much better than todays aircraft :-))). We have lots of horror stories like this regarding RAID5. Of course it's good enough in a lot of situations. But you should know the reason why it's good enough. And the moment you have to restore or recover anything, you will discover the true price (factor 4, usually) of RAID5, namely the write penalty. No amount of cache can help you in those situations. Christopher Spence wrote: Static data raid 5 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 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 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 removed from). You may also send the HELP command for other information (like subscribing).
Enterprise User Security?
Greetings, Has anyone implemented a combination of Oracle Internet Directory or MS Active Directory with LDAP and Enterprise User Security? If so, what is the complexity level like? Reliability of the solution? Management implications? My understanding is that Oracle Names will be eventually 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://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 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 removed from). You may also send the HELP command for other information (like subscribing).
RAID5 - to split or not to split
All, 9 drives + hot spare Would you stripe 6 for data and other 3 for indexes, or use one 9-drive volume for both? One side of me says the more spindles the merrier - keep them together, the other side says - separate data and indexes. The third, evil SA side is waiting for the first two 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-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 To: Multiple recipients of list ORACLE-L I'd appreciate any info. anyone could provide on what method you use to track database changes that have been implemented in dev, test, stage and production. I need a way of tracking frequent modifications to tables, packages, etc.. and wanted to get some input on how others are handling this. TIA, Richard Huntley E-mail: [EMAIL PROTECTED] -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
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 user?? I had it but I want to update mine. TIA Raghu. -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
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 San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue. --Jay Trigg -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 2:31 PM To: Multiple recipients of list ORACLE-L Subject: Bumoer Stickers [RE: Rebuilding indexes] It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT Don't forget HELP - Kirti -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Subject:RE: Rebuilding indexes On Fri, 1 Jun 2001, Hatzistavrou Giannis wrote: I don;t quite understand you quoting Once the indexes have all been rebuilt nologging into the original tablespace, all that's left is to refresh the datafiles for that tablespace onto the primary. Is primary a typo error (i.e. standby)? Argh! It was a typo. Of course, after doing many unrecoverable operations, you should refresh the affected datafiles from the primary to the standby. Vadim Gorbounov mentioned the column 'unrecoverable_change#' in v$datafile. This looks like an SCN, not a count of unrecoverable changes. Either way, it seems like a useful way to decide if a datafile shoule be refreshed onto the standby. I can even imagine improving a standby log applier that could be made to refresh such files from the primary automatically. On another topic, I believe I qualify for some sort of award as uber geek. This week I obtained the Washington State license plate ORA DBA for my '74 Volvo. It got me thinking that it would be fun to have some bumper stickers made up for members of this list. Some ideas I had: ARE YOU AN IDIOT? or SHUTDOWN ABORT -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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 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 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: 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 To: Multiple recipients of list ORACLE-L Jared is having a bad day. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
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 -Original Message- Sent: Thursday, May 31, 2001 4:10 PM To: Multiple recipients of list ORACLE-L By the way ... For your own sake . never use data files that big !!My personal opinion is multiple files of 500 Megs or less . Or, on a system that has a file limit, 1 GB files as a Max. Larger than that and you can have problems with backup software long running FTPs if you duplicate DBs ...etc. -Original Message- Sent: Thursday, May 31, 2001 2:29 PM To: Multiple recipients of list ORACLE-L What do you mean by 'the system is not set up'. How do you verify that? We had problems with datafiles larger then 2 G and just turned autoextend off on all datafiles. I didn't know the system may or may not be set up to handle specific file size limit. Is it documented? Please explain. Thank you. -Original Message- Sent: Thursday, May 31, 2001 1:08 PM To: Multiple recipients of list ORACLE-L If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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 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 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: Kevin Lange 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 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 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: 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 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 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: Kevin Lange 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 Message- Sent: Thursday, May 31, 2001 2:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] I thought everyone would realize this is a joke. It's been appearing with some regularity in a mocking tone of someone that posted it seriously a couple of weeks ago. Sigh... Maybe I am just having a bad day. Jared On Wednesday 30 May 2001 23:50, Jared Still wrote: Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always 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-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
OT: Archiving not possible with SQL Server?
Halo, Windoz 2000/SQL Server 2000 Bringing an axuliary MS SQL db online. Trying to setup archiving. Am I reading documentation right, SQL does NOT automatically archive transaction log? This process must be setup via backup routine, which truncates the log upon completion? Lemme 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 Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Archiving not possible with SQL Server?
Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always 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-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Fire your DBA's you don't need them anymore...
Title: Fire your DBA's you don't need them anymore... Very stupid thing to do by Oracle, considering the fact that many Oracle purchasing decisions are made by Oracle DBAs. To shut us out like that will most certainly have an effect on Oracle Sales. Hell, you don't need me anymore? I'll 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) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list ORACLE-LSubject: Fire your DBA's you don't need them anymore... My boss just received a cold call from Oracle that he let me listen in on. They have a new push on for their i-dba support package. For just a little more money (they did not define little), "we will replace your dba's with our superior support team that will monitor your database 24x7 and proactively eliminate problems. This will allow you to redesign you office to offload these cumbersome DBA tasks and allow your workers to do other things. You will never have another database problem." I felt good when my boss indicated that we had no base problems but based on this, I guess we will have to become sqlserver DBAs or gasp developers... :) Ahh, Friday, wonderful Friday, it seems like you've been away all week... --Chris [EMAIL PROTECTED]
RE: Oracle DBA vs. Oracle Apps DBA - Different? and how?
Sometimes I think Apps DBA is shorthand for senior developer. I'd like to wholeheartedly disagree. Administering Financials fell onto my lap as just another Oracle-based product. There is much more to knowing this package than meets the eye from DBA prospective. The technology 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 -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle and Lawson
Hello Loren, Which version of Oracle is this Lawson beast running on? If its 8.x, I wouldn't be overly concerned with amount of extents (unless 1000), as much as I would be with indexes. See if they are being rebuilt on regular basis, and if not - its a great place to start. Of course, 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 ORACLE-L Hello All, I just inherited an Oracle database which runs Lawson CRM application. The database is extremely slow because there is high insert/delete activity in the tables which are highly accessed. Is there a solution to compress extents without using exp/imp utilities. Anyone on the list using Lawson, please give me some input. Export and import can take more than a day since the database is huge and we do not have more than 4 hours of maintainence time. Thanks Loren -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
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 10:11 AM To: Multiple recipients of list ORACLE-L Bryan, What O/S are you on? I had specific problems with the intermedia install on HP/UX that required some changes in the install procedure, per support. I have a few scripts - if you would like me to send them to you, please email me directly. Lisa Rutland Koivu Oracle Database Administrator Certified Self-Important Database Deity Slayer of Unix Administrators Wanton Kickboxing Goddess [EMAIL PROTECTED] NeoMedia 2201 Second St., Suite 600 Fort Myers, FL 33901, USA Phone: 941-337-3434 Fax: 941-337-3668 www.neom.com http://www.neom.com http://www.neom.com www.paperclick.com http://www.paperclick.com http://www.paperclick.com www.qode.com http://www.qode.com http://www.qode.com P a p e r C l i c k . c o m http://www.paperclick.com/home.htm http://www.paperclick.com/home.htm Enter Your PaperClick Code Here! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, May 11, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Does anyone have instructions or know where to find concise instructions on setting up the Intermedia database objects (i.e. CTXSYS and what not) in an 8.1.6 instance? Like what scripts to run or is there a utility. TIA Bryan M. Miller Junior Oracle DBA IT Operations Telergy Inc. Email: [EMAIL PROTECTED] Phone: (315)362-2642 Pager: (315)647-1908 -- -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Ability for non DBA user to kill session.
Lee, In short, you can't achieve this within Oracle domain short of granting ALTER SYSTEM to user in question or going via PL/SQL procedure owned by other, more protectedschema. However, a tool like TOAD will provide similar capability for you - a user is capable to "cancel" 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-LSubject: Ability for non DBA user to kill session. All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
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] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 Message- Patrice J Sent: Wednesday, March 14, 2001 7:21 AM To: Multiple recipients of list ORACLE-L It just monitors Up/Down, I think. Sometimes it doesn't work very well, my SQL Server has been down for two days (I don't use it) and the green flag is still up inside the OEM. I have problems with my test server though, jre.exe is hogging the system. Do you know if the OEM can monitor MS Access and Excel? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Nguyen, Long [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 6:07 PM To: Multiple recipients of list ORACLE-L Subject:RE: OEM day today? I don't know about publicity but if you install OEM 2.2 (Management Pack I think) you would see a product in there that allows the monitoring of SQL Server. Long -Original Message- Sent: Wednesday, 14 March 2001 8:11 AM To: Multiple recipients of list ORACLE-L Since today seems to be the official OEM day on the list, here is something I just discovered (may not be news to others). OEM supports MS SQL Server services. While "discovering" one of Oracle databases running on Win2k, I noticed new entry in Console tree: SQLServers. Upon starting 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 -- 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 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 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: Nguyen, Long 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 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 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: Boivin, Patrice J 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other informa
OEM day today?
Since today seems to be the official OEM day on the list, here is something I just discovered (may not be news to others). OEM supports MS SQL Server services. While "discovering" one of Oracle databases running on Win2k, I noticed new entry in Console tree: SQLServers. Upon starting 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 -- 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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Standby db license for 8.1.6
Dennis, PLEASE post your findings! I had to go through similar exercise recently involving Oracle and Squeal Server, we may want to exchange notes off the list. Gary -Original Message- Taylor Sent: Friday, March 09, 2001 3:20 PM To: Multiple recipients of list ORACLE-L I'm in the process of doing comparitive pricing betwwen oracle, sqlserver, and db2. Unless someone objects, I'll give a general summary once the info is in. At 09:35 AM 3/9/01 -0800, you wrote: You can open a standby database in read-only mode now. How are you going to prove that you are not using it. Don't get me wrong, I don't agree with Oracle licensing but the argument is off. -Original Message- Sent: Friday, March 09, 2001 7:47 AM To: Multiple recipients of list ORACLE-L Yup, they want you to pay for it, because it is an additional x number of processors. They don't care that it's not really "on" or being accessed. At filefrenzy, this policy actually led us to turn off a few of our processors. ;-) Diana -Original Message- Sent: Friday, March 09, 2001 9:55 AM To: Multiple recipients of list ORACLE-L If we put together a standby db (SUN 4500) is Oracle going to want more license money? Our thinking is, the license(s) we already own on the production server (also a 4500) cover us to keep the standby db going. We will not use the stand-by server for anything else. There will be no user access at all. Our (hungry?) Oracle rep is telling us that this is a clear case of "multiply by existing license(s) by 2", doubling our license costs. (Let's ignore all of the issues of power unit, named users, etc. for this conversation.) What has your experience been on this license issue for a standby db? Thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy, II 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 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 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: Diana Duncan 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 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 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: Kimberly Smith 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 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 removed from). You may also send the HELP command for other information (like subscribing). Dennis Taylor Hindsight is always 20-20. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 wan
RE: Oracle Masters program
Program still exists, although Masters requirements change somewhat frequently, and at times are misleading. For instance, I'm pursuing Enterprise Scalable Master certificate and was under the impression that only 3 Master courses were needed, including Data modeling one. To my surprise, Oracle kindly notified me about the requirement to take one more course, any course, from any other track to qualify. Go figure... Gary -Original Message- Patrice J Sent: Tuesday, March 06, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does it still exist? I can't find reference to it anywhere in the new www.oracle.com http://www.oracle.com layout. I am just curious - I had major problems with it when they informed me that taking Microsoft courses on NT wasn't good enough, to be certifiable as an Oracle on NT Master you had to have learned NT from... Oracle. Even though their course names were identical to the MS ones. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Informatica on Solaris - how about HP?
Hi Linda, I've been asked to give a hardware recommendation for Solaris running Informatica in development/test and production. The products we will be looking at are PowerMart, PowerPlugs, and possibly the eProcurement application. I've heard that it is a javalina (a javalina being a peccary, a pig-like animal. 'I am not a pig' ;-) ). For those of you running Informatica, what kind of Sun machines do you have? # of CPUs, amount of RAM, disk, etc.? What are the sizes of your databases, source and target? What are your experiences with the products from a DBA standpoint? Not a Sun machine, but for what its worth we're running PowerMart on HPUX 11 (HP9000 N-class box, quad CPU, 8 GB RAM) with repository in 8.1.5, multiple targets of various versions on HPUX and Windoz), source mainly being Informix. As far as disk for PMserver, I can't say much - our box is attached to EMC unit. Actual data loads and transformation is where PowerMart get nasty with resources. The server itself (PowerMart server that is) runs pretty light while routines are scripted/edited/queried. Once you start moving data, it grabs hundreds of megs of RAM and spins the CPU. I'd recommend at the very least a dual processor, quad if budget permits. Depending on others resources using the box, I'd start with 2 GB of memory and make sure it scales to more. Regarding database sizes, Informix sources are about 300 GBs combined, same for Oracle database where database is to be moved. Either developers here are telling me lies, or Informatica can't be tweaked to perform direct loads - hence loading routines run forever. Also, same developers are telling me that Informatica version we have is not certified for 8.1.6 and repository MUST reside 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.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 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Designer issues and opinions
1. Best CASE tool for ORACLE. 2. Steep learning curve. 3. Expensive. 4. Overkill for 50% of projects its used for (personal experience, your mileage may vary). 5. Existed for years. 6. Oracle Support is strong. 7. Knowledgeable developers are few. 8. Generates different types of code. 9. Almost always you'll need to customize generated code. 10. Very strong as repository. Gary -Original Message- Vinjamuri Sent: Friday, February 23, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, This could be a FAQ-type question, however, I have been unable to find much of relevance ... I have been asked by a manager about any known issues and opinions of Oracle Designer. How much widespread is the usage of Oracle Designer product? Are there any known issues? Any strong opinions on the usage or not? Thanks in advance, -Raghav _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghav Vinjamuri 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
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 Is it me, or is MetaBlink on the fritz again? I get truly odd refresh times and behavior..
RE: Rolling Upgrade of Oracle on a 24*7 implementation
Not 100% sure, but I don't believe you can do a "rolling" upgrade in OPS configuration. All or nothing deal it seems. I can't imagine DLM capable of operating with different Oracle versions in multiple instances. My guess is, you could upgrade one box in the cluster at a time, but you would need to have a black out for the last box. Again, this is only a guess. Gary -Original Message- Vallath Sent: Thursday, February 22, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Any body have ideas on how a Oracle Upgrade is done in a 24*7 installation for a very large database specifically using OPS. TIA Murali _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: Rolling Upgrade of Oracle on a 24*7 implementation
Title: RE: Rolling Upgrade of Oracle on a 24*7 implementation So, when freshly upgraded box comes online, lock manager doesn't have a problem with different versions? And on related note, at what point is the data dictionary upgraded? Having never done this, I'm rather curious -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Thursday, February 22, 2001 2:26 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Rolling Upgrade of Oracle on a 24*7 implementation You can do rolling upgrades on OPS, yes. For 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, but I don't believe you can do a "rolling" upgrade in OPS configuration. All or nothing deal it seems. I can't imagine DLM capable of operating with different Oracle versions in multiple instances. My guess is, you could upgrade one box in the cluster at a time, but you would need to have a black out for the last box. Again, this is only a guess. Gary -Original Message- Vallath Sent: Thursday, February 22, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Any body have ideas on how a Oracle Upgrade is done in a 24*7 installation for a very large database specifically using OPS.
RE: working with CLOBS
Adam, You will most likely need to use dbms_lob package. It has few nifty functions for dealing with lobs/clobs Gary -Original Message- Sent: Friday, February 16, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Hi listers. I have a question on migrating some data. I am tryign to get some remote data into an 8.1.7 NT install and running into trouble with CLOBS. Ideally I need to do an INSERT INTO TABLE2 SELECT CLOB1, CLOB2, VARCHAR2) Is this possible? I am getting an error that looks a lot like this is not an acceptable LONG operation. thanks for any advice. adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adam Turner 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: working with CLOBS
The data is coming from Access? Number of options are present. Spool to text file and load LOBs by reading from such file. Move to LONG columns, if possible, then use TO_LOB to move data into LOB fields. A long shot, but Oracle used to ship this thing called Migration Assistant for Access. Having not seen it, I don't know if it is of any use, but could be worth a shot. Gary -Original Message- Sent: Friday, February 16, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Thanks. That is what I am trying to do now the only problem I see is that this is over a linked DB to Access over HSODBC and it looks like the calls aren't supported. What about populating some variables then writing them to the CLOB's ... hmmm adam -Original Message- Sent: Friday, February 16, 2001 3:16 PM To: Multiple recipients of list ORACLE-L Adam, You will most likely need to use dbms_lob package. It has few nifty functions for dealing with lobs/clobs Gary -Original Message- Sent: Friday, February 16, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Hi listers. I have a question on migrating some data. I am tryign to get some remote data into an 8.1.7 NT install and running into trouble with CLOBS. Ideally I need to do an INSERT INTO TABLE2 SELECT CLOB1, CLOB2, VARCHAR2) Is this possible? I am getting an error that looks a lot like this is not an acceptable LONG operation. thanks for any advice. adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adam Turner 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 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: Adam Turner 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 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 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Async I/O on Windows - CacheFusion
Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE CacheFusion is already available in 8i. They call it the first phase, or something along those lines. 8i version handles the redo blocks over the interconnect, whereas the 9i will also ship the actual data blocks. So, 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: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE The whole idea behind 9i is CacheFusion which uses a high-speed interconnect to solve the pinging issues. At least that is the marketing line that will only be proved in time. Any database of any size should be using partititioning if you want it to perform and be able to manage it. --Tony Johnson Email : [EMAIL PROTECTED]Senior Database Administrator Voice : ( 480 ) 682 - 0849GridData Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100 Fax : ( 480 ) 961 - 8801Chandler, AZ 85226--Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, RossSent: Tuesday, February 06, 2001 6:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE I understand the argument, Rodd and it raises three points/questions: 1) I can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN does for the Oracle solution, and at less cost, and 2) Do you believe you can simply "add nodes" to an OPS farm to improve performance? I have personally never gone over a humble two nodes in OPS, and even then, locking issues must be addressed. One way out of this is the geographically segregate and partition the data. But this would be "federated." In a pure play OPS scenario, I would imagine the system would choke to death after the fourth or sixth node, without special tweaks like partitioning, either by data or application. 3) Loss of a SS "state", just like loss of an oracle partition, does not "kill the operation of the system". here, they are the same. .. just a thought.. -Original Message-From: Holman, Rodney [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 06, 2001 5:21 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Ross, I was at the Open World conference session where Jeremy Burton made the comments about clustering, OPS, data segmentation, etc. The data segmentation part was about MS SQLServer, and about how it creates significant work to add cluster nodes.C|net has their terms and comments a little scrambled. The Oracle 9i solution used OPS for the instances and an EMC/SRDF SAN for the data storage. Each OPS cluster node had full access to every piece of data. By doing this no node is a single point of failure (as Larry demonstrated and was chastised for by MS). Also it creates greater capability for scalability. Just configure and add a node and it improves performance (also part of Larry's demo). As described with the MS federated database configuration you would need to resegment the data to add a node. This would then destabilize the system even further by adding another single point of failure. Failure of an OPS cluster node with the data on a SAN with redundancy, such as the EMC/SRDF option, only decreases performance, it doesn't kill the operation of the system. Rodd Holman -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, February 05, 2001 5:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE Very Interesting! It appears Oracle 9i, is, in fact, a Hybrid Federated Database! http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni A snippet: