RE: Form question

gracias Ofer -Original Message- Sent: Monday, June 09, 2003 7:50 PM To: Multiple recipients of list ORACLE-L bell ; Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Saturday, June 07, 2003 11:44 PM To: Multiple recipients of

RE: ORA600 [2103] [0] [0] [1] [900] -- Wrapping up

Dear All, ThAnks for all your comments and advise. We have found what was the cause of this. Just before we put tablespaces in hot backup mode we mount some nfs drives. Then having placed the tbs in hot backup we use a cp command to copy the *.dbf files to nfs. Also the copy of the controlfile

WG: RedHat AS Dev edition

-Ursprüngliche Nachricht- Von: Kulev, Milen Gesendet: Dienstag, 17. Juni 2003 00:39 An: Multiple recipients of list ORACLE-L Betreff: AW: RedHat AS Dev edition Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know whether RH will

RE: How to stop script

Hi Chen, My solution will be about the same with previous DBA guru I assume u r using Window (if is unix you just need to change a little bit here and there) I write this script for you. +save as imp.sql++ SET HEAD OFF SET FEEBACK OFF SET

Re: JDBC and MTS

On 2003.06.17 01:04, Richard Ji wrote: I used to seen problems with JDBC Thin with MTS on Linux and switching to a dedicated connection seemed to fix the problem. But JDBC Thin and MTS worked fine on my Solaris box. Not sure with HP-UX. Is the Java application running on an Application Server?

RE: JDBC and MTS

Richard is right...If ur Java application uses it own connection pooling...then do not use MTS...it slows down connections and more...We faced the same issue here Our configuration allows DBA to choose weather connection pooling should handled by the app or the database... Use dedicated

Re: JDBC and MTS

OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't program. I troubleshoot other people's programs. Other people program, I nag. When developers start writing bug-free software which uses the database in the most optimal way,

RE: RedHat AS Dev edition

I ordered a copy 4 weeks ago, never received it. Red Hat, USPS, or Canada Post? I'll wait a couple more weeks... Patrice (Canada) -Original Message- Sent: Monday, June 16, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Thanks for the answer Ron, the problem is that I don't

Re: AW: RedHat AS Dev edition still available today

Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know

RE: JDBC and MTS

Mladen - I'll add what I know, but it won't add much. When the Java people say they are doing connection pooling, that almost certainly means they are using an application server. This is the beast on which to focus your attention. Start by finding out which species it is. There are in my

recreating a create database file

Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the

RE: JDBC and MTS

Mladen, I've found MTS to be a blessing and a curse at the same time no matter what language (C, ASP, JAVA, etc...) is being used. The biggest problem with MTS is the number of idle shared servers that you have at any point in time. When you connection request is processed by the

Retreiving data from SQL Server

Can anyone give me an example of an SQL statement that will retrieve data from SQL Server. What is the best way to do this? Thanks! Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know

RE: JDBC and MTS

We add: 1. Application (Java) Using a JDBC Connection Pooling (CP)feature... 2. Database Oracle in MTS, pooling or not pooling enabled This was not good for us...so we kept the Java pooling side of the app and Oracle configured to run in dedicated mode. We'got a XML policy file which disables

RE: asking your opinion

With a standby database, either physical or logical (Oracle 9i) you get a failower machine, typically much smaller then the original one. The problem is that there isn't much else you can do on that machine. In case of a logical standby, you can use it as a report server, but then again, you are

Re: JDBC and MTS

Refer to Note:139775.1 - see if this helps out - basically it says to configure the jdbc driver so that it has to use dedicated server - using MTS is the problem. [EMAIL PROTECTED] 6/17/2003 7:24:50 AM OK. Let me get some things straight:a) I'm not a developer. I'm one of those vile

IOUG Live 2003

