Error Install 9i Rel.2 on Windows 2000
I want to install Oracle 9i Rel. Database on Windows 2000 Professional. Error Message after clicking on setup.exe: The Java Runtime Environment was not found at bin\javaw.exe. Hence the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.3.1 or higher and try again. I've downloaded jre-1_1_8_009-win-i.exe and installed it to programme\oracle\jre\1.1.8 then i downloaded j2re-1_3_1_04-windows-i586-i.exe and installed it to programme\oracle\jre\1.3.1 . Same error after install. The Pc is an p4 Laptop, but i don't think this is a pentium 4 bug, because i just installed it an another Pentium 4 PC. What is the problem? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-1?Q?G=FCnter_Huerkamp?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: runInstaller Error ....
I did the setting for LD_LIBRARY_PATH and is not working. I also executed rda.sh script (REMOTE DIAGNOSTIC AGENT for UNIX), It came out with an error as follows: Argument LD_LIBRARY_PATH=/lib:/usr/local/oracle/817/lib:/usr/lib not recognized and was forced to exit. I don't know how /lib was picked up. When issued echo $LD_LIBRARY_PATH, it displayed as follows: /usr/local/oracle/817/lib:/usr/lib Please let me know how I should proceed with the error. Thanks, -- Babu -Original Message- Sent: Friday, July 26, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Babu Try setting LD_LIBRARY_PATH to $ORACLE_HOME/lib -Original Message- Sent: Friday, July 26, 2002 3:40 PM To: Multiple recipients of list ORACLE-L Dear list, When I execute runInstaller from /cdrom/disk1, I get the following error message: Initializing java virtual machine from /tmp/OraInstall/jre/bin/jre. Please wait... Class not found: LD_LIBRARY_PATH=/lib:/usr/lib Iam unable to start the installer. I unset LD_LIBRARY_PATH, and still getting the error. Iam installing 8.1.7.0.0(64bit) on Sun Sparc Solaris 2.8 (64bit). Please let me know if anyone has any ideas. Thanks, -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
1 way of getting creation time of tablespaces
SQL select a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b where a.file_id=b.file#; TABLESPACE_NAMECREATION_TI -- --- SYSTEM 22-MAR-2002 ROLLBACK 22-MAR-2002 TEMP 22-MAR-2002 TOOLS 22-MAR-2002 USERS 22-MAR-2002 hth, gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle 9i
Hi, Greg, JDBC driver 8i (thin) will not work with 9i. Regards, Vadim -Original Message- Sent: Thursday, July 25, 2002 11:23 AM To: Multiple recipients of list ORACLE-L Hi All! We will use Oracle 9i db and I would like to know if Oracle8i client works fine with 9i database? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing .... Continued
yes im aware -Original Message- Sent: Friday, July 26, 2002 9:09 AM To: Multiple recipients of list ORACLE-L * * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Beware of ORA-600, ORA-7445, and incorrect results w/CS=F on 8i! I've got it on 8.1.7.2 and we live with the possibilities. I get the most ORA-7445s when doing queries on the DD. This supposedly gets better with 8.1.7.3 and .4. We've also got one app that consistently returned WRONG results with CS=F (BUG 2225065). Tbe only workaround available is to turn it off for that app or upgrade to 9i. HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Subject: Cursor Sharing Continued Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing .... Continued
Take your case to management with that statistics of how long queries take with and without bind variables. Let them decide when to make the developers re-code their apps. If your management doesnt make them correct it then I dont know what to say from there.My management has said It will be fixed in a future version. The question is now when to do it. FWIW. Mike -Original Message- Sent: Friday, July 26, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Michael - So . . . since you have a work-around that is relatively easy from the developer point of view, how do you plan to convince them to rewrite their programs? Or do you have a really big hammer? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: efficient way to duplicate db on another unix host?
I have a paper on how to do this using the same version of Oracle on the same O/S if you are interested. basically you are using hot backups from a Tar. If you are interested let me know. Mike -Original Message- Sent: Friday, July 26, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Having just been working with it rman duplicate seems a good bet. It seems very efficient and you don't have to worry about sizing issues as it just builds it as it sees it If you have any questions I might be able to help I have seen one problem and that was with it not doing a proper recovery and you need your original db in archivelog mode. I seem to have a problem in the controlfile, it put in a screwy path for the directory where the logs are. I think I need new controlfiles in the original dbs but haven't been able to work this out. alternatively I have a script here that came from one of the sites around and it explains how to do it by doing an OS copy of the datafiles. This entails a lot of downtime in the original unless you can say split the mirror or something the rman method does it with a hot backup so there is no downtime on the first system HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2002 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:efficient way to duplicate db on another unix host? Hi Oracle gurus: What is, in your opinion, the fastest way to duplicate a database on a another unix host? Thanks, Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: type of join in sql
Hi The choice of of whether to use nested loop, hash join, sort-merge join is driven by the cost (logical ios performed ) and cardinality ( count of rows source for given operation ). Optimizer formulates several plan - before the best plan among them is chosen Approach one can take to benefit in the performance would be 1. If nested loops join - would give better performance for your query then perform thefollowing a. check if the involved tables have indexes b. verify if the indexes, tables involved have the statistics have been calculated frequently c. the ordering of the tables in the 'from clause' should be in such a way that the largest table (more rows) needs to be placed at the end or towards the end in the 'from clause' for eg : select c1, c2 from b, a where a.id = b.id === (a is largest table ) d. Attempt should be made such that cost of sort-merge join would be more expensive than the nested loops join (for eg) - so that the optimizer will choose nested loops 1. if permitted hints (USE_NL ) can be used 2. optimizer_index_cost_adj ( can be used - so that indexes will be used in the plan ) Question : if optimize finds that are more qualifying records in inner table then it will prefer to go for sort merge and will do full scan of inner table , but if it thinks there are less records in inner table it will user nested loop . am I correct ? Answer: Driving table in nested loops join is the one which is used to select each row from ( when an ORDERED HINT is used the 'first table' in the from clause assuming 2 tables is the 'driving' table the other table is called 'inner table ' ) fro eg: select c1, c2 from a, b where a.id = b.id usually the driving table is a and the inner table is b ( you can double verify this in the 10053 output ) Usually the 'inner table' if it has more rows than the 'driving table' === that is when the nested loops is advantageous - that is considered the same by the optimizer as well Thanks, Kavi Grabowy, Chris wrote: bp, Checkout a white paper entitled: A Look Under The Hood of CBO: The 10053 Event. You can find this whitepaper on the hotsos.com website. Your probably going to be looking at the General Plans section of the trace. Goodluck. Chris -- BigP [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/23/2002 06:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:type of join in sql can some body shed some light on how does the optimizer decides to choose the kind of join i.e. nested loop, sort merge or hash join . In one of queries if i tweak the join condition it changes the type of join and start using index , otherwise it doesn't . I thought it depends on statistics .. if optimize finds that are more qualifying records in inner table then it will prefer to go for sort merge and will do full scan of inner table , but if it thinks there are less records in inner table it will user nested loop . am I correct ? TIA , bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:;Kavitha x-mozilla-html:FALSE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Kavitha Muthukumaren end:vcard
RE: Cursor Sharing| Soft Parsing
I'll admit I'm gullible, and I do look to you as more knowledgeable than me about internals. On the other hand, I'm a born and bred New York City girl and I've never bought a bridge yet. guess I'll have to live with because as the answer Get on with you :) Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: Its three because the mapping of the memory structures to the pga is most efficient when the hashing function involved uses the lowest prime that is not a power of two. (long pause) ...and if you believe that, you'll believe anything :-) hee hee hee Connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: Connor, Well, technically that answers the why... with Oracle's because I said so :) the REAL question is why 3 and not 2 or 4 or 10 or. ? Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: RTM :-) Performance Guide 9.2 Caching Session Cursors (blah blah blah) Oracle checks the library cache to determine whether more than three parse requests have been issued on a given statement. (more blah blah blah) hth connor --- [EMAIL PROTECTED] wrote: I wasn't aware of it requiring three calls before being useful. Why is that? Jared Cary Millsap [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cursor Sharing| Soft Parsing Well, three times, right? I think it takes three parse calls before session_cached_cursors begins to help. But 3 is still O(1). Once per call is O(#executions). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Still Sent: Thursday, July 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and execute as many times as we like. Also check out Bjorn's paper on bind variables and cursor sharing at http://technet.oracle.com/deploy/performance/pdf/cursor.pdf So CURSOR sharing is not the silver bullet as one may expect. Regards Suhen === message truncated === __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Help on Temp Space
I have seen this exact behavior too. FWIW. Mike -Original Message- Sent: Friday, July 26, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Lisa, I've had problems with TEMPORARY tablespaces in Version 7. Busy databases continually ran out of TEMP space, and it would not get released for use by other sessions. We finally went back to PERMANENT temp TBS's on version 7 and the problems disappeared. I haven't experienced this on 8+. Jared Lisa R. Clary [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/26/2002 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Help on Temp Space Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
OK, I think this explains a lot with the introduction of the new and highly technical term, softer parse. So we have the hard parse, the soft parse, and the softer parse. You can get or derive stats for all three: 1) hard parses = parse count (hard) 2) soft parses (AKA parse calls) = parse count (total) minus parse count (hard) 3) softer parses = session cursor cache hits I guess soft parses also include softer parses in 2 above. Whew... it's like you have to be a lawyer to parse the Oracle documentation and reconcile it with the facts in the v$ tables. Let just call this the parse farce episode in our chronicles of the pursuit of Oracular truth. Someone please tell me it's Friday. -Original Message- Sent: Friday, July 26, 2002 10:15 AM To: Multiple recipients of list ORACLE-L * * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Mr. Kyte's parsing explanation is also in this iss of OraMag. For the papyrus-impaired: http://www.oramag.com/oramag/oracle/02-jul/index.html?o42asktom.html (Be safe: Download page to laptop or PDA before taking to bathroom) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 4:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cursor Sharing| Soft Parsing I checked the Tom Kyte site. A soft parse comprises two -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Errors trying to connect from 8.1.7 client to 7.3.2 server
Not sure about AIX, but on some platforms the format of tnsnames.ora can be quite picky. Have also experienced odd errors connecting from 8x to 7x databases. You might try reformatting it like this: test1.world = (DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=mfgad11)(PORT=1521)) (CONNECT_DATA = (SID = test1)) ) If that doesn't work, try using netasst to add the tnsnames.ora entry. Suzy Schauss, Peter wrote: Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on Temp Space
Lisa, I've had problems with TEMPORARY tablespaces in Version 7. Busy databases continually ran out of TEMP space, and it would not get released for use by other sessions. We finally went back to PERMANENT temp TBS's on version 7 and the problems disappeared. I haven't experienced this on 8+. Jared Lisa R. Clary [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/26/2002 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Help on Temp Space Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on Temp Space
We found that that worked, but converting back to PERMANENT tbs was much more effective on Version 7. Jared Mohammad Rafiq [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/26/2002 10:10 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Help on Temp Space put it offline and again online immediately...do it at off-peak time , tested solution... Regards rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 26 Jul 2002 08:09:14 -0800 Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
Peter, Sorry for repeating but: Can your AIX client ping this host: mfgad11.atdc.northgrum.com ? Is your domain: atdc.northgrum.com or northgrum.com ? Waleed -Original Message- Sent: Friday, July 26, 2002 1:25 PM To: Multiple recipients of list ORACLE-L I should have added that I can ping the host and tnsping works also. Tracing on the server shows that listener is receiving the connection but gives no hint of why the connection failed. $ lsnrctl status (on the server): LSNRCTL for SVR4: Version 2.3.2.1.0 - Production on 26-JUL-02 11:33:41 Copyright (c) Oracle Corporation 1994. All rights reserved. Connecting to (address=(protocol=tcp)(host=mfgad11.)(port=1521 )) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for SVR4: Version 2.3.2.1.0 - Production Start Date25-JUL-02 15:28:34 Uptime0 days 20 hr. 5 min. 9 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /usr/app/oracle/product/7.3.2/network/admin/listener.o ra Listener Log File /usr/app/oracle/product/7.3.2/network/log/listener.log Services Summary... test1 has 1 service handler(s) The command completed successfully -- -Original Message- Sent: Friday, July 26, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Peter, Can you ping the remote host from AIX? Can you tnsping the remote database from AIX? What do you get when you run this: lsnrctl status (on the host running the database server)? I mean which host the listener is defined to listen on. Also you may need to trace the client and look at the output. Waleed -Original Message- Sent: Friday, July 26, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for
RE: RE: BR solutions
In Rich's case (I was working with him when his infrastructure was built) and in mine now, the backups largely define how database cloning is carried out. We are using Veritas Snaps here, allowing me to clone an instance with few minutes of sync time and a control file rebuild, much faster than using RMAN or anything else I have seen to build a clone. Rich's system copies all the files to a storage area, which then is used as the source of datafile copies for his cloning. In the case of RMAN, the clone requires an extra database be active, the storage is handled spread over several different files, i.e. you'll have to reconstitute the datafiles when cloning. Note, this is MY understanding and I may be totally off base, I don't use RMAN. It seems on it's face however that cloning would take longer running through a repository and rebuilding files than simple file copies through some other mechanism. My real point is, backups and clones are intimately related. If you don't have to clone very often and/or have a good window for doing so, overhead associated with how RMAN does its block level backing up may not be an issue. If you have to tweak to minimize every second of development downtime (Rich and I had to do this), another approach may prove better at meeting that goal. Regardless, if one strategy has been implemented, the whole ball of wax has to be addressed when considering making a change. Hope this is clearer...and would love to hear other opinions about this, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, July 26, 2002 1:00 PM To: Multiple recipients of list ORACLE-L John - Can you please elaborate on your statement? We've just started using RMAN and haven't yet used it to refresh the development environment, so I am curious how your statement may apply to me. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 3:45 PM To: Multiple recipients of list ORACLE-L There's also the little matter of the dev refresh strategy being wedded to the backup strategy. Moving generally means ripping out the best part of the infrastructure. :) John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, July 25, 2002 4:14 PM To: Multiple recipients of list ORACLE-L amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message- Sent: Thursday, July 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Sean 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 http://www.orafaq.com -- Author:
(Fwd) Re: System Administrator Appreciation Day
http://ars.userfriendly.org/cartoons/?id=20020726 --- Forwarded message follows --- Also - if you don't already read it, check out today's userfriendly comic, at http://www.userfriendly.org . The 'singer' in the strip is Stef Murkey, marketing type, while the 'singee' is Mike, sysadmin extraordinaire... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
every time I've gone to www.oracle.com and clicked oracle university lately, it hangs my browser (IE6). On 26 Jul 2002 at 4:55, [EMAIL PROTECTED] wrote: Hmm. Good point. Anyone know how we can verify that if you take the 8i exams and pass you can just do the upgrade exam without the additional course? Is there a time when 8i exams will not be offered any more or any other time constraint and does any one know? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Stored Procedures/Functions
Dear Gurus How would one monitor when and who may be executing a stored procedure/package etc at any one point in time. Similar to table locks although thats more straightforward to monitor. Pls advise Thanks in Advance IMPORTANT: This e-mail (including all attachments) is confidential and may be privileged. It may be read, copied and used only by the intended recipients, and must not be re-transmitted in any form without our consent. If you have received it in error, please contact us immediately by return e-mail. Please then delete it and do not disclose its contents to any other person. Security and reliability of email is not guaranteed. Communications should be verified from a mailed or faxed copy. All emails to anyone @vitol.com are communications to the firm and are not private or confidential to any named individual. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Easaw T Mathew INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing .... Continued
Michael - So . . . since you have a work-around that is relatively easy from the developer point of view, how do you plan to convince them to rewrite their programs? Or do you have a really big hammer? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: When was a tablespace created?
try this: select a.file_name, a.tablespace_name, b.creation_time from dba_data_files a, v$datafile b where a.file_name = b.name should give the time for the first file added to the tablespace, translates to the tablespace creation time. someone might have a better idea, I guess. Sunil Nookala Dell Corp. Austin, TX -Original Message- Sent: Friday, July 26, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Is the creation date/time for a tablespace stored within the DB? If so, where? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help on Temp Space
put it offline and again online immediately...do it at off-peak time , tested solution... Regards rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 26 Jul 2002 08:09:14 -0800 Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: efficient way to duplicate db on another unix host?
Having just been working with it rman duplicate seems a good bet. It seems very efficient and you don't have to worry about sizing issues as it just builds it as it sees it If you have any questions I might be able to help I have seen one problem and that was with it not doing a proper recovery and you need your original db in archivelog mode. I seem to have a problem in the controlfile, it put in a screwy path for the directory where the logs are. I think I need new controlfiles in the original dbs but haven't been able to work this out. alternatively I have a script here that came from one of the sites around and it explains how to do it by doing an OS copy of the datafiles. This entails a lot of downtime in the original unless you can say split the mirror or something the rman method does it with a hot backup so there is no downtime on the first system HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2002 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:efficient way to duplicate db on another unix host? Hi Oracle gurus: What is, in your opinion, the fastest way to duplicate a database on a another unix host? Thanks, Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
I should have added that I can ping the host and tnsping works also. Tracing on the server shows that listener is receiving the connection but gives no hint of why the connection failed. $ lsnrctl status (on the server): LSNRCTL for SVR4: Version 2.3.2.1.0 - Production on 26-JUL-02 11:33:41 Copyright (c) Oracle Corporation 1994. All rights reserved. Connecting to (address=(protocol=tcp)(host=mfgad11.atdc.northgrum.com)(port=1521 )) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for SVR4: Version 2.3.2.1.0 - Production Start Date25-JUL-02 15:28:34 Uptime0 days 20 hr. 5 min. 9 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /usr/app/oracle/product/7.3.2/network/admin/listener.o ra Listener Log File /usr/app/oracle/product/7.3.2/network/log/listener.log Services Summary... test1 has 1 service handler(s) The command completed successfully -- -Original Message- Sent: Friday, July 26, 2002 10:53 AM To: Multiple recipients of list ORACLE-L Peter, Can you ping the remote host from AIX? Can you tnsping the remote database from AIX? What do you get when you run this: lsnrctl status (on the host running the database server)? I mean which host the listener is defined to listen on. Also you may need to trace the client and look at the output. Waleed -Original Message- Sent: Friday, July 26, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Here is the tnsnames.ora entry. As I mentioned in my previous note, this is a direct copy from tnsnames.ora on my W2k client which has no problem connecting to this database. test1.world= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP )(HOST = mfgad11)(PORT=1521)) ) (CONECT_DATA = (SID = test1) ) ) Thanks for all of the suggestions so far. Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
Thanks for sharing your interesting research Ian. If cached cursors obviate the need for a parse call then why do they increment parse count (total)? Despite all the list contributions it does not appear that this question has been answered. As Cary Millsap pointed out, there's a problem with definitions. AND... maybe Oracle statistics data is out of sync with the definitions and the shared pool/cached cursor features. By definition a cursor is created by a parse (hard) of a valid SQL statement so if a cursor is cached then it follows that a parse is unnecessary. But the results of your query to v$sesstat contradict that. To set the stage, here's some definitional material from the Oracle docs: Concepts Manual: Oracle parses a SQL statement only if a shared SQL area for an identical SQL statement does not exist in the shared pool. In this case, a new shared SQL area is allocated and the statement is parsed. Note the difference between an application making a parse call for a SQL statement and Oracle actually parsing the statement. A parse call by the application associates a SQL statement with a private SQL area. After a statement has been associated with a private SQL area, it can be executed repeatedly without your application making a parse call. A parse operation by Oracle allocates a shared SQL area for a SQL statement. Once a shared SQL area has been allocated for a statement, it can be executed repeatedly without being reparsed. Design/Tuning Manual: Oracle uses the shared SQL area to determine whether more than three parse requests have been issued on a given statement. If so, Oracle assumes the session cursor associated with the statement should be cached and moves the cursor into the session cursor cache. Subsequent requests to parse that SQL statement by the same session then find the cursor in the session cursor cache. It seems like there are three things going on here but only two Oracle stats. There's a parse (hard), there's a parse call (soft, and there are 3 kinds of soft parses according to Morle), and a parse request which may not result in any parse. It's like parse requests are incrementing parse count (total) whether or not a parse of any kind is actually being performed. Obviously I'm just guessing here. So the unanswered question remains, if Oracle claims that a cached cursor hit obviates the need for either a parse operation OR a parse call, then why is parse count (total) incremented in v$sesstat Like Ian, I await an explanation! Steve Orr -Original Message- Sent: Thursday, July 25, 2002 8:28 PM To: Multiple recipients of list ORACLE-L Importance: High I didn't consider the invalidation possibilities. But here's more proof about Oracle still soft parsing with session_cached_cursors The following was run directly after session_cached_cursors was set to 10. select a.name, b.value from v$sysstat a, v$sesstat b where a.statistic# = b.statistic# and a.statistic# in (179, 180, 181, 191) and b.sid =16 / NAME VALUE - parse count (total) 12 parse count (hard) 0 execute count 12 session cursor cache hits0 --- The following SQL was executed select empno, ename, sal from scott.emp where empno = :v_empno; and the session stats showed NAME VALUE - parse count (total) 25 parse count (hard) 2 execute count 27 session cursor cache hits0 interate (2nd use of cursor) NAME VALUE - parse count (total) 26 parse count (hard) 2 execute count 28 session cursor cache hits0 note hard parsing has stopped. iterate (third use of cursor) NAME VALUE - parse count (total) 27 parse count (hard) 2
RE: SQLLDR question SOLVED
Thanks for all the help. It turns out there was a problem with the data and the field seperator was part of the data in one of the fields. -Original Message- Sent: Friday, July 26, 2002 10:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on Solaris 8). A couple of records keep kicking out. Because on the commonality between the records that are kicked out, I have a question. Does sqlldr treat an the same way that sqlplus does. In other words, if one of the fields in a records has an embedded in it, will sqlldr reject the record? If so, is there a way around this? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help on Temp Space
Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLLDR question
Terry, I tried the following in 817 and it worked fine: LOAD DATA INFILE * INTO TABLE test REPLACE FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( col1 char , col_seq test_seq.nextval ) BEGINDATA 'one', 'two', (sorry about the first email - fingers slipped!) Do you get an error in the sqlldr log? - what does it say? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 26, 2002 11:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on Solaris 8). A couple of records keep kicking out. Because on the commonality between the records that are kicked out, I have a question. Does sqlldr treat an the same way that sqlplus does. In other words, if one of the fields in a records has an embedded in it, will sqlldr reject the record? If so, is there a way around this? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
* * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Mr. Kyte's parsing explanation is also in this iss of OraMag. For the papyrus-impaired: http://www.oramag.com/oramag/oracle/02-jul/index.html?o42asktom.html (Be safe: Download page to laptop or PDA before taking to bathroom) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 4:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cursor Sharing| Soft Parsing I checked the Tom Kyte site. A soft parse comprises two ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
Connor, Well, technically that answers the why... with Oracle's because I said so :) the REAL question is why 3 and not 2 or 4 or 10 or. ? Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: RTM :-) Performance Guide 9.2 Caching Session Cursors (blah blah blah) Oracle checks the library cache to determine whether more than three parse requests have been issued on a given statement. (more blah blah blah) hth connor --- [EMAIL PROTECTED] wrote: I wasn't aware of it requiring three calls before being useful. Why is that? Jared Cary Millsap [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/25/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cursor Sharing| Soft Parsing Well, three times, right? I think it takes three parse calls before session_cached_cursors begins to help. But 3 is still O(1). Once per call is O(#executions). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 23-25 Chicago - Miracle Database Forum, Sep 20-22 Middlefart Denmark - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Still Sent: Thursday, July 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. No, code that uses bind variables need only parse SQL statements once if session_cached_cursors is set. Further executions of the same SQL don't require a hard or soft parse. Jared When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:23 PM To: Multiple recipients of list ORACLE-L Mike, Kirti, Try page 441 CURSOR_SHARING=FORCE does improve badly written applications that use lots of literals. However coding should be done using bind variables in almost all occasions. CURSOR_SHARING=FORCE reduces the hard parsing. What CURSOR_SHARING=FORCE does is rewrites all queries to use bind variables before parsing. eg. select ename from emp where empno = 10; rewritten as select ename from emp where empno =:SYS_B_0 or in 8.1.6 , 8.1.7 select name from emp where empno =:SYS_B_0 So it substitutes the literal with bind variables but incurs the cost of soft parsing the statement. Soft Parsing too frequently limits the scalability of applications and sacrifices optimal performance which could have been achieved in the first place if written using bind variables. Parse once and execute as many times as we like. Also check out Bjorn's paper on bind variables and cursor sharing at http://technet.oracle.com/deploy/performance/pdf/cursor.pdf So CURSOR sharing is not the silver bullet as one may expect. Regards Suhen On Thu, 25 Jul 2002 10:23, you wrote: Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists === message truncated === __ Do You Yahoo!? Yahoo! Health - Feel better, live better
RE: SQLLDR question
I'm not a sqlloader expert, so take with a large grain of salt. If you are using conventional path, a series of 'insert' statements are executed. This may cause the to be interpreted as the variable indicator. If you are using direct path, it may create a block of rows and then directly place them in the proper extent without using the SQL layer. So, try direct path and see if it works, but no promises. Another thought is to do a search and replace of the data and add the escape character (\) before each . Again, try it, but no promises. -Original Message- Sent: Friday, July 26, 2002 9:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on Solaris 8). A couple of records keep kicking out. Because on the commonality between the records that are kicked out, I have a question. Does sqlldr treat an the same way that sqlplus does. In other words, if one of the fields in a records has an embedded in it, will sqlldr reject the record? If so, is there a way around this? TIA Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Hi, the requirement for an instructor-led course is only for people wishing to gain the 9i DBA OCP credential from scratch. It's not required for people taking the 8i course, upgrading from 8i or those who've already taken an exam towards the 9i OCP credential. And the evidence is at http://www.oracle.com/education/certification/index.html?dba9i_ocpcoursereq.html regards, Mike Hately (9i OCP DBA since January =) ) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 26 July 2002 13:56To: Multiple recipients of list ORACLE-LSubject: RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA Hmm. Good point. Anyone know how we can verify that if you take the 8i exams and pass you can just do the upgrade exam without the additional course? Is there a time when 8i exams will not be offered any more or any other time constraint and does any one know? This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
When is the next patchset for 9.2.0.1 coming out?
Gene, What patchsets are currently available for 9iR2 (9.2.0.1)? I'm not aware that any are available. Does anyone know when the next patchset is expected to be released for 9.2.0.1? Thanks, Cherie Machler Oracle DBA Gelco Information Network Gene Sais [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ach.fl.us cc: Sent by:Subject: RE: RE: BR solutions [EMAIL PROTECTED] 07/25/02 04:43 PM Please respond to ORACLE-L I'll stick to my trusty unix scripts for hot cold backups. When I roll out RDBMS 9iR2 patched, then I will consider migrating to RMAN. From what I understand, 9iR2 RMAN is much improved over the 8.0 RMAN. I also agree, I want to make sure RMAN is sticking around. And of course it WORKS! :) Gene [EMAIL PROTECTED] 07/25/02 04:13PM amen! and remember...what was it called...EBU? I wanted to make sure RMAN was here to stay before moving to it. Well it looks like it's here to stay, I just don't want to change a good backup strategy that I am comfortable with. - Rich -Original Message- Sent: Thursday, July 25, 2002 3:34 PM To: Multiple recipients of list ORACLE-L I kinfa hate to admit it, but I'm one of those who has not embrased RMAN. More out of lack of time to investigate than anything else, but to make real use of it here I need to intergrate it with OmniBack, which requires a database relink. And getting the databases away from the end users long enough is a real pain in the $%#. Dick Goulet Reply Separator Author: Mercadante; Thomas F [EMAIL PROTECTED] Date: 7/25/2002 10:13 AM I agree with Ruth (using Rman since 805). Robust, stable and easy to use. And Free! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L I have used rman since O804 and it's just gotten better and better. I have never tried anything else. It's free so the State likes that. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 11:08 AM Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - Sean 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Open -- Parse --Execute -- Fetch Rows -- Close
Yes, it is done at the parse call. In some cases such as witn DBMS_SQL the calls are explicit . One writes code to explicitly open the cursor, parse the cursor, execute the cursor, fetches rows from the cursor, and close the cursor. The fetch rows call is often placed in a loop. When writing most PL/SQL procedures, one writes code which explicitly opens the cursor, fetches rows from the cursor, and closes the cursor. But the open call is really a combination of open and parse. I'm not sure where the execute happens. I'm confused by the execute then fetch vs. execute_and_fetch dbms_sql calls. In the first case the execute is not placed in the loop, in the latter it is. When writing a ref cursor when opens then prints which also result in the other cursor calls being issued. If one is using a ref cursor. The parse happens at OPEN :ref_cur_variable FOR query; - If the above statement is successful, you can revoke permissions from the user and the print statement will be successful. However the next time the open is issued in will fail the semantics check of a soft parse. This shows the parse happens at the open and not the print. Again I wss using open in this sense. Ian MacGregor Stanford linear Accelerator Center [EMAIL PROTECTED] Original Message- Sent: Friday, July 26, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Hmm, parsing is not done at the open (oopen call). It is done in the oparse/osql call. But they are deffered until the execute. So it looks like it is done at the execute. In OCI8 it is a different story all together. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 25, 2002 6:59 PM Possibly burying myself deeper: Parsing is done at the open call. If a cursor needs to be re-opened, Oracle will check for permissions whether cursors are cached or not. Some experiments. First just using bind variables in the statement. SQL alter session set session_cached_cursors = 10; Session altered. SQL VARIABLE V_EMPNO NUMBER BEGIN :V_EMPNO := 7934; END; / SQL select ename from scott.emp where empno = :v_empno; ENAME -- MILL As this is the first statement. I would expect hard and soft parsing to be taking place. SQL BEGIN 2 :V_EMPNO := 7782; 3 END; 4 / PL/SQL procedure successfully completed. SQL select ename from scott.emp where empno = :v_empno; ENAME -- CLARK What type of parsing is done here. The statement is in the buffer pool -- --- If scott revokes privileges and the above statement is rerun SQL / select ename from scott.emp where empno = :v_empno * ERROR at line 1: ORA-01031: insufficient privileges -- Scott restores privileges ... SQL variable my_select refcursor; SQL BEGIN 2 OPEN :my_select FOR SELECT ename from s 3 END; 4 / PL/SQL procedure successfully completed. SQL print my_select ENAME -- SMITH ALLEN WARD JONES MARTIN BLAKE SCOTT KING TURNER ADAMS JAMES FORD MILL CLARK 14 rows selected. -- Print closes the cursor. If scott revokes permisssions at this point. SQL BEGIN 2 OPEN :my_select FOR SELECT ename from scott.emp; 3 END; 4 / OPEN :my_select FOR SELECT ename from scott.emp; * ERROR at line 2: ORA-06550: line 2, column 45: PLS-00904: insufficient privilege to access object SCOTT.EMP ORA-06550: line 2, column 21: PL/SQL: SQL Statement ignored -- - However if scott restores permissions SQL BEGIN 2 OPEN :my_select FOR SELECT ename from scott.emp; 3 END; 4 / PL/SQL procedure successfully completed. and now revokes them here. The print statement will still work SQL print my_sele ENAME -- SMITH ALLEN WARD JONES MARTIN BLAKE SCOTT KING TURNER ADAMS JAMES FORD MILL CLARK 14 rows selected. -- -- So how does one keep such cursors open. Given a cursor such as BEGIN OPEN :my_select FOR SELECT ename from scott.emp where empno = :v_empno; END; How does one display the information, change the value of :v_empno, and display the infromation again without re-opening the cursor. In the distant past when I was writing a lot of Pro*C I'd get the occaisional fetch out of sequence error when I would change the value of a bind variable and try to fetch without
RE: Is it correct way of adding two tables without having self-jo
Do you think there is any reason for adding same tables two times without having self
join condition???
IMHO, Oracle development guys has done some mistake
-Original Message-
From: Straub, Dan [mailto:[EMAIL PROTECTED]]
Sent: Fri 7/26/2002 22:44
To: Multiple recipients of list ORACLE-L
Cc:
Subject:RE: Is it correct way of adding two tables without having self-jo
Have you done both an explain and sqltrace on the query to see how it is
being executed and where the time is being spent? I would start there.
Dan Straub
McKesson Information Solutions
541-681-8278
44°03'N 123°05'W (or thereabouts)
Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.
-Original Message-
mailto:[EMAIL PROTECTED] ]
Sent: Friday, July 26, 2002 6:13 AM
To: Multiple recipients of list ORACLE-L
self-join
condition in Oracle HRMS
Hi Guys,
I need your comments on following view. This view has been written by
Oracle Development guys. I raised iTAR for this view problem with Oracle
HRMS group, and they suggested to raise it with RDBMS Group. When I
raised iTAR with RDBMS Group, I get answer that Oracle guys are only for
product support. And he has suggested to discuss this in Forums. I've
put this question in Metalink forum as well as
http://www.oracle.com/forums http://www.oracle.com/forums .
I am having tremendous problem with this view. Even if I select just
'select * from this_view;', it takes long time to give result.
May I have your comment please?
Thanks.
#
Application: Oracle HRMS
Version: 11.5.3 11.5.5
View Name: PAY_ASSIGNMENT_ACTIONS_V2
View Query:
SELECT DISTINCT paa.ROWID row_id, paa.assignment_id,
paa.assignment_action_id,
per.person_id, SUBSTR ( pay_gb_payroll_actions_pkg.get_salary (
asf.pay_basis_id, asf.assignment_id, rppa.date_earned), 1, 60 ) salary,
SUBSTR (INITCAP (hr_general.decode_pay_basis
(asf.pay_basis_id)),1,30)pay_basis,
job.name job_title, per.full_name, per.title,
SUBSTR (per.first_name, 1, 1) || ' ' || SUBSTR (per.middle_names, 1, 1)
initials, per.last_name, asf.assignment_number, asf.location_id,
asf.internal_address_line, per.national_identifier ni_number,
per.expense_check_send_to_address,
rppa.date_earned date_earned, paa.payroll_action_id,
rpaa.assignment_action_id run_assignment_action_id,
rpaa.payroll_action_id run_payroll_action_id, rppa.time_period_id
time_period_id, rppa.payroll_id payroll_id,
NVL (rppa.pay_advice_date, ptp.pay_advice_date) pay_advice_date,
ppg.segment1, ppg.segment2, ppg.segment3, ppg.segment4,
ppg.segment5, ppg.segment6, ppg.segment7, ppg.segment8,
ppg.segment9, ppg.segment10, ppg.segment11, ppg.segment12,
ppg.segment13, ppg.segment14, ppg.segment15, ppg.segment16,
ppg.segment17, ppg.segment18, ppg.segment19, ppg.segment20,
ppg.segment21, ppg.segment22, ppg.segment23, ppg.segment24,
ppg.segment25, ppg.segment26, ppg.segment27, ppg.segment28,
ppg.segment29, ppg.segment30
FROM per_jobs job,
per_all_assignments_f asf,
per_people_f per,
pay_assignment_actions paa, /* prepayment assignment action */
pay_payroll_actions ppa, /* prepayment payroll action */
pay_assignment_actions rpaa, /* run assignment action */
pay_payroll_actions rppa, /* run payroll action */
pay_action_interlocks il,
per_time_periods ptp,
pay_people_groups ppg
WHERE paa.payroll_action_id = ppa.payroll_action_id
AND ppa.action_type IN ('U', 'P')
AND ppa.action_status = 'C'
AND ppa.payroll_id = rppa.payroll_id
AND ppa.effective_date = rppa.effective_date
AND rpaa.assignment_id = paa.assignment_id
AND ppg.people_group_id(+) = asf.people_group_id
AND job.job_id(+) = asf.job_id
AND per.person_id = asf.person_id
AND paa.assignment_id = asf.assignment_id
AND rppa.date_earned BETWEEN asf.effective_start_date
AND asf.effective_end_date
AND ptp.time_period_id = rppa.time_period_id
AND rppa.date_earned BETWEEN per.effective_start_date
AND per.effective_end_date
AND rppa.payroll_action_id = rpaa.payroll_action_id
AND rpaa.assignment_action_id = il.locked_action_id
AND paa.assignment_action_id = il.locking_action_id
AND il.ROWID = (SELECT SUBSTR ( MAX ( LPAD (aa.action_sequence, 15, 0)
|| loc.ROWID ), -18 ) /* Length of rowid */ latest_act
FROM pay_assignment_actions aa,
pay_action_interlocks loc
WHERE loc.locked_action_id =
aa.assignment_action_id
AND loc.locking_action_id =
paa.assignment_action_id);
.
Observations:
---
1.Table pay_assignment_actions has been referenced 2 times
