OCP question
I passed the Intro to SQL and PL/SQL. It says on OTN I can take either that or the SQL test for either the DBA or Developer exam. Can I use it for both certifications? Also, anyone who took the developer test. Im looking at the PL/SQL test. I have an older book and it discusses PL/SQL Builder, which is an antiquated tool and no longer exists in 9i. Didnt want to bother playing around with it. Do I need to for the test? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Anyone looking fora Developer/DBA in Wash DC area?
clearance takes a long time to get. Ran into this before. I had to sign a bondage agreement before they do the background check. Cant stay unemployed for that long and its unethical for me to take a job with another company and quit on them. How are the bondage agreements with CSC? Everyone who wanted me to get one requires them. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 2:48 PM Send resume as word attachment to [EMAIL PROTECTED] I can't guarantee anything and you will have to be clearable but there's sure a lot of work going on here. rgaffuri @cox.netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Anyone looking fora Developer/DBA in Wash DC area? 03/07/2003 01:09 PM Please respond to ORACLE-L Yes, I know this isnt a job board and this is the one and only time Ill do it. The market is tight. My current contract is up in two weeks. Im a US Citizen(no clearance) and Im more developer than DBA. I have a good track record with strong references. Anyone know of anything? Preferably something long term? I want to get out of contracting. My only hang-up is that Im working on a Masters so travel out of the area would be limited. As I said this is the one and only time Ill send this. I hope you all understand. The first day hints are gone, I will change my career! I do not think it will go away, since Oracle itself uses them to control the way PQ slaves and other background processes work. Also stored outlines is part of it. Regards, Waleed -Original Message- From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Oracle position on hints Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Anyone looking fora Developer/DBA in Wash DC area?
sorry about that one... didnt realize it went to you guys. :( - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 3:43 PM clearance takes a long time to get. Ran into this before. I had to sign a bondage agreement before they do the background check. Cant stay unemployed for that long and its unethical for me to take a job with another company and quit on them. How are the bondage agreements with CSC? Everyone who wanted me to get one requires them. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 2:48 PM Send resume as word attachment to [EMAIL PROTECTED] I can't guarantee anything and you will have to be clearable but there's sure a lot of work going on here. rgaffuri @cox.netTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: rootcc: Subject: Anyone looking fora Developer/DBA in Wash DC area? 03/07/2003 01:09 PM Please respond to ORACLE-L Yes, I know this isnt a job board and this is the one and only time Ill do it. The market is tight. My current contract is up in two weeks. Im a US Citizen(no clearance) and Im more developer than DBA. I have a good track record with strong references. Anyone know of anything? Preferably something long term? I want to get out of contracting. My only hang-up is that Im working on a Masters so travel out of the area would be limited. As I said this is the one and only time Ill send this. I hope you all understand. The first day hints are gone, I will change my career! I do not think it will go away, since Oracle itself uses them to control the way PQ slaves and other background processes work. Also stored outlines is part of it. Regards, Waleed -Original Message- From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Oracle position on hints Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Ryan 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).
cant connect oracle after developer 9i instll
1.I installed Oracle 9i on a Windows XP platform. Had it create a default database. Successfully logged in. 2. I then installed the 9i developer suite. I am now getting the follow error in my trace file: Fatal NI connect error 12645, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleryantest)(A RGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID= ryantest)(CID=(PROGRAM=C:\ora9i\bin\oradim.exe)(HOST=RYAN-2LE36OFJCE)(USER=S YSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 9.0.1.3.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.3.0 - Production Time: 08-MAR-2003 21:32:28 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12645 TNS-12645: Parameter does not exist. ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Here is my sqlnet.ora file: # SQLNET.ORA Network Configuration File: C:\ora9i\network\admin\sqlnet.ora # Generated by Oracle configuration tools. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) NAME.DEFAULT_ZONE = world NAMES.DEFAULT_DOMAIN = world SQLNET.EXPIRE_TIME = 15 SQLNET.ENCRYPTION_CLIENT = requested If I take out: SQLNET.ENCRYPTION_CLIENT = requested from SQLNET, I get the following error: ORA-01034: Oracle Not available ORA-27101: Shared Memory Realm not avaible I have checked services and my instance is started, along with my listener. I can recognize it with the Administrator tool GUI. My init.ora is just the default created by Oracle. Anyone have any ideas? It worked before I installed Developer? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).
cant connect oracle after developer 9i instll
Please ignore. had to connect as SYSDBA to get it started. No idea, why the windows services couldnt start it though... this was really annoying. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: UTL_FILE
yes, bufferedReader and printWriter should do it. they work alot like UTL_FILE. there is sample code for these at sun.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:28 PM I think there are java classes which can write across the network, but I'm unsure of how those would be implemented, especially in Oracle. You might try posting a question about this at devtrends.oracle.com or do a web search. [EMAIL PROTECTED] 3/11 2:25p Eric Utl_file only write to the database server. You can use Dbms_Output and spool the results to the local machine. Or 'select' the data to be spooled out. Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 11, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Any help would be appreciated... Is it possible to write a file to the local OS if the database is remote? Should I be using UTL_FILE or another package? I'm attempting to write to a file on my local OS (Windows NT 4.0). The database version is 9i r2 and resides on a HP-UX box. I've created a directory object as follows: CREATE OR REPLACE DIRECTORY utl_file_dir AS 'c:\'; The output from the SQL statement: select * from all_directories; follows: OWNER DIRECTORY_NAME DIRECTORY_PATH - -- SYS UTL_FILE_DIR c:\ File handle code from my procedure follows: l_FileHandle := UTL_FILE.FOPEN('UTL_FILE_DIR','role.txt','r'); When executing the associated procedure I get the following error: ORA-29280: invalid directory path Thanks, Eric Harrington -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Darrell Landrum 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Locally Managed Tablespaces
so for normal business you should not use autoextend? You should monitor it yourself? What are some tips for monitoring the database to see if you need to extend your tablespace manually? Do you use DBMS_ALERT and read the v$ views and then broadcast a message if you need to extend a tablespace? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 21, 2003 6:38 PM FWIW I've come to think of autoextend as a valuable ally in certain cases. When loading data it's nice to enable autoextend when you don't know how large you really need to have the database files. Create several and set autoextend on, being sure that if all were to fill up, it won't fill up the drive, as that can cause some sticky problems. When upgrading a database, I may set autoextend on on the SYSTEM datafiles so they don't run out. Along the same lines, I set maxextents to unlimited and monitor the number of extents so that it is not unreasonable. Better to have a couple thousand extents during a data load that someone 'forgot' to inform you about than to have the job die in the middle of the night. I think my 'reasonable' # of extents must be higher than yours Jacques. :) Jared Jacques Kilchoer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/21/2003 11:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: Locally Managed Tablespaces -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. The current thinking is that uniform extents are a good thing. So in 7.3, try and manually enforce uniform extents: initial = next for all clusters/tables/indexes in the same tablespace pctincrease=0 for all objects These should of course be the settings for the DEFAULT STORAGE clause on the create tablespace. Then to create a cluster/table/index you can (should?) use tablespace defaults and skip the storage parameter on the CREATE cluster/table/index statement. My personal opinion: always use maxextents unlimited but put your object in a tablespace where the values of INITIAL and NEXT will prevent the object from having more than 1000 extents. Autoextend datafiles: my personal opinion is don't use those, because you should have an idea of how and when your database is going to grow, and if you need more space it's nice to be aware of it. Of course this means the risk of failure when a datafile is full, but the same thing can happen with autoextend when the disk gets full. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Locally Managed Tablespaces
thanks for all the responses to such a basic question. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 22, 2003 6:03 AM The other pctincrease option that preserves a multiple of the extent size is 100. Similiar to LMT autoallocate extent sizes always being a multiple of 64K. Have Fun :) Rachel Carmichael wrote: pctincrease=0 and set the storage parameters at the tablespace level and do NOT put storage parameters on the individual objects. you can fake the workings (without the bitmap!) of an LMT by doing that. Next extent=initial extent, pctincrease=0 will effectively allocate extents of equal sizes --- [EMAIL PROTECTED] wrote: thanks in case I happen to work on a 7.3 database what kind of pctincrease should I set? What about the other settings? Just curious. Ryan From: BALA,PRAKASH (HP-USA,ex1) [EMAIL PROTECTED] Date: 2003/03/21 Fri PM 12:54:41 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Locally Managed Tablespaces Once you set to uniform extents, pctincrease will default to 0. Most Oracle gurus advise to just use uniform extents for all situations. -Original Message- Sent: Friday, March 21, 2003 10:59 To: Multiple recipients of list ORACLE-L This is probably pretty basic, so please keep in mind that Im a developer and Im trying to pick up more of the DBA side. I am assuming that the preferred way to create a tablespace in 8i, 9i is as follows(this is out of OTN docs) CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K; When you use Uniform Extents you know longer have to worry about tablespace fragmentation correct? You also do not need to worry minimum,initial,and next extents correct? What are some rules of thumb for setting PCTINCREASE(there is another PCT setting too right)? A DBA I used to work with said you should almost always use zero for PCTINCREASE. Could someone please tell me why? The default is like 40? Is there a time when I should not use Uniform Extents? Thanks... hope this isnt too basic. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BALA,PRAKASH (HP-USA,ex1) 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). __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Developer OCP, or DBA OCP ..?
The SQL test for the developer and the DBA test overlap. So if you do one, you only need 3 tests for the other. Keep in mind you also need to pay for a $2,000 class if you do the DBA certification. The developer test is very easy. So why not do both? Best bet may be to just take the tests on the developer and DBA certifications and if you find an employer willing to pay for the DBA class do it that way. That is what Im doing. BTW, the first sun java certification is a joke. You only need to get 52% right(I know I said this about an upgrade exam once, but this one I checked first). According to a Java board I posted to, employers want that first Java certification and then some vendor specific certifications for Java specialists. Not sure how it works for Oracle specialists who also do java. Ryan - Original Message - From: Stefan Jahnke To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 02, 2003 7:48 AM Subject: AW: Developer OCP, or DBA OCP ..? Hi I personally think the Oracle Developer track doesn't do very much anyway. A combination of the SUN Java certification program and DBA OCP might be more helpful. A coworker of mine did the latest Developer OCP track and was very disappointed regarding the contents of the classes. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED]. Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprngliche Nachricht-Von: Salaheldin Aboali [mailto:[EMAIL PROTECTED]Gesendet: Mittwoch, 2. April 2003 07:59An: Multiple recipients of list ORACLE-LBetreff: Developer OCP, or DBA OCP ..? Hi gurus,what do u recommend: taking "Developer OCP" then "DBA OCP", or "DBA OCP" direct ?assuming a person who is currently a 28 years - already is a senior oracle developer.thanx for advice Regards,Salaheldin Aboali--Senior Software Developer Management Information Systems--http://www.mis-kuwait.comPhone:+965.240.64.25+965.240.67.98+965.240.80.92Ext. 235Fax. +965.240.81.53Cell. +965.790.31.65--P.O. Box: 20126 Safat-13062 Kuwait--
Re: Rule Based Optimizer
there not really quitting cold turkey its been phased out. wasnt the CBO introduced in 1997? Or was it earlier than that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 6:44 PM RWB, I'll tell you, if KG says it about Oracle, I pretty much would go to the bank with it. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/10/2003 4:24 PM Mr. Gopalakrishnan: How do you know this? Can anyone confirm (or deny) this? I hope it is true! Oracle should just quit cold turkey and not support the RULE optimizer at all in any future releases. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] .com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Rule Based Optimizer ity.com 06/10/2003 12:59 PM Please respond to ORACLE-L RULE optimizer will not be supported in next version. But you can still use the RULE optimizer and it is just a matter of official support from Oracle. Best Regards, K Gopalakrishnan -Original Message- Goulet, Dick Sent: Tuesday, June 10, 2003 10:16 AM To: Multiple recipients of list ORACLE-L There appears to be a number of folks on the list who have some insight into the next version of the database. I'd like to ask those folks a simple question. What is the future of the Rule Based Optimizer looking like? Does it die in 10i?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: K Gopalakrishnan 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: 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: Freeman Robert - IL 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Re: Trigger double firing apparently double inserts
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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: 9i OCP Details
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Should percent increase higher than 0 in 817?
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Questions on java
best pl,ace ive seen for java questions are the sun.com forums. - Original Message - From: purushottam krishna hegde To: Multiple recipients of list ORACLE-L Sent: Friday, July 04, 2003 3:59 AM Subject: Questions on java hi all, can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
Re: update about 100K records
bulk collect the flag into a pl/sql table. forall with a limit clause and then commit after hitting each limit. this is on asktom. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:09 PM I have a table of about one million records. About 100,000 of them have a flag which I need it set to 0. Because of the size of the rollback segment, I cannot update them all and then commit, I need to do it in sets of 1000 records. Do I need a cursor for this? I had something like that: DECLARE I BINARY_INTEGER; Cursor MyCursor IS SELECT * FROM (Table_Name) WHERE(Condition) FOR UPDATE; BEGIN I := 0; FOR MyRec IN MyCursor LOOP UPDATE (Table_name) SET delete_flag = 1 WHERE CURRENT OF MyCursor; I := I + 1; IF MOD(I, 1000) = 0 THEN COMMIT; END IF; END LOOP; END; / But FOR UPDATE does not really work well, and at the 1000th record when it reaches the commit, its dropping out of the loop. Can I use ROWNUM to update them in batches of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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: Ryan 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: update about 100K records
uhhh... this is pretty easy. declare type mytable is table of Whatever l_table mytable; l_updatevalue mytable begin select rowid, updateValue bulk collect into l_table; from table; now update off the rowid for your value. go through like 5000 records in the pl/sql table at a time. end; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:29 PM huh??? --- Ryan [EMAIL PROTECTED] wrote: bulk collect the flag into a pl/sql table. forall with a limit clause and then commit after hitting each limit. this is on asktom. anything more down the earth for me please? thx maa - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:09 PM I have a table of about one million records. About 100,000 of them have a flag which I need it set to 0. Because of the size of the rollback segment, I cannot update them all and then commit, I need to do it in sets of 1000 records. Do I need a cursor for this? I had something like that: DECLARE I BINARY_INTEGER; Cursor MyCursor IS SELECT * FROM (Table_Name) WHERE(Condition) FOR UPDATE; BEGIN I := 0; FOR MyRec IN MyCursor LOOP UPDATE (Table_name) SET delete_flag = 1 WHERE CURRENT OF MyCursor; I := I + 1; IF MOD(I, 1000) = 0 THEN COMMIT; END IF; END LOOP; END; / But FOR UPDATE does not really work well, and at the 1000th record when it reaches the commit, its dropping out of the loop. Can I use ROWNUM to update them in batches of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson 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: Ryan 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: update about 100K records
if your in 8i you can only use one field for a bulk collect( i think ic ant remember). I think they fixed that in 9i. i meant whatever. i also 'think' to do a bulk collect in 8i you cant anchor the pl/sql table. has to be varchar2, number, etc... im pretty sure you can do it with a rowid. I dont remember either. Im 29. Im senile. Sorry. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 8:04 PM --- Ryan [EMAIL PROTECTED] wrote: uhhh... this is pretty easy. declare type mytable is table of Whatever should I really put whatever, or table%rowtype? l_table mytable; l_updatevalue mytable are both variables of the same type? begin select rowid, updateValue do you mean column-to-be-updated as opposed to updatevalue? bulk collect into l_table; from table; now update off the rowid for your value. go through like 5000 records in the pl/sql table at a time. like how? Its not an array... end; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:29 PM huh??? --- Ryan [EMAIL PROTECTED] wrote: bulk collect the flag into a pl/sql table. forall with a limit clause and then commit after hitting each limit. this is on asktom. anything more down the earth for me please? thx maa - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 7:09 PM I have a table of about one million records. About 100,000 of them have a flag which I need it set to 0. Because of the size of the rollback segment, I cannot update them all and then commit, I need to do it in sets of 1000 records. Do I need a cursor for this? I had something like that: DECLARE I BINARY_INTEGER; Cursor MyCursor IS SELECT * FROM (Table_Name) WHERE(Condition) FOR UPDATE; BEGIN I := 0; FOR MyRec IN MyCursor LOOP UPDATE (Table_name) SET delete_flag = 1 WHERE CURRENT OF MyCursor; I := I + 1; IF MOD(I, 1000) = 0 THEN COMMIT; END IF; END LOOP; END; / But FOR UPDATE does not really work well, and at the 1000th record when it reaches the commit, its dropping out of the loop. Can I use ROWNUM to update them in batches of 1000 per time? Thanks, maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson 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
Re: something appears to be funny with ROWNUM
rownum is a bit misleading. its really just a counter of the rows returned in the resultset. so lets say you go: select * from myTable where rownum = 10; you get 10 records. Your 'rownum' counter starts with the records returned. now do the following select * from myTable where myCol like '%myvalue%' and rownum 10; well your 'rownum' counter starts with the first 10 values that meet your like statement. Which is called your 'resultset'. so if you do select * from myTable where rownum between 500 and 600; your select is looking at the first row it will default to a rownum = 1; thats not 500 so it gets discarded second row gets examined, it also gets a default rownum = 1(since no rows have been returned). that isnt 500, discard and so on. to get the the records 'between' a certain rownum, you gotta use a couple of inline views. http://asktom.oracle.com/pls/ask/f?p=4950:8:404569119689273749::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:127412348064, its generic. takes a bit to figure out why it works. now your in 8.0 right? I dont think you can do an order by in a sub-query... so this might not be possible... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 10:14 PM 1. this first query gave me 600 lines of output. SELECT Rownum, Gender FROM EMP2 WHERE ROWNUM = 600; 2. this one right here told me no rows selected... SELECT Rownum, Gender FROM EMP2 WHERE ROWNUM BETWEEN 500 and 600; I dont get it... something is funny with ROWNUM... Any ideas? thx maa __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MaryAnn Atkinson 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: Ryan 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: Cary/Others RE: should you seperate indexes from tables in
may also send the HELP command for other information (like subscribing). American Express made the following annotations on 07/15/2003 02:15:07 PM -- ** This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. ** == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tracy Rahmlow 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: Ryan 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).
security without using different usernames
Title: RE: upgrade to AIX 5 I know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and tablespaces. One thing I may have control over would be to slightly rename the executable. If you check v$session, in a client-server application the name of the product connecting to the database is recording. I can handle security based off of that. My question is what would be the best way? Cant do synonyms for this since its the same login. I think I saw somewhere that there is a session based 'set' command where you can say use this schema. I think it was on asktom and in reference to a question about public synonyms. I cant find it. Anyone know it? Also is it viable to base a context off of what is in v$sesion with a logon trigger? How would I 'redirect' all queries to a specific schema? To stress, I cant change the application. Different group with different skillsets.Any suggestions?
Re: security without using different usernames
Title: RE: upgrade to AIX 5 management has handled it. namely my manager and the answeris no. Partitioning cant be done. we are ingesting data to this application via transportable tablespaces. So each schema has to be self-contained. - Original Message - From: Goulet, Dick To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 6:59 PM Subject: RE: security without using different usernames Ryan, What would be much better is to create the single schema and partition the tables so that each customer's data lands into it's own partition. As for this other group, make some friends. It's a lot easier to get your problems and concerns addressed if the people your talking to are on a friendly basis with you. You can also bring up the problems of scaling to your management in terms of dollars needed for additional servers, memory, hard disk, and software. For some reason that is something pointy headed managers seem to understand, especially when you start talking about Oracle licenses at $40K per CPU. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 15, 2003 6:29 PMTo: Multiple recipients of list ORACLE-LSubject: security without using different usernames I know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and tablespaces. One thing I may have control over would be to slightly rename the executable. If you check v$session, in a client-server application the name of the product connecting to the database is recording. I can handle security based off of that. My question is what would be the best way? Cant do synonyms for this since its the same login. I think I saw somewhere that there is a session based 'set' command where you can say use this schema. I think it was on asktom and in reference to a question about public synonyms. I cant find it. Anyone know it? Also is it viable to base a context off of what is in v$sesion with a logon trigger? How would I 'redirect' all queries to a specific schema? To stress, I cant change the application. Different group with different skillsets.Any suggestions?
Re: security without using different usernames
Title: RE: upgrade to AIX 5 yeah i think that might be 'viable'. its a big kludge. but sometimes you have to deal with that. send outpage that alters the name of the executable, so each customer's executable has a different name use program in v$session in a logon trigger to get the customer hit a lookup table to see which schema to use execute immediate to set that up. thanks. - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 7:09 PM Subject: Re: security without using different usernames Ryan, It's alter session set current_schema = name; Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 1:29 AM Subject: security without using different usernames I know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and tablespaces. One thing I may have control over would be to slightly rename the executable. If you check v$session, in a client-server application the name of the product connecting to the database is recording. I can handle security based off of that. My question is what would be the best way? Cant do synonyms for this since its the same login. I think I saw somewhere that there is a session based 'set' command where you can say use this schema. I think it was on asktom and in reference to a question about public synonyms. I cant find it. Anyone know it? Also is it viable to base a context off of what is in v$sesion with a logon trigger? How would I 'redirect' all queries to a specific schema? To stress, I cant change the application. Different group with different skillsets.Any suggestions?
Re: security without using different usernames
partitioning is not an option. one of our ingestion methods to bring data to the production database is transportable tablespaces. It wont work. So we cant just cram everything into the same table. We ingest data from different 'staging' servers. that have differing logic. this data is then transportable to the production servers. We also use imports and sqlloaders as well. depends on how we get the data. Some data we get from the client, some we get from other groups in the company. so FGAC is out andI know how to use it. From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 7:24 PM Subject: Re: security without using different usernames Ryan, To make a particular schema the focus for a session: Alter Session Set Current_Schema = TheSchema ; Better yet, instead of proliferating the same schema for each client, convert the tables to partitioned tables in a single schema, with each partiion being for a specific client. That way you can add and remove clients by adding and dropping partitions. Each client's partitions could even be in tablespace(s) on separate drives to isolate their I/O from others. If all the schemas will always be identical, then partitioned tables are the way to go. If you'll customize the app and data structures for some clients, then you'll have to stick with individual schemas. If you use partitioned tables, use FGAC (Fine-Grained Access Control, AKA Row-Level Security) and Application Context to control security - see the Concepts doc and Application Developers Guide for details. Using those features of Oracle, you could limit each client to only their own partitions. I've used it in the past and It works very well. In fact, I'm in the last stages of designing and implementing an FGAC solution by which the 162 Campus-level Student Information databases in our District will be consolidated into a single Oracle database, with users at each Campus only seeing the tables for their School. We already have all 53,000 tables and 75,000 indexes (those are not typos!) of this 3rd Party App in an Oracle database. I'm just adding the security piece to keep them out of each other's business (or, "bidness", as we say in Texas). ;-) Jack C. ApplewhiteDatabase AdministratorAustin Independent School DistrictAustin, Texas512.414.9715 (wk)512.935.5929 (pager)[EMAIL PROTECTED] "Ryan" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2003 05:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:security without using different usernamesI know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and tablespaces. One thing I may have control over would be to slightly rename the executable. If you check v$session, in a client-server application the name of the product connecting to the database is recording. I can handle security based off of that. My question is what would be the best way? Cant do synonyms for this since its the same login. I think I saw somewhere that there is a session based 'set' command where you can say use this schema. I think it was on asktom and in reference to a question about public synonyms. I cant find it. Anyone know it? Also is it viable to base a context off of what is in v$sesion with a logon trigger? How would I 'redirect' all queries to a specific schema? To stress, I cant change the application. Different group with different skillsets. Any suggestions?
Re: security without using different usernames
our application is deployed on multiple remote locations. this would mean we would have to record the osuser of each each user in each company. This limits the ability to scale. I believe our deployment process is we send a CD to the client and their technical support group installs it. Plus we already have it deployed in several locations. Im already concerned about getting the users to install a simple patch. Now they would have to send us their osuser and their company name. Too much work for the user. I want this to be as transparent as possible. As a user, I never want to be bothered with this stuff. So I dont want to bother them. These are big clients that are paying us prices that would make Oracle blush. You dont ask users to do anything when someone pays that much. thanks for the suggestion though. Brainstorming is good. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 7:34 PM Could you maybe use v$session.osuser instead of program? That way you shouldn't even have to rename the exe. HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, July 15, 2003 4:19 PM To: Multiple recipients of list ORACLE-L yeah i think that might be 'viable'. its a big kludge. but sometimes you have to deal with that. send out page that alters the name of the executable, so each customer's executable has a different name use program in v$session in a logon trigger to get the customer hit a lookup table to see which schema to use execute immediate to set that up. thanks. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 15, 2003 7:09 PM Ryan, It's alter session set current_schema = name; Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 1:29 AM I know this is terrible design, but the GUI was created by a software engineering group that is seperate from the database group. Its not scalable. So Im trying to come up with a more scalable method. I have no power to change their gui. It rides on the database. I have to live with it. This is not a high enough transaction database to warrant seperate instances. We have a variety of customers. Each of them has their own versions of data. However, the schema is exactly the same. These tables can get huge, so we dont want to throw them all into the same schema. Right now, due to the fact that the GUI has a series of logins that are the same across clients, each client has its own instance. This isnt very scalable as we get more business. We have to create another instance and ingest data to it. Id like to find a way to get all the clients in the same instance with just different schemas and tablespaces. One thing I may have control over would be to slightly rename the executable. If you check v$session, in a client-server application the name of the product connecting to the database is recording. I can handle security based off of that. My question is what would be the best way? Cant do synonyms for this since its the same login. I think I saw somewhere that there is a session based 'set' command where you can say use this schema. I think it was on asktom and in reference to a question about public synonyms. I cant find it. Anyone know it? Also is it viable to base a context off of what is in v$sesion with a logon trigger? How would I 'redirect' all queries to a specific schema? To stress, I cant change the application. Different group with different skillsets. Any suggestions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E 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: Ryan 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: Query tuning stumper
invc_line_attrb.billg_num = invc_line.billg_num, invc_line_attrb.billing_seq_num = invc_line.billg_seq_num -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard 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: Ryan 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: need help with execute immediate from a script
that was just a mock up of what I wrote. I dont have '||' in the real version. Its jut a typo here. Anyone know what is going on? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 21, 2003 5:24 PM Your using v_var1,v_var2 shouldn't be appended to the string that represents the dynamic SQL to execute; the using... is part of the syntac for execute immediate. An Oracle error message being what they are, they don't always highlight the correct cause of fault, but will identify some other error located close to where the real fault lies. For your solution, remove the || that occurs after :2 It is also unlikely that you can select * into TOTAL, which has been declared as a NUMBER. Consider count(*) perhaps? -Original Message- Sent: Monday, July 21, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im calling a script that uses dynamic sql. Im passing in a value as well. I keep getting SP2-0552: Bind variable 2 not declared. Here is a code snipped declare v_var1 Varchar2(30) := 'TEST'; v_var2 VARCHAR2(30) := '1'; total number; begin execute immediate ' Select * ' || ' from user_objects '|| ' where object_name = :1 '|| ' or object_name = :2 '|| using v_var1,v_var2 into total; end; / I call it as follows: @script HELLO -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung 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: Ryan 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).
9iAS vs. Weblogic and Websphere
I havent dug into 9iAS yet, but I want to learn atleast one of the major web servers. It appears that WebLogic and Websphere dominate the market. It also appears that 9iAS is tedious and has a poor design relative to these other two. What do you think? How different are the webservers? If I pick up one, does it translate? Also, what functionality does 9iAS add that Apache does not have in and of itself? I was able to run 9i Forms with just apache and OC4J? Ryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: 9iAS vs. Weblogic and Websphere
what functionality does 9iAS give you over just running apache? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:59 AM Ryan My impression is that 9iAS probably has the best database interface. The others look pretty primitive in comparison, basically just JDBC when you get to the bottom. Also, note that Oracle is currently running a special to lure WebLogic and Websphere users away. I think in this confusing, evolving market for application servers, a lot depends on your company's approach. If your company is highly committed to Oracle, then 9iAS is the logical choice. If you are highly committed to IBM, then Websphere is the logical choice. In our case we had to persuade people to move away from MS, and the argument was that you wouldn't be locked into one vendor, so the tendency has been to avoid Oracle for the non-DB pieces. I think the enterprise-scale AS are so complex that it is hard to compare feature-for-feature. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 22, 2003 10:54 PM To: Multiple recipients of list ORACLE-L I havent dug into 9iAS yet, but I want to learn atleast one of the major web servers. It appears that WebLogic and Websphere dominate the market. It also appears that 9iAS is tedious and has a poor design relative to these other two. What do you think? How different are the webservers? If I pick up one, does it translate? Also, what functionality does 9iAS add that Apache does not have in and of itself? I was able to run 9i Forms with just apache and OC4J? Ryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: 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: Ryan 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: what is BAARF?
information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: V$SESSSTAT stat 3 vs V$OPEN_CURSOR
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: Ryan 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).
why does block cleanout incur redo?
My understanding of block cleanout is that oracle is flushing transaction information of already committed transactions from the buffer cache. This can happen in selects, when 10% of the buffer cache is filled with 'lists' if blocks involved in transactions, or with dml. i dont understand why this incurs redo? your just flushing blocks that are no longer needed?
how to turn off ODBC auto-commit?
There is a function to turn off the auto-Commit in the JDBC. Is there one for the ODBC? Id prefer to commit at the transaction level and not for every statement.
Re: OT -- Boston Globe job listings
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).
OCP Architecture question
Im using the self test software and here is a question... I dont like the answers. Please tell me if Im wrong. Which Three methods can be used to avoid snapshot too old errors. This is for the 8i test. 1. User larger extents 2. Increase MAXEXTENTS for existing rollback segments 3. Create rollback segments with higher optimal values 4. Create rollback segments iwth high minextents 5. Run long queries when transaction processing is high. Ruling out 5 is obvious. The test says its. 1,3,4 How does using large extents help this? What about a higher minextents value?
system tablespace at 50 pct_increase in 9i?
any idea why oracle has the system tablespace using 50 pct_increase in 9i? I k now it did that in the past, but why not set it to zero? Ryan
Re: Tough Oracle DBA experience
Title: RE: Tough Oracle DBA experience how about DBAs with attitude problems? DBAs who refuse developers access to v$ views. DBAs who refuse to listen to developers. DBAs who who refuse to explain any decisions to developers. DBAs who are pure production DBAs and have no knowledge of development and cant even write PL/SQL? Ive worked with quite a few DBAs who only know a fraction of what they think they do. Same holds true for developers and managers. So its not one way. Attitude is harder to overcome than competence. Someone with a good attitude can learn. Someone who knows and has a bad attitude can be intolerable. The worst kind though is the jack of all trades who thinks he/she knows everything about everything yet only knows a little about everything. Those are the worst. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Saturday, August 23, 2003 4:24 PM Subject: RE: Tough Oracle DBA experience Top 5 problems ... 1. Developers (who think they know everything) 2. Developers (who think, others think they know everything) 3. Developers (who think but just not coherently) 4. Developers (who DON'T think at all) 5. Developers (these work for Oracle) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 23, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Subject: Tough Oracle DBA experience Dear All, I am collecting (Just writing in a book ) of all tough problems , great issues handled with Oracle RDBMS as a DBA. Request you kindly send us the Top 5 Problems , Difficult scenarios(the most tough problems , with solution u did.)you faced so far in your DBA life. Hope to see many responses to this , atleast by Monday. Thanks a lot. Regards Rajuveera
Re: Nature of Oracle-l has changed
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 23, 2003 8:19 PM On 2003.08.23 18:34, Tim Gorman wrote: Six years ago, a CIO commented to me, waving down a corridor which had offices full of developers, If I had my way, I'd get rid of all of them and replace them with lawyers. We'd buy applications instead of building them and then sue the vendors. My response was something along the lines of if you think developers are expensive, go price some lawyers, but it certainly bounced off him. At the time, I took it as just another colorful comment from a colorful guy. But he was dead serious, along with his CIO/CFO brethren, and the passing of Y2K and the dot-com bubble pop has expedited his prediction... I always wondered where does this prejudice against us, computer geeks (my apologies to anyone offended by that expression, but I'm a hard core computer geek) comes from? I must say that this prejudice is very hard to understand. IT people are very well educated, very hard working, regularly willing to work long hours and sacrifice their weekends for the benefit of the company. I found that very same attitude against the darned geeks at several executives and managers of several companies I worked for. Even if lawyers are much more expensive the programmers, system and database administrators, application designers, they are still very willing to make the switch. I'm not quite sure why are we so hated? Why would anyone want to kill a nice and seet little wabbit? Its perfectly understandable. Before the resession salaries for IT were extremely high. IT people could rake their employers over the coals because they could make a phone call and get another job. Throw in the fact that generally speaking 50% of programmers are incompetent(alot of us believe this) and still made the high salaries. So you had and still have alot of people talking up what they can do, getting large salaries, and not producing. Also throw in the fact that alot of technical people have personality problems. I dont believe that most IT people are like this, but it only takes a minority to make the rest of us look bad. Here is an example. I worked with someone who is a partner in a local Oracle consulting company. He told me that his company once hired a 'senior' developer who on his first day of work named his variables after 'Mary had a little lamb'. They fired him the first day and deservedly so. Another big flaw with alot of technical people is a lack of communication skills. They cant get across the reason why its going to take so long or they dont know how long its going to take. It then comes in over budget and takes too long. If you look at other professions you have standards to follow that can track how long something will take. Now its gotten better, but its still flawed and years away from being sound principle. Management wants sound bites. It will take this long, it will cost this much. I think there is also a lack of business knowledge on our part. I think that hurts us in understanding the 'whys' and 'hows' of business. Most importantly, managers are supposed to make it as quick as possible and as cheap as possible. Every business constantly tries to cut costs. Its the way of the world and we are a pretty heft cost. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Grid
i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan 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: Grid
no not over the atlantic. its from DC to Boston. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 7:39 PM 10GB over Atlantic? This does cost a lot. At least I assume so, why the heck am I sticking to 512kb in my home then? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 28, 2003 1:54 AM i havent seen much about internet 2. i didnt realize there was anything in production yet. do you know where i can find more info on it? 2.3 GBs isnt really that much for a connect anymore. its not that expensive to get 10GB connections or more. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 5:44 PM We've been talking of Grid computing here since either late 1999 or early 2000. The computing for our main experiment was designed before the Grid was contemplated. Still we have implemented some of the middleware needed, and build methods of authentication and authorization, and participated in Grid experiments. We have also been pushing the ability to transfer large amounts of data. The latest effort: 2.3 GB per second between the local internet hub and Geneva Switzerland over Internet 2. This is vital to make the Grid work. Yep, you'll probably have huge amounts of data coming in when CERN gets their large hadron collider online in 2007 ;) Btw, AFAIK, they're using Oracle... Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan 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: Tanel Poder 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: Ryan 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).
has anyone used threads to parallelize bulk loads?
I find this useful when I have large loads with alot of small to medium sized DML statements. Instead of running them serially I use DBMS_JOB and break them up into pieces. DBMS_JOB is limiting in that it can only do 36 at once per instance. If I want to do more, Id have to do it outside the database. I have read about unix 'pthreads'. These appear to have the same wait,notify,synchronize interface that java has. Im also on Solaris. Has anyone done anything like this? Any features on Solaris that I can use? I know solaris has some built-in low level C functions to handle locking(such as a mutex script). Any idea of some sources I can use to look this up? I dont need this for work right now, but I may need it in the future, so I want to play around with it. Or do I have to take this to a unix sys admin forum? If so anyone know any good ones? Threading interfaces seem to be very similiar across platforms. In oracle you achieve the same thing with dbms_job,dbms_lock,and dbms_alert. anyone got any scripts or experience with this? This is not essential. Im just playing around.
Re: has anyone used threads to parallelize bulk loads?
id like the wait, notify because when parts of a load end, I need to kick off other parts. you know any good sources on this? we are using 8i at work. So I cant use the recommendations that tim made. whenever i do a google search on pthreads, I get a ton of results and cant find good ones with examples. any suggestions? - Original Message - From: Tanel Poder To: Multiple recipients of list ORACLE-L Sent: Saturday, August 30, 2003 5:19 PM Subject: Re: has anyone used threads to parallelize bulk loads? Why dbms_job at all? Just create as many sqlplus sessions as you want using nohup in your databaseand execute your procedures from there. You canstill use dbms_lock, dbms_alert and dbms_pipe that way. Pthreads or IPC stuff is probably overkill if you don't need synchronization outside the database. If you still want to go that way, then you'd probably want to ask this question in some programming related forums instead of sysadmin's or Oracles. Tanel. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Saturday, August 30, 2003 11:54 PM Subject: has anyone used threads to parallelize bulk loads? I find this useful when I have large loads with alot of small to medium sized DML statements. Instead of running them serially I use DBMS_JOB and break them up into pieces. DBMS_JOB is limiting in that it can only do 36 at once per instance. If I want to do more, Id have to do it outside the database. I have read about unix 'pthreads'. These appear to have the same wait,notify,synchronize interface that java has. Im also on Solaris. Has anyone done anything like this? Any features on Solaris that I can use? I know solaris has some built-in low level C functions to handle locking(such as a mutex script). Any idea of some sources I can use to look this up? I dont need this for work right now, but I may need it in the future, so I want to play around with it. Or do I have to take this to a unix sys admin forum? If so anyone know any good ones? Threading interfaces seem to be very similiar across platforms. In oracle you achieve the same thing with dbms_job,dbms_lock,and dbms_alert. anyone got any scripts or experience with this? This is not essential. Im just playing around.
Re: has anyone used threads to parallelize bulk loads?
Title: Re: has anyone used threads to parallelize bulk loads? we are still on 8i at work. That stuff is useful in the future. what would you suggest for parallel extraction to from a DB to files? I dont know perl and dont have time to learn it right now. I can do it in C. yeah I know its easy, but Im in school too and there are so many hours in a day. how is unix redirection to a file for extraction? real slow? I always get concerned about using C in a DB, since I have to consider whether someone 2-3 years from now will be able to maintain it. - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Saturday, August 30, 2003 5:39 PM Subject: Re: has anyone used threads to parallelize bulk loads? Or forget about 3GL programming altogether and just query 9i external tables in parallel and pass the results into an INSERT /*+ APPEND PARALLEL */? Combine it all with PL/SQL pipelined table functions and you have parallel ETL -- extraction (using 9i external tables), transformation (using PL/SQL pipelined table functions), and loading (using INSERT APPEND) -- in a single SQL statement. Also, dont forget about 9i multi-table INSERT statements, conditional INSERT statements, and of course the MERGE (a.k.a up-sert) statements. There is a tremendous amount of flexibility and new features around ETL built into Oracle these days...Ive been programming C for 20 years and there are very few reasons to write another line of C code these days. I still find reasons, but only rarely. And never related to ETL...on 8/30/03 1:54 PM, Ryan at [EMAIL PROTECTED] wrote: I find this useful when I have large loads with alot of small to medium sized DML statements. Instead of running them serially I use DBMS_JOB and break them up into pieces. DBMS_JOB is limiting in that it can only do 36 at once per instance. If I want to do more, Id have to do it outside the database. I have read about unix 'pthreads'. These appear to have the same wait,notify,synchronize interface that java has. Im also on Solaris.Has anyone done anything like this? Any features on Solaris that I can use? I know solaris has some built-in low level C functions to handle locking(such as a mutex script). Any idea of some sources I can use to look this up? I dont need this for work right now, but I may need it in the future, so I want to play around with it. Or do I have to take this to a unix sys admin forum? If so anyone know any good ones? Threading interfaces seem to be very similiar across platforms. In oracle you achieve the same thing with dbms_job,dbms_lock,and dbms_alert. anyone got any scripts or experience with this? This is not essential. Im just playing around.
Re: db security, managed from application forms
thats not appropriate. go to metalink, there is a script to run to setup security to work with .mmbs. we used on a project i was on last year. I think it was pretty easy to use. it just creates views and checks existing roles. I 'think'. I cant remember exactly. I think you combine this with a database logon trigger. your reinventing the wheel. Also, if you want to grant roles on the fly, I dont recommend this in the application layer. You should put it into a package in the database. fatcity has an odtug dev2k forum where you will probably get a better response. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 30, 2003 10:59 AM List, after reading so much about managing the srcurity from the db users, roles and privileges, i have finally decided to do the same. I have figured out most of the things... 1. i have made a form interface to create role and grant privileges to roles. all the data goes to app tables, and then DB roles are created and grants given which matches the data entered. I have a routine which syncs the role/privs in the app tables to the db roles and privs. 2. another form provides interface to create users and grant roles to users. 3. then i have a MMB menu attached to a form which is executed. the user will login, and will be displayed a menu based on the role given to the user. this is where i'm not sure how would i handle it, something like... on-new-form-instance i would check the role name from the session_roles, and would have a table which would tell me which menu option has to be enabled with this role. am i going the right way ?? the forms will be run on the web, so i guess i cannot store them in the db, and cant use the menu roles facility. i have done a lot of work on this.. but cant figure out the role and form module to run...i dont want to go back to one app user accessing the db, and application managed seurity would appreciate any help. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Application DBA
im going with the flow. doing a Masters(company is paying for it) and doing my OCP. Ill probably go cert happy over time... do java,solaris, etc... I know for a fact not having a computer science degree hurt me. I was told it. So if employers want something, Ill give it to them. As long as a company has tuition reimbursement, I dont see why not to use it? Im going to grad school for free. Gotta give people what they want. btw, Im learning alot of useful stuff in school. It does not make up for experience, but its very helpful. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 4:19 PM Bill, Did you point out to them how *freekin wrong* they had been?!?!?!?! I would not have been able to resist the free shot. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 03, 2003 2:59 PM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] scribbled on the wall in glitter crayon: more and more employers are requiring OCPs and 'related degrees' such as computer science or a masters degree. At least in the US they are. How are things in other parts of the world? that they are and experience doesn't seem to count either. i was refused interviews for a number of jobs because i have neither a degree or an OCP. and while interviewed for others, they hired someone with a degree [in one case a degree in history] and no experience. i even had one place come back to me a couple of months after not hiring me, asking if i would work for them as a contractor to clean up the mess the person they did hire made. i had just taken this contract at the time so i graciously refused.;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] Science is a wonderful thing if one does not have to earn one's living at it. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Mercadante, Thomas F 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: Ryan 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: Urgent INFO needed.
i dont think so. There is too much money in this. Odds are they will refine their processes 'slowly' improve. Over a period of years they will be better. Will it always be as good as the US? No, but it doesnt need to be. Its cheap. This doesnt mean every IT job will dissapear, but there is a contraction in the market and it is continueing.. Those manufacturing jobs sent to sweat shops never came back due to lack of quality? No I dont think the IT market will dissapear, however, I think wages will continue to decline at least for a while. Most of the jobs out there these days are low paying, short temp jobs. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 5:29 PM Actually, I've seen the reverse be true. I've seen the work offshore be so poor that more folks are brought in locally to correct the problems, yet the offshore remain too because of contractual issues. Happened to me on at least two different occations. You get what you pay for. There are some great Indian DBA's out there (KG for one is awsome), but just as in America, for every great one there are probably 5 that should take up some other profession. This will come and go like everything else. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/3/2003 3:44 PM That is call mondialisation... Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Tony Johnson Sent: Wednesday, September 03, 2003 3:05 PM To: Multiple recipients of list ORACLE-L All I know about it is that for every new job in India one more DBA is out of work here in the United States. -Original Message- Sent: Wednesday, September 03, 2003 5:30 AM To: Multiple recipients of list ORACLE-L Dear Friends, One of my friends has got the offer from CSC india ltd. Please respond this mail if any one from CSC india ltd? just to know some info , thats it. Any info regarding this is appreciated. Please give me your mail id and contacts.. Thanks a lot. Regards Oracle DBA _ Do you Yahoo!? Yahoo! http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com SiteBuilder - Free, easy-to-use web site design software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Ryan 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: No more Oracle development here
what is the difference in cost between sql server and oracle? oracle claims its similiar due to sql server needing more hard ware. now that is probably bull in low end system, but is it accurate in high end systems? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:24 PM My company it's moving all the development efforts to SQL Server because the customers don't want to pay Oracle licenses anymore.. Gabriel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Ryan 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).
offshoring article
Here is a link to an article from McKinsey Co. My favorite positive is that offshoring IT jobs frees Americans up to do other jobs. Now they dont say 'what' jobs, but we are free to do them. If you dont know these are the guys who payed Chelsea Clinton 100k/year right out of college with no experience. If you explore their website they are more interested in where you went to school than anything else(notice how university comes before experience). who hires these guys? http://www.mckinsey.com/knowledge/mgi/offshore/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: question for internals experts
not my call. i posted this on here before. was done that way before i got here. Its part of the transportable tablespace plan since you cant have multiple tablespaces with the same name in one instance. I found some interesting(and troublesome things). I think Oracle may not be telling us the whole truth with how flushing the shared pool works and/or how the data dictionary data is stored in memory. We update TS$ to rename a tablespace. Normally we have no problems. Occasionally we have to flush the shared pool in order to alter the tablespace to read only. It doesnt recognize the new name. We check TS$ and the new name is there. My best guess at what is happening is that the data in the dictionary cache has the old name and the data in the system datafile has the new name. We can query the data dictionary and this queries the actually datafile and does not flush the dictionary cache. We flush the shared pool and everything works. However, for the second time flushing the shared pool has not worked. Interesting thing is that we can take the OLD tablespace name to read only, but not the new. We had everyone log out of the instance since we were wondering whether Oracle cached some data dictionary info in the PGA. We were able to bring the tablespace back online using its new name. We then logged out and back in. Didnt work this time. Flushed the shared pool. Didnt work. So we bounced the instance and everything works. This leads me to the following conclusions. 1. Updating TS$ does not cascade to other tables. If that was so, bouncing the database should not have fixed our problem. 2. Flushing the shared pool does not 'necessarily' flush all of the data from the shared pool. Since Alter tablespace still recognized the old name of the tablespace. 3. Or Oracle is storing part of the data dictionary information in other parts of memory that it is abstracting from us and not releasing. This was almost long enough to be an article... Anyone play around with this stuff? I know Steve Adams reads this forum periodically? you play with it? Some of you worked for Oracle, have you gotten and good inside info? In spite of the problem, it is fairly interesting to see that Oracle isnt telling us everything. Makes you wonder what else they are 'abstracting' from us in the documentation. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 05, 2003 7:22 PM Subject: Re: question for internals experts Sounds like you want to rename a tablespace. Not recommended without approval from Oracle support. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/05/2003 01:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:question for internals expertsDoes oracle store the tablespace_name or any data about a tablespace anywhere else accept TS$? Im looking for base data dictionary tables. Not views. Are there any documents out there about how oracle stores information in the data dictionary tables other than what Steve Adams has in his book or on his website? Has anyone else published on this? -- 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.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: question for internals experts
nah, we can afford to rebuild the instances. its just for staging anyway. Im now more curious what is going on. I dont think its in the datafile. I think there is more going on in memory than Oracle is releasing. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:04 PM I think this would be the perfect time for you, as DBA, to explain to the Powers That Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace plan has to change. You have damning evidence at this point in time. You will be doing yourself and your successors a big favour. -Original Message- not my call. i posted this on here before. was done that way before i got here. Its part of the transportable tablespace plan since you cant have multiple tablespaces with the same name in one instance. ... However, for the second time flushing the shared pool has not worked. .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: Ryan 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: question for internals experts
we publish from the same staging server daily to our master server. So we update our staging server to change the name. Then do the export. We thought about changing the export file, but its in binary and we couldnt make it work. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:24 PM ... A stupid solution might be to prefix the name of each tablespace with the name of the database it was created in ... you might have to play with users' quotas to allow them to create tables in the tablespaces you have plugged in but it is infinitely better than updating SYS tables ... I have done it in the past but always after a very very careful study of the situation and only because I really was cornered (and had a good backup). Jacques Kilchoer wrote: I think this would be the perfect time for you, as DBA, to explain to the Powers That Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace plan has to change. You have damning evidence at this point in time. You will be doing yourself and your successors a big favour. -Original Message- not my call. i posted this on here before. was done that way before i got here. Its part of the transportable tablespace plan since you cant have multiple tablespaces with the same name in one instance. ... However, for the second time flushing the shared pool has not worked. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: No more Oracle development here
how do oracle costs compare to DB2? Anyone use that? I dont have any experience in pricing. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 06, 2003 10:24 AM Ryan Comparing the costs are very difficult. You must carefully verify you have included all the costs, such as support. Oracle has Standard Edition and Enterprise Edition. Microsoft has Standard Edition and Enterprise Edition. From my analysis, they are not comparable (SE to SE or EE to EE). If you are considering MS SQL, you have probably decided you don't need the features of Oracle EE. If you feel you don't need the features in Microsoft EE you should probably consider MySQL. Therefore I feel that for most sites the comparison comes down to Oracle SE vs. MS SQL EE. If you factor in all the support costs, I found that Oracle SE was actually a little cheaper than MS SQL EE. I did that comparison over a year ago, so the prices may be slightly different today. And in your situation one or both vendors may be willing to reduce their price. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 6:19 PM To: Multiple recipients of list ORACLE-L what is the difference in cost between sql server and oracle? oracle claims its similiar due to sql server needing more hard ware. now that is probably bull in low end system, but is it accurate in high end systems? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:24 PM My company it's moving all the development efforts to SQL Server because the customers don't want to pay Oracle licenses anymore.. Gabriel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon 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: Ryan 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: 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: Ryan 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: DB2 has a foot in the door
have you used DB2? How does it compare to Oracle? Ive seen tom kyte write that each platform that DB2 runs on is in essence a different database and you cant take code from one platform and move it to another. are the features comparable? what about cost? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 8:54 AM VERY interesting. They refused to do site licensing at a 2 installation here. Thank you for this tip. Rachel Carmichael wrote: Oracle does site licensing... but only if you are a very very large corporation. Citibank (when I worked there) had one. The company I work for now has one. So I don't ask do we have a license when I want to install a new version of Oracle, even if it is a new platform One of the few things that is easier working in a rigid corporate environment --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: There's one thing that IBM can do, which Microsoft and Oracle can't offer: They do site licenses as well as cpu and user licensing. That just gives them an incredible advantage to management and others who can stop thinking about whether they should buy another server, move stuff from one server to the other, etc. I can't believe Oracle and Microsoft are not doing it (I think I can guess, but it's still not good). Mladen Gogala wrote: I believe that the answer to Stephane's question is obvious: Oracle 10g will cost 10 grands/ CPU. That's where the letter g is coming from. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Friday, September 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Stephane We've been very excited about Oracle Standard Edition. Helped stave off the interest in MS SQL. Given the budget pressures at many organizations, I'm surprised we don't hear more about this alternative. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing structure ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: 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 San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: 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 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: Ryan 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: DB2 has a foot in the door
how does DB2 compare to oracle cost wise? what about hard ware? does db2 require more hard ware than oracle does? how does its features compare? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 2:24 PM One of my previous employers had a site license. Not a huge site, but not too small either. About 5000 employees, lots of IT in that business. Not only a site license, but a 72% discount. We had a *good* negotiator. Jared On Sun, 2003-09-07 at 00:34, Mogens Nrgaard wrote: There's one thing that IBM can do, which Microsoft and Oracle can't offer: They do site licenses as well as cpu and user licensing. That just gives them an incredible advantage to management and others who can stop thinking about whether they should buy another server, move stuff from one server to the other, etc. I can't believe Oracle and Microsoft are not doing it (I think I can guess, but it's still not good). Mladen Gogala wrote: I believe that the answer to Stephane's question is obvious: Oracle 10g will cost 10 grands/ CPU. That's where the letter g is coming from. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Friday, September 05, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Stephane We've been very excited about Oracle Standard Edition. Helped stave off the interest in MS SQL. Given the budget pressures at many organizations, I'm surprised we don't hear more about this alternative. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Hi all, We're an Oracle shop, over 140 Oracle instances. Today, architecture has chosen IBM DB2 for BI projects. The next step I guessed will be to choose DB2 for the new transactionnal applications also. IBM offers DB2 at 25% less than Oracle. I wonder if Oracle 10G will come with a new pricing structure ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: 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 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: 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.net -- Author: Ryan 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: Incorrect results - 9.2 and hash joins
i meant as opposed to a nested join or sort merge. results will be the same. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 08, 2003 5:44 PM If the code is buggy, then use of hash join or any other piece of functionality might determine the result set. And we know that every useful program has bugs in it. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:19 PM show the query, show the plans. its not the hash joins. hash joins have nothing to do with determining what records are returned. its just how they are sorted. From: [EMAIL PROTECTED] Date: 2003/09/08 Mon PM 03:39:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Incorrect results - 9.2 and hash joins Good day to everyone Oracle 9.2.0.3 returns different (wrong!) results when hash joins are enabled. After (at session level) disabling hash joins, query returns correct results. The very same query, with exactly same data, returns valid values on 8.1.7 database. Has someone else seen this? This may leed to disastrous logical corruption of database. Any input, explanation, patches, stories or workarround tips, beside disabling hash joins? Thanks, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan 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: Weird ORA-00060 (deadlock) with pragma autonomous transaction
are you committing in the procedure with the autonomous transaction? do you have an exception block with a rollback? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 12:09 AM We are getting a strange deadlock problem and I am having trouble understanding the cause and action. Metalink has not been too useful for this one. We have a procedure eg INS_REC that does an insert into table ABC. The procedure uses a pragma autonomous transaction. We have a package eg DO_SET_OF_WORK that selects from several tables and then based on the information selected will call the above procedure, along with several other procedures that will do inserts or deletes (on DIFFERENT tables). The package does opens a cursor to process all records selected. When we use pragma autonomous transaction AND commit in the procedure called, the package dies with an ORA-0060. When the pragma autonomous transaction is removed from the procedure, the package does not get a deadlock. There is only ONE user using this set of tables (in a separate schema from other users on the system) at the time this is occuring. I am puzzled. Another DBA suggested this may be related to FREELISTS, so I increased them for both the table and indexes that were being reported as deadlocking but it did not make any difference. Anyone have any other suggestions ? Thanks Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood 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: Ryan 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: overloading and = comparisons in SQL
where can i find a list of sqltrace events? seems that 10053 and 10046 are well documented on hotsos. how many are there? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM Hi! Which kind of error? And where does it occur? What's the view code? Oracle does an implicit datatype conversion (if possible) when comparing different datatypes. Try to add the conversion explicitly with to_number for example try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Btw, did you change any versions recently? If you just went to 9.2.0.3 or 9.2.0.4, and started seeing your problem after that, then you might want to look at event 10499 on level 1 which is new starting from 9.2.0.3. (I doubt that you are hitting this problem, you didn't give us enough information). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 11:49 PM I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan 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).
question about migrating to 9i
Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself.
Re: 10g
did oracle provide you with documentation on these tools or just the 10g database and you had to find it all yourself? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM ADDM (pronouned Adam) is - as I wrote a minute ago - Statspack++ - for what it's worth. Of course you can't tell a damned thing about performance problems from system-data. Unless there's only one and the same user on the system in the observation internval. Active Session History (ASH), however, is a different story. Here they collect (down to every second) data about each session and what it spent its time doing. That's 10046 stuff being sampled in memory structures and stored in the repository in the SYSAUX tablespace. Very cool. Gaja will talk about it at our Database Forum - probably the day after he stars in BAARF. The Musical. Jesse, Rich wrote: Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more OEM/DBMS jobs! Wait a minute...no more DBA? Uh-oh./sarcasm I'm sorry Dave. I can't close the pod bay instance. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10g Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. -- Please see the official ORACLE-L FAQ: 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 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: Ryan 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 suppression and processing
what types are your fields? you can solve this problem by doing a function based index. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 4:59 PM DELETE FROM TABLE_MESSAGES WHERE field1 = lrec_icclaims_dtl (i).seq_id AND field2 = lrec_icclaims_dtl (i).seq_id AND type = 'E'; The above code deletes processing messages from a table that may contain upwards of 1,000,000 rows or more. We have a situation where we are inserting 100,000 rows per day into this table. When the above code executes within a package the whole process basically slows to a stop. With the code commented out the process runs. Field1 and Field2 are VARCHAR2(30). seq_id is a NUMBER(9). We believe that Oracle is doing an implicit conversion of the fields when the code is executed and causing the process to slow down dramatically. Without doing an explicit conversion with to_char (), because I believe this will suppress the indexes on field1 and field2, what can be done to make this efficient as possible? Field1 is in 2 indexes and field2 is in 1 index and type is not included in any indexes. Does Oracle suppress the use of indexes when doing an implicit conversion? Can we force index use with this statement: delete /*+ INDEX(tablename indexname [indexname]) */ from table_messages. This is the first time we have seen this problem with this table. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Ryan 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 do a variable in-list of numbers?
it was on asktom. you create a type in the database and use a CAST. it was pretty easy. you just need to add an object. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 12:44 PM I am catching up on the mail from the list and I think you can use dynamic sql. Something like: mysql := 'insert into tab2 select col1 from tab1 where col2 in ('; open cursor mysql := mysql || value || ','; loop substr(mysql,-1,1) := ');'; execute immediate 'mysql'; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 4:31 PM I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime. With strings I just build a big string. How do I build an 'inlist' of numbers at runtime? Im using a cursor to determine which values need to be added to my inlist. I think I can do some kind of cast, but im not familiar with it. Im on 8i. I do not want to j ust run this inside my cursor. It could then execute 300-400 times and will run all day. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar 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: Ryan 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).
Oracle on Linux
Are many people running Oracle on Linux? I havent seen it anywhere myself. If so what flavors? Is there much difference between administering on Say Redhat vs. Solaris? I know 'oracle' itself is the same, but any of the OS-Database interaction different? Im thinking about throwing Redhat on PC at home and playing around. Ill use a different flavor it really matters. Ive develped on HP-Unix and Solaris at work before, but never Linux. How different is the Linux kernel? Does it really matter to a DBA?
Re: how to do a variable in-list of numbers?
i used it because i needed i a cursor to do an 'insert values' so i grabbed my data from the cursor i needed anyway. Plus I needed to use it multiple times. Plus the tables are not indexed since they were designed to optimize inserts. So basically if you are going to 'resuse' the inlist, your join isnt optimized, and/or you need the cursor to grab the inlist for something else, then its useful. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 6:39 PM It's beginning to be late here and I'm feeling pretty tired, so I don't totally exclude my erring, but I believe that there is a basic conceptual flaw here. I see CAST as a way to turn into a relational object something which is not, by essence, a relational object (I would typically say the same of external tables). It's a great technique to map a PL/SQL table into something looking like a table - but only if the data you have to store into the PL/SQL table doesn't come form Oracle in the first place. Otherwise, could someone explain to me what is the benefit over a SELECT ... WHERE IN (SELECT ...) if a cursor is used to determine the in list ? The pleasure of loading more data into your PGA, perhaps ? Or is it 'why make simple when you can make complicated' in action ? SF Govindan K wrote: Here is an example of the CAST. May be you shall try this approach. set serveroutput on size 100; set echo on DROP TYPE my_table_type / CREATE or REPLACE TYPE my_record_type as OBJECT ( MSG_SYS_NO NUMBER(12) ) / CREATE or REPLACE TYPE my_table_type as TABLE of my_record_type / declare buf_data my_table_type := my_table_type() ; begin buf_data.EXTEND ; buf_data(1) := my_record_type(123456789012) ; buf_data.EXTEND ; buf_data(2) := my_record_type(123456789012) ; FOR CX in ( select MSG_SYS_NO from TABLE ( cast( buf_data as my_table_Type ) ) ) loop dbms_output.put_line('msg_sys_no = '||cx.msg_sys_no); end loop; end; / set echo off HTH GovindanK On Sun, 14 Sep 2003 08:59 , Ryan [EMAIL PROTECTED] sent: it was on asktom. you create a type in the database and use a CAST. it was pretty easy. you just need to add an object. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 14, 2003 12:44 PM I am catching up on the mail from the list and I think you can use dynamic sql. Something like: mysql := 'insert into tab2 select col1 from tab1 where col2 in ('; open cursor mysql := mysql || value || ','; loop substr(mysql,-1,1) := ');'; execute immediate 'mysql'; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 4:31 PM I need to do an insert select of the form insert into tab2 select col1 from tab1 where col2 in (inlist of numbers); I do not know how many values will be in my inlist at runtime. With strings I just build a big string. How do I build an 'inlist' of numbers at runtime? Im using a cursor to determine which values need to be added to my inlist. I think I can do some kind of cast, but im not familiar with it. Im on 8i. I do not want to j ust run this inside my cursor. It could then execute 300-400 times and will run all day. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: error transporting a tablespace from 8i to 9i?
new database. we are just taking certain tablespaces to it. we are not ready to upgrade our 8i to 9i databases yet. However, we need to set something up in 9i for a new client. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 15, 2003 4:44 PM upgrade in place is not an option, or am i missing something? joe [EMAIL PROTECTED] wrote: We are trying to transport a tablespace from 8i to 9i. According to metalink Oracle changed the NCHAR character set to 2 values so we dont have a match. we can do an export/import, but no transportable tablespaces. Any known work around? Short of destroying all our 8i databases and recreating them to match the 9i standards(since the 9i ones cant use what is in 8i). Connected to: Oracle9i Enterprise Edition RelEase 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production IMP-2: failed to open expdat.dmp for read Import file: expdat.dmp /mnt/myfile.dbf Export file created by EXPORT:V08.01.07 via conventional path About to import transportable tablespace(s) metadata... import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion) IMP-00017: following statement failed with ORACLE error 19736: BEGIN sys.dbms_plugts.beginImport ('8.1.7.3.0',31,'31',NULL,'NULL',226234 ,1569301,1); END; IMP-3: ORACLE error 19736 encountered ORA-19736: can not plug a tablespace into a database using a different national character set ORA-06512: at SYS.DBMS_PLUGTS, line 1797 ORA-06512: at SYS.DBMS_PLUGTS, line 1636 ORA-06512: at line 1 IMP-00017: following statement failed with ORACLE error 29344: BEGIN sys.dbms_plugts.checkUser('myuser); END; IMP-3: ORACLE error 29344 encountered ORA-29344: Owner validation failed - failed to match owner 'WEB_OWNER_3' ORA-06512: at SYS.DBMS_PLUGTS, line 1597 ORA-06512: at line 1 IMP-00034: Warning: FromUser myuser not found in export file Import terminated successfully with warnings. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Oracle Press OCP exam guide frustrations
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: Oracle Press OCP exam guide frustrations
all you have to do is buy the self study CD? are you sure? I thought you had to get a class? which are atleast $1500 online? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 7:39 PM True. You can save yourself $115 if you do it this way. 8i cert + upgrade - $750 9i cert (with required class, using Self-Study CD-ROM) - $865 It's up to you ... -Original Message- Ryan Sent: Tuesday, September 16, 2003 7:15 PM To: Multiple recipients of list ORACLE-L you can do the 8i cert and upgrade without paying for the course. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 6:49 PM One may as well get used to putting forth some extra expenditure when getting certified now. The publisher, Coriolis, went under. And now Oracle is requiring that you complete at least one of their prep courses (irrespective of whether you believe you need it or not) in order to become OCP-certified for 9i. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 11:00 AM To: Multiple recipients of list ORACLE-L they are not outstanding. they are ok? They are also expensive. I have found the Coriolis books to be better than the Osborne books in quality. They dont have 9i ones. you can get the 8.0/8i ones for $9/each at maryland-merchant.com Im using those myself, then the docs. I didnt like the osborne books. From: Rajesh Dayal [EMAIL PROTECTED] Date: 2003/09/16 Tue AM 10:09:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Press OCP exam guide frustrations Try out self study materials from http://www.selftestsoftware.com they are simply outstanding. I have always found them helpful for all my exams. But at same time I never totally rely on them, I first complete my ground work with standard syllabus (available on Oracle OCP site) and Oracle Documentation then only I Open them ;-). HTH, Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Tuesday, September 16, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Fwd: Oracle Press OCP exam guide frustrations All, I just purchased a Oracle9i Fundamentals I exam guide published by Oracle Press and am very disappointed with the quality of the publication. There seems to be quite a few mistakes, misleading sentences and typos (not in the Errata) which is very frustrating. Also, there is a question in the Managing Tablespaces and Datafiles chapter that replies on the order of the multiple-choices, however the quiz software randomises the choices so the question no longer makes sense - and is impossible to answer as presented. For those that have completed the OCP exam, is this what I am to expect? Does anyone know of any other resources I might be able to use? How are the OCP exam guides published by Sybex? Any help would be greatly appreciated. Regards, Craig. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Munday 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: Rajesh Dayal 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
Re: Re: max parallel query
/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan 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: sizing sort_area_size
can anyone recommend a good article managing sort_Area_size and understanding temp tablespace waits? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:34 PM I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size has helped right?(notice Im not trying to improve my cache/hit ratio). If you see less direct IO waits on your temporary tablespace, then increasing s_a_s has helped. I get this from v$sess_io. how do I tell how much temp tablespace my session uses? I cant find a statistic for it? I see that I used up all my PGA since PGA size and PGA max size are equal in v$sesstat. select * from v$sort_usage where sid = sid; anything else I can look at? Activity on temp tablespace from v$tempstat.. but it's only good enough for comparing with baselines.. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: max parallel query
i dont manage the netapp and am not a hardware person. could you explain a little better? Is netapp similiar to SAN? what is asynch I/O? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:24 PM Ryan You are probably bottlenecking on the NetApp. Probably your network link to it. If you have some regular (a.k.a. direct attached) disk available, consider using it for your redo logs. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 4:45 PM To: Multiple recipients of list ORACLE-L hmmm... when i run statspack during a big load. most of my waits are from redo log waits and read from a staging datafile. we have all of our datafiles on the same I/O mount. We are using a Network Appliance back end with asynch I/O. are you telling me that putting these files on seperate mount points will have no effect? I dont quite follow asynch I/O. I dont have much of a hard ware OS background. I cant find any docs or articles on how to tune Parallel Operations. All I see are basic syntax. Do you know of any? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 5:24 PM If you want rules of thumb, then take CPU_COUNT+1 up to CPU_COUNT *2. I think LIO PIO ratio is irrelevant, the most important is whether you are able to construct optimal parallel execution plan, e.g. avoid excessive parallel slave messaging waiting. This is mostly design and SQL issue. The number mount points is irrelevant novadays as well IMHO, especially when you're using async IO, SANs SAME like architecture. The only thing what comes into my mind where splitting into mount points (thus different file systems) helps performance wise, is that with more file systems you got more file system locks and you can spread contention for these locks that way. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 9:34 PM i know there are no magic formulas, but im hoping for something better than trial and error. i would assume that parallel query helps most when: 1. are doing work off of multiple mount points. 2. Have alot more LIOs to perform than PIOs(such as sorts). am i close on this? From: M Rafiq [EMAIL PROTECTED] Date: 2003/09/18 Thu PM 01:34:44 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: max parallel query Tanel, You are right. There is a param parallel_automatic(I don't remember exact name as I don't have access to database) which should be set to true and let system decide how many pq slave to be used. For max_parallel_server default is 5 and can be set to higher number which memory and cpu can handle. It is faster because it uses all system resources at a given time. Rarallel process can be used for large batch jobs during off-peak time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 18 Sep 2003 08:39:44 -0800 There is no simple magic formula how many parallel slaves you should have. It all depends on your CPU and IO utilization. Yes, utilization, because if your CPUs or IO are running at their limits already, you won't benefit from parallel execution at all. In fact PX may make the situation even worse, because it's designed to give you the results the fastest way, not the most efficient way. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:15 PM We run multiple instances on the same server. My understanding is max_parallel_servers should be set to 4 x CPU. We have 4 CPUs which means 16. however, does this take into account multiple instances on the same server? -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
asynch I/O
Could you clarify something for me? Are you saying that if I have a variety of 'mounts' on our netapp say /mnt1 /mnt2 I would not benefit by putting my datafiles on seperate ones? I thought that is where my I/O waits are coming from. Since we have all of our datafiles in the same directory? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).
sort area size?
Saw your post on o racle.server. I didnt see the article on ixora about sort_area_size and PQ slaves? which one is it? So your saying if I set 500MB sort_area_size and have 5 slaves? each slave can use an additional 1GB of sort_area_size? is that in otn docs? I didnt see it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).
minus vs. where not exists, vs. where not in
Do any of you have any cases when minus is superior in performance? Ive found 'not in' with a hash_aj to be the best option if the sub-query is significantly less 'costly' then the outer query. I dont mean cost in terms of the Explain Plan, I mean the work Oracle has to do to find a result set. It also depends on a proper hash_area_size I find 'where not exists' to be best if the subquery is relatively close in cost to the outer query. Yes I know you cant make broad generalizations, but there has to be some 'narrow' generalizations you can make. Such as certain cases, etc... what have you seen? There seems to be very little work in this area in the literature. Does 'where not exist' need more or less sort_area_size space than minus?
Re: minus vs. where not exists, vs. where not in
if you handle for nulls with an 'nvl' then 'not exists' appears to return the same answer as not in. or am I wrong? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 21, 2003 3:24 PM First off, the three are not equivalent, not substitutes for each other. Well not in and minus would be, but they are different from not exists. not in/minus and not exists can return different results. See http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:44202973 7684http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:4420 29737684 for examples and explanation. I have not done any performance comparisons but I personally routinely use minus and I am quite happy with it, especially across a db link. At 09:59 AM 9/21/2003 -0800, you wrote: Do any of you have any cases when minus is superior in performance? Ive found 'not in' with a hash_aj to be the best option if the sub-query is significantly less 'costly' then the outer query. I dont mean cost in terms of the Explain Plan, I mean the work Oracle has to do to find a result set. It also depends on a proper hash_area_size I find 'where not exists' to be best if the subquery is relatively close in cost to the outer query. Yes I know you cant make broad generalizations, but there has to be some 'narrow' generalizations you can make. Such as certain cases, etc... what have you seen? There seems to be very little work in this area in the literature. Does 'where not exist' need more or less sort_area_size space than minus? Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Ryan 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: Copying statistics : used a lot ????
states his opinion on this approach on page 30, section entitled Test Against Representative Data. -Original Message- Stephane Paquette Sent: Thursday, September 11, 2003 4:38 PM To: Multiple recipients of list ORACLE-L HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test environment to see what will be the access plan. If not used, why ? no time to look at it, bugged, not usefull ,... ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette 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: Grabowy, Chris 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: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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: Ryan 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).
sql trace tuning articles
did a google search and couldnt find anything worth reading. other than the ones on hotsos any other good ones? namely ones on traces other than 10053 and 10046? Ive seen a few others mentioned but no details.
Re: possible to have a primary key with a bitmap index?
im just playing around and testing things. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 5:34 PM I don't know what's the syntax (or if it even exists). But, logically bitmap indexes are for the columns with low cardinality, while primary key index is unique. So, why do you want bitmap index for your primary key? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 3:55 PM To: Multiple recipients of list ORACLE-L is it possible to have a primary key that is enforced with a bitmap index? if so what is the syntax? -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: what causes a memory dump?
nothing in the alert log. we have a script that polls it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:09 PM Ryan - The largest I've seen is 4-meg., so this is unusual. My suggestion would be to change your USER_DUMP_DEST to a drive with more free space, because the DBA's rule of life is that if an error is encountered once, it will probably be encountered again. Also check your alert log, because the error that caused the dump will be mentioned there. Try to diagnose the problem before it whacks you again. Good luck. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 2:45 PM To: Multiple recipients of list ORACLE-L i had to delete the dump file in order to log into sysdba. it took up the whole hard drive. any examples of what causes a memory dump? what is the point to a memory dump? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:19:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the application dumped. Pain is your friend. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL
OEM Problem?
for some reason when i created the OEM repositiory the OEM assistant created the following username. OEM_RYAN-2LE36OFJCE_OEMREP I cant connect to this user, drop it or alter it because of '-' in the name. how do i get rid of the repository and start over?
Re: how to drop an oem repository?
ignore i figured it out. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 2:14 PM Subject: how to drop an oem repository? I dropped an oem repository using the oem configuration assistant. Im now trying to use the GUI to create a new one. It says that I cannot create a new one, becuase another OEM 'service' exists. I dropped the user and the tablespace. How do i get rid of the service so i can make a new one? 1. I click configure local management server 2 says OMS on this machine is already configured do you want to edit? 3. then i cant login because i have dropped the user?
how to drop an oem repository?
I dropped an oem repository using the oem configuration assistant. Im now trying to use the GUI to create a new one. It says that I cannot create a new one, becuase another OEM 'service' exists. I dropped the user and the tablespace. How do i get rid of the service so i can make a new one? 1. I click configure local management server 2 says OMS on this machine is already configured do you want to edit? 3. then i cant login because i have dropped the user?
Re: Database just stops
Title: Message define 'just stops'. A specific user cant do anything. CAn any users log in? are you in archive log mode? If so this is possibly a sign that your archiver cant keep up with the amount of redo to archive. - Original Message - From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 4:14 PM Subject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
space taken up by number data types
I could have swarn I read that Precision with number data types effects how much space is reserved in the database. So number(38) and number(3) reserve different amounts of space. Here is a link from Tom Kyte in 1998 saying the opposite. Is what he says still true? http://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm=355e25d0.17874392%40192.86.155.100rnum=1prev=/groups%3Fas_q%3Dnumber%2520datatype%2520storage%26safe%3Dimages%26ie%3DUTF-8%26oe%3DUTF-8%26as_ugroup%3D*oracle*%26lr%3D%26num%3D50%26hl%3Den
Re: Database just stops
Title: Message i ran into this problem with DOM objects.we were loading them in memory and taking up so much memory the only way to even access the database was through connect internal. couldnt connect any other way. had to shutdown abort. I cant find any notes on it though. - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 4:39 PM Subject: Re: Database just stops define 'just stops'. A specific user cant do anything. CAn any users log in? are you in archive log mode? If so this is possibly a sign that your archiver cant keep up with the amount of redo to archive. - Original Message - From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 4:14 PM Subject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops. When I restart the database it goes through crash recovery but comes up fine. Anyone have any ideas? Thanks! Ron Smith
question about ordering in a table
If I have a table that does not have any indexes or keys. If I insert 10 records. Will there ever be a case that when I do a select on that table without an 'order by' clause that the result set will return in a different order? Assume the table is read only. No DML is performed on it. So I insert 1 2 3 4 5 6 7 8 9 10 I do select * from table; Will the data always be returned in that order?
Re: Performance tuning book
here is a list of tuning books to read. I used to work with the guy who wrote it. He definitely knows what he is doing. There are quite a few people on this list who can attest to that. http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re f=cm_lm_dp_l_2/102-3468524-1000163 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 6:24 PM Cary, Thank you for your in-depth response. It was very helpful. To me, the hardest books to read and understand are those that tell you WHAT but not WHY. From the excellent reviews I've received (look at MLaden's review just posted), it appears to give plenty of WHY. I appreciate that very much. I'll be buying it tonight. Thanks again, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Ryan 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: Performance tuning book
experience for our students (see http://www.hotsos.com/courses/PD101.php, for example). With the book, Jeff and I have tried to lay out a system that enables a reader to determine whether the performance information he's getting at conferences, classes, books, magazines, etc. is valid or not. We have tried to raise the bar for what people consider to be an acceptable standard for an Oracle performance analyst to meet. We have tried to further stimulate the revolution of Oracle performance methods from the very weak and inefficient checklist-based methods to a more efficient scientific approach. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - SQL Optimization 101: 12/8-12 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Michael Milligan Sent: Tuesday, October 21, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Cary, I don't mean to ask you to brag, but can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? Does it teach different methodologies? Is it more readable? I'd be very interested in your own assessment. What did you try to accomplish with this book? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Transportable tablespaces
have they added the ability to rename tablespaces? this way you can publish data easier? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 9:39 PM Hi Listers Saw this on SearchOracle What new features are customers excited about in 10G? Abramson: What they've done is given you complete flexibility. They have introduced transportable table spaces, so all you have to do is export metadata and just copy files across during an upgrade. You don't have to do a full extraction. I've been in a situation were a company was on Sun and moving to HP, and they wanted to know how to do it. I told them that you just unload the database and reload the database. It sounds easy, but with two terabytes of data it's not unless you have transportable table spaces. Can anyone confirm that this is true, that is, the implication that I can copy a transportable tablespace from Sun to HP or vice versa without issue. I suppose then is it big endian - little endian constrained or not Cheers -- = 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 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = 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. -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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 pricing ain't going down
what is the microsoft,. sybase, and ibm database pricing? anyone know the differences in prices? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:24 PM http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: How to call unix shell scripts from 'C'?
the basics are they i want 'C' so i can use a file pointer. I need to do some search and replace in a group of files. If I use straight scripting I have to redirect the output to a new file and do a 'mv' to rename it back. with the filepointer, I was hoping to be to use fopen in C to open the file and then manipulate it with search and replace. not sure its possible. I Think you run into the same 'random access' issues you do in java. im pretty weak in C programming. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 12:14 PM If you want the C program and the spawned shell script to interact and communicate back and forth with each other, then you'd have to use the pipe() system call to set up a two-way interprocess-communication pipe in the C program, then call fork() to spawn a new identical process (including the IPC pipes), then finally exec() in the child process to bring the image of the desired shell running it's shell script in. Of course, each port of C has variations on those basic function call (i.e. exec() can be execv(), execve(), execle(), etc). If you're just going to have the C program spawn the shell script that will operate independently of its parent, you can just call the system() library call and be done with it... Hope this helps... -Tim The unix and C forums are pretty inactive. Hope its ok to ask this here. Anyone know how to do this? -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ryan 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: Your new book
of the authors shines through. The formal central section will put off some (maybe a significant number) of readers though. Stephen Hawking in 'A Brief History of Time' writes Someone told me that each equation I put in the book would halve the sales. I therefore resolved not to have any equations at all. In the end, however, I did put in one equation, Einstein's famous equation E=mc². Cary and Jeff have either not been given this advice, or ignored it in the interests of accuracy. The advantage that this gives is that the book has a formal methodology that puts others to shame - the disadvantage is that folk look at pages filled with equations full of queueing theory and Greek symbols and react badly. I hope that the advice is wrong, but fear that it may not be. Niall -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Michael Milligan Sent: 21 October 2003 17:49 To: Multiple recipients of list ORACLE-L Subject: Your new book Cary, I don't mean to ask you to brag, but can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it take a different approach? Does it teach different methodologies? Is it more readable? I'd be very interested in your own assessment. What did you try to accomplish with this book? TIA, Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net http://www.orafaq.net -- Author: Michael Milligan 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: who writes the OCP tests?
my point is that relative to 'execute immediate' how many people use utl_tcp? execute immediate isnt on the exam at all. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 2:04 PM I am using utl_tcp as we speak to send feeds out to our customers ... encrypted of course. We have a program that uses utl_http to go to espn.com, fetch data, filter out what we need and use that to populate the database. Yes, we do use it ... but I am not Oracle employee. Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, October 22, 2003 1:49 PM To: Multiple recipients of list ORACLE-L DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap everything in execute immediate(which wasnt on the test). How many people actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other features that werent covered. im done griping. This was REALLY bad. ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: Ryan 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 pricing ain't going down
i thought reads still block writes in sql server? doesnt this really hurt performance in high transaction databases? whaty is the pricing of sql server? We negotiated oracle pricing down to $22k/CPU and 22% cost for support/year. how much do the rest of you pay? We got our development server for $8000 for a 2 CPU box. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:24 PM Microsoft is approcimately 2/3rds the price for standard and 1/2 the price for EE IIRC. It also has about 80-90% of the functionality of Oracle. Oracle Std Edition One addresses all those single cpu servers you use on production systems. It wasn't just bad ms marketing that saw me advocating them in SA, Oracle really needs to wake up to the fact that it has a hideously overpriced product for 90% of the businesses out there. Std Edition One pricing is what Std Edition should be selling at IMO. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is the microsoft,. sybase, and ibm database pricing? anyone know the differences in prices? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:24 PM http://www.crn.com/sections/BreakingNews/daily archives.asp?ArticleID=4 5368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: Ryan 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: Niall Litchfield 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: Ryan 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 pricing ain't going down
http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp so sql server is $20k/CPU for the enterprise edition. how flexible are they in negotiating price? We got ours for $22k/CPU. any idea what the support costs are? I couldnt dig those up? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:24 PM Microsoft is approcimately 2/3rds the price for standard and 1/2 the price for EE IIRC. It also has about 80-90% of the functionality of Oracle. Oracle Std Edition One addresses all those single cpu servers you use on production systems. It wasn't just bad ms marketing that saw me advocating them in SA, Oracle really needs to wake up to the fact that it has a hideously overpriced product for 90% of the businesses out there. Std Edition One pricing is what Std Edition should be selling at IMO. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is the microsoft,. sybase, and ibm database pricing? anyone know the differences in prices? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:24 PM http://www.crn.com/sections/BreakingNews/daily archives.asp?ArticleID=4 5368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: Ryan 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: Niall Litchfield 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: Ryan 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 full scan over an index fast full scan in an analytic function?
why would you not need a sort with a full index scan and need one with a fast full scan? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 5:19 PM function? Possibly to avoid a sort operation (assuming that you might be able to get away with a NOSORT when doing the full index scan)? It might be deciding that the benefit of the multi-block reads for the fast full scan are more than offset by the sort operation that would be needed (and might not be needed when doing the full index scan). Regards, Larry G. Elkins The Elkins Organization Inc. [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: index full scan over an index fast full scan in an analytic function? i cant attach the 10053 trace. it has proprietary info. There isnt much in analytic explain plan either. does anyone know in general why a full scan would be faster than a fast full scan? From: [EMAIL PROTECTED] Date: 2003/10/23 Thu PM 03:09:26 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: index full scan over an index fast full scan in an analytic function? I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index scan? select * from (select col1, col2, dense_rank() over (partition by col1 order by col2 desc)tab from mytable) where tab = 1 -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Larry Elkins 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: Ryan 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 pricing ain't going down
what is MSEE lacking in? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 8:14 PM Niall When I reviewed the options, it seemed that if you were in the market for SQL Server, then Oracle SE was more the choice for you. While MS has copied the SE and EE terms (and I see IBM has also), I really didn't find MS EE comparable to Oracle EE. More like MS EE vs. Oracle SE. Then the pricing is actually in Oracle's favor, IIRC. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 5:24 PM To: Multiple recipients of list ORACLE-L Microsoft is approcimately 2/3rds the price for standard and 1/2 the price for EE IIRC. It also has about 80-90% of the functionality of Oracle. Oracle Std Edition One addresses all those single cpu servers you use on production systems. It wasn't just bad ms marketing that saw me advocating them in SA, Oracle really needs to wake up to the fact that it has a hideously overpriced product for 90% of the businesses out there. Std Edition One pricing is what Std Edition should be selling at IMO. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 23 October 2003 00:29 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is the microsoft,. sybase, and ibm database pricing? anyone know the differences in prices? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 5:24 PM http://www.crn.com/sections/BreakingNews/daily archives.asp?ArticleID=4 5368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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: Ryan 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: Niall Litchfield 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: 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: Ryan 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
Re: Refresh option for Materialized view , want to use it during refresh - for
-- Author: David Boyd 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: Ryan 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: Refresh option for Materialized view , want to use it during refresh - for
, mc.segment1 product_family, mc.segment2 product_type FROM [EMAIL PROTECTED] mcs, [EMAIL PROTECTED] mc, [EMAIL PROTECTED]mic, [EMAIL PROTECTED] msi where 1=1 and mc.structure_id = 50112 and mc.segment3 != 'SPARE' and mc.global_name= 'US' and mc.enabled_flag = 'Y' and mcs.global_name = mc.global_name and mcs.category_set_name = 'PROD GROUP' and mic.category_set_id = mcs.category_set_id and mic.category_id = mc.category_id and mic.global_name = mc.global_name and mic.organization_id = 1 and mic.inventory_item_id = msi.inventory_item_id and msi.organization_id = mic.organization_id and msi.global_name = mc.global_name AND msi.auto_created_config_flag = 'N' AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG SUB','FEATURE PACK','PRODUCT LIST$0','PTO MODEL','SPARE') and msi.inventory_item_status_code IN ('ENABLE-MAJ','ENABLE-NON','ENABLE-OPT','NONORD') Please note that the tables referenced are remote tables and Oracle Apps tables and not logging on it is possible. Please suggest an appropriate refresh mechanism to see the records even during refresh period. Thanks in advance. With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED] _ Cheer a special someone with a fun Halloween eCard from American Greetings! Go to http://www.msn.americangreetings.com/index_msn.pd?source=msne134 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd 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: Ryan 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: Arup Nanda 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: Ryan 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: What happened to Howard Rogers ?
is that copyright thing something unique to Australia? I dont think they can claim that in the US unless you sign some documents first. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 25, 2003 4:39 PM Howard's response is below. Hopefully this makes things clearer for those who are still interested. I worked for Oracle for 4 years, producing my own stuff in my own time, to elaborate on questions that perplexed me, and about which I would often get asked by Oracle course students -because the official material either didn't cover it, covered it badly, or just plain mis-informed. Oracle claimed copyright on the lot, so I had to remove the material (Lydian Third is a site which copied the lot first, and despite repeated requests still hasn't removed it). In June this year, I asked for permission to have a website again, offering to have all material and content vetted by anyone Oracle cared to choose for the job, before it went up. They refused. I also asked for permission to stay at home when I wasn't training, so that I could do research on Oracle matters. They refused that too. In August, I therefore resigned. I finished work *for* Oracle on October 6th. I had two weeks of leisure, and now I contract back to Oracle, teaching much as before. Only this time, I get to write my own material, and when I'm not training, I can stay at home and do real research. I was never sacked by Oracle. Regards HJR -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Ryan 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: What happened to Howard Rogers ?
im pretty sure you have to sign papers. you cant steal material from your employer, but Ive never heard of someone getting sued by an employer over it unless they sign an employment agreement. supposedly employers in the US have lost in court when they try to make employees reimburse them for security clearances even if employees signed agreements to stay for a period of time and quit before that. I dont know that for certain though. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, October 26, 2003 9:39 AM No the copyright thing isn't unique to Australia. In the UK (I have the advantage of being married to an Intellectual Property lawyer) then broadly anything that you produce that is in the course of your employment would by default belong to your employer and not to you. We both suspect that in the UK someone who was employed to provide training and education in Oracle would also find that any training and education stuff they themselves produced would belong to their employer. It may or may not be different if they were employed as, say a developer. I would be amazed if the same wasn't true in the US, which is after all the land that can patent clicking :(. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sent: 25 October 2003 23:14 To: Multiple recipients of list ORACLE-L Subject: Re: What happened to Howard Rogers ? is that copyright thing something unique to Australia? I dont think they can claim that in the US unless you sign some documents first. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 25, 2003 4:39 PM Howard's response is below. Hopefully this makes things clearer for those who are still interested. I worked for Oracle for 4 years, producing my own stuff in my own time, to elaborate on questions that perplexed me, and about which I would often get asked by Oracle course students -because the official material either didn't cover it, covered it badly, or just plain mis-informed. Oracle claimed copyright on the lot, so I had to remove the material (Lydian Third is a site which copied the lot first, and despite repeated requests still hasn't removed it). In June this year, I asked for permission to have a website again, offering to have all material and content vetted by anyone Oracle cared to choose for the job, before it went up. They refused. I also asked for permission to stay at home when I wasn't training, so that I could do research on Oracle matters. They refused that too. In August, I therefore resigned. I finished work *for* Oracle on October 6th. I had two weeks of leisure, and now I contract back to Oracle, teaching much as before. Only this time, I get to write my own material, and when I'm not training, I can stay at home and do real research. I was never sacked by Oracle. Regards HJR -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: Ryan 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: Niall Litchfield 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
question parallel query used by SMON
Im studying for the backup and recovery exam. One quesiton from self test software states that SMON will use parallel query when it detects a dread transaction with a 'large number' of rollback blocks. my questions: 1. is the number of parallel query slaves it uses based on my parallel max servers? I have been setting this very high because there are times when I need it. I didnt see any harm in it. Im concerned that a large rollback might suck up too many resources. 2. What is considered a 'large number' of rollback blocks?
Re: Re: explain plan conundrum
the data is very skewed, but i included 'for all indexes' and for all indexed columns. doesnt that create histograms? or do i have the syntax wrong. what i really needed was histograms, Ill bet. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 5:04 PM First I would take a look at the papers posted at Wolfgang Breitling's site http://www.centrexcc.com/ Next, try and compare the number of rows the optimizer expects to bring back at each step (cardinality as seen in explain plan), to the actual number returned (rows as seen in sql_trace=true -- tkprof; or manually do each part of the query, but be careful because of the filtering). Focus in on a discrepency between these two methods. That is where the optimizer is being fooled. It might be because of bad statistics, skewed data, init.ora settings, ... Henry -Original Message- [EMAIL PROTECTED] Sent: Tuesday, November 04, 2003 3:29 PM To: Multiple recipients of list ORACLE-L everything is analyzed. For all indexes, for all indexed columns. I used analyze. its the same as dbms_stats, just not as robust. I use it when I dont feel like typing out dbms_stats. Are there optimizer parameters that help the optimizer determine join order? Ive never had to use the 'ordered' hint on the CBO before when everything is analyzed. The difference was huge. Ran for 2 hours and still going, with the hint ran in 45 seconds. im assuming there are some init.ora parameters that I should check out? Does oracle take into account 'distinctness' of the columns being joined? I have 1 table with 366,000 rows and another with 5,000 rows. the columns being joined have 4 distinct values each. However, the table with 366,000 rows joins on its primary key to another table and that filters out enough rows that that join should go first. The optimizer made a bad decision. how do i analyze why it made a bad join order decision? hints like this are a stop gap fix. From: Yong Huang [EMAIL PROTECTED] Date: 2003/11/04 Tue PM 02:09:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: explain plan conundrum Hi, Ryan, Where's the 20 billion rows? There's 1 G rows and 20 G bytes. What are the values of NUM_ROWS in xxx_INDEXES for PK1 and xxx_TABLES for TABLE2? Did you analyze using ANALYZE command or DBMS_STATS? Yong Huang --- [EMAIL PROTECTED] wrote: I cant sql trace it now. I hae run statspack. this query is running now and I dont want to run another copy with a trace on until this finishes, since I dont want to suck up resources. Im at a loss as to where the 20 billion rows comes from in this explain plan? Everything including the indexes are analyzed. when the two tables involved have 36k and 5k rows involved. looks like some form of cartesian join, but its not showing up in the plan. The two tables are joined by a column. any place to look on this? I know I need the 10046 trace, but I cant get that yet and it make take 12 hours to get it after this runs. select col1, col2, col3 from tab1 tab2 where tab1.col1 = tab2.col2; Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop SELECT STATEMENT Optimizer Mode=CHOOSE 1 G 237 HASH JOIN 1 G 20G 237 INDEX FAST FULL SCAN PK1 5 K 11 K 3 TABLE ACCESS FULL TABLE2 366 K 4 M 231 __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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). -- Please