connection using secureID tokens and JDBC thin
dear list, The setup: app server 9ias 1.0.2.2.2a db server 9i R2. The application Our app connects to the DB using JDBC thin, a simple app showing fields and inserting data into underlying tables. The problem All was working fine, then the management asked us to use RSA/ACE security using Token cards, we have implemented everything and all works fine, we CAN connect from the IAS to the DB using sql*plus and providing the passcode, BUT out application (using JDBC thin)is not able to connect !!! "invalid username or password"!!! we have another back office app connecting to the DB using web forms 6i, which also has the same problem after we setup secureID. again, we have no prolems connecting from SQL*PLUS using secureID passcodes please advise -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775.-
Re: char(1) VS varchar2(1)
Hi! Trailing columns with NULL values do not occupy any space, not even a length byte. Yep, I missed this one. Also, when few trailing null columns aren't stored in a row, this particular rows column count is smaller as well, so the column count in physical table storage can vary... Non-trailing columns with NULL values have a constant value of 0xFF (255) in the length byte consuming just the one byte. Yep, and this means that even fixed-length CHAR datatypes don't consume any space except length byte if they contain nulls. I once saw a recommendation to store your data in char columns if you don't want to have to worry about row size changes and PCTFREE setting... which is mostly a stupid suggestion anyway and doesn't work in case of nulls either. Tanel. P.S. Tim, I assume that we'll meet at RMOUG training days this Feb? -- 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).
Question about datatypes
Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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).
Antw: Question about datatypes
Hej Roland (Sverige?), I doubt that. If all the data is number in the varchar2 column, well, you don't need it to be varchar2. The easiest solution seems to be: INSERT INTO newtable SELECT TO_NUMBER(col) FROM oldtable; Premise: all your data in that column IS number. If you're not sure, do some pl/sql to identify the erroneous rows and track them in another table for correction purposes. hth, Guido [EMAIL PROTECTED] 03.11.2003 11.14 Uhr Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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).
datatypes varchar to number
Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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).
RE: datatypes varchar to number
What's the data like in the varchar field? Is it in number format? A quick sample would be good. -Original Message- [EMAIL PROTECTED] Sent: 03 November 2003 11:14 To: Multiple recipients of list ORACLE-L Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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: datatypes varchar to number
In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Hope this would be of anyhelp Rolabd Mark Leith [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: Sent by: Subject: RE: datatypes varchar to number [EMAIL PROTECTED] .com 2003-11-03 12:24 Please respond to ORACLE-L What's the data like in the varchar field? Is it in number format? A quick sample would be good. -Original Message- [EMAIL PROTECTED] Sent: 03 November 2003 11:14 To: Multiple recipients of list ORACLE-L Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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).
Re: Question about datatypes
Trigger using TO_NUMBER function would be the first thing that comes to mind. I have designs like that, which are used for parsing so calld Bloomberg files. Those files contain strings like N.A., -,|| ('|' is the field delimiter) and all of those strings mean NULL. Also, stock split ratio can be described as: 1:2, 1/2, 2 for 1, 0.5, which has to be mapped to a number field. I'm using perl to parse the input files and I'm using crontab to schedule perl script exectuion. On 2003.11.03 05:14, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). -- 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).
Datatype conversions
Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- 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).
RE: Win termin services alert
Niall, LINDESK isn't the flaw, it is the method that the server handled the request from a non-windows browser. They have fixed the problem and the application now works from any OS browser. I ment the info to be a potential security alert. Ron [EMAIL PROTECTED] 10/31/03 03:49PM I'm not entrely sure what you are saying here. Terminal Services gives you a remote session on the server. You should have to provide a username and password for this. When you get desktop access it is in the security context of the username/password you have provided. If you had full control that rather suggests that they had provided you with an inappropriate username/password. If I log into a server as root using ssh, I don't consider that to be a flaw in ssh. Now I might be misunderstanding what you are saying here, and it could be that LINDESK doesn't honour the credentials you provide it with, but this also doesn't seem like a terminal services flaw... Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Rogers Sent: 31 October 2003 14:05 To: Multiple recipients of list ORACLE-L Subject: Win termin services alert List. Reguarding Windows Terminal services... It is used to remotely display an action back to the requesting windows client with software control. Usually used in a browser application. We have an application that is browser based and we are instructed to use Windows 2000K as the client. I feel that if an application is browser based I should be able to use and client and browser. I used a browser on Linux with a windows terminal services package installed and connected to the server via a login/passwd with a browser. The problem occured when the software control didn't work and I was dropped to the server desktop. I had full control over the server. I immediatly contacted security... Please be aware of this potential and serious security problem using terminal services. The terminal services package I tested was the LINDESK for linux. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Ron Rogers 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 about datatypes
Yes but how should I write the sql statement when to make the incoming varchar2 field into a number? Roland Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Re: Question about datatypes [EMAIL PROTECTED] .com 2003-11-03 13:19 Please respond to ORACLE-L Trigger using TO_NUMBER function would be the first thing that comes to mind. I have designs like that, which are used for parsing so calld Bloomberg files. Those files contain strings like N.A., -,|| ('|' is the field delimiter) and all of those strings mean NULL. Also, stock split ratio can be described as: 1:2, 1/2, 2 for 1, 0.5, which has to be mapped to a number field. I'm using perl to parse the input files and I'm using crontab to schedule perl script exectuion. On 2003.11.03 05:14, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). -- 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: 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: Datatype conversions
This should be helpful, SQL create table tt1 (c1 varchar2 (30)); Table created. SQL insert into tt1 values ('123,50'); 1 row created. SQL insert into tt1 values ('44567,9'); 1 row created. SQL insert into tt1 values ('1,23456'); 1 row created. SQL commit ; SQL select * from tt1 ; C1 -- 123,50 44567,9 1,23456 SQL l 1 select to_number ( substr(c1,1,(instr(c1,',')-1))||'.'|| 2 substr(c1,(instr(c1,',')+1),length(c1)) 3 ) converted_number 4* from tt1 SQL / CONVERTED_NUMBER 123.5 44567.9 1.23456 SQL create table tt2 (c1 number (15,5)); Table created. SQL insert into tt2 value (select to_number ( substr(c1,1,(instr(c1,',')-1))||'.'|| 2 substr(c1,(instr(c1,',')+1),length(c1)) 3 ) converted_number 4 from tt1) 5 / 3 rows created. SQL commit; Commit complete. SQL select * from tt2 ; C1 -- 123.5 44567.9 1.23456 SQL HTH, Rajesh Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Monday, November 03, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Subject:Datatype conversions Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- 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: 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).
RE: connection using secureID tokens and JDBC thin
Rahul My understanding is that the JDBC thin client does not use Net8 across the network, but just connects directly to the listener. For example, on client systems that use thin client, I have not had to configure a tnsnames.ora. The way I understand secureID works, something on the client authenticates the connection to the server. My guess, and it is just a guess, since I've never worked with secureID, is that you will have to switch to thick client which uses Net8 to handle the connection. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 3:44 AM To: Multiple recipients of list ORACLE-L dear list, The setup: app server 9ias 1.0.2.2.2a db server 9i R2. The application Our app connects to the DB using JDBC thin, a simple app showing fields and inserting data into underlying tables. The problem All was working fine, then the management asked us to use RSA/ACE security using Token cards, we have implemented everything and all works fine, we CAN connect from the IAS to the DB using sql*plus and providing the passcode, BUT out application (using JDBC thin) is not able to connect !!! invalid username or password !!! we have another back office app connecting to the DB using web forms 6i, which also has the same problem after we setup secureID. again, we have no prolems connecting from SQL*PLUS using secureID passcodes please advise -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] or contact us on (62 21) 522 8775. - -- 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).
RE: wither Designer documentation?
Oracle's response is that the Designer documentation is all in the online help. That this decision was made for Designer 2.0, in 1998. Patrice. -Original Message- Sent: Tuesday, October 28, 2003 2:29 PM To: Multiple recipients of list ORACLE-L I have had the same problem. I have contacted Oracle for a user guide with no response as of yet. I am literally printing off the help pages within Designer to address the need. It sucks 10/28/2003 10:14 AM PST Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Where is the Designer 9i documentation? Not on OTN (http://otn.oracle.com/documentation/designer.html), not in download-east (http://download-east.oracle.com/docs/cd/A91773_01/ids902dl/index.htm ), not in tahiti... (http://tahiti.oracle.com ) Oracle Designer Generation seems to be the only book (Oracle Press). Oracle Designer Handbook by Pete Koletzke was published in 1998. 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). American Express made the following annotations on 10/28/2003 11:27:28 AM -- ** 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: 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).
Re: Datatype conversions
Can you re-post this question several more times? We didn't get it yet. Thanks in advance for your understanding. On 11/03/2003 07:29:40 AM, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- 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). Mladen Gogala Oracle DBA 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).
RE: Finding overlapping time periods - suggestions please
Mladen, Unfortunately, the density of your proposed option has warped the space continuum around us and made this option unusable... That and the fact I would have to take two years of University Mathematics to fully comprehend and appreciate the theory, makes this less than optimal in terms of time and space :-) ** Thanks to Stephane and Waleed. *** I will look into those approaches. Another approach that was suggested was to find all distinct intervals (a start time or end time), and then for EACH interval find the number of activities and calculate minutes accordingly. For example the data below, 1) the distinct intervals are 10:00-11:00, 11:00-11:30, 11:30-12:00, 12:00-13:00, 13:00-13:30, 13:30-16:00. 2) During the 10:00-11:00 (60 min) interval there was ONE task active, find the task and allocate 60 minutes elapsed and single minutes, 0 multiminutes 3) During the 11:00-11:30 interval there were 2 tasks active. Find each and allocate 30 elapsed minutes, 30 multi minutes, 15 prorated mutli minutes. 4) During the 11:30-12:00 intervaal there were 3 tasks active. Find each and allocate 30 elapsed minutes, 30 mutliminutes, 10 prorated mutli minutes. Etc. ActivityStart---End---Elapsed---ElapsedElapsed--Prorated--Prorated TimeTime--Minutes---Mutlitask--Single---Multi-Minutes MinutesMinutes--Minutes 1---10:00---12:00--120--060-60--2585 3---11:00---13:00--120--120--0--5555 4---11:30---13:30--120--090-30--4070 7---13:30---16:00--1500150---0---150 Babette -Original Message- Sent: 2003-11-01 11:59 AM To: Multiple recipients of list ORACLE-L Mladen, If you suggest a convoluted solution like this takes water when you have several million rows I fully agree :-). Funny enough, because it really looks like a purely relational problem, and yet it requires bending backwards. My feeling (and it definitely would deserve time to prove) is that quite possibly it's a design issue - perhaps the proper way would not be to say 'this activitity started then and ended then' but 'at this point in time that activity was running'; in fact, the convoluted part of what I suggest roughly means to do that, changing the design on the fly. SF Mladen Gogala wrote: Stephane, my solution was suggested because the client was a telco which was offering each client billing period of their own choosing (weekly, bi-weekly, monthly) starting whenever the client wanted. Finding which calls fall in the certain period was a major hassle. Of course, the solution like the one that I've suggested (and I don't know whether it would really work) would not make sense for 3 time periods altogether. What they've ended up implementing was a bunch of external procedures based on C and bitmaps, which is, accidentally, similar in concept to my solution. On 2003.11.01 08:09, Stephane Faroult wrote: [EMAIL PROTECTED] wrote: I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently. Here is the scenario: Elapsed minutes refer to the actual clock time either spent on a given task. Thus an activity that started at 9:00 am and finished at 11:00 am on the same day is said to have 120 elapsed minutes. If one task overlaps another (either completely or partially with another task), then the tasks are said to be multitasked. In that case the system will store the portion of the elapsed time that was multitasked as elapsed multitask minutes and the portion of the time that was not overlapped as elapsed single minutes. In addition, for the portion of time that two or more activities were simultaneously taking place; their time will be divided by the number of simultaneous activities and stored as prorated multi minutes. The sum of Elapsed Single Minutes and Prorated Minutes will equal the actual clock time that a vehicle was active. The following example should help to illustrate these concepts. In the table below a list of fictitious activities for a vehicle are shown in addition to how the time is allocated to the various measures: ActivityStart Time End TimeElapsed Minutes Elapsed Multitask Minutes Elapsed Single Minutes Prorated Multi Minutes Prorated Minutes 1 10:00 12:00 120 60 60 25 85 3 11:00 13:00 120 120 0 55 55 4 11:30 13:30 120 90 30 40 70 7 13:30 16:00 150 0 150 0 150 Totals 510 270 240
Re: Datatype conversions
INSERT INTO new_table(price) SELECT REPLACE(price, ',' ,'.') FROM old_table; Rick Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Datatype conversions [EMAIL PROTECTED] .com 11/03/2003 08:54 AM Please respond to ORACLE-L Can you re-post this question several more times? We didn't get it yet. Thanks in advance for your understanding. On 11/03/2003 07:29:40 AM, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- 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). Mladen Gogala Oracle DBA 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:
Re: Export Split Script (FAO LISA)
Hi Not sure what the original question was BUT the script offered splits exports so you may be interested in a tool Kurt van Meerbeeck and Kugendran Naidoo wrote called Ora*PePi availbale on sourceforge - the description from there reads: quote Ora*PePi is a superset of the Oracle export/import tools - providing simultaneous synchronised parallel export and import, NET8 load balancing, at runtime adjustable parallel degree and large table run ratio, down to partition level. /quote The link is http://sourceforge.net/projects/pepi hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Datatype conversions
in European notation, the , is used where Americans use a . and vice versa. makes for interesting reading of white papers but the replace statement below will distort the data being entered --- [EMAIL PROTECTED] wrote: INSERT INTO new_table(price) SELECT REPLACE(price, ',' ,'.') FROM old_table; Rick Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Datatype conversions [EMAIL PROTECTED] .com 11/03/2003 08:54 AM Please respond to ORACLE-L Can you re-post this question several more times? We didn't get it yet. Thanks in advance for your understanding. On 11/03/2003 07:29:40 AM, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- 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). Mladen Gogala Oracle DBA 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:
Re: Redo log corruption
Shibu, I'd go ahead and check your system according to the bug (it may or may not be present, my memory is a little foggy on the issue). If it is only 1 log, I would look to some other cause (disk), but if you find the corruption in several logs, it points to something inside the db (not always, but a good place to start). Daniel Shibu MB wrote: Dan , My oracle version is as given below BANNER Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production PL/SQL Release 8.1.7.3.0 - Production CORE8.1.7.0.0 Production TNS for IBM/AIX RISC System/6000: Version 8.1.7.3.0 - Production NLSRTL Version 3.4.1.0.0 - Production I saw one document in metalink which says about bug in 7.3 but i did not see anything for 8i . Thanks Shibu -Original Message- From: Daniel W. FInk [mailto:[EMAIL PROTECTED] Sent: Fri 10/31/2003 10:09 PM To: Multiple recipients of list ORACLE-L Cc: Subject: Re: Redo log corruption Shibu, What version of Oracle? There is a 7.x bug where mismatches in asynch i/o read/write corrupted the logs. I don't recall if I encountered it in 8i as well, but there is something in the back of my mind saying it may still exist in later releases. Daniel Fink Shibu MB wrote: Hi all , While applying archive logs to my standby database i got theerror ORA-00353: log corruption near block 207725 change 111482169731153 time 10/25/2003 12:14:01 Can anybody tell me how archive logs can get corrupted ?? How can i avoid oracle from generating corrupted archive logs ??How can i check the health of archive logs ?? Please help !. TIA Shibu Alphawest Disclaimer --- If this communication is not intended for you and you are not an authorised recipient of this email you are prohibited by law from dealing with or relying on the email or any file attachments. This prohibition includes reading, printing, copying, re-transmitting, disseminating, storing or in any other way dealing or acting in reliance on the information. If you have received this email in error, we request you contact Alphawest immediately by returning the email to [EMAIL PROTECTED] and destroy the original. This email is confidential and may contain privileged client information. Alphawest has taken reasonable steps to ensure the accuracy and integrity of all its communications, including electronic communications, but accepts no liability for materials transmitted. --- DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. Name: winmail.dat winmail.datType: application/ms-tnef Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. FInk 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). DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and
test
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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).
anyone have success with semi-joins?
I picked up Mark Gurry's SQL pocket reference on Friday and it states that you can radically improve performance of 'where exists' statements by using semi-joins since it only returns the sub-query ones. Now logically you have to return the sub-query repeatedly, this would only come into play if there are duplicates right? anyone know the algorithm for the semi-join? Not just the result? I cant find it anywhere. anyone ever hint this or let oracle decide? -- 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).
Sequences in OPS/RAC
I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Sequences in OPS/RAC
Hemant, I would guess that this is true if you are caching values for the sequence. Each database instance might cache the same set of values. Turn sequence caching off, and I would think that the problem goes away. Havn't tried this in awhile, but it makes sense. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, November 03, 2003 10:39 AM To: Multiple recipients of list ORACLE-L I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
RE: Sequences in OPS/RAC
me don't think so. 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: Monday, November 03, 2003 10:39 AM To: Multiple recipients of list ORACLE-L I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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. **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).
Re: Question about datatypes
If the data is really a number ( ie. no alpha characters ) you don't need to do anything, Oracle does an implicit conversion. insert into my_table_numeric( real_number_column ) select my_stupid_varchar2_col from I_hope_these_are_all_numeric_table / Jared On Mon, 2003-11-03 at 04:44, [EMAIL PROTECTED] wrote: Yes but how should I write the sql statement when to make the incoming varchar2 field into a number? Roland Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .netcc: Sent by: Subject: Re: Question about datatypes [EMAIL PROTECTED] .com 2003-11-03 13:19 Please respond to ORACLE-L Trigger using TO_NUMBER function would be the first thing that comes to mind. I have designs like that, which are used for parsing so calld Bloomberg files. Those files contain strings like N.A., -,|| ('|' is the field delimiter) and all of those strings mean NULL. Also, stock split ratio can be described as: 1:2, 1/2, 2 for 1, 0.5, which has to be mapped to a number field. I'm using perl to parse the input files and I'm using crontab to schedule perl script exectuion. On 2003.11.03 05:14, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
Re: Sequences in OPS/RAC
In the Oracle9i Real Application Clusters Administration manual, there is a chapter about sequence numbers generator. Before believing to the snake oil sellers, read the fine manual. Sequence numbers are guaranteed to be unique PER DATABASE. What they're not guaranteed is to come in ordered fashion. When sequence number are cached (that is the default), they're cached separately, for each instance. Each instance returns the contents of its cache, so it is possible for the smaller number being returned after a larger one. There is ORDERED flag to deal with that, but that can be extremely expensive and impose significant overhead on your cluster. On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote: I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Mladen Gogala Oracle DBA 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).
Re: Sequences in OPS/RAC
Sequences are mastered by the single SYS.SEQ$ table in each database. Cached or uncached, RAC or non-RAC, OPS or non-OPS, sequence numbers generated by this mechanism are unique across a database, not by instance. Each instance updates SEQ$ as individual numbers (noncached) or ranges of numbers (cached) are reserved, and those updates are controlled by the same synchronization mechanisms used by OPS/RAC for all UPDATE statements. This is precisely the reason that setting CACHE on sequence numbers help performance, as the number of updates to SEQ$ are reduced, minimizing the bottleneck. However, because of the simplicity of this caching mechanism, sequence numbers are not guaranteed to be in order (i.e. sequentially ascending) across multiple instances. Perhaps Mr. Stephens mis-spoke, confusing uniqueness for ordering? Or perhaps he is confusing distributed databases for clustered databases? I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
RE: Clone db 9.2 on AIX 5L
thanks for the info Muqthar Ahmed, I will follow the steps and let you know what happens, thanks again! Saludos, Verónica Levin Enríquez GTI Compañía Cervecera de Nicaragua -Mensaje original- De: Muqthar Ahmed [mailto:[EMAIL PROTECTED] Enviado el: Friday, October 31, 2003 11:19 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Clone db 9.2 on AIX 5L Veronica, There are two different types of installation CDs for Oracle 8.1.7: 1. Oracle 8.1.7 64-bit and 2. Oracle 8.1.7 Oracle cerfitied 8.1.7(32-bit) for 5L not for Oracle 8.1.6 64-bit. If you have Oracle 8.1.7(32-bit), then you can upgrade AIX 4.3.3 to AIX 5L: 1. Upgrade OS from AIX 4.3.3 to AIX 5L 2. Install the following AIX 5L OS patches as required by the Installation Guide, refer to Note: 169706.1: IY26778(5100-01) IY28766(5100-01) IY28949(5100-01) IY29965(5100-02) IY30150(5100-02) Maint Level 1 and IY22854 Required OS packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat 3. Install Oracle 8.1.7 for AIX 5L from CDs into new ORACLE_HOME 4. Copy init.ora to new ORACLE_HOME and modify the init.ora to change dump directories, 5. Setup your environment to point to new ORACLE_HOME and start the databases. I would recommend you to open a TAR with Oracle Support. Muqthar Ahmed -Original Message- Sent: Friday, October 31, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hi Muqthar , I am planning to upgrade from AIX 4.3.3 to AIX 5L (5.2), but I am not planning to upgrade Oracle. I am at 8.1.7.2 and can't upgrade to 9i yet due to applications compatibility Do I have to upgrade Oracle to 9i if I upgrade AIX to 5L I understand Oracle 8.1.7.2 can run on AIX 5L at 32 bits without problems. Saludos, Verónica Levin Enríquez GTI Compañía Cervecera de Nicaragua -Mensaje original- De: Muqthar Ahmed [mailto:[EMAIL PROTECTED] Enviado el: Tuesday, October 28, 2003 12:00 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Clone db 9.2 on AIX 5L Hi, You DO NOT have to CLONE the databases if you are upgrading the OS from 4.3.3 to 5L. You mentioned that the instances are already running. IBM has break the technology at AIX 5.1.0.0, meaning the AIX 4.3.3 and AIX 5.1.0.0 have different architecture. So if you are upgrading IBM AIX 4.3.3 to AIX 5.1.0.0, you also have to upgrade Oracle at the same time. Oracle 9.2 CDs are separate for IBM AIX 4.3.3 and IBM AIX 5.1.0.0. If you are in this situation, all you have to is shutdown all databases, install Oracle 9.2 with 5L CDs in new ORACEL HOME and setup your environment with new ORACLE HOME to start your existing databases. Muqthar Ahmed -Original Message- Sent: Tuesday, October 28, 2003 11:49 AM To: Multiple recipients of list ORACLE-L SQL @cr_spap SQL STARTUP NOMOUNT pfile=/iu33/u01/app/oracle/admin/spap/pfile/initspap.ora ORA-03113: end-of-file on communication channel SQL CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG 2 MAXLOGFILES 50 3 MAXLOGMEMBERS 5 4 MAXDATAFILES 100 5 MAXINSTANCES 1 6 MAXLOGHISTORY 226 7 LOGFILE 8 GROUP 1 '/iu33/u02/oradata/spap/redo01.log' SIZE 100M, 9 GROUP 2 '/iu33/u02/oradata/spap/redo02.log' SIZE 100M, 10 GROUP 3 '/iu33/u02/oradata/spap/redo03.log' SIZE 100M 11 DATAFILE 12 '/iu33/u02/oradata/spap/system01.dbf', 13 '/iu33/u02/oradata/spap/undotbs01.dbf', 14 '/iu33/u02/oradata/spap/drsys01.dbf', 15 '/iu33/u02/oradata/spap/example01.dbf', 16 '/iu33/u02/oradata/spap/odm01.dbf', 17 '/iu33/u02/oradata/spap/tools01.dbf', 18 '/iu33/u02/oradata/spap/users01.dbf', 19 '/iu33/u02/oradata/spap/xdb01.dbf', 20 '/iu33/u02/oradata/spap/users02.dbf', 21 '/iu33/u02/oradata/spap/users03.dbf', 22 '/iu33/u02/oradata/spap/users04.dbf', 23 '/iu33/u02/oradata/spap/users05.dbf', 24 '/iu33/u02/oradata/spap/indexes01.dbf', 25 '/iu33/u02/oradata/spap/indexes02.dbf', 26 '/iu33/u02/oradata/spap/indexes03.dbf' 27 CHARACTER SET WE8ISO8859P1 28 ; CREATE CONTROLFILE REUSE DATABASE SPAP RESETLOGS NOARCHIVELOG * ERROR at line 1: ORA-03114: not connected to ORACLE SQL -- RECOVER DATABASE SQL -- ALTER DATABASE OPEN; SQL -- ALTER TABLESPACE TEMP ADD TEMPFILE '/iu33/u02/oradata/spap/temp01.dbf' SIZE 3119M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE ; SQL The confusing thing is that I have instances already running on the machine. So I know the install is ok. I can start/shutdown the existing instances no problem. But when I try to clone and startup --- I get the results from above. -Original Message- Sent: Monday, October 27, 2003 5:24 PM To: [EMAIL PROTECTED] When are you getting the error? During startup? Adam John Blake [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/27/2003 03:04 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Clone db 9.2 on AIX 5L Sorry, AIX 5L to AIX 5L cold backup copies create backup
Re: Sequences in OPS/RAC
Yes, I've been aware of the difference between ORDERED and CACHED. However, the Builder.Com article quite explicity asserts Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts As Tim has pointed out earlier, the author of the article might have confused uniqueness with ordering. {I've sent copies of the builder.com article by seperate emails to Raj and Tim} Hemant At 07:59 AM 03-11-03 -0800, you wrote: In the Oracle9i Real Application Clusters Administration manual, there is a chapter about sequence numbers generator. Before believing to the snake oil sellers, read the fine manual. Sequence numbers are guaranteed to be unique PER DATABASE. What they're not guaranteed is to come in ordered fashion. When sequence number are cached (that is the default), they're cached separately, for each instance. Each instance returns the contents of its cache, so it is possible for the smaller number being returned after a larger one. There is ORDERED flag to deal with that, but that can be extremely expensive and impose significant overhead on your cluster. On 11/03/2003 10:39:26 AM, Hemant K Chitale wrote: I have always been comfortable with the idea that Sequences continue to guarantee uniqueness even in OPS / RAC environments. However, a recent Builder.Com article by Scott Stephens on the SYS_GUID function has these lines : Sequence generator numbers are guaranteed to be unique only for a single instance, which is unsuitable for use as a primary key in parallel or remote environments, where a sequence in each environment might generate the same number and result in conflicts. An identifier created by SYS_GUID is guaranteed to be unique for each database. Huh ?! Do the lines mean that a single sequence can have duplicate values in the two instances of an RAC cluster ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). Mladen Gogala Oracle DBA 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: What is a local write wait?
Thanks KG. There were underlying OS I/O issues. The SA is looking to fix the same. Regards Raj __ Rajesh L. Rao DCI - Triad, Oracle DBA IBM Global Services, JPMC Account Phone: 516 5746065 E-mail: [EMAIL PROTECTED] K Gopalakrishnan To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: What is a local write wait? o.com Sent by: [EMAIL PROTECTED] ity.com 11/01/2003 09:54 AM Please respond to ORACLE-L Rajesh: Typically DBWR has to free up some buffers when you want to read something from the disk. During this process there are chances that you will be waiting for your local buffer (i.e blocks dirtied/invalidated by your session) to be written to disk. During this time the waits are shown as local write waits. BTW do you have any other write waits or just seeing local waits? And also are you noticing any timeouts for this waits? Typically we wait for local wait up to one second and spin (or retry) again.. Timeouts for local write indicates a serious problem unless you have tiny buffer cache or extremely slow disk' KG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 01, 2003 12:54 PM Was creating an index with a degree of 4, and in unrecoverable manner? There were few waits for an event called local write wait. Can anyone shed more light on this wait? Thanks Raj -- 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).
Re[2]: Sequences in OPS/RAC
Hello Hemant, Monday, November 3, 2003, 11:29:26 AM, you wrote: HKC However, the Builder.Com article quite explicity asserts HKC Sequence generator numbers are guaranteed to be unique only for a single HKC instance, which is unsuitable for use as a primary key in parallel or HKC remote environments, where a sequence in each environment might generate HKC the same number and result in conflicts Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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[2]: Sequences in OPS/RAC
On 11/03/2003 12:04:26 PM, Jonathan Gennick wrote: Can you point us to the article? My guess is that the author is not familiar with Oracle, That shouldn't be considered enough of a reason not to write articles about oracle, should it? Mladen Gogala Oracle DBA 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).
RE: Re[2]: Sequences in OPS/RAC
Hi, I have RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order. Muqthar Ahmed -Original Message- Sent: Monday, November 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Hello Hemant, Monday, November 3, 2003, 11:29:26 AM, you wrote: HKC However, the Builder.Com article quite explicity asserts HKC Sequence generator numbers are guaranteed to be unique only for a single HKC instance, which is unsuitable for use as a primary key in parallel or HKC remote environments, where a sequence in each environment might generate HKC the same number and result in conflicts Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Muqthar Ahmed 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: Outsourcing's dirty secret
This is not appropriate for this list. Please refrain in the future. Jared hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 05:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secret Hi All DBA's all here hmm...well if i were the CFO i would have been lookin for the fast=true parameter if i were bald i would have been looking for a pill or a cream that would give me hairs overnight..the time of instant nirvana has come :-)..software bpo call centeres they are all same..today the jobs are being moved to india becaz the CEO's see that they are able to save 10$ on paper. or maybe just becoz your competitor is doin so..capital always moves in serach of labour thats the bottom line ..:-) i read argentina programmers are cheaper then indians well hehehe..hehee ...:-)..argentians woman are they more beautifulthe author in my opinion has provided a skewewed version of outsourcing ..the real competition for india will come from ETHOPIA i beelive ..provided the ethopians start learning english...:-) and will start working for food :-) as for us we americans we can come out with a dirty trick like not sharing information on fear of getting sacked with indian programmers :-) regards Hrishy --- Loughmiller, Greg [EMAIL PROTECTED] wrote: not only salries, but job opportunities as well:-) greg -Original Message- Sent: Thursday, October 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L But sure as hell does drive salaries down over here. On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote: The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secret What is also unfortunate that the company X which outsourced its project to India, didn't do its job right ... If you just want the cheapest Rolex, you can't complain about its quality later on. I am not saying this couldn't have happened, whatever happened is unfortunate, but I am just saying that the company didn't understand CYA sufficiently, it is just a blame game now. C'mon ... I think that article is one side of the coin. 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: Thursday, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outso urcing.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** 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. **5 -- 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). Mladen Gogala Oracle DBA 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
RE: Win termin services alert
Ok, what is LINDESK? I googled for it, but found nothing informative. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 04:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Win termin services alert Niall, LINDESK isn't the flaw, it is the method that the server handled the request from a non-windows browser. They have fixed the problem and the application now works from any OS browser. I ment the info to be a potential security alert. Ron [EMAIL PROTECTED] 10/31/03 03:49PM I'm not entrely sure what you are saying here. Terminal Services gives you a remote session on the server. You should have to provide a username and password for this. When you get desktop access it is in the security context of the username/password you have provided. If you had full control that rather suggests that they had provided you with an inappropriate username/password. If I log into a server as root using ssh, I don't consider that to be a flaw in ssh. Now I might be misunderstanding what you are saying here, and it could be that LINDESK doesn't honour the credentials you provide it with, but this also doesn't seem like a terminal services flaw... Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Rogers Sent: 31 October 2003 14:05 To: Multiple recipients of list ORACLE-L Subject: Win termin services alert List. Reguarding Windows Terminal services... It is used to remotely display an action back to the requesting windows client with software control. Usually used in a browser application. We have an application that is browser based and we are instructed to use Windows 2000K as the client. I feel that if an application is browser based I should be able to use and client and browser. I used a browser on Linux with a windows terminal services package installed and connected to the server via a login/passwd with a browser. The problem occured when the software control didn't work and I was dropped to the server desktop. I had full control over the server. I immediatly contacted security... Please be aware of this potential and serious security problem using terminal services. The terminal services package I tested was the LINDESK for linux. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Ron Rogers 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: anyone have success with semi-joins?
if thats the case, how is a semi_nl useful? its doing a nested loop also. There is alot of academic talk on semi-joins on the web, but I cant find an algorithm anywhere. The basics of it appear to be generic. From: Tanel Poder [EMAIL PROTECTED] Date: 2003/11/03 Mon PM 12:49:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: anyone have success with semi-joins? Hi! I don't know the exact algorithm either, but check the execution plans: SQL set autot trace exp SQL select name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 FILTER 21 TABLE ACCESS (FULL) OF 'OBJ$' 31 TABLE ACCESS (CLUSTER) OF 'TAB$' 43 INDEX (UNIQUE SCAN) OF 'I_OBJ#' (NON-UNIQUE) SQL select /*+ HASH_SJ */ name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=50 Card=8168 Bytes=3 51224) 10 HASH JOIN (SEMI) (Cost=50 Card=8168 Bytes=351224) 21 TABLE ACCESS (FULL) OF 'OBJ$' (Cost=25 Card=8168 Bytes=2 45040) 31 VIEW OF 'VW_SQ_1' (Cost=25 Card=8168 Bytes=106184) 43 TABLE ACCESS (FULL) OF 'TAB$' (Cost=25 Card=8168 Bytes =106184) You see in first execution plan we use FILTER for getting our results. FILTER has several meanings, but in this case it could be bounded nested loop (e.g. stopping for particular driving key when exists condition is satisfied). That means, for every row in obj$ we have to check separately whether there is any matching rows, this means lots of logical IOs. In second execution plan however, a hash join is done between obj$ and distinct obj# key values from tab$ (that's the reason why we're calling it a semi-join). Semi-join allow us to replace big amount of small nested loop IOs with few big reads and a hash join instead. Note that I don't know whether Oracle actually behaves this way, I'm just telling you how I think it is done, based only on brief analysis... Cheers, Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 03, 2003 5:04 PM I picked up Mark Gurry's SQL pocket reference on Friday and it states that you can radically improve performance of 'where exists' statements by using semi-joins since it only returns the sub-query ones. Now logically you have to return the sub-query repeatedly, this would only come into play if there are duplicates right? anyone know the algorithm for the semi-join? Not just the result? I cant find it anywhere. anyone ever hint this or let oracle decide? -- 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). Hi! I don't know the exact algorithm either, but check the execution plans: SQL set autot trace expSQL select name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 FILTER 2 1 TABLE ACCESS (FULL) OF 'OBJ$' 3 1 TABLE ACCESS (CLUSTER) OF 'TAB$' 4 3 INDEX (UNIQUE SCAN) OF 'I_OBJ#' (NON-UNIQUE) SQL select /*+ HASH_SJ */ name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=50 Card=8168 Bytes=3 51224) 1 0 HASH JOIN (SEMI) (Cost=50 Card=8168 Bytes=351224) 2 1 TABLE ACCESS (FULL) OF 'OBJ$' (Cost=25 Card=8168 Bytes=2 45040) 3 1 VIEW OF 'VW_SQ_1' (Cost=25 Card=8168 Bytes=106184) 4 3 TABLE ACCESS (FULL) OF 'TAB$' (Cost=25 Card=8168 Bytes =106184) You see in first execution plan we use FILTER for getting our results. FILTER has several meanings, but in this case it could be bounded nested loop (e.g. stopping for particular driving key when exists condition is satisfied). That means, for every row in obj$ we have to check separately whether there is any matching rows, this means lots of logical IOs. In second execution plan
Re: anyone have success with semi-joins?
Hi! I don't know the exact algorithm either, but check the execution plans: SQL set autot trace expSQL select name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 FILTER 2 1 TABLE ACCESS (FULL) OF 'OBJ$' 3 1 TABLE ACCESS (CLUSTER) OF 'TAB$' 4 3 INDEX (UNIQUE SCAN) OF 'I_OBJ#' (NON-UNIQUE) SQL select /*+ HASH_SJ */ name from obj$ 2 where exists (select 1 from tab$ where obj$.obj# = tab$.obj#); Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=50 Card=8168 Bytes=3 51224) 1 0 HASH JOIN (SEMI) (Cost=50 Card=8168 Bytes=351224) 2 1 TABLE ACCESS (FULL) OF 'OBJ$' (Cost=25 Card=8168 Bytes=2 45040) 3 1 VIEW OF 'VW_SQ_1' (Cost=25 Card=8168 Bytes=106184) 4 3 TABLE ACCESS (FULL) OF 'TAB$' (Cost=25 Card=8168 Bytes =106184) You see in first execution plan we use FILTER for getting our results. FILTER has several meanings, but in this case it could be bounded nested loop (e.g. stopping for particular driving key when exists condition is satisfied). That means, for every row in obj$ we have to check separately whether there is any matching rows, this means lots of logical IOs. In second execution plan however, a hash join is done between obj$ and distinct obj# key values from tab$ (that's the reason why we're calling it a semi-join). Semi-join allow us to replace big amount of small nested loop IOswith few big reads and a hash join instead. Note that I don't know whether Oracle actually behaves this way, I'm just telling you how Ithinkit is done, based only onbrief analysis... Cheers, Tanel. - Original Message - From: [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, November 03, 2003 5:04 PM Subject: anyone have success with semi-joins? I picked up Mark Gurry's SQL pocket reference on Friday and it states that you can radically improve performance of 'where exists' statements by using semi-joins since it only returns the sub-query ones. Now logically you have to return the sub-query repeatedly, this would only come into play if there are duplicates right? anyone know the algorithm for the semi-join? Not just the result? I cant find it anywhere. anyone ever hint this or let oracle decide? -- 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).
Re: memory usage by dbw very high
hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder [EMAIL PROTECTED] wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, howeverOP still uses 2.4.9 as stated in original post.I just wanted to know whether OP actually sees excessive paging or justmemory being "full", the latter one, as you know, isn't really a problem.Tanel.- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing! pages from the active processes, which will, in turn. start paging. The only possible response is to eliminate thebuffered I/ O and switch to non-buffered I/O. That is not so hard to do. On 2003.11.01 09:44, Tanel Poder wrote: Just for clarification, do you actually see swapping when starting a new process or you just guess linux would swap because you don't see "free" memory in top output? Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very highrich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08)is used by non shared memory size. i went thru all the processes and found dbwr u! sing the max %mem. what could be the reason? sai "Jesse, Rich" <[EMAIL PROTECTED]>wrote: If I'm not mistaken, this figure includes the size of the sharedmemory segment from the SGA. Take the output of the "oracle" line of"ipcs -a" (hopefully you'll only have one!) and subtract it from the processsize to get a better idea of the non-shared memory size of the process. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA-Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-Lhi i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swappingwhen any process starts. here are the spces version:9.2.0.4 os:Linux 2.4.9-e.24smp o/p from top: 1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area 1084823632 bytes Fixed! Size 452688 bytes Variable Size 335544320 bytes Database Buffers 738197504 bytes Redo Buffers 10629120 bytes pga aggregate size:700M and ps o/p of dbw process USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND oracle 4062 0.0 16.4 1131260 508168 ? S 10:16 0:06 ora_dbw0_revenue please advise. what is really going on. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services- To REMOVE yourself from this mailing list, send a! n E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
RE: Re[2]: Sequences in OPS/RAC
The problem is that the ORDER clause comes at the expense of CACHE. You can use SQL tracing to verify that each use of the sequence causes an update of SYS.SEQ$ when ORDER is set, effectively rendering the CACHE setting a no-op. So, especially in an OPS/RAC environment, the use of ORDERED sequences, especially heavily used ORDERED sequences, comes at a steep price. Think about it: is ORDERED *really* necessary? In some situations (i.e. check numbers), the ORDERED clause would be necessary, but unless you are pumping out thousands of checks an hour, perhaps a cached sequence shouldn't be used. But for system-generated keys, surrogate keys, etc, I don't think the semantics of ORDERED are necessary at all. Hi, I have RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order. Muqthar Ahmed -Original Message- Sent: Monday, November 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Hello Hemant, Monday, November 3, 2003, 11:29:26 AM, you wrote: HKC However, the Builder.Com article quite explicity asserts HKC Sequence generator numbers are guaranteed to be unique only for a single HKC instance, which is unsuitable for use as a primary key in parallel or HKC remote environments, where a sequence in each environment might generate HKC the same number and result in conflicts Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Muqthar Ahmed 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).
Database Normalization
List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared
Re: ** other oracle forums
Hi, My fatcity account from gawab.com does not work. Is it working for ne 1. Thank you Do you Yahoo!? Exclusive Video Premiere - Britney Spears
** other oracle forums
Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone hadposted it sometime back.Thank You. Do you Yahoo!? Exclusive Video Premiere - Britney Spears
RE: Win termin services alert
Jared, LINDESK is a package for linux that allows terminals-services for windows to be used from the linux OS. www.terminal-services.net The product info is linRDP and creates to application lindesk. Ron [EMAIL PROTECTED] 11/03/2003 12:54:26 PM Ok, what is LINDESK? I googled for it, but found nothing informative. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 04:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Win termin services alert Niall, LINDESK isn't the flaw, it is the method that the server handled the request from a non-windows browser. They have fixed the problem and the application now works from any OS browser. I ment the info to be a potential security alert. Ron [EMAIL PROTECTED] 10/31/03 03:49PM I'm not entrely sure what you are saying here. Terminal Services gives you a remote session on the server. You should have to provide a username and password for this. When you get desktop access it is in the security context of the username/password you have provided. If you had full control that rather suggests that they had provided you with an inappropriate username/password. If I log into a server as root using ssh, I don't consider that to be a flaw in ssh. Now I might be misunderstanding what you are saying here, and it could be that LINDESK doesn't honour the credentials you provide it with, but this also doesn't seem like a terminal services flaw... Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Rogers Sent: 31 October 2003 14:05 To: Multiple recipients of list ORACLE-L Subject: Win termin services alert List. Reguarding Windows Terminal services... It is used to remotely display an action back to the requesting windows client with software control. Usually used in a browser application. We have an application that is browser based and we are instructed to use Windows 2000K as the client. I feel that if an application is browser based I should be able to use and client and browser. I used a browser on Linux with a windows terminal services package installed and connected to the server via a login/passwd with a browser. The problem occured when the software control didn't work and I was dropped to the server desktop. I had full control over the server. I immediatly contacted security... Please be aware of this potential and serious security problem using terminal services. The terminal services package I tested was the LINDESK for linux. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Ron Rogers 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: Ron Rogers 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
RE: Database Normalization
Title: Message Hi Jared, Just so I'm clear which one to avoid, are you referring to the one that links to the excerpt from this book? Sams Teach Yourself SQL in 21 Days, Second Edition The reason I'm asking is I entered your URL below but received a "Page Not Found" error. When I searched the TinyURL site for "normalization" hits, this is what I came up with. Thanks, Melanie -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 1:34 PMTo: Multiple recipients of list ORACLE-LSubject: Database Normalization List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared
Re: Database Normalization
ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts performance. which is similiar to normalize until its inconvenient. you could have some real fun and try to explan the boyce-codd normal form from an academic text book :) From: [EMAIL PROTECTED] Date: 2003/11/03 Mon PM 01:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Normalization List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared
Re: ** other oracle forums
The newsgroups comp.databases.oracle.XXX, where XXX is server, misc, tools or marketplace. DBA issues are mostly discussed at ...server. If you don't have direct access to Usenet, go to groups.google.com or www.mailgate.org. Personal opinion: Jonathan Lewis is still there. Other experts only visit once in a while. Generally free of off-topic messages. The only problem may be that some people go overboard in trusting authorities, in spite of Jonathan's warning every time The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Other than Lazy Dba (www.lazydba.com) and others, you can think of otn.oracle.com or Metalink forums or even asktom.oracle.com as forums. Only on-topic messages are allowed on these forums. Yong Huang --- A Joshi [EMAIL PROTECTED] wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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).
RE: Database Normalization
change the url to www.tinyurl.com/th7i --- Melanie Caffrey [EMAIL PROTECTED] wrote: Hi Jared, Just so I'm clear which one to avoid, are you referring to the one that links to the excerpt from this book? Sams Teach Yourself SQL in 21 Days, Second Edition The reason I'm asking is I entered your URL below but received a Page Not Found error. When I searched the TinyURL site for normalization hits, this is what I came up with. Thanks, Melanie -Original Message- [EMAIL PROTECTED] Sent: Monday, November 03, 2003 1:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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).
Re: ** other oracle forums
A Joshi wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. Google is your friend. Just search for Oracle dba mailing lists and a whole slew of results are returned. HTH, -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Haas 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: Database Normalization
Jared - The book that has helped me the most is The Data Modeling Handbook by Reingruber and Gregory. Their approach is to develop a best practice for each modeling situation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 12:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared -- 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).
Re: Database Normalization
Jared, I'm sure that the three of you can easily do it. Good luck. On 11/03/2003 01:34:26 PM, [EMAIL PROTECTED] wrote: List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared Mladen Gogala Oracle DBA 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).
10g new features
Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared
RE: Database Normalization
Thanks, Rachel. Obvious answers like the below elude my overworked and sleep-deprived brain right now :) Long work weekend and all that ... Guess I'll leave poor Sams alone, then. -Original Message- Rachel Carmichael Sent: Monday, November 03, 2003 2:15 PM To: Multiple recipients of list ORACLE-L change the url to www.tinyurl.com/th7i --- Melanie Caffrey [EMAIL PROTECTED] wrote: Hi Jared, Just so I'm clear which one to avoid, are you referring to the one that links to the excerpt from this book? Sams Teach Yourself SQL in 21 Days, Second Edition The reason I'm asking is I entered your URL below but received a Page Not Found error. When I searched the TinyURL site for normalization hits, this is what I came up with. Thanks, Melanie -Original Message- [EMAIL PROTECTED] Sent: Monday, November 03, 2003 1:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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). ** This email is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this e-mail message is not the intended recipient, or the employee or agent responsible for delivery of the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify us immediately by telephone at (212) 686-6004 and also indicate the sender's name. Thank You www.proximo.com [EMAIL PROTECTED] * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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: Outsourcing's dirty secret
Title: Message Thank you Jared. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secretThis is not appropriate for this list. Please refrain in the future. Jared hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 05:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secretHi AllDBA's all here hmm...well if i were the CFO i wouldhave been lookin for the fast=true parameter if i werebald i would have been looking for a pill or a creamthat would give me hairs overnight..the time ofinstant nirvana has come :-)..software bpo callcenteres they are all same..today the jobs are beingmoved to india becaz the CEO's see that they are ableto save 10$ on paper. or maybe just becoz yourcompetitor is doin so..capital always moves in serachof labour thats the bottom line ..:-) i read argentinaprogrammers are cheaper then indians wellhehehe..hehee ...:-)..argentians woman are they morebeautifulthe author in my opinion has provided askewewed version of outsourcing ..the real competitionfor india will come from ETHOPIA i beelive ..providedthe ethopians start learning english...:-) and willstart working for food :-)as for us we americans we can come out with a dirtytrick like not sharing information on fear of gettingsacked with indian programmers :-)regardsHrishy--- "Loughmiller, Greg"[EMAIL PROTECTED] wrote: not onlysalries, but job opportunities as well:-) greg -Original Message- Sent: Thursday, October 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L But sure as hell does drive salaries down over here. On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote: The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared "Jamadagni, Rajendra" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Outsourcing's dirty secret What is also unfortunate that the company X which outsourced its project to India, didn't do its job right ... If you just want the cheapest Rolex, you can't complain about its quality later on. I am not saying this couldn't have happened, whatever happened is unfortunate, but I am just saying that the company didn't understand CYA sufficiently, it is just a blame game now. C'mon ... I think that article is one side of the coin. 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: Thursday, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outso urcing.htmlDennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** 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. **5 -- 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 EE and SE on same box
Hi: Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box. Regards, Gary Norwell Systems Analyst Hybrid Turkeys
Re: memory usage by dbw very high
mladen i have gtop...and i am trying to get thru the preferences which u have mentioned. 1. can you please help me to find the kernel mode for the processes. 2. on this linux box i see that demon kswapd and bdflush in the process list.should they always be running or do they get intiated only when paging or swapping happens. thanks sai Mladen Gogala [EMAIL PROTECTED] wrote: What we have here is a confusion with terminology. Process cannot "be swapping". When there is a serious shortage of memory, the swap demon(yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped.Unless, we are talking about the kswapd process, the process cannot "be swapping". Kernelswap demon seldomly uses oracle database.Process can be paging. When there is serious shortage of memory (but less serious then inthe first case), pages are stolen from the process and written onto the swap. It's called"page replacement". When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations,there is a process called "updated" or ! "paged " which performs this function.), it pages them in.If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard pagefault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode.If you have gtop (my kindest advice is to get it), you can set preferences and see kernel modefor the processes. Ones consuming large amounts of the kernel mode are ones that are paging.On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is th! ere something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder <[EMAIL PROTECTED]>wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being "full", the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" Sent: Saturday, November 01, 2003 5:39 PMThe whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserF! S or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the active processes, which will, in turn. start paging. The only possible response is to eliminate the buffered I/ O and switch to non-buffered I/O. That is not so hard to do. On 2003.11.01 09:44, Tanel Poder wrote: Just for clarification, do you actually see swapping when starting a new process or you just guess linux would swap because you don't see "free" memory in top output? Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very high ! rich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went thru all the processes and found dbwr using the max %mem. what could be the reason? sai "Jesse, Rich" wrote: If I'm not mistaken, this figure includes the size of the shared memory segment from the SGA. Take the output of the "oracle" line of "ipcs -a" (hopefully you'll only have one!) and subtract it from the process size to get a better idea of the non-shared memory size of the process. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Su! ssex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L hi i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts. here are the spces version:9.2.0.4 os:Linux 2.4.9-e.24smp o/p from top: 1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% ni! ce, 98.0% idle CPU2 states: 0.0% user,
Re: ** other oracle forums
There is no forum like this one. There is no place like 127.0.0.1. On 11/03/2003 01:34:34 PM, A Joshi wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. - Do you Yahoo!? Exclusive Video Premiere - Britney Spears Mladen Gogala Oracle DBA 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).
RE: Re[2]: Sequences in OPS/RAC
All, Just wanted to point out that 'missing' invoice numbers caused by a variety of causes (even if they were not cached), can cause problems for Accounting/Finance Depts in certain countries. Basically, the Govt looks on this as being used for 'tax avoidance', unless proved otherwise. You *can* miss uncached sequences under certain conditions when the Db restarts or a short burst of SQL causes pressure on the DD cache... Had this occur once in an Apps database and had to apply patches to undo and put back the sequence... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re[2]: Sequences in OPS/RAC The problem is that the ORDER clause comes at the expense of CACHE. You can use SQL tracing to verify that each use of the sequence causes an update of SYS.SEQ$ when ORDER is set, effectively rendering the CACHE setting a no-op. So, especially in an OPS/RAC environment, the use of ORDERED sequences, especially heavily used ORDERED sequences, comes at a steep price. Think about it: is ORDERED *really* necessary? In some situations (i.e. check numbers), the ORDERED clause would be necessary, but unless you are pumping out thousands of checks an hour, perhaps a cached sequence shouldn't be used. But for system-generated keys, surrogate keys, etc, I don't think the semantics of ORDERED are necessary at all. Hi, I have RAC and I always use ORDER when I create SEQUENCE. The following information is from Oracle Manual: ORDER is necessary only to guarantee ordered generation if you are using Oracle with Real Application Clusters. If you are using exclusive mode, sequence numbers are always generated in order. Muqthar Ahmed -Original Message- Sent: Monday, November 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Hello Hemant, Monday, November 3, 2003, 11:29:26 AM, you wrote: HKC However, the Builder.Com article quite explicity asserts HKC Sequence generator numbers are guaranteed to be unique only for a single HKC instance, which is unsuitable for use as a primary key in parallel or HKC remote environments, where a sequence in each environment might generate HKC the same number and result in conflicts Can you point us to the article? My guess is that the author is not familiar with Oracle, and is basing the above statement on his experience with some other database (DB2 perhaps?). There is no problem with using sequence numbers in a RAC. No conflicts will occur. I've never heard of a problem in that regard. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Muqthar Ahmed 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
RE: Database Normalization
Funny you should ask for this definition. Boyce-Codd Normal Form (BCNF) * Formal definition: * Every determinant must be a candidate key * Stronger form of 3NF * 3NF: Every determinant of a non-key column must be a candidate key * Applies to tables with more than one candidate key * Candidate keys are alternatives to the chosen primary key Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, November 03, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject:Re: Database Normalization File: reply ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts performance. which is similiar to normalize until its inconvenient. you could have some real fun and try to explan the boyce-codd normal form from an academic text book :) From: [EMAIL PROTECTED] Date: 2003/11/03 Mon PM 01:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database Normalization List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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: Outsourcing's dirty secret
Title: Message may best brains survive where ever it is. -Original Message-From: Anjan Thakuria [mailto:[EMAIL PROTECTED]Sent: Monday, November 03, 2003 2:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secret Thank you Jared. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, November 03, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Outsourcing's dirty secretThis is not appropriate for this list. Please refrain in the future. Jared hrishy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 05:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secretHi AllDBA's all here hmm...well if i were the CFO i wouldhave been lookin for the fast=true parameter if i werebald i would have been looking for a pill or a creamthat would give me hairs overnight..the time ofinstant nirvana has come :-)..software bpo callcenteres they are all same..today the jobs are beingmoved to india becaz the CEO's see that they are ableto save 10$ on paper. or maybe just becoz yourcompetitor is doin so..capital always moves in serachof labour thats the bottom line ..:-) i read argentinaprogrammers are cheaper then indians wellhehehe..hehee ...:-)..argentians woman are they morebeautifulthe author in my opinion has provided askewewed version of outsourcing ..the real competitionfor india will come from ETHOPIA i beelive ..providedthe ethopians start learning english...:-) and willstart working for food :-)as for us we americans we can come out with a dirtytrick like not sharing information on fear of gettingsacked with indian programmers :-)regardsHrishy--- "Loughmiller, Greg"[EMAIL PROTECTED] wrote: not onlysalries, but job opportunities as well:-) greg -Original Message- Sent: Thursday, October 30, 2003 3:39 PM To: Multiple recipients of list ORACLE-L But sure as hell does drive salaries down over here. On 10/30/2003 03:04:24 PM, [EMAIL PROTECTED] wrote: The perception of outsourcing has been that you can send your work offshore, and get it done cheaper, with higher quality. I think that this article helps to dispel that as a myth. It may or may not be less expensive, it may or may not be better. Jared "Jamadagni, Rajendra" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2003 09:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Outsourcing's dirty secret What is also unfortunate that the company X which outsourced its project to India, didn't do its job right ... If you just want the cheapest Rolex, you can't complain about its quality later on. I am not saying this couldn't have happened, whatever happened is unfortunate, but I am just saying that the company didn't understand CYA sufficiently, it is just a blame game now.C'mon ... I think that article is one side of the coin. 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: Thursday, October 30, 2003 11:59 AM To: Multiple recipients of list ORACLE-L List - If a manager seems to be contemplating outsourcing, you might want to post this. Unless you work for an outsourcer. ;-) http://techupdate.zdnet.com/techupdate/stories/main/Hidden_Costs_of_IT_Outso urcing.htmlDennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni,
Re: ** other oracle forums
Regarding the posting of 'on topic only' messages: That is highly subjective. What I call on topic you may not agree with. Then there is the issue of time. I already spend way too much time on this list. Moderating to the degree that some may like is simply out of the question. Jared Yong Huang [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: ** other oracle forums The newsgroups comp.databases.oracle.XXX, where XXX is server, misc, tools or marketplace. DBA issues are mostly discussed at ...server. If you don't have direct access to Usenet, go to groups.google.com or www.mailgate.org. Personal opinion: Jonathan Lewis is still there. Other experts only visit once in a while. Generally free of off-topic messages. The only problem may be that some people go overboard in trusting authorities, in spite of Jonathan's warning every time The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Other than Lazy Dba (www.lazydba.com) and others, you can think of otn.oracle.com or Metalink forums or even asktom.oracle.com as forums. Only on-topic messages are allowed on these forums. Yong Huang --- A Joshi [EMAIL PROTECTED] wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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).
Re: Oracle EE and SE on same box
What is the actual concern with it? Installing both EE and SE on the same *nix or Win32 box is pretty straight forward, provided you aren't trying to do so with Version 7 on Win32. You don't do anything special, just install them, create your databases, edit tnsnames, etc. If your question has to do with licensing, call your Oracle rep. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:39 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle EE and SE on same box Hi: Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box. Regards, Gary Norwell Systems Analyst Hybrid Turkeys
Re: memory usage by dbw very high
Preferences-Process Fields-STime, UTime. On 11/03/2003 02:44:34 PM, Sai Selvaganesan wrote: mladen i have gtop...and i am trying to get thru the preferences which u have mentioned. 1. can you please help me to find the kernel mode for the processes. 2. on this linux box i see that demon kswapd and bdflush in the process list.should they always be running or do they get intiated only when paging or swapping happens. thanks sai Mladen Gogala [EMAIL PROTECTED] wrote: What we have here is a confusion with terminology. Process cannot be swapping. When there is a serious shortage of memory, the swap demon (yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped. Unless, we are talking about the kswapd process, the process cannot be swapping. Kernel swap demon seldomly uses oracle database. Process can be paging. When there is serious shortage of memory (but less serious then in the first case), pages are stolen from the process and written onto the swap. It's called page replacement. When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations, there is a process called updated or paged which performs this function.), it pages them in. If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard page fault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode. If you have gtop (my kindest advice is to get it), you can set preferences and see kernel mode for the processes. Ones consuming large amounts of the kernel mode are ones that are paging. On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the active processes, which will, in turn. start paging. The only possible response is to eliminate the buffered I/ O and switch to non-buffered I/O. That is not so hard to do. On 2003.11.01 09:44, Tanel Poder wrote: Just for clarification, do you actually see swapping when starting a new process or you just guess linux would swap because you don't see free memory in top output? Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very high rich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went thru all the processes and found dbwr using the max %mem. what could be the reason? sai Jesse, Rich wrote: If I'm not mistaken, this figure includes the size of the shared memory segment from the SGA. Take the output of the oracle line of ipcs -a (hopefully you'll only have one!) and subtract it from the process size to get a better idea of the non-shared memory size of the process. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L hi i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts. here are the spces version:9.2.0.4 os:Linux 2.4.9-e.24smp
Re: ** other oracle forums
scaryvoice Do not attempt to leave us, we are the only forum you need. We now have your email address, you'll be forced to seek us out in the future for all of your oracle needs. /scaryvoice Darn halloween is over, never mind. search google as state before. joe A Joshi wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/video/?1093432fs=1redirectURL=http://launch.yahoo.com/promos/britneyspears/ -- 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).
Re: Re: ** other oracle forums
the person who made this post has a habit of asking hte exact same question on this forum and lazydba. i hope he dosent decide to expand that to 5-6 forums. From: Yong Huang [EMAIL PROTECTED] Date: 2003/11/03 Mon PM 02:04:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ** other oracle forums The newsgroups comp.databases.oracle.XXX, where XXX is server, misc, tools or marketplace. DBA issues are mostly discussed at ...server. If you don't have direct access to Usenet, go to groups.google.com or www.mailgate.org. Personal opinion: Jonathan Lewis is still there. Other experts only visit once in a while. Generally free of off-topic messages. The only problem may be that some people go overboard in trusting authorities, in spite of Jonathan's warning every time The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Other than Lazy Dba (www.lazydba.com) and others, you can think of otn.oracle.com or Metalink forums or even asktom.oracle.com as forums. Only on-topic messages are allowed on these forums. Yong Huang --- A Joshi [EMAIL PROTECTED] wrote: Hi, Can someone post a list of other oracle dba forums like this one. Again. I think someone had posted it sometime back. Thank You. __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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).
converting sybase stored procedure into oracle sp
Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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 7.3.4.0 on Win 2000
Hello Fellow Oraclers Has any of you come across installing Oracle 7.3.4.0 on Windows 2000. Can any of you share your experiences with me. I am aware that 7.3.4.0 is not certified by Oracle to run on Win 2000 however my requirements dictate I carry out the stated task. I tried to install and it did install OracleServiceOrcl and OracleStartORCL services however didn't install OracleTNSListener. Any help is appreciated Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arif Khan (GWL) 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: 10g new features
That's a nice article. The author could have enhanced it by adding or changing some wording. The buffer cache can be flushed with alter system flush buffer_cache. - ... instead of using the undocumented alter session set events = 'immediate trace name flush_cache' in 9i SQL: Regular Expressions (finally) - SQL: Regular Expressions; much enhanced over the less known owa_pattern (see http://www.stormloader.com/yonghuang/computer/OracleRegExp.html) Plus Oracle trace collection is deprecated (or gone?) after it's finally improved to the level of being quite useful (see http://www.dbazine.com/jlewis1.html) One of the biggest improvements to me is the datafile reuse across OSes. When my previous employer outsourced Financials to Oracle.com (and laid off all DBAs including me incidentally), Oracle had to use Solaris because it was too difficult to export. All other databases we outsourced are running on Linux now. Yong Huang --- [EMAIL PROTECTED] wrote: Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- 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).
RE: Database Normalization
Oh, I have *tons* of data modeling books/articles. Just needed a quick refresher for the purpose of offering explanations. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:14 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database Normalization Jared - The book that has helped me the most is The Data Modeling Handbook by Reingruber and Gregory. Their approach is to develop a best practice for each modeling situation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 12:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared -- 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).
RE: converting sybase stored procedure into oracle sp
I believe Oracle Migration Workbench will convert your Sybase (Transact-SQL) procedures to Oracle (PL/SQL). The tool is normally used to migrate an entire database, but I believe it gives you the opportunity to be very selective on which objects to migrate. The tool may require more effort than you're willing to put forward, but it's an option. -Original Message- Sent: Monday, November 03, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: Rothouse, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: converting sybase stored procedure into oracle sp
Look for Migration Workbench on OTN. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Saminathan Sent: Monday, November 03, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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).
Re: memory usage by dbw very high
What we have here is a confusion with terminology. Process cannot be swapping. When there is a serious shortage of memory, the swap demon (yes, your Unix box is haunted) known by the horrible name of [kswapd] writes the whole address space space belonging to the process onto swap. At that point, process is swapped. Unless, we are talking about the kswapd process, the process cannot be swapping. Kernel swap demon seldomly uses oracle database. Process can be paging. When there is serious shortage of memory (but less serious then in the first case), pages are stolen from the process and written onto the swap. It's called page replacement. When processes need pages that have been thrown out of memory by the page replacement demon (in case of Linux, it's called bdflush but on some unix implementations, there is a process called updated or paged which performs this function.), it pages them in. If the page is in memory (buffer cache would a good place to look), we're talking about the soft page fault. If the page has to be read from the disk, we're talking about hard page fault. Processes that page get charged for a lot of CPU time, all of it in the kernel mode. If you have gtop (my kindest advice is to get it), you can set preferences and see kernel mode for the processes. Ones consuming large amounts of the kernel mode are ones that are paging. On 11/03/2003 01:24:27 PM, Sai Selvaganesan wrote: hi tanel and mladen not every time a process is started does it swap but sometimes swapping does happen.(this is from the top o/p which shows a increase in the memory used in swap.).how do we check whether a single process swaps or not? and the dbw process is using more % of memory than a couple of days back.(o/p pf ps aux). is this how linux kernel works or is there something else i can check. thanks sai what is meant by OP,tanel.. Tanel Poder [EMAIL PROTECTED] wrote: Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 5:39 PM The whole thing comes as a consequence of using buffered I/O. New linux kernels (2.4.18 and later) have new memory management, which allows the kernel to grab more memory for buffers in periods of intense I./O activity. If you have a very active database on ReiserFS or Ext3, Linux is going to try to help you out by allocating more memory for the file system buffers, even by stealing pages from the active processes, which will, in turn. start paging. The only possible response is to eliminate the buffered I/ O and switch to non-buffered I/O. That is not so hard to do. On 2003.11.01 09:44, Tanel Poder wrote: Just for clarification, do you actually see swapping when starting a new process or you just guess linux would swap because you don't see free memory in top output? Tanel. - Original Message - From: Sai Selvaganesan To: Multiple recipients of list ORACLE-L Sent: Saturday, November 01, 2003 1:34 AM Subject: RE: memory usage by dbw very high rich the ipcs output shows 1.1 gb. so nearly 2 gb(total ram size is 3.08) is used by non shared memory size. i went thru all the processes and found dbwr using the max %mem. what could be the reason? sai Jesse, Rich wrote: If I'm not mistaken, this figure includes the size of the shared memory segment from the SGA. Take the output of the oracle line of ipcs -a (hopefully you'll only have one!) and subtract it from the process size to get a better idea of the non-shared memory size of the process. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, October 31, 2003 3:49 PM To: Multiple recipients of list ORACLE-L hi i have a system that has no active users at this point of time. the memory used by the dbw process is very high leading to a lot of swapping when any process starts. here are the spces version:9.2.0.4 os:Linux 2.4.9-e.24smp o/p from top: 1:44pm up 29 days, 23:55, 4 users, load average: 1.73, 1.68, 1.35 132 proces! ses: 131 sleeping, 1 running, 0 zombie, 0 stopped CPU0 states: 24.4% user, 2.2% system, 0.0% nice, 72.2% idle CPU1 states: 0.5% user, 0.5% system, 0.0% nice, 98.0% idle CPU2 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle CPU3 states: 0.3% user, 0.4% system, 0.0% nice, 98.3% idle Mem: 3089964K av, 3083380K used, 6584K free, 846848K shrd, 193448K buff Swap: 2048152K av, 1652K used, 2046500K free 1852468K cached sga size: Total System Global Area
RE: Oracle EE and SE on same box
Gary - I haven't done this exact task, but I would think it would be similar to having different Oracle versions on the same server. Just make sure you use a separate ORACLE_HOME for each and watch any other conflicts like the same path being used for each. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Hi: Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box. Regards, Gary Norwell Systems Analyst Hybrid Turkeys -- 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).
Re: Oracle 7.3.4.0 on Win 2000
The service for OracleTNSListener will show up once the Listener is started. Try starting it from the command line using lsnrctl. This has worked for me. 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] [EMAIL PROTECTED] [EMAIL PROTECTED] on.caTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Oracle 7.3.4.0 on Win 2000 ity.com 11/03/2003 02:04 PM Please respond to ORACLE-L Hello Fellow Oraclers Has any of you come across installing Oracle 7.3.4.0 on Windows 2000. Can any of you share your experiences with me. I am aware that 7.3.4.0 is not certified by Oracle to run on Win 2000 however my requirements dictate I carry out the stated task. I tried to install and it did install OracleServiceOrcl and OracleStartORCL services however didn't install OracleTNSListener. Any help is appreciated Arif -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arif Khan (GWL) 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).
Re: converting sybase stored procedure into oracle sp
Perhaps Oracle Migration Workbench (OMWB) is something you could look at. As I understand, it converts Sybase stored procs to oracle functions by default (since Sybase stored procs can return a result set, but Oracle Stored procs cannot). Todd Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: Todd Boss 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: Database Normalization
Jared - Sounds fine. Do you feel you received the information you needed? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Oh, I have *tons* of data modeling books/articles. Just needed a quick refresher for the purpose of offering explanations. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:14 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database Normalization Jared - The book that has helped me the most is The Data Modeling Handbook by Reingruber and Gregory. Their approach is to develop a best practice for each modeling situation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 12:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared -- 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: 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).
[ORA-000060: Deadlock detected] Finding BOTH pieces of code that
I realize ORACLE-L could not be the best place to ask this question but (googling/metalink-ing did not help overly)... ORA-60 happens in our own application in the worst of possible places - at the customer's site. It happens intermittently. All I can do is look at the alert log for errors and follow the trail to the extremely verbose trace dumps and wonder. Clearly - I am over my head here as I have very little clue of what am I actually looking at. The question is how to interpret what trace dumps tries to tell (should I be scratching my head with it or is there some kind of magic behind TAR that would save the day)? For instance - what is the meaning of this trace snippet (coming from 8.1.7.x): Deadlock graph: -Blocker(s) -Waiter(s)- Resource Name process session holds waits process session holds waits TM-457a-24 37SX 17 14 SSX TM-4571-17 14 SSX 24 37 SX session 37: DID 0001-0018-0002 session 14: DID 0001-0011-0002 session 14: DID 0001-0011-0002 session 37: DID 0001-0018-0002 Rows waited on: Session 14: no row Session 37: no row On the assumption that the source of the above problem has nothing to do with INITTRANS/PCTFREE combo (as per metalink thread # 247579.999) but the culprit really is the broken app - what would be the 'proper' way to find which two pieces of code deadlocked each other? What comes to my mind ain't a pretty sight - turning on sql tracing on the database level (and suffering worsened performance), then once error happens finding out exact time from alert log, converting it to matching TIC number in 3 sec range (if I understand correctly Oracle will detect and break deadlock after 3 seconds). Once this range is known for 3 sec. window, digging through session traces would reveal what were other sessions doing at the time may be narrowing down the search to few possible sources of contention. Problem with this approach is way too much work to set up then 'dig' through all (tons of) trace files without any real guarantees source of deadlocking would be obvious after all this effort. So the question is - how to help duhveloper(s) by pointing closer to the 'root' of deadlocking? Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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 Rebuilding Indexes in Oracle Apps -- an update
COALESCE would be a better option than REBUILD for Indexes on monotonically increasing sequences where older values are purged periodically. Unless you happen to be doing index_ffs on that particular index, in which case a rebuild *may* be in order. Rebuilding the index may cause insert performance problems for a time due to block splits. If the index is a composite index with some other non-unique value(s) making up the index, a higher than normal number of block splits may be in your future. I haven't tested the composite index yet, but this seems reasonable. If the index is based simply on the unique key, and for some reason you are using index_ffs on it, then rebuilding will cut down the number of scanned blocks. It would be interesting to see how skip scans are affected by this as well. Jared Hemant K Chitale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/01/2003 12:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: re Rebuilding Indexes in Oracle Apps -- an update Richard et al, {for those who've been following the thread on Rebuilding Indexes ...} I've just been reading the AskTom thread on rebuilding indexes at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730 and picked on the important line Coalesce... reclaim the free space from mostly empty index leaf blocks that will not be reused otherwise due to your increasing sequence. Richard has also pointed COALESCE as a better option. COALESCE would be a better option than REBUILD for Indexes on monotonically increasing sequences where older values are purged periodically. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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: Database Normalization
More than enough. :) DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 12:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database Normalization Jared - Sounds fine. Do you feel you received the information you needed? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 1:44 PM To: Multiple recipients of list ORACLE-L Oh, I have *tons* of data modeling books/articles. Just needed a quick refresher for the purpose of offering explanations. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 11:14 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database Normalization Jared - The book that has helped me the most is The Data Modeling Handbook by Reingruber and Gregory. Their approach is to develop a best practice for each modeling situation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 03, 2003 12:34 PM To: Multiple recipients of list ORACLE-L List, Doing some reading on Normalization today. We actually have the opportunity to create a database and app, and it's been so long since I've done this on a real project, a refresher was in order. I have the annoying habit of knowing what to do with normalization, based on past education and experience, but having difficulty explaining it to others. This is the kind of thing that makes Cary Millsap nuts. ( read the book if you don't know why ) Mladen would no doubt find this very simple. Anyway, in the course of finding some recent web pages on this, one of the better was at a SQL server magazine site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887pg=1 The reason for writing however, was to show you the worst one so far: www.tinyurl/th7i Basically, 'normalize unless it's inconvenient'. Jared -- 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: 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).
RE: Finding overlapping time periods - suggestions please
Also check out http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-28 .pdf by Richard Snodgrass. Henry -Original Message- Mladen Gogala Sent: Friday, October 31, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Ron, it's not as stupid as you might think. Of course, you can use SQL to find all overlaping time periods, but for a large number of intervals, it's not going to be very efficient and it's going to take a very long time. In other words, it's not practical. Spatial option, on the other hand, uses special libraries and floating point to arrive to the target in a more optimal way. And yes, the reasoning is based on mathematics. On 2003.10.31 15:34, Ron Rogers wrote: Mladen, The information might be excellent for the lecture on the Space and Time Continuum but a black hole will destroy all theories of anything overlapping when they are on the same plain. Of course there has to be an guess work theory about where the stuff the black hole consumes ends up, and does it have the ability the grow at a rate proportional the the volume it consumes? Ron mª¿ªm [EMAIL PROTECTED] 10/31/03 02:54PM I have once been asked to suggest the solution for the same problem, and I have suggested a solution which was out of this world, but completely in line with my education of a mathematician. The project was scrapped and I didn't have an opportunity to apply the solution. To start describing the solution, let me remind you that overlapping areas of space would be discovered by using spatial option. To apply the spatial option, you need to define distance function. Temporal difference does satisfy the necessary conditions for a distance function, as far as mathematics is concerned. In mathematics, there is a structure called metric space, which is, basically, a set with a distance function. Distance function d (metric) on set S is a function d:S x S-R which satisfies the following two conditions: a) d(x,y)=0 for all x,y from S. b) d(x,z)=d(x,y)+d(y,z) for every x,y,z from S. (Cauchy inequality). Points in time, with the difference in seconds do satisfy the above conditions, which means that you can define geometry and use spatial option. Next lesson will be about Cauchy sequences, complete metric spaces, continuous functions, contractions and Banach theorem. If Cary got away with queuing theory, why wouldn't I get away with some abstract calculus and general topology? As I've said earlier, I've never actually had an opportunity to actually apply this solution, but it still looks quite elegant to me, despite it's apparent oddity. On 10/31/2003 01:24:37 PM, [EMAIL PROTECTED] wrote: I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently. Here is the scenario: Elapsed minutes refer to the actual clock time either spent on a given task. Thus an activity that started at 9:00 am and finished at 11:00 am on the same day is said to have 120 elapsed minutes. If one task overlaps another (either completely or partially with another task), then the tasks are said to be multitasked. In that case the system will store the portion of the elapsed time that was multitasked as elapsed multitask minutes and the portion of the time that was not overlapped as elapsed single minutes. In addition, for the portion of time that two or more activities were simultaneously taking place; their time will be divided by the number of simultaneous activities and stored as prorated multi minutes. The sum of Elapsed Single Minutes and Prorated Minutes will equal the actual clock time that a vehicle was active. The following example should help to illustrate these concepts. In the table below a list of fictitious activities for a vehicle are shown in addition to how the time is allocated to the various measures: ActivityStart Time End TimeElapsed Minutes Elapsed Multitask Minutes Elapsed Single Minutes Prorated Multi Minutes Prorated Minutes 1 10:00 12:00 120 60 60 25 85 3 11:00 13:00 120 120 0 55 55 4 11:30 13:30 120 90 30 40 70 7 13:30 16:00 150 0 150 0 150 Totals510 270 240 120 360 The vehicle was active from 10:00 to 16:00, a total of 6 hours (360 minutes) which is equal to the total of Prorated Minutes. The vehicle performed 8 ½ hours (510 minutes) of work during that 6-hour time span. This can be arrived at by adding the total of Elapsed Multitask Minutes (270) + the total of Elapsed Single Minutes (240). Mladen Gogala Oracle DBA 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
RE: Win termin services alert
Thanks Ron. I currently use rdesktop for that: www.rdesktop.org It doesn't appear to be worthwhile ( at least to me) to compare them, as rdesktop works very well, and is GPL. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 10:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Win termin services alert Jared, LINDESK is a package for linux that allows terminals-services for windows to be used from the linux OS. www.terminal-services.net The product info is linRDP and creates to application lindesk. Ron [EMAIL PROTECTED] 11/03/2003 12:54:26 PM Ok, what is LINDESK? I googled for it, but found nothing informative. Jared Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 04:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Win termin services alert Niall, LINDESK isn't the flaw, it is the method that the server handled the request from a non-windows browser. They have fixed the problem and the application now works from any OS browser. I ment the info to be a potential security alert. Ron [EMAIL PROTECTED] 10/31/03 03:49PM I'm not entrely sure what you are saying here. Terminal Services gives you a remote session on the server. You should have to provide a username and password for this. When you get desktop access it is in the security context of the username/password you have provided. If you had full control that rather suggests that they had provided you with an inappropriate username/password. If I log into a server as root using ssh, I don't consider that to be a flaw in ssh. Now I might be misunderstanding what you are saying here, and it could be that LINDESK doesn't honour the credentials you provide it with, but this also doesn't seem like a terminal services flaw... Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Rogers Sent: 31 October 2003 14:05 To: Multiple recipients of list ORACLE-L Subject: Win termin services alert List. Reguarding Windows Terminal services... It is used to remotely display an action back to the requesting windows client with software control. Usually used in a browser application. We have an application that is browser based and we are instructed to use Windows 2000K as the client. I feel that if an application is browser based I should be able to use and client and browser. I used a browser on Linux with a windows terminal services package installed and connected to the server via a login/passwd with a browser. The problem occured when the software control didn't work and I was dropped to the server desktop. I had full control over the server. I immediatly contacted security... Please be aware of this potential and serious security problem using terminal services. The terminal services package I tested was the LINDESK for linux. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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: Ron Rogers 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: What is a local write wait?
This event is one of those 'you would never see' in normal database operations. As I have mentioned in my earlier post, existance of this event translates in to some serious I/O issues or broken disk in RAID05 or something similar to that.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 03, 2003 10:24 PM Thanks KG. There were underlying OS I/O issues. The SA is looking to fix the same. Regards Raj __ Rajesh L. Rao DCI - Triad, Oracle DBA IBM Global Services, JPMC Account Phone: 516 5746065 E-mail: [EMAIL PROTECTED] K Gopalakrishnan To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: What is a local write wait? o.com Sent by: [EMAIL PROTECTED] ity.com 11/01/2003 09:54 AM Please respond to ORACLE-L Rajesh: Typically DBWR has to free up some buffers when you want to read something from the disk. During this process there are chances that you will be waiting for your local buffer (i.e blocks dirtied/invalidated by your session) to be written to disk. During this time the waits are shown as local write waits. BTW do you have any other write waits or just seeing local waits? And also are you noticing any timeouts for this waits? Typically we wait for local wait up to one second and spin (or retry) again.. Timeouts for local write indicates a serious problem unless you have tiny buffer cache or extremely slow disk' KG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 01, 2003 12:54 PM Was creating an index with a degree of 4, and in unrecoverable manner? There were few waits for an event called local write wait. Can anyone shed more light on this wait? Thanks Raj -- 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: 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).
Re: Oracle EE and SE on same box
We did that this year except it was 8.0.6 SE and 8.1.7 EE. No big issue. Other than having 2 listeners on different ports the most annoying task was that the method of setting the Oracle Home and associated environment variables for the usage by the shell scripts and the database start procedures initiated by server bootstrap had to be changed. This was a server consolidation effort. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Oracle EE and SE on same box Date: Mon, 03 Nov 2003 11:39:35 -0800 Hi: Are there any resources out there (official Oracle or otherwise) that pertain to installing both Enterprise and Standard on the same box. Regards, Gary Norwell Systems Analyst Hybrid Turkeys _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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 7.3.4.0 on Win 2000
Arif, I have not tried this particular arragement (9.2 listener, 7.3.4 db) but, The current Oracle 9i Release 2 (9.2.0.4) listener would be the recommended listener to use. If you do not want to install that version, please use the 8.1.7 listener with the 8.1.7.4.1 and 8.1.7.4.12 patchsets applied. (security issues). I do remember reading of some issues regarding a 9.2 client not connecting to a 7.3.4 database, so you'll want to test this configuration before putting it into production. When you can migrate that database from 7.3.4 to 9.2, no changes will be required on the listener (as the migrated 9.2 database instance will register dynamically) hth. Paul "Arif Khan (GWL)" [EMAIL PROTECTED] wrote: Hello Fellow OraclersHas any of you come across installing Oracle 7.3.4.0 on Windows 2000.Can any of you share your experiences with me. I am aware that 7.3.4.0 is not certified by Oracle to run on Win 2000however my requirements dictate I carry out the stated task. I tried toinstall and it did install OracleServiceOrcl and OracleStartORCLservices however didn't install OracleTNSListener.Any help is appreciatedArif-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Arif Khan (GWL)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). Do you Yahoo!? Exclusive Video Premiere - Britney Spears
Unicode: UTF-16 to UTF-8 conversion
Hi, I have a quick question that doesn't seem to be answered in the documentation. We have a database that has a database character set of WE8ISO8859P1 and a national character set of UTF-16. Currently we are not using any NCHAR, NVARCHAR2 or NCLOB columns, but would like to soon. However, we'd like to use UTF-8 instead of UTF-16. Since there should be no conversion necessary, is there any reason why I can't just alter the national character set to UTF-8? Or am I missing something? While we are on the subject, can anyone recommend for/against UTF-8 or UTF-16. I have read the pros and cons in the manual, but actual experiences could change my mind. Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- 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).
RE: Finding overlapping time periods - suggestions please
Snodgrass is also the author of an excellent book on the subject, available at a bookstore near your browser. Henry Poras [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2003 01:49 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Finding overlapping time periods - suggestions please Also check out http://www.cs.auc.dk/research/DP/tdb/TimeCenter/TimeCenterPublications/TR-28 .pdf by Richard Snodgrass. Henry -Original Message- Mladen Gogala Sent: Friday, October 31, 2003 6:09 PM To: Multiple recipients of list ORACLE-L Ron, it's not as stupid as you might think. Of course, you can use SQL to find all overlaping time periods, but for a large number of intervals, it's not going to be very efficient and it's going to take a very long time. In other words, it's not practical. Spatial option, on the other hand, uses special libraries and floating point to arrive to the target in a more optimal way. And yes, the reasoning is based on mathematics. On 2003.10.31 15:34, Ron Rogers wrote: Mladen, The information might be excellent for the lecture on the Space and Time Continuum but a black hole will destroy all theories of anything overlapping when they are on the same plain. Of course there has to be an guess work theory about where the stuff the black hole consumes ends up, and does it have the ability the grow at a rate proportional the the volume it consumes? Ron mª¿ªm [EMAIL PROTECTED] 10/31/03 02:54PM I have once been asked to suggest the solution for the same problem, and I have suggested a solution which was out of this world, but completely in line with my education of a mathematician. The project was scrapped and I didn't have an opportunity to apply the solution. To start describing the solution, let me remind you that overlapping areas of space would be discovered by using spatial option. To apply the spatial option, you need to define distance function. Temporal difference does satisfy the necessary conditions for a distance function, as far as mathematics is concerned. In mathematics, there is a structure called metric space, which is, basically, a set with a distance function. Distance function d (metric) on set S is a function d:S x S-R which satisfies the following two conditions: a) d(x,y)=0 for all x,y from S. b) d(x,z)=d(x,y)+d(y,z) for every x,y,z from S. (Cauchy inequality). Points in time, with the difference in seconds do satisfy the above conditions, which means that you can define geometry and use spatial option. Next lesson will be about Cauchy sequences, complete metric spaces, continuous functions, contractions and Banach theorem. If Cary got away with queuing theory, why wouldn't I get away with some abstract calculus and general topology? As I've said earlier, I've never actually had an opportunity to actually apply this solution, but it still looks quite elegant to me, despite it's apparent oddity. On 10/31/2003 01:24:37 PM, [EMAIL PROTECTED] wrote: I was wondering if anyone had the need to find overlapping time periods and how to identify them efficiently. Here is the scenario: Elapsed minutes refer to the actual clock time either spent on a given task. Thus an activity that started at 9:00 am and finished at 11:00 am on the same day is said to have 120 elapsed minutes. If one task overlaps another (either completely or partially with another task), then the tasks are said to be multitasked. In that case the system will store the portion of the elapsed time that was multitasked as elapsed multitask minutes and the portion of the time that was not overlapped as elapsed single minutes. In addition, for the portion of time that two or more activities were simultaneously taking place; their time will be divided by the number of simultaneous activities and stored as prorated multi minutes. The sum of Elapsed Single Minutes and Prorated Minutes will equal the actual clock time that a vehicle was active. The following example should help to illustrate these concepts. In the table below a list of fictitious activities for a vehicle are shown in addition to how the time is allocated to the various measures: Activity Start Time End Time Elapsed Minutes Elapsed Multitask Minutes Elapsed Single Minutes Prorated Multi Minutes Prorated Minutes 1 10:00 12:00 120 60 60 25 85 3 11:00 13:00 120 120 0 55 55 4 11:30 13:30 120 90 30 40 70 7 13:30 16:00 150 0 150 0 150 Totals 510 270 240 120 360 The vehicle was
OFA and RAC on raw devices
Hi listers, Configuration : Hp-ux 11i Oracle 9iR2 with RAC (2 nodes) OSD clusterware : MC/Service Guard 11.15 Oracle software is installed on each node and the database is on shared raw devices. Any experience/gotchas implementing OFA on RAC without cluster file systems? In particular, do you share the admin subtree between nodes ? and how (NFS mount ?) Also do you cross-mount archive log file systems ? Thanks in advance for any info or pointers Regards Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: Unicode: UTF-16 to UTF-8 conversion
Alan, Unfortunately UTF-8 and UTF-16 is in fact different in their binary representations and hence you will have to perform a full fledged conversion to map the UTF-16 characters to their UTF-8 binary representation. You can use the dump() SQL function to see this for yourself if you have both an UTF-8 and UTF-16 database. Just store the same string data in both and dump the binary representation to see the difference. Additionally, if you try to just alter the character set you will receive an error back from Oracle that UTF-16 is not an _exact_ subset of UTF-8. The reason for the difference is that UTF-16 always uses 2 bytes for encoding Unicode but UTF-8 can use up to 3 bytes in the extreme case and hence use completely different encoding schemes to both support Unicode. I know this sounds confusing at times but Unicode is the standard and UTF-8 and UTF-16 are some of the encoding schemes implemented to support different versions of Unicode. Referring to your second question about UTF-8 vs. UTF-16, I would suggest UTF8 for both the national character set and the database character set in a mixed 9i and pre-9i environment. If using a pure 9i (in the ideal world!) environment then I would use AL16UTF16 for the national character set and AL32UTF8 for the database character set. The reason being that Oracle will only be supporting and extending these 2 Unicode encodings going forward and you may save yourself another database character set conversion in the near future. Another consideration would be the intensity of string manipulation in your application e.g. string searches, sub stringing, string lengths, etc. The more intense and frequent these operations are the more you would want to go with UTF-16 as this uses a fixed 2 bytes for encoding Unicode and is far more efficient at it than the variable byte length UTF-8 character set. Unfortunately you will have to load test your application to get accurate numbers but I have seen 30% longer response times on intense string manipulation operations (especially wildcard searches e.g. %DE%) after converting an Oracle 8.1.7 database from US7ASCII to UTF8. I know this is not comparing apples with apples, but gives and idea of what the extra byte and linked list/vector lookup can do to performance. HTH, Faan -Original Message- Sent: Monday, November 03, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Hi, I have a quick question that doesn't seem to be answered in the documentation. We have a database that has a database character set of WE8ISO8859P1 and a national character set of UTF-16. Currently we are not using any NCHAR, NVARCHAR2 or NCLOB columns, but would like to soon. However, we'd like to use UTF-8 instead of UTF-16. Since there should be no conversion necessary, is there any reason why I can't just alter the national character set to UTF-8? Or am I missing something? While we are on the subject, can anyone recommend for/against UTF-8 or UTF-16. I have read the pros and cons in the manual, but actual experiences could change my mind. Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- 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: Faan DeSwardt 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 9iR2 on NT sp6
Has anyone run into any problems with this combination? The MetaLink note # 45997.1 says it should work fine, but it would be nice to hear from someone that has implemented 9iR2 on NT. Why NT? I need to put an app on a server that already has licensing for backup software etc. Beats spending $10k on a box and licences for a 4 user app. Thanks, Jared
redhat/oracle
Well with RH latest ordeal of jumping out of simple ISOs and basically no more free software, what is oracle's stand on running on RH?, the paid version only from now on and those linux users out there, what are WE going to do? Looking to see if i need to spend money before end of year for tax write-off :) joe -- 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).
Re: char(1) VS varchar2(1)
Yes! RMOUG Training Days is going to be an incredible event this year! A 2-day conference in Colorado during ski season with a lineup of speakers that rivals the major international conferences, including keynotes by Bill Inmon and Sue Cook! We're going to have a blast; I'm looking forward to meeting you! on 11/3/03 2:59 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! Trailing columns with NULL values do not occupy any space, not even a length byte. Yep, I missed this one. Also, when few trailing null columns aren't stored in a row, this particular rows column count is smaller as well, so the column count in physical table storage can vary... Non-trailing columns with NULL values have a constant value of 0xFF (255) in the length byte consuming just the one byte. Yep, and this means that even fixed-length CHAR datatypes don't consume any space except length byte if they contain nulls. I once saw a recommendation to store your data in char columns if you don't want to have to worry about row size changes and PCTFREE setting... which is mostly a stupid suggestion anyway and doesn't work in case of nulls either. Tanel. P.S. Tim, I assume that we'll meet at RMOUG training days this Feb? -- 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).
Re: 10g new features
Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared
RE: converting sybase stored procedure into oracle sp
Thank you, let me explore it. -Original Message- Todd Boss Sent: Monday, November 03, 2003 3:50 PM To: Multiple recipients of list ORACLE-L Perhaps Oracle Migration Workbench (OMWB) is something you could look at. As I understand, it converts Sybase stored procs to oracle functions by default (since Sybase stored procs can return a result set, but Oracle Stored procs cannot). Todd Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan 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: Todd Boss 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: Sami 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: char(1) VS varchar2(1)
Bill Inmon? Cool. Dan won't tell me more than it's going to be incredible lots of my friends there, even if I do have to fly in at midnight the night before and fly out at midnight the night after :) --- Tim Gorman [EMAIL PROTECTED] wrote: Yes! RMOUG Training Days is going to be an incredible event this year! A 2-day conference in Colorado during ski season with a lineup of speakers that rivals the major international conferences, including keynotes by Bill Inmon and Sue Cook! We're going to have a blast; I'm looking forward to meeting you! on 11/3/03 2:59 AM, Tanel Poder at [EMAIL PROTECTED] wrote: Hi! Trailing columns with NULL values do not occupy any space, not even a length byte. Yep, I missed this one. Also, when few trailing null columns aren't stored in a row, this particular rows column count is smaller as well, so the column count in physical table storage can vary... Non-trailing columns with NULL values have a constant value of 0xFF (255) in the length byte consuming just the one byte. Yep, and this means that even fixed-length CHAR datatypes don't consume any space except length byte if they contain nulls. I once saw a recommendation to store your data in char columns if you don't want to have to worry about row size changes and PCTFREE setting... which is mostly a stupid suggestion anyway and doesn't work in case of nulls either. Tanel. P.S. Tim, I assume that we'll meet at RMOUG training days this Feb? -- 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). __ 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: 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).
Re: redhat/oracle
Well, if RedHat starts exhibitting tendencies of becoming another Microsoft, there are Mandrake, Debian , SuSE and (don't shoot, I'm just kidding) SCO. (duck, and quickly) On 2003.11.03 20:54, Joe Testa wrote: Well with RH latest ordeal of jumping out of simple ISOs and basically no more free software, what is oracle's stand on running on RH?, the paid version only from now on and those linux users out there, what are WE going to do? Looking to see if i need to spend money before end of year for tax write-off :) joe -- 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). -- 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).
Re: 10g new features
Actually, I don't understand what you mean. Here is 9.2: SQL create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL alter tablespace test rename to test01; alter tablespace test rename to test01 * ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared -- 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).
Re: 10g new features
Gopal was joking about the fact that Jared only said 'alter tablespace rename' instead of ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference has this Moving and Renaming Tablespaces: Example This example moves and renames a datafile associated with the tbs_01 tablespace from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': If you only read the subtitle here (first line), you *will* be surprised. Yong --- Mladen Gogala [EMAIL PROTECTED] wrote: Actually, I don't understand what you mean. Here is 9.2: SQL create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL alter tablespace test rename to test01; alter tablespace test rename to test01 * ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared -- 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). __ 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).
Re: redhat/oracle
This is news to me. RH will no longer let you download Linux for free? hmmm Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/ The cheapest version is $179.00 US. Looks like the next version for me will be Gentoo. Jared On Mon, 2003-11-03 at 17:54, Joe Testa wrote: Well with RH latest ordeal of jumping out of simple ISOs and basically no more free software, what is oracle's stand on running on RH?, the paid version only from now on and those linux users out there, what are WE going to do? Looking to see if i need to spend money before end of year for tax write-off :) joe -- 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: 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).
Re: 10g new features
Not sure I get it either. :) The command listed on the 10g site that I referred to is this: alter tablespace ts_user rename to ts_user_01; Renaming a tablespace is apparently possible with 10g. Must be a joke here somewhere I'm missing. Jared On Mon, 2003-11-03 at 20:09, Yong Huang wrote: Gopal was joking about the fact that Jared only said 'alter tablespace rename' instead of ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference has this Moving and Renaming Tablespaces: Example This example moves and renames a datafile associated with the tbs_01 tablespace from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': If you only read the subtitle here (first line), you *will* be surprised. Yong --- Mladen Gogala [EMAIL PROTECTED] wrote: Actually, I don't understand what you mean. Here is 9.2: SQL create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL alter tablespace test rename to test01; alter tablespace test rename to test01 * ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared -- 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). __ 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: 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).
Re: 10g new features
How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename' is possible. Of course. The full syntax is alter tablespace mytablespace rename datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words 'alter', 'tablespace' and 'rename' in there? You'll get it in the morning. ihomo sapien/i think better during the day. Yong --- Jared Still [EMAIL PROTECTED] wrote: Not sure I get it either. :) The command listed on the 10g site that I referred to is this: alter tablespace ts_user rename to ts_user_01; Renaming a tablespace is apparently possible with 10g. Must be a joke here somewhere I'm missing. Jared On Mon, 2003-11-03 at 20:09, Yong Huang wrote: Gopal was joking about the fact that Jared only said 'alter tablespace rename' instead of ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference has this Moving and Renaming Tablespaces: Example This example moves and renames a datafile associated with the tbs_01 tablespace from 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': If you only read the subtitle here (first line), you *will* be surprised. Yong --- Mladen Gogala [EMAIL PROTECTED] wrote: Actually, I don't understand what you mean. Here is 9.2: SQL create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL alter tablespace test rename to test01; alter tablespace test rename to test01 * ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM Subject: 10g new features Found a site with some 10g new features. http://www.adp-gmbh.ch/ora/misc/10g.html I'm sure some will like the new 'alter tablespace rename' http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux Jared -- 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). __ 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: 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). __ 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