Title: IOUG Live 2003 Does anyone know when we (we-couldn't-go-to-conference types) get access to conference papers or download them? I had sent an email to address on homepage, but it has been only 2+ weeks of no reply. TIA Raj

Re: recreating a create database file

Do you need the CREATE DATABASE ... script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting.

RE: Retreiving data from SQL Server

You must put double quotes around column names in select and where clauses and it is VERY case sensitive. Note the following query; select concontainer from [EMAIL PROTECTED] where conID = 1; if you tried this with the field of conid it would fail. It's a pain in the butt that is how it

AQ, RAC and delay

Title: AQ, RAC and delay A colleague casually mentioned that in RAC, the test to de-queue an AQ set-up from BOTH instances didn't succeed. The side where we were enqueuing was able to see queued messages faster than the 'other' side. About 7-8 seconds ... that got me thinking ... is this an

RE: exchange partition in 9.2

Arup and Jacques: thanks for your help. The command we are executing is alter table exchange partition ... with table .. include indexes. We have also a PK on each of the tables (local index on a partitioned table). Go global indices. We have tried the same command with novalidate and the

RE: asking your opinion

See comments below RF Robert G. Freeman Consultant - TUSC www.tusc.com One browser to rule them all, one browser to find them, One browser to bring them all and into the darkness bind them In the land of Redmond where the shadows lie. -Original Message- To: Multiple recipients

Anyone successfully installed 9ias on AIX 4.3.3 ?

Hi list, Is there someone out there who successfully installed 9ias (9.0.2.0.1) on AIX 4.3.3 ? If yes, were you able to meet all the pre-requisites (OS patches, java version, ...) ? My installation fails in the configuration tools (dbca). I always get a Lost contact message. My sys admin

RE: Retreiving data from SQL Server

Dave, You also need to put double quotes around table names as they conform to the same rules as columns. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, June 17, 2003 10:55 AM To: Multiple recipients of list ORACLE-L You must put

Re: How to stop script

Hi You can stop the script by using the line whenever sqlerror exit rollback and then generating an error by using an exception in a PL/SQL block as follows: oracle:jupiter cat imp.sql whenever sqlerror exit rollback declare cursor c_db is select name from v$database;

RE: recreating a create database file

Maybe not exactly what you are looking for, but Start the GUI DBCA (NO don't shoot), go through the all the motions and at the end choose generate scripts only. Jack -Original Message- Sent: Tuesday, June 17, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Good

Re: recreating a create database file

I got the answer, thanks anyway. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:09 AM Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a

Re: recreating a create database file

Ruth, If you have the DataBee tool (available free ) http://www.cool-tools.co.uk You can take an export and then the commands are available to recreate your tables and tablespaces. Ron [EMAIL PROTECTED] 06/17/03 10:59AM Do you need the CREATE DATABASE ... script or the scripts to create all

RE: recreating a create database file

Well ... here is some generic stuff for you to edit. This is from 8.1.x, but I think it will still (with an edit or two) get you a running database in 9.2.x connect / as sysdba startup nomount create database CRCT2 maxinstances 8 maxlogfiles 32 character set US7ASCII datafile

Re: AW: RedHat AS Dev edition

Just musing but... Are'nt Oracle and Red Hat missing a great opportunity here on building more momentum for Oracle on Linux especially RAC? Why charge anything for the Dev of AS edtition? Missed opportunities... mohammed --- Kulev, Milen [EMAIL PROTECTED] wrote: Thanks for the answer

Re: RMAN FILESPERSET

You have the maxpiecesize set to 2048. It will fill the backup piece and then start another. Have the datafile sized changed alot from one day to the next? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 6:25 PM I'm

AW: JDBC and MTS

Hi Mladen We started evaluating MTS and JDBC Thin Driver (newest version for JDK 1.4, running on Win2k against a test db on win2k, test db is oracle 9.2.0.3.0). I never used SRVR=DEDICATED. I have a dispatcher running on port 5000 and a listener on port 1521. The only thing I do to direct the

RE: recreating a create database file

Thanks Ron :) Mark Cool-Tools -Original Message- Ron Rogers Sent: 17 June 2003 17:10 To: Multiple recipients of list ORACLE-L Ruth, If you have the DataBee tool (available free ) http://www.cool-tools.co.uk You can take an export and then the commands are available to recreate your

RE: JDBC and MTS

b) I use server=dedicated, is srvr=dedicate a short hand version of it? -Original Message- Sent: Tuesday, June 17, 2003 8:25 AM To: Multiple recipients of list ORACLE-L OK. Let me get some things straight: a) I'm not a developer. I'm one of those vile creatures called DBAs. I don't

