(U) Hello All Again ... Christmas, Cary, Mysql, Perl, etc. ....
CLASSIFICATION: UNCLASSIFIED I have been off on a brand new program for a couple months now and haven't really been working with Oracle all that much. That will come later. Doing alot of prototyping in Perl and Mysql (gag) for this big project.I let everyone know that once the terabytes start flowing in MySql will no longer be an option. Just wanted to wish you all a very Merry Christmas. Cary, I started your book, but have only gotten through about 1/4 of it. Will comment later, but its obvious you write very well. Have a safe holiday everyone and we will see you soon. Mike Classification: UNCLASSIFIED -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(U) RE: RE: Hit Ratio
CLASSIFICATION: UNCLASSIFIED Rich, Burn any source that talks about hit ratio's. What exactly is running slow in your system and at what times ? Talk directly to the user that is experiencing the slowdown and ask them to repeat the behavior. Set a 10046 trace and go find the slowdown while the user is executing the application. Use the wait interface to determine what the culprit is. Lots of good books out on this stuff now. Is any batch job running at this time ? -Original Message- Sent: Monday, December 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L i dont think many people are using bchr anymore. I think its been talked down to death. only place I hear about it is offshore. people still using the old niemic book. his new took all that stuff out. or am i wrong? From: Jesse, Rich [EMAIL PROTECTED] Date: 2003/12/22 Mon PM 02:14:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Hit Ratio My BCHR is currently 96.62%. In the past, it was normally over 99%. What should I do? I'll be waiting for Mladen's reply... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, December 22, 2003 10:14 AM To: Multiple recipients of list ORACLE-L As a friendly reminder, when debunking myths, I suggest we keep sober and never go overboard. The recently popular formula to get an arbitrary hit ratio is not what a database in normal usage naturally gets. Unless a mischievous developer plays a prank, hit ratios are still useful to some extent in checking database health, although other indicators such as wait events should be given a greater weight. Yong Huang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Classification: UNCLASSIFIED -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Capacity Planning Methods?
Title: Capacity Planning Methods? Just lurking as usual, but Craig Schallahammer (sp) has a fairly extensive technical seminar on methods DBAs can use for capacity planning. Here is the link to his web-site. http://www.orapub.com/cgi/genesis.cgi -Original Message-From: David Wagoner [mailto:[EMAIL PROTECTED]Sent: Monday, August 11, 2003 2:24 PMTo: Multiple recipients of list ORACLE-LSubject: Capacity Planning Methods? How do you guys collect capacity planning metrics, such as DB size? Do you use StatsPack, Oracle OEM, others? I'm interested in an efficient method to track DB growth in GB month over month. Best regards, David B. Wagoner Database Administrator
RE: If you replied... Optimizer Mode question with regard v$sqlar
All my e-mail was sys$hosed last night so could you please resend any and all responses to this since last night. Anybody run into a situation where you see optimizer_mode equal multiple_children_present when the optimizer_mode is set to choose in the init*.ora file ? If so, did you follow up on it and try and determine why this was the case and your results ? There is very little information on Metalink regarding this issue. Thank you for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
If you replied... Optimizer Mode question with regard v$sqlarea
All my e-mail was sys$hosed last night so could you please resend any and all responses to this since last night. Anybody run into a situation where you see optimizer_mode equal multiple_children_present when the optimizer_mode is set to choose in the init*.ora file ? If so, did you follow up on it and try and determine why this was the case and your results ? There is very little information on Metalink regarding this issue. Thank you for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Optimizer Mode question with regard v$sqlarea
Anybody run into a situation where you see optimizer_mode equal multiple_children_present when the optimizer_mode is set to choose in the init*.ora file ? If so, did you follow up on it and try and determine why this was the case and your results ? There is very little information on Metalink regarding this issue. Thank you for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Millsap and Timestamps in trace files
Fair enough then. Good luck with it. -Original Message- Sent: Thursday, July 24, 2003 1:54 AM To: Multiple recipients of list ORACLE-L Thanks for the suggestion, Mike. I had hoped that the smiley had indicated that this was put forward in a (supposedly) humorous way. I had the great pleasure to spend some time with Cary during his stay in Iceland and I would not have posted my remark if I thought there was any danger of him being offended by it. But again, thanks for the reminder. Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 12:39 AM Just lurking today I suspect if you ask in a more gracious and pleasant manner you may get a response. fwiw, Mike -Original Message- Sent: Wednesday, July 23, 2003 2:10 PM To: Multiple recipients of list ORACLE-L In the draft of Cary Millsap's upcoming book. You get a copy of it when you attend the Hotsos Clinic 101. Cary's supposed to be in DC right now teaching this course so I suggest he better make damn sure that he explains this properly (both there and on ORACLE-L :) Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 3:04 PM Gudmundur, Where is this documented (so I can RTFM)? The one piece of this I don't quite understand is that the timestamp is not emitted twice in a row. If the long time is the triggering event, why do I see a gap of 90 minutes (in another trace file)? Daniel Gudmundur Bjarni Josepsson wrote: Daniel, Perhaps someone else can explain this better but the documentation I've got on this says that the Oracle kernel emits timestamps when a long time has elapsed since the last line was emitted to the trace file. Long time is defined as tens of seconds. Gudmundur -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Fink Sent: 22. júlí 2003 21:19 To: Multiple recipients of list ORACLE-L Subject: Timestamps in trace files I was perusing a 10046 trace file and I noticed that timestamps are written to the trace file. Sometimes they were very regular (3 minutes apart give or take 30 seconds) while other times they were hours apart. I have noticed that two timestamps are never written without any intervening activity. Anyone have any idea on the reasoning behind the timestamps and the 'triggering event'? Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note
RE: Millsap and Timestamps in trace files
Just lurking today I suspect if you ask in a more gracious and pleasant manner you may get a response. fwiw, Mike -Original Message- Sent: Wednesday, July 23, 2003 2:10 PM To: Multiple recipients of list ORACLE-L In the draft of Cary Millsap's upcoming book. You get a copy of it when you attend the Hotsos Clinic 101. Cary's supposed to be in DC right now teaching this course so I suggest he better make damn sure that he explains this properly (both there and on ORACLE-L :) Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 3:04 PM Gudmundur, Where is this documented (so I can RTFM)? The one piece of this I don't quite understand is that the timestamp is not emitted twice in a row. If the long time is the triggering event, why do I see a gap of 90 minutes (in another trace file)? Daniel Gudmundur Bjarni Josepsson wrote: Daniel, Perhaps someone else can explain this better but the documentation I've got on this says that the Oracle kernel emits timestamps when a long time has elapsed since the last line was emitted to the trace file. Long time is defined as tens of seconds. Gudmundur -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Fink Sent: 22. júlí 2003 21:19 To: Multiple recipients of list ORACLE-L Subject: Timestamps in trace files I was perusing a 10046 trace file and I noticed that timestamps are written to the trace file. Sometimes they were very regular (3 minutes apart give or take 30 seconds) while other times they were hours apart. I have noticed that two timestamps are never written without any intervening activity. Anyone have any idea on the reasoning behind the timestamps and the 'triggering event'? Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Index question
Terrista, Did you run the UTLXPLAN.sql file so you can get a explain plan output ? Check Metalink for an explanation of all of this here is one link http://metalink.oracle.com/metalink/plsql/ml2_gui.startup Then . SQL Set Autotrace on Then run those queries and report back the outputs. Everything else is set up fine for now although we will probaly change a few more optimzer parametersso stay tuned for that. buenos días a usted. Miquel. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Index question About the time test, this are some of the results: SQL set time on10:22:59 SQL select * from ictrans where item='0010096'10:23:30 2 10:23:39 SQL 10:23:53 SQL select * from ictrans where location='TJU01'10:24:20 2 10:24:21 SQL update itemloc set average_cost=6.3 where company='2000' and item='0010041'10:27:45 2 10:27:49 SQL [EMAIL PROTECTED] 06/26/03 03:09PM Teresita, Usted tiene un nombre hermoso. Yo nunca he estado a Guadalajara, pero oigo es muy agradable. La mayor parte de mi tiempo en México ha sido de Tiajuana completamente al sur a Zijuantinajo. El País hermoso y muy entibiar a gente Italia mucho más apreciando. Mi próximo viaje a México estará a Cabo San Lucas probablemente en agosto. Espero llegar a Guadalajara algún día. As for your current problem with the index.. First run a scriptcalled utlxplan.sql (spelling) from the $ORACLE_HOME/rdbms/admin directory under the schema you wish to execute this query out of then Theoptimizer_mode = Choose , timed_statistics = true parameters can be set in your init*.ora file, but your can see the current setting of these values through ... SQL select value from v$parameter where name like 'optimizer%' or name = 'timed_statistics'; The query will also return several optimizer values which may be needed for assessment later on. If you cannot bounce ( restart) the instance then consider setting these parameters using the command ... SQL Alter session set . Then SQL set autotrace traceonly also consider SQL set timing on for a relative cost on how much time the query takes and then Execute your SQL statement which willoutput anexplain plan for your viewing pleasure. Lots of information on metalink on how to use and interpretthe explain plan. Lets stop here and report back what your output is on the explain plan. CAUTION: I never use 3rd party products. I like to go straight to the data dictionary to find out whats going on with the database. Not to say3rd party productsare bad or anything, its just my style thats all. Espero que esto lo ayude fuera. Miquel. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Index question Where I can see the explain Plan?... I have TOAD but is a try version and I don't have this option activated, can I see it in another program? And where I have to define this option: optimizer_mode = Choose timed_statistics = true Michael: Sobre tus vacaciones como estaras cerca de Guadalaja, te recomiendo visitar estar ciudad, y tomar el tur del tren Tequita express. Yo no he ido a puerto Vallarte pero la gente de por alla es muy amigable y servicial, buena suerte !! [EMAIL PROTECTED] 06/25/03 09:59PM First, Your english is excellent or "Usted habla inglés muy bien. " Assuming you are running version 8i or better Have you analyzed the tables you are querying against ? You may not need to force a rule as the CBO will try to find the quickest way. It looks like you are using the RBO by default. Do you have optimizer_mode = Choose ? Do you have timed_statistics = true ? Have you run your queries through an explain plan ? If not this will show you the execution path and a relative cost of each statement. You can manipulate your SQL to see different costs as you change the statement. Also, Your queries could have been run while competing for resources in one case and maybe not in another case. Run both queries in the same environment. I have found that small tables don't need indexes for the most part although this is not a hard and fast rule. You must go through the process. Espero que eso lo ayude y la buena suerte a usted. Espero verlo en Puerto Vallarta Alguna Vez pronto en la playa con un margarita. Hasta
RE: Index question
Teresita, Usted tiene un nombre hermoso. Yo nunca he estado a Guadalajara, pero oigo es muy agradable. La mayor parte de mi tiempo en México ha sido de Tiajuana completamente al sur a Zijuantinajo. El País hermoso y muy entibiar a gente Italia mucho más apreciando. Mi próximo viaje a México estará a Cabo San Lucas probablemente en agosto. Espero llegar a Guadalajara algún día. As for your current problem with the index.. First run a scriptcalled utlxplan.sql (spelling) from the $ORACLE_HOME/rdbms/admin directory under the schema you wish to execute this query out of then Theoptimizer_mode = Choose , timed_statistics = true parameters can be set in your init*.ora file, but your can see the current setting of these values through ... SQL select value from v$parameter where name like 'optimizer%' or name = 'timed_statistics'; The query will also return several optimizer values which may be needed for assessment later on. If you cannot bounce ( restart) the instance then consider setting these parameters using the command ... SQL Alter session set . Then SQL set autotrace traceonly also consider SQL set timing on for a relative cost on how much time the query takes and then Execute your SQL statement which willoutput anexplain plan for your viewing pleasure. Lots of information on metalink on how to use and interpretthe explain plan. Lets stop here and report back what your output is on the explain plan. CAUTION: I never use 3rd party products. I like to go straight to the data dictionary to find out whats going on with the database. Not to say3rd party productsare bad or anything, its just my style thats all. Espero que esto lo ayude fuera. Miquel. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Index question Where I can see the explain Plan?... I have TOAD but is a try version and I don't have this option activated, can I see it in another program? And where I have to define this option: optimizer_mode = Choose timed_statistics = true Michael: Sobre tus vacaciones como estaras cerca de Guadalaja, te recomiendo visitar estar ciudad, y tomar el tur del tren Tequita express. Yo no he ido a puerto Vallarte pero la gente de por alla es muy amigable y servicial, buena suerte !! [EMAIL PROTECTED] 06/25/03 09:59PM First, Your english is excellent or "Usted habla inglés muy bien. " Assuming you are running version 8i or better Have you analyzed the tables you are querying against ? You may not need to force a rule as the CBO will try to find the quickest way. It looks like you are using the RBO by default. Do you have optimizer_mode = Choose ? Do you have timed_statistics = true ? Have you run your queries through an explain plan ? If not this will show you the execution path and a relative cost of each statement. You can manipulate your SQL to see different costs as you change the statement. Also, Your queries could have been run while competing for resources in one case and maybe not in another case. Run both queries in the same environment. I have found that small tables don't need indexes for the most part although this is not a hard and fast rule. You must go through the process. Espero que eso lo ayude y la buena suerte a usted. Espero verlo en Puerto Vallarta Alguna Vez pronto en la playa con un margarita. Hasta Luego. Miquel. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Index question Hi!! Let explain more about my situation. The company thatI work foris a chain of stores around some city's on Mexico, they bought Lawson a system that uses Oracle to manage the data bases, at first they use SQL Server 2000, but I wasn't enough to manager all the information. The structure of the table is all ready done and I have to learn it to do some reports that Lawson don't have, change or delete informationand export some information to dbf files. Because we was using SQL Server I used Store procedures to return the select resultto VB recordset and the I pass the select result to Crystal Report or to a DBF file. Well I see that in Oracle the store procedure do not returns the result set has easy has SQL Server so I use and statement that after execute it returns me the result in a record set. sQuery = "SELECT COMPANY,LOCATION, R_NAME FROM ICLOCATION " _ "WHERE COMPANY=2000 OR COMPANY=2001 OR COMPANY=2002 order by COMPANY,LOCATION"Set recRS = New ADODB.RecordsetrecRS.Open sQuery, gcnOracle,
RE: salary question
Why not ask for more like a $100K ? Your worth it, right ? -Original Message- Sent: Thursday, June 26, 2003 11:25 AM To: Multiple recipients of list ORACLE-L Does anyone have information about salaries in Denver? I looked at salary.com and saw the median salary was $72K. Does anyone have any opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Helen J Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Index question
First, Your english is excellent or "Usted habla inglés muy bien. " Assuming you are running version 8i or better Have you analyzed the tables you are querying against ? You may not need to force a rule as the CBO will try to find the quickest way. It looks like you are using the RBO by default. Do you have optimizer_mode = Choose ? Do you have timed_statistics = true ? Have you run your queries through an explain plan ? If not this will show you the execution path and a relative cost of each statement. You can manipulate your SQL to see different costs as you change the statement. Also, Your queries could have been run while competing for resources in one case and maybe not in another case. Run both queries in the same environment. I have found that small tables don't need indexes for the most part although this is not a hard and fast rule. You must go through the process. Espero que eso lo ayude y la buena suerte a usted. Espero verlo en Puerto Vallarta Alguna Vez pronto en la playa con un margarita. Hasta Luego. Miquel. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 7:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Index question Hi!! Let explain more about my situation. The company thatI work foris a chain of stores around some city's on Mexico, they bought Lawson a system that uses Oracle to manage the data bases, at first they use SQL Server 2000, but I wasn't enough to manager all the information. The structure of the table is all ready done and I have to learn it to do some reports that Lawson don't have, change or delete informationand export some information to dbf files. Because we was using SQL Server I used Store procedures to return the select resultto VB recordset and the I pass the select result to Crystal Report or to a DBF file. Well I see that in Oracle the store procedure do not returns the result set has easy has SQL Server so I use and statement that after execute it returns me the result in a record set. sQuery = "SELECT COMPANY,LOCATION, R_NAME FROM ICLOCATION " _ "WHERE COMPANY=2000 OR COMPANY=2001 OR COMPANY=2002 order by COMPANY,LOCATION"Set recRS = New ADODB.RecordsetrecRS.Open sQuery, gcnOracle, adOpenForwardOnly, adLockReadOnly, adCmdText or execute a delete or update statement sSQL = "update /*+ INDEX(itemloc ITLSET2) */ itemloc set average_cost =" costo " where (company='2000') and item= '" Arti "'"gcnOracle.Execute sSQL gcnOracle.Execute "Commit", dbSQLPassThrough Back to my problem: In this case the update of the average cost has to be done on the table Item location ( ITEMLOC) that have all the item that each location( store)have. The locations have a company, when we changes the average cost is per company ( each company represent a different city) So my boss execute the update statement sSQL = "update itemloc set average_cost =" costo " where (company='2000') and item= '" Arti "'" and she told me that per itemit takes like 10 seconds. After read the article that I mention shechanges the statement to this: sSQL = "update /*+ INDEX(itemloc ITLSET2) */ itemloc set average_cost =" costo " where (company='2000') and item= '" Arti "'" ITLSET2 is a index that have company(1), location(2) and Item(3) and it takes 2 seconds per item, so that is way she is convinced that we have to uses the /*+ INDEX(itemloc ITLSET2) */ in all of our select, update or delete statement. I hope you undestant my English and my problem too, because Ihave to dosome really complicated queries that have like 3 or5 tables in them, and using this method will give me some serious complications, maybe in this case (change of the average cost) is not too dangerous. ButI have to give her strong statements to change her mind. Thanks for everything friends!! [EMAIL PROTECTED] 06/25/03 06:10PM Teresita,I don't fully understand whether adding or removing a hint caused theproblem but like Stephane said - you should probably stay away from themfor now. If adding a hint decreased performance then you have proved thisfor yourself.A couple of important points:* Using an index isn't always faster than scanning the table* If a database is correctly analyzed then the optimisor can determine whento use indexes or not automatically* Hints can force the optimisor to choose a non-optimal execution plan. Ifyou are smarter than the optimisor this may be fine but in most cases theoptimisor will make the right decision when all tables are analyzed* Hints have very specific formatting and object name rules. If you renamean index the hint will become invalid and be blissfully ignored - you won'teven know.* There are some hints which can safely be used but
SAME technology question .....
A couple years ago, Juan Louiza(sp) of Oracle Corporation put out a white paper regarding SAME (Stripe and Mirror Everything).I have read the comments from Steve Adams regarding this methodology. I am curious if anyone else is or is not using the SAME methodology and what has been your experience so far. Oracle Corporation has locked into this methodology as recently one of our DBA's reported that they are teaching this in classes, but that others have not exactly climbed on board. Excluding Oracle employees if you could respond regarding your thoughts and experiences I would greatly appreciate it. Thanks For Your Time in Advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: any intro statspack docs online?
Search MetaLink ... Burleson has a good book "High PerformanceTuning with Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also hassome good information.. Look in your $ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or st*.txt document in there to show you how to set up and use. Also, I think Tim Gorman's site has some statspack stuffin his downloadable library section. http://www.evdbt.com/ HTH, Mike -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: Re: any intro statspack docs online? I know it is late but: Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation and recommendations. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, May 22, 2003 5:41 PM Subject: any intro statspack docs online? Ive read the otn stuff and the niemic articles from Oracle mag.anything else? any articles that give a brief intro that includes installation? Id prefer not to dig into the Burleson book. Im really looking for something brief.Not too familiar with tuning wait events, but I 'think' we have some contention problems, and before I create an elaborate routine, Id like to get some metrics. any quick start guide? Licensing is based on customers honesty basically. The versions you can download are fully functional with all the options. Visit our web site at http://www.quantsystems.nl/ -Original Message-From: Joe Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 AMTo: Multiple recipients of list ORACLE-LSubject: oracle trialware - features ?? Folks, Does "Oracle Enterprise Edition - Trialware" have all the features as that of alicensedone ? Is RMAN fully functional on a trial version of 9iR2 ? What makes the difference between these two ? If there is no difference, how does ORACLE prevent people from using it for PRODUCTION ? Read an interesting article about oracle licensing at http://www.vnunet.com/Analysis/1113993 and just thought of sharing it with u guys. Share your comments Gurus. Cheers, Joe. Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
RE: library cache pin wait
-- -- Memory Usage %: 93.23 86.67 % SQL with executions1: 54.37 75.05 % Memory for SQL w/exec1: 47.47 70.06 Top 5 Timed Events ~~ % Total Event WaitsTime (s) Ela Time --- library cache pin 97,608 95,845 40.95 latch free 2,788,119 70,018 29.91 CPU time 25,145 10.74 library cache load lock19,686 19,419 8.30 db file sequential read 6,334,694 6,715 2.87 - - Latch Activity for DB: TBASUN Instance: tbasun Snaps: 71 -91 -Get Requests, Pct Get Miss and Avg Slps/Miss are statistics for willing-to-wait latch get requests -NoWait Requests, Pct NoWait Miss are for no-wait latch get requests -Pct Misses for both should be very close to 0.0 PctAvg Wait Pct Get Get Slps Time NoWait NoWait Latch Requests Miss /Miss(s) Requests Miss -- -- -- -- -- library cache69,587,4423.30.7 53315 663,932 50.5 row cache objects29,587,4062.80.1 2549 128,096 18.3 Library Cache Activity for DB: TBASUN Instance: tbasun Snaps: 71 -91 -Pct Misses should be very low Get PctPinPct Invali- Namespace Requests Miss Requests Miss Reloads dations --- -- -- -- -- BODY 3,466 11.3 3,532 17.9187 0 CLUSTER 12,9210.1 14,9530.1 0 0 INDEX 38,620 19.0 38,618 24.5 8 0 SQL AREA 1,627,3546.3 26,006,4720.8152,116 8 TABLE/PROCEDURE1,206,3670.3 1,875,867 15.4158,738 0 TRIGGER1,4050.2 1,713 44.4542 0 - shared_pool_reserved_size 104857600 shared_pool_size 419430400 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Performance Tuning 101 Book now Available!
Title: Precise Software Solutions IMHO, Every DBA should own this book. It will change your way of thinking about how to approach oracleperformance problems. Mike -Original Message-From: Kent Mingus [mailto:[EMAIL PROTECTED]Sent: Wednesday, May 28, 2003 6:50 AMTo: [EMAIL PROTECTED]Subject: Oracle Performance Tuning 101 Book now Available! To unsubscribe from thisPrecise Software email listclick here and submit your email address. Free Book from Oracle Press Good Oracle Hit-Ratios Don't Make Users Happy...Good Performance Does! Conventional tuning approaches rely heavily on checking the Buffer Cache Hit ratio. But even though DBAs do their best to get a 99% or better hit-ratio they discover that the performance of their database isn't really improving when the hit-ratio gets better. More over, "ratio" tuning does not consider what the database is doing for the application, and application performance is what the end-user sees. Make your end users happy and reduce your workweek by following these simple steps: - Download this FREE book, Oracle Performance Tuning 101, and dispel the myths and folklore about performance tuning. - Register for a webinar on Precise's response-time tuning solutions. - Visit our website or give us a call for more information on our Oracle tuning solutions - like "Precise/Indepth for Oracle ... the best in a hotly contested market segment for Oracle instance monitoring and tuning tools." - Gartner Click here to Download Your FREE Book now! Download the Book Precise Software Solutions T: 1 781 461 0700 W: www.precise.com E: [EMAIL PROTECTED]
RE: Oracle Performance Tuning 101 Book now Available!
Charlie, I am not a spammer I am a struggling DBA trying to find answers just like you. I was mired in Hit Ratios for the longest time scratching my head trying to figure it all out ... lost in the clouds with no way out so to speak. In the end , it got me no where. I met this guy Gaja a few years back and he gave me some ideas to help me.Later I met Kirti. They are first class folks along with alot of folks on this board. Always willing to help ... Always willing to answer questions. As a free market capitalist pig I believe folks who work hard and put out good information should get notice as this book richly deserves.In addition, they deserve to be compensated for their hard work and knowledge just as Home Depot is compensating you, correct ? For example, if I told you to buy Synopsis (symbol SNPS) today at $59 and in a year that stock doubles then that information could be worth some money correct ? fwiw, Mike -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 11:10 AM To: Multiple recipients of list ORACLE-L I refuse to do business with spammers; regardless of what their product may be. Johnson, Michael [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fmc.af.mil cc: Sent by: Subject: RE: Oracle Performance Tuning 101 Book now Available! [EMAIL PROTECTED] 05/28/2003 10:44 AM Please respond to ORACLE-L IMHO, Every DBA should own this book. It will change your way of thinking about how to approach oracle performance problems. Mike -Original Message- From: Kent Mingus [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 6:50 AM To: [EMAIL PROTECTED] Subject: Oracle Performance Tuning 101 Book now Available! To unsubscribe from this Precise Software email list click here and submit your email address. |-| | | | | | | | | |(Embedded image moved to file: pic07195.gif) | |(Embedded image moved to file: pic07825.gif) | |Free Book from Oracle| |Press| | (E| | mb| | ed| | de| | d | | im| | ag| | e | | mo| | ve| | d | | to| | fi| | le| | : | | pi| | c0| | 38| | 30| | .g| | if| | ) | | | | | |(Embedded image moved to file: pic15360.gif
RE: Oracle Performance Tuning Exam
solved the problem because the first indication that something was wrong was spotting the bad BHR, which led to other investigations. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 25, 2003 10:24 PM To: Multiple recipients of list ORACLE-L Yeah, if you've taken the performance exam, you must now unlearn what you have learnt, to quote from Starwars. I've considered creating a one- or two-day class that would put people into the right track of thinking after having studied and passed that exam. The other exams are more or less fine. The tuning one really - ahm - could be improved... Mogens [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Guys, I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the oracle 8 tuning - read through once and not every item (not 8i class) - where the heck was statspack in the examm, btw? I took it in 20 minutes. Only the network one to go. Can't wait to get this done so can do the 9i upgrade exam - then wishing to concentrate on certification relating to 9ias - is there such a beast? -Original Message- mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, June 11, 2002 11:14 AM To: Multiple recipients of list ORACLE-L Arslan - I'm hoping you get some good replies since I plan to take this exam next. I just took the BR last week. The resource that helped me the most is: Oracle8i Certified Professional DBA Practice Exams by Jason S. Couchman http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA 1 http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA 1 Jisbn=0072133414 (hopefully this link will work, it will be broken into two lines which you must patch back together). Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 7:38 AM To: Multiple recipients of list ORACLE-L I will enter my last exam at next week. Could DBAs which have this exam give some advice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Excessive library cache latch contention
Harvey, Personally, I would go right to the user(s) who has complained about the slowdown and have them run the application at the peak hour/period where things seem very slow. Set a 10046 event level 8 trace on that session(s) after they log on and then take a look at the trace file in the udump area after they are finished executing the queries. There should be some strong clues in there about why the session is the waiting. My bet is on some poorly written SQL and these session competing for blocks. Check out Oracle Performance Tuning 101 Book and you can send your 10046 event data to www.hotsos.com for review if you are confused by it fwiw. good luck. mike -Original Message- Sent: Friday, January 31, 2003 3:09 AM To: Multiple recipients of list ORACLE-L We've got about 30 sites all running the same application, and I'm consistently seeing large numbers of 106 (library cache) latch free waits. They tend to happen at peak times during the day, and in the worst case I saw 12 sessions all on a 106 latch free wait event, spread across 3 P1RAW addresses. Running Steve Adams latch_sleeps scripts, yields the following: LATCH TYPE IMPACT SLEEP RATE WAITS HOLDING LEVEL - --- -- - - library cache 1281502 0.11% 2399666 5 cache buffers chains 273556 0.00% 23049 1 shared pool 73893 0.04% 91633 7 cache buffers lru chain 12236 0.01% 70756 3 session allocation 10639 0.06% 19969 5 row cache objects7835 0.00% 29816 4 cache buffer handles 3646 0.00% 2575 3 transaction allocation 2344 0.01% 4341 8 enqueue hash chains 1831 0.01% 13722 4 redo writing 778 0.01% 17328 5 session idle bit 714 0.00% 0 1 The results above are from an instance which has been up for 5 days As you can see, library cache latch has a big impact (though I must admit, I'm not sure what Steve's IMPACT formula actually tells me). When I check across other sites, I see a similar pattern - large numbers of 106 latch misses and sleeps. I guess what I'd like to know is where these latches are happening, which objects / cursors etc are causing the contention. I've grappled with SQL against x$kglob, trying to join back to the P1RAW but am not getting very far. Any ideas? TIA. Neil. -- This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message. Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvey Neil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: Excessive library cache latch contention
Correction on this ... I should have said www.hotsos.com would have some additional insights on dealing with 10046 data for you if you are interested. -Original Message- Sent: Friday, January 31, 2003 10:57 AM To: Multiple recipients of list ORACLE-L Harvey, Personally, I would go right to the user(s) who has complained about the slowdown and have them run the application at the peak hour/period where things seem very slow. Set a 10046 event level 8 trace on that session(s) after they log on and then take a look at the trace file in the udump area after they are finished executing the queries. There should be some strong clues in there about why the session is the waiting. My bet is on some poorly written SQL and these session competing for blocks. Check out Oracle Performance Tuning 101 Book and you can send your 10046 event data to www.hotsos.com for review if you are confused by it fwiw. good luck. mike -Original Message- Sent: Friday, January 31, 2003 3:09 AM To: Multiple recipients of list ORACLE-L We've got about 30 sites all running the same application, and I'm consistently seeing large numbers of 106 (library cache) latch free waits. They tend to happen at peak times during the day, and in the worst case I saw 12 sessions all on a 106 latch free wait event, spread across 3 P1RAW addresses. Running Steve Adams latch_sleeps scripts, yields the following: LATCH TYPE IMPACT SLEEP RATE WAITS HOLDING LEVEL - --- -- - - library cache 1281502 0.11% 2399666 5 cache buffers chains 273556 0.00% 23049 1 shared pool 73893 0.04% 91633 7 cache buffers lru chain 12236 0.01% 70756 3 session allocation 10639 0.06% 19969 5 row cache objects7835 0.00% 29816 4 cache buffer handles 3646 0.00% 2575 3 transaction allocation 2344 0.01% 4341 8 enqueue hash chains 1831 0.01% 13722 4 redo writing 778 0.01% 17328 5 session idle bit 714 0.00% 0 1 The results above are from an instance which has been up for 5 days As you can see, library cache latch has a big impact (though I must admit, I'm not sure what Steve's IMPACT formula actually tells me). When I check across other sites, I see a similar pattern - large numbers of 106 latch misses and sleeps. I guess what I'd like to know is where these latches are happening, which objects / cursors etc are causing the contention. I've grappled with SQL against x$kglob, trying to join back to the P1RAW but am not getting very far. Any ideas? TIA. Neil. -- This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message. Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvey Neil INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
RE: BCHR Tuning
not indicate a poorly performing database. Give me a database with a 45% BHR, and I can get it to 99% by running a few queries. Point well understood. It does not mean in any way that I should now ignore PIO's and start tuning LIO's. I still use BCHR. What you infer from the BCHR is what counts. Raj Yechiel AdarTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] adar76@intercc: .net.il Subject: Re: BCHR Tuning Sent by: root@fatcity. com January 13, 2003 10:58 AM Please respond to ORACLE-L Hello Anjo I just had a tuning session with Dov Hit, from ACS in Israel. He used some of the scripts that you showed him 2 years ago when you did some work for Amdocs. Anyway, after doing some search on the waits, he checked the BCHR and found out that this database has only 40%. That led us on further checks and we found more offending SQL's. The BCHR has it's place. Just do not measure yourself JUST by it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 13, 2003 3:03 AM Hmm, Lately? That actually started publicly in 1998 as far as I am concerned ;-) And acutally long before that. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, January 12, 2003 11:43 PM On Friday 10 January 2003 14:48, Mogens Norgaard wrote: Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Or modify the set up of these tools to take action when BCHR falls.. Here's the session info: Date: Mon, Apr 28, 2003 @ 11:45 AM - 12:15 PM Venue: Southern Hemisphere 2, Walt Disney World Dolphin, Lake Buena Vista, FL Abstract: Lately, there has been a big push to ignore your hit ratio with claims that it is meaningless. This shallow minded view (usually by people who sell a tuning tool) ignores why people look at hit ratios and what they are looking for. This quick tip talk will show you what to look for and why. You will definitely know when, where why to look at your hit ratio in the future. Show you why your hit ratio matters. How to analyze the hit ratio. Fallacies by those who want to sell you products and tools instead. Shallow Minded ?! Jared -- File: ATT00021.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mantfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: index hint ignored?
Title: Message We went thru this a couple days ago and Jonathan Lewis provided some possible scenarios as to how things are working beneath the radar. Also, page 166-167 on Guy Harrisons Book on SQL tuning will give you additional information. Good Luck. Mike -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 10:31 AMTo: Multiple recipients of list ORACLE-LSubject: index hint ignored? Hi there. I have a non-unique index on a table, and I'm trying to force Oracle to usethe index - but it always does a FTS. Why? (I've tried it with and withoutthe alias) SQL set autotrace traceonlySQL SELECT /*+ INDEX(A,vehicle_veh_year_indx) */ DISTINCT veh_year 2 FROM TIREADVISOR.vehicle A 3 ORDER BY veh_year DESC; 20 rows selected. Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=118 Card=20 Bytes=80) 1 0 SORT (ORDER BY) (Cost=118 Card=20 Bytes=80) 2 1 SORT (UNIQUE) (Cost=67 Card=20 Bytes=80) 3 2 TABLE ACCESS (FULL) OF 'VEHICLE' (Cost=16 Card=19607 Bytes=78428) === select TABLE_NAME, INDEX_NAME, COLUMN_NAME, COLUMN_POSITIONfrom dba_ind_columnswhere INDEX_OWNER = 'TIREADVISOR'and TABLE_NAME = ('VEHICLE') order by 1,2,4,3TABLE_NAME INDEX_NAME-- --COLUMN_NAME COLUMN_POSITION ---VEHICLE VEHICLE_PKVEH_ID 1 VEHICLE VEHICLE_VEH_YEAR_INDXVEH_YEAR 1 Thanks for any help! - Jerry
RE: Export / Import
From the O/S prompt $EXP HELP=Y or $IMP HELP=Y or see the Utilities manual, I believe chapters 2 and 3. Also, Kirti wrote up some good principles when using export and import that I keep on file. Im sure he could help you if you request it. HTH, Mike -Original Message- Sent: Friday, January 31, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Hello, OS Version: HP-UX 11i DB Version: Oracle 8.1.7.4 and 9.2.0.1 I've been looking around and I cannot seem to find a difinitive guide online about Oracle's Export and Import. I'm looking for all of the parameters and what they do. Could anyone point me in the right direction. Thanks, -Scott ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Jonathan Lewis ....
Thanks, Thanks for this information. I am more understanding of the underlying causes for what was going on now. I was the one that probably caused you to misinterpret the what my real issue was. Sorry for that. I am swamped here and have to brief. Thank You for your time. I enjoy referencing your book. Very nice work. Mike -Original Message- Sent: Saturday, January 25, 2003 5:39 AM To: Multiple recipients of list ORACLE-L Michael, Somewhere along the line, I mis-interpreted your note and thought you were saying that CBO was ignoring the hint - hence the irrelevant comments. RBO uses the index for this query because that's one of the rules. The CBO under ALL_ROWS optimisation is going to compare figures (in your case) like: leaf_blocks * optimizer_index_caching + clustering_factor * optimizer_index_cost_adj. and table_blocks / 6.5 + cost of sort Since clustering_factor bottoms out at table_blocks, your optimizer_index_cost_adj would probably have to be less than 15 before you had much chance of using the index. You state elsewhere that the timing difference is fractions of a second against seven seconds for thousands of rows. I wonder if this is the giveaway - I would be a little surprised if your client can actually acquire thousands of rows in a fraction of a second, although it might acquire the first few in that time. If this is the case, you might like to find out how long it really takes to acquire all the rows using the index - this might make the scan and sort path seem more reasonable.. If you switch the session's optimizer_mode to FIRST_ROWS, you will find that the optimizer will use the index - there is a heuristic hard-coded in to FIRST_ROWS (introduce in 8.1.6 I think) that always uses an index to avoid a sort. It is possible the FIRST_ROWS is actually the nominally correct optimizer mode for this bit of the application. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March USA_(FL)_May Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CBO not using the index even though it is faster when hinted
All the columns in the table are not null ... here is an interesting test I ran ... several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. Just deleted statistics on this and fwiw ... With Statistics = SELECT Statement Optimizer=Choose (Cost=225 ...) SORT (Order By) (Cost=225 ...) Table Access (Full) of 'table1' Physical Reads = 433 Without Statistics .. == SELECT Statement Optimizer=Choose Table Access (By Index Row) of 'table1 Index ( Full Scan ) of 'concatenated index' (Non-Unique) Physical Reads = 0 Mike -Original Message- Sent: Thursday, January 23, 2003 6:29 PM To: Multiple recipients of list ORACLE-L Anyone have any problems with the CBO not using a index when you know it is faster by forcing a hint ? I have set the following ... Solaris Oracle Version 8.1.7.4 block size = 8 DB_FILE_MULTIBLOCK_READ_COUNT = 8 mode = Choose also using Tim Gormans 90 and 50 values for the other optimizer parms. Select col1, col2, col3, blah1, blah2 from table order by col1, col2, col3; Concatenate index on col1, col2, col3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CBO not using the index even though it is faster when hinted
Yes ... I can force the hint, but why wont it take the RBO path ?Its a difference of 7 seconds versus a split second. So why would the CBO take that path ? -Original Message- Sent: Friday, January 24, 2003 1:14 PM To: Multiple recipients of list ORACLE-L hinted Well, if it can do it under rule-based, then it shouldn't be able to ignore the hint under CBO - I don't suppose there's any chance that you have a typo in the hint ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March USA_(FL)_May Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 24 January 2003 21:06 hinted All the columns in the table are not null ... here is an interesting test I ran ... several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. Just deleted statistics on this and fwiw ... With Statistics = SELECT Statement Optimizer=Choose (Cost=225 ...) SORT (Order By) (Cost=225 ...) Table Access (Full) of 'table1' Physical Reads = 433 Without Statistics .. == SELECT Statement Optimizer=Choose Table Access (By Index Row) of 'table1 Index ( Full Scan ) of 'concatenated index' (Non-Unique) Physical Reads = 0 Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CBO not using the index even though it is faster when hinted
John This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons). Thanks on this See note I sent just before this on what I did.Bottom line is the query now returns thousands of rows in a spilt second as opposed to the 8 seconds it took before. I believe when we were at IOUGA last year, I think Tim or Wolfgang said to be careful loading up on the hints 8i and beyond. Mike -Original Message- Sent: Friday, January 24, 2003 3:09 PM To: Multiple recipients of list ORACLE-L hinted Mike, several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons). I mention this as your original query does have a sort at the end... (Apparently, Direct read/writes is also used when async I/O is configured and used, but I will let the gurus address that!) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CBO not using the index ... Here is what I did
fwiw, The CBO is not choosing the fastest path for whatever reason on this query. When you run the various explain plans with timing on using the hints versus without the hint, it is clear which way is the faster way, but its not going that way using the CBO with a straight query. I turned the statistics back on and the apps programmer has used the index hint to force its use.Personally, I dont like this, but it works for now as we have a policy to avoid hints since Oracle 8i if at all possible. As for the question as to why the apps programmer wrote the query the way they did ? I do not have an answer as to why apps programmers think the way they do. I recommended they put some boundries on that query through a where clause and they went round and round about why they needed to return all the data. Thanks for your time and Jonathan your book is most excellent. Have a good weekend. Mike -Original Message- Sent: Friday, January 24, 2003 2:15 PM To: Multiple recipients of list ORACLE-L hinted Yes ... I can force the hint, but why wont it take the RBO path ?Its a difference of 7 seconds versus a split second. So why would the CBO take that path ? -Original Message- Sent: Friday, January 24, 2003 1:14 PM To: Multiple recipients of list ORACLE-L hinted Well, if it can do it under rule-based, then it shouldn't be able to ignore the hint under CBO - I don't suppose there's any chance that you have a typo in the hint ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) UK___March USA_(FL)_May Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 24 January 2003 21:06 hinted All the columns in the table are not null ... here is an interesting test I ran ... several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. Just deleted statistics on this and fwiw ... With Statistics = SELECT Statement Optimizer=Choose (Cost=225 ...) SORT (Order By) (Cost=225 ...) Table Access (Full) of 'table1' Physical Reads = 433 Without Statistics .. == SELECT Statement Optimizer=Choose Table Access (By Index Row) of 'table1 Index ( Full Scan ) of 'concatenated index' (Non-Unique) Physical Reads = 0 Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CBO not using the index even though it is faster when hinted ....
Anyone have any problems with the CBO not using a index when you know it is faster by forcing a hint ? I have set the following ... Solaris Oracle Version 8.1.7.4 block size = 8 DB_FILE_MULTIBLOCK_READ_COUNT = 8 mode = Choose also using Tim Gormans 90 and 50 values for the other optimizer parms. Select col1, col2, col3, blah1, blah2 from table order by col1, col2, col3; Concatenate index on col1, col2, col3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT - Who would you take with you...
Are you sure you want to go down this road and get into subjective disagreements with folks over this in front of everybody ? -Original Message- Sent: Monday, November 25, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Robert Freeman Anjo Kolk Cary Millsap Connor McDonald Kirti Deshpande Jared Still Jeramiah Wilton John Kanagaraj Waleed Khedr Ian MacGregor Rachel Carmichael Tim Gorman Well that is more than 10, there are plenty of others that should be on this list. I have these posters highlighted then sort by subject or name. I can be pretty sure if I see a lot of red names that I am getting into something juicy and the other posters that are not mentioned will be right in there also. That way I can collect messages for a couple weeks and still get all the good stuff in an hour or so. Sorry if I got some lazy dba's mixed by in here. - Ethan -Original Message- Sent: Monday, November 25, 2002 4:05 PM To: Multiple recipients of list ORACLE-L Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking because my mailbox is FULL, and I have to trash a large amount of the stored stuff thats here. I'm going to archive some of it to CD, but I have limited space, so I want to archive those people who are constantly offering the most insightful advice (I know it's available online, but I'm not always online and it's nice to be able to search these emails for targeted content). Anyone want to take a crack at a list? You are welcome to email me private if you are afraid you would hurt someone's feelings. I'd be happy to compile the lists and report back to the group the overall answers, but all email to me will be treated as strictly confidential. Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Day 1: OracleWorld
Why does this not surprise me ? -Original Message- Sent: Monday, November 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L So far strike rate of 0 for 3. ie 3 presentations, all of which were fluff and no reasonable technical content to speak of... Positives so far: The internet access PCs are nice and quick. If you're here in SF - come check out the OakTable Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to Excel
Title: Oracle to Excel there is an ODBC driver you can set up to handle this as I recall. hth. mike -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 10:49 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle to Excel I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me? Thank you in advance. Laura
ORA-03113 solved .....
After several tests on different machines we found that it was not a version problem, but a environment problem. What happened is that one of our DBAs had created a Unix alias to bring the instance up in her profile and that did not set up the environment properly even though the database came up the last time she bounced the database. Specifically, the LD_LIBRARY_PATH was environment variable was SYS$HOSED as we used to say in the VAX world. The fix is to make sure you bring up the Oracle Instance under the Oracle account. We bounced the instance in the middle of the night and everything is fine now. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop snapshot ORA-03113
We have logged a TAR with Oracle regarding this type of scenario except the client in NT and the server is Sun. They are in the process of reviewing the trace file we sent. Everyones hunch is that its a network issue. You should be able to reproduce it at with with various type of DDL. (eg. DROP USER blah;) -Original Message- Sent: Wednesday, October 16, 2002 8:49 AM To: Multiple recipients of list ORACLE-L Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to fix ORA-03113 error
I am working with Oracle right now on a similar problem which looks to be like a network problem depending on the versions of what you are running. There is a bug that was fixed in 8.1.7.3 dealing with 3113 errors. Dont know what version you are running, but that could have something to do with it. fwiw. Mike -Original Message- Sent: Monday, October 14, 2002 5:19 PM To: Multiple recipients of list ORACLE-L I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help. Thanks, David SVRMGR startup ORACLE instance started. Total System Global Area285236752 bytes Fixed Size 48656 bytes Variable Size75390976 bytes Database Buffers209715200 bytes Redo Buffers81920 bytes Database mounted. ORA-03113: end-of-file on communication channel ***Alert.log: Mon Oct 14 17:57:27 2002 Database mounted in Exclusive Mode. Completed: alter database mount Mon Oct 14 17:57:27 2002 alter database open Picked broadcast on commit scheme to generate SCNs Mon Oct 14 17:57:27 2002 Rolling back half complete log switch of thread 1 LGWR: terminating instance due to error 204 Instance terminated by LGWR, pid = 483 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box. -Original Message-From: Johnson, Michael Sent: Friday, October 11, 2002 10:38 AMTo: '[EMAIL PROTECTED]'Subject: Help on ORA-03113 error and 7445 in the trace file. We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
Help on ORA-03113 error and 7445 in the trace file.
Title: RE: Win2000/8.1.7.3.0/SQL We are getting a intermittent problem that happens both from a SQL prompt or if we execute off of a package. We can telnet in or go through the TNS side of things. It doesnt seem to matter. Sun Solaris 2.8 Oracle 8.1.7.4 Here is the scenario ... SQL Create user blah identified by blah default ts blah temporary ts blah; SQL Drop user blah; ORA-03113 end of file blah blah blah The server thread process is disconnected and we have to reconnect. ORA-07445 shows up in the trace file. After reconnecting we do indeed see that the BLAH user was dropped before we disconnected. Note that all DML seems to work on this connection , only DDL type stuff causes a problem. The only thing we can figure is some type of network issue, but what ?? Thanks for your time in advance. Mike
RE: Advice needed on move to Sun 15K (losing spindles)
I bet you Sun rep , while trying to unload some hardware on you, has never heard of the term Logical I/O.Many times when upgrading, one can make things worse , not better. If you are having performance problems, then zero in on what those could be and fix it there. Take some snapshots, 10046 data traces and or look at the session / system events for where you waits may be.Then fix them ... then tell your management you saved them 100's of 1000's of . Then they will give you a great big raise yah right !!! fwiw ... Mike -Original Message- Sent: Wednesday, October 09, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Our CIO has suggested that we get a Sun 15K to house all of our databases. This has some advantages (communication between the various boxes would be much faster) but I have some performance concerns. Specifically, our main OLTP database would go down from 18 spindles to 8 spindles. Mirroring will take away 4 of those leaving 4 spindles. The vendor (Sun) was recommending striping across all 4 spindles. He said we don't need to worry about i/o issues because there will be a large cache. I'm skeptical and argued for cutting them in half (striping 2 and 2). We could then at least seperate the redo logs from the datafiles (probably putting them with the oracle executables and some other files). The Sun rep kept talking up how much more powerful the CPUs were and I kept saying, but we're not CPU bound, we don't need any more CPU. If anyone can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody seen any information on MySQL RDBMS .....
on MySQL and what this RDBMS can do versus other RDBMS's including Oracle ? A Spec by Spec comparison is what I am looking for. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Deadlocks on lack of Foreign key indexes ...
Jared, Thank You . Tom Kytes book pages 108 to 111 goes into this. I will continue to follow this advice. Mike -Original Message- Sent: Friday, September 27, 2002 8:43 AM To: Multiple recipients of list ORACLE-L I always use indexes on FK's. If it's a table with many updates, it needs them to avoid locks on the table. If the table doesn't have many updates, it's not really necessary, but it doesn't hurt either, and that way I don't have to figure out if it's busy enough to warrant the index. :) Jared On Thursday 26 September 2002 17:43, Johnson, Michael wrote: Does anyone consider it essential to put indexes on Foreign Keys or is it just an option to safeguard against the rare possiblity of a deadlock ? Is this possibility real and have you seen it happen ? I am one who does not want to create a foreign index as their is already one wih a leading column which makes this foreign key index redundant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Setting Cursor Sharing = Force in 8.1.7.3
I went thru this recently ... The best thing to do is to FORCE the developers to use bind variables and then this is no longer an issue. If you do set it to FORCE , I believe there is a problem with it in versions 8.1.6 and before and it should not be used.Double Check with Metalink on this. FWIW ... Mike -Original Message- Sent: Friday, September 27, 2002 1:13 PM To: Multiple recipients of list ORACLE-L We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Deadlocks on lack of Foreign key indexes ...
Does anyone consider it essential to put indexes on Foreign Keys or is it just an option to safeguard against the rare possiblity of a deadlock ? Is this possibility real and have you seen it happen ? I am one who does not want to create a foreign index as their is already one wih a leading column which makes this foreign key index redundant. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: quckways to find block corruption
FWIW I like to do full exports in the middle of the night just for this reason as a hot backup wont cut it. If you find a corrupt block you can fix it using either a PL/SQL or PRO*C rountine that can be found on Metalink. Search for corrupt blocks. Mike -Original Message- Sent: Monday, September 23, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hello all, DB: 8i OS: solaris 2.7 can somebody post me reply for this. is there any quick way to find which datablocks are corrupted in my oracle database . ( other than dbverify and rman backup. ) b'coz we have BCV backup already implemented and we cannot do a dbv every week for 500 gig production database . thanks in advance, srinivas __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: quckways to find block corruption
yes, but you can recreate an index without losing any data. fwiw. mike -Original Message- Sent: Monday, September 23, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Beware, we had a corrupt block in an index. Big deal you say!? Every time the client used the index the database would crash! Not good. We now do exports, and dbverify. But they don't catch bad index blocks. We also learned to check the alertlog a couple of times a day. R. Smith -Original Message- Sent: Monday, September 23, 2002 4:48 PM To: Multiple recipients of list ORACLE-L FWIW I like to do full exports in the middle of the night just for this reason as a hot backup wont cut it. If you find a corrupt block you can fix it using either a PL/SQL or PRO*C rountine that can be found on Metalink. Search for corrupt blocks. Mike -Original Message- Sent: Monday, September 23, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hello all, DB: 8i OS: solaris 2.7 can somebody post me reply for this. is there any quick way to find which datablocks are corrupted in my oracle database . ( other than dbverify and rman backup. ) b'coz we have BCV backup already implemented and we cannot do a dbv every week for 500 gig production database . thanks in advance, srinivas __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can I change Oracle as well as NT Domain passwords
Are you trying to change the Oracle and NT Domain accounts which are the same and you want the same password ??? If not, write a script or request that one be sent to you. -Original Message- Sent: Friday, September 20, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Hi All How can I change passwords of a user of Oracle application as well as W2K/NT Login? Any utility in 8/8i can do this form me? Thanks in Advance Shiva B -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ioug meeting or HOTSOS Seminar
Goto Both -Original Message- Sent: Tuesday, September 10, 2002 7:23 AM To: Multiple recipients of list ORACLE-L Hello List I got a message about Hotsos Tuning seminar in Dallas. Scheduled in February 2003. The lecturers list include among others: Tom, Anjo, Gaja. http://www.hotsos.com/events/symposium/ I also know that there is an IOUG Live meeting on May 2003, and many of you recommended going. http://bneo15.sba.com/ew/ioug/index3.cfm?clientsess_id=07332332nextpage=cal lpapersconference_id=71 MAYBE (not shouting but a big maybe) I will convince management to spring for one of the two. Which one you recommend? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle and Cache Hit Ratio based training
FWIW ... One of our DBAs just got back from a Oracle 9i course and it was stated by the instuctor that Oracle is in the process of revamping all their performance classes to be based on the wait interface. Looks like Cache Hit Ratios may finally go away !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone seen any independent performance .....
studies on what happens to performance as indexes keep getting added to tables while inserting data ?? Thank You in advance for your time. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PCTFREE PCTUSED
why does this number not surprise me ??? lol -Original Message- Sent: Thursday, September 05, 2002 1:18 PM To: Multiple recipients of list ORACLE-L 42 ;) -Original Message- Sent: Thursday, September 05, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi Can some one suggest what would be normal PCTFREE and PCTUSED for following type of tables? TYPE A: High rate of insert/delete but less update TYPE B: High rate of update but less insert/delete TYPE C: Large objects used for read mostly less DML operations Type D: High rate of DML operations Thanks in advance -seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IMPORT sloooowwww
Here is a most excellent post from Kirti Deshpande, [EMAIL PROTECTED] earlier on some import / export principles that may help you. If you like it, pass on your thanks to him. PEACE. Mike Prepare scripts to build tables, indexes and constraints etc.. Prebuild the tables in the target database. I am assuming that a database is already created with all the tablespaces etc.. Improving Export performance: 1) Use direct=y. That will make the export process significantly faster. 2) Along with (1), setting 'recordlength' to multiples of db_block_size or to its max value (65535) will help 'squeeze out' some more performance gain. Although, this parameter is to be used when exporting/importing on different OS where it has different default values, I use it for added performance gain. You may want to give it a trial run to see if that would help. 3) I do not export indexes. Improving Import Performance: 1) Keep database in no-archive log mode, if it is not already so. 2) Remember to use ignore=y since tables are already present. 3) Use commit=y to control rollback segment usage. 4) Do not import indexes by setting indexes=n (just to be sure). 5) Set buffer= to a high value, 5-10 MB should work fine (there is no proportional gain performance in raising this value too high). 6) Set analyze=n to suppress automatic estimation of table statistics. Analyze tables using your procedures after indexes etc are built 7) For primary key constraint indexes, I keep the quota on the target tablespace to 0 to make it fail during import. (something I just find easier to remember). 8) Set log= to some log file name to capture all (good and bad) messages from the import process. 9) After the import is completed, set sort_area_size, sort_area_retained_size to a higher value (whatever is adequate and possible) to speed up index build process. Also, consider TEMPORARY type temp tablespace with properly configured initial and next (multiples of sort_area_size) extents. Make sure temp tablespace has ample room, should index build processes perform disk sorts. Also, make sure quota is okay on tablespaces for primary key constraint indexes. 10) Run all the index build scripts. Use nologging attribute and consider building indexes in parallel, if resources are available to do so. 11) Enable all the constraints etc. 12) After all indexes are successfully built, make sure the sort parameters are adjusted back to what they should be for running the db normally. Spot check and make sure everything looks fine and okay. 13) Do not forget the SQL*Net thingy.. Make necessary changes to global_name, TNSNAMES.ora and LISTENER.ora file. Bounce the listener. 14) Run your own procedures to analyze tables and indexes. 15) Take a cold back up. 16) Startup mount and change to archive log (if required). Open the db for users. 17) Time to hit the door.. -Original Message- Sent: Thursday, August 29, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.7 on Solaris 8 I am testing and upgrade from 7.3.4 to 8.1.7. Because the test server is solaris 8, and I can't find the patches for 7 anymore, I am trying to upgrade via an export and import. Besides, the DB is small - less than 2G. The export was done with compress=n. There are 200+ tables to be imported. It is taking 3+ minutes per table for the import, even on tables that have 0 rows. (Though it does take longer than that for the few tables with over 50K rows). I have tried: 1) Simple import. 2) Import with indexes=n 3) Import with table and constraints (but not indexes) pre-created and indexes=n ignore=y 4) All of the above with the buffer set to 8M (This actually slows the import down, taking 5+ minutes per table). 5) Increasing the sort_area_size for the DB to twice as large as it was and trying the above. In looking at how long it takes, the table imports in a second or less, but it takes 3 minutes + to start the import of the next table. I'm not sure what it is doing for 3 minutes after the table imports. Does anyone have any ideas how I can speed this up? 10 hours to import a 2G. DB is extreme and unacceptable. TIA. Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET
RE: how to reduce SQL*Net more data to client wait event
Tim, more specifically could large SQL have been passed across the net ? Stored procedures could help here. FWIW. Mike -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 AMTo: Multiple recipients of list ORACLE-LSubject: Re: how to reduce SQL*Net more data to client wait event Depending on the application,couldn't theselarge pausesbe performance problems in the client program? Not a server tuning issue nor a SQL*Net tuning issue at all? For example, if the client program was pausing a long time between FETCH commands, processing previously fetched data? Or would thatjust be accounted for under"SQL*Net message from client" events? - Original Message - From: Suhen Pather To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 8:08 PM Subject: how to reduce SQL*Net more data to client wait event Hi, I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction of the CPU consumed by the system. I know this is not to be characterized as an idle wait event and can yield better performance if we increase the packet size. The database is Oracle 7.3.4 (SQL Net 2.3). What effect will increasing TDU and SDU have on this wait to increase packet size. It seems that if we can reduce this wait then we can save lots of time (I Think). Will using BEQ protocol help at all. Regards Suhen
RE: how to reduce SQL*Net more data to client wait event
thank you. mike -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: how to reduce SQL*Net more data to client wait event No, this is "to client", so it is the result of a query (either to many columns or too many rows returned). Large SQL statements would result in "from client" during the Parse phase and if people keep on parsing the same statement, the client side will keep on sending it to the server. Parse once/execute many Anjo. - Original Message ----- From: Johnson, Michael To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 21, 2002 9:10 PM Subject: RE: how to reduce SQL*Net more data to client wait event Tim, more specifically could large SQL have been passed across the net ? Stored procedures could help here. FWIW. Mike -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 AMTo: Multiple recipients of list ORACLE-LSubject: Re: how to reduce SQL*Net more data to client wait event Depending on the application,couldn't theselarge pausesbe performance problems in the client program? Not a server tuning issue nor a SQL*Net tuning issue at all? For example, if the client program was pausing a long time between FETCH commands, processing previously fetched data? Or would thatjust be accounted for under"SQL*Net message from client" events? - Original Message - From: Suhen Pather To: Multiple recipients of list ORACLE-L Sent: Monday, August 19, 2002 8:08 PM Subject: how to reduce SQL*Net more data to client wait event Hi, I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction of the CPU consumed by the system. I know this is not to be characterized as an idle wait event and can yield better performance if we increase the packet size. The database is Oracle 7.3.4 (SQL Net 2.3). What effect will increasing TDU and SDU have on this wait to increase packet size. It seems that if we can reduce this wait then we can save lots of time (I Think). Will using BEQ protocol help at all. Regards Suhen
Suggestions for a single sign on in Forms and Reports ....
Just got back from vacation and have been dragged into a working group on a problem the users find unacceptable on one of our new systems. Has anybody had any experience with Forms / Reports through the 9IAS server such that one can be authenticated using the unix login/password without having to log onto Forms / Reports ? The clients connect to 9IAS through HTTP so there is no Oracle Client software installed above the apps. server and I would like to keep it this way. FYI ... I know how to do this off of a SQLPLUS command and that is not what I am looking for here. Thank You much for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Problem after Migration
I have done this before and I always do it on a test machine first as everything that has been tuned up to this point is now at step 1 all over again. Did you import everything properly ? Indexes ? Make sure your schema objects are analyzed again. Find out the time of the day where the real slowdown occurs and you should be able to pinpoint the BAD sql and tune it. Use the system and session wait interface. Also, during that time set up your 10046 event 12 data and look for your main waits. Goto to the developer/user that is complaining the most and try to feel their pain by running through the application yourself and gathering the stats at the time the application is running. Also, I would buy Gaja and Kirti's book Oracle Performance Tuning 101 which is dedicated to this type of troubleshooting. Also, see www.hotsos.com for 10046 information and Cary is very good at explaining things. Consider getting some logs on these waits and posting them here as there are many folks who are on this board that are very smart in these areas. PS.. Once you start doing this stuff and get used to it, it gets easier and easier. Good Luck to you ! FWIW ...Mike -Original Message- Sent: Thursday, August 01, 2002 2:28 PM To: Multiple recipients of list ORACLE-L I have an interesting problem. I recently migrated a database from a Digital Unix system to a Sun Solaris system, with an EMC disk array. Since I was going to be migrating the database, I decided to double the block size from 4k to 8k. I also created the tablespaces on the new box as locally managed, with fixed extent sizes. Then I did a full database export, ftp'd the file, and imported it. It went well, or so I thought. The application works, but it is much slower than it was on the original (Digital) system. One side effect was that I didn't change the db_block_buffers, so that part of the SGA essentially doubled in size. The library cache hit rate was always around 99%, but the data cache hit rate used to only be about 85%, now it is 95 - 99%. All of the sorts are being done in memory, with memory to spare (52G yesterday, not used). According to the statistics, the database should be screaming. But the users are complaining that the online screens are taking much longer to come up. They say that the screens used to come up in 1 - 2 seconds, now it's taking about 10. Just for fun, I tried deleting the statistics and changing the optimizer_mode from choose to rule. That made things worse, which was what I expected, but it was worth a try. I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. Until then, I'm pretty baffled. I'd appreciate any ideas that anyone has on this. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Performance Problem after Migration
in addition you could also have I/O and or CPU problems so check those things out too. -Original Message- Sent: Thursday, August 01, 2002 3:31 PM To: '[EMAIL PROTECTED]' I have done this before and I always do it on a test machine first as everything that has been tuned up to this point is now at step 1 all over again. Did you import everything properly ? Indexes ? Make sure your schema objects are analyzed again. Find out the time of the day where the real slowdown occurs and you should be able to pinpoint the BAD sql and tune it. Use the system and session wait interface. Also, during that time set up your 10046 event 12 data and look for your main waits. Goto to the developer/user that is complaining the most and try to feel their pain by running through the application yourself and gathering the stats at the time the application is running. Also, I would buy Gaja and Kirti's book Oracle Performance Tuning 101 which is dedicated to this type of troubleshooting. Also, see www.hotsos.com for 10046 information and Cary is very good at explaining things. Consider getting some logs on these waits and posting them here as there are many folks who are on this board that are very smart in these areas. PS.. Once you start doing this stuff and get used to it, it gets easier and easier. Good Luck to you ! FWIW ...Mike -Original Message- Sent: Thursday, August 01, 2002 2:28 PM To: Multiple recipients of list ORACLE-L I have an interesting problem. I recently migrated a database from a Digital Unix system to a Sun Solaris system, with an EMC disk array. Since I was going to be migrating the database, I decided to double the block size from 4k to 8k. I also created the tablespaces on the new box as locally managed, with fixed extent sizes. Then I did a full database export, ftp'd the file, and imported it. It went well, or so I thought. The application works, but it is much slower than it was on the original (Digital) system. One side effect was that I didn't change the db_block_buffers, so that part of the SGA essentially doubled in size. The library cache hit rate was always around 99%, but the data cache hit rate used to only be about 85%, now it is 95 - 99%. All of the sorts are being done in memory, with memory to spare (52G yesterday, not used). According to the statistics, the database should be screaming. But the users are complaining that the online screens are taking much longer to come up. They say that the screens used to come up in 1 - 2 seconds, now it's taking about 10. Just for fun, I tried deleting the statistics and changing the optimizer_mode from choose to rule. That made things worse, which was what I expected, but it was worth a try. I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. Until then, I'm pretty baffled. I'd appreciate any ideas that anyone has on this. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing .... Continued
yes im aware -Original Message- Sent: Friday, July 26, 2002 9:09 AM To: Multiple recipients of list ORACLE-L * * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Beware of ORA-600, ORA-7445, and incorrect results w/CS=F on 8i! I've got it on 8.1.7.2 and we live with the possibilities. I get the most ORA-7445s when doing queries on the DD. This supposedly gets better with 8.1.7.3 and .4. We've also got one app that consistently returned WRONG results with CS=F (BUG 2225065). Tbe only workaround available is to turn it off for that app or upgrade to 9i. HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Subject: Cursor Sharing Continued Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing .... Continued
Take your case to management with that statistics of how long queries take with and without bind variables. Let them decide when to make the developers re-code their apps. If your management doesnt make them correct it then I dont know what to say from there.My management has said It will be fixed in a future version. The question is now when to do it. FWIW. Mike -Original Message- Sent: Friday, July 26, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Michael - So . . . since you have a work-around that is relatively easy from the developer point of view, how do you plan to convince them to rewrite their programs? Or do you have a really big hammer? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: efficient way to duplicate db on another unix host?
I have a paper on how to do this using the same version of Oracle on the same O/S if you are interested. basically you are using hot backups from a Tar. If you are interested let me know. Mike -Original Message- Sent: Friday, July 26, 2002 9:20 AM To: Multiple recipients of list ORACLE-L Having just been working with it rman duplicate seems a good bet. It seems very efficient and you don't have to worry about sizing issues as it just builds it as it sees it If you have any questions I might be able to help I have seen one problem and that was with it not doing a proper recovery and you need your original db in archivelog mode. I seem to have a problem in the controlfile, it put in a screwy path for the directory where the logs are. I think I need new controlfiles in the original dbs but haven't been able to work this out. alternatively I have a script here that came from one of the sites around and it explains how to do it by doing an OS copy of the datafiles. This entails a lot of downtime in the original unless you can say split the mirror or something the rman method does it with a hot backup so there is no downtime on the first system HTH -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Carmen Rusu [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2002 06:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:efficient way to duplicate db on another unix host? Hi Oracle gurus: What is, in your opinion, the fastest way to duplicate a database on a another unix host? Thanks, Carmen Rusu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carmen Rusu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help on Temp Space
I have seen this exact behavior too. FWIW. Mike -Original Message- Sent: Friday, July 26, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Lisa, I've had problems with TEMPORARY tablespaces in Version 7. Busy databases continually ran out of TEMP space, and it would not get released for use by other sessions. We finally went back to PERMANENT temp TBS's on version 7 and the problems disappeared. I haven't experienced this on 8+. Jared Lisa R. Clary [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/26/2002 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Help on Temp Space Hi all, Still on 7.3.4, and can't seem to free up the temp space. it is set up as temporary, and I have tried the alter tablespace TEMP default storage (pctincrease 1); to see if that would clean up (reset) the free space. I swear I have done this before (with success) but maybe the brain is suffering from dementia. I thought the space would be re-used even if it didn't reflect it in the pctfree. Any suggestions? Went to metalink, and saw conflicting advice (don't use temporary...frees up automatically...smon does not clean up temporary segments...bounce the database) thanks, lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cursor Sharing| Soft Parsing
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cursor Sharing .... Continued
Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cursor Sharing
Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd/2)
There are those that argue Apple provided competition to Microsoft. Not very good competition, but competition nonetheless and so the monopoly argument goes out the window.I agree Microsoft is substandard product, especially with regard to the server based class. However, the market place has spoken very clearly and it is up to someone else to come and take away some of Microsofts Pie ! In 1998, at Oracle OpenWorld, McNally and Ellision completely trashed Microsoft and Bill Gates in one of those open morning sessions.My thought at the time was , instead of bitchin about them , why dont you just go compete against them and put them out of business. Well, its 2002 and Sun / Oracle now have major business problems and Microsoft just seems to keep on truckin. I havent heard much lately from Scott and Larry regarding this issue. Perhaps they are putting together a good technical presentation for Openworld this year and that will give me a good reason to go. maybe I will hear good technical presentations instead of thoughtless meanderings and tirades about folks they are obviously jeoulous of. FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 3:19 PM To: '[EMAIL PROTECTED]' Hi Mike, I just got a bit of a chuckle when you mentioned free market system and Microsoft in the same breath. Microsoft didn't get to be the biggest by having the best product. They got it from the best marketing and unscrupulous and illegal business practices (tried to say that without using the over-used Monopoly!). Oracle can make claims that they are the best because they can actually prove some or most those claims. MS can't. Sorry for sounding like a whiner, but it's been a Microsoft day at it's best. Multiple reboots for everyone! Yay! OK, enough whining. It's no fun when you can't whine/complain to someone without having some brewskis! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: (Fwd/2) I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd/2)
I would add to this .. In a free market system nobody should look at the negative side when people make money off of their hard work or investments. This is the way it is set up. Why not say damn, how did he do it and where do I get in line to get some of that action ? I always find it interesting the envy and/or disgust that some folks have toward people who make alot of money. Think of all the middle class people Larry Ellison and crew put to work who bought homes and cars to drive our economy. I didnt care for any of Larry and Scotts bitchin and moanin about Microsoft and Bill Gates, but I say to Larry .. More power to you to make more money, keep gettin richer and help build our economy. Keep on truckin ! FWIW. Mike -Original Message- Sent: Tuesday, July 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Certainly. I'm waiting for people to present more factual information. (Maybe Larry needed some petty cash for a new boat or something?) As the story was related to me, Ellison has been living off of loans (from banks, not Oracle) for the past couple decades. His alleged reasoning was that his stocks would appreciate far faster than the interest of the loans, thus making it more economical to borrow than to sell. Obviously, with such a plan, you have to pay off sometime, and in 2000 one (or more) of his lenders called in his loans for payment. Again, this is just hearsay, but that's what I've heard... ...so, in essence, he sold stock because he had (large unexpected) debts to pay. The timing of the stock sale wasn't his, it was some banker's... Instead, what you see is people defending the social privileges of the wealthy technocorporate elites, and the ethos of sleaze, extreme greed and selfishness that they are mired in. Oh, you do yourself far too much justice! My own objection was your prolonged and uninformed vitriol lacking anything more than a politician's media release for substantiation. Go measure some cache-hit ratios, please... Do you know if Oracle's accounting practices are currently documented in a way that is transparent to investors? No idea. Not of interest... I guess a lot of alleged facts will come out after the august deadline that the SEC has imposed for corporate executives to sign off on the validity of their accounting. Sure. Whatever. Whaddya say we get back to work and talk techie stuff and quit wasting time on this fluff? signing off on thread -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT
Not defending Ellison for anything, but it appears McCain is just another politician who is only interested in his future and he constantly takes on these reform ideas and just makes the matter worse. Everyone should accept the fact that we are in a bear market and as such all the boats go down. Everyone should have been smart enough to sell stocks and put their money into cash or better yet short stocks when it was very clear that in the Fall of 2000 after the initial March 2000 sell off that we were going into a prolonged Bear market. Ellison probably took the money and ran when this became apparent to him and many others. I know I did. FWIW. Mike -Original Message- Sent: Monday, July 15, 2002 5:53 AM To: Multiple recipients of list ORACLE-L OT - unix My understanding is that this was the very first time Ellison had ever sold Oracle stock, in over 25 years of the company's existence, in 2000, which is the occasion that McCain (and you) are referring to. As you might be aware, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almost overnight after some financial-earning restatements. On that occasion, he would certainly have had prior knowledge of what was going to happen, to put it mildly. In 2000, any foreknowledge of a long-term downturn (26 months and counting?) would have been worth far more than $700m, especially to someone holding several billions in equities... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 10:13 PM unix Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle stocks just before they lost most of their value (sarcasm: I'm sure he is planning on plowing it back into the company, especially improving quality in OWS and Metalink). regards, ep On 14 Jul 2002 at 16:28, Alex wrote: Date sent: Sun, 14 Jul 2002 16:28:18 -0800 the future To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ... As far as DB vendors targeting linux they move in herds and have just finished their linux port from when linux was a buzzword. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT
Ditto ! -Original Message- Sent: Monday, July 15, 2002 2:02 PM To: Multiple recipients of list ORACLE-L OT - unix Nope. I just thought that people are innocent until proven guilty. One thing about someone in Ellison's position is that it would be impossible for him to *ever* sell stock without having the unfounded accusations you've quoted being hurled at him. So, are you saying that it is OK to throw such accusations around, when you don't know anything about anything? Or is there further substantiation for what you're saying? Does that mean he should never sell stock? Or should he just live his life and ignore the critics? I respect and admire Sen. McCain as much as I respect and admire anyone, but he is not infallible and he (and his staff) can certainly be off the mark... - Original Message - To: Tim Gorman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 15, 2002 10:49 AM unix Tim, It is my understanding that Oracle's stocks have gone up and down wildly several times. As you say, the only time I've heard that Larry Ellison cashed out before a plunge happened was the recent one that McCain brought up. I'm afraid I fail to see what you think people should conclude from all that. Are you saying that it is ok for stock holding workers and investors to get gigantically screwed just because Larry Ellison has only done it once? regards, ep On 15 Jul 2002 at 4:53, Tim Gorman wrote: Date sent: Mon, 15 Jul 2002 04:53:21 -0800 From: Tim Gorman [EMAIL PROTECTED] Subject:Re: McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] My understanding is that this was the very first time Ellison had ever sold Oracle stock, in over 25 years of the company's existence, in 2000, which is the occasion that McCain (and you) are referring to. As you might be aware, there was a far greater opportunity for Ellison to cash out and leave Oracle dangling in 1990, when the price dropped from around $20 to $6 almost overnight after some financial-earning restatements. On that occasion, he would certainly have had prior knowledge of what was going to happen, to put it mildly. In 2000, any foreknowledge of a long-term downturn (26 months and counting?) would have been worth far more than $700m, especially to someone holding several billions in equities... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 14, 2002 10:13 PM unix Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle stocks just before they lost most of their value (sarcasm: I'm sure he is planning on plowing it back into the company, especially improving quality in OWS and Metalink). .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: McCain on Larry Ellison and Corporate Responsibility / Re: OT
I wish I had enough money to retire. But I did get out of the market in the Fall of 2000 so I at least have a fighting chance. This is only because I had parents who forced me to study bull and bear markets and let me know that money is important. Otherwise I would be in the same boat as everyone else. FWIW. Mike -Original Message- Sent: Monday, July 15, 2002 1:13 PM To: Multiple recipients of list ORACLE-L OT On Mon, 15 Jul 2002, Johnson, Michael wrote: Everyone should have been smart enough to sell stocks and put their money into cash or better yet short stocks when it was very clear that in the Fall of 2000 after the initial March 2000 sell off that we were going into a prolonged Bear market. It's always easy to play monday morning quarterback. I assume you are now retired because you made so much money from the very clear and prolonged Bear market you forcasted in Fall 2000. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: sequential reads/scattered reads
Are you sure that these are the ones that are slowing the system down ? Did you try to find out at what time of the day the system is really slow and execute your wait/event queries at that time ? Did you get a slice of 10046 data when the application was actually running slow ?You could be looking at waits which are not really the problem. FWIW ! Mike -Original Message- Sent: Thursday, July 11, 2002 8:26 AM To: Multiple recipients of list ORACLE-L Cary Millsap, i selected the top 25 SQL statements in the system over various periods . all are SELECT statements only waiting for reads. querying v$session_wait also shows more than 10 records each for DB FILE SCATTERED READS and DB FILE SEQUENTIAL READS.does not it mean that it's b'coz of I/O contention ? i am not sure . this is on RAID set up. will not seperating my tables and indexes to seperate tablespace help me ? guide me Cary.it's really urgent. i am novice DBA. On Thu, 11 Jul 2002 Cary Millsap wrote : Moving stuff around won't reduce I/O traffic, it'll just spread it around across different devices. Don't focus on how much I/O your system does, focus on how much *time* an important process spends *doing* I/O. It's Amdahl's Law: If you improve I/O latencies by 50%, but your program spends only 2% of its response time doing I/O, then your program's response time will improve by only 1%. Cary Millsap Hotsos Enterprises, Ltd. _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
It is my understanding that it currently takes 1.5 to 2 years to get this clearence mainly due to events of 9/11. So, if you have one, it behooves you to keep it current. They used to estimate these clearences were worth an additional $10K a year for salary. Im thinking at least $25K now.Alot of my friends that have these clearances , whether they be DBAs, programmers, Sys. Ads. etc, have standing offers for work in many places around the world due to the fact these clearances are very hard to get. Also, the companies will not foot the bill for this delay. The government usually has to approve all hires where the individual is not cleared. From what I have seen the government is in no mood to do this as of late. FWIW ! Mike -Original Message- Sent: Wednesday, June 26, 2002 4:54 PM To: Multiple recipients of list ORACLE-L I don't understand the large number of positions coming out that require a CURRENT Secret or Top Secret clearance. How can all these positions be filled unless these company/entities start footing the bill for people getting the clearances?!? Johnson, Michael wrote: That is not my understanding. FWIW. Mike -Original Message- Sent: Wednesday, June 26, 2002 1:35 PM To: Multiple recipients of list ORACLE-L Actually no one who has been holds any SCI tickets can admit to doing so :) One can say you have been the subject of a Special Backgroud Investigation, and Extensive Background Investigation, a Full Field Investigation even though 99. times out of 100 these investigations are done for just such access. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 26, 2002 9:24 AM To: Multiple recipients of list ORACLE-L I suspect that this position will be at Wright-Patterson Air Force base. OraStaff wrote: Position: Oracle DBA with Top Secret SCI Clearance (Please do not send your resume unless you have the required -- Jesse W. Asher They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety. - Benjamin Franklin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse W. Asher INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
In some cases this is true. It all depends on the government agency. FWIW. Mike -Original Message- Sent: Thursday, June 27, 2002 8:18 AM To: Multiple recipients of list ORACLE-L I think that test includes a polygraph exam. :-| -Original Message- Sent: Wednesday, June 26, 2002 11:16 PM To: Multiple recipients of list ORACLE-L That's what I was wondering too! Are there any Cram books for this one? Wonder if Oracle would offer that test too... some day ;-)) After OCM, they may need something new :)) -Original Message- Sent: Wednesday, June 26, 2002 10:34 PM To: Multiple recipients of list ORACLE-L Where can I take the Top Secret clearance certification exam At 03:53 PM 6/26/2002 -0800, you wrote: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
If a company or a civilian govt agency wants to hire you and put you in for one then it will happen, but like the earlier note said, you have to have a need to have one. FWIW ! Mike -Original Message- Sent: Thursday, June 27, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Yes to both? Yes to the 1st? Yes to the 2nd? Yes to neither? It wasn't a Yes/No Question - it was a X or Y question. Let me ask a more simple question then - Can a civilian pursue a clearance? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Yes. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Michael Cupp [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:12 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. But can they be pursued by a civilian, or do they have to be gov't sponsored? -Original Message- From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. If your background is clean these clearances should be no big deal. When I was driving submarines for a living I had TS, Crypto and COMSUBPAC Special Intelligence clearances. SI is above TS. Ken Janusz, CPIM Former U.S.N. Submariner - Original Message - From: Khedr, Waleed mailto:[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Thursday, June 27, 2002 2:30 PM Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. Another certification! -Original Message- From: Jesse W. Asher [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. Very good question! I've wondered the same thing myself! Michael Cupp wrote: How would one begin the process of getting one? Or does it have to be government sponsored? -Original Message- Sent: Thursday, June 27, 2002 2:35 PM To: Multiple recipients of list ORACLE-L It is my understanding that it currently takes 1.5 to 2 years to get this clearence mainly due to events of 9/11. So, if you have one, it behooves you to keep it current. They used to estimate these clearences were worth an additional $10K a year for salary. Im thinking at least $25K now.Alot of my friends that have these clearances , whether they be DBAs, programmers, Sys. Ads. etc, have standing offers for work in many places around the world due to the fact these clearances are very hard to get. Also, the companies will not foot the bill for this delay. The government usually has to approve all hires where the individual is not cleared. From what I have seen the government is in no mood to do this as of late. FWIW ! Mike -Original Message- Sent: Wednesday, June 26, 2002 4:54 PM To: Multiple recipients of list ORACLE-L I don't understand the large number of positions coming out that require a CURRENT Secret or Top Secret clearance. How can all these positions be filled unless these company/entities start footing the bill for people getting the clearances?!? Johnson, Michael wrote: That is not my understanding. FWIW. Mike -Original Message- Sent
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
I would suggest we take this thread off line as it really is irrelevant with what this list is for. Jared, correct me if Im wrong. Mike -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Get a job requiring the clearance, either as a direct government employee or as a contractor. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. For the curious around, does anyone know how one would do such a thing? RF Robert G. Freeman - Oracle8i OCP Oracle Database Architect CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:51 PM To: Multiple recipients of list ORACLE-L Don't. Its not worth the hassle. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Michael Cupp [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 1:53 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio.. How would one begin the process of getting one? Or does it have to be government sponsored? -Original Message- Sent: Thursday, June 27, 2002 2:35 PM To: Multiple recipients of list ORACLE-L It is my understanding that it currently takes 1.5 to 2 years to get this clearence mainly due to events of 9/11. So, if you have one, it behooves you to keep it current. They used to estimate these clearences were worth an additional $10K a year for salary. Im thinking at least $25K now.Alot of my friends that have these clearances , whether they be DBAs, programmers, Sys. Ads. etc, have standing offers for work in many places around the world due to the fact these clearances are very hard to get. Also, the companies will not foot the bill for this delay. The government usually has to approve all hires where the individual is not cleared. From what I have seen the government is in no mood to do this as of late. FWIW ! Mike -Original Message- Sent: Wednesday, June 26, 2002 4:54 PM To: Multiple recipients of list ORACLE-L I don't understand the large number of positions coming out that require a CURRENT Secret or Top Secret clearance. How can all these positions be filled unless these company/entities start footing the bill for people getting the clearances?!? Johnson, Michael wrote: That is not my understanding. FWIW. Mike -Original Message- Sent: Wednesday, June 26, 2002 1:35 PM To: Multiple recipients of list ORACLE-L Actually no one who has been holds any SCI tickets can admit to doing so :) One can say you have been the subject of a Special Backgroud Investigation, and Extensive Background Investigation, a Full Field Investigation even though 99. times out of 100 these investigations are done for just such access. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 26, 2002 9:24 AM To: Multiple recipients of list ORACLE-L I suspect that this position will be at Wright-Patterson Air Force base. OraStaff wrote: Position: Oracle DBA with Top Secret SCI Clearance (Please do not send your resume unless you have the required -- Jesse W. Asher They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety. - Benjamin Franklin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse W. Asher INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED
RE: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..
That is not my understanding. FWIW. Mike -Original Message- Sent: Wednesday, June 26, 2002 1:35 PM To: Multiple recipients of list ORACLE-L Actually no one who has been holds any SCI tickets can admit to doing so :) One can say you have been the subject of a Special Backgroud Investigation, and Extensive Background Investigation, a Full Field Investigation even though 99. times out of 100 these investigations are done for just such access. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 26, 2002 9:24 AM To: Multiple recipients of list ORACLE-L I suspect that this position will be at Wright-Patterson Air Force base. OraStaff wrote: Position: Oracle DBA with Top Secret SCI Clearance (Please do not send your resume unless you have the required -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Performance Tuning steps
For a 24 X 7 system I would incorporate a hot backup strategy which can be executed without taking the system down and allows for a point in time recovery. There are many scripts floating aroundyou could "borrow" to set this up. Your performance issue is going to require some time to understand and solve. it cannot be answered in a paragraph. Consider buying Gaja Krishna Vaidyanatha and Kirti Deshpande's book "Oracle Performance Tuning 101" as it has been a big help to me. Other things you might find helpful would be www.hotsos.com which goes into great detail on the 10046 event trace and they also have an excellent clinic I just went too. Good Luck and Peace ! Mike -Original Message-From: Chetan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 26, 2002 3:39 AMTo: Multiple recipients of list ORACLE-LSubject: Oracle Performance Tuning steps Hi guys , Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap. Here is some information about the db. Database size- 20GB Optimizer - CHOOSE Disk Structure - RAID 1+0 No. of processors - 4 Block Size - 8K Archivelog mode : ARCHIVELOG Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody workedwith STATSPACK before ? Can anybody tell me what shouldaccurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries. Also can someone tell me the ideal backup strategy for this databaseconsidering the fact thatit's a 24x7 system. Thanks in advance . Chetan Chindarkar Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup
RE: MTS performance is too bad.
Everything I have seen from experience tells me to avoid using MTS if you can ! FWIW. Mike -Original Message- Sent: Wednesday, June 26, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Change back to dedicated servers. Jared Bunyamin Karadeniz [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/26/2002 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:MTS performance is too bad. I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Training courses
Rachel, Yes , I worked at JPL in Pasadena California for 8 years and we had all these PHDs running around. Very smart people who could never apply their knowledge and produce work. They would let you know how smart they were though. Since I have not taken every oracle class it was unfair of me to generalize the way I did. Mike -Original Message- Sent: Thursday, June 20, 2002 5:58 PM To: Multiple recipients of list ORACLE-L heck, anything (presentations, classes, books) are all good or bad depending on the knowledge of the person presenting the information and their ability to teach sometimes the ability to teach is more important than how much they know. I've known really smart people who can't make anyone understand what they know --- Johnson, Michael [EMAIL PROTECTED] wrote: alright ... Ill buy that explanation. -Original Message- Sent: Thursday, June 20, 2002 1:15 PM To: Multiple recipients of list ORACLE-L not totally worthless, but the value of the class is directly related to the quality of the instructor. I have had the good fortune to take classes with several of the best of Oracle instructors. I have also had the misfortune to take classes with some of the less best --- Johnson, Michael [EMAIL PROTECTED] wrote: I would second these selections below Stay away for the Oracle provided training, It is worthless. fwiw ! Peace and Love Mike -Original Message- Sent: Thursday, June 20, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Check on www.orapub.com or www.hotsos.com --- Schauss, Peter [EMAIL PROTECTED] a écrit : My manager has told me that he has budget to send me for a training course of my choice, 4 to 5 days, preferably in the local area (Long Island or NYC). A bit of background on myself: Current position: Oracle DBA, right now, mostly supporting development, including data modeling. 20+ years total experience in software development, system administration (mostly UNIX), Database Administration (including about 8 years work with Oracle 7.0.x to 8.1.7). My DBA work has included both development and production, mostly on small to medium sized databases. Programming languages: C, C++, Java I have gained most of my knowledge of Oracle on the job, from reading documentation and books like Rachel's _DBA 101_, from attending user's group meetings, or from reading this list. What course would you suggest? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: How to remove Lock on a Table
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Free buffer requested
also, just a curious question as to why you sized your shared pool at 1GB ? -Original Message- Sent: Tuesday, June 18, 2002 6:33 PM To: Multiple recipients of list ORACLE-L Hi list, Scenario Sun 880 Solaris 8, Oracle 8.1.7.3, 8GB Ram, 4 processors Redo logs 200MB size 4 groups in 1 disk DBWriter = 2 log buffer 200 BM Shared Pool 1 GB db block buffers 100,000 db block size 8K I started a process and checked the V$sysstat and get those values are extremely high free buffer requested 28938, enqueue requests 25035, redo writer latching time 0 Data 1 volume stripe of 2 disk Index 1 volume stripe of 2 disk -- differents RBS 1 disk apart Temp 1 disk apart What parameter should I check ? TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERFORMANCE ISSUE
Seema, So what does that tell you about how useful database ratios are in diagnosing your problem ? I would suggest you check out some sites about detecting waits in your system. The information given here gives no one a starting point to help you diagnose the problem. Consider buying Gaja Krishna Vaidyanatha and Kirti Deshpande's book Oracle Performance Tuning 101 as it has been a big help to me. Other things you might find helpful would be www.hotsos.com which goes into great detail on the 10046 event trace and they also have an excellent clinic I just went too. Good Luck and Peace ! Mike -Original Message- Sent: Thursday, June 20, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Hi I am having some problem regarding performance.The performance problem get solved after reboot.Whenever the db unix server keep running more than 72 hrs the performance looks like slow.one of cause I found some memory leakage.But the box are having 2 instances and for another instance performance is looking good.If I see all database ratios are looking great.What could be reason? thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: order by versus order by desc problem ..... probably a simple
You are exactly correct ... it is a bug in an earlier version on Oracle we have on one of our servers See Note:1036394.6 on metalink ! thank you ! Mike -Original Message- Sent: Thursday, June 20, 2002 11:51 AM To: Multiple recipients of list ORACLE-L simple Looks like a bug! -Original Message- Sent: Thursday, June 20, 2002 2:17 PM To: Multiple recipients of list ORACLE-L pro select distinct col1 from table_name where col1 like 'ABC_' and col2 0 order by col1; returns 38 rows .. but select distinct col1 from table_name where col1 like 'ABC_' and col2 0 order by col1 desc; returns 0 rows just by putting in the descending clause anybody seen this happen before new index has been added on the table, but nothing else is new. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Training courses
I would second these selections below Stay away for the Oracle provided training, It is worthless. fwiw ! Peace and Love Mike -Original Message- Sent: Thursday, June 20, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Check on www.orapub.com or www.hotsos.com --- Schauss, Peter [EMAIL PROTECTED] a écrit : My manager has told me that he has budget to send me for a training course of my choice, 4 to 5 days, preferably in the local area (Long Island or NYC). A bit of background on myself: Current position: Oracle DBA, right now, mostly supporting development, including data modeling. 20+ years total experience in software development, system administration (mostly UNIX), Database Administration (including about 8 years work with Oracle 7.0.x to 8.1.7). My DBA work has included both development and production, mostly on small to medium sized databases. Programming languages: C, C++, Java I have gained most of my knowledge of Oracle on the job, from reading documentation and books like Rachel's _DBA 101_, from attending user's group meetings, or from reading this list. What course would you suggest? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Training courses
alright ... Ill buy that explanation. -Original Message- Sent: Thursday, June 20, 2002 1:15 PM To: Multiple recipients of list ORACLE-L not totally worthless, but the value of the class is directly related to the quality of the instructor. I have had the good fortune to take classes with several of the best of Oracle instructors. I have also had the misfortune to take classes with some of the less best --- Johnson, Michael [EMAIL PROTECTED] wrote: I would second these selections below Stay away for the Oracle provided training, It is worthless. fwiw ! Peace and Love Mike -Original Message- Sent: Thursday, June 20, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Check on www.orapub.com or www.hotsos.com --- Schauss, Peter [EMAIL PROTECTED] a écrit : My manager has told me that he has budget to send me for a training course of my choice, 4 to 5 days, preferably in the local area (Long Island or NYC). A bit of background on myself: Current position: Oracle DBA, right now, mostly supporting development, including data modeling. 20+ years total experience in software development, system administration (mostly UNIX), Database Administration (including about 8 years work with Oracle 7.0.x to 8.1.7). My DBA work has included both development and production, mostly on small to medium sized databases. Programming languages: C, C++, Java I have gained most of my knowledge of Oracle on the job, from reading documentation and books like Rachel's _DBA 101_, from attending user's group meetings, or from reading this list. What course would you suggest? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET
RE: autostart 8.1.7 intelligent agent on Solaris
the latter -Original Message- Sent: Tuesday, June 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L trying to set up the intelligent agent to autostart on unix . . . if it's already running and I save the listener config (lsnrctl save_config) does that save the agent config, too? or do I have to manually put the line lsnrctl dbsnmp_start in my boot rc script? thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Free Buffer Waits
Obviously, you have something in your system competing for resources. There are multiple sessions requesting the same block. Everything seemed to run fine and now all of a sudden things dont work , but nothing new has been introduced into the system. How can this be ?Perhaps you have other problems that have been created in the system in the last few days that wont be seen until your backups are run. It appears you are going to have to reproduce what you see and log certain events while the bottleneck is happening. I would set an event 10046 and comb through there ... I would also try to look at v$session_wait which will show the file#, clock# and id ( where id represents the status of the buffer busy wait event ). I would also buy Gaja Krishna Vaidyanatha and Kirti Deshpande's book Oracle Performance Tuning 101 as it has been a big help to me. Other things you might find helpful would be www.hotsos.com which goes into great detail on the 10046 event trace and they also have an excellent clinic I just went too. Good Luck and Peace ! Mike -Original Message- Sent: Tuesday, June 18, 2002 12:43 AM To: Multiple recipients of list ORACLE-L Hi, I came in early morning and saw the batch job had been taking forever. I immediately checked v$system_event (the job that took so long had just finished so session_wait was no longer option). Since we shutdown and backup our database every night the figure presented here was basically since the batch job started because that starts right after startup. So basically the system (with no other logins as per listener.ora file). had been waiting about 6-7 hours since startup on free buffer waits. We did not introduce any other jobs to the batch and it has been running normally since that one time strange behaviour. No logging of any hardware/software error was found on UNIX nor Symmetrix nor Oracle so we have given up for now. Jack Johnson, Michael Michael.Johnson@oln-aTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fmc.af.mil cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Free Buffer Waits [EMAIL PROTECTED] 17-06-2002 19:28 Please respond to ORACLE-L Just a couple questions . Did you introduce any new batch jobs into the system or any other interactive jobs that may have been running at the same time ? How do you know that the Buffer Wait event was the top wait event and how did you see this ? eg. are you taking a time slice and loggin it at certain time into a 10046 trace ,etc. Mike -Original Message- Sent: Thursday, June 13, 2002 2:04 AM To: Multiple recipients of list ORACLE-L Hi All, We have a production database that has a batch job running on it for months now. Last night one part of the batch job that normally takes between 20-30 minutes took well over 6 hours. The only difference I can see between today other days is that the Free Buffer Wait event was the top wait event, which it not normally is (not even top 10) This database goes down every night for backup and this is the timings I got. Total waits:22055 Total timeouts:22052 Time waited: 2225285 (is this ms or cs?) Avg.wait:100.8971 This whole thing puzzles me a bit since nothing changed to the database and nothing was in the Alert log. Also system was virtually idle during the 6 hours (no activity according to UNIX boys) I was sound asleep when this happened so I don't have much more than this info. Can anybody explain why this could have happened or point me to some documents that can. Standard answer you'll find that your DBWR can't keep up, but I have 4 of them and the sytem was idle. THX === 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
RE: ORCL stock is down...
I invest in stocks all the time .. long and short. I would not touch Oracle stock with a 10 foot pole. The company has major problems , excesses that need to be worked off and cleaned out, a business plan that is outdated, and MSFT and IBM are now starting to cut into Oracle's market share with DB2 and SQL*Server.All of these tech and biotech companies probably have another 3 to 9 months before their stock prices bottom and another 1 to 2 years before you see them rise again.I have been shorting stocks like ORCL CSCO JDSU JNPR and all the rest of them for a couple years now and the pay off has been good. I you want to buy a stock, stick with stocks that have good fundamentals in a bull market. At the present time there are not to many of those and we are NOT in a bull market. Save your money.\ Mike -Original Message- Sent: Wednesday, May 01, 2002 11:34 AM To: Multiple recipients of list ORACLE-L OFF TOPIC... Oracle stock is down 11% today. What gives? Over-reaction to executive departures and decreased revenues? Is it a good time to invest? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Extremely slow query
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Diagnose Slow System
Title: RE: Diagnose Slow System You need to take a slice of the database when the performance degrades. Capturing statistics at the end of the day before the database goes down is meaningless. Consider setting up a 10046 event trace and find out what session and what wait eventis boggin down through this information. Consider buying Kirti and Gaja's book on Oracle Performance Tuning 101. Also, www.hotsos.com just showed me some techniques on 10046 trace data that I think you would find interesting. To be sure , there is alot of information that must be understood up front. Not the easiest thing to do. To say you think you have a network problem is like saying I need to increase my hit ratio so I will increase my performance. It is based on meaningless mumbo jumbo. Not a very good feeeling when one rally does not understand what is going on behind the scenes. Not a simple answer to give to you here. Mike -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 11, 2002 12:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Diagnose Slow System I apologize if I missed the final post. Did you discovered the cause of the problem? Tony Aponte -Original Message- From: Baker, Barbara [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 6:13 PM To: Multiple recipients of list ORACLE-L Subject: Diagnose Slow System List: We've been fighting problems for several days. I've sort of overwhelmed myself with data, but I don't know what any of it means. Solaris 2.6, Oracle 8.0.5, MTS Users complain of extreme slowness. No errors in alert, no trace files generated. Database is bounced every day. I capture wait statistics each day before the database goes down. The statistics from v$system_event for enqueue waits has gone up considerably since the problems started last Wednesday. But when I look at v$lock (I'm using Steve Adams' enqueue_locks.sql scripts), nothing pops up. Any ideas where I should start looking? I would appreciate any help. (I really believe this is a connectivity (networking) issue, but don't know how to confirm this) Thanks! Barb (accumulted since last night at 11:00 pm) EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT --- --- -- --- latch free 814316 4064 106360 .130612686 enqueue 147 26 12033 81.8571429 free buffer waits 4 0 23 5.75 buffer busy waits 2959 0 567 .19161879 log file parallel write 68177 0 78788 1.155639 log file sync 66683 1 77517 1.16247019 db file sequential read 1385334 0 144617 .104391432 db file scattered read 1113301 0 142545 .12803815 (The info captured below is unusual. running this repeatedly normally shows nothing except smon TS resource wait) RESOURCE NSID SID HOLDING WANTING SECONDS - --- --- -- RT-1-0 4 LGWR X 0 TM-1949-0 46 46 SX 0 TM-1999-0 423 423 SX 4 46 46 SX 0 TM-2014-0 46 46 SX 0 TM-2106-0 46 46 SX 0 TM-2218-0 46 46 SX 0 TM-2270-0 423 423 SX 4 TM-2275-0 423 423 SX 4 46 46 SX 0 TS-1-8388610 6 SMON SX 48069 TX-1114154-43605 46 46 X 0 TX-852064-43554 423 423 X 4 (Below is also unusual. Running this repeatedly normally returns no rows) Sess Ser Wait Wait Time W'd So ID No Event State W'd (ms) Far (ms) P1 P2 P3 -- -- -- -- 16 19 latch free WAITING 0 0 2147519876 59 0 92 38 latch free WAITED S -1 0 2147519876 59 0 HORT TIM E 565 31 latch free WAITING 0 0 2147519876 59 0 636 11604 latch free WAITED S -1 0 2147519876 59 0 HORT TIM E -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Simple Oracle database question.
If you are on Unix make sure your ORACLE_SID environment variable is set to the database you want to use. -Original Message-From: Meomeo Nguyen [mailto:[EMAIL PROTECTED]]Sent: Friday, June 07, 2002 3:28 PMTo: Multiple recipients of list ORACLE-LSubject: Simple Oracle database question. Hi, Currently I have only one database running on a single host. Supposedly, I need to create multiple databases on the same host. My question is can I open two databases at the same time? I have not done it before, so just wanted to make sure that I can work on two databases all at once. Thanks in advance Trang Do You Yahoo!?Sign-up for Video Highlights of 2002 FIFA World Cup
RE: Datafile Corruption ........... or Not
There is also a Pro*C and PL/SQL routine to fix corrupted block problems if you do not have backups. Peace ! Mike -Original Message- Sent: Tuesday, May 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Hi, Find the corrupted object by the following statement: Select segment_name, segment_type from dba_extents where file_id=your_file# and your_block# between block_id and block_id + blocks -1 - If it's index, recreate it. - If not, recover the datafile - if no backup, tell us regards... Kevin Lange wrote: Hey gang; I have an 8.0.5.0 database running on a Solaris platform. The developer is running a simple query which returns the error ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 7, block # 191659) ORA-01110: data file 7: '/u08/oradata/TTCT/dynamici01.dbf' So I run dbverify (dbv) against the file and it says all is OK. $ dbv file=dynamici01.dbf DBVERIFY: Release 8.0.5.0.0 - Production on Tue May 28 13:2:7 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = dynamici01.dbf DBVERIFY - Verification complete Total Pages Examined : 409600 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 158376 Total Pages Failing (Index): 0 Total Pages Empty: 0 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Does anyone have any suggestions about this other than rebuilding the database (it is a clone of our production ... it will just set the developer back if we have to clone it) ? Thanks Kevin -- 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Datafile Corruption ........... or Not
its on Metalink search on the error number or on corrupted block. -Original Message- Sent: Wednesday, May 29, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Hi, very interesting. what is the URL for these utilities ? Johnson, Michael wrote: There is also a Pro*C and PL/SQL routine to fix corrupted block problems if you do not have backups. Peace ! Mike -Original Message- Sent: Tuesday, May 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Hi, Find the corrupted object by the following statement: Select segment_name, segment_type from dba_extents where file_id=your_file# and your_block# between block_id and block_id + blocks -1 - If it's index, recreate it. - If not, recover the datafile - if no backup, tell us regards... Kevin Lange wrote: Hey gang; I have an 8.0.5.0 database running on a Solaris platform. The developer is running a simple query which returns the error ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 7, block # 191659) ORA-01110: data file 7: '/u08/oradata/TTCT/dynamici01.dbf' So I run dbverify (dbv) against the file and it says all is OK. $ dbv file=dynamici01.dbf DBVERIFY: Release 8.0.5.0.0 - Production on Tue May 28 13:2:7 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = dynamici01.dbf DBVERIFY - Verification complete Total Pages Examined : 409600 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 158376 Total Pages Failing (Index): 0 Total Pages Empty: 0 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Does anyone have any suggestions about this other than rebuilding the database (it is a clone of our production ... it will just set the developer back if we have to clone it) ? Thanks Kevin -- 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
RE: SQL Question
Kirti, my first thought and fwiw would be to write a PL/SQL routine. Mike -Original Message- Sent: Wednesday, May 29, 2002 11:22 AM To: Multiple recipients of list ORACLE-L I need some help... The database table has following structure. commision_id number com_text_msg varchar2(500) The second column contains data fields that are delimited by ~ and delimiter's position varies. But there are only eight data fields in the column. Is there a way in SQL, other than substr/instr combinations, to extract each data field to report? Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
The results are in ... re: not thinking on a deserted nude beach
I ran the query over again and here are the results. It appears the anti join solution is the one. suit yourself. I like Jareds / Larrys solution note : Not Exists produced the same result as Not In as the index remained suppressed ! Original Query Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=15 Card=106 Bytes=19 398) 10 FILTER 21 TABLE ACCESS (FULL) OF 'table2' (Cost=15 Card=106 Bytes=19398) 31 INDEX (RANGE SCAN) OF 'table1_PK' (UNIQUE) ( Cost=2 Card=2 Bytes=18) Statistics -- 0 recursive calls 2 db block gets 6468 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2498 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1410 rows processed ** the Anti Join (+) solution Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=50 Card=2739 Bytes=5 50539) 10 FILTER 21 HASH JOIN (OUTER) 32 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Card=2 103 Bytes=384849) 42 TABLE ACCESS (FULL) OF 'Table1' (Cost=14 C ard=3361 Bytes=60498) Statistics -- 0 recursive calls 4 db block gets 450 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2489 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1410 rows processed the inline view using minus solution Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=173 Card=7037 Bytes= 1351104) 10 HASH JOIN (Cost=173 Card=7037 Bytes=1351104) 21 VIEW (Cost=145 Card=5464 Bytes=49176) 32 MINUS 43 SORT (UNIQUE) 54 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Ca rd=2103 Bytes=18927) 63 SORT (UNIQUE) 76 TABLE ACCESS (FULL) OF 'Table1' (Cost= 14 Card=3361 Bytes=30249) 81 TABLE ACCESS (FULL) OF 'Table2' (Cost=15 Card=210 3 Bytes=384849) Statistics -- 0 recursive calls 6 db block gets 779 consistent gets 0 physical reads 0 redo size 322140 bytes sent via SQL*Net to client 2389 bytes received via SQL*Net from client 97 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1410 rows processed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ANY IDEA?
check all the parameters that make up your SGA not just the shared_pool, eg. block size, block_buffers ,etc. If you need more O/S allocated memory , which is what it appears to be, talk to the SA and then will adjust otherwise you are going to have to reduce some things. Peace ! Mike -Original Message- Sent: Monday, May 20, 2002 3:38 PM To: Multiple recipients of list ORACLE-L Hello List, I got the following error today(Oracle 8.1.7.0 Sun Solaris) ORA-04031: unable to allocate 4200 bytes of shared memory (shared pool,unknown object,sga heap,state objects) At the moment my shared_pool size is 30M Thanks for your help Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Do you ever have days where you dont want to think ?
I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue. I have a query that looks like this ... select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in ( select b.n1 from b ); there is a primary key index on b.n1 there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1 the query shows that the index is being used on table b, but no indexes are being used on table a. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody get a 1630 error when trying to add an index ?
I have been trying to add an index to a index tablespace and I keep getting a 1630 error. I have 500 extents , but it says the max extents are only 121 and they are filling up. Maybe my dendrites have been temporarily fried and it is something simple. Thanks for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anybody get a 1630 error when trying to add an index ?
Everybody ... thanks for your help on this. What happened is that I had increased the extents from 121 to 500, but because there was an existing session that had the object I had to wait for that session to end before the 500 extents were noticed. So, I did everything right, I just had to wait. Thanks for all you time on this. Peace ! Mike T -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORCL stock is down...
i play the stock market all the time investing in the big cap techs (ie SUNW ORCL MSFT IBM NTAP VRST etc) the worst long play (buying a stock) one can make expect these stocks to go down or sideways for another year. Oracle has a lot of overhead and declining revenues and earnings. It is also has a high valuation right now. So stay away from it ... Consider a stock like CCRN which I bot today. Mike -Original Message- Sent: Wednesday, May 01, 2002 11:34 AM To: Multiple recipients of list ORACLE-L OFF TOPIC... Oracle stock is down 11% today. What gives? Over-reaction to executive departures and decreased revenues? Is it a good time to invest? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Financials Sys Admin. Needed in South Carolina
SQL*Plus and Reports 2.5. Experience upgrading to ORACLE 11i is desirable. Will also manage outside contractors/consultants for technical ORACLE projects. -U.S. citizens and candidates from SC or surrounding states preferred. The base salary range depends on experience...range is 65K-75K + bonus For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Spartanburg/Fin. Sys Admin/David ph: 1-800 -549-8502 All Submissions are handled in confidence. *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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Curious question about flushing the Pool
I see a couple of folks who want to know how to flush the pool or are looking for a script to do it automatically. Shouldn't we be asking what is causing the behavior that got us to this quandry in the first place ? Just a stupid question .. I know ! Peace ! Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hello Everybody ! I have found the List and looking foward to it
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).