Re: Selecting Next X Values From Dual
If X is fixed for all sessions, do a step increase of X so that you only have to select 1 row from dual. Anjo. On Friday 27 September 2002 00:18, you wrote: All... Is there a method by which I can select the next x values from a sequence from dual? I've searched Google and OraFAQs.com, but I can't seem to make any hits on my search request. TIA Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Anjo Kolk http://www.oraperf.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk 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: Should I post a preview of Oracle9i RMAN Backup and Recovery
Sure, do post it Aleem -Original Message- Sent: Friday, September 27, 2002 1:31 AM To: Multiple recipients of list ORACLE-L Subject:Should I post a preview of Oracle9i RMAN Backup and Recovery Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Abdul Aleem 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: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand
One more vote for it -Original Message- Robert Sent: Thursday, September 26, 2002 10:31 PM To: Multiple recipients of list ORACLE-L Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Alexandre Gorbatchev 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: Degrade a database??
If I wanted to degrade a database, I'd take it out to a cheap pub, get it drunk, and let it make a fool of itself on the dancefloor before taking it home for some wild bedroom scenes... Next morning, rest assured, the database will roll over in your bed and exclaim: I'll feel so degraded :-) --- [EMAIL PROTECTED] wrote: Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: extremely long parse time
ALL_INDEXES is a 9-way table join (some outer) with a few correlated subqueries. ALL_IND_COLUMNS is a 8-way table join with a few correlated subqueries as well. That's a lot of work to churn through... hth connor --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: why would a query take 148 seconds to parse? It is a two way union where the first half is going against all_tables and the second half is a join between all_indexes and all_ind_columns. The shared pool has 50M large parts of it are free. I generated a 10046 (level 12) trace, and I just don't see anything out of whack, except of the c=14868 in the PARSE #1 line. Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 place in the business (was RE: DBA work load)
Give me a break - I'm looking for solutions, not to compound the problem!! peter edinburgh -Original Message- From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 20:05 To: Multiple recipients of list ORACLE-L Subject: RE: DBA place in the business (was RE: DBA work load) and DDBA, and ODBA, and DA, and DM, and DWA, and DWM ... any more? -Original Message- Sent: Thursday, September 26, 2002 2:37 PM To: Multiple recipients of list ORACLE-L Have you gone through what's the difference between an application DBA and a database DBA? yet? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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 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: Inka Bezdziecka 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). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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 place in the business (was RE: DBA work load)
Have you gone through what's the difference between an application DBA and a database DBA? yet? Oh yes, and a logical dba, and a physical dba ... you name it, we found it ... which rather confirms the point Jared was making - 'We fit everywhere, and nowhere.' peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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: Automation of Migration to Oracle9i
Thanks for this Gerardo, I forgot to mention, but unfortunately this activity will have to be carried out on NT rather than Unix. I guess it would be more complicated as the registry and services would come into play aswell. Cheers, Kieran -Original Message- Sent: Thursday, September 26, 2002 6:14 PM To: Multiple recipients of list ORACLE-L I think it's very possible. Run the Universal Installer once (interactively). Tar up the stuff under the product directory (all subdirectories including jre and 9.2.0.1). Now you can use the tar file to install to another machine. Write a wrapper script that untars your image. I recommend Perl and the Expect perl module for this type of work. This combination (Perl with Expect module) makes telnet'ing and ftp'ing a snap. I haven't tried to do ssh and scp yet via this method but I suspect it's also possible. There are some gotchas to watch out for. You have to keep the ORACLE_HOME directory name the same. Don't expect things to work if you change the directory name. This used to be the case with 7.x but not any more since 8.1.x. If you are setting up web server, then I think you have to figure out where the host name is hard-coded into the config files. We have not had to worry about this, since we do not set up the web server as part of our database server installs. HTH Gerardo -Original Message- Sent: Thursday, September 26, 2002 7:48 AM To: Multiple recipients of list ORACLE-L Hi, I've been charged with coming up with automation scripts which will migration customer databases from Oracle 7.3.4 to Oracle 9i (35 databases in all). As the databases aren't huge I was gonna go with the Export/Import option (rather than MIG utility), so I'm in the process of writing batch files and sql scripts to automate this stage of the process. I was under the impression that the installation of the 9i software would be a manual process, but from the Universal Installer help I see it's possible to run this in silent mode with response files. Has anyone ever used this before and how have you got on? Do you think it would be possible for me to come up with scripts to automate this to run on all the client sites with minimal user intervention (assuming identical file systems)? It sounds too good to be true. Cheers, Kieran Murray CardBASE Technologies Limited® Crofton Road Dun Laoghaire Co Dublin Ireland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray 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: Molina, Gerardo 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: Kieran Murray 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: Should I post a preview of Oracle9i RMAN Backup and Recovery
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: RAC (Real Application Clusters)
Push the question about the requirement of RAW devices.. and ask if Veritas's product can work without any restrictions.. The veritas clustered file system is supposedly ok to use with RAC where you can take advantage of using file systems. But I haven't seen confirmation of that. also-ask about the differences in the hardware they are showing you as compared to your environment.. There are some differences in the implementation based on the hardware You should probably get good feel on how Oracle believes RAC could fit into your environment. Are you looking for 100% availability? Or just scalability? Can the environment take a 5 minute downtime for a Clustering solution? Or do you need to have the environment up all of the time... And as Rich indicates-the transparent application failover can be cool. But does your app use JDBC? Thick or thin? From our discussions with Oracle (as we prepare for a full blown POC of rAC) that one will need to use the thick JDBC client (cuz of the OCI layer) to take advantage of some of the TAF features.. This may not be the case in the future though.. oh well-time for coffee greg -Original Message- Sent: Thursday, September 26, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Specifically ask about RAC's performance with respect to platform. I saw a demo that HP put on at a WOUG meeting where the NT cluster took 20-30 seconds to fail over. While this isn't earth-shattering, there was mention made that Unix/Linux failover times only took about 1-2 seconds. Might be an issue for e-commerce or such. Very impressive demo they put on. I especially liked the transparent query failover and load balancing. Da-rool, da-rool. Of course, for us to convert our concurrent user licenses to per-CPU licensing for RAC, well... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 10:04 AM To: Multiple recipients of list ORACLE-L Subject: RAC (Real Application Clusters) I am visiting Oracle next week and will be getting a dog-and-pony show on Oracle 9i and RAC (Real Application Clusters). Does anyone have any experience or comments on this product/technology? Can you suggest some burning questions I can pose to Oracle when we get the demos? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Loughmiller, Greg 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
Must say I liked Inka's notion of calling all interested parties with details, though it could be income threatening =:-0 Maybe a compromise would be to agree some type of SOP for such situations and have the interested callers list put in there. I mean if they are so keen to know first thing next morning... OTOH, why not send a summary e-mail to interested parties and tell them you'll fill in any gaps when you have caught up on lost time. If the problem has been resolved, details of how are of a mainly historical nature anyhow - right? Tim: Can you give me the ISBN's to some of your novels. What!!! You haven't written any yet! - A waste of talent ;) Thanks for the homour in any case. PS: The BDBAFH has gone right over my head. My psyche is suggesting it's profane. What does it stand for? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Should I post a preview of Oracle9i RMAN Backup and Recovery
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
ODBC limits
I'm trying to get information of the limitations of ODBC drivers, specifically Oracle's and Microsoft's drivers for Oracle. Things like maximum no. of records they can fetch etc. As I know very little about ODBC (which might be reflected in the nature of my question) I hope I'm asking a sensible question. I'm asking as there are some developers here who are getting a variety of error messages when dealing with large volumes of data from 8.1.7 DB into MS-Access. I'm trying there to ascertain where the problem lies, i.e. is it the driver, MS-Access, combination of both of these, or it's Microsoft what do you expect!!! Any (non-flame) feedback to useful web sites, white papers etc would be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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-dba.com domain
I got the first bid in!!! Matt Adams - GE Appliances - [EMAIL PROTECTED]Their fundamental design flaws are completelyhidden by their superficial design flaws. - Douglas Adams -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: oracle-dba.com domain email me at [EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe
RE: Degrade a database??
Title: RE: Degrade a database?? I have no fresh ideas but how about keeping a file system backup of your oracle installation and 3 copies (in different locations of course) of a complete cold backup before the upgrade? Or copy the existing database on a similar but separate machine, ready to be brought up, all you need is TNS change. 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! *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.*1
LOAD_BALANCING=ON in listener.ora versus tnsnames.ora
Setting LOAD_BALANCING=ON parameter in listener.ora Versus tnsnames.ora . Which is Better Why ? Any Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: Best Practice - Partitioned object, one partition per tablespace,
That is the recommended way. I have a 6 partition table with each partition in a different tablespace and each table space on a different drive. It's working well! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:48 PM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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: [Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-
I found that query-only applications seemed to run OK against 8.x.x databases, but update applications encountered locking problems because of the expanded rowid. (I think Forms 3.0 stores the rowids within the form and only stores part of the expanded rowid). I don't know how you could possibly run Forms 3.0 update applications against 8.x.x or 9.x.x, but then again I am all converted from Forms 3.0 at this point and don't need to worry about it any more. -Original Message- Sent: Thursday, September 26, 2002 3:04 PM To: Multiple recipients of list ORACLE-L 11]] Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. 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). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who
RE: NETIQ monitoring tool for server and Oracle
Yes, we use it for our Winders/Linux/Solaris/HPUX boxes. It's actually used by our parent company, which also does our networking, MS sExchange administration, and Windows server admin. I'm on the mailing list for when server in our building isn't pingable. Unlike OEM, I've had no problems with NetIQ actually contacting me. OEM (from v2.x thru 9iR2) has been flaky at best. Sometimes it pages me, sometimes not. Sometimes it e-mails me, sometimes not. There's no rhyme nor reason as to why, and I've not been able to find out why. NetIQ on the other hand, hasn't missed a beat. I don't know if NetIQ can do any Oracle monitoring (Corporate doesn't use it here if it is possible), so OEM may have some advantages there. For my money, I'd be inclined to install a custom app to take the place of OEM. Hmmm...seems to me that someone here on this very list has just published a book that has a chapter on a DB tool that can be used to monitor Oracle databases using something called Perl. Only problem is that you'd REALLY need to buy the book... ;) http://www.oreilly.com/catalog/oracleperl/ Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Anubha Jalsingh [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 7:58 PM To: Multiple recipients of list ORACLE-L Subject: NETIQ monitoring tool for server and Oracle Anyone using NETIQ for monitoring Windows and Unix servers. ? How is it compare to OEM tools ? I will appreciate your comments and inputs. thanks Manmohan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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-dba.com domain
anyone have a specific URL for the "lot"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, MABG, 088130)Sent: 27 September 2002 14:18To: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain I got the first bid in!!! Matt Adams - GE Appliances - [EMAIL PROTECTED]Their fundamental design flaws are completelyhidden by their superficial design flaws. - Douglas Adams -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: oracle-dba.com domain email me at [EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe
RE: Best Practice - Partitioned object, one partition per tablesp
For any indexes on the table ,LOCAL prefixed indexes (b*tree/bitmap) is the preferred way to go ! -Original Message- Sent: Friday, September 27, 2002 7:18 AM To: Multiple recipients of list ORACLE-L tablespace, That is the recommended way. I have a 6 partition table with each partition in a different tablespace and each table space on a different drive. It's working well! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:48 PM We currently are creating partitions of a given table in individual tablespaces (1 partition = one tablespace). To me, this seems like a reasonable practice. Anyone have any thoughts about this they would like the share? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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: Kawatra V (Vikas) at Aera 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: migrating 8.x-9i and charsets
The Database Character Set and the National Character Set are different. Your DB CharSet could be UTF8 but the National CharSet AL16UTF16 . [I believe that when you create a database without specifying charsets, the default DB CharSet is still US7ASCII but the NationalCharSet is AL16something, I can't remember what] Where your NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 is defined, your DB CharSet is WE8ISO8859P1. Hemant At 08:28 PM 25-09-02 -0800, you wrote: Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16. the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16. I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s). It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale 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).
[no subject]
SET ORACLE-L NOMAIL _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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-dba.com domain
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItemitem=2057533249 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark LeithSent: Friday, September 27, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain anyone have a specific URL for the "lot"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, MABG, 088130)Sent: 27 September 2002 14:18To: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain I got the first bid in!!! Matt Adams - GE Appliances - [EMAIL PROTECTED]Their fundamental design flaws are completelyhidden by their superficial design flaws. - Douglas Adams -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: oracle-dba.com domain email me at [EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe
Re: Two Q's for SAP DBA's
On Wednesday 25 September 2002 12:33, Hand, Michael T wrote: Got a couple of questions for those of you dealing with SAP: 1) Has anyone heard of a timeline as to when (or if) SAP R3 will support Oracle 9.x? And, No, and I doubt it. 2) Has anyone implemented table partitions as a method of space management in conjunction SAP archiving? The table dependencies within SAP Archive objects would seem to make this difficult at best? Considered it, but haven't researched. Have you tried service.sap.com? Or whatever the support url is. Jared Thanks for any feedback. Mike Hand Polaroid Corp - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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
With regards to any creativity embedded in the BDBAFH thread that I might have contributed, those who have read the BOFH saga will recognize that I copied a segment (almost!) word-for-word from Simon Travaglia's original text. If you haven't read the BOFH sagas, they are a scream (flash to visual of Edvard Munch's masterpiece) and highly recommended. Especially the bit about electrocuting inexperienced hardware repair people using waffle irons. There are numerous BOFH compilations on the net -- just go to www.google.com and enter the keyword bofh. --- With regards to language and the assignment of gender to nouns (like bastard), I'd like to pass along the following, with thanks to Michael Moller (of the Oak Table network) for passing it along recently, but with ultimate thanks to persons unknown... ***===*** A language teacher was explaining to her class that in French, nouns unlike their English counterparts, are grammatically designated as masculine or feminine. House in French, is feminine-la maison. Pencil in French, is masculine-le crayon. One puzzled student asked, What gender is the word 'computer'? The teacher did not know, and the word was not in her French dictionary. So for fun she split the class into two groups appropriately enough, by gender, and asked them to decide whether computer should be a masculine of a feminine noun. Both groups were required to give four reasons for their recommendation. The men's group decided that computer should definitely be of the feminine gender (i.e. la computer), because: 1. No one but their creator understands their internal logic 2. The native language they use to communicate with other computers is incomprehensible to everyone else 3. Even the smallest mistakes are stored in long-term memory for possible later retrieval 4. As soon as you make a commitment to one, you find yourself spending half your paycheck on accessories for it. The women's group, however, concluded that computers should be masculine (i.e. 'le computer) because: 1. In order to do anything with them, you have to turn them on 2. They have a lot of data but still can't think for themselves 3. They are supposed to help you solve problems, but half the time they ARE the problem 4. As soon as you commit to one, you realize that if you had waited a little longer, you could have gotten a better model. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 10:04 AM I believe that BASTARD can be applied equally to male or female. From Webster (slightly edited): 1 : an illegitimate child 2 : something that is spurious, irregular, inferior, or of questionable origin 3 : an offensive or disagreeable person -- used as a generalized term of abuse -Original Message- Sent: Friday, September 27, 2002 9:34 AM To: Multiple recipients of list ORACLE-L On a more serious note: - a voice mail should be sufficient - next morning: -- a one page post mortem document -- a note inviting interested parties to a post mortem meeting A formal post mortem process benefits: - if a problem re-occurs it is easier to deal with it - there may be a permanent solution to it - clients and managers feel more confident and with time will stop asking for details (which they do not understand anyway) - all problems are documented in a standardise manner, which allows for -- re-negotiation of service level agreements and prices when applicable -- meaningful end year performance reviews (probably more important) inka P.S. The acronym stands for Bastard DBA from Hell - I am outraged! What a male chauvinistic world. I have a master degree in being from hell, working on Ph.D. -Original Message- Sent: Friday, September 27, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Must say I liked Inka's notion of calling all interested parties with details, though it could be income threatening =:-0 Maybe a compromise would be to agree some type of SOP for such situations and have the interested callers list put in there. I mean if they are so keen to know first thing next morning... OTOH, why not send a summary e-mail to interested parties and tell them you'll fill in any gaps when you have caught up on lost time. If the problem has been resolved, details of how are of a mainly historical nature anyhow - right? Tim: Can you give me the ISBN's to some of your novels. What!!! You haven't written any yet! - A waste of talent ;) Thanks for the homour in any case. PS: The BDBAFH has gone right over my head. My psyche is suggesting it's profane. What does it stand for? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman 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
RE: Oracle/SQL Server on same box
They can be on the same box but memory and CPU may be an issue since they both like hog each. Dave -Original Message- Sent: Friday, September 27, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they conflict? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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: Farnsworth, Dave 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
and as long as we're coming clean, i too plagiarized. mine from the very first post in the BOFH saga i believe. but blame Mladen - he got us started. --- Original Message --- Date: Fri, 27 Sep 2002 08:49:06 -0800 With regards to any creativity embedded in the BDBAFH thread that I might have contributed, those who have read the BOFH saga will recognize that I copied a segment (almost!) word-for-word from Simon Travaglia's original text. If you haven't read the BOFH sagas, they are a scream (flash to visual of Edvard Munch's masterpiece) and highly recommended. Especially the bit about electrocuting inexperienced hardware repair people using waffle irons. There are numerous BOFH compilations on the net -- just go to www.google.com and enter the keyword bofh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: STEVE OLLIG 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:
OK, here's the obligatory, ARE YOU AN IDIOT? Farnsworth, Dave [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/27/2002 08:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: HELP -Original Message- Sent: Friday, September 27, 2002 10:13 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: Farnsworth, Dave 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:RE: Oracle/SQL Server on same box
Oracle won't care, but I can't speak for SQL*server. MicroSoft has a habit of being non-compatible. Dick Goulet Reply Separator Author: Farnsworth; Dave [EMAIL PROTECTED] Date: 9/27/2002 9:19 AM They can be on the same box but memory and CPU may be an issue since they both like hog each. Dave -Original Message- Sent: Friday, September 27, 2002 11:56 AM To: Multiple recipients of list ORACLE-L Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they conflict? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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: Farnsworth, Dave 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: datafile sizing question
If I'm feeling particularly AR, or just want to revel in the fact that I can do simple multiplication and addition without error, I'll figure the datafile size to the byte. e.g. 200m + 64k for an LMT is 2097217536 bytes. On NT I tend to use NNNMm on 8.0 and NNNM on 8i LMT's where the extent size is 4m or less, as 4m isn't enough space to worry about wasting. Unless of course, I'm feeling particular AR. Jared Hand, Michael T [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/26/2002 08:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: datafile sizing question I also have a just curious question. Do most interchange the values 1000K for 1M or 1000M for 1G? I try to be precise in my usage, but I guess that's just the AR size of my personality. OK, I'll go find my pills now. ;) By the way, we use a maximum size of 4Gb+8k file size but, I've never has a reason to doubt the DEC/Compaq 64bit file systems. Mike -Original Message- Sent: Thursday, September 26, 2002 5:03 AM To: Multiple recipients of list ORACLE-L We tend to use multiples of 1Gb and add 1 Mb to the file so that we get 2001, 10001 Mb etc Solaris 2.8 LMT uniform extents range from 64K to 20Mb John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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/SQL Server on same box
yes, but not recommended for busy systems. ok for sandbox though. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:56 AM Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they conflict? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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: Steve Perry 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: Changing the Staus of a Database to Read Only
Hi Ian... I can tell you how it works in 8.1.7... You can alter a tablespace to read only with transactions in the database and the steps are as follows: You issue the alter to read only command and it will wait for EVERY transaction in the database that started BEFORE you issued the command to finish before the alter is completed. Any transaction that starts after you issue the command is cleanly handled. If it is on the tablespace you are attempting to alter it will fail. If it is on another tablespace it will not have impact on your alter command. i.e. Trans 1 on Tablespace X Trans 2 on Tablespace Y Alter Tablespace Y to read only ( it waits ) End Trans 2 Notice Alter is still waiting Attempt to start Trans 3 on Tablespace Y ( You will get an error ) Start Trans 4 on Tablespace X End Trans 1 Notice Alter completes HTH Tim -Original Message- Sent: Friday, September 27, 2002 1:09 PM To: Multiple recipients of list ORACLE-L I tried to post this in response to the Best Practices thread, but for unkown reasons it didn't seem to make it. My apologies if this is a repeat. It had been stated that placing each partition in a separate tablespace allowed one to make a tablespace read only once that partition would no longer be used for insert/update/delete operations. I have not tried to switch a database from online to read only after 8.1.6, but as of that release doing so was difficult in an active database. Oracle required not only that there be no active transactions against the tablspace to be converted but no such transactions against the entire database. If this has changed, when did it happen? We have a system where the ability to make a tablespace read only while the database is actively processing transactions bound for other tablespaces would be extremely useful. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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 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: Johnston, Tim 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: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand
Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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-dba.com domain
but your outbid already by someone in the UK :) joe Adams, Matthew (GEA, MABG, 088130) wrote: I got the first bid in!!! Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- *From:* JOE TESTA [mailto:[EMAIL PROTECTED]] *Sent:* Thursday, September 26, 2002 4:11 PM *To:* Multiple recipients of list ORACLE-L *Subject:* oracle-dba.com domain email me at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Procedural Consistency
Dan, The default is for oracle to determine this by timestamp. You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter. This may not apply to your situation as I don't know if it applies to dependencies on a local database as well. e.g. ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = {SIGNATURE | TIMESTAMP} It's in the Oracle 8i Application Developer's Guide. Jared Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Procedural Consistency Okay, I know I'm being a little lazy on this one, but I'm very interested to hear the ideas/conjecture/proof. So away we go We recently encountered a bug in Oracle where a long running process attempted to execute a procedure that was within a package that had been recompiled since the process had first executed the procedure. This brings up the question as to whether the kernel requires that each time the process executes the procedure that the procedure is exactly the same as when the process first executed it. If so, how does the process keep track of the version of the procedure that it has previously executed? Any input/thoughts are greatly appreciated... Dan -- 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: Deadlocks on lack of Foreign key indexes ...
Jared, Thank You . Tom Kytes book pages 108 to 111 goes into this. I will continue to follow this advice. Mike -Original Message- Sent: Friday, September 27, 2002 8:43 AM To: Multiple recipients of list ORACLE-L I always use indexes on FK's. If it's a table with many updates, it needs them to avoid locks on the table. If the table doesn't have many updates, it's not really necessary, but it doesn't hurt either, and that way I don't have to figure out if it's busy enough to warrant the index. :) Jared On Thursday 26 September 2002 17:43, Johnson, Michael wrote: Does anyone consider it essential to put indexes on Foreign Keys or is it just an option to safeguard against the rare possiblity of a deadlock ? Is this possibility real and have you seen it happen ? I am one who does not want to create a foreign index as their is already one wih a leading column which makes this foreign key index redundant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Johnson, Michael 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).
Goldilocks repost, please?
Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find it in the fatcity.com archives (search is subject-only!), and I'm guessing that Rachel's offline, given Her recent post. As I'm delving into this, I seem to remember from those posts that we're too small for a Papa Bear LMT, but I don't remember what the posted guidelines were. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
role naming conventions
Oracle seems to be inconsistant in the way it names roles: SQL select role, GRANTED_ROLE from ROLE_ROLE_PRIVS; ROLE GRANTED_ROLE -- -- DBADELETE_CATALOG_ROLE DBAEXECUTE_CATALOG_ROLE DBAEXP_FULL_DATABASE DBAIMP_FULL_DATABASE DBASELECT_CATALOG_ROLE EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE EXP_FULL_DATABASE SELECT_CATALOG_ROLE IMP_FULL_DATABASE EXECUTE_CATALOG_ROLE IMP_FULL_DATABASE SELECT_CATALOG_ROLE OEM_MONITORCONNECT Sometimes it's _ROLE and sometimes it not. Any strong recommendataion for local names of roles? Is there a good guide to naming in general? Thanks. === 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).
Re: Selecting Next X Values From Dual
Anjo... Thanks for the reply!! If X is fixed for all sessions, do a step increase of X so that you only have to select 1 row from dual. Unfortunately, I don't feel I can do that. I'm using the returned values as unique identifiers to protect against duplicate database submissions from a web-based application. I have implemented a workaround by selecting a row from dual X number of times. I wanted something a bit cleaner, and [seemingly] less database-intensive than querying in a loop. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: OT: For the MicroSoft bashers
They got that changed rather quickly. MS is no where on the first page now. IF you combine go to hell with Microsoft you get 7 hits but the top 2 are sites commenting on this story. Ain't it great to have clout. dgoulet @vicr.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: OT: For the MicroSoft bashers 09/25/2002 02:03 PM Please respond to ORACLE-L Google search leads to Gates of 'hell' Type go to hell (using the quotation marks) into Google's search engine, and the first result served up is Microsoft.com. http://computerworld.com/newsletter/0%2C4902%2C74566%2C0.html?nlid=AM -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: Should I post a preview of Oracle9i RMAN Backup and Recovery
Thanks Ruth, I may have some legal issues with posting it on the newsgroup, and I'm trying to work that out with OP right now. They want to post it, but I have to have the list owner agree to it, and the item posted has to go through some changes. With the nature of news groups, it may not be practical. I may have to get a web site to post it. (Joe Testa, would you be interested if your site is still up and running)?? Of course, once it's up on Amazon there will be previews available there. I'm really excited about the book. It's going to print Monday, and will be out in time for OOW. The rush to get it out for OOW was MURDER, but I think it will be worth it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, September 27, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Recovery Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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: Freeman, Robert 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: Changing the Staus of a Database to Read Only
Thanks. I believe that's how it works on 8.1.6 as well. Of course if someone has walked away without committing a transaction then one is still stuck. There is also the problem of distributed queries. If on database A, one selects from table_name@B. An entry is made into the transaction table on database A. That transaction entry will stay until the session on A which issued the distributed query commits. I can almost guarantee that at least one user will have failed to commit when it comes to changing a tablespace to read only, and that user will be unreachable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, September 27, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Hi Ian... I can tell you how it works in 8.1.7... You can alter a tablespace to read only with transactions in the database and the steps are as follows: You issue the alter to read only command and it will wait for EVERY transaction in the database that started BEFORE you issued the command to finish before the alter is completed. Any transaction that starts after you issue the command is cleanly handled. If it is on the tablespace you are attempting to alter it will fail. If it is on another tablespace it will not have impact on your alter command. i.e. Trans 1 on Tablespace X Trans 2 on Tablespace Y Alter Tablespace Y to read only ( it waits ) End Trans 2 Notice Alter is still waiting Attempt to start Trans 3 on Tablespace Y ( You will get an error ) Start Trans 4 on Tablespace X End Trans 1 Notice Alter completes HTH Tim -Original Message- Sent: Friday, September 27, 2002 1:09 PM To: Multiple recipients of list ORACLE-L I tried to post this in response to the Best Practices thread, but for unkown reasons it didn't seem to make it. My apologies if this is a repeat. It had been stated that placing each partition in a separate tablespace allowed one to make a tablespace read only once that partition would no longer be used for insert/update/delete operations. I have not tried to switch a database from online to read only after 8.1.6, but as of that release doing so was difficult in an active database. Oracle required not only that there be no active transactions against the tablspace to be converted but no such transactions against the entire database. If this has changed, when did it happen? We have a system where the ability to make a tablespace read only while the database is actively processing transactions bound for other tablespaces would be extremely useful. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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 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: Johnston, Tim 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: MacGregor, Ian A. 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: Procedural Consistency
Thanks, I'll take a look.. -Original Message- Sent: Friday, September 27, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Dan, The default is for oracle to determine this by timestamp. You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter. This may not apply to your situation as I don't know if it applies to dependencies on a local database as well. e.g. ALTER SESSION SET REMOTE_DEPENDENCIES_MODE = {SIGNATURE | TIMESTAMP} It's in the Oracle 8i Application Developer's Guide. Jared Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Procedural Consistency Okay, I know I'm being a little lazy on this one, but I'm very interested to hear the ideas/conjecture/proof. So away we go We recently encountered a bug in Oracle where a long running process attempted to execute a procedure that was within a package that had been recompiled since the process had first executed the procedure. This brings up the question as to whether the kernel requires that each time the process executes the procedure that the procedure is exactly the same as when the process first executed it. If so, how does the process keep track of the version of the procedure that it has previously executed? Any input/thoughts are greatly appreciated... Dan -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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: Selecting Next X Values From Dual
I created a package that would easily loop thru and select x number of entries, but not return them in a select to you. This way, you can make 1 simple call passing it X. Is that what you wanted ??? Or do you have to have them as returned values of a select ? Kevin -Original Message- Sent: Friday, September 27, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Anjo... Thanks for the reply!! If X is fixed for all sessions, do a step increase of X so that you only have to select 1 row from dual. Unfortunately, I don't feel I can do that. I'm using the returned values as unique identifiers to protect against duplicate database submissions from a web-based application. I have implemented a workaround by selecting a row from dual X number of times. I wanted something a bit cleaner, and [seemingly] less database-intensive than querying in a loop. Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: Kevin Lange 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: Procedural Consistency
The app was getting an ORA-600, which metalink identified as a 'bug' in 9i. The app uses persistent connections and the 'login' package had been recompiled without removing the connections. All of a sudden the ORA-600s started being thrown. It made me curious (call me George) as to how Oracle handles code consistency in procedures. The scenario I pondered was that a proc is called within a loop. At some point while the loop is being executed by a calling app, the proc is changed. This could cause the app to alter the handling of the data and produce inconsistent results. Since the proc's execution is complete, is the proc still pinned? Just trying to understand a little more about oracle internals... -Original Message- Sent: Thursday, September 26, 2002 4:58 AM To: Multiple recipients of list ORACLE-L What is the error and how is the error occuring? My experience has been: 1. Long running SQL calling PL/SQL function:will die due to invalidated state of the function. 2. Long running PL/SQL calling PL/SQL procedure (statically): cannot re-compile the procedure during the run as it is pinned. 3. Long running PL/SQL calling PL/SQL procedure (dynamically): will just run whatever procedure exists at the time of the call. - Bill. At 12:43 24/09/2002 -0800, you wrote: Okay, I know I'm being a little lazy on this one, but I'm very interested to hear the ideas/conjecture/proof. So away we go We recently encountered a bug in Oracle where a long running process attempted to execute a procedure that was within a package that had been recompiled since the process had first executed the procedure. This brings up the question as to whether the kernel requires that each time the process executes the procedure that the procedure is exactly the same as when the process first executed it. If so, how does the process keep track of the version of the procedure that it has previously executed? Any input/thoughts are greatly appreciated... Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan 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: Fink, Dan 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: datafile sizing question
this is the first time I've NOT figured the file size the AR way :) --- [EMAIL PROTECTED] wrote: If I'm feeling particularly AR, or just want to revel in the fact that I can do simple multiplication and addition without error, I'll figure the datafile size to the byte. e.g. 200m + 64k for an LMT is 2097217536 bytes. On NT I tend to use NNNMm on 8.0 and NNNM on 8i LMT's where the extent size is 4m or less, as 4m isn't enough space to worry about wasting. Unless of course, I'm feeling particular AR. Jared Hand, Michael T [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/26/2002 08:33 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: datafile sizing question I also have a just curious question. Do most interchange the values 1000K for 1M or 1000M for 1G? I try to be precise in my usage, but I guess that's just the AR size of my personality. OK, I'll go find my pills now. ;) By the way, we use a maximum size of 4Gb+8k file size but, I've never has a reason to doubt the DEC/Compaq 64bit file systems. Mike -Original Message- Sent: Thursday, September 26, 2002 5:03 AM To: Multiple recipients of list ORACLE-L We tend to use multiples of 1Gb and add 1 Mb to the file so that we get 2001, 10001 Mb etc Solaris 2.8 LMT uniform extents range from 64K to 20Mb John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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).
Can I do this in Oracle 8i?
Hi. I want to update a table based on data in another table. Something like: update table1 a set f1 = (select f2 from table2 where table2.f3 = table1.f3 and table2.f4 = table1.f4); this seems to work, but generates a lot of redo logs. So I tried to add NOLOGGING. Alas, seems like NOLOGGING and alias don't tolerate each other. I haven't been able to run an Update with both alias and NOLOGGING. Is that something that Oracle restricts or did I not try hard enough? Any suggestions? TIA Gene __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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).
Setting Cursor Sharing = Force in 8.1.7.3
We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Goldilocks repost, please?
I'm here.. was away for a day but you guys flood my inbox :) goldilocks was the name I gave to the methodology of small/medium/large tablespace sizing. There was no hard and fast rule for how big each of these tablespaces should be, nor was there one for the extent sizes. Just that if a table was too big for small and too small for big then medium would be just right, just like Goldilocks. --- Jesse, Rich [EMAIL PROTECTED] wrote: Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find it in the fatcity.com archives (search is subject-only!), and I'm guessing that Rachel's offline, given Her recent post. As I'm delving into this, I seem to remember from those posts that we're too small for a Papa Bear LMT, but I don't remember what the posted guidelines were. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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).
DB link to DB2 on an AS400
I have been asked by damagement on the possibility of of linking Oracle to DB2 so that an Oracle trigger can update a DB2 table. I have been reading some of the fine manual along with reading stuff on metalink. From what I can tell in order to connect to nonOracle data I need to use Oracles Transparent gateway to create a DB link to DB2. Also I would guess this will cost extra to use the Transparent gateway. Are these correct assumptions? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: extremely long parse time
Title: extremely long parse time Matt, Is it Oracle 9? If yes, time is in microseconds. Alex. -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: extremely long parse time why would a query take 148 seconds to parse? It is a two way union where the first half is going against all_tables and the second half is a join between all_indexes and all_ind_columns. The shared pool has 50M large parts of it are free. I generated a 10046 (level 12) trace, and I just don't see anything out of whack, except of the c=14868 in the PARSE #1 line. Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams
Re[2]: OT: For the MicroSoft bashers
What do you expect? When the god Gates speaks the feeble move. Reply Separator Author: Thomas Day [EMAIL PROTECTED] Date: 9/27/2002 11:33 AM They got that changed rather quickly. MS is no where on the first page now. IF you combine go to hell with Microsoft you get 7 hits but the top 2 are sites commenting on this story. Ain't it great to have clout. dgoulet @vicr.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: OT: For the MicroSoft bashers 09/25/2002 02:03 PM Please respond to ORACLE-L Google search leads to Gates of 'hell' Type go to hell (using the quotation marks) into Google's search engine, and the first result served up is Microsoft.com. http://computerworld.com/newsletter/0%2C4902%2C74566%2C0.html?nlid=AM -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: Selecting Next X Values From Dual
I created a package that would easily loop thru and select x number of entries, but not return them in a select to you. This way, you can make 1 simple call passing it X. Is that what you wanted ??? Or do you have to have them as returned values of a select ? I would need the values returned through select, if I'm correctly understanding you (it's a web-based application). I thought of doing something like: SELECT sequence.nextval FROM table WHERE ROWNUM x It just seems too kludgy, and I didn't think creating a table with dummy data for the count would be a good way to go. Any suggestions? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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: OT: For the MicroSoft bashers
H...even after flushing the cache, MS is still the top link for me on Google (except for the news stories). Rich -Original Message- From: Thomas Day [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT: For the MicroSoft bashers They got that changed rather quickly. MS is no where on the first page now. IF you combine go to hell with Microsoft you get 7 hits but the top 2 are sites commenting on this story. Ain't it great to have clout. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Can I do this in Oracle 8i?
NOLOGGING does not work on update, period. has nothing to do with aliases. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 3:48 PM Hi. I want to update a table based on data in another table. Something like: update table1 a set f1 = (select f2 from table2 where table2.f3 = table1.f3 and table2.f4 = table1.f4); this seems to work, but generates a lot of redo logs. So I tried to add NOLOGGING. Alas, seems like NOLOGGING and alias don't tolerate each other. I haven't been able to run an Update with both alias and NOLOGGING. Is that something that Oracle restricts or did I not try hard enough? Any suggestions? TIA Gene __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: Igor Neyman 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: Changing the Staus of a Database to Read Only
Exactly... I had to face this at my current job... I have a separate alter to read only job... Basically, it is a script that calls a stored procedure... I put the script in cron to run every 12 hours... The stored procedure alters eligible tablespaces to read only (eligible as defined by the product)... If an alter to read only hangs for more then 12 hours then the next alter to read only sends a messages (i.e. email or trap) to let you know the condition exists... If there are no tablespaces to alter then the procedure simply exits... And, since it is async then it really doesn't matter if it hangs since it won't hold anything else up... The only problem is that is the database crashes while the file is pending read only, the file needs media recovery on restart... Tim -Original Message- Sent: Friday, September 27, 2002 3:24 PM To: Multiple recipients of list ORACLE-L Thanks. I believe that's how it works on 8.1.6 as well. Of course if someone has walked away without committing a transaction then one is still stuck. There is also the problem of distributed queries. If on database A, one selects from table_name@B. An entry is made into the transaction table on database A. That transaction entry will stay until the session on A which issued the distributed query commits. I can almost guarantee that at least one user will have failed to commit when it comes to changing a tablespace to read only, and that user will be unreachable. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Friday, September 27, 2002 11:03 AM To: Multiple recipients of list ORACLE-L Hi Ian... I can tell you how it works in 8.1.7... You can alter a tablespace to read only with transactions in the database and the steps are as follows: You issue the alter to read only command and it will wait for EVERY transaction in the database that started BEFORE you issued the command to finish before the alter is completed. Any transaction that starts after you issue the command is cleanly handled. If it is on the tablespace you are attempting to alter it will fail. If it is on another tablespace it will not have impact on your alter command. i.e. Trans 1 on Tablespace X Trans 2 on Tablespace Y Alter Tablespace Y to read only ( it waits ) End Trans 2 Notice Alter is still waiting Attempt to start Trans 3 on Tablespace Y ( You will get an error ) Start Trans 4 on Tablespace X End Trans 1 Notice Alter completes HTH Tim -Original Message- Sent: Friday, September 27, 2002 1:09 PM To: Multiple recipients of list ORACLE-L I tried to post this in response to the Best Practices thread, but for unkown reasons it didn't seem to make it. My apologies if this is a repeat. It had been stated that placing each partition in a separate tablespace allowed one to make a tablespace read only once that partition would no longer be used for insert/update/delete operations. I have not tried to switch a database from online to read only after 8.1.6, but as of that release doing so was difficult in an active database. Oracle required not only that there be no active transactions against the tablspace to be converted but no such transactions against the entire database. If this has changed, when did it happen? We have a system where the ability to make a tablespace read only while the database is actively processing transactions bound for other tablespaces would be extremely useful. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- 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 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: Johnston, Tim 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: MacGregor, Ian A. INET: [EMAIL
Re: Goldilocks repost, please?
For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken from the paper How to Stop Defragmenting and Start Living. Can't remember the author but I'm sure someone will chime in as it's a well-known paper. Cherie Machler Oracle DBA Gelco Information Network Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Goldilocks repost, please? Sent by: [EMAIL PROTECTED] om 09/27/02 03:08 PM Please respond to ORACLE-L I'm here.. was away for a day but you guys flood my inbox :) goldilocks was the name I gave to the methodology of small/medium/large tablespace sizing. There was no hard and fast rule for how big each of these tablespaces should be, nor was there one for the extent sizes. Just that if a table was too big for small and too small for big then medium would be just right, just like Goldilocks. --- Jesse, Rich [EMAIL PROTECTED] wrote: Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find it in the fatcity.com archives (search is subject-only!), and I'm guessing that Rachel's offline, given Her recent post. As I'm delving into this, I seem to remember from those posts that we're too small for a Papa Bear LMT, but I don't remember what the posted guidelines were. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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
RE: Goldilocks repost, please?
Can someone please repost the Goldilocks LMT Sizing Guideline? That's from a tar on Metalink... doc 12988.2 (I think) ;- bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Can I do this in Oracle 8i?
Your update is updating all rows in table1. Is that what you want ? nologging only works with direct path insert, not with update. --- Gurelei [EMAIL PROTECTED] a écrit : Hi. I want to update a table based on data in another table. Something like: update table1 a set f1 = (select f2 from table2 where table2.f3 = table1.f3 and table2.f4 = table1.f4); this seems to work, but generates a lot of redo logs. So I tried to add NOLOGGING. Alas, seems like NOLOGGING and alias don't tolerate each other. I haven't been able to run an Update with both alias and NOLOGGING. Is that something that Oracle restricts or did I not try hard enough? Any suggestions? TIA Gene __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Setting Cursor Sharing = Force in 8.1.7.3
Nat You may want to take a look at: http://www.interealm.com/roby/technotes/cursor_sharing.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 27, 2002 3:13 PM To: Multiple recipients of list ORACLE-L We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: DENNIS WILLIAMS 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: Setting Cursor Sharing = Force in 8.1.7.3
I went thru this recently ... The best thing to do is to FORCE the developers to use bind variables and then this is no longer an issue. If you do set it to FORCE , I believe there is a problem with it in versions 8.1.6 and before and it should not be used.Double Check with Metalink on this. FWIW ... Mike -Original Message- Sent: Friday, September 27, 2002 1:13 PM To: Multiple recipients of list ORACLE-L We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Johnson, Michael 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: Setting Cursor Sharing = Force in 8.1.7.3
Make them use bind variables. Even if cursor_sharing did work correctly (it might in 8.1.7, but I don't remember), using bind variables will relieve the Oracle kernel of a lot of work (i.e., response time). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Sent: Friday, September 27, 2002 3:13 PM To: Multiple recipients of list ORACLE-L We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Cary Millsap 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: Degrade a database??
Reminds of a user who wanted to ungrade to Win98. They didn't know how right they were. Rajesh.Rao @jpmchase.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Re: Degrade a database?? 09/27/2002 12:23 PM Please respond to ORACLE-L Of course, I meant downgrade. Could you hire me to work for you? ;-) Connor McDonald To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hamcdc@yahoocc: .co.uk Subject: Re: Degrade a database?? Sent by: root@fatcity. com September 27, 2002 05:28 AM Please respond to ORACLE-L If I wanted to degrade a database, I'd take it out to a cheap pub, get it drunk, and let it make a fool of itself on the dancefloor before taking it home for some wild bedroom scenes... Next morning, rest assured, the database will roll over in your bed and exclaim: I'll feel so degraded :-) --- [EMAIL PROTECTED] wrote: Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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: Goldilocks repost, please?
Juan Loaiza, Rosanne Toohey, and Bhaskar Himatsingka. The paper's online at www.hotsos.com/catalog. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- [EMAIL PROTECTED] Sent: Friday, September 27, 2002 4:09 PM To: Multiple recipients of list ORACLE-L For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken from the paper How to Stop Defragmenting and Start Living. Can't remember the author but I'm sure someone will chime in as it's a well-known paper. Cherie Machler Oracle DBA Gelco Information Network Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Goldilocks repost, please? Sent by: [EMAIL PROTECTED] om 09/27/02 03:08 PM Please respond to ORACLE-L I'm here.. was away for a day but you guys flood my inbox :) goldilocks was the name I gave to the methodology of small/medium/large tablespace sizing. There was no hard and fast rule for how big each of these tablespaces should be, nor was there one for the extent sizes. Just that if a table was too big for small and too small for big then medium would be just right, just like Goldilocks. --- Jesse, Rich [EMAIL PROTECTED] wrote: Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find it in the fatcity.com archives (search is subject-only!), and I'm guessing that Rachel's offline, given Her recent post. As I'm delving into this, I seem to remember from those posts that we're too small for a Papa Bear LMT, but I don't remember what the posted guidelines were. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap 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
RE:
OK, here's the obligatory, ARE YOU AN IDIOT? HELP SET ORACLE-L NOMAIL I think what Jared may have meant to say is me here trying to be funny... All LIST commands should be sent to [EMAIL PROTECTED] NOT [EMAIL PROTECTED] You recied a help message whan you subscribed to the effect Bob Have a good weekend all! E.g # 5) Commonly used mailing list server commands The mailing list server software in use at fatcity.com is ListGuru. ListGuru accepts most commands from all major mailing list servers, including Listserv, ListProc, Majordomo, MailBase and SmartList (among others). All messages to the mailing list server MUST be addressed to only one address, however: [EMAIL PROTECTED]-- Note EXACT spelling of 'ListGuru' Mailing list commands must be included in the message body, not the Subject line. Commands on the Subject line are ignored. Multiple commands can be included in a single message. You may send as many messages as you wish. A short description of the most commonly used commands follows. For a complete list of all commands available, use the HELP command to obtain more detailed information. In all commands below, list refers to a name of a valid mailing list name (for example, ORACLE-L ). Command FormatWhat it does -- --- HELP Sends complete ListGuru command information LISTS Sends a list of all available lists at this site UNSUB list Unsubscribes the subscriber from the list SET list NOMAIL Temporarily turns off messages to the subscriber SET list MAIL Resumes mail flow to the subscriber CONFIRM listConfirms a subscription to a particular list WHICH Shows ALL lists that a user is subscribed to SET list DIGEST Turns on DIGEST mode for a list (if available) SET list NODIGEST Returns to normal (single message) mode for a list INDEX list Lists all available archive files for a list END Discontinues further command processing (useful if you have long signature sections). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Goldilocks repost, please?
Rich - The paper that started it all (as far as I know), How to Stop Defragmenting and Start Living posted at: http://otn.oracle.com/deploy/availability/pdf/defrag.pdf Suggests for Oracle 8 and above that the uniform extents be one of three sizes: 128k, 4m, and 128m, and it explains why you should stick to those sizes. The hard part is getting away from your old habit of trying to keep to the minimum number of extents. If your table is 3-meg, you tend to want to stick it in a tablespace with the 4m extents so it all fits in a single extent. But then if the file expands past 4m, you get another 4m extent that is mostly empty. Old habits are hard to change. Or is it just old DBAs? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 27, 2002 3:08 PM To: Multiple recipients of list ORACLE-L I'm here.. was away for a day but you guys flood my inbox :) goldilocks was the name I gave to the methodology of small/medium/large tablespace sizing. There was no hard and fast rule for how big each of these tablespaces should be, nor was there one for the extent sizes. Just that if a table was too big for small and too small for big then medium would be just right, just like Goldilocks. --- Jesse, Rich [EMAIL PROTECTED] wrote: Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find it in the fatcity.com archives (search is subject-only!), and I'm guessing that Rachel's offline, given Her recent post. As I'm delving into this, I seem to remember from those posts that we're too small for a Papa Bear LMT, but I don't remember what the posted guidelines were. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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 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: DENNIS WILLIAMS 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: Setting Cursor Sharing = Force in 8.1.7.3
I recently used it on 8.1.7.4 and 9i. I gained 33% performance gain. It would be different depending on how much literal SQL is used in your code. My process ran fine, and I was able to load the data. However, I have not fully checked the data yet. Shakir --- Johnson, Michael [EMAIL PROTECTED] wrote: I went thru this recently ... The best thing to do is to FORCE the developers to use bind variables and then this is no longer an issue. If you do set it to FORCE , I believe there is a problem with it in versions 8.1.6 and before and it should not be used.Double Check with Metalink on this. FWIW ... Mike -Original Message- Sent: Friday, September 27, 2002 1:13 PM To: Multiple recipients of list ORACLE-L We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat 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: Johnson, Michael 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: Library object/cache locks?
This is from Steve Adam's Oracle 8i Internal Services(page 50-51) Library cache locks are held in shared mode during parse operation. A pin is applied to the library cache object for a PL/SQL program unit or SQL statement while it is being compiled, parsed or executed. Pins are normally held in shared mode, but are also held in execlusive mode while the library cache information for the object is being changed. So my understanding is that, locks are applied during parse etc and pins during library cache information change. Hope this is correct. Shakir --- Walter K [EMAIL PROTECTED] wrote: Perhaps this is a rudimentary question but I haven't found any good info on this topic. Would someone please explain the difference between a library cache lock and a library cache pin? Is the first simply a dictionary lock on a physical object (i.e. table) whereas the second is a dictionary lock on a piece of code (i.e. procedure, function, trigger)? According to what I've read, I can query x$kgllk where kgllkreq=0 to find the library object locks in the database. How do I know if the lock is a library cache lock vs. a library cache pin, simply by inference due to the type of object? If I perform a systemstate dump and see 'mode=S' under a process, does that mean that the process has a 'share' lock on the object? If so, I'm confused as to why I don't see a corresponding lock in v$lock. Any info would be appreciated. Thanks VERY much in advance. -Walt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir 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: Setting Cursor Sharing = Force in 8.1.7.3
Title: RE: Setting Cursor Sharing = Force in 8.1.7.3 We had problems with FORCE setting on 901x. The query it was changing to bind variables was select to_char(sysdate,:b1) from dual / Now :b1 is a format mask supplied by developer. Initially it would work fine and then start throwing ORA-600. After analysis Oracle found that when first time a format mask was supplied, it allocated enough bytes to hold the value of the format mask e.g. 'MMDDYY', but next time if you used 'MMDD' it occasionally threw a fit, saying it can't fit 'MMDD' in space for 'MMDDYY', which makes sense, but it was actually an memory allocation problem. I think we received a patch to resolve that issue. It is so old, I can't even look it up in our TAR list. I don't know about the 8i part of it though. 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! *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.*1
RE: Goldilocks repost, please?
Thanks all! I've already got the doc d/l'd -- I just couldn't remember where I saw the numbers. All I could remember was Goldilocks! :) Hmmm...could be a case for an Oracle-based PDM ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Goldilocks repost, please? Juan Loaiza, Rosanne Toohey, and Bhaskar Himatsingka. The paper's online at www.hotsos.com/catalog. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- [EMAIL PROTECTED] Sent: Friday, September 27, 2002 4:09 PM To: Multiple recipients of list ORACLE-L For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken from the paper How to Stop Defragmenting and Start Living. Can't remember the author but I'm sure someone will chime in as it's a well-known paper. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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:
Bob, The 'ARE YOU AN IDIOT?' reply is required on this list when one encounters a help command sent to the list rather than the list manager software. It's from a thread from some time ago, and is meant in jest. Dave knows it, as well as many others. Now, you know it too. :) Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/27/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: OK, here's the obligatory, ARE YOU AN IDIOT? HELP SET ORACLE-L NOMAIL I think what Jared may have meant to say is me here trying to be funny... All LIST commands should be sent to [EMAIL PROTECTED] NOT [EMAIL PROTECTED] You recied a help message whan you subscribed to the effect Bob Have a good weekend all! E.g # 5) Commonly used mailing list server commands The mailing list server software in use at fatcity.com is ListGuru. ListGuru accepts most commands from all major mailing list servers, including Listserv, ListProc, Majordomo, MailBase and SmartList (among others). All messages to the mailing list server MUST be addressed to only one address, however: [EMAIL PROTECTED]-- Note EXACT spelling of 'ListGuru' Mailing list commands must be included in the message body, not the Subject line. Commands on the Subject line are ignored. Multiple commands can be included in a single message. You may send as many messages as you wish. A short description of the most commonly used commands follows. For a complete list of all commands available, use the HELP command to obtain more detailed information. In all commands below, list refers to a name of a valid mailing list name (for example, ORACLE-L ). Command FormatWhat it does -- --- HELP Sends complete ListGuru command information LISTS Sends a list of all available lists at this site UNSUB list Unsubscribes the subscriber from the list SET list NOMAIL Temporarily turns off messages to the subscriber SET list MAIL Resumes mail flow to the subscriber CONFIRM listConfirms a subscription to a particular list WHICH Shows ALL lists that a user is subscribed to SET list DIGEST Turns on DIGEST mode for a list (if available) SET list NODIGEST Returns to normal (single message) mode for a list INDEX list Lists all available archive files for a list END Discontinues further command processing (useful if you have long signature sections). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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).
Employment shifts in 2001
List - We have discussed the employment situation a lot over the past year, and I am still dismayed to hear of Oracle DBAs out of work. I found some interesting statistics that put the situation in perspective: In 2001, there were an estimated 10.4 million IT workers in the U.S. In 2001, 2.6 million IT workers were dismissed. In 2001, 2.1 million IT workers were hired. In 2002, there were an estimated 9.9 million IT workers in the U.S. This means that 1 in 4 IT professionals were laid off in 2001. Small wonder that some of those included DBAs. Of those laid off, 20% were not rehired (at least in IT). These figures are from: http://www2.cio.com/metrics/ The print magazine had a small summary box that I couldn't find online. Dennis Williams DBA 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 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: Selecting Next X Values From Dual
Gary Chambers wrote: I created a package that would easily loop thru and select x number of entries, but not return them in a select to you. This way, you can make 1 simple call passing it X. Is that what you wanted ??? Or do you have to have them as returned values of a select ? I would need the values returned through select, if I'm correctly understanding you (it's a web-based application). I thought of doing something like: SELECT sequence.nextval FROM table WHERE ROWNUM x It just seems too kludgy, and I didn't think creating a table with dummy data for the count would be a good way to go. Any suggestions? Why 'too kludgy' ? If you are inside a PL/SQL package have you though of a bulk collect into an array of numbers? -- 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).
RE: RAC (Real Application Clusters)
Greg, For the most part RAW is still a requirement for RAC. There are more Cluster File system Options now then there where 6 months ago. Windows/2000 - Oracle now provides a CFS. I believe you can download it from OTN. I don't have NT installed so I can't comment on its reliability or stability. Linux - Sistina has a CFS at $1000/node, Polyserv has a CFS and Oracle is currently developing a CFS for Linux. Sistina is certified for Oracle9i R1 and R2. I am not sure about Polyserv but I think it is certified. I currently use raw devices on Linux but should be installing Sistina sometime in October. AIX - has a CFS and it is certified by Oracle. Not sure if this for HACMP or RS6000/SP or both. HP - I don't think there is a CFS available for HP/UX but their newly acquired Compaq TRU64 and OpenVMS has a CFS. HP is eventually doing away with TRU64 so maybe they will roll this technology into their HP/UX MC cluster software. Solaris 2.7 and lower you will have to use raw devices. Solaris 2.8 and greater you can use Veritas DBE/AC 3.5, This package includes the Veritas Cluster Volume Manager, Cluster File System, Oracle Disk Manager (ODM, Formerly known as Quick/IO qio), and thier Cluster Server. This software currently supports Oracle9i R1 and R2. This software configuration is only supported on EMC 8XXX series towers(firmware 5567.35.20 or higher) and the Hitachi HDS 9910 and 9960 series( firmware 01-16-40-00/00 or higher). It also recommended you use JNI controllers. Your disk drives will also have to support SCSI-3 persistent reservations and the PR flag has to be set on the disks. The PR reservations are used for IO fencing in the case of any split-brain conditions. I am currently running RAC R1 and R2 using DBE/AC on SUN E6500's and I have been very impressed with their product. I am also running RAC on SUN e3500's using RAW and I have found that the CFS has made my life much easier. However if you choose to use shared Oracle homes you can have problems with Oracle's IA. The IA doesn't like to share logs and the other files the IA creates and manages. You will have to create separate homes for the agent or symbolically link these files to local directories on these nodes. TRU64 has Context Dependent Symbolic Link (CDSL) facility to separate the $ORACLE_HOME/network directory from the shared Oracle home installation. This is employed by using a specific keyword in the filename (or a symbolic link) that distinguishes the name of the current member node of the cluster. The other thing I want to comment on is the RAC is implemented differently on different hardware. This is not true. RAC is implemented the same on all hardware. However there are some options that may implemented based on a particular platform. RAC Guard is an option that was specifically geared towards TRU64. In fact Oracle thought it worked so good they licensed the technology from COMPAQ TRU64 and implemented it in RAC guard II so it is available on all platforms. It is true that some platforms may implement clustering better than other platforms, but this is at the hardware level not necessarily at the Oracle level. Don't forget SQLNET with TAF. Besides OCI you also have to be able to use SQL*Net and thin drivers do not use either. Jesse, It's hard to say what questions to ask but if I was just learning the product I would stick to a few basic rules. If it appears to work like magic ask how they got it to work. If it sounds to good to be true, ask to have them back it up with facts. Has anyone done this before? Can they provide references? The thing is don't be afraid to ask any question. It is surprising how many people won't ask questions because they think it is stupid but everyone else is thinking the same thing. Also the answer may have information for you to ask another question. The other thing is that if something is said that you don't understand send it to this list. There is enough talent on this list to know when the smoke is blowing in California and it's not from the forest fires. One last item. Don't look for RAC to fix your application problems. If your application already has problems RAC won't fix that problem and if your application is not designed to scale then RAC will provide high availability but not scalibility. Scott --- Loughmiller, Greg [EMAIL PROTECTED] wrote: Push the question about the requirement of RAW devices.. and ask if Veritas's product can work without any restrictions.. The veritas clustered file system is supposedly ok to use with RAC where you can take advantage of using file systems. But I haven't seen confirmation of that. also-ask about the differences in the hardware they are showing you as compared to your environment.. There are some differences in the implementation based on the hardware You should probably get good feel on how Oracle believes RAC could fit into your environment. Are you looking for 100% availability? Or just scalability? Can the
Re: Employment shifts in 2001
How many went back to their old non-IT jobs before they moved into IT during the boom years when IT sucked people from the non-IT sector? ltiu DENNIS WILLIAMS wrote: List - We have discussed the employment situation a lot over the past year, and I am still dismayed to hear of Oracle DBAs out of work. I found some interesting statistics that put the situation in perspective: In 2001, there were an estimated 10.4 million IT workers in the U.S. In 2001, 2.6 million IT workers were dismissed. In 2001, 2.1 million IT workers were hired. In 2002, there were an estimated 9.9 million IT workers in the U.S. This means that 1 in 4 IT professionals were laid off in 2001. Small wonder that some of those included DBAs. Of those laid off, 20% were not rehired (at least in IT). These figures are from: http://www2.cio.com/metrics/ The print magazine had a small summary box that I couldn't find online. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ltiu 3/4 OCP 9i eH? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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).
[Q] imp/exp error on 9iR2?
I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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: Are you an idiot?
And besides, the Are you an idiot? question is redundant. After all, this *is* a DBA list... developer ducking for cover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Bob, The 'ARE YOU AN IDIOT?' reply is required on this list when one encounters a help command sent to the list rather than the list manager software. It's from a thread from some time ago, and is meant in jest. Dave knows it, as well as many others. Now, you know it too. :) Jared Bob Metelsky [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/27/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: OK, here's the obligatory, ARE YOU AN IDIOT? HELP SET ORACLE-L NOMAIL I think what Jared may have meant to say is me here trying to be funny... All LIST commands should be sent to [EMAIL PROTECTED] NOT [EMAIL PROTECTED] You recied a help message whan you subscribed to the effect Bob Have a good weekend all! E.g # 5) Commonly used mailing list server commands The mailing list server software in use at fatcity.com is ListGuru. ListGuru accepts most commands from all major mailing list servers, including Listserv, ListProc, Majordomo, MailBase and SmartList (among others). All messages to the mailing list server MUST be addressed to only one address, however: [EMAIL PROTECTED]-- Note EXACT spelling of 'ListGuru' Mailing list commands must be included in the message body, not the Subject line. Commands on the Subject line are ignored. Multiple commands can be included in a single message. You may send as many messages as you wish. A short description of the most commonly used commands follows. For a complete list of all commands available, use the HELP command to obtain more detailed information. In all commands below, list refers to a name of a valid mailing list name (for example, ORACLE-L ). Command FormatWhat it does -- --- HELP Sends complete ListGuru command information LISTS Sends a list of all available lists at this site UNSUB list Unsubscribes the subscriber from the list SET list NOMAIL Temporarily turns off messages to the subscriber SET list MAIL Resumes mail flow to the subscriber CONFIRM listConfirms a subscription to a particular list WHICH Shows ALL lists that a user is subscribed to SET list DIGEST Turns on DIGEST mode for a list (if available) SET list NODIGEST Returns to normal (single message) mode for a list INDEX list Lists all available archive files for a list END Discontinues further command processing (useful if you have long signature sections). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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). -- 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
Re: Should I post a preview of Oracle9i RMAN Backup and Recovery Hand
I would love to read that . bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:08 AM Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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: BigP 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: Should I post a preview of Oracle9i RMAN Backup and Recovery
Me too. Bing Wong Open Systems Database Administrator This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Friday, September 27, 2002 5:03 PM To: Multiple recipients of list ORACLE-L Recovery Hand I would love to read that . bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:08 AM Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Ruth Gramolini 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: BigP 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: Wong, Bing 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).
Cheap table lock?
Is Select ... For Update; a cheap table lock? It seems whenever code uses this statement all the records in the cursor are locked until the cursor is closed. __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot 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: [Q] imp/exp error on 9iR2?
It would appear you don't know the pw of sys, or maybe the capslock is on ;) If you can sqlplus /nolog can connect and alter the sys pw. Then you will know the sys pw and can use it on imp cmd. $ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL connect / as sysdba Connected. SQL alter user sys identified by change_on_install User altered. SQL On Fri, Sep 27, 2002 at 02:51:37PM -0800, dist cash wrote: I tried to do full database import use sys ID and have error come out. for sqlplus I can use sqlplus /nolog to avoid it, but on import/export how to avoid it? RSS::/home/app/oracle/admin/db92/export[173]% imp Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Username: sys Password: change_on_install IMP-00058: ORACLE error 28009 encountered ORA-28009: connection to sys should be as sysdba or sysoperUsername: Password: IMP-00058: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon deniedUsername: Thanks. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash 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).
Re: Cheap table lock?
On 2002.09.27 20:33 tony ynot wrote: Is Select ... For Update; a cheap table lock? It seems whenever code uses this statement all the records in the cursor are locked until the cursor is closed. Fancy that! It works as described in the manual! Who would say? -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala 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: ODBC limits
At 07:28 AM 9/27/2002, you wrote: I'm trying to get information of the limitations of ODBC drivers, specifically Oracle's and Microsoft's drivers for Oracle. Things like maximum no. of records they can fetch etc. I don't believe there's any limitation in the number of records you can get through ODBC, other than the amount of memory on the client. I've seen apps create resultsets that were very close to the limits of their clients without anything crashing. Note that there's at least one major problem using ODBC and Access. Access will always download the whole resultset to the client before starting to display it. When you're dealing with large data volumes, this is really unfortunate. You'll probably also need to play with the prefetch count if you're using ODBC with large data volumes. I don't think Access requests particularly large data chunks with every network round-trip. Since the Net8 protocol ACK's each data chunk, this can be a significant burden. If you're actually going to be pulling large chunks of data across the network, I would advise you to strongly consider writing the front-end. You're probably going to want to have the control necessary to optimize traffic across the wire, the way data is managed in memory, etc. You're not likely to get Random error messages trying to do this. Access may crash when it can't allocate additional memoy, things may be slow, etc. As I know very little about ODBC (which might be reflected in the nature of my question) I hope I'm asking a sensible question. I'm asking as there are some developers here who are getting a variety of error messages when dealing with large volumes of data from 8.1.7 DB into MS-Access. I'm trying there to ascertain where the problem lies, i.e. is it the driver, MS-Access, combination of both of these, or it's Microsoft what do you expect!!! Any (non-flame) feedback to useful web sites, white papers etc would be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). Justin Cave Distributed Database Consulting -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Cave 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: Selecting Next X Values From Dual
Stephane... Thanks for the reply. SELECT sequence.nextval FROM table WHERE ROWNUM x It just seems too kludgy, and I didn't think creating a table with dummy data for the count would be a good way to go. Any suggestions? Why 'too kludgy' ? If you are inside a PL/SQL package have you though of a bulk collect into an array of numbers? It seems kludgy to me to have a table of n-rows of dummy data to grab a specific number of values from a sequence. Is this a common practice? Gary Chambers //- // Lucent Technologies GIO/Unix // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers 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).