RE: Missing a datafile
Kamel, What do you have for backups on the schema(s) that use the tablespace with the missed datafile? Bryan Rodrigues DBA Elcom, Inc. -Original Message- Sent: Wednesday, September 10, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hi List Due to a corrupted controlfile, I create a new controlfile with the CREATE CONTROLFILE statement. Unfortunately I missed one datafile. Is there any solution to for this case. We are running under 8.1.7 release. Thank You. Best Regards Kamel Benlatreche. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning DB from raw device to file system
Hi Sami, I have found under HP-UX, that I can use the dd command to copy the raw device files to a file system without issue. The command syntax I used was: dd if=raw_device_file_name of=destination_file_name bs=8192 Hope this helps, Bryan Rodrigues Oracle DBA Elcom Inc. -Original Message- Sent: Monday, September 08, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List, Good Morning! I have DB-1 which has all the files in raw device. I want to create DB-2 (clone of DB-1) on another server which has file system. Is it possible to create clone DB from raw device to file system( same OS and oracle version)? You help is really appreciated. Thanks Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Cisco security notice mentions the blaster worm possibly affectin
are Copyright © 1992-2003 Cisco Systems, Inc. All rights reserved. -BEGIN PGP SIGNATURE- Version: PGP 6.5.2 iQA/AwUBPzrrJnsxqM8ytrWQEQJ6pwCg2o5QLyxKh3oRAfeWuJuojb0vPRwAoKF+ WzBOI007jdkAXBLTUPt5laVi =+Izn -END PGP SIGNATURE- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Does mts affect explain plans of queries
Hi everyone, I have a development, test and production databases (They are on HP-UX 11.0 with Oracle 8.1.7.4). The development and test databases are setup for Multi Threaded Server (MTS) and production is not (We are still considering whether or not to put it on production, another story). But during the normal day, code is built, changed and tuned. I don't have any particular example, but some of the code that works fine in development and test works very differently in production. The data that exists in development and test is comparable to what is in production. The only difference I see is that development and test are using MTS and production is not. The questions I see are: Would mts affect explain plans of queries to such a degree that they would run differently in a non MTS database? Does the optimizer care whether mts is being used? TIA, Bryan Rodrigues DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Recommended Init File for Standby
Hi Kevin, I guess all I have is more questions: 1) What else do you have running on the server that has your standby database? 2) What is the purpose of the standby database (disaster recovery or reporting)? 3) If it is for disaster recovery, shouldn't the settings on the standby reflect the settings for your non standby database or are you looking at handling bare essentials and not your normal capacity? Maybe some of the answers to these questions will help answer your question to the settings. Bryan Rodrigues -Original Message- Sent: Friday, July 11, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Evening folks; Does anyone happen to have any recommended init file settings for a standby database ?? We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Why does it take so long to write archive logs
Just wanted to say thanks for the information. Bryan -Original Message- Sent: Tuesday, July 08, 2003 6:54 PM To: Multiple recipients of list ORACLE-L |Oracle says it is not their problem. They are waiting for the confirmation |that the file is written. It is written just like any sequential file. It |does not pre-allocate and then load the data. |Yes, the database would stop after it had rolled through all log groups and |could not continue until the oldest one finished archiving. We would see |where other logs would archive just fine while one was taking forever. We |have 8 log groups. So, for example, it would archive 1,2,and 3 then 4 would |just sit there while it archived 5,6,7,8,1,2,3 and then the db would hang. |It has taken over an hour for it to free up sometimes. This happened where |the two machines were sitting side by side with a GigE connection between |them writing to local disks as well as to a remote machine with a NetApp |storage connection. It didn't seem to matter what the device was, just that |it was archiving to another machine. As a work around, we turned off |automatic archiving and used scripts to copy the archive logs. And yes, we |had them set as optional and I believe that is why it let us continue to use |up the other logs but once it wrapped around it could not continue. Even with optional? Arrrggh! Guess I'm not reading the documentation correctly (LOG_ARCHIVE_DEST_N and LOG_ARCHIVE_MIN_SUCCEED_DEST default 1) or perhaps it just hasn't actually failed by taking too long... hmmm... Kip |John |-Original Message- |Sent: Tuesday, July 08, 2003 10:25 AM |To: Multiple recipients of list ORACLE-L |John, |Did Oracle give you any idea as to what Oracle was doing to the archive log |files, while it was waiting for the hardware/network issues to be resolved? |I understand that the redo log information is written the archive log file, |but does Oracle create a file with the correct size allocated and then put |the information into it or does it create the file, write all the |information into it and then update a byte within the file with a check |digit to ensure the file is complete? |TIA, |Bryan |-Original Message- |Sent: Monday, July 07, 2003 7:34 PM |To: Multiple recipients of list ORACLE-L |I had a similar problem on 9.2 and, just as you describe, I could watch the |file on the remote location and the byte count would show the whole file was |there but the alert log file would not show the archive complete for as long |an one hour. When it did finally complete, the byte count on the remote |file did not change. I worked with Oracle for several month before they |finally convinced me it was a network problem. I do not really know |anything about networks so I cannot really help you but our Unix admin guys |made some changes in the network and the problem went away. Sorry, I cannot |give you more info because we were also in the process of changing out a lot |of hardware including network hardware so there is no magic parameter I can |tell you to change. Just talk to your network gurus and hopefully, they can |figure it out. |HTH, |John |-Original Message- |Sent: Monday, July 07, 2003 3:34 PM |To: Multiple recipients of list ORACLE-L |Hello everyone, |We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs |with 3 archive log destinations, the first destination is local to the |machine which is mandatory, the second destination is a filesystem |accessible via nfs which is optional and the third destination is a remote |standby database accessible via a vpn which is also optional. We have 10 |archive processes to take care of the writing of the archives. Both the |local destination and nfs mounted filesystems are on a HP XP256 storage |device. |This morning there was a process running that would update a table that is |used for a catalog of parts. The process was producing archive logs, but the |archives were taking around 10 minutes to write. During the process we would |see the file created with the expected byte count of the file within the |first minute, but the timestamp of the file would indicate access for the |next ten minutes. |We have two other 8.1.7 databases that are setup in a similar manner (that |are not OPS) that have 2 destinations, one local and the other being sent to |a remote standy database. We are not seeing the same type of issue with the |archive logs. |Can someone point me in the direction of either information or advice about |why the archives may be taking so long to write? |Is it that we have 3 destinations and it waits until all 3 destinations are |taken care of? |Why does the archive log file appear to be modified even though the byte |count hasn't changed? |TIA, |Bryan Rodrigues |Elcom, Inc. |Oracle DBA |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Rodrigues, Bryan | INET: [EMAIL PROTECTED] |Fat City
RE: Why does it take so long to write archive logs
John, Did Oracle give you any idea as to what Oracle was doing to the archive log files, while it was waiting for the hardware/network issues to be resolved? I understand that the redo log information is written the archive log file, but does Oracle create a file with the correct size allocated and then put the information into it or does it create the file, write all the information into it and then update a byte within the file with a check digit to ensure the file is complete? TIA, Bryan -Original Message- Sent: Monday, July 07, 2003 7:34 PM To: Multiple recipients of list ORACLE-L I had a similar problem on 9.2 and, just as you describe, I could watch the file on the remote location and the byte count would show the whole file was there but the alert log file would not show the archive complete for as long an one hour. When it did finally complete, the byte count on the remote file did not change. I worked with Oracle for several month before they finally convinced me it was a network problem. I do not really know anything about networks so I cannot really help you but our Unix admin guys made some changes in the network and the problem went away. Sorry, I cannot give you more info because we were also in the process of changing out a lot of hardware including network hardware so there is no magic parameter I can tell you to change. Just talk to your network gurus and hopefully, they can figure it out. HTH, John -Original Message- Sent: Monday, July 07, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hello everyone, We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs with 3 archive log destinations, the first destination is local to the machine which is mandatory, the second destination is a filesystem accessible via nfs which is optional and the third destination is a remote standby database accessible via a vpn which is also optional. We have 10 archive processes to take care of the writing of the archives. Both the local destination and nfs mounted filesystems are on a HP XP256 storage device. This morning there was a process running that would update a table that is used for a catalog of parts. The process was producing archive logs, but the archives were taking around 10 minutes to write. During the process we would see the file created with the expected byte count of the file within the first minute, but the timestamp of the file would indicate access for the next ten minutes. We have two other 8.1.7 databases that are setup in a similar manner (that are not OPS) that have 2 destinations, one local and the other being sent to a remote standy database. We are not seeing the same type of issue with the archive logs. Can someone point me in the direction of either information or advice about why the archives may be taking so long to write? Is it that we have 3 destinations and it waits until all 3 destinations are taken care of? Why does the archive log file appear to be modified even though the byte count hasn't changed? TIA, Bryan Rodrigues Elcom, Inc. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: John Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Why does it take so long to write archive logs
Hello everyone, We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs with 3 archive log destinations, the first destination is local to the machine which is mandatory, the second destination is a filesystem accessible via nfs which is optional and the third destination is a remote standby database accessible via a vpn which is also optional. We have 10 archive processes to take care of the writing of the archives. Both the local destination and nfs mounted filesystems are on a HP XP256 storage device. This morning there was a process running that would update a table that is used for a catalog of parts. The process was producing archive logs, but the archives were taking around 10 minutes to write. During the process we would see the file created with the expected byte count of the file within the first minute, but the timestamp of the file would indicate access for the next ten minutes. We have two other 8.1.7 databases that are setup in a similar manner (that are not OPS) that have 2 destinations, one local and the other being sent to a remote standy database. We are not seeing the same type of issue with the archive logs. Can someone point me in the direction of either information or advice about why the archives may be taking so long to write? Is it that we have 3 destinations and it waits until all 3 destinations are taken care of? Why does the archive log file appear to be modified even though the byte count hasn't changed? TIA, Bryan Rodrigues Elcom, Inc. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Which method is more efficient
Yes, I am in archive log mode and I have had 2 occurances of filling up the archive log filesystem, but I don't want to change one problem for another. Bryan -Original Message- Sent: Wednesday, May 28, 2003 3:20 PM To: Multiple recipients of list ORACLE-L have you run it? isnt that alot slower? you have alot of context switches also. for every record to update, you then switch to SQL. what kind of efficiency improvement are you going for? Speed or cutting down on redo? Are you in archivelog mode and dont want to blow up your archives? From: Rodrigues, Bryan [EMAIL PROTECTED] Date: 2003/05/28 Wed PM 02:40:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Which method is more efficient The fields that are changed are determined by 1) A loop would start until all records in parts change table are done 2) Select a part record from the part changes table 3) Select the same part from the existing part table 4) Compare the value in the parts changes table against the corresponding field in the part table 5) After comparing all fields in the records, create record in a seperate work table with the values populated with null if the field values matched and the new value if the values did not. 6) This loop would continue until all parts are done. 7) After any records in the work table where all fields (outside of part number) are null are deleted. This process normally will decrease the number of records to be processed after this point by 75%. Hope that helps, Bryan -Original Message- Sent: Wednesday, May 28, 2003 1:21 PM To: Multiple recipients of list ORACLE-L oh i missed part of it. the question is how do you figure out which fields have changed? if you have to do an anti-join on each field, then do an update of every field. the question is how will you determine which fields have changed? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/05/28 Wed PM 12:59:51 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Which method is more efficient Bryan - If this is a critical issue, I would try it both ways on a test database and use log miner to examine the amount of redo that is generated. My recollection is that you will find that the redo record records the before and after data for each field. So just updating all fields may generate significantly more redo. But don't trust my recollection on this issue, test it yourself. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Hello everyone, I have a question for the group of which method is more efficient. To set the stage my company has a process to load part changes from vendors into the tables in an 8.1.7.4 Oracle database with archiving on and this database has a standby database at disaster recovery site, so nologging is not an option. There is a discussion going on as to which method is more effective for updating the information in a table. In looking at effectiveness, I am looking at reducing the amount of redo information produced and having the database do the least amount of work. 1) Method 1 is to update the information only for the fields that have changed, 1 field at a time. 2) Method 2 is to update the information for all the fields in the record whether they have changed or not, 1 record at a time. The size of the record is 1843 bytes and the distribution of field sizes: 2 fields varchar2(240). 1 field varchar2(150) 15 fields varchar2(50) 1 field varchar2(3) 2 fields varchar2(20) 4 fields varchar2(40) 3 fields varchar2(1) 2 fields varchar2(25) 2 fields number(10,2) 1 field number(13,2) 1 field number(1) 1 field number 1 field varchar2(6) 1 field number (17,2) 1 field varchar2(4) 3 fields that are date. In the past couple of months the average number of fields changed per record was 3 to 4 fields per record. Thanks for your help, Bryan Rodrigues Oracle DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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
RE: Which method is more efficient
Jared, That is correct the fields that are changed is known before going to this point. Bryan P.S. I just want to say thank you for all the responses to this question. We are still talking about the issue, but I am thankful for the input. -Original Message- Sent: Thursday, May 29, 2003 2:10 PM To: Multiple recipients of list ORACLE-L dunno about that. I was making the assumption that *which* columns changed was already known. This would require testing by someone familiar with the data. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/29/2003 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Which method is more efficient Jared, Agreed, but what about the resources needs to find _which_ column changed ?? Would that offset the extra redo generated? Heck, I'd just generate the update statements based on two tables to _only_ update the changed columns. It is pretty easy, if both tables have _same_ columns ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, May 28, 2003 6:15 PM To: Multiple recipients of list ORACLE-L There are easier ways to test redo generation than mucking about with logminer. Update only the column that changes and check redo generation: 15:06:09 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL @t1 [ much stuff deleted ] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Which method is more efficient
Hello everyone, I have a question for the group of which method is more efficient. To set the stage my company has a process to load part changes from vendors into the tables in an 8.1.7.4 Oracle database with archiving on and this database has a standby database at disaster recovery site, so nologging is not an option. There is a discussion going on as to which method is more effective for updating the information in a table. In looking at effectiveness, I am looking at reducing the amount of redo information produced and having the database do the least amount of work. 1) Method 1 is to update the information only for the fields that have changed, 1 field at a time. 2) Method 2 is to update the information for all the fields in the record whether they have changed or not, 1 record at a time. The size of the record is 1843 bytes and the distribution of field sizes: 2 fields varchar2(240). 1 field varchar2(150) 15 fields varchar2(50) 1 field varchar2(3) 2 fields varchar2(20) 4 fields varchar2(40) 3 fields varchar2(1) 2 fields varchar2(25) 2 fields number(10,2) 1 field number(13,2) 1 field number(1) 1 field number 1 field varchar2(6) 1 field number (17,2) 1 field varchar2(4) 3 fields that are date. In the past couple of months the average number of fields changed per record was 3 to 4 fields per record. Thanks for your help, Bryan Rodrigues Oracle DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Which method is more efficient
The fields that are changed are determined by 1) A loop would start until all records in parts change table are done 2) Select a part record from the part changes table 3) Select the same part from the existing part table 4) Compare the value in the parts changes table against the corresponding field in the part table 5) After comparing all fields in the records, create record in a seperate work table with the values populated with null if the field values matched and the new value if the values did not. 6) This loop would continue until all parts are done. 7) After any records in the work table where all fields (outside of part number) are null are deleted. This process normally will decrease the number of records to be processed after this point by 75%. Hope that helps, Bryan -Original Message- Sent: Wednesday, May 28, 2003 1:21 PM To: Multiple recipients of list ORACLE-L oh i missed part of it. the question is how do you figure out which fields have changed? if you have to do an anti-join on each field, then do an update of every field. the question is how will you determine which fields have changed? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/05/28 Wed PM 12:59:51 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Which method is more efficient Bryan - If this is a critical issue, I would try it both ways on a test database and use log miner to examine the amount of redo that is generated. My recollection is that you will find that the redo record records the before and after data for each field. So just updating all fields may generate significantly more redo. But don't trust my recollection on this issue, test it yourself. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, May 28, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Hello everyone, I have a question for the group of which method is more efficient. To set the stage my company has a process to load part changes from vendors into the tables in an 8.1.7.4 Oracle database with archiving on and this database has a standby database at disaster recovery site, so nologging is not an option. There is a discussion going on as to which method is more effective for updating the information in a table. In looking at effectiveness, I am looking at reducing the amount of redo information produced and having the database do the least amount of work. 1)Method 1 is to update the information only for the fields that have changed, 1 field at a time. 2)Method 2 is to update the information for all the fields in the record whether they have changed or not, 1 record at a time. The size of the record is 1843 bytes and the distribution of field sizes: 2 fields varchar2(240). 1 field varchar2(150) 15 fields varchar2(50) 1 field varchar2(3) 2 fields varchar2(20) 4 fields varchar2(40) 3 fields varchar2(1) 2 fields varchar2(25) 2 fields number(10,2) 1 field number(13,2) 1 field number(1) 1 field number 1 field varchar2(6) 1 field number (17,2) 1 field varchar2(4) 3 fields that are date. In the past couple of months the average number of fields changed per record was 3 to 4 fields per record. Thanks for your help, Bryan Rodrigues Oracle DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Oracle Silent Installs and Response files...
Greg, If you are upgrading to Oracle 8.1.7.4 on a hp-ux server without an X-term and trying to use silent install to get around it, don't do it. A DBA I work with was trying to do it and ran into issues. I researched it on metalink and found a thread that listed 3 bugs associated with this situation. BUG:754480 Silent Install from TELNET Session Gives Error: DISPLAY NOT SET BUG:763584 Runinstaller Expects DISPLAY Variable to be Set for Silent Install BUG:1191382 OUI Installer Requires an X-DISPLAY to Connect to even in Silent Mode I have not tried it in other situations, but be aware of this one. Bryan Rodrigues Elcom, Inc. DBA -Original Message- Sent: Friday, January 17, 2003 9:25 AM To: Multiple recipients of list ORACLE-L Hey guys- Have any of you all messed around with the silent install/response files? I'm looking for tips, advice, do's, don'ts,etc,etc TIA Greg Loughmiller Sr Manager - Enterprise Data Architecture gloughmiller (IPS) 678.893.3217 (office) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are ODBC connection handles shareable over multiple threads?
Grant, Thanks for the short answer, is there anything in the long answer, that I should warn the developer of? Thanks, Bryan -Original Message- Sent: Monday, October 07, 2002 8:53 PM To: Multiple recipients of list ORACLE-L threads? Rodrigues, Bryan[SMTP:[EMAIL PROTECTED]] wrote: Hi everyone, A developer who is working on an application to retrieve data from an 8.1.7 database using ODBC asked me this question, Are the connection handles for the odbc version 8.1.7.6 shareable across multiple threads?. I had to tell him I didn't know but I would look it up and ask around if anyone knew. So as I do research on my side, If someone could give me an answer or a good place to find the answer, I would be thankful. Bryan, The short answer is yes, they are. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Are ODBC connection handles shareable over multiple threads?
Hi everyone, A developer who is working on an application to retrieve data from an 8.1.7 database using ODBC asked me this question, Are the connection handles for the odbc version 8.1.7.6 shareable across multiple threads?. I had to tell him I didn't know but I would look it up and ask around if anyone knew. So as I do research on my side, If someone could give me an answer or a good place to find the answer, I would be thankful. TIA, Bryan Rodrigues DBA Elcom Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sqlloader 8.1.7.4 problem
Hello everyone, I am having a problem with sqlloader version 8.1.7.4 on HP-UX. I am trying to load a 13mb file that does not contain carriage returns. When I run it in sqlloader I receive the following: SQL*Loader-500: Unable to open file (/usr/local/bell_logix/tax/SEQMAST.dat) SQL*Loader-555: unrecognized processing option But when I run the same file using the same control file with sqlloader 7.3.4 connecting to the same database it runs fine. I have opened a tar with Oracle but results have been disappointing. It is probably something simple, but could someone please help me? Thanks, Bryan Rodrigues DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4
Mladen, Could you please speak more on the serious problems of 8.1.7.4 on HP/UX 11/64 with OPS? Thank you, Bryan Rodrigues DBA Elcom, Inc. -Original Message- Sent: Friday, August 30, 2002 4:24 PM To: Multiple recipients of list ORACLE-L Speaking of the recursion, now 8.1.7.4 has some serious problmes, especially on HP-UX 11/64 with OPS. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, August 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4 My understanding is that 8.1.7.3 is the buggy one. It was supposed to be the terminal 8.1.7 release but it had so many problems they had to come out with 8.1.7.4 -Original Message- Sent: Thursday, August 29, 2002 5:44 PM To: Multiple recipients of list ORACLE-L DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct from 8.1.6.x to 9.2.0.1... ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Maintenance of listener.log files
Thank you for the ideas on maintaining a reasonable size listener.log file.
I am trying out the scripts now in development to see which one works the
best for me.
Bryan
-Original Message-
Sent: Saturday, August 24, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
You can do it online. I have a CRON job which periodically truncates the
file to the last X (e.g. 2) lines. In this code, I've added your
requirement
to archive and preserve the log.
e.g
#!/usr/bin/sh
set `date`
ORACLE_HOME=/u01/app/oracle/product/8.1.7;export ORACLE_HOME
cd $ORACLE_HOME/network/log
find . -name 'listener.log.preserve*' -mtime +15 -exec rm {} \;
cp listener.log listener.log.preserve.$1$2
touch to_overwrite
#optional : keep the last 2 lines of the logfile
#tail -2 listener.log to_overwrite
cat to_overwrite listener.log
Test the script before you use it.
Essentially, you can overwrite the listener.log online -- but you should
not try to rm or mv it .
Hemant
At 08:53 AM 23-08-02 -0800, you wrote:
Hello all,
I have an 8.1.7.4 database on 11.0 HP-UX server with a listener.log file
and
it records information as long as the listener is up. The problem is that
the listener is always up and the file is getting larger and larger. I am
looking for a way to periodically copy the data from the listener.log to
another file (that would be around for two weeks and then purged) without
having to bring the listener down. It seems like one of those tricks of
replacing a tire on a car while it is still being driven.
TIA,
Bryan Rodrigues
DBA
Elcom, Inc.
Hemant K Chitale
Now using Eudora Email. Try it !
My home page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Install Pro*C
Ron, I believe you need to install the pro*c compiler from the installation disks, but it is on the client option. Bryan -Original Message- Sent: Wednesday, August 21, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Someone forgot to install Pro*C on our 8.1.7 Sun server. I need to install it. Is there anything that needs to be done after I run the installer? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db doesn't show in OEM ???
Are the databases listed in the tnsnames.ora file? Bryan -Original Message- Sent: Thursday, August 15, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Hi, I have two local databases on my machine. In OEM, after I find node, one db show but the other doesn't. How does that happen? OEM(2.2.0.0.0), Oracle 817 on Win2000. Thank you. Janet __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Error while invoking Email from PL/SQL
K.
Do you have java virtual machine installed? The package in the error it is
looking for dbms_java is created during the initjvm.sql script. It looks
like either jvm is not installed or failed during the install.
Bryan
-Original Message-
Sent: Monday, August 12, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL @initplsj.sql
call dbms_java.set_output(1)
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
call dbms_java.loadjava('-resolve plsql/jlib/plsql.jar')
*
ERROR at line 1:
ORA-06576: not a valid function or procedure name
And then I tried to run
loadjava -user sys/*** plsql.jar, again to no avail
Thanks in advance
K.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: karthikeyan S
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: killing sessions
If your environment is mts be very careful about killing sessions. In some cases the killed session does not die until the instance is stopped and started. Bryan Rodrigues DBA Elcom Inc. -Original Message- Sent: Thursday, July 11, 2002 2:51 PM To: Multiple recipients of list ORACLE-L We have developers who occassionally want to be able to kill their sessions in a dev instance. We are concerned about giving them alter system priviledge and were wondering what people do about this. Is there any other way they can do this? Do some shops allow certain users to do this with some training? Thanks. Joe [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Armstrong-Champ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: High % sys after Installing Solaris 8 on APP Server - SOLVED
Sounds like you had oracle trace running. A seldom useful and sometimes problem causing utility. Bryan Rodrigues -Original Message- Sent: Wednesday, July 10, 2002 11:48 AM To: Multiple recipients of list ORACLE-L process.dat regid.dat Files Existing in $ORACLE_HOME/otrace/admin on APPLICATION Server were Causing the High %sys Utilization . Deleted the 2 whereafter %sys returned to Normal NOTE - These files were get created as part of Oracle Installation . Hope this helps -Original Message- Sent: Sunday, July 07, 2002 6:51 AM To: VIVEK_SHARMA hi Vivek, i hope your problem got resolved as you didn't summarize as yet. keep in touch. Regards, Amit System Administrator Office: 510.252.4338 Mobile: 510.825.4356 E-mail: [EMAIL PROTECTED] www.santelnet.com Experience is that marvelous thing that enables you recognize a mistake when you make it again. Il y a des fleurs partout pour qui veut bien les voir. -Henri Matisse -Original Message- Sent: Monday, June 17, 2002 11:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] E10K Specific Patches + Generic Solaris 8 Patches have been applied by the Sys Admin /etc/system parameters have Also been Changed NOW Unfortunately I am NOT much acquainted with Sys Administration , So if you have Any Specific Pach Numbers OR /etc/system parameters please tell them Explicitly Also the DB APP Servers have been interchanged i.e. Application S/w moved to the machine which was previously Containing the Database vice-versa to see if it is a machine specific Issue whether HIGH % sys Utilization Occurs after interchange too . This was done Because % sys Utilization on DB Server machine was observed to be LOW (10 to 15 %) when the same was High (50 to 90 %) on APP Server Under Load We have yet to see How the %sys will be after moving the Application to the machine which was previously Containing the Database NOTE - DB Server is also an E10K machine like APP Server Thanks -Original Message- Sent: Tuesday, June 18, 2002 3:54 AM To: VIVEK_SHARMA Hi Vivek, i am not an Oracle expert but check with Sun for Solaris 8 release compatibilty with the Starfire(E10K) as some of the older E10K's sold with Solaris 2.6 were never tested for Solaris 8 performance and i suspect your E10K is one of that lot of Starfire's sold.i may be wrong but still check it out as it may help you isolate the cause. Please also do check your /etc/system shared memory and semaphore parameters too. Regards, Amit -Original Message- [mailto:[EMAIL PROTECTED]]On Behalf Of VIVEK_SHARMA Sent: Monday, June 17, 2002 12:09 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] % sys Shot up to Values Ranging from 50% to 90 % (of sar Command) on Installing Solaris 2.8 after Removing the previously Existant Solaris 2.6 on APP Server under Load . Previous % sys Utilization were 15% to 20 % on Solaris 2.6 under Similar Load Application Software Oracle Exes remained UNChanged Oracle ver 7.3.4 m/c E1 Problems happenign on a LIVE Productionm/c ___ sunmanagers mailing list [EMAIL PROTECTED] http://www.sunmanagers.org/mailman/listinfo/sunmanagers -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on Oracle Warehouse Builder 9.0.2
Hello, I am trying to create mapping between the source database and the warehouse database. I keep receiving an error api8015: length is not supported for data type float. I have validated the table and generated the object, but the mapper does not like it. TIA, Bryan Rodrigues DBA Elcom, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: NEED YOUR OPINION
Hamid,
I believe the problem is in your 'to_number(a.MSC_SERVICE_CODE)' section in
your where clause. This is trying to do a to_number on a field that could
have a non numeric value in the field.
Hope this helps,
Bryan Rodrigues
-Original Message-
Sent: Monday, June 24, 2002 7:23 PM
To: Multiple recipients of list ORACLE-L
List,
I have a table with the following structure:
CREATE TABLE SERVICE_CODE_MSC (
MSC_SERVICE_ID NUMBER (4)NOT NULL,
MSC_SERVICE_CODEVARCHAR2 (30) NOT NULL,
CONSTRAINT MSC_PK
PRIMARY KEY ( MSC_SERVICE_ID, MSC_SERVICE_CODE )
USING INDEX
TABLESPACE USERS
Here is some sample of this table:
service_id service_code
- --
7 a1000
7 a2000
30 e1230
30 e1234
10 12098
20 130987
When I run the followinh query on this table I get invalid
number(ORA-01722), then when I drop tha table and reload the data the query
running OK, Here is the query I am running:
select count(*)
from (select MSC_SERVICE_CODE,MSC_MTF_SERVICE_ID
from MTF_SERVICE_CODE_MSC
where
substr(MSC_SERVICE_CODE, 1, 1) in
('9','8','7','6','5','4','3','2','1','0')) a
where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?
Thanks Allot.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law. If you have received
this message in error, you are prohibited from copying, distributing, or
using the information. Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodrigues, Bryan
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: V$SQLTEXT text length
Jesse, You could access the v$sqltext. It contains the whole query in 64 character sections. it is not as organized as sql_text in v$sqlarea, but if you put all the rows with sql_text field ordered by piece column you will have the full query. Bryan Rodrigues -Original Message- Sent: Wednesday, June 12, 2002 4:05 PM To: Multiple recipients of list ORACLE-L While researching some shared_pool problems groan on an 8.1.6 instance, I happen to notice that the SQL_TEXT column of the V$SQLAREA view is only 1000 bytes. What happens when the statement is longer than that? Does it just not show all of it in that view? Just curious. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: duplexing the archive redo log directory
Matt, Do not alter the LOG_ARCHIVE_DUPLEX_DEST parameter online. Altering a parameter that uses a / in its value will cause problems doing selects on v$parameter table see document 136791.1. I ran into this issue and had to bounce both instances to resolve the issue. Bryan -Original Message- Sent: Thursday, June 06, 2002 3:16 PM To: Multiple recipients of list ORACLE-L Anybody encountered any bugs relating to the LOG_ARCHIVE_DUPLEX_DEST and LOG_ARCHIVE_MIN_SUCCEED_DEST parameters in 8.1.6 or 8.1.7? Matt Adams - GE Appliances - [EMAIL PROTECTED] Contrary to popular opinion, Unix is user friendly. It's just particular about who it makes friends with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback segment shrinks
Terry, Can you see if there are any session(s) (runaway or not) that might be causing your rollback segments to fill up? Until you can figure out what sessions are filling up the rollbacks you will be stuck adding more space until those session(s) end. Bryan -Original Message- Sent: Wednesday, June 05, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.6.3 on Sun Solaris 2.6. The rollback tablespace filled up last night and the rollback segments became full. I added space to the tablespace and tried shrinking the rollback segments. They remained full, so I altered them offline and online. The extents are increasing, but I still can not get a shrink to work. If they don't stop increasing, my tablespace will fill up again and I can't keep throwing disk at it. Since this is a production system, bouncing is not an option. Any ideas? TIA Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Has anyone applied patchset 8.1.7.4 on a HP 11.0 32 bit OPS envi
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on V$ping table
Hello everyone, I am trying to track down excess pinging in an OPS cluster and I was looking at the contents of the v$ping table. I looked at the contents last night before I left and saw numbers in a fairly high range, but when I did the same query this morning the numbers were much lower than the previous night.Can someone tell me if the contents of the v$ping table cumlative or are they as of the the time of the query? Thanks, Bryan Rodrigues -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on V$ping table
John, I double checked it and both instances were lower than the initial readings. One thing I have found out since my initial question is that the v$bh table that Michael had referred to is based on sga db buffers. So there is the possibility of something that could of had a lot of pinging but was aged out of the dba buffers, this could reduce the numbers in the v$ping table. Bryan -Original Message- Sent: Wednesday, May 29, 2002 6:21 PM To: Multiple recipients of list ORACLE-L Are you sure you are comparing the v$ping table from the same instance each time. Easy mistake to make (lol ) John -Original Message- Sent: 29 May 2002 20:34 To: Multiple recipients of list ORACLE-L This view is based on v$bh which is cumulative... So... YES! Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Bryan Sent: Wednesday, May 29, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Hello everyone, I am trying to track down excess pinging in an OPS cluster and I was looking at the contents of the v$ping table. I looked at the contents last night before I left and saw numbers in a fairly high range, but when I did the same query this morning the numbers were much lower than the previous night.Can someone tell me if the contents of the v$ping table cumlative or are they as of the the time of the query? Thanks, Bryan Rodrigues -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael P Sale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TOAD S/w
Try www.quest.com, I believe this is the company's web site. Bryan -Original Message- Sent: Wednesday, May 22, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Any Docs , Links ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to enable Java
Hi Joe, Check out oracle document note:156477.1 JVM installation on 8.1.7 for details. Bryan -Original Message- Sent: Tuesday, May 21, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi Joe, I think you need to run the following from the sys account /javavm/install/initjvm.sql -- setup database for running Hava and the ORB /rdbms/admin/initplsj.sql -- initializes java libraries for pl/sql There may be other scripts depending on your needs but I think these you must run. System requirements (these are just recommendations) SHARED_POOL_SIZE = 65 MB JAVA_POOL_SIZE = 50 mb 50 MB free in the system tablespace 250 MB of rollback segment space Rick Joe LaCascio jlacasci@whea To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tonma.edu cc: Sent by: Subject: How to enable Java [EMAIL PROTECTED] om 05/21/2002 09:18 AM Please respond to ORACLE-L Hi folks: I'm installing IAS on our web server which is a DEC Alpha 800, one of the steps says that Java isn't enabled on the database that the IAS will work with. This database TEST is running on a DEC Alpha 4100, the TEST database is an 8.1.6 database. The IAS install says to use dbassist to turn on Java. Okay, I ran dbassist, checked change a database configuration selected TEST and clicked next. A new window pops up, stays blank and nothing happens. No status bar, no info, just the blank window. After 10 minutes I cancelled the process. I've tried this with the database down, and dbassist opens the database. I've tried it with the TEST database up in restricted and still same thing. Any ideas? Any way to enable Java by running a script? Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Freeze
One way is to do a system state dump level 10. It is done either as svrmgrl or as sqlplus with sysdba privileges. You would use the command alter sesssion set events 'immediate trace name systemstate level 10'; (if you do not have a large user dump file capacity you can alter your session to increase it). This needs to be done on all nodes of the cluster while the cluster is hanging. The dump may take up to 10 minutes to complete, but Oracle will require this for their investigation of the issue. The dump files will be found in the udump directory. We are on 8.1.7.2.1 on HP-UX and we had a similar type of problem and Oracle had me do this when it happened. They were able to use the files in their investigation. Good luck with the issue, Bryan -Original Message- Sent: Tuesday, May 21, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Can a database go down because of too few locks?
Can anyone tell me if an ops database can be brought down because of too few locks being allocated for the database? Thanks, Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Can a database go down because of too few locks?
Tim, You hit the nail right on the head. Thanks for your answer, Bryan -Original Message- Sent: Thursday, May 16, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Depends on what you mean by down, doesn't it? Many define down as unusable, despite the fact that connections can be made and SQL statements can be processed. If you're referring to the parameters that start with the prefix LM_*, then no, the database instance won't crash/halt/abend. If you underconfigure the LM_ parameters then you can expect OPS/RAC to take what it needs for DLM resources from the Shared Pool, resulting in terrible performance and lots of messages to the alert.log. The instances also may not start if you had requested too many resources using the parameters that start with the prefix GC_* (specifically GC_FILES_TO_LOCKS), but I'm not certain of that. I've always used a liberal hand in initially allocating DLM parameters and then monitoring the V$RESOURCE_LIMIT view to consider chopping back (or adding more) as usage patterns become apparent. Clustered systems should not be memory-constrained -- this would be a fine example of penny-wise, pound-foolish, as the cost of RAM is small compared to the overall (direct and indirect) costs of a clustered configuration. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 8:38 AM Can anyone tell me if an ops database can be brought down because of too few locks being allocated for the database? Thanks, Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TEMP tablespace growing abnormally
Do you have auto extend on the temp tablespace? Bryan -Original Message- Sent: Tuesday, May 14, 2002 2:10 PM To: Multiple recipients of list ORACLE-L Hi all, Having a bad start of week. My temp tablespace is growing abnormally -from 3GB - 32 GB (Filled up disk). DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running billing application for appx 200,000 customer base. Initially set-up as OPS but undone though init.ora file still has PARALEL_SERVER=TRUE, only one node is active. I've seen a refernce to OPS in relation to de-allocation of extents but can't get further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TEMP tablespace growing abnormally
Simon, If auto extend is on the tablespace and there is a runaway or resource intensive process that is using up a great amount of temp space, Oracle will keep expanding the size of the tablespace until you have run out of space on the disk. Bryan -Original Message- Sent: Tuesday, May 14, 2002 5:08 PM To: Multiple recipients of list ORACLE-L Yes, But this shouldn't warrant 'indefinite extension' of the TB ?!? -Original Message- Sent: Tuesday, May 14, 2002 9:39 PM To: Multiple recipients of list ORACLE-L Do you have auto extend on the temp tablespace? Bryan -Original Message- Sent: Tuesday, May 14, 2002 2:10 PM To: Multiple recipients of list ORACLE-L Hi all, Having a bad start of week. My temp tablespace is growing abnormally -from 3GB - 32 GB (Filled up disk). DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running billing application for appx 200,000 customer base. Initially set-up as OPS but undone though init.ora file still has PARALEL_SERVER=TRUE, only one node is active. I've seen a refernce to OPS in relation to de-allocation of extents but can't get further. Any help will be appreciated. --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anybody get a 1630 error when trying to add an index ?
Have you checked the amount of max extents in the tablespace? The error you listed is saying that it is running out of extents in dealing with temporary objects created in the tablespace being used. Bryan -Original Message- Sent: Monday, May 13, 2002 3:33 PM To: Multiple recipients of list ORACLE-L I have been trying to add an index to a index tablespace and I keep getting a 1630 error. I have 500 extents , but it says the max extents are only 121 and they are filling up. Maybe my dendrites have been temporarily fried and it is something simple. Thanks for your time in advance. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Database
Ramon, Are you able to do a refresh from a hotbackup of the database? Bryan -Original Message- Sent: Tuesday, May 07, 2002 10:29 AM To: Multiple recipients of list ORACLE-L I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shared pool memory issue on OPS (non-MTS)
No messages in the alert log about dynamic lock allocation, the node that is having the issue has a small load on it right now and the memory is still being used up. Thanks -Original Message- Sent: Thursday, May 02, 2002 3:29 PM To: Multiple recipients of list ORACLE-L Any messages in the alert file, like dynamic lock allocation or resource allocation ? In Oracle8 locks and resources for OPS are dynamically allocated from the shared pool after the initial values of _LM* are used. You can monitor that in v$resource_limit. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 9:03 PM Hello, We are working on (2) HP 9000 64 bit HP-UX 11.0 in an OPS cluster (non mts) on version 8.1.7.2.1 32 bit, we were encountering ora-4031 errors on one of the instances, so we increased the amount of shared pool memory from 100mb to 200mb on both nodes in the cluster. Since the shared pool memory was increased the instance on the node that had the error is no longer encountering it. But now the instance on the other node that was not having any issue, is able to keep only 1% of the shared pool memory free and has hung 2 times. We are working with Oracle, but would appreciate any ideas. We know that we have 'bind variable' issues, but not enough to get us into the situation that we now face. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shared pool memory issue on OPS (non-MTS)
was increased the instance on the node that had the error is no longer encountering it. But now the instance on the other node that was not having any issue, is able to keep only 1% of the shared pool memory free and has hung 2 times. We are working with Oracle, but would appreciate any ideas. We know that we have 'bind variable' issues, but not enough to get us into the situation that we now face. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shared pool memory issue on OPS (non-MTS)
from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