AW: JDBC and MTS

Hi Regis That's basically right. As I just posted, we use MTS for development, so that not every developer starts up a local connection pool on their workstation and we also don't end up with too many dedicated server processes. But I think you're right saying that MTS and application side

RE: recreating a create database file

I have it at home. It's a modified version of the script in Orac_Dba, concocted by Jared Still and Andy Duncan. You can get the script from CPAN and I'll send you my version when I get home. I've even sent it to Jared and Andy, but I don't have time to maintain Orac_Dba right now. May be Jared

RE: recreating a create database file

Not sure if this was already mentioned. You can hack up the result of this: alter database backup controlfile to trace; into an exact replica of the create database statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 17 Jun 2003, Jack van Zanen wrote: Maybe not exactly

AW: RedHat AS Dev edition still available today THANK YOU Ron !

To Ron: Ron, your last link works !!! RH AS Dev Edition is already by me. Thank you very, VERY much for the help! BTW, according to one of the official RedHat resellers in Germany, Dev Edition was not avialable anymore (?! I haven't posted them the link yet;) ), because there were too many

RE: asking your opinion

If this is to be a web server kind of application then another possibility to consider: Transparent Application Failover (TAF) I think this works well with web applications where the data in the database(s) isn't constantly changing at a high rate. You have two or more independent databases

Anyone using EMC Clarion Cx400 in a RAC environment?

Looking at purchasing an EMCClarion Cx400 for our 2 Sun Fire 280R Solaris 9 machines. Wondering if anyone is currently using this Storage system and how it performs. Any outstanding issues/concerns we should know about. Did your system admin attend a class on taking care of this storage solution?

Re: AW: RedHat AS Dev edition still available today

Milen, The offer is still available at https://rhn.redhat.com/network/sales/index.pxt you must have a RedHat network login, Easy to get on line. Ron [EMAIL PROTECTED] 06/16/03 06:39PM Thanks for the answer Ron, the problem is that I don't see Dev Edition listed anymore ;(. I dont't know

Compare Schema with data

List, Is any body know any tools for comparing two schema for only data comparison create script for the result, I have two schema want to find out what's the difference exists as data point of view, I know TOAD can generate comparison script BUT I am interesting In data comparison, any URL or

RE: JDBC and MTS

I recall an old bug where MTS would sleep for a bit - don't recall the bug anymore. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 [EMAIL PROTECTED] 6/17/03 12:35:20 PM b) I use server=dedicated, is

Oracle releases by the different platforms...

Title: IOUG Live 2003 does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example, SUN,IBM,HP,LINUX? SUN,HP?etc,etc Thanks in advance!! Greg

Re: asking your opinion

This application will need to tie into Sun one portal, the key items are web central to provide unit to create content, change pages..etc undergrades site for class registration, staff pages do other stuff. Joan Stephen Lee wrote: If this is to be a web server kind of application then another

RE: Compare Schema with data

I think DB Artisan Change Manager will do it. -Original Message- Is any body know any tools for comparing two schema for only data comparison create script for the result -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

MySQL in the future?

WILL OPEN-SOURCE THREATEN ORACLE, IBM AND MS? | Internet News How big of a threat are open-source databases to software giants like Oracle, who hold most of the market and revenue share today? MySQL could be the biggest challenger to Oracle, and even Microsoft and IBM in the database market. MySQL

Re: Compare Schema with data

Is any body know any tools for comparing two schema for only data comparison create script for the result Isn't Change Mangement Pack in OEM able to do this? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson INET: [EMAIL PROTECTED]

RE: recreating a create database file

Tom, Yes the trace file is a good idea for scripting the database ut it does not create any of the tables and other options available in Oracle. You will still need all of your scripts or other package to completely recreate your database. That is if the interpretation of a database is more than

Re: OEM question

Lisa, Congrats on the flawless upgrade. As I understand your statement about OEM you are correct. But you can place the OEM repository on any old server, like the development one or Linux and then run the OEM using it. Of course there is the issues of licensing if you use your play station

RE: asking your opinion

The TAF thing was just another option to consider. I think it works best when you have a web app over here and databases over there and over there etc. Sqlnet handles the dirty work of connection and failover management. And *YOU* handle the dirty work of data management between the multiple

RE: Compare Schema with data

TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run sdiff -s between the files in order to get the differences. Yes, it's a bit manual, but the price is right (ours was $350/copy back in the 1900s). You can

8i OCP Question

Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level

RE: Compare Schema with data

Potentially (I've only tested it for meta data changes and it had a few issues), if you're up to paying $1000s for it. It's list is $3K/CPU or $60/named user of the DBs you'll be monitoring. What a joke! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: Anyone using IBM's FastT900 SAN for Oracle DBs?

Rich, There are two big issues with backup of an OLTP VLDB such as an ERP database: Backup window, and redo generation during hot backup mode. Disk I/O and network degradation during backup are also issues, albeit to a lesser extent. While RMAN would obviate the redo generation part, your backup

RE: JDBC and MTS

The bug Jeffrey is referring to is supposedly fixed in 8.1.7 (but I've seen metalink posts that suggest otherwise). The bug numbers are 1304130 and 1309641 - the dispatcher goes to sleep occasionally for 60 seconds before waking up and servicing requests again... Alan Aschenbrenner Oracle DBA

RE: 8i OCP Question

Jay, the answer is B is the funny word there really is supports. C is the the predecessor to Rman - and it only works in Oracle version 7. A and D are just plain false. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple

RE: Compare Schema with data

I think that's a good way to do it but I would use the Compare files of TOAD which is much nicer to look at than sdiff. At 11:04 2003-06-17 -0800, you wrote: TOAD v7.5 will allow you to export INSERT statements of all the data in a table. I've FTP'd these INSERT statements to a Unix box to run

Re: Oracle releases by the different platforms...

Greg, The pattern with 9i was Solaris and HP-UX first, Windows next (seemed to be delayed several months), then Linux. Dan Fink Loughmiller, Greg wrote: does anyone have a reasonable idea about which Hardware platforms and their order that Oracle releases the RDBMS??? For example,

Resend: Anyone using IBM's FastT900 SAN for Oracle DBs?

/** Resending, as I fat-fingered the previous one :( **/ Rich, There are two big issues with backup of an OLTP VLDB such as an ERP database: Backup window, and redo generation during hot backup mode. Disk I/O and network degradation during backup are also issues, albeit to a lesser extent. While

Re: asking your opinion

Thanks Robert, Malden and stephen. I am just wondering does master replication is an option too? As I mentioned earlier, the application is sun one portal, content based. Joan Freeman Robert - IL wrote: See comments below RF Robert G. Freeman Consultant - TUSC www.tusc.com One

RE: 8i OCP Question

The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L

RE: recreating a create database file

Ron, I read Ruth's original message meaning that she had to re-create the database structures. Of course you are correct if she meant the schema objects also. I just liked Jeremiah's thinking - this is an excellent quick way of creating the create database script to re-create all of the

Re: 8i OCP Question

B ). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:44 PM Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a

Passing array as input to procedure from sqlplus-HELP

Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPID IN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33);

Re: RE: 8i OCP Question

are these the questions you buy from oracle corporation? or from some outside vendor? if so who? I wont get those. If its from oracle, that is troubling... since the test might be wrong also. From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/06/17 Tue PM 04:20:10 EDT To: Multiple

Re: 8i OCP Question

Hi And answer D is not correct since Rman works fine without a tape subsystem, by writing to Disk :-) Gary W. Parker wrote: The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with

