standby archivelogs
I would like to pose a question to the group in hopes of saving some testing time. I am reconfiguring an 8.1.7 managed standby server after moving it to a new data center. The network link between the primary and standby is now 1/4 of what it used to be and I think this is going to be an issue. During periods of intense activity we can generate a LOT of archive logs very quickly. relevent parameters: log_archive_max_processes = 5log_archive_dest_1 = 'LOCATION=/oradata/xxx/arch MANDATORY REOPEN=120'log_archive_dest_2 = "service=X reopen=300"log_archive_min_succeed_dest = 1 my question is this.. will the primary database hang if all the redo logs are full and the archive process cannot keep up due to the slw network connection to the standby? i.e. will all 5 archive processes get tied up writing to the standby and be unavailable to archive local logs? do archivers give priority to local logs somehow? Is there a way to separate local archive processes vs. remote archive processes? I do not want to increase the number of archiversbecause this will only saturate the network more... Thanks! Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
RMAN reports
Hello everyone, I am woundering if anyone on the list has scripts written to create backup reports for all databases registered in an RMAN catalog directly from the RMAN catalog tables.I am looking for advice on the simplest way to report on the status of backups for many, many enterprise databases.. I do not want to run reports through rman for each instance.. I would like to query the rc_* tables directly to gather information about the success or failure of every database backed up to the catalog on a daily basis... I want this information on one daily report that will identify all successful backups, all failed backups, and all backups that did not run for any reason. I am finding it difficult to cull this information based on the rman catalog tables.. each backup contains dozens of pieces and each can fail or succeeed on it's own and therefore constitute the failure of the overall job..Also, the data, controlfile, and archivelogs are all seperate backups but all must suc! ceedin order to be valid. the other complication is that backups run at different times and I could be looking at an incomplete view of backup data at any given time.. The report would have to take this into account as well. As you can tell this reporting is not a trivial task but I am hoping someone out there has tackled this issue in some creative way... I cannot believe that oracle does not offer a more comprehensive consolidated view for all backups.. maybe I am missing something key here but so far it has been a real pain to keep track of all the backups running in our enterprise. TIA Jim Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
how to update rbs?
I want to change TRANSACTIONS_PER_ROLLBACK_SEGMENT default parameters of rbs segments. but i don't know where this parameter is, how can i deal with it? Jim [EMAIL PROTECTED] 2003-01-02 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim 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).
what's the exact meaning of those messages?
Hi, I found the following message from the alert.log: Sun Dec 29 22:35:42 2002 ARC0: Beginning to archive log# 3 seq# 126 ARC0: Failed to archive log# 3 seq# 126 Sun Dec 29 22:35:42 2002 ARCH: Completed archiving log# 3 seq# 126 It seemed the ARC didn't work in the begining of archive, but worked finally after a while, I got lots of those messages from alert.log file. what's the exact meaning of those messages? My Oracle is 8.1.7.3.0. and OS is aix 5.1 Thanks in advance. Jim [EMAIL PROTECTED] 2002-12-30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim 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).
share oracle info?
Where can i find any softcopy or hardcopy books containing explanations or details of all data dictionary table? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim 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).
how many records will be keep in v$log_history?
how to modify the default vaule for v$log_history? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim 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: Oracle 9.2.0.1/2 on Mandrake 9 - solved
I've been told the same thing, but the reasoning was that they couldn't guarantee what was put out for download was actually the correct build. Not sure that's very reassuring, either. Jim -Original Message- Sent: Thursday, November 14, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Oracle Corp. finds the checksum concept to be alien. They actually posted these words to me in a tar at metalink, We don't support servers that are installed via download from otn. I guess network computing really is dead. ;) On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote: Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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: Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused
Don- Look for port conflicts between the Apache installed with 9iAS and the one with 9.2. If you're using web cache on iAS check the port that is using also. Are you using iAS Release 2 (9.0.2)? If so, and both the infrastructure and mid-tier are on the same server, they will each have their own orahome with apache. iAS Release 2 is smart enough to keep its various apaches, etc on diffferent ports but the 9.2 DB install might not be. Jim -Original Message-From: Don Malzahn [mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 8i DB, 9i DB and 9iAS on same Unix box, refusedAll,Environment:HP-UX 11iWe had Oracle 8i (8.1.7) running successfully on our one host. This host also has Oracle 9i AS already too.Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN backup and recovery on another host).Since then our one application (FAMIS from PRISM) is having problems taking connections through the web (9i AS).One person here did some research and says perhaps when 9i DB was installed (to support doing RMAN backups for a 9i DB system on another box), it overlaid the prior version of Apache. Sounds good to me. We don't have that much experience in the 9iAS, so we can't really say where the problem is. The database is up and open and I can hit it from command line sqlplus.Any ideas what went wrong and how to fix it? Should we have done a reboot of the host after the Oracle 9i install? We did not.message:===ERRORThe requested URL could not be retrievedWhile trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login The following error was encountered: · Connection Failed The system returned: (61) Connection refusedThe remote host or network may be down. Please try the request again. Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) ===Thanks. - Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED] Web page: http://www.harpercollege.edu "The only limit to our realization of tomorrow will be our doubts of today". - FDR
RE: Data Purging Strategy
A poor man's solution might be to load the offline database with appropriate data, then do a tablespace export and store the results on CD labelled by date. Restoring needed data would entail a tablespace import of stuff from the appropriate CD into the offline DB. I'm sure here's some gotchas involved but some variation on that theme might work. Jim -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Data Purging Strategy This is adata-archival requirement, not a data-purge requirement. It only resembles a purge requirement based on the multiple-database-migration strategy you outlined. There are alternatives... Depending on the volume of data in your database and your availability requirements, implementing table- and index-partitioning will likely be crucial. Onestrategy is tohave the most-active tables partitioned by a date column and have different sets of these partitions reside in time-variant tablespaces. With this arrangement, you can archive data to tape by simply setting the archived tablespaces to READ ONLY and then migratingthem to tape-based (instead of disk-based) file-systems and bringing them back online. Legato has this file-system technology (recently purchased)and there is a share-ware product called SAMFS which is an HSM (hierarchical storage mgmt) filesystem used by some vendors (i.e. StorageTek, etc). By setting tablespaces to READ ONLY it becomes very easy to move them from disk to tape while retaining them within the same original database, simplifying the task of later retrieval (which is really important). Of course, Oracle's partitioning option is enormously expensive, but in this case it is a matter of the upfront license costs (withreduced downstream implementation costs due to simplicity)versusa largedownstream application-development cost. In this situation, I think roughly offsets everything. Since I'm not spending the money, I can afford such a calculation... :-) With the various storage technologies available, a single database can straddle several simultaneously, optimizing performance or cost as needed. Somefiles might reside on solid-state NVRAM "disk", some on SAN-based disk, some on NAS-based storage, and then finally reside in archive media file-systems such as tape or magneto-optical based HSM file-systems. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 06, 2002 2:13 AM Subject: Data Purging Strategy Dear List, I need some inputs from you all regarding purging data from the database. This is the requirement We define a retention period for all the data in the system. When the retention period is reached, the data should be deleted, but then at a later time, some user might request for this purged data. So it must be possible to retrieve this data. This is the strategy we have designed for this. When the retention period is reached, move the data from the main database to an offline database. Then delete the data from the main database. In the offline database, we cannot again keep it from long, so it has to moved to tapes. Now my question, how can we move this data to tapes and at the same time retrieve data from the tapes based on dates. i.e, the user will ask for the data on a particular date, so it must be possible to retrieve data from the tapes based on a date and load it to the database tables. Regards Prem
RE: Linux
We have Oracle 8.1.7 and 9.2.0 running on Red Hat Linux 7.2 - and love it. It is not a production box though. We are still in test mode. Jim Hawkins Oracle Database Administrator St. Louis, MO Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who has infoI'm researching what it would take to convert a NT database platform (Oracle 81730) to Linux. I have not approached Metalink yet, but will soon. Does anyone have any information on Linux? Whether or not Oracle can run on it? Info on the steps involved to do so? Thanks, Christine Turner Sr. Database Administrator Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Turner, Christine 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). -- Jim Hawkins Oracle© / MS SQL*Server© Database Administration St. Louis, MO 63167 __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: ORA-01031: insufficient privileges
Wow. That is a perfectly logical and amazingly simple explanation I would never have thought of. I am in awe. Jim Chris, The answer may be in what occurs below the water. Remember that RESOURCE is a bit special (here for Oracle 5 compatibility reasons), that it is one of the two (I think) 'roles' which cannot be granted to a role and that the reason I suspect it cannot be is that it grants 'unlimited tablespace' underhand. An hypothesis might be that RESOURCE was granted and then UNLIMITED TABLESPACE revoked by a DBA unwilling to see the user pollute any tablespace. It behaves like what you witnessed : SQL create user demo identified by demo; User created. SQL grant create session to demo; Grant succeeded. SQL grant resource to demo with admin option; Grant succeeded. SQL create user demo2 identified by demo2; User created. SQL revoke unlimited tablespace from demo; Revoke succeeded. SQL connect demo/demo Connected. SQL grant resource to demo2; grant resource to demo2 * ERROR at line 1: ORA-01031: insufficient privileges -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Conboy, Jim 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: DBA work load - BDBAFH #1
The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Followup: Apache core dumps after IP address change (solution)
Bruce- Glad you worked it out. Actually, this problem can be worse than you saw. Apparently 9iAS V2 contains some sort of hardware dependency (somewhere in the JDK encryption algorithms). The net result is that you can have a full, good backup of your Apache server but if that physical hardware dies it can't be successfully restored to a new, even identical, box. The startup command for Apache needs to login to OID but somehow the encrypted OID password fails if the hardware is different. I've even heard (completely unconfirmed) rumors that certain types of hardware changes on a server can trigger the problem. Not a reassuring scenario for disaster recovery, eh? Jim -Original Message- Sent: Tuesday, September 17, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Thanks to everyone who suggested ideas for my emergency yesterday. The problem only became obvious after a complete reinstall of Oracle on my server. I took this approach after finding a thread on the ODTUG-JAVA-L mailing list that talked about how 9iAS Rel 2 has hardcoded values for the IP address. The thread indicated that there was no way of changing the IP address of a server short of a complete Oracle reinstall. After literally exhausting all other ideas of my own (and needing to get the server back up asap), I reinstalled Oracle 8.1.7 last night on a new partition. Once the default installation finished, everything worked fine. After restoring my schemas and other configurations, things still continued to work fine. Apache continued to start without core dumping and life was good. The moment I moved my old httpd.conf file back into place, Apache core dumped. Clearly, it was no longer an issue of hardcoded IP addresses, so I started taking the httpd.conf file apart into small pieces. The culprit was an upgrade RedHat Network passed along to PHP4 and glibc about a month ago. I allowed the PHP4 upgrade and glibc library upgrades to be installed. Apache continued to run using the old libphp4.so module without problem, but the moment I would have had to either reboot the server or restart Apache, it would have died because the libraries had changed. Adding PHP4, BTW, is a custom enhancement I made to the stock 8.1.7 Apache config as I need it on several parts of my server. I found the latest libphp4.so file, moved it into the /u01/.../libexec directory, restarted Apache and all was well with the world again. 17 hours of work later, I believe I have things as they should be once again. Lesson learned: if Apache core dumps (something I haven't seen it do in years) when restarting after a long period of uptime, then suspect a module/library problem. Side note: if anyone wants to know every nook and cranny where Oracle stores your IP address and domain names, I can tell you that now. :-) Thanks again! bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce A. Bergman 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: Conboy, Jim 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: Oracle Arm Twisting?
I've called Oracle for a TAR once in the past 18 months. Ah, my friend, but you're not using Portal 9.0.2, are you? I've opened more TARs in the last few months than the rest of my Oracle career. Bleeding edge, I guess, so maybe its our own fault. But third-party support for this would have stopped the project before it got started. I agree that its not accurate to generalize all tech support as nimrods. There are some very good ones out there, and even the rest at least have acccess to all the internal notes we can't get to (Gr...why the hell do they show in metalink searches if we can't see them?). And the developers, if you can ever get to them, know their stuff and are a pretty decent bunch. Jim -Original Message- Sent: Wednesday, August 14, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Well, that's not really fair. There are a number of good people that work for Oracle Support. True, there are also some that are subpar, but how often is it necessary to open a TAR anymore? MetaLink has vastly improved over the past couple of years. I've called Oracle for a TAR once in the past 18 months. Some excellent in depth posts that you may have seen on this list were put there buy Oracle support personnel. No, I'm not saying who they are. Jared Rodd Holman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/14/2002 09:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Arm Twisting? Yes, Oracle support sucks, and is staffed with morons. However one thing you get with Oracle support that you cannot get with third party support is bug fixes and product upgrades. If you want this without a support contract, you need to buy new licenses each time you upgrade. Rodd On Wed, 2002-08-14 at 11:13, Steven Lembark wrote: -- Naveen Nahata [EMAIL PROTECTED] Now they say, that this can't be done and the product license will be terminated if we want this. The thing is that Oracle support is useless(I get more help from this forum :) ), but we still want it, just in case. Ever heard of FUD? That's what Oracle is selling you if you think their support is that bad: fear of not having support that you don't want because you think it's bad. Q: Does anyone know of any reliable 3rd party support for Oracle? -- 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: 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: Conboy, Jim 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 changes
Now please, please tell me you don't REALLY talk about this geeky stuff at parties! Jim -Original Message- Sent: Monday, July 22, 2002 9:53 PM To: Multiple recipients of list ORACLE-L Wish I could. This was at a party, and the person speaking was an Oracle employee. We were talking/ranting about how often Oracle changes things and he mentioned that OEM was changing AGAIN. That's all he said Rachel --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Rachel, Could you shed any light on the changes they are proposing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: Where is Oracle 9.2 init.ora?
Dennis- With 9i you have the option of using init.ora or the spfile. DBs created with the assistant I think use spfile by default. To make the change you want, issue the ALTER SYSTEM blah blah SCOPE BOTH to make the change both immediate and permanent. SCOPE MEMORY changes it immediately but only until reboot, SCOPE SPFILE changes the initialization file but won't take effect until reboot. Jim -Original Message- Sent: Thursday, July 11, 2002 11:43 AM To: Multiple recipients of list ORACLE-L For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expecting the init.ora file? I created the database using dbca. It created an init.ora in admin/{db_name}/pfile. I moved this to $ORACLE_HOME/dbs and renamed the original init.ora file. Then I discovered that Oracle is not reading the new init.ora. The database starts fine, with no errors. I tried moving the init.ora file back to the original pfile location, but it is still not reading it. Specifically, I am trying to set LOG_ARCHIVE_START = true, but I have made other changes and they are not taking effect either. I have searched the documentation, and while there is the new SPFILE, there is no indication how this might affect my problem. Any insights from someone that has turned archiving on with 9.2 would be appreciated. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -- 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: Conboy, Jim 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: runInstaller
But how ridiculous is it that you need a really hot machine to get good performance just INSTALLING the darn thing? As an aside, the 9iAS v.2 installer does an outstanding job with the database install. Unfortunately it falls apart when you have to install all the patches, but its a definite step in the right direction. -Original Message- Sent: Tuesday, July 09, 2002 5:48 PM To: Multiple recipients of list ORACLE-L You might look at silent mode install, Note:73510.1 I have found that on really hot machines oui is a screamer. It could be your system needs a facelift. On Tue, Jul 09, 2002 at 12:47:19PM -0800, [EMAIL PROTECTED] wrote: What I wouldn't give for ./orainst /c right now. RANT Where is the productivity and ease of use of the #$%^#@ OUI when it takes hours and hours just to load up all the java crap! Piece of garbage is enough to make me want to go back to 7.3.4 - and shoot the idiot who thought up java... /RANT Thankyou. I feel better about hating 9iAS now. Scott Shafer San Antonio, TX 210-581-6217 -- 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: Conboy, Jim 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: Rollback segment shrinks
Terry, What do you have optimal set to? I believe shrink only shrinks to the optimal size. Jim Ball, Terry [EMAIL PROTECTED] wrote: Oracle 8.1.6.3 on Sun Solaris 2.6. The rollback tablespace filled up last night and the rollback segments became full. I added space to the tablespace and tried shrinking the rollback segments. They remained full, so I altered them offline and online. The extents are increasing, but I still can not get a shrink to work. If they don't stop increasing, my tablespace will fill up again and I can't keep throwing disk at it. Since this is a production system, bouncing is not an option. Any ideas? TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: export tables from sql Server to Oracle
If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to unload data to Oracle. Jim Kader Ben [EMAIL PROTECTED] wrote: Hi listers, Can someone tell me how import tables from SQLServer to Oracle. Thanks for your help, Ben __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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 Financials Sys Admin. Needed in South Carolina
As evidence of this, HomeFair.com's salary calculator says a salary of $100,000 in Manhattan is equivalent to $32,000 in Spartanburg. Doubt this is accurate to the penny, but if even close it sounds like $75K has you living like a king (or queen) in Spartanburg. Jim -Original Message- Sent: Monday, April 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Geographic region affects pay scale just as much as years of experience, I think.Especially on the extreme ends of the scale such as a small town in a rural region or say Manhattan or San Fransisco. I think it's very difficult to judge pay scales in areas where you haven't been monitoring the job market for a while. It's like comparing apples and oranges because there are too many variables. My two cents. Cherie Machler Oracle DBA Gelco Information Network Minneapolis, Minnesota Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freema cc: [EMAIL PROTECTED] Subject: RE: Oracle Financials Sys Admin. Needed in South Carolina Sent by: [EMAIL PROTECTED] om 04/29/02 12:58 PM Please respond to ORACLE-L Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. I'm wondering what frequent means...? Am I the only one that thinks the pay scale is a bit low, with this caveat? To me, the paradigm seems to be the new guys out there change jobs frequently, for better money and experience and then, a bit later on, they find a place that appreciates them for who they are, pays them what they are worth and doesn't want to let them go. Granted, the current economic downturn may have changed that picture a bit... With what they are offering in pay, I'm not sure they will find anyone with any long term experience. What does anyone else think? RF -Original Message- Sent: Monday, April 29, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Company located in Spartanburg, South Carolina with a small IT shop needs an Oracle Financials System Adminsitrator to join its IT team. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Description: The Systems Administrator will be responsible for co-ordinating support of all phases of ORACLE FINANCIALS including system administration, RDBMS tuning, application tuning, DBA/Unix back-up administration, user training, report development utilizing SQL*Plus and Reports 2.5. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502
RE: Oracle Financials Sys Admin. Needed in South Carolina
Michael- 'Taint no tax free states, sometimes they just hide it better how they get you (sales tax, property tax, personal property tax, gasoline tax, etc.) Except for maybe Alaska, as long as the oil keeps flowing. But I know what you mean. Anybody who moves based solely on these calculators needs their head examined. But they can in fact provide useful information. $75K in Spartanburg doesn't look to be below-market. Jim -Original Message- Sent: Monday, April 29, 2002 3:28 PM To: Multiple recipients of list ORACLE-L The only problem with this line of thinking is the federal government. They seem to take out the same amount for federal taxes as well as social security no matter where I live. If this is truly reflective of the cost of living there then I better automatically receive a check just for being a resident (which is actually the case in Alaska). Doubtful at best. Does anybody know if SC is a tax-free state like Texas and Tennessee? I can see using a salary calculator to convince your spouse that it is a good idea to move. Otherwise I don't they relect real life. Just my 2 cents. -Original Message- Sent: Monday, April 29, 2002 2:48 PM To: Multiple recipients of list ORACLE-L As evidence of this, HomeFair.com's salary calculator says a salary of $100,000 in Manhattan is equivalent to $32,000 in Spartanburg. Doubt this is accurate to the penny, but if even close it sounds like $75K has you living like a king (or queen) in Spartanburg. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: How come I don't get postings
And new ones joining every day! Wow! Jim bill thater [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: oh oh, lisa has a fan club :-) with lots of members.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. On a clear disk you can seek forever. -Computerworld button -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Dbms_job not running
Are there any jobs running? There's a couple of init.ora parameters that must be set first. Jim -Original Message- Sent: Friday, April 19, 2002 2:04 PM To: Multiple recipients of list ORACLE-L If the parameters suggested are already set up right , I have one more thing to ask... 1. is this something do with the DB Link ??? 2. if so , the user running the job is having any private DBLINK ??? --Madhu PS: If the DB LINK is used to run this job , you need to have a private dblink created for the user running the job. -Original Message- Sent: Friday, April 19, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Hi, We have a job own by user MTSSYS which we scheduled to run every 1 minute but it is not running itself. If we run the job manully from sqlplus it runs fine. What can be the reason that job is not running itself??? Interval is set to SYSDATE+1/1440 Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Reddy, Madhusudana 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: Conboy, Jim 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).
World's largest database...
http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: initjvm and rmjvm failing
Note 159801.1 (Full JVM Removal on 8.1.7) on Metalink may help. Haven't tried it myself but I fear I'm about to. Jim -Original Message- Sent: Wednesday, April 17, 2002 12:08 AM To: Multiple recipients of list ORACLE-L Hi All I am trying to add Java support to one of the databases and it keeps failing. It seems that after the first run it didn't get it right and rmjvm doesn't seem to run properly after. there still appears to be a large bunch of objects in the database. Any ideas as to how to clean it up I can rebuild it if i need to, this is more of a learning task, I normally create them with Java in the first place. Any ideas 8.1.7 on Solaris 8 Thanks -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: World's largest database...
I can believe that - I think they are the group that offers all the geneaology services to track family histories. I'll bet that's one heck of database too! Jim Boivin, Patrice J [EMAIL PROTECTED] wrote: At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: World's largest database... http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA -- 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: RE: World's largest database...
Ian, Thanks for the info. Very interesting. Jim MacGregor, Ian A. [EMAIL PROTECTED] wrote: The 0.5 petabyte database at SLAC does not use Oracle; it uses Objectivity. Objectivity is a small company which makes an OODB. When the project started there was no way that Oracle could possibly handle this. It is still doubtful: Oracle does not truly support Hierarchical Storage Systems; using one huge RAC ties limits your machine vendors; some limits such as 64,000 partitions probably need to be increased. CERN is however very interested in using Oracle for their Large Hadronic Collider, but that's about seven years off. That database will surpass BABAR's which as of 00:01:13 this morning (April 18 2002) was storing 549.6 TB has been stored in 324603 files. CERN's possible use of Oracle is not due to failures in Objectivity, but due to that company's inability to capture market share. They are hoping the problems which prevent Oracle from handling large databases can be fixed by then. I am also hoping for this, but I fear Oracle may prove to be an uncooperative prohibitedly expensive partner. Here we have plans to turn up the luminosity. If approved the database will reach one exabyte by the end of the experiment. I don't believe the genealogy databases are even close to 500 TB. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:29 AM To: Multiple recipients of list ORACLE-L I can believe that - I think they are the group that offers all the geneaology services to track family histories. I'll bet that's one heck of database too! Jim Boivin, Patrice J [EMAIL PROTECTED] wrote: At the Oracle Technology Day here they mentioned that one of the largest databases belongs to the Church Of Latter Day Saints, if you can believe it. They mentioned it in a seminar which also talked about iFS, I don't know they were implying that it relies on iFS. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 18, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Subject: World's largest database... http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA -- 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: MacGregor, Ian A. 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
Symbolic links for datafiles...
Anybody know the answer to this question? This is on HP-UX. I am managing a database that has symbolic links for data files. On this instance, I am using STATSPACK to track performance. I need to tie IO rates back to real mount points so that I can work on balancing IO. How do I tie the names in DBA_DATA_FILES to actual mount points? I need this very quickly. Thanks in advance, Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Deleting old archive log files.
You can recover just one or a set of datafiles with RMAN. I've had to do that for a recovery before. It will recover just the datafiles you need plus the necessary archive logs. Jim Koivu, Lisa [EMAIL PROTECTED] wrote: No, not from what I saw. I may be wrong, though. Lisa -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting old archive log files. the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL datafiles from tape? Wouldn't this unnecessarily increase the mean time to recovery if you just need to recover one datafile? Orrman for RMAN, Steve Orr Bozeman, MT -Original Message- Sent: Thursday, April 04, 2002 7:19 AM To: Multiple recipients of list ORACLE-L If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Koivu, Lisa 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services
32-bit vs. 64-bit on HP-UX 11.0
We currently have PeopleSoft running on HP-UX 11.0 64-bit OS and Oracle 8.1.6 32-bit. We want to upgrade to Oracle 8.1.7.3 on the same OS, but the question is, do we go with 32-bit or 64-bit Oracle? Any feedback or information would be much appreciated. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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).
Big news regarding Oracle licensing...
Please read the following article and try not to choke... http://investor.cnet.com/investor/news/newsitem/0-9900-1028-9407413-0.html?tag=ltnc Pricing change irks Oracle customers By: Alorie Gilbert 3/19/02 5:25 PM Source: News.com A pricing disagreement between Oracle and some of its database software customers has IT analyst firm Meta Group urging customers not to pay the database software maker additional licensing fees. The dispute relates to how Oracle charges its customers when they transfer large amounts of data, known as batch feeds, to the Oracle database. These batch feeds are commonly used by companies to set up data warehouses. Meta said customers believed that all employees involved in sending the batch feeds were covered by a single license, but Oracle said policy changes in recent years mean that each individual needed his or her own license. I have reviewed hundreds of Oracle contracts in the last two-plus years. None of them have contained provisions of that sort, Meta Group analyst Mark Shainman said. Oracle acknowledged that they are talking to some customers about these licensing fees, but they said there isn't anything to dispute. The company says some customers are simply confused about a series of database software pricing changes that were announced in 2000 and 2001. These customers are now out of compliance, and the company was working with them to fix that, said Jacqueline Woods, VP of pricing at Oracle. But Meta says customers see it as more than just being confused about changing pricing policies; the firm said several of their clients are now looking into moving their data warehouses off of Oracle databases because of the situation. Meta Group sees Oracle's attempt to redefine named users in a batch multiplex environment as questionable both on legal and ethical grounds, the company said in a statement. Oracle has failed to provide convincing evidence that it has ever negotiated batch feeds as a form of multiplexing with end users. Meta has a stake in the matter--analyst Charlie Garry said they had been advising clients that the batch feeds were covered by a single license. On Tuesday, it urged its clients to not pay the fees, and even to fight it out in court. Meta Group urges that Oracle users who are told they are out of compliance with existing contracts based on Oracle's interpretation of named user refuse to pay extra license fees and resist Oracle attempts to collect them, in court if necessary, the company said. Oracle's reinterpretation of existing contracts is of questionable legality at best and may not stand up in court. Oracle has tweaked pricing of both its database and business applications software in the face of increasing competition from IBM and Microsoft in the database market and SAP and PeopleSoft in the applications market. And though technology spending is down across the board, Oracle's earnings for the last several quarters continue to fall short of Wall Street expectations while competitors have rebounded, indicating that the company may be losing market share. Garry said Oracle has asked some companies, already paying millions of dollars for the software, to pay millions more. Oracle is telling customers they can either get the additional licenses or switch to a more expensive type of licensing that charges per server processor, he said. Competitors such as Microsoft and IBM offer per processor pricing for their database products. Woods said that Oracle customers that licensed the software prior to December 1999 and paid a single license per batch feed may continue under that model. Customers licensed after that date need to comply with the current pricing rules, which would likely mean switching to per processor pricing and an overall higher cost. Oracle has 20,000 database customers in the United States. We're not using this as some kind of revenue opportunity, said Woods. We've got a whole lot of other stuff to sell than a batch feed. We have a lot more to offer, and this is a blip in the radar screen. -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
RE: Calling SQL statement
There was just the ticket in an Oracle mag online piece by Ian Craig a while back. http://www.oracle.com/oramag/webcolumns/2001/index.html?op_unixway.html A trivial example from the article: print select * from dual; | sqlplus -s scott/tiger produces the following output: D - X Jim -Original Message- Sent: Thursday, March 14, 2002 8:33 AM To: Multiple recipients of list ORACLE-L !/bin/ksh sqlplus / EOF select sysdate from dual; EOF exit [EMAIL PROTECTED] 03/14/02 06:26AM Hi all, How do I issue SQL staments to the Oracle server from shell scripts -preferably korn shell. Example scripts highly welcome. Thanx 'n Ciao +---+ CSW, MTN-Uganda, 8th Floor UDB Building Cell: 077-212655,http://mtn.co.ug +---+ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale 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: Gene Sais 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: Conboy, Jim 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: Re: NYOUG
Rachel, SLOUG would definitely pay your travel expenses, and since our meetings run from 1PM to 5PM, it could really amount to just a day trip for you if you want. You could fly in that morning, have some lunch, deliver your topic, then take off (unless you wanted to see the city of St. Louis or something). We meet every other month, and the next meeting is in April (the third Thursday). I realize this could be too soon, so maybe the June or August meeting. Or, I totally understand if you've decided to give up the speaking gig altogether, so don't feel bad saying NO! And also, thanks for the other information about finding speakers. Jim P.S. Our website is www.sloug.org in case you are interested. Rachel Carmichael [EMAIL PROTECTED] wrote: Jim, I might be interested in speaking, depends on dates and if the user group pays expenses :) I am supposedly cutting back on doing presentations. Meanwhile, NYOUG doesn't pay expenses, but unlike most other user groups I've been to, we have a significant number of speakers. Most others have 2-3 speakers for the day and we have 11 speakers each meeting. We are changing this for our September meeting and going forward, we will continue to have a keynote but will have 4 presentation time slots rather than 5, giving speakers a few more minutes for questions, and to allow the next speaker to set up while the prior speaker is still answering questions. As to how I get speakers... we post a call for papers on our website and I've gotten some excellent speakers that way. I go to conferences and buttonhole people there who are good speakers. NYOUG has an excellent member base and they on occasion ask to present. I beg and plead and grovel before my friends as well :) The other members of the board also beat up (er, persuade) people they meet to get in touch with me for possible presentations. Rachel --- Jim Hawkins [EMAIL PROTECTED] wrote: Rachel, On a related note, I am now on the St. Louis OUG board, and have the same responsibilities of arranging speakers. May I ask what your methodology is for this, as well as if you would be interested in speaking? :) Jim Rachel Carmichael [EMAIL PROTECTED] wrote: well, I'll be there, I sorta kinda have to, since I organize the speakers and chair the DBA SIG it will be a very good meeting.. all authors, Kevin Loney, Rich Niemiec, John Beresniewicz, Douglas Scherer, Gaja Krishna Vaidyanatha, Ulka Rodgers, Paul Dorsey (I don't think I've left anyone out, this is from memory!) check the website... www.nyoug.org --- Sakthi , Raj [EMAIL PROTECTED] wrote: Listers, Talking about IOUG, I was wondering who are all attending NYOUG (damagement won't spansor me to attend IOUG ;( ) Cheers, RS __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET
RE: RE: Fav. Urban Legend...
This may have already been stated, but how about: Making your SGA size bigger will always yield performance gains. There is a Law of Diminishing Returns at work when all the latches, free lists, etc. are taken into account for managing such a large SGA... Jim Orr, Steve [EMAIL PROTECTED] wrote: Bigger is better. This is the best biggest myth. Say that fast 3 times. :-) -Original Message- Sent: Wednesday, March 13, 2002 5:18 AM To: Multiple recipients of list ORACLE-L That as Oracle software becomes larger, fewer DBAs are required. 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] -Original Message- Sent: Wednesday, March 13, 2002 12:28 AM To: Multiple recipients of list ORACLE-L Subject:Re: Fav. Urban Legend... oh man, mine has to be what is probably Jeremiah's as well: the myth that Oracle doesn't write to the database files when you are in hot backup mode --- Freeman, Robert [EMAIL PROTECTED] wrote: I'm putting the final touches on my IOUG-A presentation (I got an extension for those who realize that I'm late on it!)... I'm doing Oracle Urban Legends. I've got several in my presentation but I thought I'd ask here, before I put the presentation to bed, what your favorite (or the one you find the most irritating) Oracle Urban legend was RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Orr, Steve 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com
RE: RE: Do you use RMAN?
But if using a backup catalog, doesn't the catalog have to be the same exact version of the database being backed up? That is, RMAN 9i may be used to do the backups as long as it writes to an appropriately versioned catalog. Is my thinking correct? Jim Freeman, Robert [EMAIL PROTECTED] wrote: Rman is backwards compatible, but to be honest I have not tried the new features on 8i databases, so I can't tell you for sure that they work in that way. My guess is that they probably do, but don't hold me to that. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Wednesday, March 13, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Rob, Can one use 9i RMAN to backup lower version databases (8.0.x, 8.1.x)? What new functionality will be supported in doing so? We do not use RMAN at the moment, but we may consider it in the near future. Thanks. - Kirti -Original Message- Sent: Tuesday, March 12, 2002 3:28 PM To: Multiple recipients of list ORACLE-L New Rman features in 9i make it even nicer... Recover specific blocks, while the database and the datafile is still available. Automatic channel allocation. retention policies. restartable backups and restores. backing up database and archivelog files in one operation run command isn't needed in most places anymore... Also Rman is FREE, unlike some of the other backup/recovery tools out there... :-) I do know that one major software supplier of backup and recovery tools is reworking their product so that it's just a front end to Rman RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- 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: Freeman, Robert 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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 Hungry for Money
For some reason there has been a great confusion... I believe that's exactly the point. Oracle installed this extra-cost option by default, for no other defensible reason then to encourage its unwitting use. There's a reason there has been confusion. They're like a drug pusher, first one's easy but once you're hooked you PAY. And unless you know where to look its not so easy to find info on Metalink for what are the options for each DB version. I don't know what the original meaning was behind 'feeling tricked', but I guarantee you there are some on this list who've just realized they've been tricked into using an expensive add-on product they may not be able to back out of at this point. Jim -Original Message- Sent: Wednesday, March 13, 2002 3:29 PM To: Multiple recipients of list ORACLE-L While I agree Oracle is avaricious and sales reps are a smarmy lot, I don't see any entrapment here. If you believe you are licensed for an option and you are not, it is perfectly legitimate for Oracle to ask for you to pay for that license and any maintenance costs. $23,800 is cheap, must be a 20 named user license. They are not asking for payment for all the years it had been illegally installed? Consider yourself very lucky and Oracle anything but greedy. Feeling tricked implies that had you known that you were not licensed, you would not have divulged it to Oracle. If so, you are lower than a smoldering heap of parrot droppings. However, as it was indeed an innocent mistake and no such characterization is necessary. For some reason there has been a great confusion over whether the partitioning option costs extra. Even some of the most knowledgeable DBA's in the world were mistaken on this. The height of this misunderstanding was a two to three years ago. I expect there were hundreds perhaps thousands of sites who have installed partitioning without a license because they believed it to be free. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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: NYOUG
Rachel, On a related note, I am now on the St. Louis OUG board, and have the same responsibilities of arranging speakers. May I ask what your methodology is for this, as well as if you would be interested in speaking? :) Jim Rachel Carmichael [EMAIL PROTECTED] wrote: well, I'll be there, I sorta kinda have to, since I organize the speakers and chair the DBA SIG it will be a very good meeting.. all authors, Kevin Loney, Rich Niemiec, John Beresniewicz, Douglas Scherer, Gaja Krishna Vaidyanatha, Ulka Rodgers, Paul Dorsey (I don't think I've left anyone out, this is from memory!) check the website... www.nyoug.org --- Sakthi , Raj [EMAIL PROTECTED] wrote: Listers, Talking about IOUG, I was wondering who are all attending NYOUG (damagement won't spansor me to attend IOUG ;( ) Cheers, RS __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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-Genesis of a DBA Universe
Genesis of a DBA Universe In the beginning was the disk array, and all was empty and raw, and UNIX moved over the face of the platters. And the DBA said: Let there be Oracle. And there was Oracle. And the environmental variables were set and the disks were striped and mirrored and the OFA was established, and behold spindle was rent asunder from spindle. And the DBA saw that all was in spec. And it was day and it was evening of the first day. And the DBA said: Let there be scripts. And sql.bsq brought forth myriad crawling things upon the face of the array. And catalog.sql brought forth all manner of tables and views that swim unseen beneath the waters. And catproc.sql brought forth all the built-in programs and all the hosts of the air, that the users might be given wings and take fight over the data. And it was day and it was evening of the second day. And the DBA said: Let there be tablepaces. And there were tablespaces. And the network administrator looked upon the disk array and did see what the tablespaces had wrought upon the disk arrays, and he did gnash his teeth and seek a new work upon the Internet with an engine of search. And it was day and it was evening of the third day. And the DBA created users. Male and female he created them. And he said unto the users: Thou mayest create tables and views as thou wilt. Yea, though mayest create even indexes upon the data. Only meddle not with the system tablespace, for it is a holy place, and on the day wherein thou treadest upon it, on that day thy create session shall surely be revoked. And the serpent crept among the users and whispered to them, saying: Thine roles shall not be revoked. Taste ye all of the system tablespace, for ye shall know of b-trees and hints and ye shall be as DBAs. And the users heeded the serpent and filled the system tablespace with crap. And the instance did crash and the client did wax wroth at the DBA. And the DBA did gnash his teeth and partake of the fruit of the vine, for behold the users were permanent employees and the DBA was but a contractor and could not revoke their create session. And it was day and it was evening of the fourth day. And the DBA did set default tablespaces and temporary tablespaces and did lock down all that was upon the face of the array with roles and profiles and all manner of quotas, yea even from the rollback segments even unto the archived redo logs. And it was day and it was evening of the fifth day. And the DBA created synonyms and links and did tune the server and apply patches upon the face of the database. And it was day and it was evening of the sixth day. And on the seventh day the DBA did rest from all the labors of the creation. And his pager did ring and he ceased from resting and did spend his sabbath on the telephone with Oracle support. And by the time the DBA got through to someone who knew wherof they spake behold it was day and it was evening of the eighth day. And the DBA waxed wroth. Jim Hawkins Oracle DBA St. Louis, MO -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: 8i and Veritas NetBackup
Rick, This is what our corporation uses as a standard. We are not having any of the problems you describe, however, we are on HP, AIX, Tru64, and NT, not Solaris. Jim [EMAIL PROTECTED] wrote: Is anyone using this combination? We're having problems getting backups to work with 8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control panel says the backup has started, but it doesn't finish and usually has a dead rman process on the db. We've working with Veritas support, but it's been 2 weeks and no answer. The dbs are 8.1.7.3 on Solaris 7 and we did patch the oracle executables. Thank you for any help. -- 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Fw: Just got back from SQL*Server 2000 training...
Jared, I was going to respond, but you did a great job for me. Your points were my points exactly. I really tried to go to the SQL*Server class with an open mind thinking I'm adding a skill set, but I found myself constantly comparing to Oracle. I didn't mean to start the Holy War again, but thought it would make an interesting conversation. A bit more: Having databases in noarchivelog mode, especially during batch loads for data warehouses/datamarts is extremely important for a large database shop like ours. In terms of RAID, I was just pointing out that while we mirror our redo logs to at least two different groups with two different members, I was shocked that the transaction log in SQL*Server was in no way mirrored by SQL*Server. It was either do it at the hardware/OS level or risk it. Not a Mission Critical mentality. As for transferring 10GB over the network, this would be just backing up our archive logs, not to mention the datafiles themselves. We do it every day around the clock using our tape silo. We use RMAN with hotbackups directly to tape via Veritas NetBackup enterprise wide. 10GB is trivial in the Oracle world, however, judging by the response I got, not so trivial in the SQL*Server world. One last thing: Having been to the Oracle education classes, I was expecting to learn in depth how SQL*Server uses memory to buffer the database, shared SQL, etc. thinking this would be a major tuning strategy for SQL*Server. Based on the nature of your system, you could gear the equivalent of an SGA accordingly. I almost spit up my two cups of coffee when the instructor showed me the GUI slide-bar that controls memory allocation to SQL*Server. If you need more, just slide the bar to the right... I still chuckle... Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] wrote: Couldn't resist responding to this. *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. Why would you want to? So you have the remote possibility of ending up with a corrupt, unrecoverable database if the power supply on the system fails? JS: Taking a database out of archive mode is certainly valid for large load operations. Let's see, I want to load 50 gig of raw data into my data warehouse tonight, that will generate about 800 gig of redo. Do I really want to do generate that much redo, deal with the overhead, and back it up besides? Or would it be easier to put the DW back in archive mode and back up the new data? *Txn logs not mirrored. Must rely on RAID or other mirroring software. Hardware RAID/mirrors are much better than software, so if you are comparing Oracle software based mirrors to the hardware based ones we use then our way is much faster JS: No mention of reliability there though is there? If I don't have control over the hardware layout, I want Oracle to mirror the logs, period. Backups directly to tape require the tape to be attached locally to SQL Server. Okay, if you really want to transfer your 10+GB database over the network each night, I suppose you will need to use Oracle. JS: 10+GB over the network is trivial. If you are using anything that approaches enterprise level backups, you will dedicate some fast pipes to your network attached tape system. This means that if you're using for instance Tivoli with a StorageTek Tape Silo,you must copy it first to disk, since you're not going to have direct access. Making backups to disk first tends to break any Oracle specific tape cataloging system ( RMAN for instance ) so that files must be located manually in case of a restore. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. Seems a little like disk space filling up in Oracle. How is this different? JS: This is a poor analogy. It isn't like disk space filling up in Oracle. The only disk likely to fill up is the archive log destination, and if you're doing your job as a DBA, that won't happen. I've been to DBA class for Sybase, which has the identical mechanism for transaction logging. It's crude and vulnerable. *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Valid point here. But I'd rather not trust my backup to a compression scheme anyways. Then you must not be backing up to tape, as all tape drive systems use built in compression. The I don't trust compression complaint is a red herring. Jared -- 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
RE: Rollback Segments
Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim 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).
Just got back from SQL*Server 2000 training...
During the class, I kept a list of all the I can't believe this is really the case with SQL*Server... items, and thought you might all like to see it. These are just notes I took on a Palm Pilot, so forgive me if they are a litte undetailed. I walked away from the class thinking, this is just MS Access with bells and whistles. I'm not saying it doesn't have its place in the database market, but I just don't see how it competes with Oracle and DB2. If you even want to think about scaling, you have to implement Windows clustering, which is one of the hidden costs I see that Microsoft doesn't come right out and say. *Row size cannot span multiple 8k pages, therefore max row size = 8k *Cannot take DB out of archivelog mode. Can limit what is posted to txn log, but cannot stop it. *Txn logs not mirrored. Must rely on RAID or other mirroring software. *Separate permissions for RI checking. Requires two permission grants if foreign key exists - one for child table and one for parent table. Called REFERENCES permission. *Recommended that ALL production objects owned by DBO - not conducive to multi-schema instances. *Activities that are restricted during backups: 1. Creating or modifying databases. 2. Performing autogrow operations. 3. Creating indexes. 4. Performing nonlogged operations. 5. Shrinking a database. *Backups directly to tape require the tape to be attached locally to SQL Server. *When txn log fills up, have to just truncate the log in order for processing to continue. Leaves system vulnerable until you get a full DB backup. *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Jim Oracle Database Administrator -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Oracle Advanced Replication
Pete, While SharePlex does quite nicely in replicating DML, it is all the other stuff that it doesn't replicate that ruled it out for us - adding datafiles, creating tablespaces, etc. If its not captured in the redo logs, SharePlex won't replicate it. Basically, keeping your standby and primary in sync meta-data wise is not possible with SharePlex. Just something to consider. If you have a very active environment, this becomes a nightmare. Jim Oracle Database Administrator Nick Wagner [EMAIL PROTECTED] wrote: Not yet, support for those objects are scheduled for this winter. Nick -Original Message- Sent: Friday, February 15, 2002 12:58 PM To: Multiple recipients of list ORACLE-L Nick, Does SharePlex support user defined object types? Richard -Original Message- Sent: Friday, February 15, 2002 2:09 PM To: Multiple recipients of list ORACLE-L All this talk of replication is really nice. SharePlex for Oracle, can handle master to master replication. Conflicts are handled via pl/sql procedures inside the database, where you can determine exactly what happens when there is a conflict. SharePlex performs really well whether it is a batch program doing massive DML operations, or many small OLTP type transactions. SharePlex can handle around 300-500 DML operations per second in most situations... more if the hardware and database are tuned properly. As for failover, it works VERY well, and can handle many of the datatypes that trigger based replication can not support. LONGs and LONG RAWs especially... One other thing SharePlex can replicate are sequences. If you have sequences that generate PK's or unique keys, then you should probably replicate them, otherwise after a failure, you will have to find out what the highest value for those sequences are for each of your tables, and then rebuild all the sequences. This can take a long time, even on a medium sized database. Just a couple of things to think over, when selecting a replication product. Nick -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L 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 http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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 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
RE: The use of schemas
Check your consultant's credentials. From what you've indicated, there is absolutely no reason to do this. Tell him he will get to do all the management of synonyms, permissions, and schema exports. I suppose he also wants separate tablespaces for each of these schemas as well? Jim Hawkins Oracle Database Administrator oracle dba [EMAIL PROTECTED] wrote: Hi all, Our consultant has presented a schema design which I have never seen (not that I have seen all the designs in the world) but I also failed to see the advantage. Basically our application consists of 35 tables and all is under one schema named after the application. Granted, the application has many components such as billing tables, event tables etc. Now the consultant wants to split all 35 tables into as many as 8 different schemas! Such as a billing schema, a event schema. To me this only complicates the whole thing as now you have to manage 8 schemas and manage many grants, synonyms. Not to mention some tables are not clear cut as which component it belongs to. I just don't see what this buys us. Has anyone seen such a approach? And what's the benefit of doing so? Thanks _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: SCOTT/TIGER
I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Conboy, Jim 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: HP vs SUN for a UNIX box
These threads always crack me up. Its like religious wars. We've got both in house. Most of my stuff runs on the SUN boxes, and I have had no problems with the stability. I guess administration of the HPs is easier, but the Sun SAs aren't complaining so its pretty much a non-issue for us. As far as cost, HP wasn't competitive, Sun was much cheaper. Due to the cost difference we probably wouldn't be buying any more HPs, except when a certain product is only certified on HP or when the purchase decision is made by an HP-centric manager. Jim -Original Message- Sent: Monday, January 21, 2002 10:00 AM To: Multiple recipients of list ORACLE-L I heard that they already did. Something about Sun not being stable. -Original Message- Sent: Sunday, January 20, 2002 9:55 PM To: Multiple recipients of list ORACLE-L Oracle Magazine have alot Oracle for HP articles, I think they are switching from Sun to HP -Original Message- [EMAIL PROTECTED] Sent: 19 January 2002 06:16 To: Multiple recipients of list ORACLE-L Sergey, I asked my SA to add his 2 cents, guess he's not inclined. Anyway, I've been on HP for the last 10 years, coming from VMS, I love it. VERY stable, easy to use, although I don't do the admin any longer it was easy with SAM even when it was a character based tool. Rman/OmniBack integration is well documented in the OmniBack manuals works as advertised. HP support is pretty darn good as well, especially in the middle of the night when the system won't boot. I've had HP support tech's remotely logged in to the system helping get it back online. Also if you have a problem that is not in the area of the tech you call they normally conference in the needed assistance. Problems can be resolved as fast as they occur. We also don't use disk arrays from HP, but then HP EMC really like each other. If you want an inexpensive disk alternative look into NetAppliance. Dick Goulet Senior Oracle DBA Reply Separator Author: Babich ; Sergey [EMAIL PROTECTED] Date: 1/18/2002 1:25 PM Thank you, Paul, I'll forward it to my boss... Anyone else to add to it? Thank you very much, Sergey Babich -Original Message- Sent: Friday, January 18, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Stay with HP. It's a hell of a lot more reliable, and does not require anywhere near the # of patches, and its patches work far more often that Sun's. I've done 5 years with each, and there's no question that HP is superior. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, January 18, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Our shop is switching from HP to Sun. No one can tell me why. There must be a cost savings somewhere. -Original Message- Sent: Friday, January 18, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Re: Which Character set?
We use WE8ISO8859P1 as a corporate standard for all databases globally with no problem. Haven't tried UTF8 yet though. Jim Ron Thomas [EMAIL PROTECTED] wrote: Unless you have the need to support other languages other than English or need to support characters like the Euro, don't bother. You would not believe the pains we are having here trying to get UTF8 working correctly... WE8ISO8859P1 or P15 might be a choice for you. See what other listers have to say. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Hit any PHB to continue... [EMAIL PROTECTED] om To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Which Character set? com 01/16/02 08:56 AM Please respond to ORACLE-L I have always used US7ASCII character set. I am creating a new server and database for an existing production application and I was wondering if I should be using one of the newer character sets. Is there a newer character set that would still work with the old application data? 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: Ron Thomas 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). -- __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Using procedures instead of coding update/insert
I would also add that since stored procedures are stored in the database, they are backed up in the database as well. This has saved me a few times... Jim [EMAIL PROTECTED] wrote: So what is the basis for the case by case judgement. I'm not being flip - I really want to know. From the discussion so far it appears that the pros for PL/SQL procedures are: Uniform access method to the database for all applications Processing done on the more robust server machine Less impact on the SGA Ease of maintenance Loosely couples the application to the database in that database changes only impact the procedures, not the code The pros for prepared statements is that you can do array binds (which give better performance). Anything else? I'll be the first to admit that PL/SQL development is my short suit. Gogala, Mladen To: Multiple recipients of list ORACLE-L MGogala [EMAIL PROTECTED] @oxhp.com cc: Sent by: rootSubject: RE: Using procedures instead of coding update/insert 01/15/2002 11:40 AM Please respond to ORACLE-L The reason for that is the fact that with prepared statements you can do array binds while that isn't possible with the stored procedures. I don't like this kind of comparisons. I judge on case by case basis. -Original Message- Sent: Tuesday, January 15, 2002 10:55 AM To: Multiple recipients of list ORACLE-L We have done some preliminary testing and found prepared statements about 20% faster than stored procedures. We inserted 200,000 records at a time (28-50 columns in a table ) using stored procedures and then used prepared statements for the same dataset. Both of them were called from java using JDBC thin drivers and interestingly found prepared statements faster. Similarly, deletes were also about 15%-20% faster using prepared statements. For some reasons, updates to the same tables gave almost identical performance. Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rakesh Gupta 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: Gogala, Mladen 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
Re: Grumble, grumble
You darn skippy, Bambi. We never got specific error messages, either. Just got something like 'patch failed' with no reference to where or why. The world's gone soft since the days when 'computer people' all wore white smocks and carried boxes of punch cards around. Jim [EMAIL PROTECTED] 11/02/01 12:00PM Anyone ever see *this* ? They sure don't apply patches the way they used to. Why, when *I* was a child, we applied patches with spit and mud and hay, and they didn't complain about no '=' character neither, by gum... Bambi. oradev /u05/dfinappl/ad/11.5.0/bin/adpatch c1880630.drv Copyright (c) 1998 Oracle Corporation Redwood Shores, California, USA Oracle Applications AutoPatch Version 11.5.0 NOTE: You may not use this utility for custom development unless you have written permission from Oracle Corporation. Invalid argument (no '=' character): c1880630.drv -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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: SAP and Oracle
Kimberly- When we went to SAP about 5 years ago our SAP license came with limited use Oracle licenses. This covered all the users of SAP, although in truth only the SAP superuser actually connected directly to Oracle. The license did not allow creation of additional schemas in the Oracle instance. You can create additional objects in the SAP schema, but I think technically you must do so using SAP-supplied tools. And of course you can't transfer them to a differentapplication. Sometime over the last two yearsI've heard that this arrangement had changed, and that we had to get our usage licenses directly from Oracle. But since we had a corporate agreement with Oracle which covered these users anyway I never pursued that issue and can't vouch for it. Jim [EMAIL PROTECTED] 10/26/01 05:55PM When you say for SAP only do you mean all the people who connect to SAP will be covered? -Original Message- Sent: Friday, October 26, 2001 2:11 PM To: Multiple recipients of list ORACLE-L Your SAP license comes with a 'limited-use' Oracle license, which means you can use it for SAP only. Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 ext. 3246 -Original Message- Smith Sent: Friday, October 26, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Does anyone know if we need to buy our licenses separate for Oracle when using SAP? Sometimes, when a vendor product runs on top of a database they supply that but I do not think SAP is one. Thanks a head of time. Kimberly Smith GMD Fujitsu Database Administrator (503) 669-6050 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson 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).
Re: Java in the database
Jan- I've heard some concerns about the scalability of Tomcat as an app server. Of course, some of those concerns are voiced by guys like Oracle and BEA who have a nice little Java engine to sell you for $10-20K per CPU. I know a lot of people use Tomcat for prototypes and such, then go with one of the big boys for the production system. Have you - or anyone else - hadTomcat working in a production environment with, say, 100-200 concurrent users? Thanks. Jim [EMAIL PROTECTED] 10/26/01 08:35AM PL/SQL. Java code only on Tomcat-Jakarta (Apache). JP On Thu 25. October 2001 19:16, you wrote: Out of curiosity, is anyone using the java engine for procedural code, or are most people still using PL/SQL? 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: Jan Pruner 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: Java in the database
Jan- Please do let us know how you do with 500 users. "Oracle App Server = Apache + Tomcat" Is this true? Iknow that "Oracle HTTP Server" (ha ha) is basically Apache. And I know that the Oracle Jserver was basically the Jserv precursor to Tomcat. But I thought 8.1.7 and 9i came with a new servlet. I looked on Metalink and couldn't tell, is that 'new' java servlet really Tomcat? Jim [EMAIL PROTECTED] 10/26/01 10:50AM :-) Wait 2 weeks and I will tell you how is it running up to 500 people. "Oracle and BEA who have a nice little Java engine to sell you " It has only other product name, but inside is it the same Oracle App Server = Apache + Tomcat JP
RE: Java in the database
Christopher- Do you have first-hand experience with the performance of Orion, either within iAS or as a stand-alone servlet engine? The '5x faster' seems to come from an Oracle source, which I suspect is referring to Java stored and executed within Oracle. I'm not sure whether Orion as a stand-alone product can make the same claim. Then again I'm a DBA, not an experienced Java developer, and am finding ita bit confusingto wade thru the alphabet soup. I have a 3rd-party app to install that needs 'any J2EE-compliant' java servlet engine. I'm looking for something that will provide good scalability at a good price. The price is right, if Orion scales well then maybe I won't need iAS for this server since I don't need all the other goodies that comes along with it. If you have any real-world indications of scalability I'd appreciate hearing from you. Thanks. Jim [EMAIL PROTECTED] 10/26/01 02:51PM Take a look at OrionServer (www.orionserver.com) at $1,500 / server and 5x faster than Web Logic, I would wonder why people would use others. And OAS9i uses Orion as the core now. "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-----From: Jim Conboy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Java in the database Jan- I've heard some concerns about the scalability of Tomcat as an app server. Of course, some of those concerns are voiced by guys like Oracle and BEA who have a nice little Java engine to sell you for $10-20K per CPU. I know a lot of people use Tomcat for prototypes and such, then go with one of the big boys for the production system. Have you - or anyone else - hadTomcat working in a production environment with, say, 100-200 concurrent users? Thanks. Jim [EMAIL PROTECTED] 10/26/01 08:35AM PL/SQL. Java code only on Tomcat-Jakarta (Apache). JP On Thu 25. October 2001 19:16, you wrote: Out of curiosity, is anyone using the java engine for procedural code, or are most people still using PL/SQL? 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: Jan Pruner 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: providing 24*7 database ---
Seemed fine when I tried it (and thanks for the idea!). The trick with the indexes is that the ones on the partitioned table have to be local, which was in the scripts provided, and the 'exchange partition' had to say 'including indexes', which was not. Adding 'including indexes' made this work like a charm for me. Jim [EMAIL PROTECTED] 10/24/01 11:25AM I couldn't verifythat the non-partitioned indexes become unusable after exchanging the partition for the normal table. In the sample I posted Isnipped the output of the queries on USER_INDEXES and USER_PART_INDEXES, but my tests showed that they remain valid. I'm curious to seewhy your results are different. Can you post the spooled output of your test? Thanks. Tony Aponte -Original Message-From: Narender Akula [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 23, 2001 10:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: providing 24*7 database --- Thanks all for the input. hi tony , Quick question ... when you exchange partititons with non partitioned table data , all indexes on non partitioned tables become unusable status right. do have to rebuild them afterevery exchnage... naren -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 23 October 2001 05:06To: Multiple recipients of list ORACLE-LSubject: RE: providing 24*7 database --- We use a modified version of your duplicate schema idea. But we don't have the objects in different schemas. We use partitioned objects so that we can exchange the partitions with the production tables at a scheduled time. The voodoo is that we use a single range partition of MAXVALUE and all indexes are LOCAL PARTITIONED. The partitioning key doesn't really matter in this setup since we aren't using the features for its advantages, just to be able to swap data and index segments on the fly. I've attached a transcript showing the actual sequence but I'll give you a short explanation first: There are production tables/indexes that are used by the application, whether directly or via synonyms. There is a second set of tables with a _TEMP suffix that have duplicate structural definitions (constraints, column names and data types, etc.) The indexes also end with a _TEMP but are identical to the production ones. The only difference is that they are partitioned tables/indexes. All partitioned objects have a single range partition by a bogus column. The single partition is bounded by the MAXVALUE keyword, so all of the data is contained in one partition. Now you can manipulate the _TEMP tables at your convenience without interrupting the access tot he "published" objects. Once you have refreshed your _TEMP objects and are ready to publish the new data your would execute a series of ALTER TABLE tablename_TEMP EXCHANGE PARTITION TABLE tablename. That's it. No re-pointing of synonyms, revalidating of views/stored procs./etc. The application keeps chugging along. The next execution of SQL will use the published tables. HTH Tony Aponte ** pseudo-attachment ** SQL create table x(x1 number,x2 varchar2(50)); Table created. SQL create index xi1 on x(x1); Index created. SQL create table y(x1 number,x2 varchar2(50)) 2 partition by range (x1) (partition y values less than (maxvalue)); Table created. SQL create index yi1 on y(x1) 2 local (partition yi1 ); Index created. SQL insert into x values (1,'original data from regular table'); 1 row created. SQL insert into y values (2,'original data from partitioned table'); 1 row created. SQL commit; Commit complete. SQL select * from x; X1 X2 -- -- 1 original data from regular table SQL select * from y; X1 X2 -- -- 2 original data from partitioned table SQL alter table y exchange partition y with table x; Table altered. SQL select * from x; X1 X2 -- -- 2 original data from partitioned table SQL select * from y; X1 X2 -- -- 1 original data from regular table SQL select * from user_indexes; output snipped SQL select * from user_part_indexes; output snipped SQL alter table y exchange partition y with table x; Table altered. SQL select * from x;
RE: Little Brother Larry not really ON topic
Y'know, Bambi is such a gentle name, but you're scaring me with this in-depth knowledge. :-) JIm [EMAIL PROTECTED] 10/19/01 03:59PM Yes, well, I think that they thought that was a pretty snazzy way not to pay on life insurance. In practice, though, if you've had your policy more than two years, most companies will pay anyway. It's hard to get a definitive yes or no out of them at the time you buy your policy, so it's rather the luck of the draw, um, as it were... -Original Message- Sent: Friday, October 19, 2001 2:42 PM To: Multiple recipients of list ORACLE-L And you they won't pay your life insuranc to your beneficiaries because you died in the commission of a crime..Catch 22 eh? Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, October 19, 2001 3:07 PM Suicide is illegal, but, oddly commission of that crime lands you in a mental institution because you are mentally unfit to stand trial, and, except in the case of extraordinary extenuating circumstances, is proof of at least temporary insanity. This is the mechanism that is used to institutionalize people who attempt, but fail, to commit suicide. This is also used by some insurance companies who will not pay claims for sufferings incurred in the commission of a crime. Extraordinary extenuating circumstances include (but are not limited to): Extreme political protest (e.g., the autoimolation of those monks); extraordinary pain and suffering (it's still illegal, but won't land you in a mental institution); suicide attempts immediately prior to capital punishment (they really don't like that because they can't execute you until you're mentally competent to appreciate the punishment you are about to endure and prisoners, instead, are placed on suicide watch) HTH, Bambi. -Original Message- Sent: Friday, October 19, 2001 1:15 PM To: Multiple recipients of list ORACLE-L Are you sure its not illegal to 'attempt' suicide? Granted that still does not make a whole lot of sense but it gives them a way to get back at you for the medical bills and what not of a failed attempt I believe. So if you do want to do it take the extra time and plan well (not that I think anyone should do it). -Original Message- Sent: Friday, October 19, 2001 10:55 AM To: Multiple recipients of list ORACLE-LNo, man, they through your corpse into a cell until you learn better. Duh! -Original Message- Sent: Friday, October 19, 2001 4:25 AM To: Multiple recipients of list ORACLE-L - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, October 19, 2001 00:50 My favorite law is that it is illegal to commit suicide. Love that! and what happens if u successfully commit one? will they sue u? Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: Bellows, Bambi 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] (not
Re: Corrupt block in DBVERIFY
I think you can run an analyze index validate structure on all the indexes in the tablespace associated with that datafile. Once you identify the corrupted index(es), you can drop/recreate them. Jim I have a corrupt block according to DBVERIFY. The block is on an index so I can rebuild it but I don't know how to find the object with the information displayed in DBVERIFY. Can anyone tell me how to find the object? Thanks! Ron -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Corrupt block in DBVERIFY
I think you can run an analyze index validate structure on all the indexes in the tablespace associated with that datafile. Once you identify the corrupted index(es), you can drop/recreate them. Jim I have a corrupt block according to DBVERIFY. The block is on an index so I can rebuild it but I don't know how to find the object with the information displayed in DBVERIFY. Can anyone tell me how to find the object? Thanks! Ron -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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 DBA Needed in Phoenix..
Preferably with no close friends or relatives, nobody to notice if you just...disappear. Jim [EMAIL PROTECTED] 07/06/01 09:10AM orastaff wrote:We would like to submit someone who is a renter and who is interestedin Phoenix but has not applied to Phoenix companies and is not workingwithother recruiters for Phoenix companies. Is this some super secret job or what???-Original Message-Sent: Thursday, July 05, 2001 3:15 PMTo: Multiple recipients of list ORACLE-LIf you're interested in a great opportunity, then consider this position inPhoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff.We would like to submit someone who is a renter and who is interestedin Phoenix but has not applied to Phoenix companies and is not working withother recruiters for Phoenix companies. This is a full time staff position so no sub-contractors or third partiesplease.Please do not call or send a resume if you are not in the U.S. and/or need sponsorship.* Requirements:- A degree in C.S. or equivalent- 3+ yrs Oracle DBA experience is needed- Strong Unix- Application development experience; Unix scripting; C or Perl languages are desirable- Must have good communication skills -U.S. citizenship or permanent residency requiredThis position is with a company that offers : * Quality Work Environment * Base salary up to 75K-firm +excellent benefits * Financial Stability * Some Relocation Assistance NO sub contracting positions available.PLEASE do not send your resume if you are not in the United States.For immediate consideration, please send your resume to:Email: [EMAIL PROTECTED]Phone: 1-800-549-8502. * Please use job code: One/Phoenix/DBA/CarlosWe pay referral fees.So please contact me if you know of anyone who would be qualified/interestedin the posiitiondescribed above- if it is not a match for your skills.Thanks,Bill LawOraStaff, Inc-"The Proven Connection To Oracle Opportunity"-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: OraStaff INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Farnsworth, Dave INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: SAP R3 and Locally Managed Tablespaces
Jared, I can't say that I have used LMT's with our SAP installation, however, I constantly modify storage parameters, and I really don't see a difference. That being said, I know how much of a control-freak SAP is. The problem is that SAP puts tables/indexes in certain tablespaces based on functionality. For example, the BTABD tablespace contains all transaction, heavy I/O tables, while the STABD tablespace contains all master data and transparent tables, etc. So if you organize LMT's based on size/storage characteristics, you would have to have multiple BTABD, STABD, etc. tablespaces. That would be the only thing I can see SAP being nervous about. In order to do table reorgs, I do this in the sense that I have a BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if you already knew all this, but maybe others would benefit. Jim In working with our SAP consultant, I've discovered that SAP may not yet support the use of LMT's on Oracle. Yes I know that SAP should not really care about this, but SAP seems to care about a number of things that would be best left to the DBA. Does anyone have experience with SAP and LMT's? TIA Jared -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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[2]: SAP R3 and Locally Managed Tablespaces
Doug, Here is my favorite We're a 3rd Party Product, and We Won't Support You story: I was supporting a fairly large Siebel Call Center database at my previous employer. There is a process called Territory Assignment that basically works its way through your company's list of contacts, and assigns them to a sales rep for your company's defined sales regions. We had over 2 million to assign. Basically, there are flags set, and fields updated in batch. The problem was it was taking days, no weeks. The base table for contacts had 32 indexes on it! This was a first for me and my boss, and my boss' boss. We suggested that we drop the indexes, run the assignment, then recreate the indexes. Siebel had a hissy-fit, and threatened to end our support. They then agreed to send in a team of experts to look at the situation (for a nice fee, of course). They found nothing wrong with our configuration, set-up, platform, etc. Their answer? Let's run this during times of low database use. I'm still laughing...I guess times of low use can span weeks in a large corporation! Jim Jim, I don't know about the others on the list, but I for one appreciate hearing about personal experiences of others with these crappy packaged packages. $ years ago we decided against SAP mostly due to the experiences of a local firm that had decided to implement it. At the time they were 2 months into the implementation when the German consultants had enough with their local IT folks, took the install disks/manuals, etc... went home. Sounded like a bunch of control-freaks. That was further added to by a friend at the NOUG who added a tablespace to the database for index re-organization only to have the SAP software throw a hissy fit drop the tablespace! Not sure what version of SAP that was, but WOW!! Anyway we're on PeopleSoft right now although they do not support LMT's they don't care either. Dick Goulet Reply Separator Author: Jim Hawkins [EMAIL PROTECTED] Date: 7/6/2001 12:09 PM Jared, I can't say that I have used LMT's with our SAP installation, however, I constantly modify storage parameters, and I really don't see a difference. That being said, I know how much of a control-freak SAP is. The problem is that SAP puts tables/indexes in certain tablespaces based on functionality. For example, the BTABD tablespace contains all transaction, heavy I/O tables, while the STABD tablespace contains all master data and transparent tables, etc. So if you organize LMT's based on size/storage characteristics, you would have to have multiple BTABD, STABD, etc. tablespaces. That would be the only thing I can see SAP being nervous about. In order to do table reorgs, I do this in the sense that I have a BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if you already knew all this, but maybe others would benefit. Jim In working with our SAP consultant, I've discovered that SAP may not yet support the use of LMT's on Oracle. Yes I know that SAP should not really care about this, but SAP seems to care about a number of things that would be best left to the DBA. Does anyone have experience with SAP and LMT's? TIA Jared -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
RE: Select only one of three tables
This could get ugly. I'm thinking the decode/outer join method won't work because there's no table you can reliably use as a base for the outer join. How about: select emp_id, dept from dept_one union (select emp_id, dept from dept_two minus select emp_id, dept from dept_one) union (select emp_id, dept from dept_three minus (select emp_id, dept from dept_two union select emp_id, dept from dept_one)) / and then go for some coffee if these tables are large at all. Jim Hello listI have a scenario in which I have to check three tables. If there is recordintable A, take it otherwise check table B, if there is record in table B,takeit otherwise check table C. Let say I am looking for DEPT column and thetablesare DEPT_ONE, DEPT_TWO, and DEPT_THREE. At the end I need only one DEPTcolumn.While I can check each of the tables in order I would like to do it in onestatement. I have tried DECODE but it did not like combination of count andcolumn names - error ORA-00937. To make it simpler here is my query from twotables only:select decode (count(d2.emp_id), 0, d3.dept, d2.dept) dept from dept_two d2, dept_three d3where d3.emp_id = TESTER_1' and d2.emp_id(+) = d3.emp_idCan someone recommend a solution?ThanksWitold-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: ALTER SYNONYM?
Can you use a view instead? SVRMGR create table temp1 (temp1 varchar2(1));Statement processed. SVRMGR create table temp2 (temp1 varchar2(1));Statement processed. SVRMGR insert into temp1 values ('a');1 row processed.SVRMGR insert into temp1 values ('a');1 row processed.SVRMGR insert into temp1 values ('a');1 row processed.SVRMGR insert into temp1 values ('a');1 row processed.SVRMGR insert into temp2 values ('b');1 row processed.SVRMGR insert into temp2 values ('b');1 row processed.SVRMGR insert into temp2 values ('b');1 row processed. SVRMGR create or replace view temp as select * from temp1;Statement processed.SVRMGR select * from temp;T-4 rows selected.SVRMGR create or replace view temp as select * from temp2;Statement processed.SVRMGR select * from temp;T-bbb3 rows selected.SVRMGR Maybe some unwanted overhead with the view, but it might help out. Jim [EMAIL PROTECTED] 06/30/01 04:56PM Is there a way to do what would be an ALTER SYNONYM?I've got a synonym created that rotates between pointing to two differenttables. Sometimes it points to TABLE_A, sometimes to TABLE_B. (This isso that behind the scenes, I can truncate and reload TABLE_A, and thenswap, etc. so the table "never disappears".)However, when I want to switch the SYNONYM from pointing to TABLE_A topointing to TABLE_B, the only way is to:drop synonym table_syn;create synonym table_syn for table_b;Is there a way to make that instantaneous for the database? If someonedoes a select at the exact instant between those two commands, it'll errorout, because the table "won't exist".-Rick+--+| Rick Osterberg [EMAIL PROTECTED] || Database Applications Specialist FAS Computer Services |+--+-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rick Osterberg INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: LMT for system tablespace
Isn't SYSTEM the original locally managed tablespace? (lower case anyways) %^) Jim -Original Message- Carmichael Sent: Monday, July 02, 2001 4:10 AM To: Multiple recipients of list ORACLE-L Justin, You can't make the SYSTEM tablespace a locally managed tablespace. Oracle won't allow it. Not even in 9i. :) And they do set up the other tablespaces as LMTs in the demo install. Rachel From: Justin Coleman Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: LMT for system tablespace Date: Mon, 02 Jul 2001 02:45:27 -0800 Dear All, A quick question. Is there any issues with setting up the System Tablespace as a Local Managed Tablespace? Do everyone now do this, or people still set-up as a Dictionary Managed Tablespace? Cheers, Justin _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Jim Newman 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: Speed up massive delete
Well, that IS true (actually I think its NOLOGGING for index creation). But if you have massive amounts of INSERTS or DELETES, dropping the index first and then re-creatingcan help. If the number of deletes is truly large, and you've got spare disk space, and the table can be off-line for a while, you might try CTAS (create table as select) using UNRECOVERABLE, to make a second copy of the table with just the rows you want to keep. Then drop or rename the old table, rename the new table, and re-create the indexes with NOLOGGING. In removing 3 million rows from a 9 million row table this method was very fast compared to DELETE. Jim [EMAIL PROTECTED] 06/28/01 10:58AM Yes that is right. rgds amar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Speed up massive delete Ron, How does creating indexes as UNRECOVERABLE save time when you insert data? As far as I'm aware the only operation it will save time on is the initial creation. Regards, Mike |+--- | | "Ron Rogers" | | | RROGERS@galo| | | ttery.org | | | | | | 06/28/01 | | | 02:51 PM | | | Please | | | respond to | | | ORACLE-L | | | | |+--- ---| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED] | | cc: (bcc: Mike Hately/ETECH) | | Subject: Re: Speed up massive delete | ---| Jack Drop the indexes first before you do the deletes will save you time by not creating logs for the indexes being deleted. On my large activity files I have created the indexes as "Unrecoverable" saving time when I add data or delete data. ROR mªÖªm [EMAIL PROTECTED] 06/28/01 05:45AM Hi All, I have to do some pretty big deletes on a test environment and they are estimated to take for ever. Are there any options to speed it up? Jack = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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). -- Ple
RE: exp performance question ( direct=y)
No, buffer is ignored for DIRECT=Y. But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple of it. I've had dramatic gains in performance doing this. Also, pre-8i you couldn't do direct-mode export of LONG fields. As of sometime in 8i you can (I know it works in 8.1.7). Jim [EMAIL PROTECTED] 06/22/01 04:00PM I dunno. Does the BUFFER still matter when DIRECT=Y? If so, I either remove it entirely, or multiply it by about a factor of five or so. my $0.02 -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:43 PMTo: Multiple recipients of list ORACLE-LSubject: Re: exp performance question ( direct=y) Ron, ok i'm now confused, exp direct=n|y imp no such option sql_loader has direct also. or am i missing something here? joe [EMAIL PROTECTED] 06/22/01 03:00PM I thought that DIRECT=Y was for imports only. It makes since because in the import you are placing the data directly into the blocks with out a redo log.I have no idea why there was a difference in the times unless it was the extra overhead for a command that was not used.ROR mª¿ªm [EMAIL PROTECTED] 06/22/01 12:55PM Oracle : 8.0.5Platform : SunCurrently we have cron job every night (starting from 11pm) to do export. I changed the setting "direct" to "y" two days ago while leaving all other parameters unchanged, hoping to gain some performance. I am a bit surprused to find that it did not. It actually took longer to create dump file with less data to export. The whole exp process takes about 2 hours to finish. Yes, there could be lots of other unix processes running during that time. But I would still expect to see some improvement because we are doing this way for quite a while. So my questions are:1. From your "real" export experience, how much performance boost did you see when you set "direct=y"?2. If "direct=y" improves the performance, why would anyone want to use "direct=n"?Thanks.Guang-- here is my orcle dump file's time stamp:(dmp.1 and dmp.2 are from direct=y,dmp.3, dmp.4 and dmp.5 are from direct=n).-rw-rw-r-- 1 mt prog 1042197132 Jun 18 01:05 oracle.dmp.5.gz-rw-rw-r-- 1 mt prog 1042375633 Jun 19 01:04 oracle.dmp.4.gz-rw-rw-r-- 1 mt prog 1042556662 Jun 20 00:25 oracle.dmp.3.gz-rw-rw-r-- 1 mt prog 1034773279 Jun 21 01:17 oracle.dmp.2.gz-rw-rw-r-- 1 mt prog 1035237986 Jun 22 01:22 oracle.dmp.1.gz--here is the parameter file:BUFFER = 64000COMPRESS = YCONSISTENT = NCONSTRAINTS = YDIRECT = YFILE = /oracle/exports/oracle.dmp.pipe#FULL = YGRANTS = YINDEXES = YLOG = /oracle/exports/export.logROWS = YUSERID = xxx/yyyOWNER = (aaa,bbb)_Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron Rogers INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT - interviewing your superior(fun question)
He also included something like "in the Congress" in his statement, so it was pretty clear he was speaking about providing political support as opposed to technological innovation. If you read the transcript there's not much confusion. But it does make for some good jokes. Jim [EMAIL PROTECTED] 06/21/01 05:46PM nope, he said"I played a role in inventing the Internet"-Original Message-Sent: Thursday, June 21, 2001 5:27 PMTo: Multiple recipients of list ORACLE-LI thought he invented the internet. Just ask him. The best line was "Iknew Jack Kennedy and You are no Jack Kennedy" said by Loyd Benson to DanQuayle. [EMAIL PROTECTED] 06/21/01 05:13PM :), actually if you parrot Gore, it would be"I played a role in inventing certifications".The devil is in forgetting the details!-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gene Sais INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mohan, Ross INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: large SORT_AREA_SIZE usefullness
Has the larger use of memory resulted in swapping? That could slow things down. Jim -Original Message- Poovathummoottil Sent: Wednesday, June 20, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Hi All, We have small data warehouse database. Some queries against some fact tables which are in the range of 30 to 40 GB are often causing full table scans. We had the SORT_AREA_SIZE set to 1M and we were seeing a memory sort of 99%. But the number of queries which used the disk sort was around 500 for a week. I plan to increase the sort area size according to the formula given in Steve Adams' website and tested a few queires to use a SORT_AREA_SIZE of 86M and found that all the quries which used the larger sort_area_size actually ran slower than the ones which used 1M sort_area_size. Could some one explain this behaviour? __ 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: Johnson Poovathummoottil 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: Jim Newman 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[2]: Yahoo!
So the website would be pronounced as ...? :) -Original Message- Eskridge Sent: Wednesday, June 20, 2001 11:43 AM To: Multiple recipients of list ORACLE-L Ron, Wednesday, June 20, 2001, 8:11:28 AM, you wrote: R I have often wondered about the pronunciation of the word Yahoo . R Is the a long or short?? Yahoo stands for You Always Have Other R Options (before replying, note that my name is not Merriam Webster and interpret what I write accordingly) Here's how I hear it used: yahoo (yah'-who) - interjection, an exclamation of wild exuberance yahoo (yay'-who) - noun, a person of cloddish and ungenteel behavior, a dolt, a yokel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge 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: Jim Newman 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: Prompt in Korn shell
Were you looking for something like this? export PS1='$PWD:[$ORACLE_SID]:' Jim -Original Message- Alex Sent: Wednesday, June 20, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Anybody knows how to show current working directory and in general shell variable in Korn shell that prompt change when variable changes - for current working directory and ORACLE_SID for example. I know how to do it in bash but cannot do it right in Korn. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Jim Newman 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: Externally Identified User - Serious Weirdness
Agreed, _Oracle_ users BSIDBA and OPS$BSIDBA are not the same (spelled and pronounced differently :) , even though the _UNIX_ user BSIDBA would run as OPS$BSIDBA. Can you select count(*) from BSIDBA.FA_IDNT? If so, you could try creating a synonym FA_IDNT for BSIDBA.FA_IDNT. Jim -Original Message- [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 7:32 AM To: Multiple recipients of list ORACLE-L I don't think BSIDBA and OPS$BSIDBA are the same Oracle user. (Check in dba_users). So ops$bsidba probably doesn't own the tables? (Maybe the install went wrong because of the value of the initializaion parameter os_authent_prefix which I think could be null or could be ops$ or some other value) I'm not sure how you could run the program and make it log in as bsidba; most probably you'll have to supply a username and pwd. Are there really new apps written in COBOL? :-) chaim Ron Rogers [EMAIL PROTECTED] on 06/18/2001 04:45:03 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Newman 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: NT Script
I did this on another server and can't remember the exact details, but it went something like this: 1) In SQLPlus create a rename.sql file with: Spool rename_export.bat select 'HOST REN export_file_name export_file_name_'||to_char(sysdate,'MMDD') FROM DUAL; spool off; 2) In your script have two commands: sqlplus user/password start rename.sql call rename_export.bat HTH, Jim -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Monday, June 18, 2001 9:56 AM Hello all, I know, I know, NT. Anyway, I was wondering if anyone knew how to append the system date to a file created through a script. Basically, what I want to do is have files set up to run exports every night, however, I need to be able to appened the system date to the file when it is created so I don't just over write the file that was created the night before. Does anyone know how to do this, it would be greatly appreciated!! Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Jim Walski 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: Space Manager vs. Live ReOrg vs TS ReOrg
You caught me at the perfect time. We are new customers of Quest's LiveReorg for our 350GB SAP Oracle database. We run on AIX 4.3.3 and Oracle 8.0.4.3. We have an extremely transactional database (200,000+ transactions per day), so a LiveReorg is really a task. I just reorg'd a 33GB table with 5 indexes in about 7 1/2 hours using the FastCopy feature. This was done right in the middle of the working day, and we saw about a 20-30% CPU usage footprint. It still was not enough to where users were complaining about the system. After several tweaking runs, it ran fine yesterday and we are now running on the newly reorg'd table. Myself and management are extremely pleased. As for Space Manager and LiveReorg, think of it this way: LiveReorg = Space Manager + SharePlex The GUI is based on Space Manager, but the technology behind being able to mine archive logs for transactions posted against the table being reorg'd is in SharePlex. All three are separately sold products. Hope that helps. Jim Sun Sparc Solaris 2.6/8 Oracle DB 8.0.6, 8.0.5 Oracle Apps 11.0.3 My client and I are currently planning on re-orging some of our database - say about 90G out of a 120G database (2 schemas). We've identified 3 tools and are seeking feedback on the pros/cons of each option. anyone? Also, can anyone explain the difference between Space Manager and Live ReOrg? Both are marketed by Quest, making me wonder what, if anything, is the difference... TIA J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Digestive
Ross, As part owner of the Laphroaig distillery (see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland Them's fighten' words friend! Jared On Tuesday 12 June 2001 14:18, Mohan, Ross wrote: Lagavulin??!?! Yikes, Jared, I am going to revoke my Soul Brother license from you. Don't tell me you like Laphroaig as well? That peaty sh*t should be used to clean road tar off SUVs. Now, if you're talking a fine Glendronach, you've got my full attention. -Original Message- Sent: Tuesday, June 12, 2001 4:54 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 12:33, Thater, William wrote: single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Digestive
Maybe idiot was the wrong word, because I do love Laphroaig. I meant that I was kind of childish, like when they used to send in proof-of-purchases for secret decoder rings back in the '50's. Jim I don't know if that makes you an idiot, unless you hate the Scottish and there booze or the distillery has gone broke. I could think of a lot of worse things to own a square foot of. Peter McLarty At 08:15 PM 12/06/2001 -0800, you wrote: Glenfiddich is very good, but I vote for Laphroaig from the Isle of Islay. Wanna know what an idiot I am? A couple of years ago, Laphroaig gave away 1 square foot of their distillery if you bought a bottle and filled out all the paperwork. Well, I did it, and am the proud owner of 1 square foot of the Laphroaig distillery! Cheers! Jim ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Rajendra Sent: Tuesday, June 12, 2001 5:05 PM To: Multiple recipients of list ORACLE-L Talking about single malt .. My vote goes to Glenfiddich ... anyone? 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 ! *4 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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: Hawkins Family 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: Peter McLarty 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
RE: Digestive
Laphroiagies stick together. Jim Damn! You took the bullet that was meant for Jared. Drats, Foiled Again! mad laffter -Original Message- Sent: Wednesday, June 13, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Ross, As part owner of the Laphroaig distillery (see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland Them's fighten' words friend! Jared On Tuesday 12 June 2001 14:18, Mohan, Ross wrote: Lagavulin??!?! Yikes, Jared, I am going to revoke my Soul Brother license from you. Don't tell me you like Laphroaig as well? That peaty sh*t should be used to clean road tar off SUVs. Now, if you're talking a fine Glendronach, you've got my full attention. -Original Message- Sent: Tuesday, June 12, 2001 4:54 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 12:33, Thater, William wrote: single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Mohan, Ross 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Digestive
Oh, no! Rachel, Rachel, Rachel... Being that we are well into the movie plans, I cannot replace you. But I will make it a personal mission to convert you. Remember the following: Laphroaig + ice + Romeo Y Julieta cigar = Heaven On a serious note, you know that you will always have a place in the DBA movie series - the same way big-time movie directors always stick with the same actors (Tarentino comes to mind). Jim well, I have to agree with Ross, I do not like peaty Scotch (and Laphroaig was the first single malt I ever tried -- it almost stopped me completely) does this mean I can no longer star in your movie? Rachel From: Jim Hawkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Digestive Date: Wed, 13 Jun 2001 06:55:25 -0800 Ross, As part owner of the Laphroaig distillery (see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland Them's fighten' words friend! Jared On Tuesday 12 June 2001 14:18, Mohan, Ross wrote: Lagavulin??!?! Yikes, Jared, I am going to revoke my Soul Brother license from you. Don't tell me you like Laphroaig as well? That peaty sh*t should be used to clean road tar off SUVs. Now, if you're talking a fine Glendronach, you've got my full attention. -Original Message- Sent: Tuesday, June 12, 2001 4:54 PM To: Multiple recipients of list ORACLE-L On Tuesday 12 June 2001 12:33, Thater, William wrote: single malt RULES!;-) Well, yeah, I like that too. I have some 16 yr old Lagavulin ( spelling? ) in the pantry that is just awesome. Fine smokey flavor from aging in Oak Brandy barrels. ( Or sherry, I'll have to check ) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
OT - Wrap-up of Serious Question (believe it or not)...
Well, we certainly had a fine discussion on this topic, and I thank all those who responded and weighed in. All of your input was extremely valuable to me (and others). Based on Rachel's and others' comments, I believe that I could not *happily* write a technical book at this point in my life (3 kids under age 4), so I've decided to follow the other camp's suggestion. That's right, we're going straight to the big screen. Join me in next year's Cannes Festival in southern France (yeah, they'll love an invasion of drunk Oracle DBA's). Hidden Parameter, Crouching Developer - or How I Learned to Love the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God *Bill Shrek Thater as The Enforcer (a gentle assassin with a compassionate heart) *Ross Mohan as Hannibal (speedo-wearing cannibal) *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven and Hell) *Jared Still as Charlie (the voice behind the chair) And anyone else that wants a part, just let me know. Haven't built a story-line yet, but wht could possibly go wrong with this winning combination film? But seriously, sorry about this post - it's Friday, I'm in a good mood, and have my databases all running so well, that I could spend 15 minutes typing this email. Virtual Guiness Stout to all on the list, compliments of my new film company. Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) 10% of GROSS sales? or net? I'd be really really surprised if it were gross. Figure that net sales on that @29.95 book is at most half that. And 10,000 copies? Hm, well, I'd bet someone like Steven Feuerstein or Kevin Loney would sell that many, but not most authors. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: Serious Question (believe it or not)... Date: Thu, 07 Jun 2001 18:55:22 -0800 On Thursday 07 June 2001 15:56, [EMAIL PROTECTED] wrote: I think all the original poster was asking was ballpark figures. ie; should a prospective author of an Oracle book expect to make around $1,000, around $10,000, around $100,000, etc. No personal finances involved. Your mileage may vary, etc. 100K?! In your dreams. Standard royalty rate for O'Reilly is 10%, which is public knowledge as they publish it on their web site. If you sell 10,000 copies of a 29.95 book ( assuming they all sell for the list price, which isn't likely ) and no returns, you will gross $30K from the book. 10,000 copies is probably optimistic. And if there are co-authors, you will split the proceeds. Writing a technical book is in most cases a labor of love. There are exceptions, like 'SQL for Smarties' by Joe Celko, but not many tech books sell that well. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: OT - Wrap-up of 'Serious Question (believe it or not)...'
You're in, but any kissing scenes are out of the question. This will be a family film aside from Ross' speedo-wearing cannibalism and Bill Thater's occasional dusting of a helpless developer. As for the soundtrack, we'll put your song on as well. By the way, Larry E. called me from his yacht and really wants to add another character: Bill Gates as The Extortionist. I'm now taking bids on who gets to ax this guy in the movie... Jim How about the films theme song? I vote for Database Writer : sung to the tune the Beatles created. database writer DATABASE WRIIITTERR DATTTAAABASE WRRRIIITEERRR Dorothy P.S Can i get a part in my red shoes as a transvestite waitress or something? :) I'll even get a wig with bunches.. -Original Message- Sent: Friday, June 08, 2001 04:48 To: Multiple recipients of list ORACLE-L Well, we certainly had a fine discussion on this topic, and I thank all those who responded and weighed in. All of your input was extremely valuable to me (and others). Based on Rachel's and others' comments, I believe that I could not *happily* write a technical book at this point in my life (3 kids under age 4), so I've decided to follow the other camp's suggestion. That's right, we're going straight to the big screen. Join me in next year's Cannes Festival in southern France (yeah, they'll love an invasion of drunk Oracle DBA's). Hidden Parameter, Crouching Developer - or How I Learned to Love the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God *Bill Shrek Thater as The Enforcer (a gentle assassin with a compassionate heart) *Ross Mohan as Hannibal (speedo-wearing cannibal) *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven and Hell) *Jared Still as Charlie (the voice behind the chair) And anyone else that wants a part, just let me know. Haven't built a story-line yet, but wht could possibly go wrong with this winning combination film? But seriously, sorry about this post - it's Friday, I'm in a good mood, and have my databases all running so well, that I could spend 15 minutes typing this email. Virtual Guiness Stout to all on the list, compliments of my new film company. Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) 10% of GROSS sales? or net? I'd be really really surprised if it were gross. Figure that net sales on that @29.95 book is at most half that. And 10,000 copies? Hm, well, I'd bet someone like Steven Feuerstein or Kevin Loney would sell that many, but not most authors. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: Serious Question (believe it or not)... Date: Thu, 07 Jun 2001 18:55:22 -0800 On Thursday 07 June 2001 15:56, [EMAIL PROTECTED] wrote: I think all the original poster was asking was ballpark figures. ie; should a prospective author of an Oracle book expect to make around $1,000, around $10,000, around $100,000, etc. No personal finances involved. Your mileage may vary, etc. 100K?! In your dreams. Standard royalty rate for O'Reilly is 10%, which is public knowledge as they publish it on their web site. If you sell 10,000 copies of a 29.95 book ( assuming they all sell for the list price, which isn't likely ) and no returns, you will gross $30K from the book. 10,000 copies is probably optimistic. And if there are co-authors, you will split the proceeds. Writing a technical book is in most cases a labor of love. There are exceptions, like 'SQL for Smarties' by Joe Celko, but not many tech books sell that well. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: OT - Wrap-up of 'Serious Question (believe it or not)...'
set director_talk on Yes, yes. I can see this...panning camera...slowly rising...The Enforcer emerging from the crystal blue surf...I like it! We will adapt the film to this. Cut! Print! Where's my damn Grip? I need my coffee refilled! And who's responsible for the catering? set director_talk off I want to see Bill Thater doing an Austin Powers shimmy in the background, while dressed up in full combat scuba gear. Can we get that in on the script rewrite? Can we? Can we? Huh huh huh? || -Original Message- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Friday, June 08, 2001 12:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: OT - Wrap-up of Serious Question (believe it || or not)... || || || How about the films theme song? || || I vote for Database Writer : sung to the tune the Beatles created. || || database writer || DATABASE WRIIITTERR || DATTTAAABASE WRRRIIITEERRR || || Dorothy || || P.S Can i get a part in my red shoes as a transvestite waitress or || something? :) I'll even get a wig with bunches.. || || -Original Message- || Sent: Friday, June 08, 2001 04:48 || To: Multiple recipients of list ORACLE-L || || || Well, we certainly had a fine discussion on this topic, and || I thank all || those who responded and weighed in. All of your input was extremely || valuable to me (and others). || || Based on Rachel's and others' comments, I believe that I || could not *happily* || write a technical book at this point in my life (3 kids || under age 4), so || I've decided to follow the other camp's suggestion. That's || right, we're || going straight to the big screen. Join me in next year's || Cannes Festival in || southern France (yeah, they'll love an invasion of drunk || Oracle DBA's). || || Hidden Parameter, Crouching Developer - or How I Learned to || Love the Larry || directed by Jim Hawkins. || || Starring (not in order of importance): || *Larry Ellison as God || *Bill Shrek Thater as The Enforcer (a gentle assassin with || a compassionate || heart) || *Ross Mohan as Hannibal (speedo-wearing cannibal) || *Rachel Carmichael as The Goddess (a do-good angel caught || between Heaven and || Hell) || *Jared Still as Charlie (the voice behind the chair) || || And anyone else that wants a part, just let me know. Haven't built a || story-line yet, but wht could possibly go wrong with this winning || combination film? || || But seriously, sorry about this post - it's Friday, I'm in a || good mood, and || have my databases all running so well, that I could spend 15 || minutes typing || this email. || || Virtual Guiness Stout to all on the list, compliments of my new film || company. || || Jim || || -- || Jim Hawkins || Lead SAPR/3 Oracle Database Administrator || MEMC Electronic Materials, Inc. || 600 Pearl Drive || St. Louis, MO 633376 || 9636) 474-7832 || [EMAIL PROTECTED] (work) || [EMAIL PROTECTED] (home) || || 10% of GROSS sales? or net? I'd be really really || surprised if it were || gross. || || Figure that net sales on that @29.95 book is at most half that. || || And 10,000 copies? Hm, well, I'd bet someone like Steven || Feuerstein or || Kevin || Loney would sell that many, but not most authors. || || || || From: Jared Still [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: Re[2]: Serious Question (believe it or not)... || Date: Thu, 07 Jun 2001 18:55:22 -0800 || || On Thursday 07 June 2001 15:56, [EMAIL PROTECTED] wrote: || ||I think all the original poster was asking was || ballpark figures. ie; ||should a prospective author of an Oracle book expect || to make around || $1,000, ||around $10,000, around $100,000, etc. No personal || finances involved. || Your ||mileage may vary, etc. || || 100K?! || || In your dreams. Standard royalty rate for O'Reilly is || 10%, which is || public knowledge as they publish it on their web site. || || If you sell 10,000 copies of a 29.95 book ( assuming they all sell || for the list price, which isn't likely ) and no returns, you will || gross $30K from the book. || || 10,000 copies is probably optimistic. And if there are || co-authors, || you will split the proceeds. || || Writing a technical book is in most cases a labor of love. || || There are exceptions, like 'SQL for Smarties' by Joe Celko, but || not many tech books sell that well. || || Jared || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jared Still || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists
Re: OT - Wrap-up of 'Serious Question (believe it or not)...'
Always glad to spread some semi-on-topic humor on Fridays. It helps me out of the daily drone mode... By Monday, I'll be back to my serious, helpful, wannabe-guru self! Cheers, everyoneand another round of virtual Guiness on me! Jim Oh god Jim, this is the best laugh I have had in days! Thank you, thank you, thank you! Jared ( still laughing ) On Friday 08 June 2001 08:47, Jim Hawkins wrote: Hidden Parameter, Crouching Developer - or How I Learned to Love the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God *Bill Shrek Thater as The Enforcer (a gentle assassin with a compassionate heart) *Ross Mohan as Hannibal (speedo-wearing cannibal) *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven and Hell) *Jared Still as Charlie (the voice behind the chair) And anyone else that wants a part, just let me know. Haven't built a story-line yet, but wht could possibly go wrong with this winning combination film? But seriously, sorry about this post - it's Friday, I'm in a good mood, and have my databases all running so well, that I could spend 15 minutes typing this email. Virtual Guiness Stout to all on the list, compliments of my new film company. Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: SUMMARY: Thanks everyone - tru64
I don't really care who's what, as long as I can still play Pink Floyd's Dark Side of the Moon to it. But since we're lobbying for parts, I guess I'll audition for the Tin Man due to his lack of heart ;) Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) PLEASE I want to be the wicked witch!!! 8] April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Wednesday, June 06, 2001 8:41 AM To: Multiple recipients of list ORACLE-L Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: OT RE: SUMMARY: Thanks everyone - tru64
That's funny, 'cause if you ask the developers, I'm the stupid dunkey (Eddie Murphy's donkey character). Is that why they keep saying I'm an ass? Jim Actually I'm torn... I REALLY want to be the wicked witch... but I just feel more like Princess Fiona (Shrek)... -Original Message- Sent: Wednesday, June 06, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Damn! You beat me to it! -- Anita --- April Wells [EMAIL PROTECTED] wrote: PLEASE I want to be the wicked witch!!! 8] April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Wednesday, June 06, 2001 8:41 AM To: Multiple recipients of list ORACLE-L Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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 - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official
RE: What stands for i in Oracle 8i
Wouldn't that be Micro$oft IIS and Internet Exploder? Yeah, Oracle softwaresoftware that crashes the internet! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Yexley Robert D SSgt AFIT/SCA Sent: Wednesday, June 06, 2001 1:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: What stands for i in Oracle 8i I believe it stands for internet, as in, the internet database. -Original Message- From: Muthaiah [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 06 June, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: What stands for i in Oracle 8i Hi, I am just curious about to know for what that i stands for in Oracle 8i. Can any one shed some light? Thanks, Muths Do not go where the path may lead, go instead where there is no path and leave a trail. -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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).
Serious Question (believe it or not)...
All, I am very interested in collaborating with others in the writing of an Oracle technical book (DBA subject matter). I am interested in how those of you who have done this (ala Rachel), got started or made the right connections. I do have a somewhat literary background, so I know I can do this. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: How to prevent oracle from committing a transaction?
Keep in mind that if at any point you issue any DDL command, a commit is automatically performed. For example, if you open a SQL*Plus session, insert a few records, then do an alter table ..., those records will be committed. Just a thought... Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Jim Hawkins 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: HELP! / RE: OT: Archiving not possible with SQL Server?
You forgot the most important program loop: elsif is is friday yet? = true then loop beer_counter = beer_counter + 1 end loop endif if is it friday yet? != true then SET INDIGESTION ON endif On 1 Jun 2001, at 8:54, Jared Still wrote: HELP ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Performance tuning
Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Performance tuning
Sorry - that's what I meant. No archive log generation. NOT no redo log generation. Thanks for pointing that out. Is it Friday yet? Jim Why putting DB in noarchivelog will avoid redo generation? There will be no archiving, but redo will continue to be generated. Alex Hillman -Original Message- Sent: Wednesday, May 30, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) HI ALL, We have to load almost 3 millions records of average row size of 150 bytes. We are importing data using sqloader with ROWS=4000 and bindsize=845 . We have adjusted the rollback segment to almost 10 m with 8 extents enough for single transaction size and considering 30% rollback overhead. We adjusted the OPTIMAL TO 10 M to have avoid rollback extension Rollback segment, databuffer cache have hit ratio of 100%. The loading was fast only for first 10 commits but then it slowed like snail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM . SGA figures in M : NAME VALUE - Fixed Size.0676384 Variable Size239.02734 Database Buffers 39.0625 Redo Buffers 7.8203125 - sum 285.97779 ( we can't use direct path due to functions in sqlldr controlfile). . Couldn't figure out the bottleneck yet. Any ideas. TIA Azhar Siddiq, DBA LMK Resources -- 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Hillman, Alex 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
RE: Your views on Quest - Shareplex
I verified this today actually. I had a conference call with Quest regarding SharePlex, and asked specifically about the chained rows. They said there is a reorganization step on the target database, so chained rows are not a problem. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] We are looking into the product as well, but have yet to even toy with the product. There is a no chained rows restriction. I'm not sure what that statement means. Shareplex will replicate a table that has chained rows. Shareplex does not replicate transactions on sys objects. A table dropped on one side will not be dropped on the other. It apparently will replicate truncates however. It's one thing to read the logs and to find the time when a truncate caused writes to the data dictionary, but quite another to reconstruct the statement. Statement from a developer of Shareplex: Interesting statement as this is how we replicate DML. Providing functionality for DDL is not at all impossible for us. It is just one of the things on the list of enhancements that we plan for SharePlex, the priority of which is dependent on the market. Let me relate my personal experience working with Shareplex (BEFORE I was an employee with Quest Software). At a previous company we were looking for a replication tool at a company that did payroll taxes. There were large batch loads (bank records) every night, but especially at the end of each quarter and at the end of the year. We wanted to ensure that the replication tool we chose would be fast enough to keep up with the large data loads. When we tested Oracle Replication and Quest Shareplex, we found that Shareplex was significantly faster. I personally argued against it initially for some of the reasons posters here have mentioned (e.g. it uses unsupported means to accomplish its goal) but eventually we implemented Shareplex and were satisfied with the result. There can be some manual effort involved in reconciliation of discrepancies but we found that effort to be minor. Another factor that influenced our decision is that we were intending to use Shareplex for Oracle in conjunction with Shareplex FS to replicate datafiles created on the HP-UX server. -- Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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:Your views on Quest - Shareplex
All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface -- Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered database useless. History indicates that SharePlex can withstand most log corruptions and data block corruptions, while maintaining a viable live standby site. If the client is not a 100% sure, SharePlex provides a variety of mechanisms to periodically resync the standby database, including the ability to use a hot backup and 3rd party disk mirroring technologies - all of this without interruption to the main production site and without the need to reactivate the replication. Possible Symptoms ~ The logs are applied logically, with most correctness checking performed within the SQL generated by SharePlex, So SharePlex itself must alert the user to any correctness problems. Absent SharePlex notification, the destination database likely will continue to work, leaving the user to discover any incorrect data. Eyal: Conclusion, Oracle is still obligated to support the Oracle database
Re:Your views on Quest - Shareplex
Jared, That's a really good question! I don't know the answer... Sorry, Jim On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: From note on MetaLink: 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. So how does a standby database work if the logs don't contain complete transactions? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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:Your views on Quest - Shareplex
Jared, That's a really good question! I don't know the answer... Sorry, Jim On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: From note on MetaLink: 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. So how does a standby database work if the logs don't contain complete transactions? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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:Your views on Quest - Shareplex
Rachel, Sorry for the confusion - I meant that my sales rep got Eyal to reply to this, and then sent me the informative email. I did not, however, know that I was getting it from the VP for Technology! I guess I should have been really impressed with my sales reps leg-work! Jim Jim, Um, if that is the Eyal I know, it's Eyal Aronoff and he's not exactly a sales rep for Quest but instead is the Senior VP for Technology and the person who developed Shareplex. Which means you got the best possible answer from the best possible source. He's brilliant. Rachel From: Jim Hawkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:Your views on Quest - Shareplex Date: Tue, 29 May 2001 11:01:21 -0800 All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface -- Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered
RE: Another Database Down
Laura, I fight this nearly every damn day. We constantly refresh several SAP systems from production copies via EMC BCV's and TimeFinder. About half of the time, I get the same error, where recovery was successful, but open resetlogs would fail. It turns out, in my case, that no amount of recovery will every get this database open (even with resetlogs) with this backup set. Apparently there is an issue with a piece of the EMC software that causes problems when mirrors are split during a hot backup. To make a long story short, there is an event you can set in via a server manager session that will dump all datafile headers. What you look for is what Oracle calls a fuzzy SCN. That is, an SCN hex value that evaluates to a non- sensical number. In English, the SCN for the header should have some hex value that corresponds to a number. If it is set to something like FFx, then you have a fuzzy SCN which means your backup is bad and will never work. I don't know if this is your exact problem or not, but since you're getting the same symptoms I was, I thought I would throw it out there. You can read more on MetaLink by searching for fuzzy SCN. By the way, as soon as our RS/6000 SA upgraded our version of PowerPath, the bug went away, we have consistent mirror splits, and all is well on the SAP backup/restore front... Sorry if I threw you way off on a tangent on this one. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) snip Just to put you a little more in the picture I have recovered a couple of DBs now without archived redo log files etc where all hope had been lost and resumes were being updated and got them back by fudging a couple of issues. (Oracle would probably throw their hands up in horror and refuse to support what I did, but the database opened, I didn't lose any data (this I believe was down to good fortune rather than skill) and everyone was happy. (snip Lee snip Lee, I am just glad someone has responded and wants to help! I am not sure how much I told you about my situation, so bear with me while I recite it to you. Our OS is Windows NT. We had 2 disks to crash. Two of my databases are ok because I had archive logs for one and a cold backup for the other. However, I have one that I have not done anything too as far as backup, other than a physical backup of the database datafiles, redo logs, etc. The Sysadm had a full backup of the previous Friday and a differential backup from the following Thursday which he loaded back to the server when the new disks were installed. I tried to recover the database and when it asked for the logs I entered cancel. It said that recovery was successful but gave me a warning that if I tried to open the database with the Resetlogs option it would tell me that my system datafile was too incomplete (or something to that affect). Yesterday (Thursday) I did call Oracle and this is what this first guy had me do: 1) Startup Mount2) Select from v$datafile to check the status of my datafiles. They were all online, which per Support, that was not good. 3) Alter database datafile ??? offline. This command gave me the error 'offline immediate disallowed unless media recovery enabled (ORA 01145). So then I was referred to another Support person. He had me shutdown the database, startup mount, recover database. Of course the recover asked for a log and Support had me input each of my five redo logs, but the log with the info needed had already been overwritten so the info wasn't there and I didn't get any further. Next Support wanted me to restore my files from the Friday backup only. This is where I have stopped because now I am waiting on my Sysadm to come in and restore them for me. I tried to call the Support guy back and let him know the status, but got a message stating that because I had only 'basic or bronze' support that I could only speak to someone between certain hours, and then was cut off. I had gone through Metalink though so I just updated the tar. If you have any ideas for me I would appreciate any and all. Thanks, Laura -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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
Re: OT: My bad
I call for your immediate removal from this list. We do not tolerate mistakes. Goodbye - you are the weakest link! Just kidding...welcome. Jim I didn't mean to reply-all. That's my bad. Chuck Speaks, MCSE Database Administrator Lithonia Lighting 770-922-9000 x3450 http://www.lithonia.com -Original Message- Sent: Friday, May 25, 2001 12:56 PM To: '[EMAIL PROTECTED]' Sounds pretty standard. Chuck Speaks, MCSE Database Administrator Lithonia Lighting 770-922-9000 x3450 http://www.lithonia.com -Original Message- Sent: Friday, May 25, 2001 1:08 PM To: Multiple recipients of list ORACLE-L We have one little rule that most folks follow pretty well. If it's not about Oracle or oracle proper, we usually place an OFFTOPIC or OT in the first position of the subject line. || -Original Message- || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || Sent: Friday, May 25, 2001 12:21 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: New member || || || Sounds great. I am a Lazy DBA refugee and I must say that I || like the tone || and banter on this list a lot better. I'll be talking to || you guys soon. || It's good to see familiar names like Chris Spence and Steve || Adams, for they || are outlaws on other sites. REAL TROUBLEMAKERS! || || Chuck Speaks, MCSE || Database Administrator || Lithonia Lighting || 770-922-9000 x3450 || http://www.lithonia.com || || || -Original Message- || Sent: Friday, May 25, 2001 11:43 AM || To: Multiple recipients of list ORACLE-L || || || Welcome, Chuck. || || Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. || || Welcome to a List where politics and recipes are posted with || equal fervor as SQL Tuning tips. || || The water's fine! || || || -Original Message- || || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]] || || Sent: Friday, May 25, 2001 11:07 AM || || To: Multiple recipients of list ORACLE-L || || Subject: New member || || || || || || Hello, || || || || Just wanted to introduce myself before posting to the list. || || I look forward || || to interacting with you guys/ladies on the list. Have a || || great Friday! || || || || Chuck Speaks, MCSE || || Database Administrator || || Lithonia Lighting || || 770-922-9000 x3450 || || http://www.lithonia.com || || || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Speaks, Chuck W. || || 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: Mohan, Ross || 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: Speaks, Chuck W. || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: MICROSOFTDTPROPERTIES
Joking I think we've stumbled on to something... SQL desc MICROSOFTDPROPERTIES; NameNull?Type --- PROPERTY_ID NUMBER(38,0) FIRST_CRASH_DATE DATE NEXT_CRASH_DATE DATE TOTAL_CRASH_NUMBER_SETTING LONG NONSENSICAL_HEX_ERROR_CODE VARCHAR2(38) CRASH_INTERVAL_SECONDS NUMBER(38,0) SECURITY_LOOPHOLE_ID NUMBER(38,0) SECURITY_LOOPHOLE_DESC VARCHAR2(250) AUTO_DATA_PURGE_INTERVAL_SECONDS NUMBER(38,0) AUTO_DATA_CORRUPT_INTERVAL_SECONDS NUMBER(38,0) /joking I have developers who have created this table. Now they've come to me to find out what the table does. I think it is used by the Microsoft Transaction Server software. Does anyone know for sure the purpose of the MICROSOFTDTPROPERTIES table? Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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).
Should Archive Log File OS Size be the same?
Oracle 8.1.5 and 7.3.4.5 No Alter System switch logfile performed. NT 4.0 I am testing some recovery plans, and I tried to restore a cold backup and roll the database forward. However, when I went to apply the 1st archive log since the cold backup it complained about a size of the transaction and indicated the archive log was corrupted. When I review all the archive logs on the production system I notice the OS size of the files are not always the exact same. Should they be the exact same size assuming that no one does an alter system switch logfile command? The archive logs are 10MB each and some appear to be off 1-4k Normal = 10241, Others = 10,237,10240,10238) Thanks, Jim Jim Walski ClassicPlan Chino, CA 91710 email [EMAIL PROTECTED] http://www.classicplan.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski 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 oracle patch 8.1.7.1.1
I just received this from a iTar. It is for Win NT. Go to Metalink. On the left side, choose Patches. Under Patch Download, click: == NEW! Click here for ALL Product Patches On the Patch Download screen, choose: Oracle Server for Product Family 8.1.7.1 for Product Release MS Windows NT for Platform Click search. You should find: ID:611940 Patchset::1711240 8.1.7.1.1 ORACLE SERVER PATCH SET NOTE: Do NOT enter a Patch Number. This is a patchset not a patch, it will not match if you enter it as a patch number. -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tuesday, May 08, 2001 8:26 AM I must be going blind -- I search for the patch and the latest I find is 8.1.7.0.2 ... could you provide the ID number and/or a working method to find the .1.1 patch for NT? The Oracle DBA wrote: I guess you are not on NT because the .1.1 patch is there. The std procedure for 817 is to install 817, patch it to .1.1 then .1.2. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 04 May 2001 10:31:23 Shaw, John B wrote: I just downloaded patch 8.1.7.1.2 from metalink - in the readme (yes I actually read it before installing ) it states that the earliest version that this patch may be applied to is 8.1.7.1.1 - I can't find this patch on metalink anybody know where I can get it? . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw Intergraph Public Safety mailstop LR24A4 [EMAIL PROTECTED] 256-730-8038 All the usual disclaimers and some of the certifications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Jim Walski 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).
Problems with hot backup via BCV's...
List, Oracle 8.0.4.3.0 AIX 4.3.3 EMC Symmetrix SAPR/3 4.0B 200,000+ transactions/day; 300GB database. Here's what we do: 1. Put all tablespaces in hot backup mode. 2. Split/Sync mirror. 3. Take tablespaces out of hot backup mode (usually after only 3-5 minutes). 4. Take BCV backup of this mirror. Problem is, when restored, sometimes the database can be opened resetlogs, and sometimes it can't. When it opens, we just apply all archive logs generated during steps 1 through 3, then open resetlogs and it works fine. The other half of the time, Oracle complains that the system datafile still needs more recovery. You can keep applying logs and it will never open. Oracle had me take header dumps to check for fuzzy SCN's, which these do appear to have. Oracle says this is a bad backup set even though EMC thinks it was fine. By the way, fuzzy SCN's are SCN's that have a hex value that evaluates to a nonnumeric, nonsensical number. Was wondering if anyone else was having issues with hot BCV backups and restoring them. We are current in terms of EMC TimeFinder and other software. It just seems to be hit or miss with these backups (obviously we take other backups too, but these are the easiest and most timely). Thanks, Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: authentication externally on WinNT
I was just recently playing around with this and found a couple of tips to fix my problem: There is a registry setting called: OSAUTH_PREFIX_DOMAIN that is now defaulted to TRUE for 8.1 databases. To get my machine to login without a username/password I had to create an oracle user name like "MYDOMAIN\USERABC". ( not sure if it matters but the notes also said to put everything in uppercase). You can set this to false and then i believe the domain name can be left off the oracle username. There is an init.ora parameter = REMOTE_OS_AUTHENT that must be set to TRUE ( I do believe this causes some security risks so you may want to investigate those issues to.) There is also an init.ora parameter OS_AUTHENT_PREFIX that needs to be set. I believe the default is now "" (no prefix required for the oracle user account). I used these keywords and was able to locate some helpful documents in Metalink. HTH, Jim References Metalink: Note:102665.1 -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, April 18, 2001 2:28 AM Hi! Oracle8.1.7 on WinNT. I created database user with external authentication with whom I'm logged on that WinNT server. When I start exp there is error invalid username/password logon denied. What am I missing? It works just fine on UNIX! TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= 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: Jim Walski 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).