Re: Fwd: RE: !! *Very* important Oracle-L message !!
May be I'm a naive idiot (Forrest Gump :-)), but have somebody asked Oracle to sponzor this community of Oracle users? Jan Pruner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Clarification on External procedure in Oracle 8.1.6
Title: Clarification on External procedure in Oracle 8.1.6 Hi all... I believe any of u Would be of GREAT help... I have been trying Calling C functions from pl/sql using Oracle 8i's External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it is failing at connect itself. I have used EXEC SQL Connect username identified by passwd; The same Pro*c WORKS FINE when I try it from the command line. Have any of u tried calling Pro*C from Pl/sql. If YES. could u .. Send me an example or some resource from wherein I can proceed with my work. Thanx a lot in advance Ramesh.
DB Monitoring
What Monitoring Activities Need to be Carried Out on Large Databases ( Excess of 100 GB ) ? Any Experiences , best Practices , Documents , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Fwd: Re: How to select and display 10 records at a time from a table using sql query
You can use the Rank () function to rank your rows based on a simple or complex criteria in a subquery or an inline view and then extract the requisite set by using a simple condition on the Rank col. Below is a simple example just to give you some idea of what is possible. You may want to take a look at some ref manual to explore this for meeting your particular requirement (Best place is Datawarehousing Guide): SELECT keycol, some_other_col(s) FROM (SELECT keycol, some_other_col(s), RANK() OVER (ORDER BY keycol) AS Ranking FROM mytable WHERE condition(s) ) WHERE ranking between 11 and 20; == alter this cond. to get a different set. You can use more complex criteria in ranking/ordering your rows. --- Jan Pruner [EMAIL PROTECTED] wrote: Does anybody know how to do it better way? But this will return only the first ten rows not subsequent sets. How do I display rows from 11 to 20, 21 to 30 and so on? ROWNUM is counting output tuples. You cannot use ROWNUM 10. I think you have to order select by your primary key, make filter based on your primary key and take only first 10 tuples using ROWNUM. JP -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jan Pruner Sent: Wednesday, August 29, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to select and display 10 records at a time from a table using sql query select * from ( select column1, column2 from my_table order by 1) where ROWNUM 11; Look at manual how to use ROWNUM. It's ease to make mistakes with it. JP Dne st 29. srpen 2001 10:55 jste napsal(a): Dear DBA Gurus, How do I select and display 10 records at a time from a table using sql query only? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
RE: financial problems with fatcity.com
As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to select and display 10 records at a time from a table using sql query - Solved
Dear all, Here is the query to do the same: select outer.* from(select inner.*,ROWNUM as Query_Rownum from (select * from tablename)inner where Rownum =to) outer where Outer.Query_Rownum=from / Hope this helps! Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: insert into table .... values....
Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists how to do the folloiwng inserts into a table? table xyz has col1,col2, col3. I need to populate the values to col1 from table dummy1 (cola) col2 table dummy2(colb) col3 table dummy3(colc). there is no relation between dummy1 , dummy2, dummy3. We cannot join these tables. can I insert data into xyz in a single shot. is there anything like insert into xyz values((select cola from dummy1 where), (select colb from dummy2 where), (select colc from dummy3 where ) ); srinivas. insert into xyz select v1.cola, v2.colb, v3.colc from (select cola from dummy1 where ...) v1, (select colb from dummy2 where ...) v2, (select colc from dummy3 where ...) v3; But be certain that each of the WHERE conditions returns a single row (beware of cartesian products). IMHO it may be easier to spool the contents of dummy1, dummy2, dummy3 to flat files, load them into your favourite spreadsheet, do whatever you want, save it as a CSV file and load with SQL*Loader. It will probably take you less time. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.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: Clarification on External procedure in Oracle 8.1.6
please anyone tell me how to call external procedures(C) from plsql with an example. -Original Message- From: Ramesh_Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Clarification on External procedure in Oracle 8.1.6 Hi all... I believe any of u Would be of GREAT help... I have been trying Calling C functions from pl/sql using Oracle 8i's External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it is failing at connect itself. I have used EXEC SQL Connect username identified by passwd; The same Pro*c WORKS FINE when I try it from the command line. Have any of u tried calling Pro*C from Pl/sql. If YES. could u .. Send me an example or some resource from wherein I can proceed with my work. Thanx a lot in advance Ramesh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: financial problems with fatcity.com
Surely those of us in the UK can pay electronically (say via Credit Card)??. I've done this for other things such as DVDs (15$) etc. Lee -Original Message- Sent: 30 August 2001 09:55 To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or
RE: !! *Very* important Oracle-L message !!
I'm in too DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 29, 2001 10:28 PM To: Multiple recipients of list ORACLE-L Hola, I think a subscription is the best solution. I have learned too much reading the solutions to the posts that everyday show up, and mines too. Can count on me !!! Regards, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase. After some discussions with Jared (the list owner), and some encouragement from him, I am coming to you to ask for you help in keeping Fat City financially afloat until I can be self sufficient. I'm not asking for a specific dollar amount from anyone, nor am I *expecting* anything from you folks. But if it is within your power to contribute some money towards this end (and yes, I know these are hard financial times for everyone), I am hoping you can help. If I can get sufficient promise of funds that will see me through the next few months, I am willing to jump in with both feet and make Fat City a viable business. If it looks like the contributions are not sufficient to enable me to do that, I will cease operations within the next 45-60 days. Let me be clear about a few things: If I *do* cease operations, I will give all of my lists time to find new list providers, and will make every effort to aid the shift over to the new provider, provide list dumps, archives, mail forwarding, etc. Even though Rhythms goes out of business on 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable this to happen. So don't worry about having to rush into your conversion if things don't work out. I would
RE: financial problems with fatcity.com
Lee, They are considering payments by PayPal - www.paypal.com This does in fact let you pay by credit card, and look like a nice easy way of doing it also.. -Original Message- Lee - lerobe Sent: Thursday, August 30, 2001 10:57 To: Multiple recipients of list ORACLE-L Surely those of us in the UK can pay electronically (say via Credit Card)??. I've done this for other things such as DVDs (15$) etc. Lee -Original Message- Sent: 30 August 2001 09:55 To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The
database consistency tools ?
Hello, Excuse me for this maybe dummy question, I am new at Oracle and coming from Sybase world, I subscribed to this list 1 week ago. If my question is answered somewhere in archived place, please feel free to direct me to this place. I am looking for Oracle built-in tools to check/verify consistency of the db/tables/indexes etc... Sybase provides a set of tools to verify/check/repair the database/tables/indexes logical and physical consistency called dbcc . This will allow to check allocation structures , page and object linkage (sybase page is equivalent to an oracle block and an object is a table,index,view...). To say that in Oracle words, the tools will verify that the oracle block(s)/extent(s) which are allocated to an objectis/are effectively allocated to this object and that the different blocks/extents(s) are correctly linked together. Does this make sense to you ? Thanks, Maya
Re: Fwd: RE: !! *Very* important Oracle-L message !!
No, and I don't think we should. Oracle sponsorship would mean they might want to control contents of the list IOUGA sponsors user groups - it's a remote possibility that we could get them to define us as a user group and then give us a grant to cover Bruce's expenses. But it would take longer than Bruce has at the moment. From: Jan Pruner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Fwd: RE: !! *Very* important Oracle-L message !! Date: Wed, 29 Aug 2001 23:30:23 -0800 May be I'm a naive idiot (Forrest Gump :-)), but have somebody asked Oracle to sponzor this community of Oracle users? Jan Pruner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tab ascii value
Title: RE: tab ascii value This script prints the ascii table whole. May be usefull. Bunyamin set serveroutput on size 10240 declare i number; j number; k number; begin for i in 2..15 loop for j in 1..16 loop k:=i*16+j; dbms_output.put((to_char(k,'000'))||':'||chr(k)||' '); if k mod 8 = 0 then dbms_output.put_line(''); end if; end loop; end loop; end; - Original Message - From: Bryan S To: Multiple recipients of list ORACLE-L Sent: Thursday, August 30, 2001 5:25 AM Subject: Re: tab ascii value I'm not sure about the tab. I didthe following ('tab' is between the ' '): SQL select dump(' ') from dual; DUMP('')Typ=96 Len=1: 32 SQL select chr(32) from dual; C- It looks like a tab, but since it is a nonprinting character, it's hard to tell. I'm pretty sure new line is 13 ( appears as ^M line ending char when viewed in vi). I looked it up once online, and I did the following: SQL select chr(013) from dual; C- SQL select 'you' || chr(13) || 'me' || chr(13) || 'us' 2 from dual; 'YOU'||CH-youmeus HTH, Bryan - Original Message - From: Jacques Kilchoer To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 28, 2001 2:21 PM Subject: RE: tab ascii value -Original Message- From: Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] how to find out the ascii value of tab, new line for new line it is 10 for tab it is 9 but how to get from the following statement. select ascii(??) from dual; I don't remember if this has been answered already, but read the documentation on the DUMP and CHR functions. SQL select dump ('A') from dual ; DUMP('A') Typ=96 Len=1: 65 SQL select chr (65) from dual ; C - A
!! *Very* important Oracle-L message !!
Jared, I'm in for $12. Dias Costa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! *Very* important Oracle-L message !!
Do I have an Amen? Yes ! Orr, Steve wrote: I like Jeremiah's idea. All the sermonizing about the value of the list and how we should be required to put something in the offering basket is just so much preaching to the choir. :-) I would gladly pay a subscription fee because I understand the value of the list after having been on it a few years. HOWEVER, a newcomer may not appreciate the value of the list without having seen any content over time (as we all have). Requiring an up front entrance fee would probably scare them off like fire and brimstone sermon. If entrance to the list is free then we can better evangelize new believers in the list. Broad participation keeps the list healthy. In order to keep the list healthy we need to be constantly adding new members and the best way to do this is to make it free and easy. Another approach would be to make the first 6 months free but this could be an administrative burden to enforce. So I think voluntary contributions are the way to go... Do I have an Amen? IMHO, Steve Orr -Original Message- Sent: Wednesday, August 29, 2001 11:27 AM To: Multiple recipients of list ORACLE-L On my web page I maintain an Amazon.com payments paybox, which is for collecting anonymous donations. I think if Bruce sets up a paybox for each list he hosts free of charge, and included a pledge request in the list footers, there will be a steady stream of donations. Amazon calls this the Honor System, and it can be found at: http://auctions.amazon.com/exec/varzea/subst/fx/home.html It is basically like paypal, etc, but you can put the paybox inline with any HTML, and it allows anonymous donations. The fee to Amazon is 15% of the total payment per transaction plus 15 cents. I work for Amazon, so feel free to flame me for shamelessly promoting my own product as a solution to this. As an act of contrition, I promise to pay US$50 into any form of collection that Bruce sets up, Amazon or not. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 29 Aug 2001, Anjan Thakuria wrote: Can we just start pledging ..We have got to keep this form going under. Ideas -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution
Re: How to select and display 10 records at a time from a table using sql query - Solved
your query is equivalent to , select * from tablename where rownumnum =10; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:55 PM using sql query - Solved Dear all, Here is the query to do the same: select outer.* from(select inner.*,ROWNUM as Query_Rownum from (select * from tablename)inner where Rownum =to) outer where Outer.Query_Rownum=from / Hope this helps! Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Parallelism in oracle8i
Hi, We are doing testing of oracle 8i parallelism features on unix HP 11 . We have done 2 partitions on the table ib020mb_3 on a field adt_date with the following details (partition p1 values less than('22-apr-2000') tablespace CONTRACT, partition p2 values less than('01-jUn-2000')tablespace CONTRACT1). Each of these partitions are in different tablespace. Each of this tablespace are on different disks(data files on different disk ) in unix environment. We have 4 processors and 4 controllers (like disk drives) to write on disk. With this details we are running the following query with and without degree of parallelism specified. select adt_date from ib020mb_3 where adt_date '01-jun-2000' But we are taking more time with parallelism. We have tried the query with different degrees of parallelism. Currently we are fetching approx. 15 lac records. We have tested with a different table and different set of records but still we are taking more time with degree of parallelism specified. Could you please suggest why we are taking more time . The following are the tkprof generated for this queries: == 1) Without parallelism: select adt_date from ib020mb_3 where adt_date '01-jun-2000' call count cpuelapsed disk query current rows --- -- -- -- -- -- --- Parse1 0.12 0.31 21204 5 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 101340 11.37 16.48 7107 107826 0 1520078 --- -- -- --- -- - total 101342 11.49 16.79 7128 108030 5 1520078 Total time taken : 28.28 2)With parallelism: select /*+parallel(ib020mb_3,2)*/ adt_date from ib020mb_3 where adt_date '01-jun-2000' call count cpuelapsed disk query currentrows --- -- -- -- --- -- -- Parse1 0.13 0.61 21243 6 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 101340 11.72 16.79 7107 107826 0 1520078 --- -- -- - total 101342 11.85 17.40 7128 108069 6 1520078 Total time taken :29.25 == === Thanks In Advance __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Soman Manoj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! Keeping the list alive
Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NT-Question: Where to put TNS_ADMIN
hi, Ora817 documentation says, that I have to put TNS_ADMIN under each ...\SOFTWARE\ORACLE\HOMEn . And it works very well on a machine with four OraHomes! But on another machine with only 806-installation I have to put it under ...\SOFTWARE\ORACLE. Is there any rule behind that? Where do I find more about Net*8 and the registry? Thanx a lot Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner Weg 22-24 D-52070 Aachen Telefon:+49 241 / 9 18 79-33 Fax:+49 241 / 15 40 38 mailto:[EMAIL PROTECTED] http://www.soptim.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN tuning
Thanks Tom!RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 4:50 PM Ruth, According to Michael: Tom: I haven't got a change to test it. I will try it sometime today. However, page 11-11 of Oracle8i Backup and Recovery Guide (8.1.5) states that Do not use this port-specific string if you have specified type disk. Thanks, Michael I haven't tried it for disk, as I am backing up to tape and am happy about it. I mentioned that when I tested this param on NT/EDM, I experienced marked improvements by setting this value from the default of 64k up to 2M. There was no appreciable difference setting the parameter higher. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Tom, Does this only work for tape? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 9:10 AM Michael, You might look at the BLKSIZE parameter. I did some basic tests using NT and the EDM client, and found that setting the BLKSIZE to 2 Meg was the fastest for my installation. I think the default is 64k. You set the parameter like: allocate channel d2 type 'SBT_TAPE' parms 'BLKSIZE=2097152'; Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, August 28, 2001 9:26 PM To: Multiple recipients of list ORACLE-L Hi All, I use RMAN to do a full backup of 120G database while the database is up running. It takes around 6 hours to finish. I have 61 data files and manually allocate 6 channels. For all the RMAN parameters such as FILESPERSET, I take the default. Does anybody there know how to maximize the throughput? Thanks, Michael This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xin \Michael\ Wu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
External procedures - How to make extproc.dll ?
Hi all, Oracle 8.1.6, OS - win NT. I have an requirement to call an external procedure through Pl/sql. I adopted all the steps guidelined by oracle, but only i'm stucking with creating the extproc.dll file in oracle home. when i try to run the dos batch file oracle_home\plsql\demo\make.bat, system prompting me, is not a valid command etc. But i don't have any compliers for C/C++/Pro*c. I just have oracle 816 in my local PC. Can anybody insist me what i have do done to succeed. Rgds, Nirmal Kumar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fwd: RE: !! *Very* important Oracle-L message !!
I don't think they would agree to that as they would point to MetaLink. Jon Walthour -Original Message- Sent: Thursday, August 30, 2001 3:30 AM To: Multiple recipients of list ORACLE-L May be I'm a naive idiot (Forrest Gump :-)), but have somebody asked Oracle to sponzor this community of Oracle users? Jan Pruner -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: financial problems with fatcity.com
So then the Canadian conversion would be $20 US . 28 Loonies in Canada!! You gotta love a currency called the loonie!! I got to spend a lot of time in Winnipeg and I really liked. Dave -Original Message- Sent: Thursday, August 30, 2001 3:55 AM To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: !! *Very* important Oracle-L message !!
Ok for people living in US. How about people willing to contribute but living overseas? Regards -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 00:29 To: Multiple recipients of list ORACLE-L Subject: !! *Very* important Oracle-L message !! Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a "State of the Union" address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase. After some discussions with Jared (the list owner), and some encouragement from him, I am coming to you to ask for you help in keeping Fat City financially afloat until I can be self sufficient. I'm not asking for a specific dollar amount from anyone, nor am I *expecting* anything from you folks. But if it is within your power to contribute some money towards this end (and yes, I know these are hard financial times for everyone), I am hoping you can help. If I can get sufficient promise of funds that will see me through the next few months, I am willing to jump in with both feet and make Fat City a viable business. If it looks like the contributions are not sufficient to enable me to do that, I will cease operations within the next 45-60 days. Let me be clear about a few things: If I *do* cease operations, I will give all of my lists time to find new list providers, and will make every effort to aid the shift over to the new provider, provide list dumps, archives, mail forwarding, etc. Even though Rhythms goes out of business on 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable this to happen. So don't worry about having to rush into your conversion if things don't work out. I would also like to clearly state that this is not some attempt to blackmail or coerce anyone into coming up with money. This
Re: External procedures - How to make extproc.dll ?
Install C++ compiler. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 8:30 AM Hi all, Oracle 8.1.6, OS - win NT. I have an requirement to call an external procedure through Pl/sql. I adopted all the steps guidelined by oracle, but only i'm stucking with creating the extproc.dll file in oracle home. when i try to run the dos batch file oracle_home\plsql\demo\make.bat, system prompting me, is not a valid command etc. But i don't have any compliers for C/C++/Pro*c. I just have oracle 816 in my local PC. Can anybody insist me what i have do done to succeed. Rgds, Nirmal Kumar. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: football fan-hood
I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: football fan-hood
Title: RE: OT: football fan-hood BLASPHEMY! -Original Message- From: Scott Shafer [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 6:35 PM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood Lisa's really a Dolphins phan in purple viking drag... --Scott Paul Baumgartel wrote: Lisa, The stereotypical football fan is, of course, a male, whose wife/significant other usually wants nothing to do with the sport. I've often wondered what might inspire a woman to follow football--care to satisfy my curiosity? Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] Lisa Koivu Vikings Fan and DBA Ft. Lauderdale, FL, USA ). _ 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: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: financial problems with fatcity.com
Hi Gang, I was reading all the comments, and saw the one about 'Corporate' sponsorship ... BILL LAW of OraStaff - don't you feel this is a good opportunity .. ? (Don't you feel a moral obligation?) Regards Oweson Flynn -- A clean limerick is a contradiction in terms. Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] -Original Message- Lee - lerobe Sent: 30 August 2001 11:57 To: Multiple recipients of list ORACLE-L Surely those of us in the UK can pay electronically (say via Credit Card)??. I've done this for other things such as DVDs (15$) etc. Lee -Original Message- Sent: 30 August 2001 09:55 To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
RE: OT: football fan-hood
Title: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Monitoring
Title: RE: DB Monitoring HI Vivek, off the top of my head: Number of extents - any reaching huge numbers? Tablespaces running out of room? Drives on the host filling up? Any jobs that have been running over 24 hours? Possible zombie processes? Top 10 most resource-intensive queries. Can they be tuned? utlbstat/utlestat - anything stand out? And most importantly, is the DATABASE UP? Page immediately if it isn't. I'm sure there's much more. This is just a start. And again I advocate home-cooked scripts in comparison to any gui tool doing this for you. Lisa Koivu VIKINGS FAN and DBA Ft. Lauderdale, FL, USA -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 3:55 AM To: Multiple recipients of list ORACLE-L Subject: DB Monitoring What Monitoring Activities Need to be Carried Out on Large Databases ( Excess of 100 GB ) ? Any Experiences , best Practices , Documents , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: financial problems with fatcity.com
Title: RE: financial problems with fatcity.com THAT IS A FANTASTIC IDEA Oweson. If he places one person from this list he can sure afford it. -Original Message- From: Oweson Flynn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:22 AM To: Multiple recipients of list ORACLE-L Subject: RE: financial problems with fatcity.com Hi Gang, I was reading all the comments, and saw the one about 'Corporate' sponsorship ... BILL LAW of OraStaff - don't you feel this is a good opportunity .. ? (Don't you feel a moral obligation?) Regards Oweson Flynn -- A clean limerick is a contradiction in terms. Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] -Original Message- Lee - lerobe Sent: 30 August 2001 11:57 To: Multiple recipients of list ORACLE-L Surely those of us in the UK can pay electronically (say via Credit Card)??. I've done this for other things such as DVDs (15$) etc. Lee -Original Message- Sent: 30 August 2001 09:55 To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ:
RE: DB Monitoring
Same things for a 1G database in my opinion. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 30, 2001 3:55 AM To: Multiple recipients of list ORACLE-L What Monitoring Activities Need to be Carried Out on Large Databases ( Excess of 100 GB ) ? Any Experiences , best Practices , Documents , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NT-Question: Where to put TNS_ADMIN
I usually just make sure that all of my tnsnames files and listeners match. Then using only one of the listenters I am able to connect to all of the db's. Sincerely, Kev -Original Message- Sent: Thursday, August 30, 2001 8:08 AM To: Multiple recipients of list ORACLE-L hi, Ora817 documentation says, that I have to put TNS_ADMIN under each ...\SOFTWARE\ORACLE\HOMEn . And it works very well on a machine with four OraHomes! But on another machine with only 806-installation I have to put it under ...\SOFTWARE\ORACLE. Is there any rule behind that? Where do I find more about Net*8 and the registry? Thanx a lot Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner Weg 22-24 D-52070 Aachen Telefon:+49 241 / 9 18 79-33 Fax:+49 241 / 15 40 38 mailto:[EMAIL PROTECTED] http://www.soptim.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Blum, Marc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: is this a resource problem?
Hi, It would have been helpful to include the whole select statement. Anyway.: If your where clause is pretty straightforward (where word ='UNIVERSITY' for instance) it may help to index the columns in the where clause. Proper indexing and it should run normal. If you have functions in your where clause (to_char for instance) than prior to 8i you where left in the cold so to speak. In 8i you can than use function based indexes. Jack Bufnea Darius [EMAIL PROTECTED]@fatcity.com on 30-08-2001 15:06:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) hi guys, first sorry my English and second sorry if this is a stupid question (or it's the wrong place to ask it) I'm new to Oracle (few mounts) and I developed a search engine for my Univeristy. One of the table of the database contains pairs of (word, id_url). This pair is also the primary key. So, after I insert around 300.000 words in the table the server get realy slowly (aroud 30 seconds for something like this select * from words where ...). I'll expect to have more than 1.200.000 pairs (word, id_url) in my table. The machine is what my University afford, a PIII 700 Mhz machine, 256 Mb RAM, running windows nt 4 server. Can I do someting to speed up the procces (I dont know what - reindexing, etc) or I really need a monster sun entreprise edition with 8 processor :( Thanks, Darius __ Do you want a free e-mail for life ? Get it at http://www.personal.ro/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bufnea Darius INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: Flat File vs. Database
ACID Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 29, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Hi all, We are proposing a project to convert applications that use flat files to Oracle databases. An essential piece of this proposal is to present to the management the advantages of databases over flat files. Are there any websites, whitepapers that talk about this? I know this probably is a no-brainer for most of you but we just want to have all of our ducks in a row so that we can make a strong case. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: 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: OT: football fan-hood
Title: RE: OT: football fan-hood Who's your favorite hockey team? Just curious since you grew up in snowda. Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Thursday, August 30, 2001 9:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: constraints in create table..
Title: Message Try inserting into it, you will not be able to insert anything. Although Oracle allows it, it will not let you put data in it. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 2:31 PMTo: Multiple recipients of list ORACLE-LSubject: constraints in create table.. hi all, do anybody explain me what is happening when i'm creating a table with the following constraints.. CREATE TABLE TAB1( ENUM NUMBER PRIMARY KEY CHECK(ENUM IS NULL), ENAME VARCHAR2(10) ); why i'm being able to create table with such contradicting constraints. both can't be true at the same time. i can't have null in aprimary key. what's the significance of this DDL. thanks in advance.. Saurabh Sharma
Re: Install oracle 7.3.4 in Solaris.
Been there, done that. An installation manual comes from Oracle with the software. Follow it exactly. Do not use an installation manual for a different platform or a different version of Oracle. Every one of them is slightly different and just enough different to mess up your installation. Read the installation manual cover to cover before you begin. Nguyen Thanh-truc To: Multiple recipients of list ORACLE-L truc@nguyen.[EMAIL PROTECTED] as cc: Sent by: Subject: Install oracle 7.3.4 in Solaris. root@fatcity. com 08/29/2001 07:19 PM Please respond to ORACLE-L Hello listers, I have to install a server Oracle (7.3.4) on Sun Solaris but i've never done that before. Could some one show me the steps to follow or give me some address where i can find the informations please ? Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen Thanh-truc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Logical Backup for a large database
Duplicate your database using RMAN. Then export/import the table that was dropped. Of course, this means that you need to have an extra 150 Gb of disk space lying around. -Original Message- Sent: Monday, August 27, 2001 5:11 PM To: Multiple recipients of list ORACLE-L DBAs Last week one of my user dropped a table since we don't have any backup except for rman backup. It is not allowe me to do any recovery on 7/24 database. Anyway we recreate the table(we are lucky, this table hold parameters) This make me think of situation of lossing very important big table. We have about 1000 tables with bigget one of 8GB . Is there any idea how to perform a logical backup on a database with 150GBs. Or take a TSPITR in case of those kind of thing happen again. From my case, imp/exp looks impossibe from point of view of timing and spacing. The question will be the same for TSOITR on large database. Is there any other way to prepre those kind of situation. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Flat File vs. Database
flat files data bases are mostly used for molecular biology data storage, I do not know of any molecular biology data bank that runs undeer a real data engine, but it has many reasons why, and of course u can import these flat files and get them in to a real database engine, and OFCOURSE it would be MUCH by far more easy to administrate and develop but there is one point... there are more than I would say 50 different molecular biology databases and justone of them may be ofer 75 gigas I do not knwo (and please read DO NOT KNOW) much more in deep about data engines but can a data engine like oracle handle 50 different databases that together may be about... many many gigas.. more than 600 gigs and that grow very fast every day? I ask because I do not know. cheers On Thu, 30 Aug 2001, Christopher Spence wrote: Date: Thu, 30 Aug 2001 05:55:29 -0800 From: Christopher Spence [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Flat File vs. Database ACID Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 29, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Hi all, We are proposing a project to convert applications that use flat files to Oracle databases. An essential piece of this proposal is to present to the management the advantages of databases over flat files. Are there any websites, whitepapers that talk about this? I know this probably is a no-brainer for most of you but we just want to have all of our ducks in a row so that we can make a strong case. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: 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: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install oracle 7.3.4 in Solaris.
Go to Oracle Technology Network. You'll find it under the documentation section (http://technet.oracle.com/docs/products/oracle7/doc_index.htm) they have the following: Oracle7 Server for Sun SPARC Solaris 2.x, Release 7.3.4 Administrator's Reference for UNIX Installation Guide I have used this documentaion before and it's good information. It should get you through the install. BTW membership to OTN is free. Good luck! -Original Message- Sent: Wednesday, August 29, 2001 7:19 PM To: Multiple recipients of list ORACLE-L Hello listers, I have to install a server Oracle (7.3.4) on Sun Solaris but i've never done that before. Could some one show me the steps to follow or give me some address where i can find the informations please ? Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen Thanh-truc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Van M. Etheridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Flat File vs. Database
Yes, Oracle can handle that perfectly fine. But there is no question file system has higher throughput due to the many things Oracle has to do to enforce Atomicity, Consistency, Isolation, Durability. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 30, 2001 10:31 AM To: Multiple recipients of list ORACLE-L flat files data bases are mostly used for molecular biology data storage, I do not know of any molecular biology data bank that runs undeer a real data engine, but it has many reasons why, and of course u can import these flat files and get them in to a real database engine, and OFCOURSE it would be MUCH by far more easy to administrate and develop but there is one point... there are more than I would say 50 different molecular biology databases and justone of them may be ofer 75 gigas I do not knwo (and please read DO NOT KNOW) much more in deep about data engines but can a data engine like oracle handle 50 different databases that together may be about... many many gigas.. more than 600 gigs and that grow very fast every day? I ask because I do not know. cheers On Thu, 30 Aug 2001, Christopher Spence wrote: Date: Thu, 30 Aug 2001 05:55:29 -0800 From: Christopher Spence [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Flat File vs. Database ACID Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 29, 2001 5:46 PM To: Multiple recipients of list ORACLE-L Hi all, We are proposing a project to convert applications that use flat files to Oracle databases. An essential piece of this proposal is to present to the management the advantages of databases over flat files. Are there any websites, whitepapers that talk about this? I know this probably is a no-brainer for most of you but we just want to have all of our ducks in a row so that we can make a strong case. TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: 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: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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,
Re: !! *Very* important Oracle-L message !!
Count me in. While I have time to read the list, I always enjoy it. Joan Hsieh DBA-ocp 78 617-627-5032 Andrey Bronfin wrote: I'm in too DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 29, 2001 10:28 PM To: Multiple recipients of list ORACLE-L Hola, I think a subscription is the best solution. I have learned too much reading the solutions to the posts that everyday show up, and mines too. Can count on me !!! Regards, Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase. After some discussions with Jared (the list owner), and some encouragement from him, I am coming to you to ask for you help in keeping Fat City financially afloat until I can be self sufficient. I'm not asking for a specific dollar amount from anyone, nor am I *expecting* anything from you folks. But if it is within your power to contribute some money towards this end (and yes, I know these are hard financial times for everyone), I am hoping you can help. If I can get sufficient promise of funds that will see me through the next few months, I am willing to jump in with both feet and make Fat City a viable business. If it looks like the contributions are not sufficient to enable me to do that, I will cease operations within the next 45-60 days. Let me be clear about a few things: If I *do* cease operations, I will give all of my lists time to find new list providers, and will make every effort to aid the shift over to the new provider, provide list dumps, archives, mail forwarding,
ora - 4031 while inserting into a parent table
Dear DBA Gurus, I am getting the following error while inserting into a schema's parent table which is being referred by 42 tables of another schema. ORA-04031: unable to allocate 2196 bytes of shared memory (shared pool,RA_VOLUME_PLAN_POOL,KQLS heap,KQLS MEM BLOCK); How do I resolve this? I increased the shared_pool_size from 15mb to 30mb and shared_pool_reserved_size from 1mb to 5mb but it didn't solve the problem. I also set the _db_cached_cursors parameter to 0 and bounced the database but in vain. BTW I am using oracle 8.1.6 enterprise edition on Sun Solaris 2.7. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: financial problems with fatcity.com
I have subscribed to the Auerbach Oracle Internals news letter in the past at $150 a year, if memory serves. I would offer that this list is 100 times more valuable to a DBA (even Duhvelopers). That said, I would willingly pay any reasonable monthly/yearly fee to continue the list. Steven Haas Opus Consultants, LLC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 12:15 PM I for one would even agree to , say , a 25$ a year fee. This is a very good site and there are a lot of good ideas bandied about here every day. Kevin -Original Message- Sent: Wednesday, August 29, 2001 10:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! Keeping the list alive
no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: football fan-hood
Title: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 8:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i NT
Just thought I would mention this interesting little feature. Now I don't know if I am an idiot or if something went wrong (probably both), but apparently NT services will not start the instance. I had to manually start it to get it to go? I guess in a way that's good, move little nt people like me away from the GUI tools:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !! *Very* important Oracle-L message !!
How much is that in EUROs, for the future, and do we allow for differences in the depressed state that the EURO is in. I understand in the IRISH republic, that the Church is worried that when it changes, their value amount will be less. -Original Message- Sent: Wednesday, August 29, 2001 20:56 To: Multiple recipients of list ORACLE-L What about the Ozzie rate???...whatever it is, this list is great even though I've only been subscribed for a short time - I'm learning heaps ... so I'm in for donating whatever the set fee is. Cheers, Sujatha -Original Message- Sent: Thursday, 30 August 2001 5:02 AM To: Multiple recipients of list ORACLE-L It is good start...I think we all should start sending min $20(for USA) and UKL 15 (for UK) to Jared/Bruce once we have address Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 29 Aug 2001 08:50:55 -0800 Just publish the address where to send the money orders to and my $20 will be on it's way tomorrow. -Original Message- From: Anjan Thakuria [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: Re: !! *Very* important Oracle-L message !! Can we just start pledging ..We have got to keep this form going under. Ideas . Anjan Jenner Mike wrote: -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500 more per month. Right now that seems daunting, but I've been working hard to line up that additional income, and I believe I can do it. Just not right away. My estimates are that it will take me four or five months to come up to that level. I need to get out there and sell website hosting and list hosting packages, and get new customers. That takes time, unfortunately. I need a buffer to enable me to get past this startup phase.
RE: DB Monitoring
Define ORA- errors that are critical and grep the alert.log and page if there are errors. Segments that cannot extend. Segments near max extents. Archive log disk space low. Locks. Hit rates, system statistics, etc. From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: DB Monitoring Date: Thu, 30 Aug 2001 05:21:31 -0800 HI Vivek, off the top of my head: Number of extents - any reaching huge numbers? Tablespaces running out of room? Drives on the host filling up? Any jobs that have been running over 24 hours? Possible zombie processes? Top 10 most resource-intensive queries. Can they be tuned? utlbstat/utlestat - anything stand out? And most importantly, is the DATABASE UP? Page immediately if it isn't. I'm sure there's much more. This is just a start. And again I advocate home-cooked scripts in comparison to any gui tool doing this for you. Lisa Koivu VIKINGS FAN and DBA Ft. Lauderdale, FL, USA -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 3:55 AM To: Multiple recipients of list ORACLE-L Subject:DB Monitoring What Monitoring Activities Need to be Carried Out on Large Databases ( Excess of 100 GB ) ? Any Experiences , best Practices , Documents , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FROM SRINIVAS -HELP
Sorry list, I sent the following to the list by mistake. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora - 4031 while inserting into a parent table
Why is your shared pool so tiny? -Original Message- Sent: Thursday, August 30, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, I am getting the following error while inserting into a schema's parent table which is being referred by 42 tables of another schema. ORA-04031: unable to allocate 2196 bytes of shared memory (shared pool,RA_VOLUME_PLAN_POOL,KQLS heap,KQLS MEM BLOCK); How do I resolve this? I increased the shared_pool_size from 15mb to 30mb and shared_pool_reserved_size from 1mb to 5mb but it didn't solve the problem. I also set the _db_cached_cursors parameter to 0 and bounced the database but in vain. BTW I am using oracle 8.1.6 enterprise edition on Sun Solaris 2.7. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT : kernel using 75% of CPU - Summary and last post
Hi all, Think we've figured this out, with much help from you guys. I believe the high percentage of kernel CPU was due to the system swapping. I believe the root cause of the swapping was a combination of: a) an SGA that was too large b) a sort_area_size that was set too large (30Mb.) c) an app that does a *lot* of sorting I believe each connection from the app server (there were about 50-55 connections) would eventually grab 30Mb. of sort space in it's PGA. According to Oracle, this memory never gets released to the OS. So, that's 1.5-1.6Gb. of memory that apparently send us over the edge. Since these are persistent connections from an app server, they neverdisconnect. We greatly reduced the size of the java pool and brought sort_area_size down, which - I think - fixed the problem. Better to have a few disk sorts than have your box start swapping! Thanks again! - Jerry - Original Message - From: "Connor McDonald" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 5:27 AM Subject: RE: OT : kernel using 75% of CPU Agreed - and Sun doesn't handle getting "close to the edge" at all well imho. Recently upgraded a db on (2.6) server from 8.0 to 8.1.6 and it went from running fine to running like an absolute dog - kernel thrashing exactly like our initial poster reports... ... The problem? java_pool_size (and its 20m default). Once the idiot (me) remembered to reset this to 32k, performance was immediately better than even the original 8.0. Just an extra 20M freed up (on a 512M box) and miracles occurred Cheers Connor --- Christopher Spence [EMAIL PROTECTED] wrote: paging and swapping is the first thing that comes to mind, look at vmstat.I think your question is completely on topic. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 28, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Hi there,I have a Sun e4500, running Solaris 2.7 and Oracle 8.1.7.1.0. Everything looks normal from a database perspective, but when I run "top" it show the kernel being very hog-like:load averages: 14.38, 15.18, 15.18 07:16:21 126 processes: 118 sleeping, 4 running, 4 on cpu CPU states: 0.6% idle, 26.6% user, 72.8% kernel, 0.0% iowait, 0.0% swap Memory: 4096M real, 63M free, 216M swap in use, 5310M swap freePID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 2286 oracle 1 0 0 1844M 1814M run 9:44 13.90% oracle 11068 oracle 1 0 0 2056K 1536K cpu0 0:02 1.53% top 11333 oracle 1 0 0 1150M 1124M cpu1 0:01 1.39% oracle 5944 oracle 1 40 0 1820M 1789M sleep 14:40 1.36% oracle 4797 root 1 50 0 2112K 1248K sleep 6:01 1.36% top 11346 oracle 1 0 0 110M 92M cpu0 0:01 1.26% oracle 4 oracle 1 0 0 1009M 984M cpu1 0:00 0.66% oracle 11157 oracle 1 0 0 1009M 984M run 0:00 0.63% oracle 11368 oracle 1 33 0 1794M 1765M sleep 0:00 0.29% oracle 19558 oracle 1 60 0 1797M 1751M sleep 78:28 0.28% oracle 19554 oracle 1 60 0 1794M 1751M sleep 38:05 0.20% oracle 11366 oracle 1 55 0 1793M 1763M sleep 0:00 0.19% oracle 11292 oracle 1 26 2 2008K 1424K run 0:00 0.19% dsql Any ideas on what I, as a lowly DBA, would be able to check? It's a bit out of my area and I'm stumped... Thanks! Jerry = 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).
RE: Clarification on External procedure in Oracle 8.1.6
Here is an external procedure I call from within pl/sql. This is for unix so I create a .so file and mapped it with the library. In Windows NT, you would create a .dll and map it the same way in oracle with the library. -- * START OF FUNCTION F_CHECK_FAQ -- This procedure references an IN variable for the external C function -- RetrieveURL and maps the library in the database which points to -- the C external procedure to be run. This external function will -- return an integer value for the request time (positive number) or -- an error code (negative number). -- * FUNCTION f_check_faq (RetrieveURLIN VARCHAR2, timeout IN BINARY_INTEGER) RETURN BINARY_INTEGER AS LANGUAGE C NAME rnt_url LIBRARY MY_C_LIB PARAMETERS ( RetrieveURL string, timeout int); HTH ReedK devoted Vikings Fan -Original Message- Sent: Thursday, August 30, 2001 3:25 AM To: Multiple recipients of list ORACLE-L please anyone tell me how to call external procedures(C) from plsql with an example. -Original Message- From: Ramesh_Kota [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Subject: Clarification on External procedure in Oracle 8.1.6 Hi all... I believe any of u Would be of GREAT help... I have been trying Calling C functions from pl/sql using Oracle 8i's External Routine. It works. But when I try to call the Pro*C function after precompiling it .. it is failing at connect itself. I have used EXEC SQL Connect username identified by passwd; The same Pro*c WORKS FINE when I try it from the command line. Have any of u tried calling Pro*C from Pl/sql. If YES. could u .. Send me an example or some resource from wherein I can proceed with my work. Thanx a lot in advance Ramesh. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kempf, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unix-script
Hallo Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled? Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: !! *Very* important Oracle-L message !!
I agree. Anjan mohammed bhatti wrote: my 2 cents. i think it was re-iterated that payment was not necessary so i don't think folks should feel guilty if they can't pay. we're throwing out figures like $10, $20, $50 etc. for us in the US, this is barely the cost of lunch or dinner, so no big deal. but some other folks in other parts of the world, $10-$20 bucks is a big chunk of money that they can ill-afforded. all i'm saying is that folks should not feel compelled to pay or feel guilty. just re-read the original post. hopefully, most if not all the funds can be covered by US/Europe based DBAs' (and i hope this does'nt offend anyone). and everyone, whether they contribute or not, should feel more than welcome to use the list - no guilt trips please. mkb --- Jan Pruner [EMAIL PROTECTED] wrote: There is no problem with subscription of today's user. I will pay too because I find this list excelent. But what about new users? If I find a new list server with subscription, I will never pay to try if is it valuable or not. I think that free subscription is better way 'cause mail list is still free (and open for new users) and Bruce have no troubles with restriction (user's rights) etc. Of course, we will pay and the others (nonpaying users) have the List free, I don't like it but Jan Pruner Dne st 29. srpen 2001 19:22 jste napsal(a): I think a subscription is a decent suggestion. I know Bruce wants to keep it free but it still sounds the most feasible to me. After all the electronic friends I have made on the list, and of course its primary aim as a second-to-none technical resource/forum, I would hate to see it go. Regards Lee -Original Message- Sent: 29 August 2001 11:36 To: Multiple recipients of list ORACLE-L -Original Message- Sent: 28 August 2001 23:29 To: Multiple recipients of list ORACLE-L Ok, now that I have your attention, please read the following message from Bruce Bergman, owner of fatcity.com. It concerns the future of this list. Please read the entire message before replying. Thank you. Jared Still ( List Owner ) --- Hello ORACLE-L list members -- I would like to take a few minutes of your time for a State of the Union address, if you can call it that. This is a rather serious message, and I request that you take the time to read this message entirely. I've got a problem that needs resolution this week, and I'm hoping you folks can help me come to a conclusion. This message turned out to be fairly long-winded, so please excuse me for that. :-) Fat City (fatcity.com) is my company, and I am the provider of the list services that you receive ORACLE-L through. I've been hosting Internet mailing lists for over 10 years, and carry quite a few lists, including a big selection of Oracle-related lists (14, in fact). Fat City has always been a labor of love for me. Over the years it has rarely generated any income at all, and it usually does not cover my expenses -- most of the time it is a monthly loss for me. The vast majority of my 60+ mailing lists have been hosted for free, at my expense (as is the ORACLE-L list, for example). Yet I have absorbed these costs because I enjoy hosting discussion lists and I know a lot of lists can't afford to pay for quality service. I am soon to be one of the Rhythms Orphans. Rhythms, my DSL provider, has gone bankrupt and will be out of business by 10-Sep-2001. I need to find another provider of high-speed Internet in order to continue operations. I am at the point of either folding shop completely and going out of business myself, or trying to make Fat City a viable, money-making endeavor. I need to make this decision by this Friday (for financial and planning reasons). After Friday, I am committed one way or the other. My upstream ISP and I are on very good terms, and in fact, I've been a customer of theirs since 1985! As a result, they have graciously offered to help me out of this situation at considerable expense to themselves. I'm not at liberty to discuss the terms of the contract I would engage in with them, but suffice to say that is one of those once-in-a-lifetime opportunities that I'd be a fool to pass up. I have this offer personally from the President of that company, if I want it. Simply said, my ability to take them up on their offer and switch Fat City over to a dedicated T1 or better solution revolves around being able to generate quite a bit of additional income per month, and very soon. In an effort to be open and up-front with you folks about this, I basically need to generate an additional $500
RE: !! Keeping the list alive
Title: RE: !! Keeping the list alive AMEN! -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject: RE: !! Keeping the list alive no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: football fan-hood
Title: RE: OT: football fan-hood Jim, for the life of me, I can't see the issue here. sounds like your wife needs a hobby. -Original Message-From: HAWKINS, JAMES W [IT/1000] [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 8:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 NT
Old behavior especially in W2K with Oracle 8.1.6.0 (solved by 8.1.7.0). Regards, Hatzistavrou Yannis -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 16:56 To: Multiple recipients of list ORACLE-L Subject: 9i NT Just thought I would mention this interesting little feature. Now I don't know if I am an idiot or if something went wrong (probably both), but apparently NT services will not start the instance. I had to manually start it to get it to go? I guess in a way that's good, move little nt people like me away from the GUI tools:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! Keeping the list alive
Interesting post, but it highly depends on the duh-velupur as well as the db eh. Some developers are very aware of SQL Tuning, some are not. Some DBA's are great coders, some are not. But neither are as good as a good developer and a good dba working together. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, August 30, 2001 11:27 AM To: Multiple recipients of list ORACLE-L I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: OT : kernel using 75% of CPU
Hi, Jerry, Next time you see top output like shown below, please provide this information: In SQL*Plus: select * from v$session_wait where sid = (select sid from v$session where paddr = (select addr from v$process where spid = 2286)); may need to run it a few times. Post it to the list (or email me) unless the wait is like 'SQL*Net%' or '%timer%' or 'rdbms%'. And also find the SQL by select * from v$sql where address = (select sql_address from v$session) once you know the SID and On OS: truss -flp 2286 (the first 100 lines or so should be OK; if there's a pause in running truss, indicate where the pause happens) Also let us know if there's anything special in alert.log and any new file in udump. Yong Huang [EMAIL PROTECTED] you wrote: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 2286 oracle 1 00 1844M 1814M run 9:44 13.90% oracle 11068 oracle 1 00 2056K 1536K cpu00:02 1.53% top 11333 oracle 1 00 1150M 1124M cpu10:01 1.39% oracle __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: football fan-hood
Beat me to the punch John, however Jims analysis of the day transcends all of that. The only bit I disagree with is the going home and sobering up for dinner before having more beer. What a waste of those already consumed. Stay out on the town and keep drinking Lee (hic !!) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 16:36 To: Multiple recipients of list ORACLE-L we'll not get into the argument that what you play is not football... :o) What you call soccer is football... your football is more like rugby just my euro's worth... ;oD -Original Message- Sent: 30 August 2001 15:01 To: Multiple recipients of list ORACLE-L Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch The Greatest Show on Earth beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 8:27 AM To: Multiple recipients of list ORACLE-L BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street
Re: !! Keeping the list alive
Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: football fan-hood
we'll not get into the argument that what you play is not football... :o) What you call soccer is football... your football is more like rugby just my euro's worth... ;oD -Original Message- Sent: 30 August 2001 15:01 To: Multiple recipients of list ORACLE-L Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch The Greatest Show on Earth beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 8:27 AM To: Multiple recipients of list ORACLE-L BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /
RE: !! Keeping the list alive
I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
RE: !! Keeping the list alive
Of course the guilty ones want to avoid that $1000 fine... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive AMEN! -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about this that I really can't personally reply to them all right now. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com 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 http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Rachel
query rewrite question
I've gone thru the FM for about 4 hours now, to no avail. I thought oracle uppercased tables and columns that were not enclosed in double quotes("), but for query rewrite to pick up on a materialized view, the SQL has to be EXACT(oracle supposedly strips whitespace), but if i spell the table Ft_SALES and the materialized view sql says FT_SALES, no rewrite is done. Is this the way its supposed to work, i'd thought oracle would have been smart enough to do the upper on anythin not in " and then do the compare, guess i'm asking for too much. I'm done venting. joe
Tkprof output
Apologies for the length of the mail. This query is running for a mad amount of time, anyone any ideas. Code and tkprof out put shown below. Huge TIA Lee (who must learn more about such things !!!) DECLARE CURSOR TEMP_CDS ISSELECT ACXIOM_CUSTOMER_KEY, VERSION_NO, ADDRESS_OCCUPANCY_KEYFROM CUSTOMER_DETAIL_SOURCEWHERE VISIBLE=1; COUNTER NUMBER(8); BEGIN COUNTER:=0; FOR I IN TEMP_CDS LOOP UPDATE SCHEMA..SINGLE_CUSTOMER SC SET VISIBLE = 1 WHERE ACXIOM_CUSTOMER_KEY=I.ACXIOM_CUSTOMER_KEY AND VERSION_NO =I.VERSION_NO; UPDATE SCHEMA..SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE = 1 WHERE ACXIOM_CUSTOMER_KEY=I.ACXIOM_CUSTOMER_KEY AND VERSION_NO =I.VERSION_NO; UPDATE SCHEMA..ADDRESS_OCCUPANCY AO SET VISIBLE = 1 WHERE ADDRESS_OCCUPANCY_KEY = I.ADDRESS_OCCUPANCY_KEY; COUNTER := COUNTER + 1; IF (COUNTER = 5) THEN COUNTER:=0; COMMIT; END IF; END LOOP; COMMIT; Sort options: prsela exeela fchela count = number of times OCI procedure was executedcpu = cpu time in seconds executing elapsed = elapsed time in seconds executingdisk = number of physical reads of buffers from diskquery = number of buffers gotten for consistent readcurrent = number of buffers gotten in current mode (usually for update)rows = number of rows processed by the fetch or execute call UPDATE VM_LIVE.SINGLE_CUSTOMER SC SET VISIBLE=1 WHEREACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2 call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 0 0.00 0.00 0 0 0 0Execute 39562 15.51 398.98 56555 181085 40672 39562Fetch 0 0.00 0.00 0 0 0 0--- -- -- -- -- -- --total 39562 15.51 398.98 56555 181085 40672 39562 Misses in library cache during parse: 0Misses in library cache during execute: 1Optimizer goal: CHOOSEParsing user id: 39 (VM_LIVE) (recursive depth: 1) Rows Execution Plan--- --- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'SINGLE_CUSTOMER' 0 TABLE ACCESS (BY INDEX ROWID) OF 'SINGLE_CUSTOMER' 0 INDEX (UNIQUE SCAN) OF 'SINGLE_CUSTOMER_PK' (UNIQUE) UPDATE VM_LIVE.ADDRESS_OCCUPANCY AO SET VISIBLE=1 WHEREADDRESS_OCCUPANCY_KEY = :b1 call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 0 0.00 0.00 0 0 0 0Execute 39562 12.57 186.88 57285 124038 40726 39562Fetch 0 0.00 0.00 0 0 0 0--- -- -- -- -- -- --total 39562 12.57 186.88 57285 124038 40726 39562 Misses in library cache during parse: 0Optimizer goal: CHOOSEParsing user id: 39 (VM_LIVE) (recursive depth: 1) Rows Execution Plan--- --- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'ADDRESS_OCCUPANCY' 0 INDEX (UNIQUE SCAN) OF 'I_ADDRESS_OCCUPANCY_I4' (UNIQUE) UPDATE VM_LIVE.SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE=1 WHEREACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2 call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 0 0.00 0.00 0 0 0 0Execute 39562 4.55 7.22 10897 118687 1 1Fetch 0 0.00 0.00 0 0 0 0--- -- -- -- -- -- --total 39562 4.55 7.22 10897 118687 1 1 Misses in library cache during parse: 0Optimizer goal: CHOOSEParsing user id: 39 (VM_LIVE) (recursive depth: 1) Rows Execution Plan--- --- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'SINGLE_CUSTOMER_HISTORY' 0 INDEX (UNIQUE SCAN) OF 'SINGLE_CUSTOMER_HISTORY_PK' (UNIQUE) SELECT ACXIOM_CUSTOMER_KEY,VERSION_NO,ADDRESS_OCCUPANCY_KEY FROMCUSTOMER_DETAIL_SOURCE WHERE VISIBLE = 1 call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 0 0.00 0.00 0 0 0 0Execute 0 0.00 0.00 0 0 0 0Fetch 39562 1.51 2.04 392 39618 0 39562--- -- -- -- -- -- --total 39562 1.51 2.04 392 39618 0 39562 Misses in library cache during parse: 0Parsing user id: 39 (VM_LIVE) (recursive depth: 1) OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows--- --
Oracle to Sql Server
Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK
AW: Unix-script
Title: AW: Unix-script Hi Roland, try this: 1) shell script #!/usr/bin/ksh # ora_load.sh # load data to db using sql loader . /etc/profile . $HOME/.profile cd /home/oracle/load # set Oracle specific environmental variables here export NLS_NUMERIC_CHARACTERS=., export ORACLE_SID=TEST $ORACLE_HOME/bin/sqlldr user/password control=ora_bla.ctl 2) control file ora_bla.ctl for sql loader -- - -- Controlfile for sql loader -- - LOAD DATA INFILE /home/oracle/load/load.sqlldr BADFILE /home/oracle/load/load.bad APPEND INTO TABLE ORA_LOAD Fields terminated by | ( field specification goes here ) 3) entry in crontab 00 4 * * 1-6 /home/oracle/load/ora_load.sh /dev/null 21 # Index Report Hope this helps. Regards, Michael -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet am: Donnerstag, 30. August 2001 17:16 An: Multiple recipients of list ORACLE-L Betreff: Unix-script Hallo Can anyone give me an example on how to write a unix script which schedules the run run of a sqlloader script from unix server into the database. I mean I could easily get the file tmanually o be imported if i use the ftp command, but how do i do if I want that to be scheduled? Roland S -- 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).
Recruiters Should Pay Attention
Oweson, One of the most damn sensible things I have heard in a while. I agree -- recruiters and others who make $$ from this list should lead by example in donating to FATCITY. Ross -Original Message- Sent: Thursday, August 30, 2001 9:22 AM To: Multiple recipients of list ORACLE-L Hi Gang, I was reading all the comments, and saw the one about 'Corporate' sponsorship ... BILL LAW of OraStaff - don't you feel this is a good opportunity .. ? (Don't you feel a moral obligation?) Regards Oweson Flynn -- A clean limerick is a contradiction in terms. Certified Oracle DBA The Flynn Consultancy Tel: 082-600-7-006 Fax: (011) 782-9313 EMail: [EMAIL PROTECTED] -Original Message- Lee - lerobe Sent: 30 August 2001 11:57 To: Multiple recipients of list ORACLE-L Surely those of us in the UK can pay electronically (say via Credit Card)??. I've done this for other things such as DVDs (15$) etc. Lee -Original Message- Sent: 30 August 2001 09:55 To: Multiple recipients of list ORACLE-L As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon
Re: Parallelism in oracle8i
2 possible reasons 1-Your hint is not working. Type as select /*+ parallel(ib020mb_3,2) */ adt_date from --there must be space between + sign and parallel and * else it is --treated as a comment ib020mb_3 where adt_date '01-jun-2000' 2) are your table/indexes analyzed a) compare explain plan of both to check difference b)what is your optimize rule or choose Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 30 Aug 2001 03:15:21 -0800 Hi, We are doing testing of oracle 8i parallelism features on unix HP 11 . We have done 2 partitions on the table ib020mb_3 on a field adt_date with the following details (partition p1 values less than('22-apr-2000') tablespace CONTRACT, partition p2 values less than('01-jUn-2000')tablespace CONTRACT1). Each of these partitions are in different tablespace. Each of this tablespace are on different disks(data files on different disk ) in unix environment. We have 4 processors and 4 controllers (like disk drives) to write on disk. With this details we are running the following query with and without degree of parallelism specified. select adt_date from ib020mb_3 where adt_date '01-jun-2000' But we are taking more time with parallelism. We have tried the query with different degrees of parallelism. Currently we are fetching approx. 15 lac records. We have tested with a different table and different set of records but still we are taking more time with degree of parallelism specified. Could you please suggest why we are taking more time . The following are the tkprof generated for this queries: == 1) Without parallelism: select adt_date from ib020mb_3 where adt_date '01-jun-2000' call count cpuelapsed disk query current rows --- -- -- -- -- -- --- Parse1 0.12 0.31 21204 5 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 101340 11.37 16.48 7107 107826 0 1520078 --- -- -- --- -- - total 101342 11.49 16.79 7128 108030 5 1520078 Total time taken : 28.28 2)With parallelism: select /*+parallel(ib020mb_3,2)*/ adt_date from ib020mb_3 where adt_date '01-jun-2000' call count cpuelapsed disk query currentrows --- -- -- -- --- -- -- Parse1 0.13 0.61 21243 6 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 101340 11.72 16.79 7107 107826 0 1520078 --- -- -- - total 101342 11.85 17.40 7128 108069 6 1520078 Total time taken :29.25 == === Thanks In Advance __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Soman Manoj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: !! *Very* important Oracle-L message !!
Count me in! === Patrick Housholder Sr. Staff Engr Sim Fleet. United Airlines Flight Training Center Denver CO -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7 on W2K
Guys, I have an just finished upgrading to 8.1.7 on all my boxes some of which are Windows2000. I have had no problems with Sun Solaris, HP and Windows NT4.0. But on Windows2000, every time the box is rebooted the instance does not come up automatically. However the service shows as running. I checked the registry to make sure I had ORACLE_SID set right. I have to manually start the instance every time and its a pain in the 'you know what'. If anyone has had this problem and solved it please let me know the solution. Thanks, Uma Mohoni Consultant, CDI Corporation @ iKimbo Inc. 500-A Huntmar Park Drive Herndon, VA 20170 (703) 904-4150 Ext:237 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Uma Mohoni INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: financial problems with fatcity.com
Title: OT: RE: financial problems with fatcity.com Guys like Lewis, Adams, Uni-Bomberism, etc. both add value and get advertising for their own sites/products. I think it balances out well enough to not worry about it. For me, I'd be happy to see them get a free ride, but would rather have a Benevolent Dictator ( Jared/Bruce ) make this call. my $0.02 -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 3:36 PMTo: Multiple recipients of list ORACLE-LSubject: OT: RE: financial problems with fatcity.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Alex, that is an excellent idea! I second that notion. "doh.state.fl.us"? Does that University count Homere Simpson amongst its proud alumni? Please excuse the long e-mail, but since the suggestion has been made to make this a "subscription" list, I will share some of the issues that I am grappling with (along with others) as part of a volunteer moderator at an internet message board, where we are currently debating a fee-based message board instead of free membership. My personal opinion (though of course this would be Mr. Still and Mr. Bergman's decision) is that having a "subscription" list would be very hard to manage. If someone who has provided valuable responses (e.g. a Steve Adams) doesn't pay his fee, do you immediately unsubscribe him from the list? Do you prevent him from posting an answer? What's the grace period for non-payment of fees? Would there be a trial period, or would you have to pay before you can even see what the list is like? Paying before you can see the content would diminish new membership, and new membership is essential to the survival of a list such as this one. If you have a free introductory period, I could sign up with a different "free" e-mail (e.g. hotmail) every month and never pay. Only the "honest" people would pay, which would end up being the same as asking for voluntary donations. Another issue - how many people would go try out another "free" list? Charging a fee may mean the demise of this list. I think that the list is worth a modest fee, but what percentage of the membership will think so? What if a person has paid for membership, but is posting messages disruptive to the list (e.g. spam or insults.) Do you refund their fee when you remove them from the list? Do they have more rights as a "paying customer"? How about the archives? Would you have to pay to see them? What about people that always ask questions, but never answer any? Would they be charged more? Would some of our "experts" become resentful since they are paying Mr. Bergman and giving out more information than they are receiving? I can very well imagine a person thinking "why should I give out free answers when Mr. Bergman 'profits' from my expertise?" (Of course I realize that there is very little, if any, 'profit' involved, but some people may not be convinced of that.) These are all difficult questions that would be faced by the person maintaining the list. Without charging enough to make the list profitable, it might not be worth the headache.
Re: !! *Very* important Oracle-L message !!
I'll throw in $20. Let me know where to send it. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: FW: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
yea unfortunately. I've reported him the already, if i dont hear back, i'll be reporting him to his upstream provider also. joe [EMAIL PROTECTED] 08/30/01 12:16PM Uh-oh - anyone else get this ??-Original Message-Sent: 30 August 2001 09:56To: [EMAIL PROTECTED]Want a FREE way to improve your Career potential in the Enterprise Software marketplace? Are you prepared for the changes in the Enterprise marketplace that will take place over the next 2 years?Please take a minute to read this note and register with Peoplestaff's innovative Career Scout tool. This tool helps Peoplestaffhelp hiring managers make better and faster hires and keeps ourcandidates aware of the skills and opportunities they need for continuedsuccess. If you don't want to receive any future inquiries please reply to [EMAIL PROTECTED] and put 'REMOVE' in the subject and you will not receive another inquiry.If you'd like to register or get more info on Peoplestaff's Career Scout please reply to [EMAIL PROTECTED] and put 'MORE INFO' in the subject area. Hi, my name is Rick Zabor, President of Peoplestaff. Since 1994 we've been focused on the placement of Peoplesoft, Oracle, SAP,JDEdwards, Lawson, DBA, and CRM talent. We are utilizing a toolthat allows hiring managers make better/ faster hiring decisions and candidates to make better career choices. This FREE and CONFIDENTIAL tool gives you the choice of what local and/or national markets you want to keep aware of, and unlike most recruiting firms or corporations we will provide almost instant feedback on your match potential when you apply for an opportunity. Rick Zabor Peoplestaff (formerly Leader Institute) ERP - Perm and Contract Talent Specialists 770.321.1231 x-110 or x-100[EMAIL PROTECTED]TESTIMONIALS FROM CANDIDATES ABOUT USING CAREER SCOUT"I just wanted to thank you for taking the time to meet with me regarding the 3cSoftware position. Even though I did not emerged as a match for the position, I value the time you spent with me counseling me about my career pursuit. " Bright Boateng"Thanks, I really appreciate your feedback."Darren"Even though this one didn't work out at least you followed up and kept me informed. This is what I (and I'm sure many other job hunters) am missing in other recruiters and agencies. I really appreciate this. It beats the heck out of just being "left hanging" like most firmsdo."Hal Page"Thanks for the reply. Most recruiters get your resume, make a lot of promises and that's the last you hear from them. Your consideration is greatly appreciated." Craig WatsonThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT : kernel using 75% of CPU
Jerry, Be aware that the system performance degardes drastically while truss is running. Rao Maheswara Rao -Original Message- Sent: Thursday, August 30, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, Jerry, Next time you see top output like shown below, please provide this information: In SQL*Plus: select * from v$session_wait where sid = (select sid from v$session where paddr = (select addr from v$process where spid = 2286)); may need to run it a few times. Post it to the list (or email me) unless the wait is like 'SQL*Net%' or '%timer%' or 'rdbms%'. And also find the SQL by select * from v$sql where address = (select sql_address from v$session) once you know the SID and On OS: truss -flp 2286 (the first 100 lines or so should be OK; if there's a pause in running truss, indicate where the pause happens) Also let us know if there's anything special in alert.log and any new file in udump. Yong Huang [EMAIL PROTECTED] you wrote: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 2286 oracle 1 00 1844M 1814M run 9:44 13.90% oracle 11068 oracle 1 00 2056K 1536K cpu00:02 1.53% top 11333 oracle 1 00 1150M 1124M cpu10:01 1.39% oracle __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: yong huang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: financial problems with fatcity.com
Title: RE: RE: financial problems with fatcity.com Ross is that all you are contributing? Two cents? -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: financial problems with fatcity.com Guys like Lewis, Adams, Uni-Bomberism, etc. both add value and get advertising for their own sites/products. I think it balances out well enough to not worry about it. For me, I'd be happy to see them get a free ride, but would rather have a Benevolent Dictator ( Jared/Bruce ) make this call. my $0.02 -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject: OT: RE: financial problems with fatcity.com -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Alex, that is an excellent idea! I second that notion. doh.state.fl.us? Does that University count Homere Simpson amongst its proud alumni? Please excuse the long e-mail, but since the suggestion has been made to make this a subscription list, I will share some of the issues that I am grappling with (along with others) as part of a volunteer moderator at an internet message board, where we are currently debating a fee-based message board instead of free membership. My personal opinion (though of course this would be Mr. Still and Mr. Bergman's decision) is that having a subscription list would be very hard to manage. If someone who has provided valuable responses (e.g. a Steve Adams) doesn't pay his fee, do you immediately unsubscribe him from the list? Do you prevent him from posting an answer? What's the grace period for non-payment of fees? Would there be a trial period, or would you have to pay before you can even see what the list is like? Paying before you can see the content would diminish new membership, and new membership is essential to the survival of a list such as this one. If you have a free introductory period, I could sign up with a different free e-mail (e.g. hotmail) every month and never pay. Only the honest people would pay, which would end up being the same as asking for voluntary donations. Another issue - how many people would go try out another free list? Charging a fee may mean the demise of this list. I think that the list is worth a modest fee, but what percentage of the membership will think so? What if a person has paid for membership, but is posting messages disruptive to the list (e.g. spam or insults.) Do you refund their fee when you remove them from the list? Do they have more rights as a paying customer? How about the archives? Would you have to pay to see them? What about people that always ask questions, but never answer any? Would they be charged more? Would some of our experts become resentful since they are paying Mr. Bergman and giving out more information than they are receiving? I can very well imagine a person thinking why should I give out free answers when Mr. Bergman 'profits' from my expertise? (Of course I realize that there is very little, if any, 'profit' involved, but some people may not be convinced of that.) These are all difficult questions that would be faced by the person maintaining the list. Without charging enough to make the list profitable, it might not be worth the headache.
Re: Oracle to Sql Server
i'd think if u are abandoning oracle for M$, then check their website, i'm sure they have a way to do it, just like oracle's website has a way to go TO oracle FROM M$. joe [EMAIL PROTECTED] 08/30/01 12:06PM Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK
RE: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
Title: RE: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY yep. is the list selling our email's to ease the financial woes? ;-) -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Subject: FW: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY Uh-oh - anyone else get this ?? -Original Message- Sent: 30 August 2001 09:56 To: [EMAIL PROTECTED] Want a FREE way to improve your Career potential in the Enterprise Software marketplace? Are you prepared for the changes in the Enterprise marketplace that will take place over the next 2 years? Please take a minute to read this note and register with Peoplestaff's innovative Career Scout tool. This tool helps Peoplestaff help hiring managers make better and faster hires and keeps our candidates aware of the skills and opportunities they need for continued success. If you don't want to receive any future inquiries please reply to [EMAIL PROTECTED] and put 'REMOVE' in the subject and you will not receive another inquiry. If you'd like to register or get more info on Peoplestaff's Career Scout please reply to [EMAIL PROTECTED] and put 'MORE INFO' in the subject area. Hi, my name is Rick Zabor, President of Peoplestaff. Since 1994 we've been focused on the placement of Peoplesoft, Oracle, SAP, JDEdwards, Lawson, DBA, and CRM talent. We are utilizing a tool that allows hiring managers make better/ faster hiring decisions and candidates to make better career choices. This FREE and CONFIDENTIAL tool gives you the choice of what local and/or national markets you want to keep aware of, and unlike most recruiting firms or corporations we will provide almost instant feedback on your match potential when you apply for an opportunity. Rick Zabor Peoplestaff (formerly Leader Institute) ERP - Perm and Contract Talent Specialists 770.321.1231 x-110 or x-100 [EMAIL PROTECTED] TESTIMONIALS FROM CANDIDATES ABOUT USING CAREER SCOUT I just wanted to thank you for taking the time to meet with me regarding the 3cSoftware position. Even though I did not emerged as a match for the position, I value the time you spent with me counseling me about my career pursuit. Bright Boateng Thanks, I really appreciate your feedback. Darren Even though this one didn't work out at least you followed up and kept me informed. This is what I (and I'm sure many other job hunters) am missing in other recruiters and agencies. I really appreciate this. It beats the heck out of just being left hanging like most firms do. Hal Page Thanks for the reply. Most recruiters get your resume, make a lot of promises and that's the last you hear from them. Your consideration is greatly appreciated. Craig Watson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: !! *Very* important Oracle-L message !!
Let's start a campaign for Hunger ! -Original Message- Sent: Thursday, August 30, 2001 12:28 PM To: Multiple recipients of list ORACLE-L I'll throw in $20. Let me know where to send it. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: char vs. varchar2
Actually char has some minor performance advantages over varchar2 when the column is frequently updated to a larger size since the full space is already claimed within the block. -Original Message- Sent: Wednesday, August 29, 2001 6:58 PM To: Multiple recipients of list ORACLE-L Isn't CHAR a declining feature, which is why Oracle is forcing the conversion to VARCHAR2 whenever possible? -- 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tkprof output
Title: RE: Tkprof output Lee, This query seems suspect UPDATE VM_LIVE.SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE=1 WHERE ACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2 because of this call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 0 0.00 0.00 0 0 0 0 Execute 39562 4.55 7.22 10897 118687 1 1 Fetch 0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 39562 4.55 7.22 10897 118687 1 1 It's reading a ton of blocks to operate on ONE record. What's the table structure here? What's the index structure? Cardinality? The buffer gets in the other queries are suspect too. What's your blocksize? It's reading a ton of blocks to arrive at the result. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Tkprof output Apologies for the length of the mail. This query is running for a mad amount of time, anyone any ideas. Code and tkprof out put shown below. Huge TIA Lee (who must learn more about such things !!!) DECLARE CURSOR TEMP_CDS IS SELECT ACXIOM_CUSTOMER_KEY, VERSION_NO, ADDRESS_OCCUPANCY_KEY FROM CUSTOMER_DETAIL_SOURCE WHERE VISIBLE=1; COUNTER NUMBER(8); BEGIN COUNTER:=0; FOR I IN TEMP_CDS LOOP UPDATE SCHEMA..SINGLE_CUSTOMER SC SET VISIBLE = 1 WHERE ACXIOM_CUSTOMER_KEY=I.ACXIOM_CUSTOMER_KEY AND VERSION_NO =I.VERSION_NO; UPDATE SCHEMA..SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE = 1 WHERE ACXIOM_CUSTOMER_KEY=I.ACXIOM_CUSTOMER_KEY AND VERSION_NO =I.VERSION_NO; UPDATE SCHEMA..ADDRESS_OCCUPANCY AO SET VISIBLE = 1 WHERE ADDRESS_OCCUPANCY_KEY = I.ADDRESS_OCCUPANCY_KEY; COUNTER := COUNTER + 1; IF (COUNTER = 5) THEN COUNTER:=0; COMMIT; END IF; END LOOP; COMMIT; Sort options: prsela exeela fchela count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call UPDATE VM_LIVE.SINGLE_CUSTOMER SC SET VISIBLE=1 WHERE ACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2 call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 0 0.00 0.00 0 0 0 0 Execute 39562 15.51 398.98 56555 181085 40672 39562 Fetch 0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 39562 15.51 398.98 56555 181085 40672 39562 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 39 (VM_LIVE) (recursive depth: 1) Rows Execution Plan --- --- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'SINGLE_CUSTOMER' 0 TABLE ACCESS (BY INDEX ROWID) OF 'SINGLE_CUSTOMER' 0 INDEX (UNIQUE SCAN) OF 'SINGLE_CUSTOMER_PK' (UNIQUE) UPDATE VM_LIVE.ADDRESS_OCCUPANCY AO SET VISIBLE=1 WHERE ADDRESS_OCCUPANCY_KEY = :b1 call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 0 0.00 0.00 0 0 0 0 Execute 39562 12.57 186.88 57285 124038 40726 39562 Fetch 0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 39562 12.57 186.88 57285 124038 40726 39562 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 39 (VM_LIVE) (recursive depth: 1) Rows Execution Plan --- --- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'ADDRESS_OCCUPANCY' 0 INDEX (UNIQUE SCAN) OF 'I_ADDRESS_OCCUPANCY_I4' (UNIQUE) UPDATE
RE: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
Yep I got it too ... twice ... This one heads straight to junk email senders list ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! -Original Message- Uh-oh - anyone else get this ?? *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
A PL/SQL datatypes conversion question
Dear list ! There is a column of datatype RAW in a table. it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are concatenated and then converted to RAW by an external C++ application. I need to convert it back in a PL/SQL trigger. I.e. i need retrieve that RAW column , and divide it according to the offset to the 4 numbers and the string. The problem is that i haven't found any cast_to_number or hextonumber conversion functions . UTL_RAW only has got CAST_TO_VARCHAR2 function , and there is also the standard RAWTOHEX conversion function. How can i sort it out , please ? Thanks a lot in advance , DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 to Sql Server
Title: Message Easy. Use SQL*Server's DTS (data transformation services) to pull the data from Oracle into SQL*Server. Jon Walthour -Original Message-From: Apps Sol [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:07 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Sql Server Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK
RE: OT: football fan-hood
Title: RE: OT: football fan-hood Well, I'm trying to get her to like hockey...that's a good hobby, right? Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 10:43 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Jim, for the life of me, I can't see the issue here. sounds like your wife needs a hobby. -Original Message-From: HAWKINS, JAMES W [IT/1000] [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch "The Greatest Show on Earth" beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 8:27 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: football fan-hood I thought that she was s overwhelmed by the choices available that she decided to be an "outsider" and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tkprof output
Are you on 8i? Then you can use BULK binding which will definitely give you some speed. IF you need example ... let me know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 Are you on 8i?Then youcan use BULK binding which will definitely give you some speed. IF you need example ... let me know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art !
WebDB 2.2 on linux RH 7.0 w/Oracle 8.1.7
List, Has anyone deployed WebDB 2.2 on Linux RedHat 7.0 yet. The install manual states that it is for RH6.0 with Oracle 8.1.5, 8.1.6. I understand the process of loading 8.1.7 on 7.0 and have the glib's for 2.1 available . Do I follow the glib linking process for installing 8.1.7 on RH7.0 and then install WebDB2.2. The reason I am asking is I do NOT have the ability to backup the server (test server) and do not want to realy foul things up if the install will cause problems. I would like to learn about WebDB or portal and this is the combination I have available to me. Any hints, sites, horror stories? ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: football fan-hood
Maybe he has to sober up to avoid the issuing of beat downs from his wife? -Original Message- Lee - lerobe Sent: Thursday, August 30, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Beat me to the punch John, however Jims analysis of the day transcends all of that. The only bit I disagree with is the going home and sobering up for dinner before having more beer. What a waste of those already consumed. Stay out on the town and keep drinking Lee (hic !!) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 30 August 2001 16:36 To: Multiple recipients of list ORACLE-L we'll not get into the argument that what you play is not football... :o) What you call soccer is football... your football is more like rugby just my euro's worth... ;oD -Original Message- Sent: 30 August 2001 15:01 To: Multiple recipients of list ORACLE-L Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch The Greatest Show on Earth beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 8:27 AM To: Multiple recipients of list ORACLE-L BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore
RE: OT: football fan-hood
I think it's that pass out part she's upset with :) From: HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: football fan-hood Date: Thu, 30 Aug 2001 07:00:51 -0800 Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my house and depart for TWA Dome. 9:00AM - 11:50AM - Beer, brats, cigars, music in front of the Dome. Noon - 3:15PM - Watch The Greatest Show on Earth beat up on defenses. 3:16PM - Head home for the rest of the 3:00PM games on DirecTV Sunday Ticket. Note: I have the ability to watch all three games at once using a well-developed channel-flipping technique. 6:00PM - Dinner, sober up - get ready for Sunday Night game on ESPN. 7:00PM - 10:00PM - Watch whoever's playing, more beer. 10:01PM - Pass out. My wife just doesn't get it... Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 8:27 AM To: Multiple recipients of list ORACLE-L BLECH! My second favorite team is Tampa (they are half ex-vikings) I dare say they will be better than the Vikings this year. Charge that $5 to my account. Sorry. The short story is: Grew up in MN... my whole family watched the Vikings... my grandfather was one of the announcers... I was going to Purple Crush games at 6 years old with my mother in the Met Stadium. I was (still am) a tomboy and there was no girls football or hockey back then. There. I said it. -Original Message- Sent: Thursday, August 30, 2001 9:01 AM To: Multiple recipients of list ORACLE-L I thought that she was s overwhelmed by the choices available that she decided to be an outsider and pick a team from snow-bird country so she would be accepted in Ft.Laud. After all she does have 3 Florida football teams to choose from. Very confusing and it can upset your pears, neighbors, and friends of you choose the wrong one. You can tell that she is not solid in her choice and committed by the unique, colorful, and subliminal signature? She is screaming for guidance and understanding. I offer to her that she support the BRONCO'S and I will have my daughter-in-law ( devout BRONCO fan) get with her and tailgate party to relieve the stress. ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: financial problems with fatcity.com
Title: RE: RE: financial problems with fatcity.com No, I'll do a bit more than that! mysterious smile -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:48 AMTo: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'Subject: RE: RE: financial problems with fatcity.com Ross is that all you are contributing? Two cents? -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 12:22 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: financial problems with fatcity.com Guys like Lewis, Adams, Uni-Bomberism, etc. both add value and get advertising for their own sites/products. I think it balances out well enough to not worry about it. For me, I'd be happy to see them get a free ride, but would rather have a Benevolent Dictator ( Jared/Bruce ) make this call. my $0.02 -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 3:36 PMTo: Multiple recipients of list ORACLE-LSubject: OT: RE: financial problems with fatcity.com -Original Message-From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Alex, that is an excellent idea! I second that notion. "doh.state.fl.us"? Does that University count Homere Simpson amongst its proud alumni? Please excuse the long e-mail, but since the suggestion has been made to make this a "subscription" list, I will share some of the issues that I am grappling with (along with others) as part of a volunteer moderator at an internet message board, where we are currently debating a fee-based message board instead of free membership. My personal opinion (though of course this would be Mr. Still and Mr. Bergman's decision) is that having a "subscription" list would be very hard to manage. If someone who has provided valuable responses (e.g. a Steve Adams) doesn't pay his fee, do you immediately unsubscribe him from the list? Do you prevent him from posting an answer? What's the grace period for non-payment of fees? Would there be a trial period, or would you have to pay before you can even see what the list is like? Paying before you can see the content would diminish new membership, and new membership is essential to the survival of a list such as this one. If you have a free introductory period, I could sign up with a different "free" e-mail (e.g. hotmail) every month and never pay. Only the "honest" people would pay, which would end up being the same as asking for voluntary donations. Another issue - how many people would go try out another "free" list? Charging a fee may mean the demise of this list. I think that the list is worth a modest fee, but what percentage of the membership will think so? What if a person has paid for membership, but is posting messages disruptive to the list (e.g. spam or insults.) Do you refund their fee when you remove them from the list? Do they have more rights as a "paying customer"? How about the archives? Would you have to pay to see them? What about people that always ask questions, but never answer any? Would they be charged more? Would some of our "experts" become resentful since they are paying Mr. Bergman and giving out more information than they are receiving? I can very well imagine a person thinking "why should I give out free answers when Mr. Bergman 'profits' from my expertise?" (Of course I realize that there is very little, if any, 'profit' involved, but some people may not be convinced of that.) These are all difficult questions that would be faced by the person maintaining the list. Without charging enough to make the list profitable, it might not be worth the headache.
Re: FW: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
I received it a few days ago along with a couple of other items like this. I just blew them away as I didn't solicit them. ROR mª¿ªm [EMAIL PROTECTED] 08/30/01 12:16PM Uh-oh - anyone else get this ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 DBA With Internet Experience Needed in Harrisburg, PA
This Manufacturing Client located near Harrisburg, Pennsylvania needs an Oracle DBA to join its' I.T. staff. The selected candidate will receive general direction from the Sr. DBA and Director of Application Services however, independence is encouraged for the day-to-day operations. * Candidates local to the Greater Harrisburg area only will be considered. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. * Description: Directs the day to day activities of personnel involved in the internet database architechture and infrastructure, to ensure the availability, stability and responsiveness of Company's Internet systems. Essential functions-- Responsible for: Internet database tuning and performance, management and monitoring of database sizing and design, for database backup and recovery for the internet systems, for recommending internet and report database interface recommendations. Duties will also include daily activities releated to customers databases , including upgrades, requested deletions or adding custom database modifications. * Requirements: - 2-5 Years Oracle DBA in a large Internet environment. - 2 years Java, JSP and or Pearl programming experience a plus. - B.S. in Computer Science preferred or related technical discipline. - Must be able to work effectively in a team environment and be a team player - U.S. citizenship or Permanent residency is also required These positions offer: * Stability * The opportunity to become a key member of the team. * Base salary of between 70-90K-D.O.E. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] ph: 1-800 -549-8502 Please use job code One/Harrisburg/DBA/Coombes Candidates who we are interested in will be contacted immediately. *We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PEOPLESTAFF'S TOOL FOR ENTERPRISE IT JOB SECURITY
You bet. Maybe they can split the cost with OraStaff. -Original Message- Sent: Thursday, August 30, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Uh-oh - anyone else get this ?? -Original Message- Sent: 30 August 2001 09:56 To: [EMAIL PROTECTED] Want a FREE way to improve your Career potential in the Enterprise Software marketplace? Are you prepared for the changes in the Enterprise marketplace that will take place over the next 2 years? Please take a minute to read this note and register with Peoplestaff's innovative Career Scout tool. This tool helps Peoplestaff help hiring managers make better and faster hires and keeps our candidates aware of the skills and opportunities they need for continued success. If you don't want to receive any future inquiries please reply to [EMAIL PROTECTED] and put 'REMOVE' in the subject and you will not receive another inquiry. If you'd like to register or get more info on Peoplestaff's Career Scout please reply to [EMAIL PROTECTED] and put 'MORE INFO' in the subject area. Hi, my name is Rick Zabor, President of Peoplestaff. Since 1994 we've been focused on the placement of Peoplesoft, Oracle, SAP, JDEdwards, Lawson, DBA, and CRM talent. We are utilizing a tool that allows hiring managers make better/ faster hiring decisions and candidates to make better career choices. This FREE and CONFIDENTIAL tool gives you the choice of what local and/or national markets you want to keep aware of, and unlike most recruiting firms or corporations we will provide almost instant feedback on your match potential when you apply for an opportunity. Rick Zabor Peoplestaff (formerly Leader Institute) ERP - Perm and Contract Talent Specialists 770.321.1231 x-110 or x-100 [EMAIL PROTECTED] TESTIMONIALS FROM CANDIDATES ABOUT USING CAREER SCOUT I just wanted to thank you for taking the time to meet with me regarding the 3cSoftware position. Even though I did not emerged as a match for the position, I value the time you spent with me counseling me about my career pursuit. Bright Boateng Thanks, I really appreciate your feedback. Darren Even though this one didn't work out at least you followed up and kept me informed. This is what I (and I'm sure many other job hunters) am missing in other recruiters and agencies. I really appreciate this. It beats the heck out of just being left hanging like most firms do. Hal Page Thanks for the reply. Most recruiters get your resume, make a lot of promises and that's the last you hear from them. Your consideration is greatly appreciated. Craig Watson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
O8i install solution to ORA-3113 problems on RH 7
I thought I'd pass on the solution to a problem we just experienced trying to install Oracle 8.1.7 on to a box running Linux Kernel 2.2.16 (Red Hat 7.0): The install of Oracle8i (8.1.7) Standard Edition on this Intel box went very well except when it attempted to create the sample database. Since then, I have tried to create a small database with SID=orcl myself. Here is what happened: I successfully startup SVRMGR and connect internal. However, when I issue the startup nomount pfile=/orcl/pfile/initorcl_0.ora, I get the error message ORA-03113: end-of-file on communication channel. After doing this, I will get this same ORA-03113 every time I try to start SVRMGR. If I reboot the machine, I can alleviate getting the error message, that is until I try to startup nomount... in which case the same cycle repeats. By the way, I can successfully connect to databases running on remote servers. The Final solution to this problem was the following: RDBMS 817 rquires glibc 2.1.3 to install correctly. That means RedHat 7 will not work with glibc-2.2-12. This problem does not exist with RedHat 7.1 and all Suse certified versions. The problem is that Oracle 8.1.x needs glibc 2.1.3. It will link without error with glibc 2.2, but when you try to run dbassist or create a database from scratch, there are problems (dbassist hangs, End of file on communication channel, etc.) To get Oracle 8.1.6 or 8.1.7 working on systems with glibc 2.2. 1. Install the compat-glibc RPM for 2.1.3.x 2. cd to the directory where compat-glibc installed the files 3. Copy the following files to $ORACLE_HOME/lib: libc-2.1.3.so libpthread.so libdl.so ld-linux.so.2 Sometimes, these are symbolic links, so you'll need to copy the target of the symbolic link and rename it to the link name when you copy it to $ORACLE_HOME/lib. For example, if ls -l shows: ld-linux.so.2 - ld-2.1.3.so libc-2.1.3.so libdl.so - libdl.so.2 libpthread.so - libpthread.so.0 Then: cp ld-2.1.3.so $ORACLE_HOME/lib/ld-linux.so.2 cp libc-2.1.3.so $ORACLE_HOME/lib cp libdl.so.2 $ORACLE_HOME/lib/libdl.so cp libpthread.so.0 $ORACLE_HOME/lib/libpthread.so 4. Create a file in $ORACLE_HOME/lib called libc.so with the following contents (as a single line): GROUP ( OH/lib/libc-2.1.3.so OH/lib/ld-linux.so.2 CL/libc_nonshared.a ) Substitute the value of $ORACLE_HOME for OH and the location of the compat-glibc directory for CL. For example, my $ORACLE_HOME is: /u01/app/oracle/product/8.1.7 and my compat-glibc directory is: /usr/i386-glibc21-linux/lib so the GROUP line looks like this for me: GROUP (/u01/app/oracle/product/8.1.7/lib/libc-2.1.3.so /u01/app/oracle/product/8.1.7/lib/ld-linux.so.2 /usr/i386-glibc21-linux/lib/libc_nonshared.a) (This is all one line.) 5. cd $ORACLE_HOME/bin 6. Run the following command from the UNIX prompt: relink all All of the Oracle software, including the assitants, will work fine after this and will work with RedHat 7.0 and kernel 2.2.16 kernel, as well as the 2.4.0 and 2.4.1-pre11 kernels. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora - 4031 while inserting into a parent table
Raganath, Sounds like you got some bad SQL operating. Usually the error you are seeing is caused not by the shared pool being too small (although if it's too small for you're trying to do, nothing will help), but rather by excessive fragmentation making the requisite amount of continuous free space unavailable. Your remark that this is an insert involving 42 tables from another DB sort of reinforces my suspicions. One of the things I found out (from this list last year) was that you need to commit across DB links after DML to free memory. Make sure you're using bind variables. Make sure you're sharing SQL. Try using fully qualified table names. You could try flushing the shared pool to see if this resolves your problem, but you run the risk of losing sequences unless you've specified they should not be flushed using dbms_shared_pool.keep. The kqls heap message might also indicate library cache problems. Oracle suggests using the following to determine which parameters you need to address in tuning: First determine if the ORA-04031 was a result of fragmentation in the library cache or in the shared pool reserved space by issuing the following query: SELECT free_space, avg_free_size, used_space, avg_used_size, request_failures, last_failure_size FROM v$shared_pool_reserved; The ORA-04031 is a result of lack of contiguous space in the shared pool reserved space if: REQUEST_FAILURES is 0 and LAST_FAILURE_SIZE is SHARED_POOL_RESERVED_MIN_ALLOC. To resolve this consider increasing SHARED_POOL_RESERVED_MIN_ALLOC to lower the number of objects being cached into the shared pool reserved space and increase SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE to increase the available memory in the shared pool reserved space. The ORA-04031 is a result of lack of contiguous space in the library cache if: REQUEST_FAILURES is 0 and LAST_FAILURE_SIZE is SHARED_POOL_RESERVED_MIN_ALLOC or REQUEST_FAILURES is 0 and LAST_FAILURE_SIZE is SHARED_POOL_RESERVED_MIN_ALLOC The first step would be to consider lowering SHARED_POOL_RESERVED_MIN_ALLOC to put more objects into the shared pool reserved space and increase SHARED_POOL_SIZE. Note that _shared_pool_reserved_min_alloc is a hidden parameter in 8i. If all else fails, increase the size of the shared pool again. Hope some of this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ranganath K ranganathk@subex To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] group.com cc: Sent by:Subject: ora - 4031 while inserting into a parent table [EMAIL PROTECTED] 08/30/2001 09:37 AM Please respond to ORACLE-L Dear DBA Gurus, I am getting the following error while inserting into a schema's parent table which is being referred by 42 tables of another schema. ORA-04031: unable to allocate 2196 bytes of shared memory (shared pool,RA_VOLUME_PLAN_POOL,KQLS heap,KQLS MEM BLOCK); How do I resolve this? I increased the shared_pool_size from 15mb to 30mb and shared_pool_reserved_size from 1mb to 5mb but it didn't solve the problem. I also set the _db_cached_cursors parameter to 0 and bounced the database but in vain. BTW I am using oracle 8.1.6 enterprise edition on Sun Solaris 2.7. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence
sql*loader datatype question
Title: sql*loader datatype question I'm hitting a wall here. I'm trying to load data into a large table. Two of the fields are phone numbers (10 digits). The database field is defined as number(10). When I try to load these records, they err out with an error similar to below. Record 858: Rejected - Error on table INV_OWNER.FPSITE, column FPS_AFFIL_LTD_PTS_FPS. ORA-01722: invalid number So I change the fields to character, get the data in and it truly is all 10-digit numbers. I'm wondering if I'm missing something in the format. The doco says that INTEGER EXTERNAL is to be used for human readable numbers, non-binary, when you want to specify the length. The length I've chosen is correct. I can even create a table with number(10) columns and insert the varchar(10) phone number data into it! What am I missing? I really do not want to change all my number fields to character. It would defeat the purpose. I have a feeling I'm missing some sort of conversion in SQL*Loader but I don't see it off the top of my head. Thanks in advance for any suggestions. Lisa Koivu wanna-be DBA Hand Holder (that's what I've been doing this morning with an ex-coworker) and DBA Ft. Lauderdale, FL, USA The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.