ora-1031

I have 3 triggers that are giving an ora-1031, below is an example: ON AUTH_ADDTL_INFO * ERROR at line 16: ORA-01031: insufficient privileges The same schema owns the tables and the triggers. Let me repeat, the tables exist and are owned by the same schema as the triggers. I can

RE: 8i OCP Question

Title: RE: 8i OCP Question Jay, I disagree. Go to (you may have to paste the link back together) http://www.znow.com/sales/oracle/server.816/a76990/rmanconc.htm#424437 And scroll down to the first NOTE: It tells you right there that RMAN is not compatible with EBU. I'm assuming your

RE: 8i OCP Question

B is the correct answer. Incremental backups are supported in archivelog and noarchivelog mode. Rman does not require a recovery catalog. RMAN is not compatible with EBU RMAN works just fine to disk. Robert Oracle9i RMAN Backup and Recovery Freeman -Original Message- To: Multiple

RE: asking your opinion

CAVEAT: With all the banging around Oracle has done with replication, I think my knowledge of replication is quickly getting outdated. Keeping that in mind: In my limited experience with simple snapshot replication, about the only time you run into difficulties is when you need to replicate at

RE: Compare Schema with data

Hi Louis, That sounds cool, but where can you compare table data in TOAD? The only options I see (TOAD 7.5 registered and TOAD 7.5.3.28 BETA w/DBA module) are for the object definitions of schemas and not the data itself. Rich Rich Jesse System/Database Administrator

