Processing speed for Images
Title: Processing speed for Images Hi, Background: We user scanners to scan images of the documents and store it on our NT server. The documents are later shown to the user in data-entry screens for capturing the required information. We make use of *read_image_file* to populate the image item. This works successfully without any errors. In the data entry screen, User captures information from one image and presses commit (f10). The next image is populated automatically and user continues with the data capture. Issue: The response time. It takes approximately upto 4-5 seconds to show an image. Our data-entry operators are very fast and they want the image population time to be brought down. We tried this with Java and the response time was very fast, as we were storing the images in memory, in advance. Is it possible to do the same in form builder itself, or any other feature that can improve the processing speed of images in forms? Image type: JPG files sized around 50-80k. Stored on the network file server. rgds amar http://amzone.netfirms.com
RE: Any other OCP discount code ? S36 code can no longer be used
Cheers, that should save a few pounds. I actually decided to stop being lazy and looked it up myself, Thanks, JIm -Original Message- Ling Catherine (CSC) Sent: 12 January 2002 01:00 To: Multiple recipients of list ORACLE-L used Hi Jim, I use OTN20. 20% discount. Regds, New Bee -Original Message- From: James McCann [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 6:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Any other OCP discount code ? S36 code can no longer be used Hi, could you pass it on to me please, Thanks, Jim -Original Message- Ling Catherine (CSC) Sent: 11 January 2002 06:25 To: Multiple recipients of list ORACLE-L used Dear All, I've found the discount code. Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Friday, January 11, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Subject:Any other OCP discount code ? S36 code can no longer be used Dear Gurus, The education discount code S36 can no longer be used to get 20% discount from the OCP Test. Does anyone know of any discount code ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
TOAD Software???
Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dynamic views in 8.1.6
we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
Been there, done that, BOUGHT it. All our DBA's (4) are working with it. Mind you, this is a tool for DBA. We bought PlSqlDeveloper for the development stuff. A very good Swiss army knife for the dba. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Relika Shetty [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
Well, it is much better than standard SQL*Plusgives u a lot of GUI options and other functionalities. For that matter, most of the products of Quest Software are quite good..especially their performance monitoring tools. Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 14 January 2002 12:00 To: Multiple recipients of list ORACLE-L Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need SQL*Loader Coding Help
I need some help coding this scenario. I have multiple records coming in a delimited flat file. Some of the records are: RegNumber Cnum1 Cnum2 . . . Cnum10 There can be data in 1 to 10 of these fields. I need to load this into this table. Trademark_Class_Data Registration_Number (FK) Class_Code_ID (FK) An example of the code. RegNumber - 65304 Cnum1 - 45 Cnum2 - 54 Cnum3 - 100 So, my question is how do I code this so that I create 3 records in this table as? Registration_Number Class_Code_ID 65304 45 65304 54 65304 100 I need to take data that is contained in 1 record and load it into 3 records. Any help you can give me will be greatly appreciated. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Uninstall oracle
As an experiment i tried installing oracle 8 (for NT) on my PC at home (which is win2k)it crashed at an early stage( with some OS error-obviously) How do i uninstall this crashed version? and why does oracle 8i (for NT) install without a problem? cheers all -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP discount is avaialable still?
Thanks for the replies. I have checked it again, the 'S36' discount is not avaialable anymore. You guys maight have read other thread on the same topic in this list, someone mentioned about a new discount code, 'OTN20'. I will try if it works. Thanks, Suren -Original Message- Sent: Wednesday, January 09, 2002 10:40 PM To: Multiple recipients of list ORACLE-L Hi... I think the discount is still available, I am working in IT consultant company and we are a member of Oracle Program Partner, we get the discount until 35% for each Modul. Rgds/Jeram - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Wednesday, January 09, 2002 1:15 PM Awhile ago one of the Developers took a PL/SQL course at the Oracle trainig center. This fall we received a voucher redeemable for one OCP exam. Valid until 08/31/2002. It looks like Oracle has realized the cost of OCP hits the DBA's pocket and not the company's pocket and is offering assistance on the certification costs. Either way I'll take it to do the upgrade exam. I wonder if I have to claim the cost on my taxes??? ROR mª¿ªm [EMAIL PROTECTED] 01/09/02 02:12PM In recent past it was available and code was 'S36' .PLease check Oracle education site/OCP section. No OTN membership required. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 09 Jan 2002 10:45:25 -0800 Hi List, I would like to know if anyone knows whether the OCP discount for otn memebers is still avaialable? Have been trying in technet.oracle.com without success. Thanks, Surendra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_stats.gather... (method_opt)
Hi, Could someone tell me what the HIDDEN columns option is in the DBMS_STATS.GATHER_SCHEMA_STATS and DBMS_STATS.GATHER_TABLE_STATS procedures? I don't seem to find any explanation anywhere about its purpose. Thanks again. -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN
Charlie, The semi-equivalent to RMAN for 7.3.4 databases is EBU. EBU is somewhat more difficult to set up and use than RMAN. If possible, upgrade the 7.3.4.5 database. Cherie Machler Oracle DBA Gelco Information Network Charlie Mengler To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] charliem@mwh. cc: com Subject: RMAN Sent by: [EMAIL PROTECTED] om 01/12/02 02:50 PM Please respond to ORACLE-L Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 SQL*Loader Coding Help
Hi, Maybe i'm looking for the easy way out here. Load into temporary table and populate from there. If you only have ten Cnum fileds it should be easy to query the intermediate table for the records you need select regnumber, cnum1 from table where cnum1 is not null union select regnumber, cnum2 from table where cnum2 is not null union ... upto ten Jack Ken Janusz [EMAIL PROTECTED]@fatcity.com on 14-01-2002 14:25:21 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) I need some help coding this scenario. I have multiple records coming in a delimited flat file. Some of the records are: RegNumber Cnum1 Cnum2 . . . Cnum10 There can be data in 1 to 10 of these fields. I need to load this into this table. Trademark_Class_Data Registration_Number (FK) Class_Code_ID (FK) An example of the code. RegNumber - 65304 Cnum1 - 45 Cnum2 - 54 Cnum3 - 100 So, my question is how do I code this so that I create 3 records in this table as? Registration_Number Class_Code_ID 65304 45 65304 54 65304 100 I need to take data that is contained in 1 record and load it into 3 records. Any help you can give me will be greatly appreciated. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. === The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. === -- 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).
Socket directory under solaris
Title: Socket directory under solaris Under HP-UX, NET8 sets up a directory called /tmp/.oracle and creats a number of sockets there. Does Oracle have a similar directory containing sockets under solaris? Where? (It does not appear to be /tmp). Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: Let the programmers by many and the managers few, Then all will be productive - The Tao of Programming
new to DBA
Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
Hi Relika, I have used Toad. Toad is an excellent replacement for SQL*Plus and has a good PL/SQL development environment. Thanks Jason ~~~ Oracle DB Resources ( http://oracle.dbresources.com) - Online community for Oracle DBAs and Developers - ~~~ --- Relika Shetty [EMAIL PROTECTED] wrote: Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UTF8 and Win2K
Folks, I am starting a new project today and the client is using 8.1.7 on a standalone Win2K server. They had a DBA set up the server and install the software. Now when they run any query, the server locks up. I am not on-site yet, so I can't give any further details yet, but has anyone ever heard of anything like this? I am not even sure that the UTF8 character set is involved, but I thought I would ask. Thanks, Frank -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: F Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 SQL*Loader Coding Help
you have got to read the utilities manual -- there are case studies in there with sample code to do what you need --- Ken Janusz [EMAIL PROTECTED] wrote: I need some help coding this scenario. I have multiple records coming in a delimited flat file. Some of the records are: RegNumber Cnum1 Cnum2 . . . Cnum10 There can be data in 1 to 10 of these fields. I need to load this into this table. Trademark_Class_Data Registration_Number (FK) Class_Code_ID (FK) An example of the code. RegNumber - 65304 Cnum1 - 45 Cnum2 - 54 Cnum3 - 100 So, my question is how do I code this so that I create 3 records in this table as? Registration_Number Class_Code_ID 65304 45 65304 54 65304 100 I need to take data that is contained in 1 record and load it into 3 records. Any help you can give me will be greatly appreciated. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Enterprise Manager
I have tried, but they show a status of pending. I am unable to de-register from OEM against this node. Srini -Original Message- Sent: Friday, January 11, 2002 8:55 PM To: Multiple recipients of list ORACLE-L Have you cleared out all registered events, jobs, and alerts against this node? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 11, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Hi: I am running into this problem with OEM while trying to delete a node previously configured. OEM returns an error VNI-4040 Node agent queue file may be corrupted. I have gone through a few postings on Metalink and implemented the suggestions there such as removing .q files in agent directory on the NODE and restating agent on the node, bouncing OMS on the client side but the problem persists. I would appreciate recommendations on resolving this problem. Thanks -Srini -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The OCP bar is being raised
[EMAIL PROTECTED] wrote: additional tests to convert it OCP7, took the two upgrades for 8 and 8i respectively. I never studied for the tests, in fact, I took them on the spur of the moment each time. I had never worked with 8 or 8i when I took those upgrades. so what does that tell you? tells me that you are either twice lucky or the goddess that people call you .. lol go for the goddess, the lady is wyy smart. trust me in this.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. No program done by a hacker will work unless he is on the system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Data warehousing Resources
Take a look at Ralph Kimball's books. -Original Message- Sent: Saturday, January 12, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hi, try http://www.stewartmc.com/oracle http://www.dwinfocenter.org/ oli On Sat, 2002-01-12 at 06:27, [EMAIL PROTECTED] wrote: Dear All, Would greatly appreciate any advice on books/resources on designing and implementing data warehouse (on Oracle 7-8i) from a less technical and more functional perspective. Cheers, Pete _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pete Wang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: new to DBA
To install... release notes, Getting Started guide. Then, Oracle Concepts manual and Database Administration manual. Perhaps Oracle Press DBA 101 book. After that, get a membership card for your local bookstore. Get used to purchasing books that sell for US$60 or more each... Switch your meal plan to macaroni and cheese. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, January 14, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Subject:new to DBA Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to prevent Oracle 9i for Windows from starting?
Use the Oracle Admin Assistant for Windows NT. It will make all the necessary changes to the registry. Csillag Zsolt starsoft@inte To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rware.hucc: Sent by: Subject: How to prevent Oracle 9i for Windows from starting? [EMAIL PROTECTED] om 01/12/2002 10:05 AM Please respond to ORACLE-L Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Casey Jorda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: new to DBA
Get yourself a test box and play with it while RTFMing. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 14, 2002 9:40 AM Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UTF8 and Win2K
Obviously you need more details on the lock-up part. But I am curious as to why you think UTF8 would be part of the lock-up issue?? TIA Chris -Original Message- Sent: Monday, January 14, 2002 9:05 AM To: Multiple recipients of list ORACLE-L Folks, I am starting a new project today and the client is using 8.1.7 on a standalone Win2K server. They had a DBA set up the server and install the software. Now when they run any query, the server locks up. I am not on-site yet, so I can't give any further details yet, but has anyone ever heard of anything like this? I am not even sure that the UTF8 character set is involved, but I thought I would ask. Thanks, Frank -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: F Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: new to DBA
The Oracle documentation is a good thing to read. I would start with the concepts manual. However, I recommend going out and purchasing a third party book geared towards a new DBA. I heard rumours that Oracle DBA 101 from Oracle Press is a good book but I have not read it myself. I am just going by the half a million recommendations for the book I would also get a book on backup and recover. Again, I would go with the Oracle Press copy. I would buy that one, even if you don't have time to read it yet, as its pretty easy to follow if you do need to recover a database. I would also try and talk management into sending you on an Oracle course. Best of luck. If you are a solid Unix administrator you should do fine as a DBA. Its pretty much the same mentality. -Original Message- Sent: Monday, January 14, 2002 6:40 AM To: Multiple recipients of list ORACLE-L Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using procedures instead of coding update/insert SQL...huh?
I just joined a new Oracle/Java project using Tomcat app server. On this project they decided to create an update procedure and insert procedure for every table. This procedure is then called in the Java code with the appropriate parameters passed, instead of simply coding the UPDATE or INSERT SQL directly in Java. Does anyone else take this approach? I'm trying to understand the pros vs cons of this approach. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
We use it. I really like it. I also got it purchased for the developers. Small footprint, reasonably priced, new features added all the time, not a lot of bugs. -Original Message- Shetty Sent: Monday, January 14, 2002 4:00 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
buffer writes vs. archived logs generation
FYI, I just compared audit trail data for buffer writes against the number of archived logs generated per day. Although there appears to be a vague correspondence between the two, it is not always the case. I would have thought that the relationship would have been more direct. Would anyone know why some buffer writes might not get written through redo logs? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: new to DBA
Andy, One addition to Patrice's steps: If you really want to be a good DBA, forget sleep or a social life for at least a year, maybe longer depending on your goals. Oh, and have fun! -D- On Monday 14 January 2002 10:10 am, Boivin, Patrice J wrote: To install... release notes, Getting Started guide. Then, Oracle Concepts manual and Database Administration manual. Perhaps Oracle Press DBA 101 book. After that, get a membership card for your local bookstore. Get used to purchasing books that sell for US$60 or more each... Switch your meal plan to macaroni and cheese. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: new to DBA
I would insist that your boss send you to Oracle training. If they'll pay for training, travel, and your salary while you are in training then that's a good measure of their support. You should also get commitment for annual trips to the IOUG conference. Is your employer willing to support you in your Oracle DBA education? If they are not willing to give this level of commitment then why expend the energy to become self-taught? The answer to that last question is up to you. -Original Message- Sent: Monday, January 14, 2002 8:10 AM To: Multiple recipients of list ORACLE-L To install... release notes, Getting Started guide. Then, Oracle Concepts manual and Database Administration manual. Perhaps Oracle Press DBA 101 book. After that, get a membership card for your local bookstore. Get used to purchasing books that sell for US$60 or more each... Switch your meal plan to macaroni and cheese. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, January 14, 2002 10:40 AM To: Multiple recipients of list ORACLE-L Subject:new to DBA Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN
There was it's predecessor, EBU, but I have never used it. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 12, 2002 4:35 PM Unfortunately NO. John [EMAIL PROTECTED] wrote: Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Exporting thru a pipe
The script is on the Lazy DBA website, but I have been having trouble with it. Look on Metalink for ways to do this. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 5:00 PM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 23:20 I know someone had the script because I've read it here, but at the time it was on little interest since an export did not take that much space. Well times this is from Metalink: == o How do you create a compressed export file? If you have calculated the size of the file your export will produce and it is too large to fit onto disk, you may want to consider producing a compressed export file as an alternative to exporting directly to tape. Please note, this method should be thoroughly tested before being implemented. - To create a compressed export file: 1. Create a unix named pipe : os mknod /tmp/exp_pipe p 2. Start compress in the background reading in from the named pipe, writing out to 'export.dmp.Z' : os compress /tmp/exp_pipe export.dmp.Z 3. Start the export, specifying the named pipe as the output file : os exp file=/tmp/exp_pipe other options == hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using procedures instead of coding update/insert SQL...huh?
Chris, I personally think this is the best approach. Think of the application task: 1). Is it easier to perform Database Processing within PL/SQL than within Java? PL/SQL is a very strong development tool. Code development and maintenance-wise, I think it is much easier to do all the work in PL/SQL rather than in Java. 2). DB Tuning wise, this forces the application to always use bind variables - a very good thing. 3). Finally, it forces an application model to work in an n-tier model where Java is doing the presentation (making pretty pictures interfacing with the db), and the database is doing what it does best - process the data within the db engine. Remember, of all the computers in the mix, the db server is usually the strongest machine of the bunch - why not take advantage of that power and make it do the db work. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 14, 2002 10:10 AM To: Multiple recipients of list ORACLE-L I just joined a new Oracle/Java project using Tomcat app server. On this project they decided to create an update procedure and insert procedure for every table. This procedure is then called in the Java code with the appropriate parameters passed, instead of simply coding the UPDATE or INSERT SQL directly in Java. Does anyone else take this approach? I'm trying to understand the pros vs cons of this approach. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using procedures instead of coding update/insert SQL...huh?
We used it at a former site. The idea is, this makes the JAVA code totally reusable if you end up changing database servers. All you would have to do is change the underlying insert and update procedures and recompile the application code. I can see a use for it even if you aren't changing databases If you use a standard routine, then the SQL statements will always be identical,and you don't have to worry about shared pool problems rachel --- Grabowy, Chris [EMAIL PROTECTED] wrote: I just joined a new Oracle/Java project using Tomcat app server. On this project they decided to create an update procedure and insert procedure for every table. This procedure is then called in the Java code with the appropriate parameters passed, instead of simply coding the UPDATE or INSERT SQL directly in Java. Does anyone else take this approach? I'm trying to understand the pros vs cons of this approach. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using procedures instead of coding update/insert SQL...huh?
It makes absolute sense to use this encapsulated approach, because you don't have to keep changing your code for DML every time table structure changes, plus this way you guarantee that everyone will use the same statement promoting its reuse in the SGA. Oracle designer likes to call this approach TAPI (Table API). 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! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Exporting thru a pipe
One thing I have found is that the pipe can get messed up if anything goes wrong with the import or export. I always recreate the pipe before each run to make sure it is clean. (pipe cleaner?) Ron -Original Message- Sent: Monday, January 14, 2002 10:15 AM To: Multiple recipients of list ORACLE-L The script is on the Lazy DBA website, but I have been having trouble with it. Look on Metalink for ways to do this. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 5:00 PM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 10, 2002 23:20 I know someone had the script because I've read it here, but at the time it was on little interest since an export did not take that much space. Well times this is from Metalink: == o How do you create a compressed export file? If you have calculated the size of the file your export will produce and it is too large to fit onto disk, you may want to consider producing a compressed export file as an alternative to exporting directly to tape. Please note, this method should be thoroughly tested before being implemented. - To create a compressed export file: 1. Create a unix named pipe : os mknod /tmp/exp_pipe p 2. Start compress in the background reading in from the named pipe, writing out to 'export.dmp.Z' : os compress /tmp/exp_pipe export.dmp.Z 3. Start the export, specifying the named pipe as the output file : os exp file=/tmp/exp_pipe other options == hth, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Uninstall oracle
hkey_local_machine - system - currentcontrolset - services take a look on ALL the controlsets. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: orantdba [SMTP:[EMAIL PROTECTED]] Sent: Mon, January 14, 2002 5:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Uninstall oracle Perhaps because Oracle 8.0.x is not supported on Win2k. Assuming you have no valid Oracle files on the system, to deinstall you will need to do the following 1. If any oracle services were created, make sure they are shut down 2. Using Oracle explorer of similar tool delete the entire directory pointed to by oracle_home 3. Using Oracle explorer or similar tool delete the entire directory c:\program files\oracle and subdirectories 4. Using regedit or regedt32 remove the entire key hkey_local_machine - software - Oracle 5. Remove all services that are associated with oracle (if any). This can be done using the resource kit utility delsrv or by using regedit or regedt32 to find and remove the services. If using regedit you will be going to the hkey_local_machine - system - currentcontrolset - services and remove the oracle services. There may be still be a few files floating around on the c: drive but this should be enough to let you reinstall Oracle8i. John [EMAIL PROTECTED] wrote: As an experiment i tried installing oracle 8 (for NT) on my PC at home (which is win2k)it crashed at an early stage( with some OS error-obviously) How do i uninstall this crashed version? and why does oracle 8i (for NT) install without a problem? cheers all -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: new to DBA
DC Andy, DC One addition to Patrice's steps: DC If you really want to be a good DBA, forget sleep or a social life for at DC least a year, maybe longer depending on your goals. DC Oh, and have fun! Thanks, Dwayne and everyone ;-) So : Five steps to become Oracle DBA 1. Read Oracle documentation. 2. Read specific third-party books. 3. Change a meal plan. 4. Change a social life etc. 5. Get out the Allergy from my manager and local bookstore seller. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database sizing estimates in Designer 6i
I'm trying to generate some table sizing estimates for a new database using Des/6i. Within the Repository Object Navigator, I've entered initial and final row estimates in the Table Definitions section. I have tried to run the report generator that runs Database Table and Index Sizing Report from Repository Reports from Tools Pull-down menu. It runs but shows no tables. The tables are defined in the Table Definitions section of the RON but I'm not sure if they need to be defined somewhere else. I can't find anything in the on-line documentation that shows how to do this within Designer. Can anyone give me the big picture on what needs to be set up/configured in order to run this report successfully. Perhaps I have to have the tables defined within the database in RON in order to get the report to show the sizing. Thanks for any light shed or for pointing me to adequate documentation. Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database sizing estimates in Designer 6i
Hi Cherie, I ran the report and my tables were listed just fine. Have you implemented the tables within a database using either the Ron or Design Editor? Try that (assigning them to a tablespace, assigning storage clauses, etc) and try and run the report again. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 14, 2002 12:20 PM To: Multiple recipients of list ORACLE-L I'm trying to generate some table sizing estimates for a new database using Des/6i. Within the Repository Object Navigator, I've entered initial and final row estimates in the Table Definitions section. I have tried to run the report generator that runs Database Table and Index Sizing Report from Repository Reports from Tools Pull-down menu. It runs but shows no tables. The tables are defined in the Table Definitions section of the RON but I'm not sure if they need to be defined somewhere else. I can't find anything in the on-line documentation that shows how to do this within Designer. Can anyone give me the big picture on what needs to be set up/configured in order to run this report successfully. Perhaps I have to have the tables defined within the database in RON in order to get the report to show the sizing. Thanks for any light shed or for pointing me to adequate documentation. Cherie Machler Oracle DBA Gelco Information Network -- 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Access to Oracle migration
Somewhere at otn.oracle.com is an Access migration kit for Oracle. It's been awhile since I've looked at it, but it's still there. If you need to have several LONG types in a table, you will need to use BLOB or CLOB instead of a LONG. You don't really want to use a LONG datatype anyway, as the LOB is much more flexible. Jared Michael Wu xwu@sempratra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ding.comcc: Sent by: Subject: Access to Oracle migration [EMAIL PROTECTED] om 01/14/02 07:45 AM Please respond to ORACLE-L Hi List, I have a small Access database which needs to be migrated to Oracle. I can use ODBC to convert the data from Access to Oracle. However I encountered the following constraints. 1. Access's MEMO datatype will be converted to Oracle's LONG. Oracle allows only one column with LONG in each table. How about if I have multiple columns with MEMO in the Access database? 2. ODBC does not allow me to pre-create the table in Oracle and then export the data. Otherwise it will complain that the table already exists. Does anybody on the list know if there is any better way or utilities to convert from Access to Oracle? Thanks, Michael ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
Virtual Private Databases
I've read several articles about this aspect of Oracle 8i. However, the 8i database I would like to implement it on is running Standard Edition, not Enterprise Edition. I have information comparing 8i SE vs EE features and VPD was listed as only available if you are running EE. When I poked around the database it appears that the DBMS_RLS package is installed and available. Before I try testing this on a happy production server, can someone confirm whether or not I can implement VPD on Standard Edition? Regards, Gary Norwell Senior Systems Analyst Hybrid Turkeys
Re: tablespace default maxextents
Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using procedures instead of coding update/insert SQL...huh?
DITTO THAT!!! You can also use PL/SQL for selects, not just inserts, updates and deletes. You do this by having the PL/SQL return a reference cursor and then the Java code takes it from there to display everything via jsp or whatever. I was DBA where we did this on a Java/Oracle development project. We had tons of queries and NO EMBEDDED SQL in the Java code. I could change (tune) the SQL queries in the PL/SQL packages without making any changes to the Java source code. We also used some native dynamic SQL for the queries with lot's of user interface driven permutations on the WHERE clause. This approach requires duhvelopers to work closely with DBAs/database dweebs and... depending on your demeanor, you can count this as a pro or a con. ;-) Steve Orr -Original Message- Sent: Monday, January 14, 2002 9:01 AM To: Multiple recipients of list ORACLE-L Chris, I personally think this is the best approach. Think of the application task: 1). Is it easier to perform Database Processing within PL/SQL than within Java? PL/SQL is a very strong development tool. Code development and maintenance-wise, I think it is much easier to do all the work in PL/SQL rather than in Java. 2). DB Tuning wise, this forces the application to always use bind variables - a very good thing. 3). Finally, it forces an application model to work in an n-tier model where Java is doing the presentation (making pretty pictures interfacing with the db), and the database is doing what it does best - process the data within the db engine. Remember, of all the computers in the mix, the db server is usually the strongest machine of the bunch - why not take advantage of that power and make it do the db work. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, January 14, 2002 10:10 AM To: Multiple recipients of list ORACLE-L I just joined a new Oracle/Java project using Tomcat app server. On this project they decided to create an update procedure and insert procedure for every table. This procedure is then called in the Java code with the appropriate parameters passed, instead of simply coding the UPDATE or INSERT SQL directly in Java. Does anyone else take this approach? I'm trying to understand the pros vs cons of this approach. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dynamic views in 8.1.6
1. Did you really change all of those 'undocumented' parameters at once? That is *not* a good idea. You should change them one at a time and determine the effects of each, unless you are already familiar with using them. You should comment all but one out and restart your database. 2. What do you mean by 'dynamic views'? 3. What does 'stopped working' mean? Any error messages? Incorrect data? etc... ? Also, if possible, upgrade to 8.1.7.(current patch level here) and some of these undocs either go away or become documented. Jared Oracle DBA [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] steel.com cc: Sent by: Subject: dynamic views in 8.1.6 [EMAIL PROTECTED] 01/14/02 04:45 AM Please respond to ORACLE-L we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virtual Private Databases
I'm hoping you can tell us. :) Jared gnorwell@hybridt urkeys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Virtual Private Databases 01/14/02 10:25 AM Please respond to ORACLE-L I've read several articles about this aspect of Oracle 8i. However, the 8i database I would like to implement it on is running Standard Edition, not Enterprise Edition. I have information comparing 8i SE vs EE features and VPD was listed as only available if you are running EE. When I poked around the database it appears that the DBMS_RLS package is installed and available. Before I try testing this on a happy production server, can someone confirm whether or not I can implement VPD on Standard Edition? Regards, Gary Norwell Senior Systems Analyst Hybrid Turkeys -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Socket directory under solaris
Title: Socket directory under solaris Try /ver/tmp/.oracle Tony Aponte -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, January 14, 2002 9:00 AMTo: Multiple recipients of list ORACLE-LSubject: Socket directory under solaris Under HP-UX, NET8 sets up a directory called /tmp/.oracle and creats a number of sockets there. Does Oracle have a similar directory containing sockets under solaris? Where? (It does not appear to be /tmp). Matt Adams - GE Appliances - [EMAIL PROTECTED] Thus spake the master programmer: "Let the programmers by many and the managers few, Then all will be productive" - The Tao of Programming
RE: tablespace default maxextents
Hello, Read up on the hierarchy rules and you will see that if no specific table/index parameters are set, then they default to the tablespace's parameters. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 14, 2002 1:25 PM To: Multiple recipients of list ORACLE-L Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: tablespace default maxextents
Mitchell, When creating a new table or index, Oracle uses the tablespace's default maxextents setting unless you specify a different one in the table or index creation storage clause. After that, Oracle depends on the each table's or index's maxextents for the actual number of extents. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: mitchell [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: tablespace default maxextents Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Virtual Private Databases
Listen to yourself: *testing* on a happy *production* server. Add 1 cup of milk. Shake well. Makes enough Chaos for 100-200 users. Just MHO, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, January 14, 2002 12:25 PM To: Multiple recipients of list ORACLE-L I've read several articles about this aspect of Oracle 8i. However, the 8i database I would like to implement it on is running Standard Edition, not Enterprise Edition. I have information comparing 8i SE vs EE features and VPD was listed as only available if you are running EE. When I poked around the database it appears that the DBMS_RLS package is installed and available. Before I try testing this on a happy production server, can someone confirm whether or not I can implement VPD on Standard Edition? Regards, Gary Norwell Senior Systems Analyst Hybrid Turkeys -- 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).
RE: Access to Oracle migration
Michael - This was discussed in detail recently on this list. Basically, what I recall is: - The key is to define the tables in Oracle first, then import your Access data. You don't want to let Access define the tables, and I think you are learning this. - How large are the Memo fields? Can you store them in a varchar2 column? Can you break them into multiple varchar2 columns, like maybe they have some internal structure? If the latter, you could create a child table to store each. Just a wild thought. - If you are just doing a few tables, and your posting uses the word small, then this should work fine. If you had many tables, someone mentioned an Oracle migration tool provided by Oracle that worked well. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 14, 2002 9:46 AM To: Multiple recipients of list ORACLE-L Hi List, I have a small Access database which needs to be migrated to Oracle. I can use ODBC to convert the data from Access to Oracle. However I encountered the following constraints. 1. Access's MEMO datatype will be converted to Oracle's LONG. Oracle allows only one column with LONG in each table. How about if I have multiple columns with MEMO in the Access database? 2. ODBC does not allow me to pre-create the table in Oracle and then export the data. Otherwise it will complain that the table already exists. Does anybody on the list know if there is any better way or utilities to convert from Access to Oracle? Thanks, Michael ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dynamic views in 8.1.6
I'm happy that something stopped working! Do you really enjoy changing the undocumented parameters? -Original Message- Sent: Monday, January 14, 2002 7:45 AM To: Multiple recipients of list ORACLE-L we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tablespace default maxextents
'tablespace maxextents' is used as a default, when you don't explicitly specify 'table or index maxextents'. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 14, 2002 1:25 PM Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tablespace default maxextents
Hi Mitchell, The maxextents on the tablespace are applied as defaults to tables or indexes that are created without an explicit maxextents value. An explicit maxextents clause on the table or index level will override the tablespace clause. Hope this helps, John [EMAIL PROTECTED] wrote: Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: tablespace default maxextents
Oracle doesn't depend on maxextents. Oracle depends on the sale of their software. As for the maxextents, it depends: If maxextents is specified for the table, then the table level definition will be used. If, not the tablespace level default will be used. I believe that that is explained in the oracle documentation and that you should read the fine manuals. -Original Message- Sent: Monday, January 14, 2002 1:25 PM To: Multiple recipients of list ORACLE-L Hi Gurus. Oracle has tablespace maxextents and table or index maxextents. Which one oracle depend on? thanks Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
NT questions
Hi dear Listers, I have 2 NT questions like to ask; 1.On unix, I use the following script to change the name of alert file. How to change it in the same way on NT? for log_file in $(find $ORACLE_BASE/admin -name alert_FMRPT.log | grep -v alert_FMRPT_.*.log) do newfile=$(echo $log_file | sed s/\.log$/_$dt.log/) echo moving alert logs: $log_file $newfile mv $log_file $newfile 2. I remember read somewhere about oracle version, for example, 8.1.7.2.x , the last digit is OS related informantion. Is that true? Our nt boxes, some instance show it is 8.1.7.2.1, some shows 8.1.7.2.6. I'd like to make all the same version. Where I can get those patch information? (On unix, all our instances are 8.1.7.2.0, we installed and patched. Not on NT. kind of out of control at beginning) Thanks in advance, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: new to DBA
Been there, Burned out! Gee, lucky you. You get to do two full time jobs at your current salary. If you are bored are looking for new things to do learn, then accept the offer. If you are fully loaded or overloaded, then ask which tasks you get to hand off to sombody else. HTH YMMV HAND! == Production wrote: Hi dear all A few days ago I was surprised by my IT manager who has offered to me to administer local Sun box with Oracle 8i. I have a near-deep experience with Solaris system administration (about 4 year) but I have doubts regarding administration of Oracle+Solaris. *** (hurray, this is the question section!) *** From what I must to start to deeping into DBA business? Is it enough - careful reading of Oracle documentation? I really confused ;-[ *** thank you! Andy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Production INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 I'm as busy as a one armed wall paper hanger! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
problem with 9i import
Hi, I have recently installed 9i on my computer and wanted to import my exdat.dmp file from my Oracel 8i. I got nowhere with the enterprise manager console so after trying with no success through Oracle support I decided to try doing the import from a command prompt. Well, I must have done something wrong because it imported the file but it put it in the OEM database instead of the ORCL and so my developer 6.0 does not have access to any of the tables or data that I imported. Does anyone know the correct sintax to do the import that I want to do and also how do I get it out of the OEM now? Have I totally messed everything up? Thanks -- 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).
DBA Experiences with Oracle and RAID 0+1
We are in the process of setting up a SAN using RAID 0+1 for our database. In our current environment, we are able to separate our tables, indexes, rollback segments, and archive logs on different disks. On the SAN we would have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable space (3 disks worth of space). Some white papers that I have read suggest attempting to separate the data, indexes, and rollback segments on separate RAID volumes, and others simply suggest that the performance boost of striping will supercede the separation of these items. Can anyone offer any comments or suggestions? Jon Behnke Applications Development Manager Industrial Electric Wire Cable Phone (262) 957-1147 Fax (262) 957-1647 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Behnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dynamic views in 8.1.6
Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Virtual Private Databases
Sometimes, when you aren't sure if it will work, someone will say Let's try it and see what happens ... . Every once in awhile, you hit one of those We probably shouldn't have tried that on a production system landslides. Regards, Gary Norwell Senior Systems Analyst Hybrid Turkeys __ I'm hoping you can tell us. :) Jared
Re: dbms_stats.gather... (method_opt)
Walter K wrote: Hi, Could someone tell me what the HIDDEN columns option is in the DBMS_STATS.GATHER_SCHEMA_STATS and DBMS_STATS.GATHER_TABLE_STATS procedures? I don't seem to find any explanation anywhere about its purpose. Thanks again. -w I would guess that 'hidden' columns may more or less have to do with the object option, which seems (if sys.col$ is to be believed) to sometimes present as a single aggregated column what is indeed traditional 'split' columns. Another possibility might be function-based indexes. They create dummy columns in dba_ind_columns, those dummy (and therefore hidden) columns might be used when gathering stats. Just wild ideas. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: problem with 9i import
HI New2orcl, My guess is that your $oracle_sid was set to point to oem when you did the import with is why it imported into that database. The only way to get it out is to log on to the oem database and drop each table. To get it into the correct database set the oracle_sid and then do your import. Good luck, John [EMAIL PROTECTED] wrote: Hi, I have recently installed 9i on my computer and wanted to import my exdat.dmp file from my Oracel 8i. I got nowhere with the enterprise manager console so after trying with no success through Oracle support I decided to try doing the import from a command prompt. Well, I must have done something wrong because it imported the file but it put it in the OEM database instead of the ORCL and so my developer 6.0 does not have access to any of the tables or data that I imported. Does anyone know the correct sintax to do the import that I want to do and also how do I get it out of the OEM now? Have I totally messed everything up? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dynamic views in 8.1.6
LOL!!! Todd -Original Message- Faroult Sent: Monday, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT questions
Hi Joan A1) ? A2) You are right about that the last digit is OS patches, you can get the patches from Metalink (http://metalink.oracle.com). Joan Hsieh wrote: Hi dear Listers, I have 2 NT questions like to ask; 1.On unix, I use the following script to change the name of alert file. How to change it in the same way on NT? for log_file in $(find $ORACLE_BASE/admin -name alert_FMRPT.log | grep -v alert_FMRPT_.*.log) do newfile=$(echo $log_file | sed s/\.log$/_$dt.log/) echo moving alert logs: $log_file $newfile mv $log_file $newfile 2. I remember read somewhere about oracle version, for example, 8.1.7.2.x , the last digit is OS related informantion. Is that true? Our nt boxes, some instance show it is 8.1.7.2.1, some shows 8.1.7.2.6. I'd like to make all the same version. Where I can get those patch information? (On unix, all our instances are 8.1.7.2.0, we installed and patched. Not on NT. kind of out of control at beginning) Thanks in advance, Joan -- Best regards Peter Gram Miracle A/S http://MiracleAS.dk Tel: +45 2527 7107 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
TOAD is the one Oracle tool I would refuse to give up. We used to use SQL*Navigator, and I much prefer TOAD. It has a well-thought-out interface, and has useful features for both DBA and Developer. All of our developers and DBAs use it. The support from Toadman and his development group is outstanding. There is a very active mail list (http://www.egroups.com/list/toad) and an active beta program open to ALL registered TOAD owners. I can't recommend TOAD highly enough. Dave -Original Message- From: Relika Shetty [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:00 AM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Virtual Private Databases
Gary - I don't have that much experience with SE vs. EE, but my experience has been that Oracle tends to provide many features, regardless of your licensing. Think of it as the honor system. The problem for you is that if you use features that your license does not entitle you to, then some day your Oracle rep. discovers it and gently suggests a change in your license policy. To your boss. So, in the words of Clint Eastwood: Do you feel lucky, punk? Well do you?. Personally, I think the best policy is to check your licensing policy carefully before using a feature. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 14, 2002 12:25 PM To: Multiple recipients of list ORACLE-L I've read several articles about this aspect of Oracle 8i. However, the 8i database I would like to implement it on is running Standard Edition, not Enterprise Edition. I have information comparing 8i SE vs EE features and VPD was listed as only available if you are running EE. When I poked around the database it appears that the DBMS_RLS package is installed and available. Before I try testing this on a happy production server, can someone confirm whether or not I can implement VPD on Standard Edition? Regards, Gary Norwell Senior Systems Analyst Hybrid Turkeys -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA Experiences with Oracle and RAID 0+1
Jon: I would suggest Oracle8i DBA Handbook by Loney Theriault. Chapter 4 deals with the physical database layouts. It starts with the ideal layout on 22 disks and goes down to about 7 disks. It's very good. Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Monday, January 14, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Subject:DBA Experiences with Oracle and RAID 0+1 We are in the process of setting up a SAN using RAID 0+1 for our database. In our current environment, we are able to separate our tables, indexes, rollback segments, and archive logs on different disks. On the SAN we would have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable space (3 disks worth of space). Some white papers that I have read suggest attempting to separate the data, indexes, and rollback segments on separate RAID volumes, and others simply suggest that the performance boost of striping will supercede the separation of these items. Can anyone offer any comments or suggestions? Jon Behnke Applications Development Manager Industrial Electric Wire Cable Phone (262) 957-1147 Fax (262) 957-1647 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Behnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sign Out
I will be out for the remainder of the day. Thanks Colin Newport S-S Technologies Inc. -- The Automation Engineers 86 Ardelt Ave, Kitchener, Ontario, Canada, N2C 2C9 P: (519) 571-1435 X335 F: (519) 571-1721 mailto:[EMAIL PROTECTED] http://www.sstechnologies.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Newport, Colin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sniped sessions
Dear List, I have init.ora resource_limit = true, and idle_time set in profile. When idle_time exceeds, the session status becomes 'sniped' in v$session and never gets cleaned up. I manually kill these threads using orakill utility. I appreciate, if someone can help me with a script to clean up these sessions automatically(8.1.7 on NT)?? Sunil Nookala DBA Dell Computer Corp. Austin, TX 78738 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sign Out
We'll sorely miss you. Can you reconsider? If not, can you publish that on CNN and NYT so that the rest of the world doesn't remain uninformed? They say that ignorance is bliss but this certainly qualifies as breaking news. -Original Message- Sent: Monday, January 14, 2002 4:30 PM To: Multiple recipients of list ORACLE-L I will be out for the remainder of the day. Thanks Colin Newport S-S Technologies Inc. -- The Automation Engineers 86 Ardelt Ave, Kitchener, Ontario, Canada, N2C 2C9 P: (519) 571-1435 X335 F: (519) 571-1721 mailto:[EMAIL PROTECTED] http://www.sstechnologies.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Newport, Colin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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).
RE: Sign Out
Have fun! -Original Message- Sent: Monday, January 14, 2002 4:30 PM To: Multiple recipients of list ORACLE-L I will be out for the remainder of the day. Thanks Colin Newport S-S Technologies Inc. -- The Automation Engineers 86 Ardelt Ave, Kitchener, Ontario, Canada, N2C 2C9 P: (519) 571-1435 X335 F: (519) 571-1721 mailto:[EMAIL PROTECTED] http://www.sstechnologies.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Newport, Colin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dynamic views in 8.1.6
If you added these to a production system, I trust you that you habitually wear asbestos underwear. Personally, I never add supported undocumented parameters to init.ora unless I have to resolve an issue. And I would do so, one parameter at a time, on a test system, and carefully note the effects. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, January 14, 2002 4:30 PM To: Multiple recipients of list ORACLE-L LOL!!! Todd -Original Message- Faroult Sent: Monday, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: 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).
RE: DBA Experiences with Oracle and RAID 0+1
Title: RE: DBA Experiences with Oracle and RAID 0+1 If I remember correctly, I do not think that chapter covers RAID. There is a good white paper on implementing RAID for Oracle at http://www.quest.com/whitepapers/Raid1.pdf Cheers, Craig. -Original Message- From: Ken Janusz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 15 January 2002 8:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA Experiences with Oracle and RAID 0+1 Jon: I would suggest Oracle8i DBA Handbook by Loney Theriault. Chapter 4 deals with the physical database layouts. It starts with the ideal layout on 22 disks and goes down to about 7 disks. It's very good. Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Monday, January 14, 2002 2:40 PM To: Multiple recipients of list ORACLE-L Subject: DBA Experiences with Oracle and RAID 0+1 We are in the process of setting up a SAN using RAID 0+1 for our database. In our current environment, we are able to separate our tables, indexes, rollback segments, and archive logs on different disks. On the SAN we would have six 73 gig disks on RAID 0+1 for a total of about 210 Gig of usable space (3 disks worth of space). Some white papers that I have read suggest attempting to separate the data, indexes, and rollback segments on separate RAID volumes, and others simply suggest that the performance boost of striping will supercede the separation of these items. Can anyone offer any comments or suggestions? Jon Behnke Applications Development Manager Industrial Electric Wire Cable Phone (262) 957-1147 Fax (262) 957-1647 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Behnke INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sign Out
Wait for me, I want to sign out too!!! Let's go for a beer. -Original Message- Sent: January 14, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We'll sorely miss you. Can you reconsider? If not, can you publish that on CNN and NYT so that the rest of the world doesn't remain uninformed? They say that ignorance is bliss but this certainly qualifies as breaking news. -Original Message- Sent: Monday, January 14, 2002 4:30 PM To: Multiple recipients of list ORACLE-L I will be out for the remainder of the day. Thanks Colin Newport S-S Technologies Inc. -- The Automation Engineers 86 Ardelt Ave, Kitchener, Ontario, Canada, N2C 2C9 P: (519) 571-1435 X335 F: (519) 571-1721 mailto:[EMAIL PROTECTED] http://www.sstechnologies.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Newport, Colin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Fisher, Julie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: The NT forms60 service in iAS 1.0.2.2.
Patrice, When you run the forms server using the desktop shortcut who are you logged in as? Can the local administrator account map to the mapped drives? ie, what happens if you login to the server as the local admin account and run the forms server from the desktop? Alternatively, what happens if you tell the forms server to run as a domain account rather than the local admin account? Regards, Bruce Reardon -Original Message- Sent: Friday, 11 January 2002 20:06 When I run the forms server on one of the servers using a shortcut from the desktop (i.e. from the command line), Web clients can run Web form applications. When I start the forms server service, however, I see the following errors on the client: This is an old problem, revisiting it hoping to fix it. Basically, we use mapped drives to point to .fmx and .html files, therefore the Forms server cannot be run as the NT SYSTEM account. The Forms Server service has been set to run as the local Administrator account. When I start the Forms60Server service, the services applet reports no problems. From the remote browser however, when I bring up a Web Application, the HTML loads properly, a small window opens, and then I see error FRM-92050: Failed to connect to the Server hostname:9001 When the Forms Server is started from the command line with port=9001, the Web application appears no problem. I would like to run the Forms Server as a service, the OEM Forms Listener monitoring guidelines say I should start it as a service. Misc. notes: formsweb.cfg file says port=9001. forms60_timeout does not exist in the registry. Local Admin has the log in as a service user right. The Jinit version had been set to 1.1.8.16, but we are using 1.1.8.14 -- I changed formsweb.cfg to reflect this. I clicked on the link from technet to download 1.1.8.16, but it leads nowhere. Also the text just before the link appears to have a typo, it refers to 1.1.8.17. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: NT questions
Hi you have a couple of choices for the first problem. You could install cygwin on the NT server and then you could use the shell script to do the work or alternatively install Perl and recode the script in Perl and it would be useable on either platform. Yes the last number is a platform specific patch. There may be reasons that different systems are patched differently. It may be that one system exhibited a bug relevant to the package the server supports but due to different things the other servers do not have that issue. It might not be a good thing to just patch the other systems without investigating further the purpose of those patches. It is possible you could break something else Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/01/2002 06:45 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:NT questions Hi dear Listers, I have 2 NT questions like to ask; 1.On unix, I use the following script to change the name of alert file. How to change it in the same way on NT? for log_file in $(find $ORACLE_BASE/admin -name alert_FMRPT.log | grep -v alert_FMRPT_.*.log) do newfile=$(echo $log_file | sed s/\.log$/_$dt.log/) echo moving alert logs: $log_file $newfile mv $log_file $newfile 2. I remember read somewhere about oracle version, for example, 8.1.7.2.x , the last digit is OS related informantion. Is that true? Our nt boxes, some instance show it is 8.1.7.2.1, some shows 8.1.7.2.6. I'd like to make all the same version. Where I can get those patch information? (On unix, all our instances are 8.1.7.2.0, we installed and patched. Not on NT. kind of out of control at beginning) Thanks in advance, Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
RE: TOAD Software???
Warning: if you are offended by fogeyism or curmudgeonly attitudes, you should not read the rest of this message. Thank you. As for TOAD vs SQL*Navigator, I would certainly agree with you there. TOAD has a much better interface. As for the tools that I would steadfastly refuse to give up, sorry, TOAD doesn't make the cut. Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Not necessarily in that order. Jared schmoldt@fyiow a.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: TOAD Software??? om 01/14/02 01:55 PM Please respond to ORACLE-L TOAD is the one Oracle tool I would refuse to give up. We used to use SQL*Navigator, and I much prefer TOAD. It has a well-thought-out interface, and has useful features for both DBA and Developer. All of our developers and DBAs use it. The support from Toadman and his development group is outstanding. There is a very active mail list (http://www.egroups.com/list/toad) and an active beta program open to ALL registered TOAD owners. I can't recommend TOAD highly enough. Dave -Original Message- From: Relika Shetty [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 6:00 AM To: Multiple recipients of list ORACLE-L Subject: TOAD Software??? Hi DBAs, Not sure, whether this has already been discussed on list. If so, then please mail me directly instead of mailing to list. I just wanted to check how good TOAD software is. I am evaluating this software for my company. Has anyone bought it? Will appreciate quick response. Thanks in Advance, Regards, RS. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Relika Shetty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
Re: sniped sessions
Here's a very rough cut at a script to generate a batch file to kill the threads. -- orakill.sql set head off feed off linesize 100 pagesize 0 spool okill.bat select 'orakill ' || i.instance_name || ' ' || p.spid from v$process p, v$session s, v$instance i where p.addr=s.paddr and s.status = 'SNIPED' / spool off exit --- from the command line: sqlplus system/manager @orakill.sql okill.bat Jared Sunil_Nookala@ Dell.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: sniped sessions om 01/14/02 02:10 PM Please respond to ORACLE-L Dear List, I have init.ora resource_limit = true, and idle_time set in profile. When idle_time exceeds, the session status becomes 'sniped' in v$session and never gets cleaned up. I manually kill these threads using orakill utility. I appreciate, if someone can help me with a script to clean up these sessions automatically(8.1.7 on NT)?? Sunil Nookala DBA Dell Computer Corp. Austin, TX 78738 -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UTF8 and Win2K
Maybe I am wrong, but here is my thinking.. The problem is that the DBA on-site built a db using US7ACII and then used the dbca to change the character set to UTF8 and perform a partial re-install. My thought was that some of the language specific .msb files were not installed correctly during the modification. Since I was just engaged, I have had only 1 hour on the server, I found ORA-0600 errors in the alter.log. I have opened a TAR and I am working all the other potential holes in the DB. Like 1 db with 6 service handlers ! I could understand 1 or 2 but 6 ? All for TCP/IP and all for the same DB and server. I will be doing some cleaning here while I wait! Frank --- Grabowy, Chris [EMAIL PROTECTED] wrote: Obviously you need more details on the lock-up part. But I am curious as to why you think UTF8 would be part of the lock-up issue?? TIA Chris -Original Message- Sent: Monday, January 14, 2002 9:05 AM To: Multiple recipients of list ORACLE-L Folks, I am starting a new project today and the client is using 8.1.7 on a standalone Win2K server. They had a DBA set up the server and install the software. Now when they run any query, the server locks up. I am not on-site yet, so I can't give any further details yet, but has anyone ever heard of anything like this? I am not even sure that the UTF8 character set is involved, but I thought I would ask. Thanks, Frank -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: F Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mr Frank Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: TOAD Software???
Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Software???
Tools that do make the cut: SQL*Plus vi or vim korn shell Perl Guiness Yukon Jack Bombay Saphire Gin Martini and Rossi Vermouth Lagavulin Single Malt Jared Yukon Jack !? I would never have guessed it. Lagavulin huh? If only I had known. I am partial to Dalwhinnie myself. Oh I absolutely agree on the other important tools, though I admit you did have me wondering what the Guiness software suite had to offer. As for TOAD, I would definately give it a thumbs up. I used to work for a client that owned a copy. I admit it was the GUI tool that made me begrudgingly begin to accept GUI tools. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: buffer writes vs. archived logs generation
Patrice, Didn't see any answers from the performance gurus, so here's my take on this. While it is true that all changes that are made to the database is made against the buffers in the buffer cache, this is preceded by redo entries in the redo buffer that is in turn written almost continuosly into the redologs. It is these redologs that are then written out as archivelogs at redolog switch (when a redolog fills up). Multiple changes to a particular 'hot' db buffer will result in multiple redolog entries (more redolog and thus archive log) but a single write (buffer write) when the buffer is ultimately written out. In other words, the amount of information written out as measured by 'buffer writes' cannot be compared to archivelogs generated when you have a multiple simultaneous update-intensive workload. I believe you should look at V$SYSSTAT's 'redo blocks written' to measure what you are looking for. Does this answer your query? Btw, what did you use to measure 'buffer writes'? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 7:35 AM To: Multiple recipients of list ORACLE-L Subject: buffer writes vs. archived logs generation FYI, I just compared audit trail data for buffer writes against the number of archived logs generated per day. Although there appears to be a vague correspondence between the two, it is not always the case. I would have thought that the relationship would have been more direct. Would anyone know why some buffer writes might not get written through redo logs? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Enterprise Manager
What version of OEM - 204, 2.1 or 2.2? In 204 to clean out you had to manually connect via sqlplus and run a PLSQL package. In 2.1 / 2.2 this can be done from the navigator. Regards, Bruce Reardon -Original Message- Sent: Tuesday, 15 January 2002 1:20 To: Multiple recipients of list ORACLE-L I have tried, but they show a status of pending. I am unable to de-register from OEM against this node. Srini -Original Message- Sent: Friday, January 11, 2002 8:55 PM To: Multiple recipients of list ORACLE-L Have you cleared out all registered events, jobs, and alerts against this node? -Original Message- [EMAIL PROTECTED] Sent: Friday, January 11, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Hi: I am running into this problem with OEM while trying to delete a node previously configured. OEM returns an error VNI-4040 Node agent queue file may be corrupted. I have gone through a few postings on Metalink and implemented the suggestions there such as removing .q files in agent directory on the NODE and restating agent on the node, bouncing OMS on the client side but the problem persists. I would appreciate recommendations on resolving this problem. Thanks -Srini -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dynamic views in 8.1.6
This one's a keeper :) -Original Message- Sent: Monday, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Oracle DBA wrote: we have added these parameters in the init.ORA file . query_rewrite_enabled=true _complex_view_merging=true _push_join_predicate=true optimizer_max_permutations=79000 _use_column_stats_for_function=true _like_with_bind_as_equality=true _push_join_union_view=true _ordered_nested_loop=true _or_expand_nvl_predicate=true after these changes all the dynamic views created by developers have stopped working . our database is running on aix 4.3.3 and its in MTS mode . Will appreciate quick response. thanks in advance . brajesh jaiswal _stop_messing_with_undocumented_parameters=TRUE -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: TOAD Software???
While the first four are required low level tools, those following are indeed outsourced from a third party. Though considered by many to be used only in case of emergency, I find that modest application of these tools tends to relieve situations that might otherwise induce panic. Overuse on the other hand, tends to throw a wrench in the works and complicate issues, as third party tools are wont to do. Jared On Monday 14 January 2002 15:51, Robert Eskridge wrote: Jared, I find it somewhat curious that while the first four tools suggest a preference for the home brew approach, the last five are certainly third party tools. I'm certainly with you on the first four, but I think the others need more research. If you are ever in Dallas, we'll have to go to a lab and compare results -rje J As for the tools that I would steadfastly refuse to give up, sorry, TOAD J doesn't make the cut. J Tools that do make the cut: J SQL*Plus J vi or vim J korn shell J Perl J Guiness J Yukon Jack J Bombay Saphire Gin J Martini and Rossi Vermouth J Lagavulin Single Malt J Not necessarily in that order. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).