Re: OT: Working from home
On Friday 15 June 2001 06:00, Rachel Carmichael wrote: > There was a manager in that same shop who measured her programmers > abilities by the number of lines of code they wrote in a day. She also said > to me once "I don't like to waste time on design" Rachel, Remember the Dilbert where the PHB tells the engineers that he'll pay a cash incentive for every bug the find and fix? Wally leave the meaning saying " I'm gonna code me a minivan!" As for lines of code, one could get even by writing succint obtuse code before leaving. ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Perl question
Sorry to tell you this Long, but the reason you are having this problem is that you compiled Perl by setting LD_LIBRARY_PATH=/usr/local/lib. This shouldn't be done. It should be compiled *without* setting LD_LIBRARY_PATH, other than for Oracle software. I saw that you did this in a previous post, thought you'd discover it pretty quick. :) You will have to recompile Perl to fix this. I don't recall which option in the configuration you set the libraries at, as it's been a few months since I've had to do it. You can read more about the evils of LD_LIBRARY_PATH at http://www.cis.ohio-state.edu/~barr/ldpath.html We're stuck with it for Oracle though. Jared On Friday 15 June 2001 02:05, Nguyen, Long (ITS, Limestone Ave) wrote: > Hi, > > The Perl 5.005_03 software on my Solaris 2.6 box did not have the GDBM_file > module in it, so I removed it, installed GNU gdbm software, and > re-installed Perl 5.005_03 that I got from CPAN. However now every time I > run Perl the system gives me this message > > ld.so.1: perl: fatal: libgdbm.so.2: open failed: No such file or directory > > It did not happen with the old Perl copy. > > If I set LD_LIBRARY_PATH=/usr/local/lib then run Perl, there is no > problem. > > Do you know why How can I 'link' this LD_LIBRARY_PATH setting into Perl so > that I do not need to have it explicitly set every time I run Perl. (And > also I do not want other users on teh system to explicitly set it in order > to run Perl). > > Thanks > Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo latch contention
Hi All, I had some situation of Redo Allocation and copy latch contention as stated in following output. SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, IMMEDIATE_MISSES FROM V$LATCH WHERE NAME LIKE '%redo%' / NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- -- redo allocation 74878 16 00 redo copy 114100 53756 232 redo writing30219 1 00 3 rows selected. Realizing small contention on redo allocation latch, I increased the value of "log_small_entry_max_size" from 80 to 90. But this would definitely overload (already suffering) redo copy latches, so I increased the value of log_simultaneous_copies from 2 to 6. This sorted out redo latch contention, but somewhere in FM it's mentioned that value of log_simultaneous_copies shouldn't be more than (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. So... 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are the golden rules. I have seen some authers not mentioning this. 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the algorithm?? What is the new strategy to handle redo latch contention?? Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they still talk of these parameters(which are made obsolete)... Appreciate your inputs ;-) Cheers, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Out of office until Tuesday 26th June
I will be on annual leave until Tuesday 26th June. For matters that cannot wait until then, please email Ray Feighery at [EMAIL PROTECTED] or phone +61 2 8437 6311 Thanks and regards Jeffrey Lim Infrastructure Consultant RecruitASP Pty Ltd PO Box 300, St Leonards New South Wales 1590 Australia Tel: +61 (2) 8437 6311 Fax: +61 (2) 8437 6399 Email: [EMAIL PROTECTED] Web: www.recruitasp.com.au -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Statement Tuning
Hi I'm looking for docs that explain tuning of SQL statements. But, no stories about latches, buffers, TKPROF, blocks, V$ views... Just simple (or advanced?) tips on: - ordering of tables in FROM part of select (where goes the largest table, and where to put the smallest table), and why is it so, - if i have multiple ANDed conditions, in where part of select, where to put the most restrictive, at the left end or at the right end? How does oracle evaluates ANDed and ORed list, from left to right or counterwise? - aditional tips: how to avoid OR and use AND instead, how to make query to use index, tips on EXISTS, NOT IN... Before diving into V$ stuff, I want do try simple query rewriting. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DKTS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reorgs in general
There are reorgs to fix fragmentations, and reorg to reclaim dirty space. LMT's fix the former but not necessarily the latter. I do believe tho' that the days of unloading the entire database and reloading it (with the exception of changing the blocksize) should be a thing of the past hth connor --- [EMAIL PROTECTED] wrote: > All, > > Oracle's party line has for a while been that for > the most > part reorgs aren't necessary anymore, right? > Assuming storage > initially has been set decently? Are reorgs very > common in > these parts? > > Also, even according to those who find reorgs still > necessary, > they should completely go away with LMT's, right? > > Opinions all? > > Thanks, > > Yosi Greenfield > Oracle DBA, Will work for food > [EMAIL PROTECTED] > -- > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Semaphores
Oracle Financials 11i asks for 14000 semaphores: When I do the calculation as per the Oracle Guide I come to about 1000. Anybody know why the disparate nature of these numbers. Can semaphores be set to such high levels. I can RTFM, but wonder what lists comments are before Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: primary/ foreign key constraints for oltp, overhead?...soluti
Amar, That's the whole point Jared was trying to make: your locking issue is because you *don't* have indexes on your foreign keys. You might want to review the following notes: 11828.1 " FOREIGN KEYS, INDEXES AND PARENT TABLE LOCKING" 33453.1 "(V7) REFERENTIAL INTEGRITY AND LOCKING" 38373.1 "TECH: Example Table Locks During Referential Integrity Enforcement" 61552.1 "DIAGNOSING DATABASE HANGING ISSUES" 15476.1 "Detecting and Resolving Locking Conflicts" HTH, -- Anita --- Amar Kumar Padhi <[EMAIL PROTECTED]> wrote: > No indexes on foreign key. > still the same result. > > rgds > amar > > -Original Message- > Sent: Monday, June 11, 2001 2:05 PM > To: Multiple recipients of list ORACLE-L > overhead?...soluti > > > Jared has a point. Is there an index on the foreign > key? > > Another minor detail: You should of course never > update a primary key > column, of > course :-) > > Amar Kumar Padhi wrote: > > > Jared, > > I tried again and got the same result. > > on oracle 8.1.7 (RBO). > > > > session1 : delete from emp where deptno = 10; > > > > session2 : delete from dept where deptno = 30; > > session 2 hanged and waited till transaction in > session one was committed. > > > > the max_trans on both tab is set to 255, incase > this raises doubt. > > are you getting a different result? Is the FK > present on the detail table > > you are trying with? > > > > rgds > > amar > > > > -Original Message- > > Sent: Monday, June 11, 2001 10:25 AM > > To: Multiple recipients of list ORACLE-L > > overhead?...soluti > > > > On Sunday 10 June 2001 21:50, Amar Kumar Padhi > wrote: > > > - locks > > > Oracle generates internal locks on dict tables > to maintain the data > > > integrity. > > > e.g.: I deleted a record from detail table in > one session. In another > > > session I tried to delete a master record not > related to the deleted > > detail > > > record. The 2nd session hanged. There were > row-exclusive locks present > on > > > the detail table and an exclusive lock present > on an internal table (I > > > couldn't access). The same is the case with > update. > > > > > > Oracle locks both the master & detail table > records when the master > record > > > is deleted and the foreign key is created with > on delete cascade option. > > > > > > Bottomline, Oracle doesn't allow altering of > master table primary key > when > > > active transactions exists on detail table. > Oracle will allow update of > > > columns other than the primary key. > > > > You should probably test this scenario, as it > works fine for me. > > > > Delete the a child detail row. > > Delete an unrelated parent row, with delete > cascade on the child table. > > > > Works fine. > > > > Possibly are missing an index? Some of these > rules have changed I know, > > but I'll let you look up the details. > > > > Bottom line, it does work. > > > > Jared > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Amar Kumar Padhi > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Venlig hilsen > > Mogens Nørgaard > > Technical Director > Miracle A/S, Denmark > Web: http://MiracleAS.dk > Mobile: +45 2527 7100 > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > t
Re: Reorgs in general
Connor, Reorgs to change the blocksize are reduced even further in 9i since multiple blocksizes are allowed in the same database, although you still can't change the default blocksize without rebuilding. The new free list allocation mechanism looks pretty slick too. Definitely lots of new goodies to play with ;) -- Anita --- Connor McDonald <[EMAIL PROTECTED]> wrote: > There are reorgs to fix fragmentations, and reorg to > reclaim dirty space. LMT's fix the former but not > necessarily the latter. > > I do believe tho' that the days of unloading the > entire database and reloading it (with the exception > of changing the blocksize) should be a thing of the > past > > hth > connor > > --- [EMAIL PROTECTED] wrote: > All, > > > > Oracle's party line has for a while been that for > > the most > > part reorgs aren't necessary anymore, right? > > Assuming storage > > initially has been set decently? Are reorgs very > > common in > > these parts? > > > > Also, even according to those who find reorgs > still > > necessary, > > they should completely go away with LMT's, right? > > > > Opinions all? > > > > Thanks, > > > > Yosi Greenfield > > Oracle DBA, Will work for food > > [EMAIL PROTECTED] > > -- > > 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). > > > = > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the > statue" > > > Do You Yahoo!? > Get your free @yahoo.co.uk address at > http://mail.yahoo.co.uk > or your free @yahoo.ie address at > http://mail.yahoo.ie > -- > 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 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: the conversion is from Mainframe flat file to Unix Flat file - b
On Fri, 15 Jun 2001,Raymond Lee Meng Hong scribbled on the wall in glitter...: ->what is EBCDIC format -> ->I have a customer from IBM DB2 mainframe going to pass data to my oracle ->system for matching of record ,what they told me is the tape is in EBCDIC ->format ? I don't have any experience on these format ? can anyone please ->explain /guildline on these ? -> -> ->Raymond fall asleep in waiting for the Q. -> -> it's Extended Binary Data Interchange Code or EBDIC and wad big blue's attempt at ASCII. there should be utilities on your system to convert. what's your OS and version? -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ God made machine language; all the rest is the work of man. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SYS vs SYSTEM
connect internal has been removed from 9i you will have to login as sys/password as sysdba thro sqlplus even the svrmgrl has been removed. this I think oracle has been saying from 8i version itself that they will be removing connect as internal in the future version >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: SYS vs SYSTEM >Date: Fri, 15 Jun 2001 13:27:12 -0800 > >How about oradim and server manager? > >-Original Message- >Sent: Friday, June 15, 2001 5:02 PM >To: Multiple recipients of list ORACLE-L > > >Trying to connect using INTERNAL via SQLPLUS. > >Platform is Solaris 2.6, Oracle 9i. Logged in as oracle user. Oracle user >is a member of the dba group and CONNECT INTERNAL works fine in 8i. > >See following error message for 9i: > >ORA-09275: CONNECT INTERNAL is not a valid DBA connection > >-Original Message- >[EMAIL PROTECTED] >Sent: Friday, June 15, 2001 3:56 PM >To: Multiple recipients of list ORACLE-L > > >Is it the same old rumor or it could be confirmed 100%? > >-Original Message- >Sent: Friday, June 15, 2001 3:26 PM >To: Multiple recipients of list ORACLE-L > > >Well you will have alot of scripts to change, internal is gone in 9i. > >"Walking on water and developing software from a specification are easy if >both are frozen." > >Christopher R. Spence >Oracle DBA >Fuelspot > > > >-Original Message- >Sent: Friday, June 15, 2001 2:41 PM >To: Multiple recipients of list ORACLE-L > > >Greg, > >I was told by Oracle Support when I started using Rman under version 8.0 to >use SYS or INTERNAL, as it is "better". > >Between you and me, "better" is quite subjective. But, I wrote scripts >that >connect as INTERNAL, and it has been working fine ever since, so I did not >re-visit it. > >Do you use a DBA account? Is there a better way? > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Friday, June 15, 2001 12:07 PM >To: Multiple recipients of list ORACLE-L > > >Tom, > >Why do you use SYS exclusively for startup and shutdown, since your DBA >priv >account could also accomplish this? > >- Greg > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Greg Moore > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Christopher Spence > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: eric harrington > INET: [EMAIL PROTECTED] > >Fat City Network Se
Re: Reorgs in general
"A. Bardeen" wrote: > Reorgs to change the blocksize are reduced even > further in 9i since multiple blocksizes are allowed in > the same database, although you still can't change the > default blocksize without rebuilding. At last. 'blocksize' has been an attribute in SYS.TS$ since the early days of Oracle6, so I guess that they have had this in mind for a long time. I have at last downloaded that "$+à?!!! Linux Disk2 (after 4 or 5 attempts - don't believe official number of downloads figures), ready to burn. Install (going to try it with 256M) will come later. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SQL Statement Tuning
Take a look at my website, I recently wrote a 32 page document on tuning sql. I would be very interested in getting feedback from what you think of it. www.vampired.net under articles. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Saturday, June 16, 2001 6:03 AM To: Multiple recipients of list ORACLE-L Hi I'm looking for docs that explain tuning of SQL statements. But, no stories about latches, buffers, TKPROF, blocks, V$ views... Just simple (or advanced?) tips on: - ordering of tables in FROM part of select (where goes the largest table, and where to put the smallest table), and why is it so, - if i have multiple ANDed conditions, in where part of select, where to put the most restrictive, at the left end or at the right end? How does oracle evaluates ANDed and ORed list, from left to right or counterwise? - aditional tips: how to avoid OR and use AND instead, how to make query to use index, tips on EXISTS, NOT IN... Before diving into V$ stuff, I want do try simple query rewriting. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DKTS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i On Linux
No, that IS MegaBytes Generic PRICE FOR ONLINE ORDERS ONLY - 512MB 168 Pin PC100 MUST MENTION PRICE WATCH - SDRAM - HIGH DENSITY; CAS2 ;NeutronUSA# 442185 - Volume DISCOUNT AVAILABLE $ 56 $12.85 2nd Air 6/15/2001 6:52:56 PM CT NeutronUSA.com 800-813-4218 814-237-0902 PA - The 150MHz went up a little and is $102 "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 15, 2001 8:55 PM To: Multiple recipients of list ORACLE-L That is 512 M Bits not Bytes = 512/8 = 64MB. Regards, Waleed -Original Message- Sent: Friday, June 15, 2001 8:06 PM To: Multiple recipients of list ORACLE-L Where can I find it that cheap? - E -Original Message- Sent: Friday, June 15, 2001 3:12 PM To: Multiple recipients of list ORACLE-L When you can buy 512Mb for $61 on the net, who cares :) "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 15, 2001 6:00 PM To: Multiple recipients of list ORACLE-L A minimum of 128M on the client??!! Who do they think they are?? Microsoft? -Original Message- Sent: Friday, June 15, 2001 3:02 PM To: Multiple recipients of list ORACLE-L >From Linux release notes: http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf The following requirements must be met to perform a typical Oracle9i software installation. Memory: A minimum of 512 MB of is required to install Oracle9i Server. A minimum of 512 MB is required to install Oracle9i Management and Integration. A minimum of 128 MB is required to install Oracle9i Client. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 4:20 PM > Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? > > Thank, > > Waleed > -- > 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt
Re: Redo latch contention
First of all, if you don't see cumulated waits for the 'latch free' event in either v$system_event or v$session_event (for a specific session/job) there is absolutely no need to do anything about these ratios. It's about the only two latches mentioned in the reference books and it's about the only two latches that never really have a problem :). My guess is that this effort (increasing log_simultaneous_copies and log_small_entry_max_size) hasn't increased performance on your system whatsoever. If - only if - you have latch contention/waits in the system (high percentage of time_waited in the above-mentioned v$system_event/v$session_event, you should ignore all those calculations with gets and misses and insted just look in v$latch like this: select name, sleeps from v$latch order by 2; to find the latches with highest contention. But again: If your system or session is not really waiting for latches, why bother? Rajesh Dayal wrote: > Hi All, > I had some situation of Redo Allocation and copy latch > contention as stated in following output. > > SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, > IMMEDIATE_MISSES > FROM V$LATCH WHERE NAME LIKE '%redo%' > / > > NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES > > -- -- -- -- > > redo allocation 74878 16 00 > > redo copy 114100 53756 232 > > redo writing30219 1 00 > > 3 rows selected. > > Realizing small contention on redo allocation latch, I increased > the value of "log_small_entry_max_size" from 80 to 90. > But this would definitely overload (already suffering) redo copy > latches, so I increased the value of log_simultaneous_copies from 2 to > 6. > This sorted out redo latch contention, but somewhere in FM it's > mentioned that value of log_simultaneous_copies shouldn't be more than > (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. > So... > > 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > the golden rules. I have seen some authers not mentioning this. > > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > algorithm?? What is the new strategy to handle redo latch contention?? > > Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they > still talk of these parameters(which are made obsolete)... > > Appreciate your inputs ;-) > > Cheers, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Reorgs in general
But each different block size requires its own buffer cache. If you haven't configured the seperate buffer cache, you cannot add tablespaces with a different block size to the database. Stephane Faroult wrote: > "A. Bardeen" wrote: > > Reorgs to change the blocksize are reduced even > > further in 9i since multiple blocksizes are allowed in > > the same database, although you still can't change the > > default blocksize without rebuilding. > > At last. 'blocksize' has been an attribute in SYS.TS$ since the early > days of Oracle6, so I guess that they have had this in mind for a long > time. I have at last downloaded that "$+à?!!! Linux Disk2 (after 4 or 5 > attempts - don't believe official number of downloads figures), ready to > burn. Install (going to try it with 256M) will come later. > -- > Regards, > > Stephane Faroult > Oriole Corporation > Voice: +44 (0) 7050-696-269 > Fax:+44 (0) 7050-696-449 > Performance Tools & Free Scripts > -- > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Redo latch contention
Rajesh: I'm a bit confused here. You say that you are going to tune your redo allocation latch contention, but, based on the output presented, you don't have any redo allocation latch contention. The threshold to determine contention is misses/gets >= .01 or immediate_misses/(immediate_gets+immediate_misses) >= .01. You do seem to have a problem with redo copy latches, but not redo allocation latches. So, I wouldn't mess with the log_small_entry_max_size parameter. Besides, in 8i, to tune this parameter you would either (1) use the NOLOGGING option to reduce the amount of redo log entries for certain operations or (2) reduce the load on the latch by increasing the LOG_BUFFER parameter or decreasing _LOG_IO_SIZE. So, you really need to be worried about tuning the redo copy latch waits. To do that, Oracle recommends increasing _LOG_SIMULTANEOUS_COPIES to have more latches available. But this is on multiple CPU machines and is limited to 32. Since, under 8i, a redo copy latch is now required for all redo generation, not just that which is larger than log_small_entry_max_size, and it is held longer until the redo has been applied to the target buffers, one would expect there to be more redo copy latch contention. Based on what I have read, it seems you may also want to check for log file syncs by DBWn and tune down checkpointing if appropriate. You may also want to look at the commit rate in your application to see if that can be reasonably reduced. Hope this helps! -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio > From: Rajesh Dayal <[EMAIL PROTECTED]> > Organization: Fat City Network Services, San Diego, California > Reply-To: [EMAIL PROTECTED] > Date: Sat, 16 Jun 2001 00:25:42 -0800 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Redo latch contention > > Hi All, > I had some situation of Redo Allocation and copy latch > contention as stated in following output. > > SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, > IMMEDIATE_MISSES > FROM V$LATCH WHERE NAME LIKE '%redo%' > / > > NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES > > -- -- -- -- > > redo allocation 74878 16 00 > > redo copy 114100 53756 232 > > redo writing30219 1 00 > > > 3 rows selected. > > Realizing small contention on redo allocation latch, I increased > the value of "log_small_entry_max_size" from 80 to 90. > But this would definitely overload (already suffering) redo copy > latches, so I increased the value of log_simultaneous_copies from 2 to > 6. > This sorted out redo latch contention, but somewhere in FM it's > mentioned that value of log_simultaneous_copies shouldn't be more than > (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. > So... > > 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > the golden rules. I have seen some authers not mentioning this. > > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > algorithm?? What is the new strategy to handle redo latch contention?? > > Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they > still talk of these parameters(which are made obsolete)... > > Appreciate your inputs ;-) > > Cheers, > Rajesh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
New certified DBA
I've recently completed my last exam to achieve OCP status and I'm looking for a jr DBA position in the Twin City area. I'm currently employed as a database developer. My problem is I have no hands on DBA experience. Any suggestions? Thanks in advance for any leads or suggestions! Jim
Re: Redo latch contention
Mogens, You are right. nothing is a performance problem unless there is a time contention. In general, it's very hard to see time spent in each latch. itrprof SQL Analyzer with waitgroup=(name,P1,P2) can report time spent in each latch. So, you can see time spent in A latch, time spent in B latch, etc. I'm not a very old dba, but I don't think many latches can be tuned by init.ora parameters. with waitgroup=(name,P1), you can see time spent in each enqueue such as 5 sec in (TX), 3 sec in (TM) etc. 'latch free' and 'enqueue' waits do not make sense themselves. You can drill-down these each waits by itrprof. a little marketing... Mogens Nørgaard wrote: > First of all, if you don't see cumulated waits for the 'latch free' event in > either v$system_event or v$session_event (for a specific session/job) there > is absolutely no need to do anything about these ratios. It's about the only > two latches mentioned in the reference books and it's about the only two > latches that never really have a problem :). > > My guess is that this effort (increasing log_simultaneous_copies and > log_small_entry_max_size) hasn't increased performance on your system > whatsoever. > > If - only if - you have latch contention/waits in the system (high > percentage of time_waited in the above-mentioned > v$system_event/v$session_event, you should ignore all those calculations > with gets and misses and insted just look in v$latch like this: > > select name, sleeps from v$latch order by 2; > > to find the latches with highest contention. But again: If your system or > session is not really waiting for latches, why bother? > > Rajesh Dayal wrote: > > > Hi All, > > I had some situation of Redo Allocation and copy latch > > contention as stated in following output. > > > > SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, > > IMMEDIATE_MISSES > > FROM V$LATCH WHERE NAME LIKE '%redo%' > > / > > > > NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES > > > > -- -- -- -- > > > > redo allocation 74878 16 00 > > > > redo copy 114100 53756 232 > > > > redo writing30219 1 00 > > > > 3 rows selected. > > > > Realizing small contention on redo allocation latch, I increased > > the value of "log_small_entry_max_size" from 80 to 90. > > But this would definitely overload (already suffering) redo copy > > latches, so I increased the value of log_simultaneous_copies from 2 to > > 6. > > This sorted out redo latch contention, but somewhere in FM it's > > mentioned that value of log_simultaneous_copies shouldn't be more than > > (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. > > So... > > > > 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > > the golden rules. I have seen some authers not mentioning this. > > > > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > > algorithm?? What is the new strategy to handle redo latch contention?? > > > > Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they > > still talk of these parameters(which are made obsolete)... > > > > Appreciate your inputs ;-) > > > > Cheers, > > Rajesh > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rajesh Dayal > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Venlig hilsen > > Mogens Nørgaard > > Technical Director > Miracle A/S, Denmark > Web: http://MiracleAS.dk > Mobile: +45 2527 7100 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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:
RE: OT: Working from home
My theory is this. A loosely used ratio for performance reviews. (Number of Bugs Resolved x Number of Projects x Number of lines of code - (Bugs introduced in your code x 500)) But use this with a grain of salt as many things are involved in programming and lines of codes, bugs, and number of products are all relative to the current situation. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Saturday, June 16, 2001 3:55 AM To: Multiple recipients of list ORACLE-L On Friday 15 June 2001 06:00, Rachel Carmichael wrote: > There was a manager in that same shop who measured her programmers > abilities by the number of lines of code they wrote in a day. She also said > to me once "I don't like to waste time on design" Rachel, Remember the Dilbert where the PHB tells the engineers that he'll pay a cash incentive for every bug the find and fix? Wally leave the meaning saying " I'm gonna code me a minivan!" As for lines of code, one could get even by writing succint obtuse code before leaving. ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Redo latch contention
Setting it too high may cause additional content switching. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Saturday, June 16, 2001 4:26 AM To: Multiple recipients of list ORACLE-L Hi All, I had some situation of Redo Allocation and copy latch contention as stated in following output. SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, IMMEDIATE_MISSES FROM V$LATCH WHERE NAME LIKE '%redo%' / NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- -- redo allocation 74878 16 00 redo copy 114100 53756 232 redo writing30219 1 00 3 rows selected. Realizing small contention on redo allocation latch, I increased the value of "log_small_entry_max_size" from 80 to 90. But this would definitely overload (already suffering) redo copy latches, so I increased the value of log_simultaneous_copies from 2 to 6. This sorted out redo latch contention, but somewhere in FM it's mentioned that value of log_simultaneous_copies shouldn't be more than (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. So... 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are the golden rules. I have seen some authers not mentioning this. 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the algorithm?? What is the new strategy to handle redo latch contention?? Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they still talk of these parameters(which are made obsolete)... Appreciate your inputs ;-) Cheers, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: the conversion is from Mainframe flat file to Unix Flat file
Basically IBM's version of ASCII "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 15, 2001 10:40 PM To: Multiple recipients of list ORACLE-L b what is EBCDIC format I have a customer from IBM DB2 mainframe going to pass data to my oracle system for matching of record ,what they told me is the tape is in EBCDIC format ? I don't have any experience on these format ? can anyone please explain /guildline on these ? Raymond fall asleep in waiting for the Q. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Redo latch contention
>1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > the golden rules. I have seen some authers not mentioning this. Yes, it is okay to set it higher than this. It won't degrade the performance, but don't expect any considerable gain in the performance either. On some combination of Oracle version & platform, the max value can be as high as 8 times the number of CPUs. But as Mogens says if there are no waits for 'latch free' event you should forget about messing with this. Unless there is a chance that you are suffering from a compulsive tuning disorder ;-) > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > algorithm?? What is the new strategy to handle redo latch contention?? It is now an unsupported parameter in 8i, and it defaults to 2 times the number of CPUs. (The max according to Oracle). Oracle thinks that it is the appropriate value in most cases and there is no reason (most of the times) to adjust this parameter. There have been some enhancements, from 8.0, in how LGWR dealt with redo log buffer (with its own 3 secs timer) but I don't think there is any new strategy for handling redo latch contention. For some reason, sometimes Oracle is rather late in updating their documentation. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, June 16, 2001 10:17 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Redo latch contention > > First of all, if you don't see cumulated waits for the 'latch free' event > in > either v$system_event or v$session_event (for a specific session/job) > there > is absolutely no need to do anything about these ratios. It's about the > only > two latches mentioned in the reference books and it's about the only two > latches that never really have a problem :). > > My guess is that this effort (increasing log_simultaneous_copies and > log_small_entry_max_size) hasn't increased performance on your system > whatsoever. > > If - only if - you have latch contention/waits in the system (high > percentage of time_waited in the above-mentioned > v$system_event/v$session_event, you should ignore all those calculations > with gets and misses and insted just look in v$latch like this: > > select name, sleeps from v$latch order by 2; > > to find the latches with highest contention. But again: If your system or > session is not really waiting for latches, why bother? > > Rajesh Dayal wrote: > > > Hi All, > > I had some situation of Redo Allocation and copy latch > > contention as stated in following output. > > > > SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, > > IMMEDIATE_MISSES > > FROM V$LATCH WHERE NAME LIKE '%redo%' > > / > > > > NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES > > > > -- -- -- -- > > > > redo allocation 74878 16 00 > > > > redo copy 114100 53756 232 > > > > redo writing30219 1 00 > > > > 3 rows selected. > > > > Realizing small contention on redo allocation latch, I increased > > the value of "log_small_entry_max_size" from 80 to 90. > > But this would definitely overload (already suffering) redo copy > > latches, so I increased the value of log_simultaneous_copies from 2 to > > 6. > > This sorted out redo latch contention, but somewhere in FM it's > > mentioned that value of log_simultaneous_copies shouldn't be more than > > (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. > > So... > > > > 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > > the golden rules. I have seen some authers not mentioning this. > > > > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > > algorithm?? What is the new strategy to handle redo latch contention?? > > > > Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they > > still talk of these parameters(which are made obsolete)... > > > > Appreciate your inputs ;-) > > > > Cheers, > > Rajesh > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rajesh Dayal > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > al
Re: primary/ foreign key constraints for oltp, overhead?...soluti
On Friday 15 June 2001 21:50, Amar Kumar Padhi wrote: > No indexes on foreign key. > still the same result. > Of course, because you don't have the indexes on the FK constraints. Now it's time to RTFM please. Read the concepts manual on relational integrity. Build sample tables and play with RI until you have a solid understanding of it. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
JDeveloper Connection to Oracle DB
Hi, I have installed JDeveloper 3.0 and I am running Oracle 8i personal edition on a Windows 98 platform. I am trying to create a connection to the DB from JDeveloper. I specify the "Oracle JDBC Thin" as driver and I select "Existing TNS Names" as the connection method and I choose the service running. When I click on the "Test Connection" button I get an error message that reads: "Io Exception: The Network adapter could not establish the connection". I tried to resolve the problem but was unable to. I would appreciate any help. Thank you, Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDeveloper Connection to Oracle DB
Elias, I don't know much about JDBC, but I suspect that like ODBC it sits on top of the Net8 layer. By default, Personal Oracle on Win95/98 doesn't automatically start the listener the way the TNSlistener service does on NT/Win2K, so try manually starting the listener from the command prompt: lsnrctl start You can set the listener to start up up automatically by changing the registry entry LISTENER_STARTUP to AUTO hkey_local_machine\oracle\home0 HTH, -- Anita --- Elias Mouchantaf <[EMAIL PROTECTED]> wrote: > Hi, > > I have installed JDeveloper 3.0 and I am running > Oracle > 8i personal edition on a Windows 98 platform. I am > trying to create a connection to the DB from > JDeveloper. I specify the "Oracle JDBC Thin" as > driver > and I select "Existing TNS Names" as the connection > method and I choose the service running. When I > click > on the "Test Connection" button I get an error > message > that reads: "Io Exception: The Network adapter could > > not establish the connection". I tried to resolve > the > problem but was unable to. I would appreciate any > help. > > Thank you, > > Elias S. Mouchantaf > Tel. (+961) 3 740319 > [EMAIL PROTECTED] > www.moshnet.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Elias Mouchantaf > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Redo latch contention
Or with Cary Millsap's hprof/Sparky stuff (hotsos.com). I'm deligthed that guys like you and Cary are writing tools/products that harvest the enormous amount of useful stuff available in 10046 level 8/12 trace files. You know what would be really cool? The same stuff is available via x$trace. x$trace is in itself much more non-intrusive than 10046 traces (it uses memory buffers), but has some features and possibilities that sets it apart: - The memory buffers are round-robin, ie. they get re-used. You would need to either get data out of them all the time or use the wonderful feature of flushing the data to disk and harvest the information from those files - It's all or nothing. You either trace all sessions or none at all (in other words: instance-level) - With the absolutely incredible amount of data available through the x$trace interface you can - as I see it - map the interactions between processes (foreground/background). So it would be really cool if some tool some day could get some of this data out :). "Danisment Gazi Unal (Unal Bilisim)" wrote: > Mogens, > > You are right. > > nothing is a performance problem unless there is a time contention. > > In general, it's very hard to see time spent in each latch. itrprof SQL Analyzer > with waitgroup=(name,P1,P2) can report time spent in each latch. So, you can see > time spent in A latch, time spent in B latch, etc. I'm not a very old dba, but I > don't think many latches can be tuned by init.ora parameters. > > with waitgroup=(name,P1), you can see time spent in each enqueue such as 5 sec > in (TX), 3 sec in (TM) etc. > > 'latch free' and 'enqueue' waits do not make sense themselves. You can > drill-down these each waits by itrprof. > > a little marketing... > > Mogens Nørgaard wrote: > > > First of all, if you don't see cumulated waits for the 'latch free' event in > > either v$system_event or v$session_event (for a specific session/job) there > > is absolutely no need to do anything about these ratios. It's about the only > > two latches mentioned in the reference books and it's about the only two > > latches that never really have a problem :). > > > > My guess is that this effort (increasing log_simultaneous_copies and > > log_small_entry_max_size) hasn't increased performance on your system > > whatsoever. > > > > If - only if - you have latch contention/waits in the system (high > > percentage of time_waited in the above-mentioned > > v$system_event/v$session_event, you should ignore all those calculations > > with gets and misses and insted just look in v$latch like this: > > > > select name, sleeps from v$latch order by 2; > > > > to find the latches with highest contention. But again: If your system or > > session is not really waiting for latches, why bother? > > > > Rajesh Dayal wrote: > > > > > Hi All, > > > I had some situation of Redo Allocation and copy latch > > > contention as stated in following output. > > > > > > SQL> SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, > > > IMMEDIATE_MISSES > > > FROM V$LATCH WHERE NAME LIKE '%redo%' > > > / > > > > > > NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES > > > > > > -- -- -- -- > > > > > > redo allocation 74878 16 00 > > > > > > redo copy 114100 53756 232 > > > > > > redo writing30219 1 00 > > > > > > 3 rows selected. > > > > > > Realizing small contention on redo allocation latch, I increased > > > the value of "log_small_entry_max_size" from 80 to 90. > > > But this would definitely overload (already suffering) redo copy > > > latches, so I increased the value of log_simultaneous_copies from 2 to > > > 6. > > > This sorted out redo latch contention, but somewhere in FM it's > > > mentioned that value of log_simultaneous_copies shouldn't be more than > > > (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. > > > So... > > > > > > 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are > > > the golden rules. I have seen some authers not mentioning this. > > > > > > 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the > > > algorithm?? What is the new strategy to handle redo latch contention?? > > > > > > Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they > > > still talk of these parameters(which are made obsolete)... > > > > > > Appreciate your inputs ;-) > > > > > > Cheers, > > > Rajesh > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Rajesh Dayal > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > >
Re: performance impact of optimizer_search_limit
Steve, You might also want to test setting optimizer_max_permutations < 8. By design, the CBO considers multiple starting tables and restricts permutations during OR expansion when optimizer_max_permutations < 8. This can have a significant impact on queries that join a large number of tables or have a large number of OR expansions. I believe apps 11i (not sure about 11.0), for example, recommends setting this to 7. HTH, -- Anita --- "Wilkes, Steve" <[EMAIL PROTECTED]> wrote: > Hi, > > Oracle 8.0.5 > AIX 4.3.3 > > I have improved the response time of one of my 8 > table join queries by > increasing optimizer_search_limit from the default 5 > to 8. At the value of 8 > the plan changes and has made a 10 min query run in > under 5 seconds. The > optimizer is set to CHOOSE with the statistics up to > date and a sample size > of 20%. This is a third party application and I > don't have access to the > source code to add hints. The value of > optimizer_max_permutations has been > left at 8. > > I know that this makes the optimizer now check > 8!=40320 permutations instead > of 5!=120 permutations. I expect the parse time to > increase but does anyone > have any experience as to the performance impact > that this may have? Any > horror stories? > > Thanks in advance. > > Steve Wilkes > > _ > Oracle DBA > npower > > = > This email and any files transmitted with it are > confidential and > intended solely for the use of the individual or > entity to whom they > are addressed. If you have received this email in > error please notify > gpupower.co.uk or [EMAIL PROTECTED] > > This outgoing e-mail (and any attachments) has been > checked > (using Sophos Sweep 3.45 + patches) before leaving > us (UK 08457 353637), > and has been found to be clean from any virus > infection. > > = > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Wilkes, 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). __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Statspack report !! Resending Can someone help Please
Hierarchical, network and relational. That's what it was. My true age is - as per 4th of May this year - is 40. Big party, band playing, etc. About 130 guests. My wish list for all the guests I had invited was very short. Among the very few items were black socks, the latest book by John le Carre, a Leatherman Supertool and a Swiss Army knife. Well, I got three Swiss army knives, three Supertool's, six copies of le Carre's latest book...and 67 pairs of black socks. Oh, I got 13 bottles of excllent whisky, too. Well, one of Cary Millsap's relatives sent me two pairs of socks last week, explaining that 67 was 2 short of 69 - and that this would probably be the closest I got to 69 for a while...and Cary wants me to beleive it wasn't his idea. Rather cool relatives he's got himselves, this mr. Millsap. John Kanagaraj wrote: > Hi Mogens, > > >I think SQL*Net was called SQL*Star or something, at least > >with version 5? > > SQL*Star, as I remember it was SQL*Net + OpenGateway (or something like > that). It was basically SQL*Net to other DBMS. (And there were three types > of DBMS's - Hierarchical, something else, and that new-fangled Relational). > Never got it to work other than test databases... > > >Back in the gold old days, when Oracle2 was written in > >assembly and running on > > Now we know your true age Mogens ;-) > > John Kanagaraj > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDeveloper Connection to Oracle DB
Hi again, Thanks for your tip Anita, but unfortunately I still get the same error message. So I guess I am still taking suggestions. Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com Quoting "A. Bardeen" <[EMAIL PROTECTED]>: > Elias, > > I don't know much about JDBC, but I suspect that like > ODBC it sits on top of the Net8 layer. By default, > Personal Oracle on Win95/98 doesn't automatically > start the listener the way the TNSlistener service > does on NT/Win2K, so try manually starting the > listener from the command prompt: > > lsnrctl start > > You can set the listener to start up up automatically > by changing the registry entry LISTENER_STARTUP to > AUTO > hkey_local_machine\oracle\home0 > > HTH, > > -- Anita > > --- Elias Mouchantaf <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have installed JDeveloper 3.0 and I am running > > Oracle > > 8i personal edition on a Windows 98 platform. I am > > trying to create a connection to the DB from > > JDeveloper. I specify the "Oracle JDBC Thin" as > > driver > > and I select "Existing TNS Names" as the connection > > method and I choose the service running. When I > > click > > on the "Test Connection" button I get an error > > message > > that reads: "Io Exception: The Network adapter could > > > > not establish the connection". I tried to resolve > > the > > problem but was unable to. I would appreciate any > > help. > > > > Thank you, > > > > Elias S. Mouchantaf > > Tel. (+961) 3 740319 > > [EMAIL PROTECTED] > > www.moshnet.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Elias Mouchantaf > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > -- -- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: A. Bardeen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -- -- > To REMOVE yourself from this mailing list, send an E- Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Mogens' Age ;) [RE: Statspack report !! Resending Can someone
Hey John, If you had come to IOUG-A 2001! conference and attended Cary's presentation, you would have been part of a special group (all the attendees in the room, that is) that yelled out "Happy Birthday, Mogens" over a cellular phone call to Mogens. Now, who can top that idea (Cary's, I suspect) !! But that's how I came to know his true age. - Kirti Deshpande Verizon Information Sevices http://www.superpages.com > -Original Message- > From: Mogens Nørgaard [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, June 16, 2001 5:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Statspack report !! Resending Can someone help Please > > Hierarchical, network and relational. That's what it was. > > My true age is - as per 4th of May this year - is 40. Big party, band > playing, > etc. About 130 guests. My wish list for all the guests I had invited was > very > short. Among the very few items were black socks, the latest book by John > le > Carre, a Leatherman Supertool and a Swiss Army knife. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: * I'm Looking for an Oracle Financials DBA for Miami, Florida..
On June 16, 2001 04:35 am, Jared Still wrote: >Many of > us consider this a service, especially the way that jobs are > at the moment. Amazing the difference a year can make, eh? Cheers, GC (obviously a canuck) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tuning Sorts
--- "Hillman, Alex" <[EMAIL PROTECTED]> wrote: > Sort allocate memory in chunks of 8K, Is that the general rule or does it depend on any parameter? > should worry only in case > when there are too many users who are doing large > sorts simultaniously. Also > I think memory is freed when records returned ( I am > not sure). Docs say that the memory once allocated to a sort is not retured to to OS but to the PGA. The docs are silent about when the memory is returned to the OS. Is it when user session ends or at instance restart?. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tuning Sorts
> silent about when the memory is returned to the OS. Is > it when user session ends or at instance restart?. When the session ends. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8i installation problem
Hi All, Before I explain what I did, here is the system configuration details : Hardware : CPU : Intel Pentium III 500 Mhz RAM : 256MB HDD : 15GB Software : OS : Solaris 8 for Intel Oracle : Oracle 8.1.7 Rel 3 I first changed the /etc/system file by adding these entries as it is given in the install.htm file. But it failed. set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_sshmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=100 I tried it for the second time by using the original system generated file (the default) and it fails even then. I suppose it is due to the shm parameters in the /etc/system file. Does anyone know what combination of shm parameters to use with my HW configuration ? Is it possible to copy these files onto a floppy with DOS format from Solaris. This way, I Can email you the files atleast. I know that my Solaris skills are pretty bad. I'm waiting for the Solaris 8 installation books to be released so that I can get myself certified. Any idea which are the trace & log files that I need to look into. Thanks, __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pankaj Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation problem
Hi Pankaj, With 256 MB RAM, you may not be able to set set shmsys:shminfo_shmmax=4294967295 Try setting it to lower values 1-2 GB, It should resolve the issue. Of course it shdn't have any impact on Oracle's functioning ( If you have just 256 MB, you can't allocate 4 GB to one single Mem Segment right??). HTH, Rajesh -Original Message- Kumar Sent: Sunday, June 17, 2001 8:40 AM To: Multiple recipients of list ORACLE-L Hi All, Before I explain what I did, here is the system configuration details : Hardware : CPU : Intel Pentium III 500 Mhz RAM : 256MB HDD : 15GB Software : OS : Solaris 8 for Intel Oracle : Oracle 8.1.7 Rel 3 I first changed the /etc/system file by adding these entries as it is given in the install.htm file. But it failed. set shmsys:shminfo_shmmax=4294967295 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=100 set shmsys:shminfo_sshmseg=10 set semsys:seminfo_semmni=100 set semsys:seminfo_semmsl=100 set semsys:seminfo_semmns=200 set semsys:seminfo_semopm=100 set semsys:seminfo_semvmx=100 I tried it for the second time by using the original system generated file (the default) and it fails even then. I suppose it is due to the shm parameters in the /etc/system file. Does anyone know what combination of shm parameters to use with my HW configuration ? Is it possible to copy these files onto a floppy with DOS format from Solaris. This way, I Can email you the files atleast. I know that my Solaris skills are pretty bad. I'm waiting for the Solaris 8 installation books to be released so that I can get myself certified. Any idea which are the trace & log files that I need to look into. Thanks, __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pankaj Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation problem
Hi Rajesh, Thanks for the info. I was not aware what shmmax value was, though, I knew it is related to memory. I had even left the /etc/system file unchanged during my 2nd installation attempt (I had copied system to system.org) and tried. But it fails there too. Thanks, gopi --- Rajesh Dayal <[EMAIL PROTECTED]> wrote: > Hi Pankaj, > With 256 MB RAM, you may not be able to set > > set shmsys:shminfo_shmmax=4294967295 > > Try setting it to lower values 1-2 GB, It should > resolve the issue. Of course it shdn't have any > impact on > Oracle's functioning ( If you have just 256 MB, you > can't > allocate 4 GB to one single Mem Segment right??). > > HTH, > Rajesh > -Original Message- > Kumar > Sent: Sunday, June 17, 2001 8:40 AM > To: Multiple recipients of list ORACLE-L > > > Hi All, > > Before I explain what I did, here is the system > configuration details : > > Hardware : > CPU : Intel Pentium III 500 Mhz > RAM : 256MB > HDD : 15GB > > Software : > OS : Solaris 8 for Intel > Oracle : Oracle 8.1.7 Rel 3 > > I first changed the /etc/system file by adding these > entries as it is given in the install.htm file. But > it > > failed. > > set shmsys:shminfo_shmmax=4294967295 > set shmsys:shminfo_shmmin=1 > set shmsys:shminfo_shmmni=100 > set shmsys:shminfo_sshmseg=10 > set semsys:seminfo_semmni=100 > set semsys:seminfo_semmsl=100 > set semsys:seminfo_semmns=200 > set semsys:seminfo_semopm=100 > set semsys:seminfo_semvmx=100 > > I tried it for the second time by using the original > system generated file (the default) and it fails > even > then. I suppose it is due to the shm parameters in > the /etc/system file. > > Does anyone know what combination of shm parameters > to > > use with my HW configuration ? > > Is it possible to copy these files onto a floppy > with > DOS format from Solaris. This way, I Can email you > the > > files atleast. > > I know that my Solaris skills are pretty bad. I'm > waiting for the Solaris 8 installation books to be > released so that I can get myself certified. > > Any idea which are the trace & log files that I need > to look into. > > Thanks, > > __ > Do You Yahoo!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Pankaj Kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pankaj Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation problem
You have to increase this value. The default value would be too small. I'm not aware of default on solaris, but on TRU64 it's somewhere around 45 MB ( don't remember exactly)... So just increase this value to 1-2 GB and try once more, this should succeed. Rajesh -Original Message- Kumar Sent: Sunday, June 17, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Hi Rajesh, Thanks for the info. I was not aware what shmmax value was, though, I knew it is related to memory. I had even left the /etc/system file unchanged during my 2nd installation attempt (I had copied system to system.org) and tried. But it fails there too. Thanks, gopi --- Rajesh Dayal <[EMAIL PROTECTED]> wrote: > Hi Pankaj, > With 256 MB RAM, you may not be able to set > > set shmsys:shminfo_shmmax=4294967295 > > Try setting it to lower values 1-2 GB, It should > resolve the issue. Of course it shdn't have any > impact on > Oracle's functioning ( If you have just 256 MB, you > can't > allocate 4 GB to one single Mem Segment right??). > > HTH, > Rajesh > -Original Message- > Kumar > Sent: Sunday, June 17, 2001 8:40 AM > To: Multiple recipients of list ORACLE-L > > > Hi All, > > Before I explain what I did, here is the system > configuration details : > > Hardware : > CPU : Intel Pentium III 500 Mhz > RAM : 256MB > HDD : 15GB > > Software : > OS : Solaris 8 for Intel > Oracle : Oracle 8.1.7 Rel 3 > > I first changed the /etc/system file by adding these > entries as it is given in the install.htm file. But > it > > failed. > > set shmsys:shminfo_shmmax=4294967295 > set shmsys:shminfo_shmmin=1 > set shmsys:shminfo_shmmni=100 > set shmsys:shminfo_sshmseg=10 > set semsys:seminfo_semmni=100 > set semsys:seminfo_semmsl=100 > set semsys:seminfo_semmns=200 > set semsys:seminfo_semopm=100 > set semsys:seminfo_semvmx=100 > > I tried it for the second time by using the original > system generated file (the default) and it fails > even > then. I suppose it is due to the shm parameters in > the /etc/system file. > > Does anyone know what combination of shm parameters > to > > use with my HW configuration ? > > Is it possible to copy these files onto a floppy > with > DOS format from Solaris. This way, I Can email you > the > > files atleast. > > I know that my Solaris skills are pretty bad. I'm > waiting for the Solaris 8 installation books to be > released so that I can get myself certified. > > Any idea which are the trace & log files that I need > to look into. > > Thanks, > > __ > Do You Yahoo!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Pankaj Kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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: Rajesh Dayal > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pankaj Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rajesh Dayal INET