RE: Passing array as input to procedure from sqlplus-HELP

Title: RE: Passing array as input to procedure from sqlplus-HELP exec testproc(pid_varray(1,2,3,4,5)); Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal.

RE: MySQL in the future?

I haven't really used either in-depth, but the features of PostrgeSQL http://advocacy.postgresql.org/advantages/ seem to be a lot closer to Enterprise than MySQL 4.x, IMHO. Then again, I'm an Oracle bigot -- for now. :) Rich Rich Jesse System/Database Administrator

RE: recreating a create database file

popping my head out the window... Here is the create script I just did for 9i [createdb.sql] spool DB_DESTINATION\admin\INSTANCE\create\CreateDB.log set echo on connect SYS/PASSWORD as SYSDBA startup nomount pfile=DB_DESTINATION\admin\INSTANCE\pfile\initINSTANCE.ora; -- build the db CREATE

Re: RE: 8i OCP Question

This is from an outside vendor, usually they are good but I can't seem to figure this one out. I know that you can allocate a channel to disk on a NoArchiveLog mode database through Rman. Also, only full backups (offline) can be taken if the db is in NoArchiveLog mode. The only thing that I

RE: ora-1031

Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that out for an explicitly specified datatype for l_active_trigger, does it make any difference? Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, June 17,

RE: 8i OCP Question

Does that apply to 8i databases as well? From: Freeman Robert - IL [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Date: Tue, 17 Jun 2003 13:24:41 -0800 B is the correct answer. Incremental backups are supported

RE: Oracle releases by the different platforms...

And then OpenVMS. sigh And MTS *still* doesn't work there... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, June

RE: RedHat AS Dev edition still available today THANK YOU Ron !

Maybe Redhat was overwhelmed by the demand? Patrice. -Original Message- Sent: Tuesday, June 17, 2003 1:59 PM To: Multiple recipients of list ORACLE-L To Ron: Ron, your last link works !!! RH AS Dev Edition is already by me. Thank you very, VERY much for the help! BTW, according to one

RE: Anyone using IBM's FastT900 SAN for Oracle DBs?

Thanks John, but I already know the generic issues with Oracle DB backup on SAN. That's why I was asking specifically about the FastT900. After some research, I've found out that there is an option called FlashCopy, which appears to be different than the third mirror approach, but am having a

RE: ora-1031

Yes, it does. I just double checked that. David Ehresmann. -Original Message- Sent: Tuesday, June 17, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that out for an explicitly specified datatype for

Passing array as input to procedure from sqlplus-HELP

Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How can I pass array value from sql*plus Procedure testproc(iarrPID IN PID_VArray). I want to test it this way SQLExec testproc(?) Tried this was SQLEXEC testproc(33);

sequential waits -- how to proceed

Hello ALL, Oracle ver is 9.2 running on EMC array. I am executing a pl/sql procedure which does an update on a fact table. There is an unique index on the fact, with clearly shows up in the explain plan for udapte. I ran 10046 event for a 18 min duration during this update process and

Re: Passing array as input to procedure from sqlplus-HELP

You will have to write an anonymous block that declares the array variable, and passes that array to your procedure under test. --- Basavaraja, Ravindra [EMAIL PROTECTED] wrote: Hi All, I want to test a procedure that accepts an array as input.I want to test this script from SQL*PLUS.How

Re: Anyone using EMC Clarion Cx400 in a RAC environment?

I can't speak for Clariion on Sun, but I support Win2K/Oracle 8.1.7on aClariion fc4700 and Sym 8530. The sym has been great. The Clariion is pretty good, but is a bit slower than the sym. It's much easier to manage though. It hasn't quite lived up the promise of being able to upgrade it

RE: MySQL in the future? (OT)

In that article, unless I missed it, they didn't mention the deal between SAP and MySQL. SAP, MySQL Sign Open-Source Database Deal (By MARC L. SONGINI, JUNE 02, 2003, Computerworld) SAP AG last week said it plans to hand off lead development of its SAP DB database software to MySQL AB and work

RE: Anyone using EMC Clarion Cx400 in a RAC environment?

Hi, One incident (first year or usage) the fiber card driver crash and zombie processes occur. IO hang, database down. DB cannot fail over to standby server, primary server cannot shutdown, shutdown abort can't help, physically power off server is require. I don't think is the EMC

is it SP2 or SP3 -- 9iR2 on Win2K ?

Dear All, I need to install 9iR2 on Win2K Server. Is it SP2 or SP3 ? metalink docs say that SP1 or higher is OK. but still found some queries posted on metalink regarding SP3 9iR2. #$##$ ...confused :-| !*#$$ any serious issues known already ?! TIA. Jp. -- Please see the official

Re: Compare Schema with data

The below links are pretty good for compare tools. I recommend dbdiff, it seems to be pretty complete. http://www.torry.net/tools_dbcompare.htm http://www.dkgadvancedsolutions.com/dbdiff.htm - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday,

Re: sequential waits -- how to proceed

Your pl/sql procedure is obviously doing a sql per row updated rather than a set update. Unless you change the procedure you can expect only marginal improvement from any other measure. At 03:29 PM 6/17/2003 -0800, you wrote: Hello ALL, Oracle ver is 9.2 running on EMC array. I am executing

system_call

Hello list, I was wondering if someone out there can help me. I'm trying to use the system_call external procedure. It's running fine on my development box, but it was there before my time. What do I need to do to get it running on my test server? or any server for that matter. TIA, M. Bryan

Re: exchange partition in 9.2

Are you using UPDATE GLOBAL INDEXES clause in the ALTER TABLE EXCHANGE PARTITION? This causes significant IO. Try tracing the session using 10046 trace and see exactly what statements are being issued. ALTER SESSION SET EVENTS '10046 trace name context forever, level 8'; ALTER TABLE EXCHANGE

Re: How to stop script

Thanks! That's exactly what I need! Jin Quoting Pete Finnigan [EMAIL PROTECTED]: Hi You can stop the script by using the line whenever sqlerror exit rollback and then generating an error by using an exception in a PL/SQL block as follows: oracle:jupiter cat imp.sql whenever

Re: sequential waits -- how to proceed

Thanks for your reply ... I understand that it is a sql per row update but the same update on UAT environment works at a rate of about 2000 rows per sec. Though the data volume is definetly less compared to PROD, still there is night and day difference between prod and uat..In terms of the

Re: sequential waits -- how to proceed

Does the UAT have the same data volume, same nr of rows and blocks in the table being updated? At 08:49 PM 6/17/2003 -0800, you wrote: Thanks for your reply ... I understand that it is a sql per row update but the same update on UAT environment works at a rate of about 2000 rows per sec. Though

Oracle RDBMS for Win XP

Hi all, Do you install Oracle RDBMS (maybe personal edition) with Win XP? Will that work? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,